Oracle SQL Tutorials

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

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.

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