Mixing PROJECTION and SELECTION

Oracle 12c SQL Fundamentals

Introduction to RDBMS and data modeling

What is data? (4:50)
Introduction to RDBMS (5:48)
Data modeling and data types (7:35)
Reading a data model (4:15)
Understanding data model (1:17)

Database Normalization

Introduction to database normalization (2:25)
First normal form (1NF) (6:44)
Second normal form (2NF) (6:06)
Second normal form example (10:12)
Re-visiting the data model (1:16)
Third Normal Form (3NF) (4:03)
Assignment: Database Normalization

Introduction to Structured Query Language (SQL)

Origin of SQL (3:17)
Oracle products - part 1 (7:36)
Oracle products - part 2 (3:07)
Tools to connect Oracle Database (5:04)
How to connect your cloud lab (1:46)

Oracle SELECT Statement

SELECT statement overview (3:50)
Execute your first SELECT statement (7:18)
SELECT syntax rules (6:19)
PROJECTION and SELECTION (WHERE clause) (7:23)
Mixing PROJECTION and SELECTION (1:28)
Query readability (2:20)
DESCRIBE table structure (5:54)

Oracle SQL Operators

SQL operators overview (2:33)
SQL arithmetic operators (6:25)
SQL comparison operators (5:52)
SQL character operator (12:19)
IS NULL and IS NOT NULL operator (3:44)
BETWEEN operator (2:57)
IN operator (1:55)
BOOLEAN operator (7:34)
CONCATINATION operator (1:48)
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

Oracle 1Z0-071 Certification Prepare

Lecture content locked

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