Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
The Complete Oracle SQL Certification Course
Database Basics
Lesson 1 - Course Overview (5:54)
Lesson 2 - Oracle Database Overview & Basics of Tables (19:42)
Lesson 3 - Setting up The SQL Development Environment (5:26)
IMPORTANT: Prepare the Course Data (4:33)
Single Table Queries
Lesson 4 - Retrieving Data Using SELECT Clause (14:42)
Lesson 5 - Using the WHERE Clause In a SQL Query (19:35)
Lesson 6 - Using Operators in the WHERE Clause (19:45)
Lesson 7 - Combining WHERE, AND & OR with Operators (19:14)
Lesson 8 - Query Filtering Continued BETWEEN, IN and NULL (19:58)
Lesson 9 - Query Filtering Conditions & Operator Precedence (19:54)
Lesson 10 - Ordering, Concatenating & Aliasing Query Results (19:58)
Single Row Functions (SRFs)
Lesson 11 - Single Row Functions (SRF) & Using The Dual Table (19:36)
Lesson 12 - Using Functions in WHERE And Character Based SRFs (19:58)
Lesson 13 - Numeric and Date Data type SRFs (19:52)
Lesson 14 - Conversion SRFs & Date Formatting (19:37)
Lesson 15 - Concluding SRFs & NULL / NULLIF Functions (16:15)
Grouping Functions
Lesson 16 - Grouping Functions MIN, MAX, AVG, COUNT etc. (19:42)
Lesson 17 - GROUP BY Clause & HAVING Clause (19:57)
Lesson 18 - More Practice With The GROUP BY Clause (12:10)
Multi-Table Queries and Joins
Lesson 19 - SELECT within SELECT (Subqueries) (23:55)
Lesson 20 - Relating Tables Together Using JOINs (19:19)
Lesson 21 - Joins Continued INNER & OUTER Joins (21:29)
Lesson 22 - More Joins With Correlated Subqueries (21:13)
Creating, Altering, and Updating Tables Using SQL
Lesson 23 - Creating Your Own Tables & Design Considerations (20:59)
Lesson 24 - Inserting Data Into Our Table (19:39)
Lesson 25 - Create Table With a Primary Key Constraint (21:34)
Lesson 26 - Using ALTER to modify the table structure (Newly Added) (16:32)
Lesson 27 - Create Table with SELECT + UPDATE Data (Newly Added) (19:55)
Lesson 28 - Deleting, Dropping and Truncating (18:48)
Lesson 29 - Working With Database Indexes (Newly Added) (14:19)
Lesson 30 - System Tables, Pseudo Columns & Deleting Duplicates (Newly Added) (24:05)
Granting and Revoking Privileges (15:08)
Lesson 19 - SELECT within SELECT (Subqueries)
Lecture content locked
If you're already enrolled,
you'll need to login
.
Site Membership Required