Filename | Size |
| 1. Database Basics/1. Oracle Database Introduction & Basics of Tables.mp4 | 35.7 MB |
| 1. Database Basics/1. Oracle Database Introduction & Basics of Tables.vtt | 27.3 KB |
| 1. Database Basics/2. Setting Up the SQL Development Environment (Mac & Windows).mp4 | 15.7 MB |
| 1. Database Basics/2. Setting Up the SQL Development Environment (Mac & Windows).vtt | 7.1 KB |
| 1. Database Basics/3. IMPORTANT Prepare the Data in the Database.mp4 | 15.1 MB |
| 1. Database Basics/3. IMPORTANT Prepare the Data in the Database.vtt | 5.9 KB |
| 1. Database Basics/3.1 course_data.txt.txt | 2.4 KB |
| 2. Single Table Queries (Exercises & Solutions in the Lectures)/1. Oracle Exams and Certification Information.html | 688 B |
| 2. Single Table Queries (Exercises & Solutions in the Lectures)/10. Practice Test For Single Table Queries.html | 151 B |
| 2. Single Table Queries (Exercises & Solutions in the Lectures)/2. Retrieving Data Using the SELECT Clause.mp4 | 25.3 MB |
| 2. Single Table Queries (Exercises & Solutions in the Lectures)/2. Retrieving Data Using the SELECT Clause.vtt | 18.4 KB |
| 2. Single Table Queries (Exercises & Solutions in the Lectures)/3. Using the WHERE Clause in a Query.mp4 | 42.3 MB |
| 2. Single Table Queries (Exercises & Solutions in the Lectures)/3. Using the WHERE Clause in a Query.vtt | 23.8 KB |
| 2. Single Table Queries (Exercises & Solutions in the Lectures)/4. Using Operators in the WHERE Clause.mp4 | 47.1 MB |
| 2. Single Table Queries (Exercises & Solutions in the Lectures)/4. Using Operators in the WHERE Clause.vtt | 25.6 KB |
| 2. Single Table Queries (Exercises & Solutions in the Lectures)/5. Combining WHERE, AND & OR with Operators.mp4 | 42.4 MB |
| 2. Single Table Queries (Exercises & Solutions in the Lectures)/5. Combining WHERE, AND & OR with Operators.vtt | 26 KB |
| 2. Single Table Queries (Exercises & Solutions in the Lectures)/6. Query Filtering Continued BETWEEN, IN and NULL.mp4 | 44.2 MB |
| 2. Single Table Queries (Exercises & Solutions in the Lectures)/6. Query Filtering Continued BETWEEN, IN and NULL.vtt | 24.8 KB |
| 2. Single Table Queries (Exercises & Solutions in the Lectures)/7. Query Filtering Conditions & Operator Precedence.mp4 | 43.5 MB |
| 2. Single Table Queries (Exercises & Solutions in the Lectures)/7. Query Filtering Conditions & Operator Precedence.vtt | 24.8 KB |
| 2. Single Table Queries (Exercises & Solutions in the Lectures)/8. Ordering, Concatenating & Aliasing Query Results.mp4 | 43.1 MB |
| 2. Single Table Queries (Exercises & Solutions in the Lectures)/8. Ordering, Concatenating & Aliasing Query Results.vtt | 24.4 KB |
| 2. Single Table Queries (Exercises & Solutions in the Lectures)/9. Practice with single table queries.html | 155 B |
| 3. Single Row Functions (Exercises and Solutions In the Lectures)/1. Single Row Functions (SRF) & Using The Dual Table.mp4 | 40.8 MB |
| 3. Single Row Functions (Exercises and Solutions In the Lectures)/1. Single Row Functions (SRF) & Using The Dual Table.vtt | 25.1 KB |
| 3. Single Row Functions (Exercises and Solutions In the Lectures)/2. Using Functions in WHERE And Character Based SRFs.mp4 | 41.7 MB |
| 3. Single Row Functions (Exercises and Solutions In the Lectures)/2. Using Functions in WHERE And Character Based SRFs.vtt | 24.8 KB |
| 3. Single Row Functions (Exercises and Solutions In the Lectures)/3. Numeric and Date Data type SRFs.mp4 | 40.5 MB |
| 3. Single Row Functions (Exercises and Solutions In the Lectures)/3. Numeric and Date Data type SRFs.vtt | 25.9 KB |
| 3. Single Row Functions (Exercises and Solutions In the Lectures)/4. Conversion SRFs & Date Formatting.mp4 | 38.1 MB |
| 3. Single Row Functions (Exercises and Solutions In the Lectures)/4. Conversion SRFs & Date Formatting.vtt | 25.1 KB |
| 3. Single Row Functions (Exercises and Solutions In the Lectures)/5. Some More Date Functions.html | 723 B |
| 3. Single Row Functions (Exercises and Solutions In the Lectures)/6. Concluding SRFs & NULL NULLIF Functions.mp4 | 33.3 MB |
| 3. Single Row Functions (Exercises and Solutions In the Lectures)/6. Concluding SRFs & NULL NULLIF Functions.vtt | 21.9 KB |
| 3. Single Row Functions (Exercises and Solutions In the Lectures)/7. Practice with Single Row Functions.html | 155 B |
| 4. Grouping Functions (Exercises and Solutions In the Lectures)/1. Grouping Functions MIN, MAX, AVG, COUNT etc..mp4 | 40.4 MB |
| 4. Grouping Functions (Exercises and Solutions In the Lectures)/1. Grouping Functions MIN, MAX, AVG, COUNT etc..vtt | 25.5 KB |
| 4. Grouping Functions (Exercises and Solutions In the Lectures)/2. GROUP BY Clause & HAVING Clause.mp4 | 40.2 MB |
| 4. Grouping Functions (Exercises and Solutions In the Lectures)/2. GROUP BY Clause & HAVING Clause.vtt | 26.2 KB |
| 4. Grouping Functions (Exercises and Solutions In the Lectures)/3. More Practice With The GROUP BY Clause.mp4 | 28 MB |
| 4. Grouping Functions (Exercises and Solutions In the Lectures)/3. More Practice With The GROUP BY Clause.vtt | 16.4 KB |
| 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/1. SELECT within SELECT (Subqueries).mp4 | 48.1 MB |
| 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/1. SELECT within SELECT (Subqueries).vtt | 31.6 KB |
| 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/2. Relating Tables Together Using JOINs.mp4 | 41.7 MB |
| 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/2. Relating Tables Together Using JOINs.vtt | 25.3 KB |
| 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/3. Joins Continued INNER & OUTER Joins.mp4 | 48 MB |
| 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/3. Joins Continued INNER & OUTER Joins.vtt | 28.3 KB |
| 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/4. Correlated Subqueries with EXISTS & NOT EXIST operators.mp4 | 44.2 MB |
| 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/4. Correlated Subqueries with EXISTS & NOT EXIST operators.vtt | 27.4 KB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/1. Creating Your Own Tables & Design Considerations.mp4 | 42.4 MB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/1. Creating Your Own Tables & Design Considerations.vtt | 28.3 KB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/10. Views and Other Objects and Commands (Newly Added).mp4 | 51.6 MB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/10. Views and Other Objects and Commands (Newly Added).vtt | 30.8 KB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/11. SQL could be tricky, check this out!.html | 1.2 KB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/12. Granting and Revoking Privileges.mp4 | 339.9 MB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/12. Granting and Revoking Privileges.vtt | 18.3 KB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/13. BECOME A SQL QUERY WIZARD!.html | 704 B |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/14. Bonus Lecture Lifetime Access to All My Courses.html | 663 B |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/2. Inserting Data Into Our Table.mp4 | 40.2 MB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/2. Inserting Data Into Our Table.vtt | 25.3 KB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/3. Create Table With a Primary Key Constraint.mp4 | 47.4 MB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/3. Create Table With a Primary Key Constraint.vtt | 30 KB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/4. Using ALTER to modify the table structure.mp4 | 34.8 MB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/4. Using ALTER to modify the table structure.vtt | 20.9 KB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/5. Create Table with SELECT + UPDATE Data.mp4 | 44 MB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/5. Create Table with SELECT + UPDATE Data.vtt | 24.7 KB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/6. Primary and Foreign Keys.html | 1.6 KB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7. DELETE, TRUNCATE, and DROP Commands.mp4 | 40.8 MB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7. DELETE, TRUNCATE, and DROP Commands.vtt | 23.3 KB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/8. Working With Database Indexes.mp4 | 29.1 MB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/8. Working With Database Indexes.vtt | 18.6 KB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/9. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).mp4 | 63.4 MB |
| 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/9. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).vtt | 31 KB |