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

File Type video

Size 3.39GB

UpdateDate 2024-9-5

hash *****897B49537A52E3B9FD016F0779A63B7DD0

Hot 3

Files 1. Introduction/1. Course Agenda.mp4 | 21.10MB 1. Introduction/1. Course Agenda.vtt | 6.90KB 1. Introduction/1.1 agenda - Copy.xlsx.xlsx | 14.64KB 1. Introduction/2. System Development Life Cycle & Database Definition.mp4 | 14.71MB 1. Introduction/2. System Development Life Cycle & Database Definition.vtt | 3.27KB 1. Introduction/2.1 chapter 1 hint.pdf.pdf | 537.18KB 1. Introduction/3. What is a Table.mp4 | 6.66MB 1. Introduction/3. What is a Table.vtt | 1.38KB 1. Introduction/4. Data Models & ERM.mp4 | 18.54MB 1. Introduction/4. Data Models & ERM.vtt | 4.28KB 1. Introduction/5. About Primary key & foreign key.mp4 | 14.51MB 1. Introduction/5. About Primary key & foreign key.vtt | 4.17KB 1. Introduction/6. SQL and Types of SQL Statements.mp4 | 13.44MB 1. Introduction/6. SQL and Types of SQL Statements.vtt | 2.72KB 1. Introduction/7. Oracle Database 12c Architecture.mp4 | 15.28MB 1. Introduction/7. Oracle Database 12c Architecture.vtt | 4.37KB 1. Introduction/8. HR Schema in this Course.mp4 | 21.27MB 1. Introduction/8. HR Schema in this Course.vtt | 4.59KB 10. Displaying Data from multiple tables using joins/1. Before You Start, important notes.mp4 | 38.56MB 10. Displaying Data from multiple tables using joins/1. Before You Start, important notes.vtt | 4.88KB 10. Displaying Data from multiple tables using joins/1.1 chapter 10 part 2.sql.sql | 3.74KB 10. Displaying Data from multiple tables using joins/1.2 chapter 10 part 1.sql.sql | 1.72KB 10. Displaying Data from multiple tables using joins/1.3 chapter 10 part 3.sql.sql | 6.13KB 10. Displaying Data from multiple tables using joins/1.4 chapter 10 hints.pdf.pdf | 1.19MB 10. Displaying Data from multiple tables using joins/10. 1999 Syntax USING Clause.mp4 | 12.68MB 10. Displaying Data from multiple tables using joins/10. 1999 Syntax USING Clause.vtt | 3.33KB 10. Displaying Data from multiple tables using joins/11. 1999 Syntax ON Clause.mp4 | 20.28MB 10. Displaying Data from multiple tables using joins/11. 1999 Syntax ON Clause.vtt | 7.56KB 10. Displaying Data from multiple tables using joins/12. 1999 Syntax LeftRightfull Outer Join.mp4 | 22.52MB 10. Displaying Data from multiple tables using joins/12. 1999 Syntax LeftRightfull Outer Join.vtt | 8.04KB 10. Displaying Data from multiple tables using joins/2. HR Tables Diagram, Joins Clarification.mp4 | 12.67MB 10. Displaying Data from multiple tables using joins/2. HR Tables Diagram, Joins Clarification.vtt | 5.78KB 10. Displaying Data from multiple tables using joins/3. What is Cartesian product.mp4 | 18.22MB 10. Displaying Data from multiple tables using joins/3. What is Cartesian product.vtt | 4.83KB 10. Displaying Data from multiple tables using joins/4. Old Joins Equijoin.mp4 | 20.44MB 10. Displaying Data from multiple tables using joins/4. Old Joins Equijoin.vtt | 7.91KB 10. Displaying Data from multiple tables using joins/5. Old Joins nonEquijoins.mp4 | 24.47MB 10. Displaying Data from multiple tables using joins/5. Old Joins nonEquijoins.vtt | 8.20KB 10. Displaying Data from multiple tables using joins/6. Old Joins outer join.mp4 | 20.86MB 10. Displaying Data from multiple tables using joins/6. Old Joins outer join.vtt | 8.00KB 10. Displaying Data from multiple tables using joins/7. Old Joins Self Join and More Practices.mp4 | 20.00MB 10. Displaying Data from multiple tables using joins/7. Old Joins Self Join and More Practices.vtt | 9.52KB 10. Displaying Data from multiple tables using joins/8. 1999 Syntax Cross Join (Cartesian product ).mp4 | 14.60MB 10. Displaying Data from multiple tables using joins/8. 1999 Syntax Cross Join (Cartesian product ).vtt | 3.57KB 10. Displaying Data from multiple tables using joins/9. 1999 Syntax Natural Join.mp4 | 26.24MB 10. Displaying Data from multiple tables using joins/9. 1999 Syntax Natural Join.vtt | 6.87KB 11. Using Subqueries to Solve Queries/1. Single row Subqueries.mp4 | 21.26MB 11. Using Subqueries to Solve Queries/1. Single row Subqueries.vtt | 9.14KB 11. Using Subqueries to Solve Queries/1.1 chapter 11 hints.pdf.pdf | 483.91KB 11. Using Subqueries to Solve Queries/1.2 chapter 11 sql.sql.sql | 4.18KB 11. Using Subqueries to Solve Queries/2. Multiple rows Subqueries.mp4 | 17.57MB 11. Using Subqueries to Solve Queries/2. Multiple rows Subqueries.vtt | 6.23KB 11. Using Subqueries to Solve Queries/3. NULL values and Subqueries.mp4 | 15.92MB 11. Using Subqueries to Solve Queries/3. NULL values and Subqueries.vtt | 4.32KB 11. Using Subqueries to Solve Queries/4. Exists and not Exists.mp4 | 13.41MB 11. Using Subqueries to Solve Queries/4. Exists and not Exists.vtt | 4.21KB 12. Using the Set Operators/1. Overview (Union, union all, intersect, minus ).mp4 | 11.69MB 12. Using the Set Operators/1. Overview (Union, union all, intersect, minus ).vtt | 4.19KB 12. Using the Set Operators/1.1 chapter 12 hints.pdf.pdf | 469.32KB 12. Using the Set Operators/1.2 chapter 12.sql.sql | 2.93KB 12. Using the Set Operators/2. Practice (Union, union all, intersect, minus ).mp4 | 26.83MB 12. Using the Set Operators/2. Practice (Union, union all, intersect, minus ).vtt | 12.77KB 13. Managing tables using DML Statments/1. Introduction to DML.mp4 | 10.94MB 13. Managing tables using DML Statments/1. Introduction to DML.vtt | 5.18KB 13. Managing tables using DML Statments/1.1 chapter 13 hints.pdf.pdf | 2.01MB 13. Managing tables using DML Statments/1.2 chapter 13 part 2 update.sql.sql | 2.19KB 13. Managing tables using DML Statments/1.3 chapter 13 part 3 delete.sql.sql | 1.08KB 13. Managing tables using DML Statments/1.4 lesson 13 last part.sql.sql | 6.32KB 13. Managing tables using DML Statments/1.5 chapter 13 part 1 insert.sql.sql | 3.58KB 13. Managing tables using DML Statments/10. ROW Lock.mp4 | 10.56MB 13. Managing tables using DML Statments/10. ROW Lock.vtt | 3.85KB 13. Managing tables using DML Statments/11. FOR UPDATE Clause.mp4 | 19.40MB 13. Managing tables using DML Statments/11. FOR UPDATE Clause.vtt | 8.31KB 13. Managing tables using DML Statments/2. Insert Statement.mp4 | 33.20MB 13. Managing tables using DML Statments/2. Insert Statement.vtt | 14.18KB 13. Managing tables using DML Statments/3. Inserting common errors.mp4 | 14.59MB 13. Managing tables using DML Statments/3. Inserting common errors.vtt | 4.46KB 13. Managing tables using DML Statments/4. Update Statement.mp4 | 33.62MB 13. Managing tables using DML Statments/4. Update Statement.vtt | 13.66KB 13. Managing tables using DML Statments/5. Delete Statement.mp4 | 33.22MB 13. Managing tables using DML Statments/5. Delete Statement.vtt | 11.00KB 13. Managing tables using DML Statments/6. What is Database Transactions.mp4 | 16.78MB 13. Managing tables using DML Statments/6. What is Database Transactions.vtt | 4.11KB 13. Managing tables using DML Statments/7. About Commit & Rollback.mp4 | 18.80MB 13. Managing tables using DML Statments/7. About Commit & Rollback.vtt | 5.89KB 13. Managing tables using DML Statments/8. Practice ( Commit and rollback ).mp4 | 25.98MB 13. Managing tables using DML Statments/8. Practice ( Commit and rollback ).vtt | 10.45KB 13. Managing tables using DML Statments/9. SAVEPOINT.mp4 | 12.05MB 13. Managing tables using DML Statments/9. SAVEPOINT.vtt | 5.03KB 14. Introduction to Data Definition Language/1. DDL & Naming Rules.mp4 | 20.69MB 14. Introduction to Data Definition Language/1. DDL & Naming Rules.vtt | 7.61KB 14. Introduction to Data Definition Language/1.1 chapter 14 hints.pdf.pdf | 2.66MB 14. Introduction to Data Definition Language/1.2 chapter 14 sql part 3.sql.sql | 357B 14. Introduction to Data Definition Language/1.3 chapter 14 sql part 2.sql.sql | 3.95KB 14. Introduction to Data Definition Language/1.4 chapter 14 sql part 1.sql.sql | 6.10KB 14. Introduction to Data Definition Language/10. Create Table AS subquery.mp4 | 18.63MB 14. Introduction to Data Definition Language/10. Create Table AS subquery.vtt | 6.99KB 14. Introduction to Data Definition Language/11. Alter Table Add Columns.mp4 | 22.43MB 14. Introduction to Data Definition Language/11. Alter Table Add Columns.vtt | 9.36KB 14. Introduction to Data Definition Language/12. Alter Table Modify Columns.mp4 | 19.30MB 14. Introduction to Data Definition Language/12. Alter Table Modify Columns.vtt | 9.24KB 14. Introduction to Data Definition Language/13. Alter Table Drop Columns.mp4 | 18.17MB 14. Introduction to Data Definition Language/13. Alter Table Drop Columns.vtt | 6.26KB 14. Introduction to Data Definition Language/14. Alter Table Set Unused.mp4 | 17.76MB 14. Introduction to Data Definition Language/14. Alter Table Set Unused.vtt | 5.72KB 14. Introduction to Data Definition Language/15. ALTER TABLE READ ONLY READ write.mp4 | 17.06MB 14. Introduction to Data Definition Language/15. ALTER TABLE READ ONLY READ write.vtt | 3.87KB 14. Introduction to Data Definition Language/16. Drop Table.mp4 | 15.68MB 14. Introduction to Data Definition Language/16. Drop Table.vtt | 7.14KB 14. Introduction to Data Definition Language/17. Rename Column Rename Table.mp4 | 9.24MB 14. Introduction to Data Definition Language/17. Rename Column Rename Table.vtt | 3.24KB 14. Introduction to Data Definition Language/2. Data Types Part 1.mp4 | 16.12MB 14. Introduction to Data Definition Language/2. Data Types Part 1.vtt | 6.34KB 14. Introduction to Data Definition Language/3. Data Types Part 2.mp4 | 13.39MB 14. Introduction to Data Definition Language/3. Data Types Part 2.vtt | 5.17KB 14. Introduction to Data Definition Language/4. Creating Tables (without constraints).mp4 | 21.97MB 14. Introduction to Data Definition Language/4. Creating Tables (without constraints).vtt | 9.68KB 14. Introduction to Data Definition Language/5. Types of constraints and why we use it.mp4 | 16.30MB 14. Introduction to Data Definition Language/5. Types of constraints and why we use it.vtt | 6.99KB 14. Introduction to Data Definition Language/6. Creating Tables ( Column Level Constraints ).mp4 | 32.22MB 14. Introduction to Data Definition Language/6. Creating Tables ( Column Level Constraints ).vtt | 12.28KB 14. Introduction to Data Definition Language/7. Creating Tables ( Table Level Constraints ).mp4 | 14.68MB 14. Introduction to Data Definition Language/7. Creating Tables ( Table Level Constraints ).vtt | 6.07KB 14. Introduction to Data Definition Language/8. Constraints Guidelines.mp4 | 17.75MB 14. Introduction to Data Definition Language/8. Constraints Guidelines.vtt | 5.71KB 14. Introduction to Data Definition Language/9. ON DELETE cascade ON DELETE set null.mp4 | 18.48MB 14. Introduction to Data Definition Language/9. ON DELETE cascade ON DELETE set null.vtt | 7.28KB 15. Tips you Should know/1. Tips you Should know Part 1.mp4 | 16.28MB 15. Tips you Should know/1. Tips you Should know Part 1.vtt | 5.98KB 15. Tips you Should know/1.1 chapter 15 tips.sql.sql | 6.57KB 15. Tips you Should know/2. Tips you Should know Part 2.mp4 | 5.38MB 15. Tips you Should know/2. Tips you Should know Part 2.vtt | 2.66KB 15. Tips you Should know/3. Tips you Should know Part 3.mp4 | 14.76MB 15. Tips you Should know/3. Tips you Should know Part 3.vtt | 6.63KB 15. Tips you Should know/4. Tips you Should know Part 4.mp4 | 11.94MB 15. Tips you Should know/4. Tips you Should know Part 4.vtt | 4.98KB 15. Tips you Should know/5. Tips you Should know Part 5.mp4 | 11.54MB 15. Tips you Should know/5. Tips you Should know Part 5.vtt | 4.74KB 15. Tips you Should know/6. Tips you Should know Part 6.mp4 | 15.67MB 15. Tips you Should know/6. Tips you Should know Part 6.vtt | 6.01KB 16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/1. About Exam 1Z0-061 Visiting Oracle Website.mp4 | 22.08MB 16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/1. About Exam 1Z0-061 Visiting Oracle Website.vtt | 7.04KB 16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/2. My recommendations.mp4 | 15.24MB 16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/2. My recommendations.vtt | 3.47KB 17. Introduction to Data Dictionary Views/1. What is Data Dictionary Views.mp4 | 16.32MB 17. Introduction to Data Dictionary Views/1. What is Data Dictionary Views.vtt | 6.74KB 17. Introduction to Data Dictionary Views/1.1 chapter 17.sql.sql | 3.75KB 17. Introduction to Data Dictionary Views/1.2 chapter 17 hints.pdf.pdf | 1.38MB 17. Introduction to Data Dictionary Views/2. What is DICTIONARY.mp4 | 10.49MB 17. Introduction to Data Dictionary Views/2. What is DICTIONARY.vtt | 3.15KB 17. Introduction to Data Dictionary Views/3. USER_OBJECTS ALL_OBJECTS.mp4 | 18.28MB 17. Introduction to Data Dictionary Views/3. USER_OBJECTS ALL_OBJECTS.vtt | 8.31KB 17. Introduction to Data Dictionary Views/4. USER_TABLES ALL_TABLES USER_TAB_COLUMNS.mp4 | 19.31MB 17. Introduction to Data Dictionary Views/4. USER_TABLES ALL_TABLES USER_TAB_COLUMNS.vtt | 6.00KB 17. Introduction to Data Dictionary Views/5. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 1.mp4 | 14.81MB 17. Introduction to Data Dictionary Views/5. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 1.vtt | 5.20KB 17. Introduction to Data Dictionary Views/6. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 2.mp4 | 38.30MB 17. Introduction to Data Dictionary Views/6. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 2.vtt | 15.56KB 17. Introduction to Data Dictionary Views/7. COMMENT ON TABLE COLUMN.mp4 | 14.88MB 17. Introduction to Data Dictionary Views/7. COMMENT ON TABLE COLUMN.vtt | 5.08KB 18. Creating sequences, synonyms, and indexes/1. Sequences Part 1.mp4 | 17.63MB 18. Creating sequences, synonyms, and indexes/1. Sequences Part 1.vtt | 5.31KB 18. Creating sequences, synonyms, and indexes/1.1 chapter 18 part 1.sql.sql | 3.65KB 18. Creating sequences, synonyms, and indexes/1.2 chapter 18 part 3.sql.sql | 3.26KB 18. Creating sequences, synonyms, and indexes/1.3 chapter 18 hints.pdf.pdf | 1.17MB 18. Creating sequences, synonyms, and indexes/1.4 chapter 18 part 2.sql.sql | 622B 18. Creating sequences, synonyms, and indexes/2. Sequences Part 2.mp4 | 16.79MB 18. Creating sequences, synonyms, and indexes/2. Sequences Part 2.vtt | 6.02KB 18. Creating sequences, synonyms, and indexes/3. Sequences Part 3.mp4 | 18.28MB 18. Creating sequences, synonyms, and indexes/3. Sequences Part 3.vtt | 8.91KB 18. Creating sequences, synonyms, and indexes/4. Sequences Part 4.mp4 | 33.07MB 18. Creating sequences, synonyms, and indexes/4. Sequences Part 4.vtt | 14.48KB 18. Creating sequences, synonyms, and indexes/5. Creating Synonyms.mp4 | 17.81MB 18. Creating sequences, synonyms, and indexes/5. Creating Synonyms.vtt | 5.68KB 18. Creating sequences, synonyms, and indexes/6. Creating Indexes Part 1.mp4 | 41.88MB 18. Creating sequences, synonyms, and indexes/6. Creating Indexes Part 1.vtt | 17.14KB 18. Creating sequences, synonyms, and indexes/7. Creating Indexes Part 2.mp4 | 25.67MB 18. Creating sequences, synonyms, and indexes/7. Creating Indexes Part 2.vtt | 7.85KB 19. Creating Views/1. What is a View What is the benefits of Views.mp4 | 13.17MB 19. Creating Views/1. What is a View What is the benefits of Views.vtt | 5.66KB 19. Creating Views/1.1 chapter 19.sql.sql | 4.58KB 19. Creating Views/1.2 chapter 19 hints.pdf.pdf | 772.52KB 19. Creating Views/2. Creating Simple Views.mp4 | 19.24MB 19. Creating Views/2. Creating Simple Views.vtt | 8.20KB 19. Creating Views/3. Creating Complex Views.mp4 | 21.79MB 19. Creating Views/3. Creating Complex Views.vtt | 8.55KB 19. Creating Views/4. With READ ONLY With check option Force view.mp4 | 20.54MB 19. Creating Views/4. With READ ONLY With check option Force view.vtt | 8.05KB 2. Live SQL & Download Install/1. Oracle Live SQL No Installation for anything.mp4 | 35.91MB 2. Live SQL & Download Install/1. Oracle Live SQL No Installation for anything.vtt | 8.75KB 2. Live SQL & Download Install/2. Oracle Live SQL limitation.html | 714B 2. Live SQL & Download Install/3. Downloading Oracle DB 12c.mp4 | 17.77MB 2. Live SQL & Download Install/3. Downloading Oracle DB 12c.vtt | 3.58KB 2. Live SQL & Download Install/4. Installing Oracle DB 12c.mp4 | 25.61MB 2. Live SQL & Download Install/4. Installing Oracle DB 12c.vtt | 8.63KB 2. Live SQL & Download Install/5. About oracle 11g express edition.html | 478B 20. Managing Schema Objects/1. Adding constraints dropping constraints.mp4 | 36.49MB 20. Managing Schema Objects/1. Adding constraints dropping constraints.vtt | 16.33KB 20. Managing Schema Objects/1.1 chapter 20 part 1.sql.sql | 4.83KB 20. Managing Schema Objects/1.2 chapter 20 part 3.sql.sql | 3.07KB 20. Managing Schema Objects/1.3 chapter 20 part 2.sql.sql | 2.59KB 20. Managing Schema Objects/2. Rename Column Rename Constraint.mp4 | 8.36MB 20. Managing Schema Objects/2. Rename Column Rename Constraint.vtt | 3.56KB 20. Managing Schema Objects/3. Enable Disable Constraints.mp4 | 21.47MB 20. Managing Schema Objects/3. Enable Disable Constraints.vtt | 7.45KB 20. Managing Schema Objects/4. Understanding DEFERRABLE Constraints.mp4 | 19.87MB 20. Managing Schema Objects/4. Understanding DEFERRABLE Constraints.vtt | 3.47KB 20. Managing Schema Objects/5. DEFERRABLE Constraints Exercises.mp4 | 21.91MB 20. Managing Schema Objects/5. DEFERRABLE Constraints Exercises.vtt | 11.19KB 20. Managing Schema Objects/6. GLOBAL TEMPORARY TABLE.mp4 | 14.21MB 20. Managing Schema Objects/6. GLOBAL TEMPORARY TABLE.vtt | 4.97KB 20. Managing Schema Objects/7. About SQLLoader.mp4 | 34.86MB 20. Managing Schema Objects/7. About SQLLoader.vtt | 11.38KB 20. Managing Schema Objects/7.1 emp.csv.csv | 498.12KB 20. Managing Schema Objects/8. External Tables Part 1.mp4 | 21.80MB 20. Managing Schema Objects/8. External Tables Part 1.vtt | 8.91KB 20. Managing Schema Objects/9. External Tables Part 2.mp4 | 17.09MB 20. Managing Schema Objects/9. External Tables Part 2.vtt | 7.24KB 21. Retrieving Data By Using Subqueries/1. Using the subquery as a source table.mp4 | 23.48MB 21. Retrieving Data By Using Subqueries/1. Using the subquery as a source table.vtt | 9.20KB 21. Retrieving Data By Using Subqueries/1.1 chapter 21 part 1.sql.sql | 3.71KB 21. Retrieving Data By Using Subqueries/1.2 chapter 21 part 2.sql.sql | 2.22KB 21. Retrieving Data By Using Subqueries/1.3 chapter 21 hints.pdf.pdf | 106.77KB 21. Retrieving Data By Using Subqueries/1.4 chapter 21 part 3.sql.sql | 2.62KB 21. Retrieving Data By Using Subqueries/2. Pairwise Non Pairwise Subqueries.mp4 | 17.67MB 21. Retrieving Data By Using Subqueries/2. Pairwise Non Pairwise Subqueries.vtt | 6.64KB 21. Retrieving Data By Using Subqueries/3. Scalar Subquery Correlated Subquery.mp4 | 22.75MB 21. Retrieving Data By Using Subqueries/3. Scalar Subquery Correlated Subquery.vtt | 9.76KB 21. Retrieving Data By Using Subqueries/4. Reminder of Exists Not Exists.mp4 | 22.15MB 21. Retrieving Data By Using Subqueries/4. Reminder of Exists Not Exists.vtt | 5.05KB 21. Retrieving Data By Using Subqueries/5. WITH Clause.mp4 | 32.95MB 21. Retrieving Data By Using Subqueries/5. WITH Clause.vtt | 13.11KB 22. Manipulating Data By Using Subqueries/1. Inserting Updating Deleting Using a subquery as a target.mp4 | 20.32MB 22. Manipulating Data By Using Subqueries/1. Inserting Updating Deleting Using a subquery as a target.vtt | 8.51KB 22. Manipulating Data By Using Subqueries/1.1 chapter 22 hints.pdf.pdf | 105.08KB 22. Manipulating Data By Using Subqueries/1.2 chapter 22.sql.sql | 2.97KB 22. Manipulating Data By Using Subqueries/2. Correlated Update Correlated Delete.mp4 | 25.73MB 22. Manipulating Data By Using Subqueries/2. Correlated Update Correlated Delete.vtt | 9.42KB 23. Controlling User Access/1. Database Security System Privileges & Roles.mp4 | 24.26MB 23. Controlling User Access/1. Database Security System Privileges & Roles.vtt | 11.55KB 23. Controlling User Access/1.1 chapter 23 part 1.sql.sql | 1.19KB 23. Controlling User Access/1.2 chapter 23 hints.pdf.pdf | 1.04MB 23. Controlling User Access/1.3 chapter 23 part 2.sql.sql | 1.39KB 23. Controlling User Access/1.4 chapter 23 part 3.sql.sql | 706B 23. Controlling User Access/1.5 chapter 23 part 5.sql.sql | 587B 23. Controlling User Access/1.6 chapter 23 part 4.sql.sql | 466B 23. Controlling User Access/2. Database Security Object Privileges.mp4 | 22.36MB 23. Controlling User Access/2. Database Security Object Privileges.vtt | 8.91KB 23. Controlling User Access/3. System Privileges & Privileges Practice 1.mp4 | 23.09MB 23. Controlling User Access/3. System Privileges & Privileges Practice 1.vtt | 10.11KB 23. Controlling User Access/4. System Privileges & Privileges Practice 2.mp4 | 25.75MB 23. Controlling User Access/4. System Privileges & Privileges Practice 2.vtt | 11.08KB 23. Controlling User Access/5. Creating ROLE Practice.mp4 | 30.46MB 23. Controlling User Access/5. Creating ROLE Practice.vtt | 12.75KB 23. Controlling User Access/6. With Grant Option.mp4 | 18.04MB 23. Controlling User Access/6. With Grant Option.vtt | 7.91KB 23. Controlling User Access/7. Drop user Statement.mp4 | 13.91MB 23. Controlling User Access/7. Drop user Statement.vtt | 3.89KB 24. Manipulating Data/1. What is Data Warehouse.mp4 | 9.20MB 24. Manipulating Data/1. What is Data Warehouse.vtt | 3.04KB 24. Manipulating Data/1.1 chapter 24 part 2.sql.sql | 2.32KB 24. Manipulating Data/1.2 chapter 24 part 3.sql.sql | 2.03KB 24. Manipulating Data/1.3 chapter 24 hints.pdf.pdf | 548.14KB 24. Manipulating Data/1.4 chapter 24 part 1.sql.sql | 3.45KB 24. Manipulating Data/2. Explicit default value in insert & update statement.mp4 | 10.73MB 24. Manipulating Data/2. Explicit default value in insert & update statement.vtt | 4.50KB 24. Manipulating Data/3. Copy rows from another table.mp4 | 8.61MB 24. Manipulating Data/3. Copy rows from another table.vtt | 3.26KB 24. Manipulating Data/4. INSERT ALL statement INSERT FIRST.mp4 | 28.28MB 24. Manipulating Data/4. INSERT ALL statement INSERT FIRST.vtt | 11.51KB 24. Manipulating Data/5. Another INSERT ALL Example & Notes.mp4 | 18.83MB 24. Manipulating Data/5. Another INSERT ALL Example & Notes.vtt | 6.14KB 24. Manipulating Data/6. Creating Matrix Report Using PIVOT.mp4 | 17.06MB 24. Manipulating Data/6. Creating Matrix Report Using PIVOT.vtt | 7.25KB 24. Manipulating Data/7. The Merge Statement.mp4 | 12.19MB 24. Manipulating Data/7. The Merge Statement.vtt | 6.28KB 24. Manipulating Data/8. FLASHBACK Table & System change Number ( SCN).mp4 | 27.82MB 24. Manipulating Data/8. FLASHBACK Table & System change Number ( SCN).vtt | 10.58KB 25. Managing Data in Different Time Zones/1. THE INTERVAL ( YEAR TO MONTH day TO second).mp4 | 18.61MB 25. Managing Data in Different Time Zones/1. THE INTERVAL ( YEAR TO MONTH day TO second).vtt | 6.36KB 25. Managing Data in Different Time Zones/1.1 chapter 25.sql.sql | 5.21KB 25. Managing Data in Different Time Zones/1.2 chapter 25 hints.pdf.pdf | 279.70KB 25. Managing Data in Different Time Zones/2. to_yminterval to_dsinterval.mp4 | 9.31MB 25. Managing Data in Different Time Zones/2. to_yminterval to_dsinterval.vtt | 4.44KB 25. Managing Data in Different Time Zones/3. Extract function.mp4 | 4.93MB 25. Managing Data in Different Time Zones/3. Extract function.vtt | 2.38KB 25. Managing Data in Different Time Zones/4. timestamp timestamp with time zone.mp4 | 10.88MB 25. Managing Data in Different Time Zones/4. timestamp timestamp with time zone.vtt | 5.17KB 25. Managing Data in Different Time Zones/5. V$TIMEZONE_NAMES and some functions.mp4 | 19.07MB 25. Managing Data in Different Time Zones/5. V$TIMEZONE_NAMES and some functions.vtt | 9.83KB 25. Managing Data in Different Time Zones/6. timestamp with local time zone.mp4 | 11.81MB 25. Managing Data in Different Time Zones/6. timestamp with local time zone.vtt | 4.47KB 25. Managing Data in Different Time Zones/7. TZ_OFFSET FROM_TZ TO_TIMESTAMP.mp4 | 12.22MB 25. Managing Data in Different Time Zones/7. TZ_OFFSET FROM_TZ TO_TIMESTAMP.vtt | 3.85KB 26. Exam 1Z0-071 for SQL Certified Associate/1. About the Exam 1Z0-071.mp4 | 18.44MB 26. Exam 1Z0-071 for SQL Certified Associate/1. About the Exam 1Z0-071.vtt | 6.37KB 26. Exam 1Z0-071 for SQL Certified Associate/2. Some helpful websites contains exams Dumps.mp4 | 29.86MB 26. Exam 1Z0-071 for SQL Certified Associate/2. Some helpful websites contains exams Dumps.vtt | 5.97KB 26. Exam 1Z0-071 for SQL Certified Associate/3. EXAM 1z0-071 Sample Questions.html | 96B 26. Exam 1Z0-071 for SQL Certified Associate/3.1 EXAM 1z0-071 sample.pdf.pdf | 1.70MB 27. Bonus Section/1. Using SELECT statement to create dynamic scripts.mp4 | 18.78MB 27. Bonus Section/1. Using SELECT statement to create dynamic scripts.vtt | 4.33KB 27. Bonus Section/1.1 Using SELECT statement to create dynamic scripts.sql.sql | 357B 27. Bonus Section/2. Installing oracle 11g express edition.mp4 | 36.90MB 27. Bonus Section/2. Installing oracle 11g express edition.vtt | 9.29KB 27. Bonus Section/3. Rownum and rowid.mp4 | 16.32MB 27. Bonus Section/3. Rownum and rowid.vtt | 5.71KB 27. Bonus Section/4. About PLSQL.mp4 | 31.45MB 27. Bonus Section/4. About PLSQL.vtt | 11.85KB 27. Bonus Section/5. Understanding NULLS when used with ( IN NOT IN ).html | 1.91KB 27. Bonus Section/6. permanent solution for ORA-01033 oracle initialization or shutdown in progress.html | 942B 27. Bonus Section/7. DML logs using package dbms_errlog.mp4 | 90.21MB 27. Bonus Section/7. DML logs using package dbms_errlog.vtt | 8.17KB 27. Bonus Section/7.1 dbms_errlog.sql.sql | 480B 28. What next it is time for PLSQL/1. Move your skills to PLSQL.html | 1.26KB 28. What next it is time for PLSQL/2. Move your skills to Oracle Analytic Functions In-Depth & Advanced Oracle SQL.html | 702B 3. Connecting to the Database/1. Connecting SYS using SQL plus & SQL Developer.mp4 | 31.64MB 3. Connecting to the Database/1. Connecting SYS using SQL plus & SQL Developer.vtt | 10.31KB 3. Connecting to the Database/1.1 steps to unlock hr.sql.sql | 320B 3. Connecting to the Database/2. if you do not remember the sys password.html | 52B 3. Connecting to the Database/3. Unlock HR Account Part 1.mp4 | 16.04MB 3. Connecting to the Database/3. Unlock HR Account Part 1.vtt | 4.06KB 3. Connecting to the Database/4. Unlock HR Account Part 2.mp4 | 38.43MB 3. Connecting to the Database/4. Unlock HR Account Part 2.vtt | 9.74KB 3. Connecting to the Database/5. ORA-01033 oracle initialization or shutdown in progress 12c.mp4 | 20.60MB 3. Connecting to the Database/5. ORA-01033 oracle initialization or shutdown in progress 12c.vtt | 3.29KB 3. Connecting to the Database/6. ORA-65054 Cannot open a pluggable database in the desired mode.html | 573B 3. Connecting to the Database/7. Creating new pluggable database contains HR user.html | 211B 3. Connecting to the Database/7.1 Creating new pluggable database contains HR user.pdf.pdf | 1021.40KB 4. Retrieving data using the select statement/1. Navigate HR schema.mp4 | 29.63MB 4. Retrieving data using the select statement/1. Navigate HR schema.vtt | 6.44KB 4. Retrieving data using the select statement/1.1 Capabilities of SQL select statement .pdf.pdf | 167.50KB 4. Retrieving data using the select statement/1.2 Retrieving data using the select statement.sql.sql | 2.29KB 4. Retrieving data using the select statement/2. Capabilities of SQL SELECT Statements.mp4 | 21.28MB 4. Retrieving data using the select statement/2. Capabilities of SQL SELECT Statements.vtt | 6.92KB 4. Retrieving data using the select statement/3. Arithmetic expressions and NULL values.mp4 | 16.27MB 4. Retrieving data using the select statement/3. Arithmetic expressions and NULL values.vtt | 5.20KB 4. Retrieving data using the select statement/4. Column Alias, Concatenation , Distinct and DESCRIBE.mp4 | 29.94MB 4. Retrieving data using the select statement/4. Column Alias, Concatenation , Distinct and DESCRIBE.vtt | 11.51KB 4. Retrieving data using the select statement/5. Important Notes in Select Statement.mp4 | 23.84MB 4. Retrieving data using the select statement/5. Important Notes in Select Statement.vtt | 4.93KB 5. Restricting and Sorting Data/1. The WHERE Clause & Comparison Operators.mp4 | 39.73MB 5. Restricting and Sorting Data/1. The WHERE Clause & Comparison Operators.vtt | 13.13KB 5. Restricting and Sorting Data/1.1 Restricting and Sorting Data.sql.sql | 8.02KB 5. Restricting and Sorting Data/1.2 chapter 5 hints .pdf.pdf | 199.41KB 5. Restricting and Sorting Data/2. Using Between and IN Like Operators.mp4 | 28.33MB 5. Restricting and Sorting Data/2. Using Between and IN Like Operators.vtt | 10.64KB 5. Restricting and Sorting Data/3. Using IS NULL NOT Not equal Operators.mp4 | 11.94MB 5. Restricting and Sorting Data/3. Using IS NULL NOT Not equal Operators.vtt | 4.53KB 5. Restricting and Sorting Data/4. Logical Operators (AND OR NOT).mp4 | 25.57MB 5. Restricting and Sorting Data/4. Logical Operators (AND OR NOT).vtt | 8.14KB 5. Restricting and Sorting Data/5. Order by Clause.mp4 | 28.05MB 5. Restricting and Sorting Data/5. Order by Clause.vtt | 7.80KB 5. Restricting and Sorting Data/6. The FETCH Clause.mp4 | 27.75MB 5. Restricting and Sorting Data/6. The FETCH Clause.vtt | 7.61KB 6. Substitution Variables/1. What is a Substitution Variables (&).mp4 | 24.39MB 6. Substitution Variables/1. What is a Substitution Variables (&).vtt | 7.32KB 6. Substitution Variables/1.1 Substitution Variables.sql.sql | 2.96KB 6. Substitution Variables/2. DEFINE UNDEFINE.mp4 | 13.35MB 6. Substitution Variables/2. DEFINE UNDEFINE.vtt | 4.99KB 6. Substitution Variables/2.1 Substitution Variables.sql.sql | 2.96KB 6. Substitution Variables/3. ACCEPT PROMPT.mp4 | 16.99MB 6. Substitution Variables/3. ACCEPT PROMPT.vtt | 4.17KB 6. Substitution Variables/4. Double-Ampersand SET VERIFY SET DEFINE.mp4 | 13.54MB 6. Substitution Variables/4. Double-Ampersand SET VERIFY SET DEFINE.vtt | 6.91KB 7. Using Single-Row Functions to Customize Output/1. Single Row Function Introduction.mp4 | 16.45MB 7. Using Single-Row Functions to Customize Output/1. Single Row Function Introduction.vtt | 4.83KB 7. Using Single-Row Functions to Customize Output/1.1 7.1-character functions.sql.sql | 3.25KB 7. Using Single-Row Functions to Customize Output/1.2 chapter 7 hints.pdf.pdf | 730.43KB 7. Using Single-Row Functions to Customize Output/1.3 7.3-date functions.sql.sql | 3.45KB 7. Using Single-Row Functions to Customize Output/1.4 7.2-number functions.sql.sql | 1.24KB 7. Using Single-Row Functions to Customize Output/10. Nesting Functions.mp4 | 15.04MB 7. Using Single-Row Functions to Customize Output/10. Nesting Functions.vtt | 4.57KB 7. Using Single-Row Functions to Customize Output/2. Character functions (Upper, Lower, Initcap ).mp4 | 13.72MB 7. Using Single-Row Functions to Customize Output/2. Character functions (Upper, Lower, Initcap ).vtt | 3.73KB 7. Using Single-Row Functions to Customize Output/3. Character functions (concat, substr, length ).mp4 | 17.90MB 7. Using Single-Row Functions to Customize Output/3. Character functions (concat, substr, length ).vtt | 6.73KB 7. Using Single-Row Functions to Customize Output/4. Character functions ( instr ).mp4 | 11.47MB 7. Using Single-Row Functions to Customize Output/4. Character functions ( instr ).vtt | 4.49KB 7. Using Single-Row Functions to Customize Output/5. Character functions ( lpad, rpad , replace, trim).mp4 | 25.36MB 7. Using Single-Row Functions to Customize Output/5. Character functions ( lpad, rpad , replace, trim).vtt | 10.23KB 7. Using Single-Row Functions to Customize Output/6. Number functions ( Round, Trunc, MOD ).mp4 | 28.98MB 7. Using Single-Row Functions to Customize Output/6. Number functions ( Round, Trunc, MOD ).vtt | 10.33KB 7. Using Single-Row Functions to Customize Output/7. Date Functions ( Sysdate).mp4 | 23.27MB 7. Using Single-Row Functions to Customize Output/7. Date Functions ( Sysdate).vtt | 7.63KB 7. Using Single-Row Functions to Customize Output/8. Date Functions ( months_between, add_months, next_day, last_day).mp4 | 19.61MB 7. Using Single-Row Functions to Customize Output/8. Date Functions ( months_between, add_months, next_day, last_day).vtt | 7.74KB 7. Using Single-Row Functions to Customize Output/9. Date Functions ( round , trunc ).mp4 | 19.80MB 7. Using Single-Row Functions to Customize Output/9. Date Functions ( round , trunc ).vtt | 8.24KB 8. Using Conversion Functions and Conditional Expressions/1. Implicit Data Conversion VS Explicit.mp4 | 16.65MB 8. Using Conversion Functions and Conditional Expressions/1. Implicit Data Conversion VS Explicit.vtt | 6.46KB 8. Using Conversion Functions and Conditional Expressions/1.1 chapter 8 part 1.sql.sql | 3.70KB 8. Using Conversion Functions and Conditional Expressions/1.2 chapter 8 hints.pdf.pdf | 578.31KB 8. Using Conversion Functions and Conditional Expressions/1.3 chapter 8 part 2.sql.sql | 3.86KB 8. Using Conversion Functions and Conditional Expressions/2. TO_CHAR with dates.mp4 | 21.41MB 8. Using Conversion Functions and Conditional Expressions/2. TO_CHAR with dates.vtt | 8.63KB 8. Using Conversion Functions and Conditional Expressions/3. TO_CHAR with numbers.mp4 | 28.88MB 8. Using Conversion Functions and Conditional Expressions/3. TO_CHAR with numbers.vtt | 13.67KB 8. Using Conversion Functions and Conditional Expressions/4. TO_NUMBER , TO_DATE Functions.mp4 | 19.09MB 8. Using Conversion Functions and Conditional Expressions/4. TO_NUMBER , TO_DATE Functions.vtt | 7.80KB 8. Using Conversion Functions and Conditional Expressions/5. nvl , nvl2 , nullif and coalesce Functions.mp4 | 28.01MB 8. Using Conversion Functions and Conditional Expressions/5. nvl , nvl2 , nullif and coalesce Functions.vtt | 11.43KB 8. Using Conversion Functions and Conditional Expressions/6. The CASE Function.mp4 | 30.10MB 8. Using Conversion Functions and Conditional Expressions/6. The CASE Function.vtt | 10.54KB 8. Using Conversion Functions and Conditional Expressions/7. The DECODE Function.mp4 | 20.28MB 8. Using Conversion Functions and Conditional Expressions/7. The DECODE Function.vtt | 6.17KB 9. Reporting Aggregated Data Using the Group Functions/1. Group functions Introduction.mp4 | 15.61MB 9. Reporting Aggregated Data Using the Group Functions/1. Group functions Introduction.vtt | 6.36KB 9. Reporting Aggregated Data Using the Group Functions/1.1 chapter 9.sql.sql | 3.91KB 9. Reporting Aggregated Data Using the Group Functions/1.2 chapter 9 hints.pdf.pdf | 565.67KB 9. Reporting Aggregated Data Using the Group Functions/2. Group functions (sum, count, max, min, avg & more).mp4 | 17.88MB 9. Reporting Aggregated Data Using the Group Functions/2. Group functions (sum, count, max, min, avg & more).vtt | 9.07KB 9. Reporting Aggregated Data Using the Group Functions/3. Group by Clause, Having Clause.mp4 | 30.15MB 9. Reporting Aggregated Data Using the Group Functions/3. Group by Clause, Having Clause.vtt | 10.75KB [FreeCourseLab.com].url | 126B