In this course, Mike Dane will teach you database management basics and SQL.

The course starts off with Mike helping you install MySQL on Windows or Mac. Then he explores topics like schema design, Create-Read-Update-Delete operations (CRUD), and other database fundamentals.

If you've never studied databases or SQL before, this is a great starting point. It will cover:

  • What a database is
  • Tables and Keys
  • SQL Basics
  • MySQL Windows/Mac Installation
  • Creating Tables
  • Inserting Data
  • Constraints
  • Update & Delete
  • Basic Queries
  • Company Database Intro
  • Creating Company Database
  • More Basic Queries
  • Functions
  • Wildcards
  • Unions
  • Joins
  • Nested Queries
  • On Delete
  • Triggers
  • ER Diagrams