FreeCourseSite com Udemy The Complete Oracle SQL Certification Course

FreeCourseSite com Udemy The Complete Oracle SQL Certification Course

Name	[FreeCourseSite.com] Udemy - The Complete Oracle SQL Certification Course	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	6.5 GB
Total Files	174
Hash	2C02EC36FD5E133491332D719DC1E35102006139

/0. Websites you may like/
[CourseClub.ME].url	0.1 KB
[FCS Forum].url	0.1 KB
[FreeCourseSite.com].url	0.1 KB
/1. Database Basics/
1. Oracle Database Introduction & Basics of Tables.mp4	70.8 MB
1. Oracle Database Introduction & Basics of Tables.srt	21.2 MB
2. Creating the Workspace in Oracle.mp4	52.8 MB
2. Creating the Workspace in Oracle.srt	10.5 KB
3. IMPORTANT Prepare the Sample Data.mp4	25.4 MB
3. IMPORTANT Prepare the Sample Data.srt	6.0 KB
3.1 course_data.txt	2.5 KB
4. How to Proceed in This Course.mp4	49.8 MB
4. How to Proceed in This Course.srt	4.2 KB
/10. APPENDIX - Installing Oracle on Windows/
1. Install Oracle Database 19c in Windows.mp4	82.4 MB
1. Install Oracle Database 19c in Windows.srt	16.6 KB
2. Install Oracle SQL Developer in Windows.mp4	99.7 MB
2. Install Oracle SQL Developer in Windows.srt	22.5 KB
/2. Single Table Queries (Exercises & Solutions in the Lectures)/
1. Oracle Exams and Certification Information.html	0.7 KB
10. Ordering, Concatenating & Aliasing Query Results.mp4	114.8 MB
10. Ordering, Concatenating & Aliasing Query Results.srt	26.4 KB
10.1 Code for Ordering, Concatenating & Aliasing Query Results.txt	0.7 KB
11. Assignment 1 Practice with Single Table Queries.html	5.4 KB
2. Retrieving Data Using the SELECT Clause.mp4	26.5 MB
2. Retrieving Data Using the SELECT Clause.srt	20.5 KB
2.1 Code for Select Clause.txt	0.2 KB
3. Using the WHERE Clause in a Query.mp4	98.4 MB
3. Using the WHERE Clause in a Query.srt	26.6 KB
3.1 Code for WHERE Clause.txt	0.1 KB
4. Using Operators in the WHERE Clause.mp4	128.9 MB
4. Using Operators in the WHERE Clause.srt	29.0 KB
4.1 Code for Using Operators in the WHERE Clause.txt	0.7 KB
5. Some Inspiration.mp4	53.4 MB
5. Some Inspiration.srt	4.6 KB
6. Combining WHERE, AND & OR with Operators.mp4	109.6 MB
6. Combining WHERE, AND & OR with Operators.srt	29.1 KB
6.1 Code for Combining WHERE, AND & OR Operators.txt	0.3 KB
7. Query Filtering Continued BETWEEN, IN and NULL.mp4	115.3 MB
7. Query Filtering Continued BETWEEN, IN and NULL.srt	27.5 KB
7.1 Code for Query Filtering Continued BETWEEN, IN & NULL.txt	0.6 KB
8. What Will Make you Grow as a Software Developer.mp4	68.2 MB
8. What Will Make you Grow as a Software Developer.srt	6.1 KB
9. Query Filtering Conditions & Operator Precedence.mp4	115.5 MB
9. Query Filtering Conditions & Operator Precedence.srt	28.0 KB
9.1 Code for Query Filtering Conditions & Operator Precedence.txt	0.7 KB
/3. Single Row Functions (Exercises and Solutions In the Lectures)/
1. Single Row Functions (SRF) & Using The Dual Table.mp4	101.2 MB
1. Single Row Functions (SRF) & Using The Dual Table.srt	27.3 KB
1.1 Code for Single Row Functions (SRF) & Using the Dual Table.txt	0.7 KB
2. Using Functions in WHERE And Character Based SRFs.mp4	108.4 MB
2. Using Functions in WHERE And Character Based SRFs.srt	27.1 KB
2.1 Code for Using Functions in WHERE and Character Based SRFs.txt	1.0 KB
3. Numeric and Date Data type SRFs.mp4	103.4 MB
3. Numeric and Date Data type SRFs.srt	28.3 KB
3.1 Code for Numeric and Date Datatype SRFs.txt	1.1 KB
4. Conversion SRFs and Date Formatting.mp4	99.8 MB
4. Conversion SRFs and Date Formatting.srt	28.1 KB
4.1 Code for Conversion SRFs & Date Formatting.txt	0.5 KB
5. Some More Date Functions.html	0.7 KB
6. Concluding SRFs & NULL NULLIF Functions.mp4	82.1 MB
6. Concluding SRFs & NULL NULLIF Functions.srt	23.9 KB
6.1 Code for Concluding SRFs & NULLNULLIF Functions.txt	0.8 KB
7. Assignment 2 Practice with Single Row Functions.html	6.8 KB
/4. Grouping Functions (Exercises and Solutions In the Lectures)/
1. Grouping Functions MIN, MAX, AVG, COUNT etc..mp4	105.8 MB
1. Grouping Functions MIN, MAX, AVG, COUNT etc..srt	28.0 KB
1.1 Code for Grouping Functions MIN, MAX, AVG, COUNT etc.txt	0.9 KB
2. GROUP BY Clause & HAVING Clause.mp4	104.0 MB
2. GROUP BY Clause & HAVING Clause.srt	29.0 KB
2.1 Code for GROUP BY Clause & HAVING CLAUSE.txt	0.6 KB
3. More Practice With The GROUP BY Clause.mp4	68.5 MB
3. More Practice With The GROUP BY Clause.srt	18.0 KB
3.1 Code for More Practice with the GROUP BY Clause.txt	0.3 KB
/5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/
1. SELECT within SELECT (Subqueries).mp4	133.3 MB
1. SELECT within SELECT (Subqueries).srt	35.1 KB
1.1 Code for SELECT within SELECT (Nested Queries Subqueries).txt	1.3 KB
2. Relating Tables Together Using JOINs.mp4	115.7 MB
2. Relating Tables Together Using JOINs.srt	28.0 KB
2.1 Code for Relating Tables together using JOINs .txt	1.2 KB
3. Joins Continued INNER & OUTER Joins.mp4	144.2 MB
3. Joins Continued INNER & OUTER Joins.srt	31.1 KB
3.1 Code for JOINS Continued INNER & OUTER Joins.txt	1.2 KB
4. Career Advice.mp4	31.8 MB
4. Career Advice.srt	2.8 KB
5. Correlated Subqueries with EXISTS & NOT EXIST operators.mp4	128.5 MB
5. Correlated Subqueries with EXISTS & NOT EXIST operators.srt	30.6 KB
5.1 Code for More JOINS with Correlated Subqueries .txt	1.1 KB
6. SELF JOIN.mp4	61.9 MB
6. SELF JOIN.srt	17.1 KB
7. CROSS JOIN, NATURAL JOIN and the USING CLAUSE.mp4	55.7 MB
7. CROSS JOIN, NATURAL JOIN and the USING CLAUSE.srt	12.9 KB
8. EQUIJOIN and NON-EQUIJOINs.mp4	48.1 MB
8. EQUIJOIN and NON-EQUIJOINs.srt	14.8 KB
8.1 Code for EQUI and NON-EQUI Joins.txt	0.4 KB
9. CASE Statements.mp4	64.6 MB
9. CASE Statements.srt	12.1 KB
9.1 Oracle COALESCE Function.pdf	290.0 KB
9.2 Code for CASE Statement.txt	0.4 KB
/6. Analytical Functions using OVER and PARTITION with ORDER BY/
1. OVER Clause with PARTITION BY.mp4	123.8 MB
1. OVER Clause with PARTITION BY.srt	28.2 KB
2. Compute Running Totals with Ordering and Partitioning.mp4	134.6 MB
2. Compute Running Totals with Ordering and Partitioning.srt	29.5 KB
3. Unbounded Preceding Order in Over Clause.mp4	64.1 MB
3. Unbounded Preceding Order in Over Clause.srt	14.2 KB
4. Slicing Windows and Filtering with Analytic Functions.mp4	47.0 MB
4. Slicing Windows and Filtering with Analytic Functions.srt	10.4 KB
5. Rank, Dense_rank, Lead, and Lag Functions.mp4	113.1 MB
5. Rank, Dense_rank, Lead, and Lag Functions.srt	24.5 KB
/7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/
1. Creating Your Own Tables & Design Considerations.mp4	123.2 MB
1. Creating Your Own Tables & Design Considerations.srt	32.0 KB
1.1 Code for Creating Your Own Tables & Design Considerations.txt	0.2 KB
10. DELETE, TRUNCATE, and DROP Commands.mp4	119.8 MB
10. DELETE, TRUNCATE, and DROP Commands.srt	26.2 KB
10.1 Code for Delete, Truncate and Drop Commands.txt	0.4 KB
11. Working With Database Indexes.mp4	84.4 MB
11. Working With Database Indexes.srt	20.5 KB
11.1 Code for Database Indexes.txt	0.6 KB
12. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).mp4	166.8 MB
12. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).srt	33.3 KB
12.1 Code for System Tables, Pseudo Columns, & Deleting Duplicate Data.txt	1.2 KB
13. Views and Other Objects and Commands (Newly Added).mp4	145.0 MB
13. Views and Other Objects and Commands (Newly Added).srt	33.7 KB
13.1 Code for Other Objects and Commands VIEWs UNIONALL etc.txt	1.6 KB
14. SQL could be tricky, check this out!.html	1.2 KB
15. Granting and Revoking Privileges.mp4	356.4 MB
15. Granting and Revoking Privileges.srt	20.5 KB
16. BECOME A SQL QUERY WIZARD!.html	0.7 KB
17. Bonus Lecture Lifetime Access to All My Courses.html	1.0 KB
2. Inserting Data Into Our Table.mp4	119.3 MB
2. Inserting Data Into Our Table.srt	28.1 KB
2.1 Code for Inserting Data Into our Table.txt	1.0 KB
3. Create Table With a Primary Key Constraint.mp4	153.6 MB
3. Create Table With a Primary Key Constraint.srt	33.4 KB
3.1 Code for Create Table With Primary Key Constraint.txt	2.0 KB
4. INSERT ALL for Multi-table & Conditional Inserts.mp4	80.8 MB
4. INSERT ALL for Multi-table & Conditional Inserts.srt	16.1 KB
4.1 Code for Multi-Table Insert Using INSERT ALL.txt	1.0 KB
5. Using ALTER to modify the table structure.mp4	104.9 MB
5. Using ALTER to modify the table structure.srt	23.1 KB
5.1 Code for Alter Table and Modify Column Attributes.txt	0.7 KB
6. Create Table with SELECT + UPDATE Data.mp4	129.5 MB
6. Create Table with SELECT + UPDATE Data.srt	27.8 KB
6.1 Code for Create Table with SELECT and UPDATE existing Data.txt	0.7 KB
7. MERGE Statement in Oracle.mp4	123.2 MB
7. MERGE Statement in Oracle.srt	24.0 KB
7.1 Code for MERGE Statement.txt	1.1 KB
7.2 merge_sql_example.txt	2.9 KB
8. Primary and Foreign Keys.html	1.6 KB
9. Sequence Statements.mp4	67.7 MB
9. Sequence Statements.srt	18.2 KB
9.1 Code for Sequence Statements.txt	0.3 KB
/8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/
1. OFFSET and FETCH.mp4	69.1 MB
1. OFFSET and FETCH.srt	17.0 KB
2. ERD Diagrams.mp4	64.9 MB
2. ERD Diagrams.srt	29.3 KB
3. Commit, Rollback, and Savepoint.mp4	57.0 MB
3. Commit, Rollback, and Savepoint.srt	23.0 KB
4. Large Objects and Interval Data Types.mp4	137.7 MB
4. Large Objects and Interval Data Types.srt	29.3 KB
4.1 code for building_lease example.txt	0.5 KB
5. Using Cascade Constraints and On Delete Cascade.mp4	120.3 MB
5. Using Cascade Constraints and On Delete Cascade.srt	28.5 KB
5.1 code for cascade constraints.txt	0.8 KB
6. UNUSED Columns.mp4	40.6 MB
6. UNUSED Columns.srt	12.3 KB
7. External Tables.mp4	112.8 MB
7. External Tables.srt	24.9 KB
7.1 code for external tables.txt	1.0 KB
8. SQL Plus and Substitution Variables.mp4	236.5 MB
8. SQL Plus and Substitution Variables.srt	55.1 KB
/9. Exam Question Walkthrough Videos + 2 Exams/
1. QA 1- DML, DDL, and Transaction Control.mp4	176.1 MB
1. QA 1- DML, DDL, and Transaction Control.srt	41.8 KB
2. QA 2- Fetch and Substitution Variables.mp4	185.6 MB
2. QA 2- Fetch and Substitution Variables.srt	43.1 KB
3. QA 3- Conversion Functions, T0_CHAR, TO_DATE, and NVL.mp4	224.3 MB
3. QA 3- Conversion Functions, T0_CHAR, TO_DATE, and NVL.srt	49.7 KB
4. Practice Test 1.html	0.2 KB
5. Practice Test 2.html	0.2 KB
Total files 174