SQL: A Complete Reference

0.0

It starts from scratch, prepares the reader for SQL by introducing concepts of data, database management, relational databases and data modeling. Highlights: It describes the newest and official version - Database Language SQL: 1992 - informally known as SQL/92 or SQL 2 ; Numerous solved examples and exercises. ; Quick reference of SQL commands, listed alphabetically with examples; Frequently asked interview questions (FAQs) are also included. Table of Contents 1. Introduction to Database Management Systems 2. Relational Database Management Systems (RDBMS) 3. Database Design 4. Data Normalization 5. A Practical Approach to Database Design 6. Introduction to Structured Query Language (SQL) 7. SQL Language Levels 8. SQL Data Types and Literals 9. SQL Operators 10. Types of SQL Commands 11. Tables 12. Indexes 13. Views 14. Nulls 15. Aggregate Functions 16. The SELECT Statement 17. Subqueries 18. INSERT, UPDATE and DELETE Operations 19. JOINs 20. UNIONs 21. Data Security 22. Data Integrity 23. Data Concurrency 24. Triggers 25. Backup & Recovery 26. Numeric and Text Data in SQL 27. Dealing with Dates 28. Synonyms 29. Snapshots 30. Programming with SQL 31. Embedded SQL 32. Dynamic SQL 34. Exception Handling 35. SQL Tips & Tricks 36. The System Catalog 37. Binding Styles