Sams Teach Yourself SQL in One Hour a Day
Publication date: May 2009
Digital Book format: PDF (Adobe DRM)
You save: $4.00 (10%)
This is the eBook version of the printed book. If the print book includes a CD-ROM, this content is not included within the eBook version.In just one hour a day or less, this book will help you 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 you need to know to use SQL with any database, whether you have previous database experience or not.Using realistic, hands-on examples, you 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 you through your most common questions, issues, and tasks...Quizzes and Exercises help you test your knowledge... "Did You Know?" tips offer insider advice and shortcuts... and "Watch Out!" alerts help you avoid problems.