Oracle SQL Certifications Complete Guide Video Course

Curriculum For This Course

• 1. Database Basics 2 Videos 00:28:23
  • Oracle Database Introduction & Basics of Tables 18:39
  • Setting Up the SQL Development Environment (Mac & Windows) 08:28
• 2. Single Table Queries (Exercises & Solutions in the Lectures) 7 Videos 02:14:13
  • Retrieving Data Using the SELECT Clause 15:17
  • Using the WHERE Clause in a Query 19:18
  • Using Operators in the WHERE Clause 19:19
  • Combining WHERE, AND & OR with Operators 18:03
  • Query Filtering Continued BETWEEN, IN and NULL 19:20
  • Query Filtering Conditions & Operator Precedence 19:19
  • Ordering, Concatenating & Aliasing Query Results 19:37
• 3. Single Row Functions (Exercises and Solutions In the Lectures) 5 Videos 01:35:18
  • Single Row Functions (SRF) & Using The Dual Table 19:17
  • Using Functions in WHERE And Character Based SRFs 18:39
  • Numeric and Date Data type SRFs 19:00
  • Conversion SRFs & Date Formatting 19:09
  • Concluding SRFs & NULL / NULLIF Functions 16:01
• 4. Grouping Functions (Exercises and Solutions In the Lectures) 3 Videos 00:51:49
  • Grouping Functions MIN, MAX, AVG, COUNT etc. 19:22
  • GROUP BY Clause & HAVING Clause 19:44
  • More Practice With The GROUP BY Clause 11:58
• 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures) 4 Videos 01:25:56
  • SELECT within SELECT (Subqueries) 23:10
  • Relating Tables Together Using JOINs 18:59
  • Joins Continued INNER & OUTER Joins 21:09
  • More Joins With Correlated Subqueries 20:56
• 6. Creating, Altering, and Updating Tables Using SQL (Exercises in Lectures) 9 Videos 02:59:22
  • Creating Your Own Tables & Design Considerations 20:21
  • Inserting Data Into Our Table 07:36
  • Create Table With a Primary Key Constraint 21:15
  • Using ALTER to modify the table structure 16:25
  • Create Table with SELECT + UPDATE Data 19:36
  • DELETE, TRUNCATE, and DROP Commands 18:01
  • Working With Database Indexes (Newly Added) 13:40
  • System Tables, Pseudo Columns & Deleting Duplicates (Newly Added) 23:30
  • Views and Other Objects and Commands (Newly Added) 22:56