Examples in book that may not work with some databases
Some readers have purchased this book with the expectation that all examples in the book will work with all implementations of SQL. This book does not completely cover any particular vendor of SQL, but covers ANSI SQL. ANSI SQL is a standard and not a database itself. Please note that some implementations of SQL are not completely ANSI compliant. In this book, we have shown the ANSI (standard) syntax of code, and have shown examples from various implementations of SQL. The majority of the examples have been performed using Oracle since Oracle is mostly ANSI compliant, and since Oracle is the most popular relational database. If you are using an implementation that does not comply with standard SQL, some of the examples may not work.
Sams Teach Yourself SQL in 21 Days Third Edition Take your skills to the next level In just 21 days, youll have all the skills you need to begin programming with SQL quickly and easily. With this complete tutorial, youll master the basics and then move on to the more advanced features and concepts.
Understand the fundamentals of SQL programming
Master all the new and advanced features SQL offers
Learn how to effectively use the latest tools and features by following practical, real-world examples
Get expert tips from leading authorities on implementing SQL in the corporate environment
Completely updated and revised, this book is designed for the way you learn. Go chapter by chapter through the step-by-step lessons or just choose those lessons that interest you the most.
Ryan K. Stephens is the president and CEO of Perpetual Technologies, Inc. Most of Ryans time is spent in Oracle database administration, Oracle training, and developing training materials. Ryan has more than 10 years experience with Oracle development, Oracle administration, and UNIX. He is an Oracle Certified Professional and is an adjunct professor for Indiana University-Purdue University in Indianapolis. He also serves part time as an Oracle programmer for the Indiana National Guard. Ronald R. Plew is owner and vice-president of Perpetual Technologies, Inc., and is an adjunct professor with Indiana University-Purdue University in Indianapolis, where he teaches various SQL, UNIX, and Oracle database classes. An Oracle Certified Professional, Ronald is an Oracle/SQL programmer for the Indiana National Guard.
oLearn to create and maintain your own SQL tables
oExplore the fundamentals of retrieving data with SQL queries
oLearn essential SQL debugging techniques for troubleshooting your own SQL code oDiscover how to mold and shape your data with SQLs built-in functions
oTune your database using stored procedures and triggers
oEnhance your database security with tips from experienced database administrators oImprove your database performance by streamlining SQL statements and creating indexes
oWork through this editions seven bonus days to further enhance your SQL knowledge
oExplore new SQL territories by reviewing the SQL 3 standards
oGain an understanding of PL/SQL, Transact-SQL, and SQL*Plus
--This text refers to an out of print or unavailable edition of this title.