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.
David Olsen has been an educator since 1993. He received his Ph.D. in Management Information Systems from The University of Arizona in 1993 and taught at The University of Akron accounting department in accounting information systems for five years.
His research interests include database concurrency control and modeling, accounting information systems, and the integration of SQL with other useful tools like XML, SSIS, SSRS, PYTHON, EXCEL, and TABLEAU. David has been published in journals such as Communications of the ACM, Issues in Accounting Education, and the Journal of Database Management; he has published research with many different graduate students over the years. Professionally, Dr. Olsen’s favorite accomplishments are the teaching awards he has received. His favorite conversation is with student that tells him, “Dr. Olsen, I got a job.”
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 _
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 _