Summary
This chapter has brought the discussion of generic SQL closer to the real world by touching on topics such as
Data Security
Transactions
Performance
Data Integrity
We will not explore these issues further as relational database management systems differ widely from each other in their implementations of backup and recovery tools, transaction control, and access strategies.
The next chapter pulls together many of the SQL statements you have learned so far, presenting more complex pieces of code. It also introduces functions and gives examples of nesting functions inside one another.
Get Practical SQL Handbook, The: Using SQL Variants, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
