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