[FreeCourseLab.com] Udemy - Oracle Database 12c SQL Certified Associate 1Z0-071

• [FreeCourseLab.com] Udemy - Oracle Database 12c SQL Certified Associate 1Z0-071
• 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

No comments yet.