Introduction to Databases, SQL, and MySQL

Whether you are working in business intelligence (BI), data science, database administration, or back-end development, you will have to retrieve information from a server storing large amounts of data. To achieve this, you need SQL. The relational database management system we chose for this course is MySQL. We did that because MySQL is open-source, reliable, and mature. In one of the videos of this section, we will provide you with step-by-step guidance when you install MySQL Server and MySQL Workbench. The introductory part of this course pays significant attention to database theory. You will learn the meaning of terms like database, data table, data entity, record, field, relation, and more.

Quiz Assignment
Quiz Assignment
Quiz Assignment
Quiz Assignment

SQL

Our graduates work at exciting places

Introduction to Databases, SQL, and MySQL

Welcome to SQL (4 min)

Why SQL? (3 min)

Why MySQL? (2 min)

Introduction to databases (5 min)

SQL Theory

SQL as a declarative language (2 min)

Data definition language (DDL) (4 min)

SQL keywords (1 min)

Data manipulation language (DML) (5 min)

Data control language (DCL) (5 min)

Transaction control language (TCL) (3 min)

Basic Database Terminology

Relational database essentials (5 min)

Databases vs spreadsheets (7 min)

Database terminology (4 min)

Relational schemas - Primary key (5 min)

Relational schemas - Foreign key (5 min)

Relational schemas - Unique key and null values (3 min)

Relationships (5 min)

Installing MySQL and Getting Acquainted with the Interface

Installing MySQL (11 min)

Additional note – Installing – Visual C

Installing MySQL on macOS and Unix systems

The Client-Server Model

Setting up a connection (3 min)

Important - Please read

New Authentication Plugin - Creating a New User (6 min)

Introduction to the MySQL interface (5 min)

First Steps in SQL

Creating a Database - Part I (5 min)

SQL files

Creating a Database - Part II (2 min)

Introduction to data types (2 min)

String data types (5 min)

Integers (4 min)

Fixed and floating-point data types (6 min)

Other useful data types (6 min)

Creating a table (5 min)

Using databases and tables (3 min)

Additional notes on using tables (2 min)

MySQL Constraints

PRIMARY KEY constraint (5 min)

FOREIGN KEY constraint - Part I (5 min)

FOREIGN KEY constraint - Part II (5 min)

UNIQUE Constraint (5 min)

DEFAULT Constraint (5 min)

NOT NULL Constraint - Part I (6 min)

NOT NULL Constraint - Part II (2 min)

SQL Best Practices

Coding techniques and best practices - Part I (6 min)

Coding techniques and best practices - Part II (4 min)

Loading the Data

Loading the 'employees' database (2 min)

SQL SELECT STATEMENT

SELECT… FROM… (5 min)

WHERE (3 min)

AND (2 min)

OR (4 min)

Operator Precedence (4 min)

IN - NOT IN (3 min)

LIKE - NOT LIKE (4 min)

Wildcard Characters (2 min)

BETWEEN… AND… (2 min)

IS NOT NULL - IS NULL (2 min)

Other Comparison Operators (5 min)

SELECT DISTINCT (2 min)

Introduction to Aggregate Functions (5 min)

ORDER BY (4 min)

GROUP BY (6 min)

Using Aliases (AS) (2 min)

HAVING (3 min)

WHERE vs HAVING - Part I (4 min)

WHERE vs HAVING - Part II (3 min)

LIMIT (5 min)

SQL INSERT Statement

The INSERT statement - Part I (6 min)

The INSERT statement - Part II (2 min)