Play all

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!)

Description:

Dive into an extensive 8-hour tutorial series on Oracle SQL, covering everything from basic database concepts to advanced querying techniques. Learn about entities, attributes, database design principles, normalization, and indexing. Master the process of creating tables, implementing constraints, and establishing relationships between tables. Explore various data types, including character and numeric types, and understand their implications in database design. Gain hands-on experience with downloading Oracle Database, installing SQL Developer, and writing SQL queries. Progress through practical examples of creating primary and foreign keys, managing table relationships, and implementing advanced features like composite keys and ON DELETE cascades. By the end of this comprehensive series, develop a solid foundation in Oracle SQL and database management skills.

Oracle SQL Tutorials

Caleb Curry

Add to list

#Programming #Cloud Computing #Oracle #Databases #Database Design #Normalization #Domain-Specific Languages (DSL) #SQL #Oracle SQL