Introduction to databases, SQL, and MySQL
  • What does the course cover?
  • Why SQL?
  • Why SQL?
  • Why MySQL?
  • Why MySQL?
  • Introduction to databases
  • Introduction to databases
SQL theory
  • SQL as a declarative language
  • SQL as a declarative language
  • Data definition language (DDL)
  • Data definition language (DDL)
  • SQL keywords
  • SQL keywords
  • Data manipulation language (DML)
  • Data manipulation language (DML)
  • Data control language (DCL)
  • Data control language (DCL)
  • Transaction control language (TCL)
  • Transaction control language (TCL)
Basic database terminology
  • Relational database essentials
  • Relational database essentials
  • Databases vs spreadsheets
  • Databases vs spreadsheets
  • Database terminology
  • Database terminology
  • Relational schemas - Primary key
  • Relational schemas - Primary key
  • Relational schemas - Foreign key
  • Relational schemas - Foreign key
  • Relational schemas - Unique key and null values
  • Relational Schemas - Unique key
  • Relationships
  • Relational Schemas – Relationships
Installing MySQL and getting acquainted with the interface
  • Installing MySQL
  • Additional note – Installing – Visual C
  • Installing MySQL on macOS and Unix systems
  • The Client-Server Model
  • Setting up a connection
  • Read me!!!
  • New Authentication Plugin - Creating a New User
  • Introduction to the MySQL interface
First steps in SQL
  • Creating a Database - Part I
  • SQL files
  • Creating a Database - Part I - exercise
  • Creating a Database - Part I - solution
  • Creating a Database - Part II
  • Creating a Database - Part II - exercise
  • Creating a Database - Part II - solution
  • Introduction to data types
  • Introduction to data types
  • String data types
  • String data types
  • Integers
  • Integers
  • Fixed and floating-point data types
  • Fixed and floating-point data types
  • Other useful data types
  • Other useful data types
  • Creating a table
  • Creating a table - exercise
  • Creating a table - solution
  • Using databases and tables
  • Using databases and tables - exercise
  • Using databases and tables - solution
  • Additional notes on using tables
  • Additional notes on using tables
  • Additional notes on using tables - exercise
MySQL constraints
  • PRIMARY KEY constraint
  • PRIMARY KEY Constraint
  • PRIMARY KEY constraint - exercise
  • PRIMARY KEY constraint - solution
  • FOREIGN KEY constraint - Part I
  • FOREIGN KEY constraint - Part II
  • FOREIGN KEY constraint - Part II - exercise
  • FOREIGN KEY constraint - Part II - solution
  • UNIQUE Constraint
  • UNIQUE Constraint - exercise
  • DEFAULT Constraint
  • DEFAULT Constraint - exercise
  • DEFAULT Constraint - solution
  • NOT NULL Constraint - Part I
  • NOT NULL Constraint - Part I - exercise
  • NOT NULL Constraint - Part I - solution
  • NOT NULL Constraint - Part II
SQL best practices
  • Coding techniques and best practices - Part I
  • Coding techniques and best practices – Part I
  • Coding techniques and best practices - Part II
  • Coding techniques and best practices – Part II
Loading the 'employees' database
  • Loading the 'employees' database
  • Loading the 'employees' database
SQL SELECT statement
  • SELECT - FROM