The Complete SQL and MySQL Course - From Beginner to Expert 

Introduction

Installing SQL and MY SQL

What are databases and database management systems(DBMS)

The relational model

Data structures behind database servers

Procedural and non-procedural languages

Types of DBMS and database languages

Data types

Creating databases

CODE - creating databases

Creating a table

CODE - creating database tables

Inserting into a table

Inserting multiple items in one statement

CODE - inserting into tables

Delete row from a table

CODE - delete row

Updating a row

CODE - updating rows

Changing table structure

CODE - change table structure

Drop tables

What are primary keys?

The auto increment feature

CODE - auto incremented primary keys

Enums

Booleans

Floating point numbers with decimals

Dates

Exercise

Solution

SQL dump - the city and country tables

SELECT

WHERE

IN

BETWEEN

NOT

Logical operators

Wildcards

Functions

ORDER BY

Code - order by

GROUP BY

CODE - group by

Exercise

Solution

HAVING

CASE

NULL functions

What is a foreign key?

Foreign key example

CODE - foreign keys

How to handle changes when dealing with multiple tables?

Updating dependent tables example