LESSON 14Controlling Transactions
You have spent the last 13 lessons learning virtually everything that you can do with data within a relational database. For example, you know how to use the SQL SELECT
statement to retrieve data from one or more tables based on a number of conditions supplied by the user. You have also had a chance to use data-modification statements such as INSERT
, UPDATE
, and DELETE
. At this point, you have become an intermediate level SQL and database user. If required, you could build a database with its associated tables, each of which would contain several fields of different data types. Using proper design techniques, you could leverage the information contained within this database into a powerful application.
If you ...
Get Sams Teach Yourself SQL in One Hour a Day, Fifth 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.