Learn SQL databases in a weekend

Course Curriculum

Chapter 1: The WHY: Introduction and motivation

Lecture 1: Why learn SQL?

Lecture 2: What jobs can I get?

Lecture 3: What is SQL?

Lecture 4: Why learn SQL when we have ORM (Object-relational-mapping)?

Lecture 5: Conclusion – SQL is a long-term skill

Chapter 2: Fundamentals

Lecture 1: Content overview

Lecture 2: Architecture

Lecture 3: Steps to access an SQL database

Lecture 4: Data, facts and information

Lecture 5: Data in databases

Lecture 6: Tables

Lecture 7: Relations between tables

Lecture 8: Database access – establishing a connection

Lecture 9: Connection examples in Java, Python, PHP

Lecture 10: Can I access SQL in websites (Javascript)?

Lecture 11: Sending queries and statements

Lecture 12: Statement and query examples

Lecture 13: Summary

Lecture 14: Note on plural and singular table names

Chapter 3: Getting started

Lecture 1: How to choose an SQL engine?

Lecture 2: Why MySQL?

Lecture 3: How to install MySQL?

Lecture 4: Installing MySQL on Windows

Lecture 5: Installing MySQL on macOS and Linux

Lecture 6: Database administration and exploration tools

Lecture 7: Installing DBeaver

Lecture 8: Installing DBeaver on Mac

Lecture 9: First look at DBeaver

Lecture 10: Opening our MySQL database

Lecture 11: Typical way of fixing weird errors

Lecture 12: Running queries in DBeaver

Chapter 4: Creating tables

Lecture 1: Creating a database

Lecture 2: Column types

Lecture 3: Side note – storing pictures

Lecture 4: Primary key (unique identifier)

Lecture 5: Business case introduction

Lecture 6: CREATE TABLE syntax

Lecture 7: Enclosing names in `backticks`

Lecture 8: CREATE TABLE example

Lecture 9: Exercise – CREATE TABLE

Lecture 10: Exercise solution – CREATE TABLE

Chapter 5: Altering and dropping tables

Lecture 1: ALTER TABLE

Lecture 2: Exercise – ALTER TABLE

Lecture 3: Exercise solution – ALTER TABLE

Lecture 4: DROP TABLE

Chapter 6: Database export and import

Lecture 1: Exporting and importing

Lecture 2: Creating a database dump (exporting)

Lecture 3: Exercise – Import a DB dump

Lecture 4: Exercise solution – importing a DB dump

Chapter 7: Inserting data

Lecture 1: Inserting data into tables

Lecture 2: INSERT statement

Lecture 3: Example: INSERT a store

Lecture 4: Exercise – INSERT employees

Lecture 5: Exercise solution

Lecture 6: DEFAULT values

Lecture 7: Create product table

Lecture 8: Examples: INSERTs with default values

Lecture 9: Expressions and functions as default values

Lecture 10: Exercise – extend product table, INSERT data

Lecture 11: Exercise solution

Chapter 8: SELECT queries

Lecture 1: Selecting data, SELECT statement

Lecture 2: Selecting all data with *

Lecture 3: Selecting specific fields

Lecture 4: Using expressions in SELECT

Lecture 5: Renaming result columns with aliases

Lecture 6: Using functions

Lecture 7: Let's insert more data!

Lecture 8: Conditions with WHERE clause

Lecture 9: Combining conditions with logical operators

Lecture 10: Operator precedence

Lecture 11: Substring search

Lecture 12: Ordering with ORDER BY

Lecture 13: LIMIT the number of returned rows