Book description
Taking readers through the basics of the language, right up to some more advanced topics, this book is a practical, hands-on resource and aims to keep the reader involved at all times
Focuses on the SQL standard and is loaded with detailed examples and code; each chapter includes practice exercises that readers can challenge themselves with before looking at the sample solutions in the appendix
Paul Wilton is a successful Wrox "Beginning" book author and is an ideal author to write for those who want a firm grasp of standard SQL before learning the details specific to a particular database product
SQL is an international standard for manipulating data in databases and is used by database programmers in all major database systems: Microsoft, IBM, Oracle, MySQL, and many others
Table of contents
- Copyright
- About the Authors
- Credits
- Acknowledgments
- Introduction
- 1. Introduction to SQL
- 2. Entering Information
- 3. Extracting Information
- 4. Advanced Database Design
- 5. Manipulating Data
- 6. Grouping and Aggregating Data
- 7. Selecting Data from Different Tables
- 8. Queries within Queries
- 9. Advanced Queries
- 10. Views
- 11. Transactions
- 12. SQL Security
- 13. Database Tuning
- A. Exercise Answers
- B. Setting Up and Using the Five Database Systems
- C. Initial Data Setup
Product information
- Title: Beginning SQL
- Author(s):
- Release date: March 2005
- Publisher(s): Wrox
- ISBN: 9780764577321
You might also like
book
SQL For Dummies®
See how SQL interfaces with today's environments Start building and using relational databases with SQL's newest …
video
SQL in Motion
See it. Do it. Learn it! SQL in Motion introduces the SQL database language through high-quality …
book
Beginning SQL Queries: From Novice to Professional, Second Edition
Get started on mastering the one language binding the entire database industry. That language is SQL, …
video
SQL: Beyond the Basics
In this SQL: Beyond the Basics training course, expert author Guy Vaccaro will dive deeper into …