- Shopping Bag ( 0 items )
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 ...
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.
|Ch. 1||Introduction to SQL||7|
|Ch. 2||Entering information||41|
|Ch. 3||Extracting information||53|
|Ch. 4||Advanced database design||117|
|Ch. 5||Manipulating data||157|
|Ch. 6||Grouping and aggregating data||189|
|Ch. 7||Selecting data from different tables||207|
|Ch. 8||Queries within queries||235|
|Ch. 9||Advanced queries||263|
|Ch. 12||SQL security||327|
|Ch. 13||Database tuning||349|
|App||Setting up and using the five database systems||391|