Course curriculum

  • 1

    What is a Database?

    • Introduction

    • What is a Database?

    • Different Kinds of Data

    • Different Kinds of Databases

    • What is a DBMS?

    • The Relational Database Schema
  • 2

    Setting up your Work Environment

    • Downloading MySQL Workbench

    • Load a CSV file into MySQL Workbench

    • Explore MySQL Workbench and Run your First Query

    • CSV Files for Download
  • 3

    Intro to SQL

    • Intro to SQL and Syntax

    • Data Types

    • SELECT & FROM

    • Order of Operations: SELECT

    • Let's Practice 1!
  • 4

    Where & Comparison Operators

    • WHERE

    • Comparison Operators 1

    • Comparison Operators 2

    • Order of Operations: WHERE

    • Let's Practice 2!
  • 5

    Logical Operators

    • Logical Operators 1

    • Logical Operators 2

    • Logical Operators 3

    • Logical Operators 4

    • Let's Practice 3!
  • 6

    ORDER BY

    • ORDER BY

    • ORDER BY with WHERE

    • Let's Practice 4!