Description

Curriculum For This Course

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

  • Oracle Database Introduction & Basics of Tables18: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 Clause15:17

  • Using the WHERE Clause in a Query19:18

  • Using Operators in the WHERE Clause19:19

  • Combining WHERE, AND & OR with Operators18:03

  • Query Filtering Continued BETWEEN, IN and NULL19:20

  • Query Filtering Conditions & Operator Precedence19:19

  • Ordering, Concatenating & Aliasing Query Results19:37

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

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

  • Using Functions in WHERE And Character Based SRFs18:39

  • Numeric and Date Data type SRFs19:00

  • Conversion SRFs & Date Formatting19:09

  • Concluding SRFs & NULL / NULLIF Functions16: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 Clause19:44

  • More Practice With The GROUP BY Clause11: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 JOINs18:59

  • Joins Continued INNER & OUTER Joins21:09

  • More Joins With Correlated Subqueries20:56

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

  • Creating Your Own Tables & Design Considerations20:21

  • Inserting Data Into Our Table07:36

  • Create Table With a Primary Key Constraint21:15

  • Using ALTER to modify the table structure16:25

  • Create Table with SELECT + UPDATE Data19:36

  • DELETE, TRUNCATE, and DROP Commands18: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