Chapter 1
SQL Foundations
IN THIS CHAPTER
Relating SQL to the relational model
Figuring out functional dependencies
Discovering keys, views, users, privileges, schemas, and catalogs
Checking out connections, sessions, and transactions
Understanding routines and paths
This chapter offers a brief introduction to the (somewhat complicated) relationship between SQL and the relational database model. The chapter highlights how certain important terms and concepts may have slightly different meanings in the (practical) SQL world as opposed to the (theoretical) relational database world. The chapter also provides some general, all-inclusive definitions for good measure.
SQL and the Relational Model
SQL is a software tool designed to deal with relational database data. It does far more than just execute queries. Yes, of course, you can use it to retrieve the data you want from a database using a query. However, you can also use SQL to create and destroy databases, as well as modify their ...
Get Data Analytics & Visualization All-in-One For Dummies 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.
