Resource Detail

Go Back Return to Home
Udemy - Oracle Database SQL Certified Associate 1Z0-071 (5.2024)
Size 5.57 GB
Files 423
Info Hash: 66AF0AB2F112E3C193F0AAC966856CFF6671052E
Indexed 2026-01-13 13:59:19
Updated 2026-01-13 13:59:19
📂 File List (423)
📄
01. Introduction/1. agenda - Copy.xlsx
14.64 KB
🎬
01. Introduction/1. Course Agenda.mp4
19.46 MB
💬
01. Introduction/1. Course Agenda.vtt
6.9 KB
📄
01. Introduction/2. chapter 1 hint.pdf
537.18 KB
🎬
01. Introduction/2. System Development Life Cycle & Database Definition.mp4
7.76 MB
💬
01. Introduction/2. System Development Life Cycle & Database Definition.vtt
3.27 KB
🎬
01. Introduction/3. What is a Table.mp4
5.85 MB
💬
01. Introduction/3. What is a Table.vtt
1.38 KB
🎬
01. Introduction/4. Data Models & ERM.mp4
53.55 MB
💬
01. Introduction/4. Data Models & ERM.vtt
4.28 KB
🎬
01. Introduction/5. About Primary key & foreign key.mp4
17.7 MB
💬
01. Introduction/5. About Primary key & foreign key.vtt
4.17 KB
🎬
01. Introduction/6. SQL and Types of SQL Statements.mp4
21.68 MB
💬
01. Introduction/6. SQL and Types of SQL Statements.vtt
2.72 KB
🎬
01. Introduction/7. Oracle Database 12c Architecture.mp4
15.28 MB
💬
01. Introduction/7. Oracle Database 12c Architecture.vtt
4.37 KB
🎬
01. Introduction/8. HR Schema in this Course.mp4
20.96 MB
💬
01. Introduction/8. HR Schema in this Course.vtt
4.6 KB
💬
02. Live SQL & Download Install/1. Oracle Live SQL No Installation for anything.vtt
8.76 KB
🎬
02. Live SQL & Download Install/1. Oracle Live SQL No Installation for anything.mp4
63.98 MB
💻
02. Live SQL & Download Install/2. Oracle Live SQL limitation.html
873 B
💻
02. Live SQL & Download Install/3. before you install oracle DB.html
609 B
🎬
02. Live SQL & Download Install/4. Downloading Oracle DB 12c.mp4
29.81 MB
💬
02. Live SQL & Download Install/4. Downloading Oracle DB 12c.vtt
3.58 KB
🎬
02. Live SQL & Download Install/5. Installing Oracle DB 12c.mp4
50.54 MB
💬
02. Live SQL & Download Install/5. Installing Oracle DB 12c.vtt
8.63 KB
📄
02. Live SQL & Download Install/6. 18c express.pdf
174.2 KB
💻
02. Live SQL & Download Install/6. About Oracle 18c express edition.html
261 B
💻
02. Live SQL & Download Install/7. About oracle 11g express edition.html
537 B
🎬
03. Connecting to the Database/1. Connecting SYS using SQL plus & SQL Developer.mp4
38.81 MB
💬
03. Connecting to the Database/1. Connecting SYS using SQL plus & SQL Developer.vtt
10.31 KB
💻
03. Connecting to the Database/1. steps to unlock hr.sql
320 B
💻
03. Connecting to the Database/2. if you do not remember the sys password.html
95 B
🎬
03. Connecting to the Database/3. Unlock HR Account Part 1.mp4
15.98 MB
💬
03. Connecting to the Database/3. Unlock HR Account Part 1.vtt
4.06 KB
🎬
03. Connecting to the Database/4. Unlock HR Account Part 2.mp4
47.34 MB
💬
03. Connecting to the Database/4. Unlock HR Account Part 2.vtt
9.75 KB
🎬
03. Connecting to the Database/5. ORA-01033 oracle initialization or shutdown in progress 12c.mp4
29.1 MB
💬
03. Connecting to the Database/5. ORA-01033 oracle initialization or shutdown in progress 12c.vtt
3.29 KB
💻
03. Connecting to the Database/6. ORA-65054 Cannot open a pluggable database in the desired mode.html
624 B
💻
03. Connecting to the Database/7. Creating new pluggable database contains HR user.html
250 B
📄
03. Connecting to the Database/7. Creating new pluggable database contains HR user.pdf
1021.4 KB
📄
04. Retrieving data using the select statement/1. Capabilities of SQL select statement .pdf
167.5 KB
🎬
04. Retrieving data using the select statement/1. Navigate HR schema.mp4
78.61 MB
💬
04. Retrieving data using the select statement/1. Navigate HR schema.vtt
6.44 KB
💻
04. Retrieving data using the select statement/1. Retrieving data using the select statement.sql
2.29 KB
🎬
04. Retrieving data using the select statement/2. Capabilities of SQL SELECT Statements.mp4
41 MB
💬
04. Retrieving data using the select statement/2. Capabilities of SQL SELECT Statements.vtt
6.92 KB
🎬
04. Retrieving data using the select statement/3. Arithmetic expressions and NULL values.mp4
34.61 MB
💬
04. Retrieving data using the select statement/3. Arithmetic expressions and NULL values.vtt
5.21 KB
🎬
04. Retrieving data using the select statement/4. Column Alias, Concatenation , Distinct and DESCRIBE.mp4
61.85 MB
💬
04. Retrieving data using the select statement/4. Column Alias, Concatenation , Distinct and DESCRIBE.vtt
11.52 KB
🎬
04. Retrieving data using the select statement/5. Important Notes in Select Statement.mp4
44.61 MB
💬
04. Retrieving data using the select statement/5. Important Notes in Select Statement.vtt
4.93 KB
📄
05. Restricting and Sorting Data/1. chapter 5 hints .pdf
199.41 KB
💻
05. Restricting and Sorting Data/1. Restricting and Sorting Data.sql
8.02 KB
🎬
05. Restricting and Sorting Data/1. The WHERE Clause & Comparison Operators.mp4
102.51 MB
💬
05. Restricting and Sorting Data/1. The WHERE Clause & Comparison Operators.vtt
13.14 KB
💬
05. Restricting and Sorting Data/2. Using Between and IN Like Operators.vtt
10.65 KB
🎬
05. Restricting and Sorting Data/2. Using Between and IN Like Operators.mp4
41.57 MB
💬
05. Restricting and Sorting Data/3. Using IS NULL NOT Not equal Operators.vtt
4.53 KB
🎬
05. Restricting and Sorting Data/3. Using IS NULL NOT Not equal Operators.mp4
17.77 MB
🎬
05. Restricting and Sorting Data/4. Logical Operators (AND OR NOT).mp4
54.34 MB
💬
05. Restricting and Sorting Data/4. Logical Operators (AND OR NOT).vtt
8.14 KB
🎬
05. Restricting and Sorting Data/5. Order by Clause.mp4
55.44 MB
💬
05. Restricting and Sorting Data/5. Order by Clause.vtt
7.8 KB
🎬
05. Restricting and Sorting Data/6. The FETCH Clause.mp4
65.5 MB
💬
05. Restricting and Sorting Data/6. The FETCH Clause.vtt
7.61 KB
💻
06. Substitution Variables/1. Substitution Variables.sql
2.96 KB
🎬
06. Substitution Variables/1. What is a Substitution Variables (&).mp4
29.14 MB
💬
06. Substitution Variables/1. What is a Substitution Variables (&).vtt
7.32 KB
💬
06. Substitution Variables/2. DEFINE UNDEFINE.vtt
4.99 KB
🎬
06. Substitution Variables/2. DEFINE UNDEFINE.mp4
15.44 MB
💻
06. Substitution Variables/2. Substitution Variables.sql
2.96 KB
💬
06. Substitution Variables/3. ACCEPT PROMPT.vtt
4.17 KB
🎬
06. Substitution Variables/3. ACCEPT PROMPT.mp4
18.25 MB
💬
06. Substitution Variables/4. Double-Ampersand SET VERIFY SET DEFINE.vtt
6.91 KB
🎬
06. Substitution Variables/4. Double-Ampersand SET VERIFY SET DEFINE.mp4
17.71 MB
💻
07. Using Single-Row Functions to Customize Output/1. 7.1-character functions.sql
3.25 KB
💻
07. Using Single-Row Functions to Customize Output/1. 7.2-number functions.sql
1.24 KB
💻
07. Using Single-Row Functions to Customize Output/1. 7.3-date functions.sql
3.45 KB
📄
07. Using Single-Row Functions to Customize Output/1. chapter 7 hints.pdf
730.43 KB
🎬
07. Using Single-Row Functions to Customize Output/1. Single Row Function Introduction.mp4
32.38 MB
💬
07. Using Single-Row Functions to Customize Output/1. Single Row Function Introduction.vtt
4.83 KB
🎬
07. Using Single-Row Functions to Customize Output/10. Nesting Functions.mp4
19.38 MB
💬
07. Using Single-Row Functions to Customize Output/10. Nesting Functions.vtt
4.57 KB
🎬
07. Using Single-Row Functions to Customize Output/2. Character functions (Upper, Lower, Initcap ).mp4
17.08 MB
💬
07. Using Single-Row Functions to Customize Output/2. Character functions (Upper, Lower, Initcap ).vtt
3.73 KB
🎬
07. Using Single-Row Functions to Customize Output/3. Character functions (concat, substr, length ).mp4
43.37 MB
💬
07. Using Single-Row Functions to Customize Output/3. Character functions (concat, substr, length ).vtt
6.73 KB
🎬
07. Using Single-Row Functions to Customize Output/4. Character functions ( instr ).mp4
13.04 MB
💬
07. Using Single-Row Functions to Customize Output/4. Character functions ( instr ).vtt
4.49 KB
🎬
07. Using Single-Row Functions to Customize Output/5. Character functions ( lpad, rpad , replace, trim).mp4
25.36 MB
💬
07. Using Single-Row Functions to Customize Output/5. Character functions ( lpad, rpad , replace, trim).vtt
10.23 KB
🎬
07. Using Single-Row Functions to Customize Output/6. Number functions ( Round, Trunc, MOD ).mp4
35.45 MB
💬
07. Using Single-Row Functions to Customize Output/6. Number functions ( Round, Trunc, MOD ).vtt
10.33 KB
🎬
07. Using Single-Row Functions to Customize Output/7. Date Functions ( Sysdate).mp4
53.7 MB
💬
07. Using Single-Row Functions to Customize Output/7. Date Functions ( Sysdate).vtt
7.63 KB
🎬
07. Using Single-Row Functions to Customize Output/8. Date Functions ( months_between, add_months, next_day, last_day).mp4
33.16 MB
💬
07. Using Single-Row Functions to Customize Output/8. Date Functions ( months_between, add_months, next_day, last_day).vtt
7.74 KB
💬
07. Using Single-Row Functions to Customize Output/9. Date Functions ( round , trunc ).vtt
8.24 KB
🎬
07. Using Single-Row Functions to Customize Output/9. Date Functions ( round , trunc ).mp4
29.63 MB
📄
08. Using Conversion Functions and Conditional Expressions/1. chapter 8 hints.pdf
578.31 KB
💻
08. Using Conversion Functions and Conditional Expressions/1. chapter 8 part 1.sql
3.7 KB
💻
08. Using Conversion Functions and Conditional Expressions/1. chapter 8 part 2.sql
3.86 KB
🎬
08. Using Conversion Functions and Conditional Expressions/1. Implicit Data Conversion VS Explicit.mp4
22.84 MB
💬
08. Using Conversion Functions and Conditional Expressions/1. Implicit Data Conversion VS Explicit.vtt
6.46 KB
💬
08. Using Conversion Functions and Conditional Expressions/2. TO_CHAR with dates.vtt
8.63 KB
🎬
08. Using Conversion Functions and Conditional Expressions/2. TO_CHAR with dates.mp4
57.97 MB
💬
08. Using Conversion Functions and Conditional Expressions/3. TO_CHAR with numbers.vtt
13.67 KB
🎬
08. Using Conversion Functions and Conditional Expressions/3. TO_CHAR with numbers.mp4
64.79 MB
🎬
08. Using Conversion Functions and Conditional Expressions/4. TO_NUMBER , TO_DATE Functions.mp4
40.39 MB
💬
08. Using Conversion Functions and Conditional Expressions/4. TO_NUMBER , TO_DATE Functions.vtt
7.8 KB
💬
08. Using Conversion Functions and Conditional Expressions/5. nvl , nvl2 , nullif and coalesce Functions.vtt
11.43 KB
🎬
08. Using Conversion Functions and Conditional Expressions/5. nvl , nvl2 , nullif and coalesce Functions.mp4
39.39 MB
🎬
08. Using Conversion Functions and Conditional Expressions/6. The CASE Function.mp4
45.95 MB
💬
08. Using Conversion Functions and Conditional Expressions/6. The CASE Function.vtt
10.54 KB
🎬
08. Using Conversion Functions and Conditional Expressions/7. The DECODE Function.mp4
26.42 MB
💬
08. Using Conversion Functions and Conditional Expressions/7. The DECODE Function.vtt
6.3 KB
📄
09. Reporting Aggregated Data Using the Group Functions/1. chapter 9 hints.pdf
565.67 KB
💻
09. Reporting Aggregated Data Using the Group Functions/1. chapter 9.sql
3.91 KB
🎬
09. Reporting Aggregated Data Using the Group Functions/1. Group functions Introduction.mp4
15.6 MB
💬
09. Reporting Aggregated Data Using the Group Functions/1. Group functions Introduction.vtt
6.73 KB
🎬
09. Reporting Aggregated Data Using the Group Functions/2. Group functions (sum, count, max, min, avg & more).mp4
20.64 MB
💬
09. Reporting Aggregated Data Using the Group Functions/2. Group functions (sum, count, max, min, avg & more).vtt
9.12 KB
🎬
09. Reporting Aggregated Data Using the Group Functions/3. Group by Clause, Having Clause.mp4
27.56 MB
💬
09. Reporting Aggregated Data Using the Group Functions/3. Group by Clause, Having Clause.vtt
11.39 KB
🎬
10. Displaying Data from multiple tables using joins/1. Before You Start, important notes.mp4
22.78 MB
💬
10. Displaying Data from multiple tables using joins/1. Before You Start, important notes.vtt
4.97 KB
📄
10. Displaying Data from multiple tables using joins/1. chapter 10 hints.pdf
1.19 MB
💻
10. Displaying Data from multiple tables using joins/1. chapter 10 part 1.sql
1.72 KB
💻
10. Displaying Data from multiple tables using joins/1. chapter 10 part 2.sql
3.74 KB
💻
10. Displaying Data from multiple tables using joins/1. chapter 10 part 3.sql
6.13 KB
🎬
10. Displaying Data from multiple tables using joins/10. 1999 Syntax USING Clause.mp4
22.91 MB
💬
10. Displaying Data from multiple tables using joins/10. 1999 Syntax USING Clause.vtt
3.42 KB
🎬
10. Displaying Data from multiple tables using joins/11. 1999 Syntax ON Clause.mp4
53.82 MB
💬
10. Displaying Data from multiple tables using joins/11. 1999 Syntax ON Clause.vtt
7.85 KB
🎬
10. Displaying Data from multiple tables using joins/12. 1999 Syntax LeftRightfull Outer Join.mp4
21.65 MB
💬
10. Displaying Data from multiple tables using joins/12. 1999 Syntax LeftRightfull Outer Join.vtt
8.2 KB
🎬
10. Displaying Data from multiple tables using joins/2. HR Tables Diagram, Joins Clarification.mp4
26.09 MB
💬
10. Displaying Data from multiple tables using joins/2. HR Tables Diagram, Joins Clarification.vtt
6.12 KB
🎬
10. Displaying Data from multiple tables using joins/3. What is Cartesian product.mp4
33.47 MB
💬
10. Displaying Data from multiple tables using joins/3. What is Cartesian product.vtt
5.12 KB
🎬
10. Displaying Data from multiple tables using joins/4. Old Joins Equijoin.mp4
25.28 MB
💬
10. Displaying Data from multiple tables using joins/4. Old Joins Equijoin.vtt
8.53 KB
🎬
10. Displaying Data from multiple tables using joins/5. Old Joins nonEquijoins.mp4
29.49 MB
💬
10. Displaying Data from multiple tables using joins/5. Old Joins nonEquijoins.vtt
8.28 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.51 KB
🎬
10. Displaying Data from multiple tables using joins/7. Old Joins Self Join and More Practices.mp4
49.53 MB
💬
10. Displaying Data from multiple tables using joins/7. Old Joins Self Join and More Practices.vtt
9.75 KB
🎬
10. Displaying Data from multiple tables using joins/8. 1999 Syntax Cross Join (Cartesian product ).mp4
16.92 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
54.75 MB
💬
10. Displaying Data from multiple tables using joins/9. 1999 Syntax Natural Join.vtt
6.98 KB
📄
11. Using Subqueries to Solve Queries/1. chapter 11 hints.pdf
483.91 KB
💻
11. Using Subqueries to Solve Queries/1. chapter 11 sql.sql
4.18 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.46 KB
🎬
11. Using Subqueries to Solve Queries/2. Multiple rows Subqueries.mp4
27.42 MB
💬
11. Using Subqueries to Solve Queries/2. Multiple rows Subqueries.vtt
6.36 KB
🎬
11. Using Subqueries to Solve Queries/3. NULL values and Subqueries.mp4
31.03 MB
💬
11. Using Subqueries to Solve Queries/3. NULL values and Subqueries.vtt
4.35 KB
🎬
11. Using Subqueries to Solve Queries/4. Exists and not Exists.mp4
17.86 MB
💬
11. Using Subqueries to Solve Queries/4. Exists and not Exists.vtt
4.43 KB
📄
12. Using the Set Operators/1. chapter 12 hints.pdf
469.32 KB
💻
12. Using the Set Operators/1. chapter 12.sql
2.93 KB
🎬
12. Using the Set Operators/1. Overview (Union, union all, intersect, minus ).mp4
15.7 MB
💬
12. Using the Set Operators/1. Overview (Union, union all, intersect, minus ).vtt
4.56 KB
🎬
12. Using the Set Operators/2. Practice (Union, union all, intersect, minus ).mp4
53.77 MB
💬
12. Using the Set Operators/2. Practice (Union, union all, intersect, minus ).vtt
12.96 KB
📄
13. Managing tables using DML Statments/1. chapter 13 hints.pdf
2.01 MB
💻
13. Managing tables using DML Statments/1. chapter 13 part 1 insert.sql
3.58 KB
💻
13. Managing tables using DML Statments/1. chapter 13 part 2 update.sql
2.19 KB
💻
13. Managing tables using DML Statments/1. chapter 13 part 3 delete.sql
1.08 KB
🎬
13. Managing tables using DML Statments/1. Introduction to DML.mp4
17.14 MB
💬
13. Managing tables using DML Statments/1. Introduction to DML.vtt
5.26 KB
💻
13. Managing tables using DML Statments/1. lesson 13 last part.sql
6.32 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.79 KB
🎬
13. Managing tables using DML Statments/11. FOR UPDATE Clause.mp4
35.25 MB
💬
13. Managing tables using DML Statments/11. FOR UPDATE Clause.vtt
8.59 KB
🎬
13. Managing tables using DML Statments/2. Insert Statement.mp4
74.54 MB
💬
13. Managing tables using DML Statments/2. Insert Statement.vtt
14.49 KB
🎬
13. Managing tables using DML Statments/3. Inserting common errors.mp4
16.93 MB
💬
13. Managing tables using DML Statments/3. Inserting common errors.vtt
4.51 KB
🎬
13. Managing tables using DML Statments/4. Update Statement.mp4
72.47 MB
💬
13. Managing tables using DML Statments/4. Update Statement.vtt
13.52 KB
🎬
13. Managing tables using DML Statments/5. Delete Statement.mp4
36.99 MB
💬
13. Managing tables using DML Statments/5. Delete Statement.vtt
11.48 KB
🎬
13. Managing tables using DML Statments/6. What is Database Transactions.mp4
21.19 MB
💬
13. Managing tables using DML Statments/6. What is Database Transactions.vtt
4.34 KB
🎬
13. Managing tables using DML Statments/7. About Commit & Rollback.mp4
42.03 MB
💬
13. Managing tables using DML Statments/7. About Commit & Rollback.vtt
6.11 KB
🎬
13. Managing tables using DML Statments/8. Practice ( Commit and rollback ).mp4
35.36 MB
💬
13. Managing tables using DML Statments/8. Practice ( Commit and rollback ).vtt
10.61 KB
🎬
13. Managing tables using DML Statments/9. SAVEPOINT.mp4
21.05 MB
💬
13. Managing tables using DML Statments/9. SAVEPOINT.vtt
4.57 KB
📄
14. Introduction to Data Definition Language/1. chapter 14 hints.pdf
2.66 MB
💻
14. Introduction to Data Definition Language/1. chapter 14 sql part 1.sql
6.1 KB
💻
14. Introduction to Data Definition Language/1. chapter 14 sql part 2.sql
3.95 KB
💻
14. Introduction to Data Definition Language/1. chapter 14 sql part 3.sql
357 B
🎬
14. Introduction to Data Definition Language/1. DDL & Naming Rules.mp4
25.79 MB
💬
14. Introduction to Data Definition Language/1. DDL & Naming Rules.vtt
8.14 KB
🎬
14. Introduction to Data Definition Language/10. Create Table AS subquery.mp4
26.81 MB
💬
14. Introduction to Data Definition Language/10. Create Table AS subquery.vtt
7.19 KB
🎬
14. Introduction to Data Definition Language/11. Alter Table Add Columns.mp4
47.63 MB
💬
14. Introduction to Data Definition Language/11. Alter Table Add Columns.vtt
9.67 KB
🎬
14. Introduction to Data Definition Language/12. Alter Table Modify Columns.mp4
27.46 MB
💬
14. Introduction to Data Definition Language/12. Alter Table Modify Columns.vtt
9.45 KB
🎬
14. Introduction to Data Definition Language/13. Alter Table Drop Columns.mp4
38.22 MB
💬
14. Introduction to Data Definition Language/13. Alter Table Drop Columns.vtt
6.62 KB
🎬
14. Introduction to Data Definition Language/14. Alter Table Set Unused.mp4
16.98 MB
💬
14. Introduction to Data Definition Language/14. Alter Table Set Unused.vtt
6.01 KB
💬
14. Introduction to Data Definition Language/15. ALTER TABLE READ ONLY READ write.vtt
4.04 KB
🎬
14. Introduction to Data Definition Language/15. ALTER TABLE READ ONLY READ write.mp4
30.7 MB
🎬
14. Introduction to Data Definition Language/16. Drop Table.mp4
20.64 MB
💬
14. Introduction to Data Definition Language/16. Drop Table.vtt
7.06 KB
💬
14. Introduction to Data Definition Language/17. Rename Column Rename Table.vtt
3.52 KB
🎬
14. Introduction to Data Definition Language/17. Rename Column Rename Table.mp4
8.49 MB
🎬
14. Introduction to Data Definition Language/2. Data Types Part 1.mp4
37.37 MB
💬
14. Introduction to Data Definition Language/2. Data Types Part 1.vtt
6.35 KB
🎬
14. Introduction to Data Definition Language/3. Data Types Part 2.mp4
34.85 MB
💬
14. Introduction to Data Definition Language/3. Data Types Part 2.vtt
5.06 KB
🎬
14. Introduction to Data Definition Language/4. Creating Tables (without constraints).mp4
45.33 MB
💬
14. Introduction to Data Definition Language/4. Creating Tables (without constraints).vtt
9.97 KB
🎬
14. Introduction to Data Definition Language/5. Types of constraints and why we use it.mp4
24.77 MB
💬
14. Introduction to Data Definition Language/5. Types of constraints and why we use it.vtt
7.25 KB
🎬
14. Introduction to Data Definition Language/6. Creating Tables ( Column Level Constraints ).mp4
72.39 MB
💬
14. Introduction to Data Definition Language/6. Creating Tables ( Column Level Constraints ).vtt
12.62 KB
🎬
14. Introduction to Data Definition Language/7. Creating Tables ( Table Level Constraints ).mp4
23.48 MB
💬
14. Introduction to Data Definition Language/7. Creating Tables ( Table Level Constraints ).vtt
6.53 KB
🎬
14. Introduction to Data Definition Language/8. Constraints Guidelines.mp4
36.58 MB
💬
14. Introduction to Data Definition Language/8. Constraints Guidelines.vtt
6.02 KB
💬
14. Introduction to Data Definition Language/9. ON DELETE cascade ON DELETE set null.vtt
7.48 KB
🎬
14. Introduction to Data Definition Language/9. ON DELETE cascade ON DELETE set null.mp4
18.48 MB
💻
15. Tips you Should know/1. chapter 15 tips.sql
6.57 KB
🎬
15. Tips you Should know/1. Tips you Should know Part 1.mp4
21.71 MB
💬
15. Tips you Should know/1. Tips you Should know Part 1.vtt
6.11 KB
🎬
15. Tips you Should know/2. Tips you Should know Part 2.mp4
5.82 MB
💬
15. Tips you Should know/2. Tips you Should know Part 2.vtt
2.87 KB
🎬
15. Tips you Should know/3. Tips you Should know Part 3.mp4
18.69 MB
💬
15. Tips you Should know/3. Tips you Should know Part 3.vtt
6.74 KB
🎬
15. Tips you Should know/4. Tips you Should know Part 4.mp4
16.8 MB
💬
15. Tips you Should know/4. Tips you Should know Part 4.vtt
5.04 KB
🎬
15. Tips you Should know/5. Tips you Should know Part 5.mp4
16.47 MB
💬
15. Tips you Should know/5. Tips you Should know Part 5.vtt
4.94 KB
🎬
15. Tips you Should know/6. Tips you Should know Part 6.mp4
22.25 MB
💬
15. Tips you Should know/6. Tips you Should know Part 6.vtt
6.34 KB
🎬
16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/1. About Exam 1Z0-061 Visiting Oracle Website.mp4
25.2 MB
🎬
16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/2. My recommendations.mp4
10.54 MB
💬
16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/2. My recommendations.vtt
3.59 KB
💻
16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/3. 1Z0-061 retires on 30, Nov 2019.html
454 B
📄
17. Introduction to Data Dictionary Views/1. chapter 17 hints.pdf
1.38 MB
💻
17. Introduction to Data Dictionary Views/1. chapter 17.sql
3.75 KB
🎬
17. Introduction to Data Dictionary Views/1. What is Data Dictionary Views.mp4
27.35 MB
💬
17. Introduction to Data Dictionary Views/1. What is Data Dictionary Views.vtt
6.89 KB
🎬
17. Introduction to Data Dictionary Views/2. What is DICTIONARY.mp4
12.61 MB
💬
17. Introduction to Data Dictionary Views/2. What is DICTIONARY.vtt
3.34 KB
💬
17. Introduction to Data Dictionary Views/3. USER_OBJECTS ALL_OBJECTS.vtt
8.56 KB
🎬
17. Introduction to Data Dictionary Views/3. USER_OBJECTS ALL_OBJECTS.mp4
26.99 MB
💬
17. Introduction to Data Dictionary Views/4. USER_TABLES ALL_TABLES USER_TAB_COLUMNS.vtt
6.05 KB
🎬
17. Introduction to Data Dictionary Views/4. USER_TABLES ALL_TABLES USER_TAB_COLUMNS.mp4
51.68 MB
🎬
17. Introduction to Data Dictionary Views/5. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 1.mp4
21.38 MB
💬
17. Introduction to Data Dictionary Views/5. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 1.vtt
5.46 KB
🎬
17. Introduction to Data Dictionary Views/6. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 2.mp4
66.04 MB
💬
17. Introduction to Data Dictionary Views/6. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 2.vtt
16.08 KB
💬
17. Introduction to Data Dictionary Views/7. COMMENT ON TABLE COLUMN.vtt
5.31 KB
🎬
17. Introduction to Data Dictionary Views/7. COMMENT ON TABLE COLUMN.mp4
11.41 MB
📄
18. Creating sequences, synonyms, and indexes/1. chapter 18 hints.pdf
1.17 MB
💻
18. Creating sequences, synonyms, and indexes/1. chapter 18 part 1.sql
3.65 KB
💻
18. Creating sequences, synonyms, and indexes/1. chapter 18 part 2.sql
622 B
💻
18. Creating sequences, synonyms, and indexes/1. chapter 18 part 3.sql
3.26 KB
🎬
18. Creating sequences, synonyms, and indexes/1. Sequences Part 1.mp4
47.86 MB
💬
18. Creating sequences, synonyms, and indexes/1. Sequences Part 1.vtt
5.66 KB
🎬
18. Creating sequences, synonyms, and indexes/2. Sequences Part 2.mp4
17.35 MB
💬
18. Creating sequences, synonyms, and indexes/2. Sequences Part 2.vtt
6.21 KB
🎬
18. Creating sequences, synonyms, and indexes/3. Sequences Part 3.mp4
19.53 MB
💬
18. Creating sequences, synonyms, and indexes/3. Sequences Part 3.vtt
8.98 KB
🎬
18. Creating sequences, synonyms, and indexes/4. Sequences Part 4.mp4
95.61 MB
💬
18. Creating sequences, synonyms, and indexes/4. Sequences Part 4.vtt
15.06 KB
🎬
18. Creating sequences, synonyms, and indexes/5. Creating Synonyms.mp4
32.58 MB
💬
18. Creating sequences, synonyms, and indexes/5. Creating Synonyms.vtt
5.71 KB
🎬
18. Creating sequences, synonyms, and indexes/6. Creating Indexes Part 1.mp4
106.89 MB
💬
18. Creating sequences, synonyms, and indexes/6. Creating Indexes Part 1.vtt
17.48 KB
🎬
18. Creating sequences, synonyms, and indexes/7. Creating Indexes Part 2.mp4
60.1 MB
💬
18. Creating sequences, synonyms, and indexes/7. Creating Indexes Part 2.vtt
8.19 KB
📄
19. Creating Views/1. chapter 19 hints.pdf
772.52 KB
💻
19. Creating Views/1. chapter 19.sql
4.58 KB
💬
19. Creating Views/1. What is a View What is the benefits of Views.vtt
5.81 KB
🎬
19. Creating Views/1. What is a View What is the benefits of Views.mp4
31.25 MB
🎬
19. Creating Views/2. Creating Simple Views.mp4
48.72 MB
💬
19. Creating Views/2. Creating Simple Views.vtt
8.08 KB
🎬
19. Creating Views/3. Creating Complex Views.mp4
29.07 MB
💬
19. Creating Views/3. Creating Complex Views.vtt
8.65 KB
💬
19. Creating Views/4. With READ ONLY With check option Force view.vtt
8.05 KB
🎬
19. Creating Views/4. With READ ONLY With check option Force view.mp4
28.19 MB
💬
20. Managing Schema Objects/1. Adding constraints dropping constraints.vtt
16.94 KB
🎬
20. Managing Schema Objects/1. Adding constraints dropping constraints.mp4
79.04 MB
💻
20. Managing Schema Objects/1. chapter 20 part 1.sql
4.83 KB
💻
20. Managing Schema Objects/1. chapter 20 part 2.sql
2.59 KB
💻
20. Managing Schema Objects/1. chapter 20 part 3.sql
3.07 KB
💬
20. Managing Schema Objects/2. Rename Column Rename Constraint.vtt
3.53 KB
🎬
20. Managing Schema Objects/2. Rename Column Rename Constraint.mp4
10.78 MB
💬
20. Managing Schema Objects/3. Enable Disable Constraints.vtt
7.49 KB
🎬
20. Managing Schema Objects/3. Enable Disable Constraints.mp4
29.38 MB
🎬
20. Managing Schema Objects/4. Understanding DEFERRABLE Constraints.mp4
49.58 MB
💬
20. Managing Schema Objects/4. Understanding DEFERRABLE Constraints.vtt
3.75 KB
🎬
20. Managing Schema Objects/5. DEFERRABLE Constraints Exercises.mp4
25.57 MB
💬
20. Managing Schema Objects/5. DEFERRABLE Constraints Exercises.vtt
11.31 KB
🎬
20. Managing Schema Objects/6. GLOBAL TEMPORARY TABLE.mp4
18.48 MB
💬
20. Managing Schema Objects/6. GLOBAL TEMPORARY TABLE.vtt
5.19 KB
🎬
20. Managing Schema Objects/7. About SQLLoader.mp4
75.61 MB
💬
20. Managing Schema Objects/7. About SQLLoader.vtt
11.2 KB
📄
20. Managing Schema Objects/7. emp.csv
498.12 KB
🎬
20. Managing Schema Objects/8. External Tables Part 1.mp4
62.24 MB
💬
20. Managing Schema Objects/8. External Tables Part 1.vtt
9.11 KB
🎬
20. Managing Schema Objects/9. External Tables Part 2.mp4
20.69 MB
💬
20. Managing Schema Objects/9. External Tables Part 2.vtt
7.42 KB
📄
21. Retrieving Data By Using Subqueries/1. chapter 21 hints.pdf
106.77 KB
💻
21. Retrieving Data By Using Subqueries/1. chapter 21 part 1.sql
3.71 KB
💻
21. Retrieving Data By Using Subqueries/1. chapter 21 part 2.sql
2.22 KB
💻
21. Retrieving Data By Using Subqueries/1. chapter 21 part 3.sql
2.62 KB
🎬
21. Retrieving Data By Using Subqueries/1. Using the subquery as a source table.mp4
31.22 MB
💬
21. Retrieving Data By Using Subqueries/1. Using the subquery as a source table.vtt
10.15 KB
🎬
21. Retrieving Data By Using Subqueries/2. Pairwise Non Pairwise Subqueries.mp4
43.14 MB
💬
21. Retrieving Data By Using Subqueries/2. Pairwise Non Pairwise Subqueries.vtt
6.71 KB
💬
21. Retrieving Data By Using Subqueries/3. Scalar Subquery Correlated Subquery.vtt
9.91 KB
🎬
21. Retrieving Data By Using Subqueries/3. Scalar Subquery Correlated Subquery.mp4
38.43 MB
💬
21. Retrieving Data By Using Subqueries/4. Reminder of Exists Not Exists.vtt
5.13 KB
🎬
21. Retrieving Data By Using Subqueries/4. Reminder of Exists Not Exists.mp4
19.89 MB
🎬
21. Retrieving Data By Using Subqueries/5. WITH Clause.mp4
32.95 MB
💬
21. Retrieving Data By Using Subqueries/5. WITH Clause.vtt
13.63 KB
📄
22. Manipulating Data By Using Subqueries/1. chapter 22 hints.pdf
105.08 KB
💻
22. Manipulating Data By Using Subqueries/1. chapter 22.sql
2.97 KB
💬
22. Manipulating Data By Using Subqueries/1. Inserting Updating Deleting Using a subquery as a target.vtt
8.91 KB
🎬
22. Manipulating Data By Using Subqueries/1. Inserting Updating Deleting Using a subquery as a target.mp4
18.31 MB
💬
22. Manipulating Data By Using Subqueries/2. Correlated Update Correlated Delete.vtt
9.7 KB
🎬
22. Manipulating Data By Using Subqueries/2. Correlated Update Correlated Delete.mp4
56.72 MB
📄
23. Controlling User Access/1. chapter 23 hints.pdf
1.04 MB
💻
23. Controlling User Access/1. chapter 23 part 1.sql
1.19 KB
💻
23. Controlling User Access/1. chapter 23 part 2.sql
1.39 KB
💻
23. Controlling User Access/1. chapter 23 part 3.sql
706 B
💻
23. Controlling User Access/1. chapter 23 part 4.sql
466 B
💻
23. Controlling User Access/1. chapter 23 part 5.sql
587 B
💬
23. Controlling User Access/1. Database Security System Privileges & Roles.vtt
12.02 KB
🎬
23. Controlling User Access/1. Database Security System Privileges & Roles.mp4
60.3 MB
💬
23. Controlling User Access/2. Database Security Object Privileges.vtt
8.99 KB
🎬
23. Controlling User Access/2. Database Security Object Privileges.mp4
31.71 MB
🎬
23. Controlling User Access/3. System Privileges & Privileges Practice 1.mp4
27.58 MB
💬
23. Controlling User Access/3. System Privileges & Privileges Practice 1.vtt
10.65 KB
🎬
23. Controlling User Access/4. System Privileges & Privileges Practice 2.mp4
42.05 MB
💬
23. Controlling User Access/4. System Privileges & Privileges Practice 2.vtt
11.4 KB
🎬
23. Controlling User Access/5. Creating ROLE Practice.mp4
46.03 MB
💬
23. Controlling User Access/5. Creating ROLE Practice.vtt
12.8 KB
🎬
23. Controlling User Access/6. With Grant Option.mp4
19.11 MB
💬
23. Controlling User Access/6. With Grant Option.vtt
8.58 KB
🎬
23. Controlling User Access/7. Drop user Statement.mp4
8.49 MB
💬
23. Controlling User Access/7. Drop user Statement.vtt
3.92 KB
📄
24. Manipulating Data/1. chapter 24 hints.pdf
548.14 KB
💻
24. Manipulating Data/1. chapter 24 part 1.sql
3.45 KB
💻
24. Manipulating Data/1. chapter 24 part 2.sql
2.32 KB
💻
24. Manipulating Data/1. chapter 24 part 3.sql
2.03 KB
🎬
24. Manipulating Data/1. What is Data Warehouse.mp4
11.67 MB
💬
24. Manipulating Data/1. What is Data Warehouse.vtt
3.16 KB
🎬
24. Manipulating Data/2. Explicit default value in insert & update statement.mp4
15.3 MB
💬
24. Manipulating Data/2. Explicit default value in insert & update statement.vtt
4.62 KB
🎬
24. Manipulating Data/3. Copy rows from another table.mp4
9.31 MB
💬
24. Manipulating Data/3. Copy rows from another table.vtt
3.39 KB
💬
24. Manipulating Data/4. INSERT ALL statement INSERT FIRST.vtt
12.04 KB
🎬
24. Manipulating Data/4. INSERT ALL statement INSERT FIRST.mp4
57.51 MB
🎬
24. Manipulating Data/5. Another INSERT ALL Example & Notes.mp4
37.19 MB
💬
24. Manipulating Data/5. Another INSERT ALL Example & Notes.vtt
6.47 KB
🎬
24. Manipulating Data/6. Creating Matrix Report Using PIVOT.mp4
29.74 MB
💬
24. Manipulating Data/6. Creating Matrix Report Using PIVOT.vtt
7.67 KB
🎬
24. Manipulating Data/7. The Merge Statement.mp4
14.22 MB
💬
24. Manipulating Data/7. The Merge Statement.vtt
6.38 KB
🎬
24. Manipulating Data/8. FLASHBACK Table & System change Number ( SCN).mp4
65.47 MB
💬
24. Manipulating Data/8. FLASHBACK Table & System change Number ( SCN).vtt
10.66 KB
📄
25. Managing Data in Different Time Zones/1. chapter 25 hints.pdf
279.7 KB
💻
25. Managing Data in Different Time Zones/1. chapter 25.sql
5.21 KB
💬
25. Managing Data in Different Time Zones/1. THE INTERVAL ( YEAR TO MONTH day TO second).vtt
6.41 KB
🎬
25. Managing Data in Different Time Zones/1. THE INTERVAL ( YEAR TO MONTH day TO second).mp4
20.67 MB
💬
25. Managing Data in Different Time Zones/2. to_yminterval to_dsinterval.vtt
4.65 KB
🎬
25. Managing Data in Different Time Zones/2. to_yminterval to_dsinterval.mp4
12.8 MB
🎬
25. Managing Data in Different Time Zones/3. Extract function.mp4
6.14 MB
💬
25. Managing Data in Different Time Zones/3. Extract function.vtt
2.55 KB
💬
25. Managing Data in Different Time Zones/4. timestamp timestamp with time zone.vtt
5.42 KB
🎬
25. Managing Data in Different Time Zones/4. timestamp timestamp with time zone.mp4
25.42 MB
🎬
25. Managing Data in Different Time Zones/5. V$TIMEZONE_NAMES and some functions.mp4
50.09 MB
💬
25. Managing Data in Different Time Zones/5. V$TIMEZONE_NAMES and some functions.vtt
9.93 KB
🎬
25. Managing Data in Different Time Zones/6. timestamp with local time zone.mp4
13.64 MB
💬
25. Managing Data in Different Time Zones/6. timestamp with local time zone.vtt
4.73 KB
💬
25. Managing Data in Different Time Zones/7. TZ_OFFSET FROM_TZ TO_TIMESTAMP.vtt
3.89 KB
🎬
25. Managing Data in Different Time Zones/7. TZ_OFFSET FROM_TZ TO_TIMESTAMP.mp4
20.26 MB
🎬
26. Exam 1Z0-071 for SQL Certified Associate/1. About the Exam 1Z0-071.mp4
25.55 MB
💬
26. Exam 1Z0-071 for SQL Certified Associate/1. About the Exam 1Z0-071.vtt
6.62 KB
💻
26. Exam 1Z0-071 for SQL Certified Associate/2. EXAM 1z0-071 Sample Questions.html
135 B
📄
26. Exam 1Z0-071 for SQL Certified Associate/2. EXAM 1z0-071 sample.pdf
1.7 MB
🎬
27. Bonus Section/1. Using SELECT statement to create dynamic scripts.mp4
18.73 MB
💻
27. Bonus Section/1. Using SELECT statement to create dynamic scripts.sql
357 B
💬
27. Bonus Section/1. Using SELECT statement to create dynamic scripts.vtt
4.48 KB
🎬
27. Bonus Section/10. oracle 18c express edition part 3 ( sql developer ).mp4
20.4 MB
💬
27. Bonus Section/10. oracle 18c express edition part 3 ( sql developer ).vtt
6.3 KB
🎬
27. Bonus Section/2. Installing oracle 11g express edition.mp4
40.15 MB
💬
27. Bonus Section/2. Installing oracle 11g express edition.vtt
9.5 KB
🎬
27. Bonus Section/3. Rownum and rowid.mp4
21.67 MB
💬
27. Bonus Section/3. Rownum and rowid.vtt
5.84 KB
🎬
27. Bonus Section/4. About PLSQL.mp4
91.36 MB
💬
27. Bonus Section/4. About PLSQL.vtt
11.77 KB
💻
27. Bonus Section/5. Understanding NULLS when used with ( IN NOT IN ).html
1.96 KB
💻
27. Bonus Section/6. permanent solution for ORA-01033 oracle initialization or shutdown in progress.html
1.05 KB
💻
27. Bonus Section/7. dbms_errlog.sql
480 B
🎬
27. Bonus Section/7. DML logs using package dbms_errlog.mp4
35.09 MB
💬
27. Bonus Section/7. DML logs using package dbms_errlog.vtt
8.45 KB
🎬
27. Bonus Section/8. oracle 18c express edition part 1 (download and install ).mp4
42.35 MB
💬
27. Bonus Section/8. oracle 18c express edition part 1 (download and install ).vtt
8.28 KB
🎬
27. Bonus Section/9. oracle 18c express edition part 2 (unlock hr ).mp4
31.85 MB
💬
27. Bonus Section/9. oracle 18c express edition part 2 (unlock hr ).vtt
9.88 KB
🖼️
28. What next it is time for PLSQL/1. 2018-01-10_08-06-36-522880710123fea4c18889023ddcb237.jpg
24.01 KB
💻
28. What next it is time for PLSQL/1. Move your skills to PLSQL.html
1.12 KB
💻
28. What next it is time for PLSQL/2. Move your skills to Oracle Analytic Functions In-Depth & Advanced Oracle SQL.html
749 B
💻
28. What next it is time for PLSQL/3. Oracle Apex.html
2.77 KB
⬇️ 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].