- Cover
- Introduction
- Part 1: Getting Started with SQL
- Part 2: Using SQL to Build Databases
- Part 3: Storing and Retrieving Data
- Chapter 6: Manipulating Database Data
- Chapter 7: Handling Temporal Data
- Chapter 8: Specifying Values
- Chapter 9: Using Advanced SQL Value Expressions
- Chapter 10: Zeroing In on the Data You Want
- Chapter 11: Using Relational Operators
- Chapter 12: Delving Deep with Nested Queries
- Chapter 13: Recursive Queries
- Part 4: Controlling Operations
- Part 5: Taking SQL to the Real World
- Part 6: Advanced Topics
- Part 7: The Parts of Tens
- Chapter 24: Ten Common Mistakes
- Assuming That Your Clients Know What They Need
- Ignoring Project Scope
- Considering Only Technical Factors
- Not Asking for Client Feedback
- Always Using Your Favorite Development Environment
- Using Your Favorite System Architecture Exclusively
- Designing Database Tables in Isolation
- Neglecting Design Reviews
- Skipping Beta Testing
- Not Documenting Your Process
- Chapter 25: Ten Retrieval Tips
- Verify the Database Structure
- Try Queries on a Test Database
- Double-Check Queries That Include Joins
- Triple-Check Queries with Subselects
- Summarize Data with GROUP BY
- Watch GROUP BY Clause Restrictions
- Use Parentheses with AND, OR, and NOT
- Control Retrieval Privileges
- Back Up Your Databases Regularly
- Handle Error Conditions Gracefully
- Chapter 24: Ten Common Mistakes
- Appendix: ISO/IEC SQL: 2016 Reserved Words
- Index
- About the Author
- Connect with Dummies
- End User License Agreement
Part 6
Advanced Topics
IN THIS PART …
Creating cursors
Building compound statements
Handling errors
Applying triggers
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.