Mixing PROJECTION and SELECTION

Oracle 12c SQL Fundamentals

Welcome to the course!

Introduction to RDBMS and data modeling

What is data? (4:57)
Introduction to RDBMS (5:55)
Data modeling (7:41)
Reading a data model (4:21)
Understanding data model (1:24)

Database Normalization

Introduction to normalization (2:31)
First normal form (1NF) (6:51)
Second normal form (2NF) (6:13)
Second normal form example (10:18)
Re-visiting the data model (1:22)
Third Normal Form (3NF) (4:10)
Assignment: Database Normalization

Introduction to (SQL)

Origin of SQL (3:23)
Oracle products - part 1 (7:42)
Oracle products - part 2 (3:13)
Tools to connect Oracle Database (5:10)
How to connect your cloud lab (1:53)

Oracle SELECT Statement

SELECT statement overview (3:57)
Execute your first SELECT statement (7:24)
SELECT syntax rules (6:26)
PROJECTION and SELECTION (WHERE clause) (7:30)
Mixing PROJECTION and SELECTION (1:34)
Query readability (2:26)
DESCRIBE table structure (6:00)

Oracle SQL Operators

SQL operators overview (2:39)
SQL arithmetic operators (6:31)
SQL comparison operators (5:58)
SQL character operator (12:25)
IS NULL and IS NOT NULL operator (3:50)
BETWEEN operator (3:04)
IN operator (2:01)
BOOLEAN operator (7:41)
CONCATINATION operator (1:54)
Assignment: SQL Operators

Precedence Rule & Records Sorting

SQL Operators Precedence rule (4:51)
Precedence rule example 1 (5:24)
Precedence rule example 2 (4:09)
Column Alias in Oracle (5:42)
Table Alias in Oracle (2:53)
ORDER BY clause - sorting data (6:30)
ORDER BY clause example 1 (1:31)
Ampersand substitution (7:25)
Ampersand substitution example 1 (3:57)
Double Ampersand substitution (5:37)
Oracle DUAL table (3:31)

SQL Functions

Single Row Functions (2:32)
Character functions (16:29)
Numeric functions (6:15)
Date functions (10:56)
Group Functions (5:34)
AVG function (0:59)
COUNT function (2:17)
MINIMUM and MAXIMUM functions (3:09)
SUM function (0:38)
GROUP BY clause (7:12)
HAVING clause (5:06)
Data type conversion functions

Test Your Progress

SQL Sub-Queries

Oracle SQL Joins

Introduction to SQL join (3:24)
Types of SQL join (7:54)
SQL joins article link (1:06)
Join syntax (3:26)
INNER join and NATURAL join (5:21)
LEFT OUTER join and RIGHT OUTER join (9:51)
FULL OUTER join (0:42)
CARTESIAN join or CROSS join (0:51)
INNER join and NATURAL join - lab practice (12:58)
LEFT OUTER join - lab practice (6:11)
RIGHT OUTER join - lab practice (5:53)
FULL OUTER join - lab practice (2:13)
CARTESIAN join or CROSS join - lab practice (1:14)
LEFT and RIGHT OUTER join - Traditional join method (1:51)

Oracle SET Operators

Other DML Commands

Data Type in Oracle

Why data types (2:59)
Alphanumeric data types (2:25)
Numeric data types (6:44)
DATE data types (4:54)
Large object data types (4:12)
RowID data type (1:59)

DDL Commands in Oracle

Table level constraints (10:07)
CREATE table (8:59)
CREATE table - lab practice (6:20)
ALTER table (6:25)
DROP and TRUNCATE table (3:28)
RENAME table (0:28)
COMMENT on table and column (3:56)
CREATE table with constraints (14:24)
Testing table constraints (7:55)
Add table constraint using ALTER table command (2:25)

TCL and DCL Commands

Bonus section

What's next?

Lecture content locked

If you're already enrolled, you'll need to login.