Materials
Textbooks/Materials
There is no single textbook for this class. Instead, the material will be drawn from various texts and sources. For a general book that aligns with the course level, I recommend:
Other books which might be useful for some parts of the course are:
- Database Concepts by David M. Kroenke, David J. Auer, Scott L. Vandenberg, and Robert C. Yoder, 9th Edition, 2020.
- Database Principles: Fundamentals of Design, Implementation, and Management by Carlos Coronel, Steven Morris, Keeley Crockett, and Craig Blewett, Cengage, 3th Edition, 2020.
- Concepts of Database Management by Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, and Philip J. Pratt, Cengage Learning, 2020.
- Grokking Relational Database Design by Dr. Qiang Hao and Dr. Michael Tsikerdekis, No Starch Press, 2024.
- Practical SQL: A Beginner’s Guide to Storytelling with Data by Anthony DeBarros, No Starch Press, 2nd Edition, 2022.
- SQL for Data Science: Data Cleaning, Wrangling and Analytics with Relational Databases by Antonio Badia, Springer Nature Switzerland AG, 2020.
- SQL for Data Scientists: A Beginner’s Guide for Building Datasets for Analysis by Renée M. P. Teate, Wiley, 2021.
- SQL for Data Analytics: Perform Fast and Efficient Data Analysis with the Power of SQL by Upom Malik, Matt Goldwasser, and Benjamin Johnston, Packt Publishing, 2019.
- Learn PostgreSQL: Build and Manage High-Performance Database Solutions Using PostgreSQL 12 and 13 by Luca Ferrari and Enrico Pirozzi, Packt Publishing, 2020.
- SQL Cookbook: Query Solutions and Techniques for All SQL Users by Anthony Molinaro and Robert de Graaf, O’Reilly Media, 2020.
- Mastering MongoDB 6.x: Expert Techniques to Run High-Volume and Fault-Tolerant Database Solutions Using MongoDB 6.x, 3rd Edition by Alex Giamas, Packt Publishing, 2022.
Lecture notes, homework assignments and their solutions, and other supplementary materials will be made available on this website throughout the course.
Online Editor
Cheat Sheet
SQL & Data Interview Questions
SQL Projects for Beginners with Solutions and Explanation
Online resources related to PostgreSQL
- PostgreSQL vs SQL Server (MSSQL): Detailed Comparison
- PostgreSQL Tutorial
- Tutorials Point PostgreSQL
- Understanding Postgres Full Text Search: 10 Critical Aspects
- PostgreSQL Query Optimization: 10 Best Tricks & Techniques (Explained with Code)
- Top 10 PostgreSQL Extensions (With Code + Example)
- PostgreSQL SELECT Statement: Syntax, Parameters & Examples
- How to Use the PostgreSQL UNION & UNION ALL Operators: Easy Steps and Examples Explained
- Working with PostgreSQL Subquery
- Build your first REST API with Flask and PostgreSQL
- Making a Flask app using a PostgreSQL database
- Flask Postgres basic setup
Online resources related to Relational Algebra
Online resources related to NoSQL
Online resources to learn DuckDB
Online resources to learn Pandas
Online resources related to Database Management Systems