chapter 4Introduction to SQL
This chapter introduces SQL, which has become the universal language for relational databases in that nearly every DBMS in modern use supports it. The reason for this wide acceptance is clearly the time and effort that went into the development of language features and standards, making SQL highly portable across different RDBMS products.
CHAPTER OBJECTIVES
In this chapter, the reader should:
• Understand the history of SQL.
• Learn how to write Data Query Language (DQL) statements in SQL to select data from database tables and views.
• Learn how to write Data Manipulation Language (DML) statements in SQL to update data in database tables.
• Understand how transactions support concurrent database access.
• Learn how ...
Get Databases DeMYSTiFieD, 2nd Edition, 2nd 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.
