Module Learn SQL the Hard Way

An introductory course in the SQL programming data language.

Preface
This is a simple course that teaches you the basics of SQL.
Introduction: Haters Gonna Hate, Or Why You Still Need SQL
SQL is everywhere, and I'm not saying that because I want you to use it.
Exercise 0: The Setup
This book will use SQLite3(http://www.
Exercise 1: Creating Tables
In the introduction I said that you can do "Create Read Update Delete" operations to the data inside tables.
Exercise 2: Creating A Multi-Table Database
Creating one table isn't too useful.
Exercise 3: Inserting Data
You have a couple tables to work with, so now I'll have you put some data into them using the INSERT command: {{ ork.
Exercise 4: Insert Referential Data
In the last exercise you filled in some tables with people and pets.
Exercise 5: Selecting Data
Out of the CRUD matrix you only know "Create".
Exercise 6: Join Many Tables
Hopefully you're getting your head around selecting data out of tables.
Exercise 7: Deleting Data
This is the simplest exercise, but I want you to think for a second before typing the code in.
Exercise 8: Deleting Using Other Tables
Remember I said, "DELETE is like SELECT but it removes rows from the table.
Exercise 9: Updating Data
You now know the CRD parts of CRUD, and I just need to teach you the Update part to round out the core of SQL.
Exercise 10: Updating Complex Data
In the previous exercise you did a simple UPDATE that changed just one row.
Exercise 11: Replacing Data
I'm going to show you an alternative way to insert data which helps with atomic replacement of rows.
Exercise 12: Destroying And Altering Tables
You've already encountered DROP TABLE as a way to get rid of a table you've created.
Exercise 13: Migrating And Evolving Data
This exercise will have you apply some skills you've learned.
Exercise 14: Basic Transactions
Imagine if the SQL in your last exercise had an error half-way through its run and it aborted.
Exercise 15: GROUP BY And Counts
For this exercise we'll need a large dataset to demonstrate how to group rows by data in their columns.
Exercise 16: GROUP BY With Relations
For the rest of the book we will be using the `ex15.
Exercise 17: Dates, Times and ORDER BY
I'm going to tell you a little story about SQL and time.
Exercise 18: Aggregate Functions
In this exercise you'll learn the other "aggregate functions".
Exercise 19: Logic and Math Expressions
The SQLite3 language supports many more functions to handle math, string manipulation, grouping, types, and other features in the SQLite3 Core Functions(https://www.
Exercise 20: Inner and Outer Joins
You have been learning how to join (link) tables using simple equality (`person.
Exercise 21: Using Views
A VIEW is a fake table that is populated with the results of a SELECT query you write.
Exercise 22: Accessing SQLite3 from Python
Learn how to access a SQLite3 database from Python.
Exercise 23: Setting Up PostgreSQL
The final exercise in this book will teach you to setup a basic PostgreSQL database on your desktop machine.
Next Steps
You now know the very basic level of SQL.

Register for Learn SQL the Hard Way

Register today for the course and get the all currently available videos and lessons, plus all future modules for no extra charge.