Resource Detail

Go Back Return to Home
[FreeCourseLab.com] Udemy - Oracle Database 12c SQL Certified Associate 1Z0-071
Size 3.39 GB
Files 415
Info Hash: 9624B897B49537A52E3B9FD016F0779A63B7DD0E
Indexed 2019-02-12 09:00:00
Updated 2019-02-12 09:00:00
📂 File List (415)
🎬
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.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.2 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 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.52 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.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.4 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.2 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 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.8 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 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.1 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.3 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.3 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 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.2 KB
🎬
17. Introduction to Data Dictionary Views/6. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 2.mp4
38.3 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 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.2 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 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 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.8 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.2 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 B
💻
23. Controlling User Access/1.5 chapter 23 part 5.sql.sql
587 B
💻
23. Controlling User Access/1.6 chapter 23 part 4.sql.sql
466 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.2 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.5 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.7 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 B
📄
26. Exam 1Z0-071 for SQL Certified Associate/3.1 EXAM 1z0-071 sample.pdf.pdf
1.7 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 B
🎬
27. Bonus Section/2. Installing oracle 11g express edition.mp4
36.9 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 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 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 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 B
💻
3. Connecting to the Database/2. if you do not remember the sys password.html
52 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.6 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 B
💻
3. Connecting to the Database/7. Creating new pluggable database contains HR user.html
211 B
📄
3. Connecting to the Database/7.1 Creating new pluggable database contains HR user.pdf.pdf
1021.4 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.5 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.2 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.8 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.9 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.8 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.7 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.8 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.1 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 B
⬇️ Offline Download

Disclaimer

This website only provides DHT network resource indexing services and does not store any resource files. All resources come from the DHT network, and this site cannot control their content. Please comply with local laws and regulations and use network resources rationally. If there are copyright issues, please contact [email protected].