Udemy Oracle SQL Become Certified SQL Developer From Scratch | 426D6942F66D281BCB1D0D170CEFB8CAD0587CC5

Udemy Oracle SQL Become Certified SQL Developer From Scratch

Name	[Udemy] Oracle SQL - Become A Certified SQL Developer From Scratch!	DOWNLOAD Copy Link
Total Size	2.3 GB
Total Files	261
Hash	426D6942F66D281BCB1D0D170CEFB8CAD0587CC5

/1. Database Concepts/
1. What is a Database.mp4	84.2 MB
1. What is a Database.vtt	0.4 KB
2. Why Oracle Database.mp4	64.8 MB
2. Why Oracle Database.vtt	8.3 KB
3. What is a Table.mp4	46.0 MB
3. What is a Table.vtt	3.6 KB
4. UDEMY 101 How to Use Udemy +Some Useful Tips.mp4	53.1 MB
4. UDEMY 101 How to Use Udemy +Some Useful Tips.vtt	0.4 KB
5. Special Gifts for Our Students!(SQL Cheatsheet & SQL Certification Exam Samples).html	1.3 KB
5.1 Oracle-Database-12c-Database-SQL-1Z0-071-Exam [2016-07-12].pdf.pdf	588.2 KB
5.1 SQL Cheatsheet (Oracle Master).pdf.pdf	3.7 MB
5.2 Oracle-Database-12c-Database-SQL-1Z0-071-Exam [2018-06-30].pdf.pdf	2.4 MB
5.2 Oracle-Database-12c-SQL-Fundamentals-1Z0-061-Exam [04.03.2017].pdf.pdf	1.7 MB
5.3 Oracle-Database-12c-SQL-Fundamentals-1Z0-061-Exam [04.03.2017].pdf.pdf	1.7 MB
5.3 Oracle-Database-12c-SQL-Fundamentals-1Z0-061-Exam [18.06.2017].pdf.pdf	7.2 MB
5.4 Oracle-Database-12c-Database-SQL-1Z0-071-Exam [2016-07-12].pdf.pdf	588.2 KB
5.4 SQL Cheatsheet (Oracle Master).pdf.pdf	3.7 MB
5.5 Oracle-Database-12c-Database-SQL-1Z0-071-Exam [2018-06-30].pdf.pdf	2.4 MB
5.5 Oracle-Database-12c-SQL-Fundamentals-1Z0-061-Exam [18.06.2017].pdf.pdf	7.2 MB
6. What is a Relational Database.mp4	93.9 MB
6. What is a Relational Database.vtt	8.3 KB
7. Entity Relationship Logic in Databases.mp4	38.9 MB
7. Entity Relationship Logic in Databases.vtt	4.1 KB
8. The Sample (HR) Schema Used in This Course.mp4	79.8 MB
8. The Sample (HR) Schema Used in This Course.vtt	8.1 KB
8.1 HR-Schema-Relationship.png.png	238.7 KB
9. What is SQL.mp4	47.5 MB
9. What is SQL.vtt	5.5 KB
/.../10. Grouping Data/
1. GROUP BY Clause.mp4	36.2 MB
1. GROUP BY Clause.vtt	0.1 KB
2. HAVING Clause.mp4	16.0 MB
2. HAVING Clause.vtt	0.1 KB
3. Nesting Group Functions.mp4	7.8 MB
3. Nesting Group Functions.vtt	0.1 KB
4. Section 9 Quiz.html	0.2 KB
/.../11. Joining Multiple Tables/
1. Joining Multiple Tables & Types of Joins.mp4	7.4 MB
1. Joining Multiple Tables & Types of Joins.vtt	0.4 KB
10. OUTER JOINS.mp4	9.7 MB
10. OUTER JOINS.vtt	0.4 KB
11. LEFT OUTER JOIN.mp4	10.4 MB
11. LEFT OUTER JOIN.vtt	0.4 KB
12. RIGHT OUTER JOIN.mp4	18.2 MB
12. RIGHT OUTER JOIN.vtt	0.4 KB
13. FULL OUTER JOIN.mp4	6.3 MB
13. FULL OUTER JOIN.vtt	0.4 KB
14. CROSS JOIN (Cartesian Product).mp4	14.0 MB
14. CROSS JOIN (Cartesian Product).vtt	0.1 KB
15. Section 10 Quiz.html	0.2 KB
2. Natural Joins.mp4	20.0 MB
2. Natural Joins.vtt	0.1 KB
3. Join with USING Clause.mp4	12.9 MB
3. Join with USING Clause.vtt	0.1 KB
4. Handling Ambiguous Column Names.mp4	14.8 MB
4. Handling Ambiguous Column Names.vtt	0.1 KB
5. Join with ON Clause.mp4	11.8 MB
5. Join with ON Clause.vtt	0.1 KB
6. Multiple Join Operations.mp4	12.7 MB
6. Multiple Join Operations.vtt	0.1 KB
7. Restricting Joins.mp4	5.5 MB
7. Restricting Joins.vtt	0.1 KB
8. Joining Unequal Tables.mp4	7.5 MB
8. Joining Unequal Tables.vtt	0.1 KB
9. SELF JOIN.mp4	11.0 MB
9. SELF JOIN.vtt	0.4 KB
/.../12. Using Subqueries/
1. Using Subqueries.mp4	13.9 MB
1. Using Subqueries.vtt	0.4 KB
2. Single Row Subqueries.mp4	21.5 MB
2. Single Row Subqueries.vtt	0.4 KB
3. Multiple Row Subqueries.mp4	23.7 MB
3. Multiple Row Subqueries.vtt	0.4 KB
4. Multiple Column Subqueries.mp4	15.8 MB
4. Multiple Column Subqueries.vtt	0.1 KB
5. Section 11 Quiz.html	0.2 KB
/.../13. Using SET Operators/
1. SET Operators.mp4	25.5 MB
1. SET Operators.vtt	0.4 KB
1.1 Retired Employees Tables Creation Codes.pdf.pdf	261.9 KB
2. UNION and UNION ALL Operators.mp4	22.8 MB
2. UNION and UNION ALL Operators.vtt	0.1 KB
3. INTERSECT Operator.mp4	4.2 MB
3. INTERSECT Operator.vtt	0.4 KB
4. MINUS Operator.mp4	5.2 MB
4. MINUS Operator.vtt	0.4 KB
5. Matching Unmatched Queries in SET Operations.mp4	5.9 MB
5. Matching Unmatched Queries in SET Operations.vtt	0.4 KB
6. Order By with SET Operators.mp4	11.7 MB
6. Order By with SET Operators.vtt	0.1 KB
7. Section 12 Quiz.html	0.2 KB
/.../14. Data Manipulation Language (DML) Statements/
1. Data Manipulation Language (DML).mp4	5.6 MB
1. Data Manipulation Language (DML).vtt	0.1 KB
10. Section 13 Quiz.html	0.2 KB
2. INSERT Statement (Part 1).mp4	17.8 MB
2. INSERT Statement (Part 1).vtt	0.1 KB
3. INSERT Statement (Part 2).mp4	25.1 MB
3. INSERT Statement (Part 2).vtt	0.1 KB
4. UPDATE Statement.mp4	20.3 MB
4. UPDATE Statement.vtt	0.1 KB
5. DELETE Statement.mp4	12.2 MB
5. DELETE Statement.vtt	0.1 KB
6. Transaction Control Statements.mp4	8.8 MB
6. Transaction Control Statements.vtt	0.1 KB
7. COMMIT and ROLLBACK Statements.mp4	17.8 MB
7. COMMIT and ROLLBACK Statements.vtt	0.1 KB
8. SAVEPOINT Statement.mp4	22.0 MB
8. SAVEPOINT Statement.vtt	0.1 KB
9. FOR UPDATE Statement.mp4	18.0 MB
9. FOR UPDATE Statement.vtt	0.4 KB
/.../15. Data Definition Language (DDL) Statements/
1. Data Definition Language (DDL).mp4	5.3 MB
1. Data Definition Language (DDL).vtt	0.1 KB
2. Naming Rules.mp4	5.8 MB
2. Naming Rules.vtt	0.1 KB
3. CREATE TABLE Statement.mp4	35.4 MB
3. CREATE TABLE Statement.vtt	0.4 KB
4. ALTER TABLE Statement.mp4	38.7 MB
4. ALTER TABLE Statement.vtt	0.4 KB
5. DROP TABLE Statement.mp4	8.4 MB
5. DROP TABLE Statement.vtt	0.4 KB
6. TRUNCATE TABLE Statement.mp4	9.7 MB
6. TRUNCATE TABLE Statement.vtt	0.4 KB
7. COMMENT Statement.mp4	14.9 MB
7. COMMENT Statement.vtt	0.4 KB
8. RENAME Statement.mp4	11.8 MB
8. RENAME Statement.vtt	0.4 KB
9. Section 14 Quiz.html	0.2 KB
/.../16. Creating Constraints/
1. Creating Constraints.mp4	9.5 MB
1. Creating Constraints.vtt	0.4 KB
2. NOT NULL Constraint.mp4	11.9 MB
2. NOT NULL Constraint.vtt	0.4 KB
3. UNIQUE Constraint.mp4	21.2 MB
3. UNIQUE Constraint.vtt	0.4 KB
4. PRIMARY KEY Constraint.mp4	14.1 MB
4. PRIMARY KEY Constraint.vtt	0.4 KB
5. FOREIGN KEY Constraint.mp4	33.1 MB
5. FOREIGN KEY Constraint.vtt	0.1 KB
6. CHECK Constraint.mp4	8.8 MB
6. CHECK Constraint.vtt	0.4 KB
7. Section 15 Quiz.html	0.2 KB
/.../17. Conclusion + Bonus/
1. Conclusion.mp4	1.0 MB
1. Conclusion.vtt	0.4 KB
2. Bonus Code Samples.pdf	86.2 KB
3. Where to next.html	2.6 KB
3.1 Special Discounts For Our Students.xlsx.xlsx	36.1 KB
4. Course Bonuses (SQL Cheatsheet & SQL Certification Exam Samples).html	1.3 KB
4.1 Oracle Database 12c SQL Fundamentals 1Z0-061 Exam (04.03.2017).pdf.pdf	1.7 MB
4.2 Oracle Database 12c SQL Fundamentals 1Z0-061 Exam (23.01.2017).pdf.pdf	3.0 MB
4.3 SQL Cheatsheet (Oracle Master).pdf.pdf	3.7 MB
/.../2. Introduction and Software Installation/
1. About the Installation.mp4	52.6 MB
1. About the Installation.vtt	0.4 KB
10. The Working Document.html	0.6 KB
10.1 Working Document Link.html	0.1 KB
11. Don't Forget to Leave a Rating!.html	0.5 KB
12. Section 1 Quiz.html	0.2 KB
2. Which Option to Have a Database.mp4	90.7 MB
2. Which Option to Have a Database.vtt	90.7 MB
3. Option 1 Having The Database with Oracle VirtualBox.mp4	39.0 MB
3. Option 1 Having The Database with Oracle VirtualBox.vtt	13.0 KB
3.1 (Optional) Download Oracle's Virtual Machine (12c Release 2).html	0.1 KB
3.1 Step 2 Download Virtual Machine Image Link.html	0.1 KB
3.2 Linux Username and Password.txt.txt	0.2 KB
3.2 Step 2 Download Virtual Machine Image Link.html	0.1 KB
3.3 Linux Username and Password.txt.txt	0.2 KB
3.3 Oracle Master - Changing Virtual Machine Keyboard Input Settings.pdf.pdf	842.8 KB
3.4 (Optional) Download Oracle's Virtual Machine (12c Release 2).html	0.1 KB
3.4 Oracle Master - Changing Virtual Machine Keyboard Input Settings.pdf.pdf	842.8 KB
3.5 Step 1 Download Oracle Virtual Box.html	0.1 KB
4. How to Install VirtualBox on Mac OSX.html	3.9 KB
5. Option 2 Downloading And Installing Oracle Database.mp4	19.8 MB
5. Option 2 Downloading And Installing Oracle Database.vtt	0.4 KB
5.1 Oracle's Official Website.html	0.1 KB
6. Option 3 Using Oracle Live SQL.mp4	44.9 MB
6. Option 3 Using Oracle Live SQL.vtt	7.6 KB
7. Configuring and Using SQL Developer.mp4	28.2 MB
7. Configuring and Using SQL Developer.vtt	0.4 KB
8. How to Unlock HR Schema in Oracle.html	1.9 KB
9. SQL Statement used in this course.mp4	2.8 MB
9. SQL Statement used in this course.vtt	0.1 KB
/3. Retrieving Data/
1. Oracle Data Types.mp4	7.1 MB
1. Oracle Data Types.vtt	0.1 KB
10. Section 2 Quiz.html	0.2 KB
2. DESCRIBE Command.mp4	6.6 MB
2. DESCRIBE Command.vtt	0.1 KB
3. SQL Statement Basics.mp4	22.0 MB
3. SQL Statement Basics.vtt	0.4 KB
4. Using SELECT Statement.mp4	9.3 MB
4. Using SELECT Statement.vtt	0.4 KB
5. Using Column Aliases.mp4	15.1 MB
5. Using Column Aliases.vtt	0.4 KB
6. Quote (Q) Operator.mp4	12.5 MB
6. Quote (Q) Operator.vtt	0.1 KB
7. DISTINCT Operator.mp4	10.8 MB
7. DISTINCT Operator.vtt	0.1 KB
8. Concatenation Operators.mp4	15.0 MB
8. Concatenation Operators.vtt	0.1 KB
9. Arithmetic Expressions and NULL Values.mp4	19.7 MB
9. Arithmetic Expressions and NULL Values.vtt	0.1 KB
/4. Restricting Data/
1. Using WHERE Clause.mp4	6.1 MB
1. Using WHERE Clause.vtt	0.1 KB
10. Section 3 Quiz.html	0.2 KB
2. Comparison Operators.mp4	13.5 MB
2. Comparison Operators.vtt	0.1 KB
3. BETWEEN … AND Operator.mp4	10.6 MB
3. BETWEEN … AND Operator.vtt	0.1 KB
4. IN Operator.mp4	12.6 MB
4. IN Operator.vtt	0.4 KB
5. LIKE Operator.mp4	16.4 MB
5. LIKE Operator.vtt	0.1 KB
6. IS NULL Operator.mp4	5.4 MB
6. IS NULL Operator.vtt	0.1 KB
7. Logical Operators (AND, OR, NOT).mp4	25.1 MB
7. Logical Operators (AND, OR, NOT).vtt	0.1 KB
8. Rules of Precedence.mp4	10.8 MB
8. Rules of Precedence.vtt	0.1 KB
9. Quiz.html	0.2 KB
/5. Sorting Data/
1. ORDER BY Clause.mp4	10.3 MB
1. ORDER BY Clause.vtt	0.1 KB
2. ASC and DESC Operators.mp4	18.0 MB
2. ASC and DESC Operators.vtt	0.1 KB
3. NULLS FIRST and NULLS LAST Operators.mp4	11.8 MB
3. NULLS FIRST and NULLS LAST Operators.vtt	0.1 KB
4. Section 4 Quiz.html	0.2 KB
/.../6. Single-Row Functions/
1. Single Row Functions.mp4	16.1 MB
1. Single Row Functions.vtt	0.1 KB
2. Character Functions (Part 1).mp4	22.8 MB
2. Character Functions (Part 1).vtt	0.4 KB
3. Character Functions (Part 2).mp4	30.4 MB
3. Character Functions (Part 2).vtt	0.1 KB
4. Number Functions.mp4	16.5 MB
4. Number Functions.vtt	0.1 KB
5. Nesting Functions.mp4	14.2 MB
5. Nesting Functions.vtt	0.1 KB
6. Date Functions.mp4	15.1 MB
6. Date Functions.vtt	0.1 KB
7. Date Operations.mp4	38.6 MB
7. Date Operations.vtt	0.1 KB
8. Section 5 Quiz.html	0.2 KB
/7. Conversion Functions/
1. Conversion Functions.mp4	14.1 MB
1. Conversion Functions.vtt	0.1 KB
2. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1).mp4	19.0 MB
2. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1).vtt	0.1 KB
3. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2).mp4	24.6 MB
3. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2).vtt	0.1 KB
4. NVL, NVL2, NULLIF, COALESCE Functions.mp4	25.6 MB
4. NVL, NVL2, NULLIF, COALESCE Functions.vtt	0.0 KB
5. Section 6 Quiz.html	0.2 KB
/8. Conditional Expressions/
1. Conditional Expressions (CASE-DECODE).mp4	38.0 MB
1. Conditional Expressions (CASE-DECODE).vtt	0.1 KB
2. Section 7 Quiz.html	0.2 KB
/9. Group Functions/
1. Group Functions.mp4	8.2 MB
1. Group Functions.vtt	0.1 KB
2. AVG Function.mp4	8.8 MB
2. AVG Function.vtt	0.1 KB
3. COUNT Function.mp4	9.3 MB
3. COUNT Function.vtt	0.1 KB
4. MAX Function.mp4	7.8 MB
4. MAX Function.vtt	0.1 KB
5. MIN Function.mp4	9.8 MB
5. MIN Function.vtt	0.1 KB
6. SUM Function.mp4	6.1 MB
6. SUM Function.vtt	0.1 KB
7. Overview Of Group Functions.mp4	5.4 MB
7. Overview Of Group Functions.vtt	0.1 KB
8. Section 8 Quiz.html	0.2 KB
Total files 261