The ever-growing amount of data in the world is stored in some sort of database and the need for people in all areas is also growing.
There are a number of different types of databases and number of different ways that they are stored. The most common database model is the relational model and SQL is the language that accesses data in a relational database.
There are hundreds of SQL books that have been written but this one focuses on problem-solving. We give a gentle introduction of database terms and SQL components. Then we cover harder SQL concepts such as common table expressions, derived tables, and correlated subqueries.
The next section is a compilation of self-contained modules that are illustrative of real-world problems. Some of these modules have been published in academic journal articles such as the one on dynamic SQL and Benford‘s law. Students have frequently commented that building each of the modules was the thing that has helped them most in developing SQL problem-solving skills.
Chapters
Chapter 1 // Introduction to Databases _
Chapter 2 // SQL Foundations _
Chapter 3 // Entity Relationship (ER) Diagramming _
Chapter 4 // Intermediate SQL _
Chapter 5 // Intermediate SQL 2 _
Chapter 6 // Data Cleansing Using SQL _
Chapter 7 // Normalization _
Modules
Correlation Coefficients and Regression _
Building a List of Numbers _
Cast and Convert _
Indexes _
SQL Server Integration Services (SSIS) _
BenFord’s Law _
Retail Gasoline _
XML and JSON _