SQL 101 Class 3 Spring 2023

An Overview of classes 1 and 2 followed by Class 3:

Class 1 – SQL definitions and Real World Examples
-Class overview, tool setup
-Data manipulation background, definitions, basics
-Examples and exercises with real-world data
Class 2 – Common SQL Clauses and Functions
-Practice common SQL clauses
-Practice using common aggregate functions
-Practice using comments for debugging or explaining code
-Learn SQL functions
-Practice writing subqueries
-Practice using SQL using examples
Class 3 – Creating Tables
-Create and delete databases
-Create and delete tables & views
-Create tables with constraints
-Add and delete table fields
-Add and delete table constraints
-Insert, Update, Delete data from tables
-Import data from SQL and CSV files