This is the ultimate SQL All-in-One Tutorial series! This includes my Oracle SQL, MySQL, SQL Server, and DB2 SQL series’!

Timestamps:
Oracle SQL All-in-One Quick Start Tutorial Series

• 00:00:00 - Intro to Oracle Database
• 00:10:16 - Entities and Attributes
• 00:20:33 - Downloading Oracle Database and Installing SQL Developer
• 00:30:50 - Beginner Terms - Database Design Primer 1
• 00:45:00 - Database Integrity - Database Design Primer 2
• 00:57:17 - Relationships and Primary and Foreign Keys - Database Design Primer 3
• 01:26:54 - Normalization - Database Design Primer 4
• 01:47:31 - Indexes - Database Designer Primer 5
• 01:58:36 - Intro to Queries
• 02:03:29 - Whitespace, Case Sensitivity, and Comments
• 02:11:17 - CREATE TABLE
• 02:16:20 - Intro to Constraints
• 02:22:32 - How to Add Column Constraints (Attributes)
• 02:28:26 - Column-Level and Table-Level Constraints
• 02:32:40 - How to Add Primary Key Constraints
• 02:35:33 - Parent Child Relationships
• 02:41:41 - Designing Our Foreign Keys
• 02:49:27 - How to Create Foreign Keys
• 02:56:35 - ON DELETE (SET NULL and CASCADE)
• 03:02:33 - How to Create Composite Primary Keys
• 03:09:34 - How to Create - Drop Indexes
• 03:13:31 - Why Primary Keys Shouldn’t Change
• 03:20:44 - Intro to Data Types
• 03:25:47 - Important Data Types
• 03:31:55 - UTF-8 and UTF-16
• 03:37:40 - CHAR Part 1
• 03:41:31 - CHAR Part 2
• 03:45:03 - NCHAR Part 1
• 03:50:00 - UTF-8 and UTF-16 Character Sets
• 03:54:01 - NCHAR Part 2
• 03:57:12 - VARCHAR2 and NCARCHAR2
• 04:00:17 - NUMBER Data Type
• MySQL All-in-One Quick Start Tutorial Series
• 04:07:54 - Intro to MySQL
• 04:21:06 - Installing MySQL
• 04:25:30 - MySQL Workbench
• 04:29:34 - Beginner Terms Part 1
• 04:35:47 - Beginner Terms Part 2
• 04:39:04 - Beginner Terms Part 3
• 04:42:57 - One-to-One Relationships
• 04:46:32 - One-to-Many Relationships
• 04:51:43 - Many-to-Many Relationships
• 04:58:40 - Summary of Relationships
• 05:02:23 - Entity Integrity
• 05:06:45 - Referential Integrity
• 05:09:56 - Domain Integrity
• 05:14:56 - Primary Key
• 05:20:02 - Auto Increment (AUTO_INCREMENT)
• 05:25:21 - Foreign Key
• 05:31:16 - ON DELETE and ON UPDATE
• 05:35:47 - Intro to Normalization
• 05:43:23 - 1NF
• 05:48:45 - 2NF
• 05:56:33 - 3NF
• 06:02:15 - Normalization Summary
• 06:05:11 - Intro to Data Types
• 06:11:34 - Important Data Types
• 06:17:07 - CHAR Data Type
• 06:21:52 - VARCHAR Data Type
• 06:26:21 - TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT
• 06:30:01 - ENUM
• 06:35:47 - SET Data Type
• 06:42:00 - INT Data Type
• 06:45:01 - DECIMAL Data Type
• 06:47:20 - FLOAT and DOUBLE Data Types
• 06:53:42 - Datetime, Date, and Time Data Types
• MySQL Stored Procedures All-in-One Quick Start Tutorial Series
• 07:00:42 - Intro to Stored Routines
• 07:04:15 - Intro to Variables
• 07:10:01 - Variables
• 07:13:38 - Creating Variables within SELECT
• 07:18:24 - SQL Fiddle - CREATE DATABASE
• 07:26:03 - How to Create Variables with SELECT and SET
• 07:31:43 - Intro to Stored Procedures
• 07:38:08 - Procedure Syntax
• 07:42:30 - Database API (Application Programming Interface)
• 07:50:42 - CREATE PROCEDURE
• SQL Server All-in-One Quick Start Tutorial Series Timestamps
• 07:56:28 - Intro to SQL Server
• 08:05:50 - Installing SQL Server 2016
• 08:09:11 - How to Install SSMS
• 08:13:12 - Beginner Terms Part 1
• 08:20:25 - Beginner Terms Part 2
• 08:26:56 - One-to-One Relationship
• 08:32:02 - One-to-Many Relationships
• 08:38:44 - Many-to-Many Relationships
• 08:46:01 - Database Relationships Summary
• 08:51:13 - Entity Integrity
• 08:58:49 - Referential Integrity
• 09:06:09 - Domain Integrity
• 09:11:24 - Primary Key
• 09:15:05 - Composite Key
• 09:21:54 - Foreign Key
• 09:29:50 - ON DELETE and ON UPDATE
• 09:37:51 - Intro to Normalization
• 09:46:05 - 1NF
• 09:56:30 - 2NF
• 10:09:23 - 3NF
• 10:24:37 - Normalization Summary
• 10:32:05 - Intro to Queries
• 10:36:45 - CREATE TABLE
• 10:43:16 - Drop Table
• 10:52:00 - PRIMARY KEY, NOT NULL, UNIQUE
• 10:55:36 - How to Create FOREIGN KEY Constraints
• 11:00:00 - Composite Primary Key
• 11:04:55 - How to Name Constraints
• 11:08:37 - How to INSERT Data
• 11:14:24 - How to SELECT Data
• 11:17:04 - How to Create an Alias with AS
• 11:20:29 - Indexes
• 11:28:09 - How to Create and Drop Indexes
• DB2 SQL All-in-One Quick Start Tutorial Series
• 11:33:43 - Intro to Db2
  … and more!

#sql #mysql #databases #web-development