Description

Curriculum For This Course

• 1. Database Basics 2 Videos 00:28:23

  • Oracle Database Introduction & Basics of Tables19:42

  • Setting Up the SQL Development Environment (Mac & Windows)8:41

• 2. Single Table Queries (Exercises & Solutions in the Lectures) 7 Videos 02:14:13

  • Retrieving Data Using the SELECT Clause15:49

  • Using the WHERE Clause in a Query19:35

  • Using Operators in the WHERE Clause19:45

  • Combining WHERE, AND & OR with Operators19:14

  • Query Filtering Continued BETWEEN, IN and NULL19:58

  • Query Filtering Conditions & Operator Precedence19:54

  • Ordering, Concatenating & Aliasing Query Results19:58

• 3. Single Row Functions (Exercises and Solutions In the Lectures) 5 Videos 01:35:18

  • Single Row Functions (SRF) & Using The Dual Table19:36

  • Using Functions in WHERE And Character Based SRFs19:58

  • Numeric and Date Data type SRFs19:52

  • Conversion SRFs & Date Formatting19:37

  • Concluding SRFs & NULL / NULLIF Functions16:15

• 4. Grouping Functions (Exercises and Solutions In the Lectures) 3 Videos 00:51:49

  • Grouping Functions MIN, MAX, AVG, COUNT etc.19:42

  • GROUP BY Clause & HAVING Clause19:57

  • More Practice With The GROUP BY Clause12:10

• 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures) 4 Videos 01:25:56

  • SELECT within SELECT (Subqueries)23:55

  • Relating Tables Together Using JOINs19:19

  • Joins Continued INNER & OUTER Joins21:29

  • More Joins With Correlated Subqueries21:13

• 6. Creating, Altering, and Updating Tables Using SQL (Exercises in Lectures) 9 Videos 02:59:22

  • Creating Your Own Tables & Design Considerations20:59

  • Inserting Data Into Our Table19:39

  • Create Table With a Primary Key Constraint21:34

  • Using ALTER to modify the table structure16:32

  • Create Table with SELECT + UPDATE Data19:55

  • DELETE, TRUNCATE, and DROP Commands18:48

  • Working With Database Indexes (Newly Added)14:19

  • System Tables, Pseudo Columns & Deleting Duplicates (Newly Added)24:05

  • Views and Other Objects and Commands (Newly Added)23:31