Lesson 19 - SELECT within SELECT (Subqueries)

The Complete Oracle SQL Certification Course

Database Basics

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

Multi-Table Queries and Joins

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)

Lecture contents locked

Site Membership Required

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