This is everything you need to know to get started with Oracle SQL! This is a basic, quick start series to help you get started for complete beginners!

Timestamps 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 01: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