Dimensions
181 x 231 x 42mm
Authors include: Ryan Stephens, Ron Plew and Arie D. Jones.
The complete hands-on tutorial for writing SQL queries with any database - get up and running in just an hour a day!
Thoroughly revised for the latest version of SQL and today's most effective SQL techniques.
Covers SQL-related database design, data manipulation, database administration, security, and programming - including chapters on Oracle SQL*Plus, Oracle PL/SQL, Transact-SQL, and MySQL.
A complete tutorial package: step-by-step instructions, quizzes, exercises, tips, shortcuts, and more.
In just one hour a day or less, this book will help readers start using the SQL query language to access the data they need to solve real-world business problems. Friendly, accessible, and complete, it covers everything readers need to know to use SQL with any database, whether they have previous database experience or not.Using realistic, hands-on examples, readers will learn how to write basic queries... design better databases... use SQL in database administration... optimize SQL statements to run faster... work with data dictionaries, tables, triggers, and cursors... create and debug complex SQL statements... embed SQL in other software, and more. This book also contains additional chapters on using SQL in Oracle SQL*Plus, Oracle PL/SQL, Transact-SQL, and MySQL environments. This edition has been fully revised and refined to reflect the latest SQL practices and techniques. All syntax has been updated for the ANSI SQL 2003 Standard and 2006 XML extensions, and this edition contains far more advanced coverage, including XML, stored procedures, and windowed table functions. Throughout, step-by-step instructions walk readers through their most common questions, issues, and tasks...Quizzes and Exercises help them test their knowledge... 'Did You Know?' tips offer insider advice and shortcuts... and 'Watch Out!' alerts help them avoid problems.