Skip to content
O'Reilly home
Operators and Functions
Working with Dates and Times
Mixing AND and OR
Operators and Functions
Working with Dates and Times
Mixing AND and OR

SQL Fundamentals—SQL for Data Analysis and Database Design

By Thomas Nield
    1. Introduction
      2m 10s
    1. Module 1 Overview
      52s
    2. Why Learn SQL?
      1 page
    3. Databases
      6 pages
    4. What Are Databases?
      7m 42s
    5. What Is SQL and NoSQL
      3m 57s
    6. SQLite
      9 pages
    7. Setting Up SQLite
      4m 15s
    8. Module 1 Summary
      32s
    1. Module 2 Overview
      41s
    2. SELECT
      9 pages
    3. Using SELECT to Retrieve Data
      3m 4s
    4. Calculating Fields with Expressions
      6m 47s
    5. Module 2 Summary
      44s
    1. Module 3 Overview
      45s
    2. WHERE
      11 pages
    3. Filtering Numbers with WHERE
      6m 13s
    4. Filtering Text with WHERE
      4m 46s
    5. Filtering Booleans and Nulls with WHERE
      7m 28s
    6. Operators and Functions
      8 pages
    7. Taken from
      SQL Fundamentals
      By
      Thomas Nield
      Published by
      O'Reilly Media, Inc., 2019
    8. Mixing AND and OR
      2m 54s
    9. Module 3 Summary
      38s
    1. Module 4 Overview
      35s
    2. GROUP BY and ORDER BY
      9 pages
    3. Using COUNT, GROUP BY, and ORDER BY
      5m 28s
    4. SUM, MIN, MAX, and AVG
      5m 55s
    5. Filtering Aggregate Values with HAVING
      2m 21s
    6. Module 4 Summary
      40s
    1. Module 5 Overview
      57s
    2. CASE Statements
      6 pages
    3. The CASE Expression
      4m 48s
    4. The Zero/Null Case Trick
      5m 22s
    5. Module 5 Summary
      35s
    1. Checkpoint
      38s
    1. Module 6 Overview
      42s
    2. JOIN
      14 pages
    3. INNER JOIN
      7m 58s
    4. LEFT OUTER JOIN
      6m
    5. Joining Multiple Tables and Joining with GROUP BY
      6m 27s
    6. Module 6 Summary
      52s
    1. Module 7 Overview
      52s
    2. Thinking about Database Design
      8m 33s
    3. Creating and Dropping Tables
      7m 18s
    4. Creating and Dropping Views
      2m 43s
    5. Database Design
      27 pages
    6. Module 7 Summary
      32s
    1. Module 8 Overview
      42s
    2. Managing Data
      6 pages
    3. Creating Records with INSERT
      4m 9s
    4. Testing Foreign Key Constraints
      2m 26s
    5. Updating and Deleting Records
      4m 14s
    6. Transactions
      3m 17s
    7. Using an Index
      4m 6s
    8. Improving Performance with Indexes and Transactions
      6 pages
    1. Going Forward
      2m 6s