SQL works with databases to insert and extract data and is an international standard for manipulating data in databases. This hands-on resource covers everything from a review of SQL basics and database design to creating your own databases and using the SQL language in a variety of database applications.

    Packed with essential code, theories, concepts, and techniques, as well as a cache of useful examples, this comprehensive text will have you quickly designing your
own databases and writing SQL code sufficient for many
real-world situations. Practice exercises in each chapter
help speed up your comprehension. By the end of the
book, you'll be prepared to handle any surprise that SQL
might throw your way.

   This book is for programmers with some prior programming experience who are seeking to develop their database programming skills using SQL. The book assumes no previous programming experience, so it is also suitable for database programming beginners including database administrators.

Chapter 1 Introduction to SQL
Chapter 2 Entering information
Chapter 3 Extracting information
Chapter 4 Advanced database design
Chapter 5 Manipulating data
Chapter 6 Grouping and aggregating data
Chapter 7 Selecting data from different tables
Chapter 8 Queries within queries
Chapter 9 Advanced queries
Chapter 10 Views
Chapter 11 Transactions
Chapter 12 SQL security
Chapter 13 Database tuning
Appendix Setting up and using the five database systems