|
/.../2. Software Download & Installation/
|
|
4. Option 2 Downloading And Installing Oracle Database.mp4
|
330.8 MB
|
|
-Oracle-Master-Training-Scripts-to-Unlock-the-HR-Schema.pdf
|
236.4 KB
|
|
Changing-Virtual-Machine-Keyboard-Settings.pdf
|
1.1 MB
|
|
6. Option 2 Configuring and Using the SQL Developer-it_IT.srt
|
25.5 KB
|
|
6. Option 2 Configuring and Using the SQL Developer-pl_PL.srt
|
25.3 KB
|
|
6. Option 2 Configuring and Using the SQL Developer-en_US.srt
|
24.7 KB
|
|
2. Which Option to Choose to Have a Database-th_TH.srt
|
23.9 KB
|
|
3. Option 1 Having the Database with the Oracle Virtual Box-th_TH.srt
|
23.2 KB
|
|
4. Option 2 Downloading And Installing Oracle Database-it_IT.srt
|
21.5 KB
|
|
4. Option 2 Downloading And Installing Oracle Database-pl_PL.srt
|
21.5 KB
|
|
4. Option 2 Downloading And Installing Oracle Database-en_US.srt
|
21.0 KB
|
|
3. External URLs.txt
|
0.4 KB
|
|
4. External URLs.txt
|
0.1 KB
|
|
Don't Forget to Leave a Rating!.html
|
0.6 KB
|
|
Linux-Username-and-Password.txt
|
0.2 KB
|
|
Option 3 Warning About Oracle Live SQL Limitations.html
|
1.0 KB
|
|
The Working Document.html
|
0.7 KB
|
|
7. Option 3 Using Oracle Live SQL-th_TH.srt
|
14.8 KB
|
|
6. Option 2 Configuring and Using the SQL Developer.mp4
|
262.3 MB
|
|
3. Option 1 Having the Database with the Oracle Virtual Box-ro_RO.srt
|
13.7 KB
|
|
2. Which Option to Choose to Have a Database-ro_RO.srt
|
13.7 KB
|
|
3. Option 1 Having the Database with the Oracle Virtual Box-id_ID.srt
|
13.3 KB
|
|
2. Which Option to Choose to Have a Database-id_ID.srt
|
13.2 KB
|
|
2. Which Option to Choose to Have a Database-it_IT.srt
|
13.2 KB
|
|
3. Option 1 Having the Database with the Oracle Virtual Box-it_IT.srt
|
13.0 KB
|
|
2. Which Option to Choose to Have a Database-pl_PL.srt
|
12.9 KB
|
|
3. Option 1 Having the Database with the Oracle Virtual Box-pl_PL.srt
|
12.8 KB
|
|
2. Which Option to Choose to Have a Database-en_US.srt
|
12.7 KB
|
|
3. Option 1 Having the Database with the Oracle Virtual Box-en_US.srt
|
12.4 KB
|
|
1. About the Database Installation-th_TH.srt
|
10.2 KB
|
|
5. Option 2 Unlocking the HR Schema-pl_PL.srt
|
9.6 KB
|
|
5. Option 2 Unlocking the HR Schema-it_IT.srt
|
9.4 KB
|
|
7. Option 3 Using Oracle Live SQL-ro_RO.srt
|
8.9 KB
|
|
5. Option 2 Unlocking the HR Schema-en_US.srt
|
8.7 KB
|
|
7. Option 3 Using Oracle Live SQL-id_ID.srt
|
8.7 KB
|
|
7. Option 3 Using Oracle Live SQL-it_IT.srt
|
8.6 KB
|
|
7. Option 3 Using Oracle Live SQL-pl_PL.srt
|
8.3 KB
|
|
7. Option 3 Using Oracle Live SQL-en_US.srt
|
8.2 KB
|
|
8. SQL Statements Used in This Course-it_IT.srt
|
6.0 KB
|
|
8. SQL Statements Used in This Course-pl_PL.srt
|
5.8 KB
|
|
8. SQL Statements Used in This Course-en_US.srt
|
5.7 KB
|
|
1. About the Database Installation-id_ID.srt
|
5.3 KB
|
|
1. About the Database Installation-ro_RO.srt
|
5.3 KB
|
|
1. About the Database Installation-it_IT.srt
|
5.2 KB
|
|
1. About the Database Installation-pl_PL.srt
|
5.0 KB
|
|
1. About the Database Installation-en_US.srt
|
4.9 KB
|
|
Option 1 How to Install the Virtual Box on Mac OS X.html
|
4.2 KB
|
|
3. Option 1 Having the Database with the Oracle Virtual Box.mp4
|
114.4 MB
|
|
8. SQL Statements Used in This Course.mp4
|
66.0 MB
|
|
2. Which Option to Choose to Have a Database.mp4
|
64.7 MB
|
|
1. About the Database Installation.mp4
|
52.6 MB
|
|
7. Option 3 Using Oracle Live SQL.mp4
|
31.5 MB
|
|
5. Option 2 Unlocking the HR Schema.mp4
|
28.6 MB
|
|
/
|
|
TutsNode.com.txt
|
0.1 KB
|
|
[TGx]Downloaded from torrentgalaxy.to .txt
|
0.6 KB
|
|
/1. Database Concepts/
|
|
HR-Schema-Relationship.png
|
238.7 KB
|
|
Special Gifts for Our Students!(SQL Cheatsheet & SQL Certification Exam Samples).html
|
1.3 KB
|
|
5. What is a Relational Database (RDBMS)-th_TH.srt
|
16.9 KB
|
|
2. Why Oracle Database-th_TH.srt
|
16.5 KB
|
|
8. Introduction to Database Objects-it_IT.srt
|
15.5 KB
|
|
9. The Sample (HR) Schema Used in This Course-th_TH.srt
|
15.4 KB
|
|
8. Introduction to Database Objects-pl_PL.srt
|
15.3 KB
|
|
8. Introduction to Database Objects-en_US.srt
|
14.9 KB
|
|
10. What is SQL-th_TH.srt
|
11.5 KB
|
|
4. UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip)-th_TH.srt
|
10.9 KB
|
|
5. What is a Relational Database (RDBMS)-ro_RO.srt
|
9.7 KB
|
|
1. What is a Database-pl_PL.srt
|
9.6 KB
|
|
1. What is a Database-it_IT.srt
|
9.6 KB
|
|
2. Why Oracle Database-ro_RO.srt
|
9.6 KB
|
|
2. Why Oracle Database-id_ID.srt
|
9.5 KB
|
|
5. What is a Relational Database (RDBMS)-it_IT.srt
|
9.5 KB
|
|
5. What is a Relational Database (RDBMS)-id_ID.srt
|
9.4 KB
|
|
5. What is a Relational Database (RDBMS)-pl_PL.srt
|
9.3 KB
|
|
2. Why Oracle Database-pl_PL.srt
|
9.2 KB
|
|
9. The Sample (HR) Schema Used in This Course-ro_RO.srt
|
9.1 KB
|
|
2. Why Oracle Database-it_IT.srt
|
9.1 KB
|
|
1. What is a Database-en_US.srt
|
9.0 KB
|
|
9. The Sample (HR) Schema Used in This Course-pl_PL.srt
|
8.9 KB
|
|
9. The Sample (HR) Schema Used in This Course-id_ID.srt
|
8.9 KB
|
|
9. The Sample (HR) Schema Used in This Course-it_IT.srt
|
8.9 KB
|
|
5. What is a Relational Database (RDBMS)-en_US.srt
|
8.8 KB
|
|
2. Why Oracle Database-en_US.srt
|
8.8 KB
|
|
9. The Sample (HR) Schema Used in This Course-en_US.srt
|
8.6 KB
|
|
6. Entity Relationship Logic in Databases-th_TH.srt
|
8.2 KB
|
|
10. What is SQL-ro_RO.srt
|
6.5 KB
|
|
10. What is SQL-id_ID.srt
|
6.5 KB
|
|
4. UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip)-ro_RO.srt
|
6.5 KB
|
|
10. What is SQL-pl_PL.srt
|
6.3 KB
|
|
4. UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip)-id_ID.srt
|
6.3 KB
|
|
10. What is SQL-it_IT.srt
|
6.2 KB
|
|
4. UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip)-it_IT.srt
|
6.2 KB
|
|
4. UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip)-pl_PL.srt
|
6.0 KB
|
|
10. What is SQL-en_US.srt
|
5.9 KB
|
|
4. UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip)-en_US.srt
|
5.8 KB
|
|
6. Entity Relationship Logic in Databases-ro_RO.srt
|
4.7 KB
|
|
6. Entity Relationship Logic in Databases-it_IT.srt
|
4.6 KB
|
|
6. Entity Relationship Logic in Databases-id_ID.srt
|
4.6 KB
|
|
6. Entity Relationship Logic in Databases-pl_PL.srt
|
4.4 KB
|
|
6. Entity Relationship Logic in Databases-en_US.srt
|
4.4 KB
|
|
3. What is a Table-it_IT.srt
|
4.1 KB
|
|
3. What is a Table-pl_PL.srt
|
4.1 KB
|
|
7. What is Pluggable Database-pl_PL.srt
|
3.9 KB
|
|
3. What is a Table-en_US.srt
|
3.9 KB
|
|
7. What is Pluggable Database-it_IT.srt
|
3.8 KB
|
|
7. What is Pluggable Database-en_US.srt
|
3.7 KB
|
|
8. Introduction to Database Objects.mp4
|
189.1 MB
|
|
5. What is a Relational Database (RDBMS).mp4
|
94.8 MB
|
|
9. The Sample (HR) Schema Used in This Course.mp4
|
82.1 MB
|
|
1. What is a Database.mp4
|
72.0 MB
|
|
2. Why Oracle Database.mp4
|
64.8 MB
|
|
10. What is SQL.mp4
|
47.5 MB
|
|
3. What is a Table.mp4
|
40.1 MB
|
|
6. Entity Relationship Logic in Databases.mp4
|
35.9 MB
|
|
4. UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip).mp4
|
31.2 MB
|
|
7. What is Pluggable Database.mp4
|
16.4 MB
|
|
/.../7. Single-Row Functions/
|
|
9. Date Values & Date Formats in Oracle-pl_PL.srt
|
30.3 KB
|
|
9. Date Values & Date Formats in Oracle-it_IT.srt
|
30.2 KB
|
|
9. Date Values & Date Formats in Oracle-en_US.srt
|
29.2 KB
|
|
9. Date Values & Date Formats in Oracle.mp4
|
286.2 MB
|
|
5. Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions)-it_IT.srt
|
24.8 KB
|
|
11. Date Manipulation Functions in SQL-it_IT.srt
|
24.5 KB
|
|
11. Date Manipulation Functions in SQL-pl_PL.srt
|
24.3 KB
|
|
5. Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions)-en_US.srt
|
24.2 KB
|
|
5. Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions)-pl_PL.srt
|
24.1 KB
|
|
11. Date Manipulation Functions in SQL-en_US.srt
|
23.7 KB
|
|
10. Date Functions & Arithmetic Operations on Dates-it_IT.srt
|
21.5 KB
|
|
10. Date Functions & Arithmetic Operations on Dates-pl_PL.srt
|
21.1 KB
|
|
10. Date Functions & Arithmetic Operations on Dates-en_US.srt
|
20.4 KB
|
|
8. Nested Functions-it_IT.srt
|
19.2 KB
|
|
7. Numeric Functions-en_US.srt
|
19.2 KB
|
|
7. Numeric Functions-pl_PL.srt
|
19.2 KB
|
|
7. Numeric Functions-it_IT.srt
|
18.7 KB
|
|
8. Nested Functions-pl_PL.srt
|
18.6 KB
|
|
8. Nested Functions-en_US.srt
|
18.5 KB
|
|
2. Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functios-it_IT.srt
|
16.4 KB
|
|
2. Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functios-pl_PL.srt
|
16.1 KB
|
|
2. Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functios-en_US.srt
|
15.9 KB
|
|
3. Character Functions - Character Manipulation Functios (Part 1)-en_US.srt
|
15.2 KB
|
|
3. Character Functions - Character Manipulation Functios (Part 1)-it_IT.srt
|
15.1 KB
|
|
3. Character Functions - Character Manipulation Functios (Part 1)-pl_PL.srt
|
14.7 KB
|
|
6. Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions)-it_IT.srt
|
14.6 KB
|
|
1. Single Row Functions-it_IT.srt
|
14.4 KB
|
|
1. Single Row Functions-pl_PL.srt
|
14.2 KB
|
|
6. Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions)-en_US.srt
|
14.2 KB
|
|
1. Single Row Functions-en_US.srt
|
14.0 KB
|
|
6. Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions)-pl_PL.srt
|
13.9 KB
|
|
4. Character Functions - Character Manipulation Functions Part 2 (INSTR Function)-en_US.srt
|
12.0 KB
|
|
4. Character Functions - Character Manipulation Functions Part 2 (INSTR Function)-it_IT.srt
|
11.7 KB
|
|
4. Character Functions - Character Manipulation Functions Part 2 (INSTR Function)-pl_PL.srt
|
11.5 KB
|
|
7. External URLs.txt
|
0.1 KB
|
|
10. Date Functions & Arithmetic Operations on Dates.mp4
|
227.6 MB
|
|
5. Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions).mp4
|
176.0 MB
|
|
6. Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions).mp4
|
142.8 MB
|
|
11. Date Manipulation Functions in SQL.mp4
|
142.6 MB
|
|
1. Single Row Functions.mp4
|
140.4 MB
|
|
8. Nested Functions.mp4
|
139.5 MB
|
|
3. Character Functions - Character Manipulation Functios (Part 1).mp4
|
108.9 MB
|
|
2. Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functios.mp4
|
99.7 MB
|
|
7. Numeric Functions.mp4
|
94.7 MB
|
|
4. Character Functions - Character Manipulation Functions Part 2 (INSTR Function).mp4
|
69.8 MB
|
|
/.../13. Using Subqueries/
|
|
6. SCALAR Subqueries-pl_PL.srt
|
18.1 KB
|
|
3. Multiple Row Subqueries-pl_PL.srt
|
22.0 KB
|
|
3. Multiple Row Subqueries-it_IT.srt
|
21.8 KB
|
|
3. Multiple Row Subqueries-en_US.srt
|
20.9 KB
|
|
4. Multiple Column Subqueries-it_IT.srt
|
20.9 KB
|
|
4. Multiple Column Subqueries-pl_PL.srt
|
20.4 KB
|
|
4. Multiple Column Subqueries-en_US.srt
|
19.8 KB
|
|
7. Correlated Subqueries-it_IT.srt
|
18.6 KB
|
|
6. SCALAR Subqueries-it_IT.srt
|
18.5 KB
|
|
7. Correlated Subqueries-pl_PL.srt
|
18.4 KB
|
|
6. SCALAR Subqueries-en_US.srt
|
17.6 KB
|
|
7. Correlated Subqueries-en_US.srt
|
17.4 KB
|
|
2. Single Row Subqueries-it_IT.srt
|
17.0 KB
|
|
2. Single Row Subqueries-pl_PL.srt
|
16.9 KB
|
|
2. Single Row Subqueries-en_US.srt
|
16.2 KB
|
|
8. EXISTS Operator & Semijoins-pl_PL.srt
|
14.6 KB
|
|
8. EXISTS Operator & Semijoins-it_IT.srt
|
14.5 KB
|
|
8. EXISTS Operator & Semijoins-en_US.srt
|
13.9 KB
|
|
5. Using Subqueries as a Table-it_IT.srt
|
10.1 KB
|
|
5. Using Subqueries as a Table-pl_PL.srt
|
9.9 KB
|
|
1. Using Subqueries-pl_PL.srt
|
9.5 KB
|
|
1. Using Subqueries-it_IT.srt
|
9.5 KB
|
|
5. Using Subqueries as a Table-en_US.srt
|
9.4 KB
|
|
1. Using Subqueries-en_US.srt
|
8.9 KB
|
|
9. NOT EXISTS Operator-it_IT.srt
|
7.5 KB
|
|
9. NOT EXISTS Operator-pl_PL.srt
|
7.3 KB
|
|
9. NOT EXISTS Operator-en_US.srt
|
7.2 KB
|
|
2. Single Row Subqueries.mp4
|
234.1 MB
|
|
3. Multiple Row Subqueries.mp4
|
167.8 MB
|
|
7. Correlated Subqueries.mp4
|
133.4 MB
|
|
4. Multiple Column Subqueries.mp4
|
112.5 MB
|
|
5. Using Subqueries as a Table.mp4
|
110.4 MB
|
|
6. SCALAR Subqueries.mp4
|
98.7 MB
|
|
1. Using Subqueries.mp4
|
83.5 MB
|
|
8. EXISTS Operator & Semijoins.mp4
|
80.7 MB
|
|
9. NOT EXISTS Operator.mp4
|
63.1 MB
|
|
/18. Appendix/
|
|
1. External URLs.txt
|
0.1 KB
|
|
2. Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c-th_TH.srt
|
19.9 KB
|
|
1. Appendix 1 Oracle Database 12c Installation into Your Computer-th_TH.srt
|
17.3 KB
|
|
2. Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c-ro_RO.srt
|
11.6 KB
|
|
2. Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c-id_ID.srt
|
11.5 KB
|
|
2. Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c-pl_PL.srt
|
11.3 KB
|
|
2. Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c-it_IT.srt
|
11.2 KB
|
|
1. Appendix 1 Oracle Database 12c Installation into Your Computer-ro_RO.srt
|
10.2 KB
|
|
1. Appendix 1 Oracle Database 12c Installation into Your Computer-id_ID.srt
|
10.1 KB
|
|
2. Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c-en_US.srt
|
10.1 KB
|
|
1. Appendix 1 Oracle Database 12c Installation into Your Computer-it_IT.srt
|
9.8 KB
|
|
1. Appendix 1 Oracle Database 12c Installation into Your Computer-pl_PL.srt
|
9.7 KB
|
|
1. Appendix 1 Oracle Database 12c Installation into Your Computer-en_US.srt
|
9.6 KB
|
|
Appendix 2 How to Unlock the HR Schema in the Oracle Database 12c.html
|
3.2 KB
|
|
2. Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c.mp4
|
91.4 MB
|
|
1. Appendix 1 Oracle Database 12c Installation into Your Computer.mp4
|
83.0 MB
|
|
/.../16. Data Manipulation Language (DML) Statements/
|
|
3. INSERT Statement (Part 2).mp4
|
304.7 MB
|
|
11. MERGE Statement-it_IT.srt
|
24.9 KB
|
|
11. MERGE Statement-pl_PL.srt
|
24.3 KB
|
|
3. INSERT Statement (Part 2)-it_IT.srt
|
23.2 KB
|
|
11. MERGE Statement-en_US.srt
|
22.8 KB
|
|
3. INSERT Statement (Part 2)-pl_PL.srt
|
22.2 KB
|
|
3. INSERT Statement (Part 2)-en_US.srt
|
21.5 KB
|
|
12. (TCL) Transaction Control Statements-en_US.srt
|
0.0 KB
|
|
2. INSERT Statement (Part 1)-it_IT.srt
|
17.5 KB
|
|
2. INSERT Statement (Part 1)-pl_PL.srt
|
17.0 KB
|
|
2. INSERT Statement (Part 1)-en_US.srt
|
16.4 KB
|
|
6. Conditional INSERT ALL Statements-it_IT.srt
|
16.0 KB
|
|
6. Conditional INSERT ALL Statements-pl_PL.srt
|
15.5 KB
|
|
6. Conditional INSERT ALL Statements-en_US.srt
|
15.0 KB
|
|
12. (TCL) Transaction Control Statements-th_TH.srt
|
0.1 KB
|
|
9. UPDATE Statement-it_IT.srt
|
14.4 KB
|
|
9. UPDATE Statement-pl_PL.srt
|
14.0 KB
|
|
5. Unconditional Insert Statements (INSERT ALL Statements)-it_IT.srt
|
13.3 KB
|
|
9. UPDATE Statement-en_US.srt
|
13.2 KB
|
|
5. Unconditional Insert Statements (INSERT ALL Statements)-pl_PL.srt
|
12.8 KB
|
|
5. Unconditional Insert Statements (INSERT ALL Statements)-en_US.srt
|
12.4 KB
|
|
8. Pivoting Insert-it_IT.srt
|
12.0 KB
|
|
8. Pivoting Insert-pl_PL.srt
|
11.9 KB
|
|
8. Pivoting Insert-en_US.srt
|
11.1 KB
|
|
11. MERGE Statement.mp4
|
255.8 MB
|
|
13. COMMIT and ROLLBACK Statements-th_TH.srt
|
0.1 KB
|
|
14. SAVEPOINT Statement-th_TH.srt
|
0.1 KB
|
|
7. Conditional INSERT FIRST Statements-it_IT.srt
|
7.6 KB
|
|
7. Conditional INSERT FIRST Statements-pl_PL.srt
|
7.5 KB
|
|
7. Conditional INSERT FIRST Statements-en_US.srt
|
7.3 KB
|
|
1. Data Manipulation Language (DML)-it_IT.srt
|
6.5 KB
|
|
1. Data Manipulation Language (DML)-pl_PL.srt
|
6.3 KB
|
|
1. Data Manipulation Language (DML)-en_US.srt
|
6.0 KB
|
|
10. DELETE Statement-it_IT.srt
|
5.5 KB
|
|
10. DELETE Statement-pl_PL.srt
|
5.3 KB
|
|
10. DELETE Statement-en_US.srt
|
5.1 KB
|
|
4. Multitable Insert Statements-it_IT.srt
|
3.7 KB
|
|
4. Multitable Insert Statements-pl_PL.srt
|
3.6 KB
|
|
4. Multitable Insert Statements-en_US.srt
|
3.5 KB
|
|
SAVEPOINT-Statement.sql
|
0.9 KB
|
|
Good News!.html
|
0.8 KB
|
|
15. FOR UPDATE Statement-th_TH.srt
|
0.1 KB
|
|
12. (TCL) Transaction Control Statements-id_ID.srt
|
0.0 KB
|
|
12. (TCL) Transaction Control Statements-it_IT.srt
|
0.0 KB
|
|
12. (TCL) Transaction Control Statements-pl_PL.srt
|
0.0 KB
|
|
12. (TCL) Transaction Control Statements-ro_RO.srt
|
0.0 KB
|
|
13. COMMIT and ROLLBACK Statements-en_US.srt
|
0.0 KB
|
|
13. COMMIT and ROLLBACK Statements-id_ID.srt
|
0.0 KB
|
|
13. COMMIT and ROLLBACK Statements-it_IT.srt
|
0.0 KB
|
|
13. COMMIT and ROLLBACK Statements-pl_PL.srt
|
0.0 KB
|
|
13. COMMIT and ROLLBACK Statements-ro_RO.srt
|
0.0 KB
|
|
14. SAVEPOINT Statement-en_US.srt
|
0.0 KB
|
|
14. SAVEPOINT Statement-id_ID.srt
|
0.0 KB
|
|
14. SAVEPOINT Statement-it_IT.srt
|
0.0 KB
|
|
14. SAVEPOINT Statement-pl_PL.srt
|
0.0 KB
|
|
14. SAVEPOINT Statement-ro_RO.srt
|
0.0 KB
|
|
15. FOR UPDATE Statement-en_US.srt
|
0.0 KB
|
|
15. FOR UPDATE Statement-id_ID.srt
|
0.0 KB
|
|
15. FOR UPDATE Statement-it_IT.srt
|
0.0 KB
|
|
15. FOR UPDATE Statement-pl_PL.srt
|
0.0 KB
|
|
15. FOR UPDATE Statement-ro_RO.srt
|
0.0 KB
|
|
6. Conditional INSERT ALL Statements.mp4
|
207.6 MB
|
|
2. INSERT Statement (Part 1).mp4
|
145.6 MB
|
|
14. SAVEPOINT Statement.mp4
|
141.2 MB
|
|
8. Pivoting Insert.mp4
|
130.7 MB
|
|
13. COMMIT and ROLLBACK Statements.mp4
|
88.1 MB
|
|
5. Unconditional Insert Statements (INSERT ALL Statements).mp4
|
84.8 MB
|
|
9. UPDATE Statement.mp4
|
80.2 MB
|
|
15. FOR UPDATE Statement.mp4
|
71.5 MB
|
|
10. DELETE Statement.mp4
|
67.4 MB
|
|
7. Conditional INSERT FIRST Statements.mp4
|
52.1 MB
|
|
1. Data Manipulation Language (DML).mp4
|
43.7 MB
|
|
12. (TCL) Transaction Control Statements.mp4
|
25.7 MB
|
|
4. Multitable Insert Statements.mp4
|
22.9 MB
|
|
/.../19. Conclusion + Reward!/
|
|
Code-Samples.pdf
|
86.2 KB
|
|
Bonus Lecture.html
|
2.7 KB
|
|
Course Gifts(SQL Cheatsheet & SQL Certification Exam Samples).html
|
1.2 KB
|
|
1. Conclusion-th_TH.srt
|
0.1 KB
|
|
1. Conclusion-en_US.srt
|
0.0 KB
|
|
1. Conclusion-id_ID.srt
|
0.0 KB
|
|
1. Conclusion-it_IT.srt
|
0.0 KB
|
|
1. Conclusion-pl_PL.srt
|
0.0 KB
|
|
1. Conclusion-ro_RO.srt
|
0.0 KB
|
|
1. Conclusion.mp4
|
2.1 MB
|
|
/9. Conditional Expressions/
|
|
1. Oracle Conditional Expressions CASE Expressions-it_IT.srt
|
28.9 KB
|
|
1. Oracle Conditional Expressions CASE Expressions-pl_PL.srt
|
28.2 KB
|
|
1. Oracle Conditional Expressions CASE Expressions-en_US.srt
|
27.3 KB
|
|
2. Oracle Conditional Expressions DECODE Function-it_IT.srt
|
12.3 KB
|
|
2. Oracle Conditional Expressions DECODE Function-pl_PL.srt
|
11.9 KB
|
|
2. Oracle Conditional Expressions DECODE Function-en_US.srt
|
11.4 KB
|
|
1. Oracle Conditional Expressions CASE Expressions.mp4
|
221.5 MB
|
|
2. Oracle Conditional Expressions DECODE Function.mp4
|
83.1 MB
|
|
/8. Conversion Functions/
|
|
4. Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions-it_IT.srt
|
25.6 KB
|
|
4. Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions-pl_PL.srt
|
25.1 KB
|
|
4. Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions-en_US.srt
|
25.0 KB
|
|
2. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1)-it_IT.srt
|
20.7 KB
|
|
3. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2)-it_IT.srt
|
20.6 KB
|
|
2. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1)-pl_PL.srt
|
20.2 KB
|
|
3. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2)-pl_PL.srt
|
19.8 KB
|
|
2. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1)-en_US.srt
|
19.7 KB
|
|
3. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2)-en_US.srt
|
19.5 KB
|
|
1. Conversion Functions-it_IT.srt
|
13.9 KB
|
|
1. Conversion Functions-pl_PL.srt
|
13.4 KB
|
|
1. Conversion Functions-en_US.srt
|
13.3 KB
|
|
4. Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions.mp4
|
228.7 MB
|
|
3. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2).mp4
|
186.4 MB
|
|
2. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1).mp4
|
127.5 MB
|
|
1. Conversion Functions.mp4
|
83.0 MB
|
|
/3. Retrieving Data/
|
|
9. Quote (Q) Operator-en_US.srt
|
9.4 KB
|
|
5. SQL Statement Basics-it_IT.srt
|
15.2 KB
|
|
5. SQL Statement Basics-pl_PL.srt
|
14.9 KB
|
|
CODE Using Column Aliases.html
|
0.4 KB
|
|
CODE Using SELECT Statements.html
|
0.2 KB
|
|
5. SQL Statement Basics-en_US.srt
|
14.3 KB
|
|
12. Arithmetic Expressions and NULL Values-it_IT.srt
|
11.3 KB
|
|
12. Arithmetic Expressions and NULL Values-en_US.srt
|
11.1 KB
|
|
12. Arithmetic Expressions and NULL Values-pl_PL.srt
|
11.1 KB
|
|
9. Quote (Q) Operator-it_IT.srt
|
10.0 KB
|
|
4. INFORMATION Command-it_IT.srt
|
10.0 KB
|
|
9. Quote (Q) Operator-pl_PL.srt
|
9.8 KB
|
|
4. INFORMATION Command-pl_PL.srt
|
9.6 KB
|
|
4. INFORMATION Command-en_US.srt
|
9.4 KB
|
|
10. DISTINCT and UNIQUE Operator-en_US.srt
|
8.5 KB
|
|
10. DISTINCT and UNIQUE Operator-it_IT.srt
|
8.5 KB
|
|
10. DISTINCT and UNIQUE Operator-pl_PL.srt
|
8.4 KB
|
|
11. Concatenation Operators-en_US.srt
|
8.4 KB
|
|
11. Concatenation Operators-it_IT.srt
|
8.3 KB
|
|
1. Oracle Data Types-it_IT.srt
|
8.3 KB
|
|
1. Oracle Data Types-pl_PL.srt
|
8.2 KB
|
|
8. Using Column Aliases-it_IT.srt
|
8.2 KB
|
|
8. Using Column Aliases-pl_PL.srt
|
8.0 KB
|
|
8. Using Column Aliases-en_US.srt
|
8.0 KB
|
|
11. Concatenation Operators-pl_PL.srt
|
7.9 KB
|
|
1. Oracle Data Types-en_US.srt
|
7.7 KB
|
|
6. Oracle Error Messages-pl_PL.srt
|
7.6 KB
|
|
6. Oracle Error Messages-it_IT.srt
|
7.5 KB
|
|
6. Oracle Error Messages-en_US.srt
|
7.4 KB
|
|
7. Using SELECT Statements-it_IT.srt
|
7.1 KB
|
|
7. Using SELECT Statements-en_US.srt
|
7.0 KB
|
|
7. Using SELECT Statements-pl_PL.srt
|
6.9 KB
|
|
2. What is a NULL Value-pl_PL.srt
|
6.2 KB
|
|
2. What is a NULL Value-it_IT.srt
|
6.1 KB
|
|
2. What is a NULL Value-en_US.srt
|
5.8 KB
|
|
3. DESCRIBE Command-it_IT.srt
|
5.1 KB
|
|
3. DESCRIBE Command-en_US.srt
|
4.9 KB
|
|
3. DESCRIBE Command-pl_PL.srt
|
4.8 KB
|
|
5. SQL Statement Basics.mp4
|
133.0 MB
|
|
12. Arithmetic Expressions and NULL Values.mp4
|
106.6 MB
|
|
1. Oracle Data Types.mp4
|
89.9 MB
|
|
2. What is a NULL Value.mp4
|
67.6 MB
|
|
9. Quote (Q) Operator.mp4
|
62.0 MB
|
|
10. DISTINCT and UNIQUE Operator.mp4
|
55.3 MB
|
|
11. Concatenation Operators.mp4
|
54.1 MB
|
|
3. DESCRIBE Command.mp4
|
51.9 MB
|
|
6. Oracle Error Messages.mp4
|
49.8 MB
|
|
4. INFORMATION Command.mp4
|
49.2 MB
|
|
8. Using Column Aliases.mp4
|
43.9 MB
|
|
7. Using SELECT Statements.mp4
|
39.5 MB
|
|
/.pad/
|
|
0
|
0.0 KB
|
|
1
|
0.0 KB
|
|
2
|
0.0 KB
|
|
3
|
0.0 KB
|
|
4
|
0.0 KB
|
|
5
|
0.0 KB
|
|
6
|
399.1 KB
|
|
7
|
2.0 MB
|
|
8
|
987.6 KB
|
|
9
|
842.7 KB
|
|
10
|
1.6 MB
|
|
11
|
10.5 KB
|
|
12
|
313.8 KB
|
|
13
|
1.3 MB
|
|
14
|
1.7 MB
|
|
15
|
1.7 MB
|
|
16
|
499.6 KB
|
|
17
|
252.1 KB
|
|
18
|
112.0 KB
|
|
19
|
345.2 KB
|
|
20
|
2.1 MB
|
|
21
|
1.8 MB
|
|
22
|
811.9 KB
|
|
23
|
873.1 KB
|
|
24
|
1.1 MB
|
|
25
|
1.2 MB
|
|
26
|
1.9 MB
|
|
27
|
55.0 KB
|
|
28
|
627.3 KB
|
|
29
|
1.4 MB
|
|
30
|
66.6 KB
|
|
31
|
1.0 MB
|
|
32
|
775.2 KB
|
|
33
|
1.3 MB
|
|
34
|
1.4 MB
|
|
35
|
1.2 MB
|
|
36
|
475.8 KB
|
|
37
|
517.7 KB
|
|
38
|
1.9 MB
|
|
39
|
911.8 KB
|
|
40
|
1.4 MB
|
|
41
|
1.8 MB
|
|
42
|
793.1 KB
|
|
43
|
784.7 KB
|
|
44
|
1.7 MB
|
|
45
|
144.1 KB
|
|
46
|
650.8 KB
|
|
47
|
1.8 MB
|
|
48
|
389.1 KB
|
|
49
|
583.7 KB
|
|
50
|
744.0 KB
|
|
51
|
873.5 KB
|
|
52
|
974.8 KB
|
|
53
|
1.9 MB
|
|
54
|
1.7 MB
|
|
55
|
1.8 MB
|
|
56
|
436.2 KB
|
|
57
|
831.3 KB
|
|
58
|
255.4 KB
|
|
59
|
725.9 KB
|
|
60
|
1.0 MB
|
|
61
|
8.4 KB
|
|
62
|
1.3 MB
|
|
63
|
1.2 MB
|
|
64
|
287.6 KB
|
|
65
|
435.1 KB
|
|
66
|
828.9 KB
|
|
67
|
891.5 KB
|
|
68
|
900.3 KB
|
|
69
|
1.8 MB
|
|
70
|
1.1 MB
|
|
71
|
1.6 MB
|
|
72
|
570.7 KB
|
|
73
|
839.4 KB
|
|
74
|
1.5 MB
|
|
75
|
1.1 MB
|
|
76
|
1.4 MB
|
|
77
|
1.9 MB
|
|
78
|
829.1 KB
|
|
79
|
845.3 KB
|
|
80
|
1.5 MB
|
|
81
|
1.4 MB
|
|
82
|
1.7 MB
|
|
83
|
1.8 MB
|
|
84
|
1.1 MB
|
|
85
|
260.3 KB
|
|
86
|
355.2 KB
|
|
87
|
1.9 MB
|
|
88
|
928.3 KB
|
|
89
|
2.0 MB
|
|
90
|
246.9 KB
|
|
91
|
1.1 MB
|
|
92
|
1.8 MB
|
|
93
|
372.8 KB
|
|
94
|
1.5 MB
|
|
95
|
1.6 MB
|
|
96
|
1.3 MB
|
|
97
|
1.8 MB
|
|
98
|
422.4 KB
|
|
99
|
720.8 KB
|
|
100
|
1.4 MB
|
|
101
|
1.7 MB
|
|
102
|
2.0 MB
|
|
103
|
351.3 KB
|
|
104
|
507.8 KB
|
|
105
|
1.5 MB
|
|
106
|
562.1 KB
|
|
107
|
1.2 MB
|
|
108
|
1.3 MB
|
|
109
|
711.3 KB
|
|
110
|
1.6 MB
|
|
111
|
1.2 MB
|
|
112
|
1.4 MB
|
|
113
|
1.4 MB
|
|
114
|
143.3 KB
|
|
115
|
326.2 KB
|
|
116
|
1.8 MB
|
|
117
|
27.3 KB
|
|
118
|
346.9 KB
|
|
119
|
847.3 KB
|
|
120
|
1.8 MB
|
|
121
|
176.1 KB
|
|
122
|
926.9 KB
|
|
123
|
267.1 KB
|
|
124
|
1.5 KB
|
|
125
|
212.3 KB
|
|
126
|
667.8 KB
|
|
127
|
739.5 KB
|
|
128
|
1.4 MB
|
|
129
|
625.5 KB
|
|
130
|
1.2 MB
|
|
131
|
1.6 MB
|
|
132
|
1.8 MB
|
|
133
|
1.8 MB
|
|
134
|
949.3 KB
|
|
135
|
1.2 MB
|
|
136
|
1.4 MB
|
|
137
|
206.6 KB
|
|
138
|
1.2 MB
|
|
139
|
1.6 MB
|
|
140
|
420.0 KB
|
|
141
|
689.4 KB
|
|
142
|
260.5 KB
|
|
143
|
424.1 KB
|
|
144
|
1.3 MB
|
|
145
|
276.3 KB
|
|
146
|
696.3 KB
|
|
/.../15. Data Definition Language (DDL) Statements/
|
|
5. ALTER TABLE Statement-it_IT.srt
|
22.7 KB
|
|
5. ALTER TABLE Statement-pl_PL.srt
|
21.8 KB
|
|
5. ALTER TABLE Statement-en_US.srt
|
20.7 KB
|
|
4. CREATE TABLE AS SELECT (CTAS) Statement in Oracle-it_IT.srt
|
14.8 KB
|
|
4. CREATE TABLE AS SELECT (CTAS) Statement in Oracle-pl_PL.srt
|
14.5 KB
|
|
2. Naming Rules & Naming Conventions in Oracle-it_IT.srt
|
14.3 KB
|
|
2. Naming Rules & Naming Conventions in Oracle-pl_PL.srt
|
14.1 KB
|
|
4. CREATE TABLE AS SELECT (CTAS) Statement in Oracle-en_US.srt
|
14.0 KB
|
|
2. Naming Rules & Naming Conventions in Oracle-en_US.srt
|
13.3 KB
|
|
9. TRUNCATE TABLE Statement-it_IT.srt
|
13.1 KB
|
|
9. TRUNCATE TABLE Statement-pl_PL.srt
|
12.5 KB
|
|
9. TRUNCATE TABLE Statement-en_US.srt
|
11.9 KB
|
|
10. COMMENT Statement-it_IT.srt
|
11.9 KB
|
|
6. Marking Columns Unused (Using The SET UNUSED Clause)-it_IT.srt
|
11.7 KB
|
|
10. COMMENT Statement-pl_PL.srt
|
11.4 KB
|
|
6. Marking Columns Unused (Using The SET UNUSED Clause)-pl_PL.srt
|
11.4 KB
|
|
3. CREATE TABLE Statement-it_IT.srt
|
11.2 KB
|
|
3. CREATE TABLE Statement-pl_PL.srt
|
10.9 KB
|
|
10. COMMENT Statement-en_US.srt
|
10.9 KB
|
|
8. DROP TABLE Statement-it_IT.srt
|
10.7 KB
|
|
3. CREATE TABLE Statement-en_US.srt
|
10.5 KB
|
|
6. Marking Columns Unused (Using The SET UNUSED Clause)-en_US.srt
|
10.4 KB
|
|
8. DROP TABLE Statement-pl_PL.srt
|
10.4 KB
|
|
8. DROP TABLE Statement-en_US.srt
|
9.9 KB
|
|
7. READ-ONLY Tables in SQL-it_IT.srt
|
8.8 KB
|
|
7. READ-ONLY Tables in SQL-pl_PL.srt
|
8.4 KB
|
|
7. READ-ONLY Tables in SQL-en_US.srt
|
7.9 KB
|
|
11. RENAME Statement-it_IT.srt
|
6.9 KB
|
|
11. RENAME Statement-pl_PL.srt
|
6.9 KB
|
|
11. RENAME Statement-en_US.srt
|
6.4 KB
|
|
1. Data Definition Language (DDL)-it_IT.srt
|
5.1 KB
|
|
1. Data Definition Language (DDL)-pl_PL.srt
|
5.0 KB
|
|
1. Data Definition Language (DDL)-en_US.srt
|
4.8 KB
|
|
5. ALTER TABLE Statement.mp4
|
163.8 MB
|
|
4. CREATE TABLE AS SELECT (CTAS) Statement in Oracle.mp4
|
108.4 MB
|
|
2. Naming Rules & Naming Conventions in Oracle.mp4
|
89.2 MB
|
|
10. COMMENT Statement.mp4
|
76.1 MB
|
|
9. TRUNCATE TABLE Statement.mp4
|
70.5 MB
|
|
6. Marking Columns Unused (Using The SET UNUSED Clause).mp4
|
70.5 MB
|
|
3. CREATE TABLE Statement.mp4
|
67.8 MB
|
|
8. DROP TABLE Statement.mp4
|
53.2 MB
|
|
7. READ-ONLY Tables in SQL.mp4
|
49.0 MB
|
|
11. RENAME Statement.mp4
|
39.8 MB
|
|
1. Data Definition Language (DDL).mp4
|
24.2 MB
|
|
/.../12. Joining Multiple Tables/
|
|
15. Cross Join (Cartesian Product Cross Product)-it_IT.srt
|
21.8 KB
|
|
21. Entity-Relationship Models in DBMS - How to Use Them with Joins-it_IT.srt
|
21.6 KB
|
|
21. Entity-Relationship Models in DBMS - How to Use Them with Joins-pl_PL.srt
|
21.6 KB
|
|
15. Cross Join (Cartesian Product Cross Product)-pl_PL.srt
|
21.2 KB
|
|
21. Entity-Relationship Models in DBMS - How to Use Them with Joins-en_US.srt
|
20.8 KB
|
|
15. Cross Join (Cartesian Product Cross Product)-en_US.srt
|
20.3 KB
|
|
17. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2)-it_IT.srt
|
19.7 KB
|
|
17. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2)-pl_PL.srt
|
19.3 KB
|
|
14. FULL OUTER JOIN (FULL JOIN)-it_IT.srt
|
4.9 KB
|
|
15. Cross Join (Cartesian Product Cross Product).mp4
|
280.0 MB
|
|
17. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2)-en_US.srt
|
18.6 KB
|
|
19. The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins-it_IT.srt
|
17.8 KB
|
|
19. The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins-pl_PL.srt
|
17.8 KB
|
|
16. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1)-it_IT.srt
|
16.9 KB
|
|
19. The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins-en_US.srt
|
16.7 KB
|
|
16. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1)-pl_PL.srt
|
16.5 KB
|
|
16. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1)-en_US.srt
|
15.9 KB
|
|
10. Non-Equijoins (Joining Unequal Tables)-it_IT.srt
|
15.6 KB
|
|
10. Non-Equijoins (Joining Unequal Tables)-pl_PL.srt
|
15.5 KB
|
|
12. LEFT OUTER JOIN (LEFT JOIN)-it_IT.srt
|
15.3 KB
|
|
12. LEFT OUTER JOIN (LEFT JOIN)-pl_PL.srt
|
14.8 KB
|
|
10. Non-Equijoins (Joining Unequal Tables)-en_US.srt
|
14.7 KB
|
|
8. Restricting Joins-it_IT.srt
|
4.0 KB
|
|
12. LEFT OUTER JOIN (LEFT JOIN)-en_US.srt
|
14.4 KB
|
|
7. Multiple Join Operations-it_IT.srt
|
14.3 KB
|
|
7. Multiple Join Operations-pl_PL.srt
|
13.9 KB
|
|
7. Multiple Join Operations-en_US.srt
|
13.7 KB
|
|
5. Handling Ambiguous Column Names-it_IT.srt
|
13.1 KB
|
|
18. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3)-it_IT.srt
|
13.0 KB
|
|
18. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3)-pl_PL.srt
|
12.8 KB
|
|
5. Handling Ambiguous Column Names-pl_PL.srt
|
12.8 KB
|
|
5. Handling Ambiguous Column Names-en_US.srt
|
12.4 KB
|
|
3. Natural Join-it_IT.srt
|
12.2 KB
|
|
18. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3)-en_US.srt
|
12.1 KB
|
|
3. Natural Join-pl_PL.srt
|
11.7 KB
|
|
3. Natural Join-en_US.srt
|
11.5 KB
|
|
13. RIGHT OUTER JOIN (RIGHT JOIN)-it_IT.srt
|
10.2 KB
|
|
13. RIGHT OUTER JOIN (RIGHT JOIN)-pl_PL.srt
|
10.1 KB
|
|
11. OUTER JOINS-it_IT.srt
|
9.9 KB
|
|
11. OUTER JOINS-pl_PL.srt
|
9.9 KB
|
|
13. RIGHT OUTER JOIN (RIGHT JOIN)-en_US.srt
|
9.6 KB
|
|
11. OUTER JOINS-en_US.srt
|
9.4 KB
|
|
1. What is a Join & Oracle SQL Join Types-it_IT.srt
|
9.1 KB
|
|
1. What is a Join & Oracle SQL Join Types-pl_PL.srt
|
8.7 KB
|
|
8. Restricting Joins-pl_PL.srt
|
3.9 KB
|
|
1. What is a Join & Oracle SQL Join Types-en_US.srt
|
8.7 KB
|
|
6. Inner Join & Join with the ON Clause-it_IT.srt
|
8.2 KB
|
|
6. Inner Join & Join with the ON Clause-pl_PL.srt
|
8.1 KB
|
|
6. Inner Join & Join with the ON Clause-en_US.srt
|
7.9 KB
|
|
9. Self Join-it_IT.srt
|
7.2 KB
|
|
9. Self Join-pl_PL.srt
|
7.2 KB
|
|
4. Join with the USING Clause-it_IT.srt
|
6.9 KB
|
|
4. Join with the USING Clause-pl_PL.srt
|
6.8 KB
|
|
9. Self Join-en_US.srt
|
6.8 KB
|
|
4. Join with the USING Clause-en_US.srt
|
6.6 KB
|
|
NonEquiJoins-Source-Code.sql
|
1.6 KB
|
|
Source-Code-Differences-Between-All-Types-of-Joins.sql
|
2.7 KB
|
|
20. Which Join Type Should You Use-pl_PL.srt
|
4.9 KB
|
|
20. Which Join Type Should You Use-it_IT.srt
|
4.8 KB
|
|
14. FULL OUTER JOIN (FULL JOIN)-pl_PL.srt
|
4.7 KB
|
|
20. Which Join Type Should You Use-en_US.srt
|
4.6 KB
|
|
14. FULL OUTER JOIN (FULL JOIN)-en_US.srt
|
4.4 KB
|
|
2. Creating a Join-pl_PL.srt
|
3.8 KB
|
|
8. Restricting Joins-en_US.srt
|
3.8 KB
|
|
2. Creating a Join-it_IT.srt
|
3.7 KB
|
|
2. Creating a Join-en_US.srt
|
3.6 KB
|
|
7. Multiple Join Operations.mp4
|
207.3 MB
|
|
16. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1).mp4
|
206.3 MB
|
|
19. The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins.mp4
|
188.2 MB
|
|
10. Non-Equijoins (Joining Unequal Tables).mp4
|
156.5 MB
|
|
17. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2).mp4
|
128.8 MB
|
|
21. Entity-Relationship Models in DBMS - How to Use Them with Joins.mp4
|
121.1 MB
|
|
3. Natural Join.mp4
|
119.8 MB
|
|
18. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3).mp4
|
113.5 MB
|
|
1. What is a Join & Oracle SQL Join Types.mp4
|
109.5 MB
|
|
12. LEFT OUTER JOIN (LEFT JOIN).mp4
|
107.2 MB
|
|
13. RIGHT OUTER JOIN (RIGHT JOIN).mp4
|
83.6 MB
|
|
5. Handling Ambiguous Column Names.mp4
|
78.9 MB
|
|
11. OUTER JOINS.mp4
|
54.8 MB
|
|
9. Self Join.mp4
|
53.8 MB
|
|
6. Inner Join & Join with the ON Clause.mp4
|
44.8 MB
|
|
4. Join with the USING Clause.mp4
|
44.8 MB
|
|
14. FULL OUTER JOIN (FULL JOIN).mp4
|
27.9 MB
|
|
8. Restricting Joins.mp4
|
26.6 MB
|
|
2. Creating a Join.mp4
|
21.5 MB
|
|
20. Which Join Type Should You Use.mp4
|
16.5 MB
|
|
/.../6. Using Substitution Variables/
|
|
2. Double Ampersand (&&) and DEFINE & UNDEFINE Commands-it_IT.srt
|
21.5 KB
|
|
2. Double Ampersand (&&) and DEFINE & UNDEFINE Commands-pl_PL.srt
|
21.4 KB
|
|
2. Double Ampersand (&&) and DEFINE & UNDEFINE Commands-en_US.srt
|
21.1 KB
|
|
1. What is a Substitution Variable-en_US.srt
|
17.1 KB
|
|
1. What is a Substitution Variable-it_IT.srt
|
17.1 KB
|
|
1. What is a Substitution Variable-pl_PL.srt
|
16.8 KB
|
|
4. SET VERIFY ON SET VERIFY OFF Commands-it_IT.srt
|
9.2 KB
|
|
3. ACCEPT and PROMPT Commands-en_US.srt
|
9.0 KB
|
|
3. ACCEPT and PROMPT Commands-it_IT.srt
|
9.0 KB
|
|
3. ACCEPT and PROMPT Commands-pl_PL.srt
|
8.8 KB
|
|
4. SET VERIFY ON SET VERIFY OFF Commands-pl_PL.srt
|
8.7 KB
|
|
4. SET VERIFY ON SET VERIFY OFF Commands-en_US.srt
|
8.7 KB
|
|
2. Double Ampersand (&&) and DEFINE & UNDEFINE Commands.mp4
|
214.4 MB
|
|
1. What is a Substitution Variable.mp4
|
93.9 MB
|
|
3. ACCEPT and PROMPT Commands.mp4
|
79.1 MB
|
|
4. SET VERIFY ON SET VERIFY OFF Commands.mp4
|
72.3 MB
|
|
/.../11. Grouping Data/
|
|
1. GROUP BY Clause (Part 1)-it_IT.srt
|
19.1 KB
|
|
1. GROUP BY Clause (Part 1)-pl_PL.srt
|
18.7 KB
|
|
1. GROUP BY Clause (Part 1)-en_US.srt
|
18.3 KB
|
|
2. GROUP BY Clause (Part 2)-it_IT.srt
|
14.6 KB
|
|
2. GROUP BY Clause (Part 2)-pl_PL.srt
|
14.2 KB
|
|
2. GROUP BY Clause (Part 2)-en_US.srt
|
13.8 KB
|
|
3. HAVING Clause-it_IT.srt
|
10.6 KB
|
|
3. HAVING Clause-pl_PL.srt
|
10.2 KB
|
|
3. HAVING Clause-en_US.srt
|
10.1 KB
|
|
4. Nested Group Functions-it_IT.srt
|
5.6 KB
|
|
4. Nested Group Functions-pl_PL.srt
|
5.5 KB
|
|
4. Nested Group Functions-en_US.srt
|
5.3 KB
|
|
2. GROUP BY Clause (Part 2).mp4
|
145.7 MB
|
|
1. GROUP BY Clause (Part 1).mp4
|
86.7 MB
|
|
3. HAVING Clause.mp4
|
59.7 MB
|
|
4. Nested Group Functions.mp4
|
24.0 MB
|
|
/.../14. Working with the Oracle SET Operators/
|
|
1. Introduction to SET Operators in Oracle SQL-it_IT.srt
|
18.8 KB
|
|
1. Introduction to SET Operators in Oracle SQL-pl_PL.srt
|
18.4 KB
|
|
1. Introduction to SET Operators in Oracle SQL-en_US.srt
|
18.0 KB
|
|
2. UNION and UNION ALL Operators-it_IT.srt
|
17.5 KB
|
|
2. UNION and UNION ALL Operators-pl_PL.srt
|
17.1 KB
|
|
2. UNION and UNION ALL Operators-en_US.srt
|
16.6 KB
|
|
6. Using the ORDER BY Clause with SET Operators-it_IT.srt
|
8.8 KB
|
|
7. Combining Multiple Queries Using the SET Operators-en_US.srt
|
6.9 KB
|
|
6. Using the ORDER BY Clause with SET Operators-pl_PL.srt
|
8.7 KB
|
|
6. Using the ORDER BY Clause with SET Operators-en_US.srt
|
8.4 KB
|
|
5. Matching Unmatched Queries in SET Operations-it_IT.srt
|
7.4 KB
|
|
5. Matching Unmatched Queries in SET Operations-pl_PL.srt
|
7.2 KB
|
|
7. Combining Multiple Queries Using the SET Operators-it_IT.srt
|
7.0 KB
|
|
7. Combining Multiple Queries Using the SET Operators-pl_PL.srt
|
7.0 KB
|
|
5. Matching Unmatched Queries in SET Operations-en_US.srt
|
6.9 KB
|
|
4. MINUS Operator-pl_PL.srt
|
4.7 KB
|
|
4. MINUS Operator-it_IT.srt
|
4.7 KB
|
|
4. MINUS Operator-en_US.srt
|
4.6 KB
|
|
3. INTERSECT Operator-it_IT.srt
|
3.7 KB
|
|
3. INTERSECT Operator-pl_PL.srt
|
3.7 KB
|
|
3. INTERSECT Operator-en_US.srt
|
3.5 KB
|
|
Source-Code-Combining-Multiple-Queries-Using-the-SET-Operators.sql
|
2.5 KB
|
|
Source-Code-UNION-and-UNION-ALL-SET-Operators.sql
|
1.0 KB
|
|
1. Introduction to SET Operators in Oracle SQL.mp4
|
189.2 MB
|
|
2. UNION and UNION ALL Operators.mp4
|
114.0 MB
|
|
6. Using the ORDER BY Clause with SET Operators.mp4
|
52.8 MB
|
|
7. Combining Multiple Queries Using the SET Operators.mp4
|
46.7 MB
|
|
5. Matching Unmatched Queries in SET Operations.mp4
|
39.0 MB
|
|
4. MINUS Operator.mp4
|
25.4 MB
|
|
3. INTERSECT Operator.mp4
|
12.3 MB
|
|
/5. Sorting Data/
|
|
1. ORDER BY Clause-it_IT.srt
|
17.2 KB
|
|
1. ORDER BY Clause-en_US.srt
|
17.0 KB
|
|
1. ORDER BY Clause-pl_PL.srt
|
16.9 KB
|
|
5. Oracle FETCH Clause-pl_PL.srt
|
14.5 KB
|
|
5. Oracle FETCH Clause-it_IT.srt
|
14.3 KB
|
|
4. ROWNUM & ROWID in SQL-en_US.srt
|
14.2 KB
|
|
4. ROWNUM & ROWID in SQL-pl_PL.srt
|
14.2 KB
|
|
5. Oracle FETCH Clause-en_US.srt
|
14.0 KB
|
|
4. ROWNUM & ROWID in SQL-it_IT.srt
|
14.0 KB
|
|
2. ASC and DESC Operators-it_IT.srt
|
11.5 KB
|
|
2. ASC and DESC Operators-pl_PL.srt
|
11.4 KB
|
|
2. ASC and DESC Operators-en_US.srt
|
11.2 KB
|
|
1. ORDER BY Clause.mp4
|
249.0 MB
|
|
3. NULLS FIRST and NULLS LAST Operators-pl_PL.srt
|
5.1 KB
|
|
3. NULLS FIRST and NULLS LAST Operators-it_IT.srt
|
4.9 KB
|
|
3. NULLS FIRST and NULLS LAST Operators-en_US.srt
|
4.8 KB
|
|
4. ROWNUM & ROWID in SQL.mp4
|
171.6 MB
|
|
5. Oracle FETCH Clause.mp4
|
101.9 MB
|
|
2. ASC and DESC Operators.mp4
|
89.5 MB
|
|
3. NULLS FIRST and NULLS LAST Operators.mp4
|
25.5 MB
|
|
/4. Restricting Data/
|
|
7. Logical Operators (AND, OR, NOT)-pl_PL.srt
|
15.3 KB
|
|
7. Logical Operators (AND, OR, NOT)-it_IT.srt
|
15.3 KB
|
|
7. Logical Operators (AND, OR, NOT)-en_US.srt
|
15.0 KB
|
|
5. LIKE Operator-it_IT.srt
|
13.2 KB
|
|
5. LIKE Operator-en_US.srt
|
12.9 KB
|
|
5. LIKE Operator-pl_PL.srt
|
12.9 KB
|
|
4. IN Operator-it_IT.srt
|
12.3 KB
|
|
8. Rules of Precedence-it_IT.srt
|
12.0 KB
|
|
4. IN Operator-pl_PL.srt
|
12.0 KB
|
|
4. IN Operator-en_US.srt
|
11.9 KB
|
|
8. Rules of Precedence-pl_PL.srt
|
11.7 KB
|
|
8. Rules of Precedence-en_US.srt
|
11.2 KB
|
|
2. Comparison Operators-pl_PL.srt
|
7.0 KB
|
|
2. Comparison Operators-en_US.srt
|
6.9 KB
|
|
2. Comparison Operators-it_IT.srt
|
6.9 KB
|
|
3. BETWEEN ... AND Operator-pl_PL.srt
|
6.1 KB
|
|
3. BETWEEN ... AND Operator-it_IT.srt
|
6.1 KB
|
|
3. BETWEEN ... AND Operator-en_US.srt
|
5.9 KB
|
|
6. IS NULL Operator-pl_PL.srt
|
5.8 KB
|
|
6. IS NULL Operator-it_IT.srt
|
5.8 KB
|
|
6. IS NULL Operator-en_US.srt
|
5.6 KB
|
|
1. Using WHERE Clause-en_US.srt
|
5.0 KB
|
|
1. Using WHERE Clause-pl_PL.srt
|
5.0 KB
|
|
1. Using WHERE Clause-it_IT.srt
|
5.0 KB
|
|
7. Logical Operators (AND, OR, NOT).mp4
|
148.0 MB
|
|
5. LIKE Operator.mp4
|
142.0 MB
|
|
2. Comparison Operators.mp4
|
104.3 MB
|
|
4. IN Operator.mp4
|
60.9 MB
|
|
8. Rules of Precedence.mp4
|
60.6 MB
|
|
3. BETWEEN ... AND Operator.mp4
|
44.9 MB
|
|
6. IS NULL Operator.mp4
|
34.7 MB
|
|
1. Using WHERE Clause.mp4
|
33.3 MB
|
|
SQL-Quiz-by-Oracle-Master-Training.pdf
|
3.5 MB
|
|
/.../10. Group Functions/
|
|
7. LISTAGG Function-it_IT.srt
|
12.4 KB
|
|
7. LISTAGG Function-pl_PL.srt
|
12.2 KB
|
|
7. LISTAGG Function-en_US.srt
|
11.8 KB
|
|
1. Group Functions-it_IT.srt
|
10.3 KB
|
|
1. Group Functions-pl_PL.srt
|
9.9 KB
|
|
1. Group Functions-en_US.srt
|
9.8 KB
|
|
3. COUNT Function-it_IT.srt
|
8.1 KB
|
|
3. COUNT Function-pl_PL.srt
|
7.9 KB
|
|
3. COUNT Function-en_US.srt
|
7.7 KB
|
|
8. Overview Of Group Functions-pl_PL.srt
|
4.9 KB
|
|
5. MIN Function-it_IT.srt
|
5.7 KB
|
|
4. MAX Function-it_IT.srt
|
5.6 KB
|
|
5. MIN Function-pl_PL.srt
|
5.6 KB
|
|
4. MAX Function-pl_PL.srt
|
5.5 KB
|
|
5. MIN Function-en_US.srt
|
5.4 KB
|
|
4. MAX Function-en_US.srt
|
5.4 KB
|
|
8. Overview Of Group Functions-it_IT.srt
|
5.1 KB
|
|
6. SUM Function-it_IT.srt
|
4.8 KB
|
|
8. Overview Of Group Functions-en_US.srt
|
4.7 KB
|
|
6. SUM Function-pl_PL.srt
|
4.7 KB
|
|
6. SUM Function-en_US.srt
|
4.4 KB
|
|
1. Group Functions.mp4
|
59.1 MB
|
|
7. LISTAGG Function.mp4
|
58.3 MB
|
|
4. MAX Function.mp4
|
57.1 MB
|
|
2. AVG Function.mp4
|
50.9 MB
|
|
3. COUNT Function.mp4
|
26.1 MB
|
|
5. MIN Function.mp4
|
23.8 MB
|
|
8. Overview Of Group Functions.mp4
|
20.6 MB
|
|
6. SUM Function.mp4
|
15.4 MB
|
|
/.../17. Creating Constraints/
|
|
1. Creating Constraints-th_TH.srt
|
0.1 KB
|
|
2. NOT NULL Constraint-th_TH.srt
|
0.1 KB
|
|
3. UNIQUE Constraint-th_TH.srt
|
0.1 KB
|
|
4. PRIMARY KEY Constraint-th_TH.srt
|
0.1 KB
|
|
5. FOREIGN KEY Constraint-th_TH.srt
|
0.1 KB
|
|
6. CHECK Constraint-th_TH.srt
|
0.1 KB
|
|
1. Creating Constraints-en_US.srt
|
0.0 KB
|
|
1. Creating Constraints-id_ID.srt
|
0.0 KB
|
|
1. Creating Constraints-it_IT.srt
|
0.0 KB
|
|
1. Creating Constraints-pl_PL.srt
|
0.0 KB
|
|
1. Creating Constraints-ro_RO.srt
|
0.0 KB
|
|
2. NOT NULL Constraint-en_US.srt
|
0.0 KB
|
|
2. NOT NULL Constraint-id_ID.srt
|
0.0 KB
|
|
2. NOT NULL Constraint-it_IT.srt
|
0.0 KB
|
|
2. NOT NULL Constraint-pl_PL.srt
|
0.0 KB
|
|
2. NOT NULL Constraint-ro_RO.srt
|
0.0 KB
|
|
3. UNIQUE Constraint-en_US.srt
|
0.0 KB
|
|
3. UNIQUE Constraint-id_ID.srt
|
0.0 KB
|
|
3. UNIQUE Constraint-it_IT.srt
|
0.0 KB
|
|
3. UNIQUE Constraint-pl_PL.srt
|
0.0 KB
|
|
3. UNIQUE Constraint-ro_RO.srt
|
0.0 KB
|
|
4. PRIMARY KEY Constraint-en_US.srt
|
0.0 KB
|
|
4. PRIMARY KEY Constraint-id_ID.srt
|
0.0 KB
|
|
4. PRIMARY KEY Constraint-it_IT.srt
|
0.0 KB
|
|
4. PRIMARY KEY Constraint-pl_PL.srt
|
0.0 KB
|
|
4. PRIMARY KEY Constraint-ro_RO.srt
|
0.0 KB
|
|
5. FOREIGN KEY Constraint-en_US.srt
|
0.0 KB
|
|
5. FOREIGN KEY Constraint-id_ID.srt
|
0.0 KB
|
|
5. FOREIGN KEY Constraint-it_IT.srt
|
0.0 KB
|
|
5. FOREIGN KEY Constraint-pl_PL.srt
|
0.0 KB
|
|
5. FOREIGN KEY Constraint-ro_RO.srt
|
0.0 KB
|
|
6. CHECK Constraint-en_US.srt
|
0.0 KB
|
|
6. CHECK Constraint-id_ID.srt
|
0.0 KB
|
|
6. CHECK Constraint-it_IT.srt
|
0.0 KB
|
|
6. CHECK Constraint-pl_PL.srt
|
0.0 KB
|
|
6. CHECK Constraint-ro_RO.srt
|
0.0 KB
|
|
5. FOREIGN KEY Constraint.mp4
|
104.1 MB
|
|
3. UNIQUE Constraint.mp4
|
57.2 MB
|
|
4. PRIMARY KEY Constraint.mp4
|
35.5 MB
|
|
2. NOT NULL Constraint.mp4
|
30.8 MB
|
|
6. CHECK Constraint.mp4
|
21.9 MB
|
|
1. Creating Constraints.mp4
|
18.2 MB
|
|
Total files 833
|
-1.-database-concepts-hr-schema-relationship.png-2-4871ebd2fd5208799efb87472386a7a0bfc51c11.html){kind=link}