|
SQL Demystified
There's no easier, faster, or more practical way to learn the really tough subjects. SQL Demystified explains how to use SQL (Structured Query Language) - the ubiquitous programming language for databases. Readers will learn to create database objects, add and retrieve data from a database, and modify existing data. This self-teaching guide comes
complete with key points, background information, quizzes at the end of each chapter, and even a final exam. Simple enough for beginners but challenging enough for advanced students, this is a lively and entertaining brush-up, introductory text, or classroom supplement.
Contents:
Chapter 1: Relational Database ConceptsChapter 2: SQL ConceptsChapter 3: Defining Database Objects Using SQLChapter 4: Retrieving Data Using Data Query Language (DQL)Chapter 5: Combining Data From Multiple TablesChapter 6: Advanced Query WritingChapter 7: Maintaining Data Using DMLChapter 8: Applying Security Controls Using Data DCLChapter 9: Preserving Database Integrity Using TransactionsChapter 10: Integrating SQL into ApplicationsChapter 11: SQL Performance Tuning ConsiderationsFINAL EXAMANSWERS TO QUIZZES AND FINAL EXAMINDEX
|
