Filename | Size |
| 1. Introduction/1. Course Agenda.mp4 | 21.1 MB |
| 1. Introduction/1. Course Agenda.vtt | 6.9 KB |
| 1. Introduction/1.1 agenda - Copy.xlsx.xlsx | 14.6 KB |
| 1. Introduction/2. System Development Life Cycle & Database Definition.mp4 | 14.7 MB |
| 1. Introduction/2. System Development Life Cycle & Database Definition.vtt | 3.3 KB |
| 1. Introduction/2.1 chapter 1 hint.pdf.pdf | 537.2 KB |
| 1. Introduction/3. What is a Table.mp4 | 6.7 MB |
| 1. Introduction/3. What is a Table.vtt | 1.4 KB |
| 1. Introduction/4. Data Models & ERM.mp4 | 18.5 MB |
| 1. Introduction/4. Data Models & ERM.vtt | 4.3 KB |
| 1. Introduction/5. About Primary key & foreign key.mp4 | 14.5 MB |
| 1. Introduction/5. About Primary key & foreign key.vtt | 4.2 KB |
| 1. Introduction/6. SQL and Types of SQL Statements.mp4 | 13.4 MB |
| 1. Introduction/6. SQL and Types of SQL Statements.vtt | 2.7 KB |
| 1. Introduction/7. Oracle Database 12c Architecture.mp4 | 15.3 MB |
| 1. Introduction/7. Oracle Database 12c Architecture.vtt | 4.4 KB |
| 1. Introduction/8. HR Schema in this Course.mp4 | 21.3 MB |
| 1. Introduction/8. HR Schema in this Course.vtt | 4.6 KB |
| 10. Displaying Data from multiple tables using joins/1. Before You Start, important notes.mp4 | 38.6 MB |
| 10. Displaying Data from multiple tables using joins/1. Before You Start, important notes.vtt | 4.9 KB |
| 10. Displaying Data from multiple tables using joins/1.1 chapter 10 part 2.sql.sql | 3.7 KB |
| 10. Displaying Data from multiple tables using joins/1.2 chapter 10 part 1.sql.sql | 1.7 KB |
| 10. Displaying Data from multiple tables using joins/1.3 chapter 10 part 3.sql.sql | 6.1 KB |
| 10. Displaying Data from multiple tables using joins/1.4 chapter 10 hints.pdf.pdf | 1.2 MB |
| 10. Displaying Data from multiple tables using joins/10. 1999 Syntax USING Clause.mp4 | 12.7 MB |
| 10. Displaying Data from multiple tables using joins/10. 1999 Syntax USING Clause.vtt | 3.3 KB |
| 10. Displaying Data from multiple tables using joins/11. 1999 Syntax ON Clause.mp4 | 20.3 MB |
| 10. Displaying Data from multiple tables using joins/11. 1999 Syntax ON Clause.vtt | 7.6 KB |
| 10. Displaying Data from multiple tables using joins/12. 1999 Syntax LeftRightfull Outer Join.mp4 | 22.5 MB |
| 10. Displaying Data from multiple tables using joins/12. 1999 Syntax LeftRightfull Outer Join.vtt | 8 KB |
| 10. Displaying Data from multiple tables using joins/2. HR Tables Diagram, Joins Clarification.mp4 | 12.7 MB |
| 10. Displaying Data from multiple tables using joins/2. HR Tables Diagram, Joins Clarification.vtt | 5.8 KB |
| 10. Displaying Data from multiple tables using joins/3. What is Cartesian product.mp4 | 18.2 MB |
| 10. Displaying Data from multiple tables using joins/3. What is Cartesian product.vtt | 4.8 KB |
| 10. Displaying Data from multiple tables using joins/4. Old Joins Equijoin.mp4 | 20.4 MB |
| 10. Displaying Data from multiple tables using joins/4. Old Joins Equijoin.vtt | 7.9 KB |
| 10. Displaying Data from multiple tables using joins/5. Old Joins nonEquijoins.mp4 | 24.5 MB |
| 10. Displaying Data from multiple tables using joins/5. Old Joins nonEquijoins.vtt | 8.2 KB |
| 10. Displaying Data from multiple tables using joins/6. Old Joins outer join.mp4 | 20.9 MB |
| 10. Displaying Data from multiple tables using joins/6. Old Joins outer join.vtt | 8 KB |
| 10. Displaying Data from multiple tables using joins/7. Old Joins Self Join and More Practices.mp4 | 20 MB |
| 10. Displaying Data from multiple tables using joins/7. Old Joins Self Join and More Practices.vtt | 9.5 KB |
| 10. Displaying Data from multiple tables using joins/8. 1999 Syntax Cross Join (Cartesian product ).mp4 | 14.6 MB |
| 10. Displaying Data from multiple tables using joins/8. 1999 Syntax Cross Join (Cartesian product ).vtt | 3.6 KB |
| 10. Displaying Data from multiple tables using joins/9. 1999 Syntax Natural Join.mp4 | 26.2 MB |
| 10. Displaying Data from multiple tables using joins/9. 1999 Syntax Natural Join.vtt | 6.9 KB |
| 11. Using Subqueries to Solve Queries/1. Single row Subqueries.mp4 | 21.3 MB |
| 11. Using Subqueries to Solve Queries/1. Single row Subqueries.vtt | 9.1 KB |
| 11. Using Subqueries to Solve Queries/1.1 chapter 11 hints.pdf.pdf | 483.9 KB |
| 11. Using Subqueries to Solve Queries/1.2 chapter 11 sql.sql.sql | 4.2 KB |
| 11. Using Subqueries to Solve Queries/2. Multiple rows Subqueries.mp4 | 17.6 MB |
| 11. Using Subqueries to Solve Queries/2. Multiple rows Subqueries.vtt | 6.2 KB |
| 11. Using Subqueries to Solve Queries/3. NULL values and Subqueries.mp4 | 15.9 MB |
| 11. Using Subqueries to Solve Queries/3. NULL values and Subqueries.vtt | 4.3 KB |
| 11. Using Subqueries to Solve Queries/4. Exists and not Exists.mp4 | 13.4 MB |
| 11. Using Subqueries to Solve Queries/4. Exists and not Exists.vtt | 4.2 KB |
| 12. Using the Set Operators/1. Overview (Union, union all, intersect, minus ).mp4 | 11.7 MB |
| 12. Using the Set Operators/1. Overview (Union, union all, intersect, minus ).vtt | 4.2 KB |
| 12. Using the Set Operators/1.1 chapter 12 hints.pdf.pdf | 469.3 KB |
| 12. Using the Set Operators/1.2 chapter 12.sql.sql | 2.9 KB |
| 12. Using the Set Operators/2. Practice (Union, union all, intersect, minus ).mp4 | 26.8 MB |
| 12. Using the Set Operators/2. Practice (Union, union all, intersect, minus ).vtt | 12.8 KB |
| 13. Managing tables using DML Statments/1. Introduction to DML.mp4 | 10.9 MB |
| 13. Managing tables using DML Statments/1. Introduction to DML.vtt | 5.2 KB |
| 13. Managing tables using DML Statments/1.1 chapter 13 hints.pdf.pdf | 2 MB |
| 13. Managing tables using DML Statments/1.2 chapter 13 part 2 update.sql.sql | 2.2 KB |
| 13. Managing tables using DML Statments/1.3 chapter 13 part 3 delete.sql.sql | 1.1 KB |
| 13. Managing tables using DML Statments/1.4 lesson 13 last part.sql.sql | 6.3 KB |
| 13. Managing tables using DML Statments/1.5 chapter 13 part 1 insert.sql.sql | 3.6 KB |
| 13. Managing tables using DML Statments/10. ROW Lock.mp4 | 10.6 MB |
| 13. Managing tables using DML Statments/10. ROW Lock.vtt | 3.9 KB |
| 13. Managing tables using DML Statments/11. FOR UPDATE Clause.mp4 | 19.4 MB |
| 13. Managing tables using DML Statments/11. FOR UPDATE Clause.vtt | 8.3 KB |
| 13. Managing tables using DML Statments/2. Insert Statement.mp4 | 33.2 MB |
| 13. Managing tables using DML Statments/2. Insert Statement.vtt | 14.2 KB |
| 13. Managing tables using DML Statments/3. Inserting common errors.mp4 | 14.6 MB |
| 13. Managing tables using DML Statments/3. Inserting common errors.vtt | 4.5 KB |
| 13. Managing tables using DML Statments/4. Update Statement.mp4 | 33.6 MB |
| 13. Managing tables using DML Statments/4. Update Statement.vtt | 13.7 KB |
| 13. Managing tables using DML Statments/5. Delete Statement.mp4 | 33.2 MB |
| 13. Managing tables using DML Statments/5. Delete Statement.vtt | 11 KB |
| 13. Managing tables using DML Statments/6. What is Database Transactions.mp4 | 16.8 MB |
| 13. Managing tables using DML Statments/6. What is Database Transactions.vtt | 4.1 KB |
| 13. Managing tables using DML Statments/7. About Commit & Rollback.mp4 | 18.8 MB |
| 13. Managing tables using DML Statments/7. About Commit & Rollback.vtt | 5.9 KB |
| 13. Managing tables using DML Statments/8. Practice ( Commit and rollback ).mp4 | 26 MB |
| 13. Managing tables using DML Statments/8. Practice ( Commit and rollback ).vtt | 10.5 KB |
| 13. Managing tables using DML Statments/9. SAVEPOINT.mp4 | 12.1 MB |
| 13. Managing tables using DML Statments/9. SAVEPOINT.vtt | 5 KB |
| 14. Introduction to Data Definition Language/1. DDL & Naming Rules.mp4 | 20.7 MB |
| 14. Introduction to Data Definition Language/1. DDL & Naming Rules.vtt | 7.6 KB |
| 14. Introduction to Data Definition Language/1.1 chapter 14 hints.pdf.pdf | 2.7 MB |
| 14. Introduction to Data Definition Language/1.2 chapter 14 sql part 3.sql.sql | 357 B |
| 14. Introduction to Data Definition Language/1.3 chapter 14 sql part 2.sql.sql | 3.9 KB |
| 14. Introduction to Data Definition Language/1.4 chapter 14 sql part 1.sql.sql | 6.1 KB |
| 14. Introduction to Data Definition Language/10. Create Table AS subquery.mp4 | 18.6 MB |
| 14. Introduction to Data Definition Language/10. Create Table AS subquery.vtt | 7 KB |
| 14. Introduction to Data Definition Language/11. Alter Table Add Columns.mp4 | 22.4 MB |
| 14. Introduction to Data Definition Language/11. Alter Table Add Columns.vtt | 9.4 KB |