Data Analytics & Visualization All-in-One For Dummies
by Jack A. Hyman, Luca Massaron, Paul McFedries, John Paul Mueller, Lillian Pierson, Jonathan Reichental, Joseph Schmuller, Alan R. Simon, Allen G. Taylor
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 ...