Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Oracle 12c SQL Fundamentals
Welcome to the course!
How to get help
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
Quiz Time
Quick Recap
Quick Read
SQL Sub-Queries
Introduction to Sub-Queries (2:12)
Using sub-queries in WHERE clause (6:04)
Using sub-queries in SELECT part (2:55)
Sub-Queries more examples (6:51)
Assignment 1
Assignment 2
Assignment 3
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
UNION operator (3:30)
UNION ALL operator (0:49)
INTERSECT operator (1:03)
MINUS operator (1:02)
Other DML Commands
INSERT rows into a table (9:12)
UPDATE rows in a table (1:49)
DELETE rows from a table (1:05)
MERGE columns from two tables (8:19)
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
COMMIT transactions (10:10)
ROLLBACK transactions (4:09)
SAVEPOINT transactions (5:01)
GRANT and REVOKE permissions (4:09)
Bonus section
Oracle SQL interview questions
Oracle 1Z0-071 exam dumps (2:12)
Mixing PROJECTION and SELECTION
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock