This course aims to teach learners the fundamentals of Oracle SQL, including database design, normalization, querying, constraints, relationships, and data types. Students will acquire skills in creating tables, adding constraints, designing keys, and working with different data types. The teaching method includes tutorials on various topics related to Oracle SQL. This course is intended for individuals interested in learning Oracle SQL, database management, and data querying.
Overview
Syllabus
Oracle SQL Tutorial 1 - Intro to Oracle Database.
Oracle SQL Tutorial 2 - Entities and Attributes.
Oracle SQL Tutorial 3 - Downloading Oracle Database and Installing SQL Developer.
Oracle SQL Tutorial 4 - Beginner Terms - Database Design Primer 1.
Oracle SQL Tutorial 5 - Database Integrity - Database Design Primer 2.
Oracle SQL Tutorial 6 - Relationships and Primary and Foreign Keys - Database Design Primer 3.
Oracle SQL Tutorial 7 - Normalization - Database Design Primer 4.
Oracle SQL Tutorial 8 - Indexes - Database Design Primer 5.
Oracle SQL Tutorial 9 - Intro to Queries.
Oracle SQL Tutorial 10 - Whitespace, Case Sensitivity, and Comments.
Oracle SQL Tutorial 11 - CREATE TABLE.
Oracle SQL Tutorial 12 - Intro to Constraints.
Oracle SQL Tutorial 13 - How to Add Column Constraints (Attributes).
Oracle SQL Tutorial 14 - Column-Level and Table-Level Constraints.
Oracle SQL Tutorial 15 - How to Add Primary Key Constraints.
Oracle SQL Tutorial 16 - Parent Child Relationships.
Oracle SQL Tutorial 17 - Designing Our Foreign Keys.
Oracle SQL Tutorial 18 - How to Create Foreign Keys.
Oracle SQL Tutorial 19 - ON DELETE (SET NULL and CASCADE).
Oracle SQL Tutorial 20 - How to Create Composite Primary Keys.
Oracle SQL Tutorial 21 - How to Create / Drop Indexes.
Oracle SQL Tutorial 22 - Why Primary Keys Shouldn't Change.
Oracle SQL Tutorial 23 - Intro to Data Types.
Oracle SQL Tutorial 24 - Important Data Types.
Oracle SQL Tutorial 25 - ASCII and Unicode.
Oracle SQL Tutorial 26 - UTF-8 and UTF-16.
Oracle SQL Tutorial 27 - CHAR Part 1.
Oracle SQL Tutorial 28 - CHAR Part 2.
Oracle SQL Tutorial 29 - NCHAR Part 1.
Oracle SQL Tutorial 30 - UTF-8 and UTF-16 Character Sets.
Oracle SQL Tutorial 31 - NCHAR Part 2.
Oracle SQL Tutorial 32 - VARCHAR2 and NVARCHAR2.
Oracle SQL Tutorial 33 - NUMBER Data Type.
Oracle SQL All-in-One Quick Start Tutorial Series (4 HOURS!).
Taught by
Caleb Curry
