Objects in MySQL

Course Overview

What is SQL

What is MySQL

Relational Databases

Udemy Basics

MySQL Installation Overview

Course Resources PDF + Lecture Downloads!

MySQL Installation on Mac OS

Adding the Countries Data

MySQL Workbench UI Overview

MySQL Installation on Windows OS

Section Overview

USE SCHEMA

The SELECT Statement

Statements vs Queries

SELECT STAR ()

Aliasing Column Names

Aliasing Table Names (and Qualifying Columns)

Adding Comments to SQL Code

Selecting Distinct Rows

Limiting Rows

Ordering Rows

Syntax Differences Across Databases

Order of Execution (So Far)

Numeric Data Types

String Data Types

The Describe Statement

Data Type Differences Across Databases

Creating and Dropping Schemas

Creating and Dropping Tables

Create Table As (CTAS)

Inserting Rows

Inserting Multiple Rows

Truncating Tables

Constraints in SQL

Not Null Constraint

Alter Table

Unique Constraint

Updating and Deleting Rows

Default Constraint

Dropping the Unique and Check Constraints

Check Constraint

Dropping the Not Null and Default Constraints

Types of Relationships

Tidying Up Our Schemas

Primary and Foreign Keys

Primary and Foreign Keys (Demo)

Entity Relationship Diagrams (ERD)

Normalization

Syntax Differences Across Databases

HR Schema

Customer Orders Schema

Assignment 2

Assignment 1

Assignment 3

Introduction to the Where Clause

Null Values

Arithmetic Operators, Expressions and Order of SQL Execution

Comparison Operators and the Where Clause

Recapping DDL and DML Statements

Pattern Matching with the LIKE Operator

Logical Operators

Syntax Differences Across Databases

Internal and Metadata Schemas in MySQL

Information Schema Demo

String Functions - Upper and Lower

SQL Literals

String Functions - Concat

String Functions - Length

String Functions - Right and Left

String Functions - Substring and Mid

Numerical Functions - Abs

Numerical Functions - Round and Truncate

String Functions - Locate

Date and Time Functions - Current Time, Date and Timestamp

Date and Time Functions - Date Format

Coalesce

Date and Time Functions - String to Date

Date and Time Functions - Add Date and Date Diff

Using Expressions in Clauses

Differences Across Databases

Conditional Functions - Case Expression

Assignment 4

Aggregate Functions

Overview of the Group By Clause

Group By Examples

Group By Index Position

Group By Expression

Filtering Aggregated Data with the Having Clause

Assignment 5

Join Syntax with other Clauses

Joining Tables Demo

Joining Tables Overview

Union and Union All

Intersect and Except

Joining Tables Demo 2

Cross Join

Emulating Full Outer Joins in MySQL

Differences Across Databases

Aliasing Columns and SQL Execution Order

Order of Execution

Subqueries Demo

Self Join

Subqueries

Views Overview

Views Demo

Creating a New User Account

Differences Across Databases

Grant and Revoke Demo

Commit

Rollback

Differences Across Databases

Savepoint