Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Introduction to Oracle SQL
Introduction and Setup
Introduction (2:09)
Tools and Concepts (7:40)
Oracle Client Download (1:46)
Oracle Client Install (1:24)
How To Install Oracle On A Mac
Java JDK Download (1:11)
Java JDK Install (1:20)
SQL Developer Download (2:47)
SQL Developer Setup (2:16)
SQL Developer Connection Setup (1:12)
Viewing Data
Viewing Data - SELECT statement (Part 1) (2:53)
SQL Developer - Create New User (2:36)
SQL Developer - Create and Populate Tables (3:27)
Viewing Data - SELECT statement (Part 2) (5:04)
Viewing Data - Operators, DISTINCT and NULL (13:24)
SQL Data Types (5:21)
Viewing Data - Restricting and Sorting (Part 1) (13:19)
Viewing Data - Restricting and Sorting (Part 2) (10:24)
Functions
Functions - Strings (11:22)
Functions - Numbers (6:14)
Working with Dates and Times (5:29)
Functions - Dates (4:25)
Functions - Conversion (3:43)
Aggregate Functions (11:41)
More SELECT Concepts
Table Aliases and Joins (16:44)
Joins Part 2 (8:44)
Set Operators (6:35)
Translate, Decode and Case (6:41)
Subqueries - Single Row (13:21)
Subqueries - Multiple Row (17:14)
DML - Data Manipulation Language
DML - Insert (7:15)
DML - Update (6:08)
DML - Delete and TRUNCATE (4:27)
Objects
DDL - Object Types (15:48)
DDL - Create Table and Constraints (20:28)
DDL - Alter and Drop Table (4:50)
Conclusion
Conclusion (1:10)
Java JDK Install
Download
Complete and Continue