FreeCourseLab com Udemy The Complete Oracle SQL Certification Course

FreeCourseLab com Udemy The Complete Oracle SQL Certification Course

Name	[FreeCourseLab.com] Udemy - The Complete Oracle SQL Certification Course	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	1.7 GB
Total Files	75
Hash	DCA2A1F227B4CC123C94CD11C3DC6AB80FE64555

/1. Database Basics/
1. Oracle Database Introduction & Basics of Tables.mp4	37.4 MB
1. Oracle Database Introduction & Basics of Tables.vtt	27.9 KB
2. Setting Up the SQL Development Environment (Mac & Windows).mp4	16.5 MB
2. Setting Up the SQL Development Environment (Mac & Windows).vtt	7.3 KB
3. IMPORTANT Prepare the Data in the Database.mp4	15.8 MB
3. IMPORTANT Prepare the Data in the Database.vtt	6.0 KB
3.1 course_data.txt.txt	2.5 KB
/2. Single Table Queries (Exercises & Solutions in the Lectures)/
1. Oracle Exams and Certification Information.html	0.7 KB
10. Practice Test For Single Table Queries.html	0.2 KB
2. Retrieving Data Using the SELECT Clause.mp4	26.5 MB
2. Retrieving Data Using the SELECT Clause.vtt	18.9 KB
3. Using the WHERE Clause in a Query.mp4	44.4 MB
3. Using the WHERE Clause in a Query.vtt	24.4 KB
4. Using Operators in the WHERE Clause.mp4	49.4 MB
4. Using Operators in the WHERE Clause.vtt	26.2 KB
5. Combining WHERE, AND & OR with Operators.mp4	44.4 MB
5. Combining WHERE, AND & OR with Operators.vtt	26.6 KB
6. Query Filtering Continued BETWEEN, IN and NULL.mp4	46.4 MB
6. Query Filtering Continued BETWEEN, IN and NULL.vtt	25.4 KB
7. Query Filtering Conditions & Operator Precedence.mp4	45.6 MB
7. Query Filtering Conditions & Operator Precedence.vtt	25.4 KB
8. Ordering, Concatenating & Aliasing Query Results.mp4	45.2 MB
8. Ordering, Concatenating & Aliasing Query Results.vtt	25.0 KB
9. Practice with single table queries.html	0.2 KB
/3. Single Row Functions (Exercises and Solutions In the Lectures)/
1. Single Row Functions (SRF) & Using The Dual Table.mp4	42.8 MB
1. Single Row Functions (SRF) & Using The Dual Table.vtt	25.7 KB
2. Using Functions in WHERE And Character Based SRFs.mp4	43.7 MB
2. Using Functions in WHERE And Character Based SRFs.vtt	25.4 KB
3. Numeric and Date Data type SRFs.mp4	42.5 MB
3. Numeric and Date Data type SRFs.vtt	26.5 KB
4. Conversion SRFs & Date Formatting.mp4	40.0 MB
4. Conversion SRFs & Date Formatting.vtt	25.7 KB
5. Some More Date Functions.html	0.7 KB
6. Concluding SRFs & NULL NULLIF Functions.mp4	35.0 MB
6. Concluding SRFs & NULL NULLIF Functions.vtt	22.4 KB
7. Practice with Single Row Functions.html	0.2 KB
/4. Grouping Functions (Exercises and Solutions In the Lectures)/
1. Grouping Functions MIN, MAX, AVG, COUNT etc..mp4	42.4 MB
1. Grouping Functions MIN, MAX, AVG, COUNT etc..vtt	26.2 KB
2. GROUP BY Clause & HAVING Clause.mp4	42.2 MB
2. GROUP BY Clause & HAVING Clause.vtt	26.8 KB
3. More Practice With The GROUP BY Clause.mp4	29.4 MB
3. More Practice With The GROUP BY Clause.vtt	16.8 KB
/5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/
1. SELECT within SELECT (Subqueries).mp4	50.4 MB
1. SELECT within SELECT (Subqueries).vtt	32.3 KB
2. Relating Tables Together Using JOINs.mp4	43.7 MB
2. Relating Tables Together Using JOINs.vtt	25.9 KB
3. Joins Continued INNER & OUTER Joins.mp4	50.3 MB
3. Joins Continued INNER & OUTER Joins.vtt	29.0 KB
4. Correlated Subqueries with EXISTS & NOT EXIST operators.mp4	46.4 MB
4. Correlated Subqueries with EXISTS & NOT EXIST operators.vtt	28.1 KB
/6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/
1. Creating Your Own Tables & Design Considerations.mp4	44.5 MB
1. Creating Your Own Tables & Design Considerations.vtt	29.0 KB
10. Views and Other Objects and Commands (Newly Added).mp4	54.1 MB
10. Views and Other Objects and Commands (Newly Added).vtt	31.6 KB
11. SQL could be tricky, check this out!.html	1.2 KB
12. Granting and Revoking Privileges.mp4	356.4 MB
12. Granting and Revoking Privileges.vtt	18.7 KB
13. BECOME A SQL QUERY WIZARD!.html	0.7 KB
14. Bonus Lecture Lifetime Access to All My Courses.html	0.7 KB
2. Inserting Data Into Our Table.mp4	42.1 MB
2. Inserting Data Into Our Table.vtt	25.9 KB
3. Create Table With a Primary Key Constraint.mp4	49.7 MB
3. Create Table With a Primary Key Constraint.vtt	30.8 KB
4. Using ALTER to modify the table structure.mp4	36.5 MB
4. Using ALTER to modify the table structure.vtt	21.4 KB
5. Create Table with SELECT + UPDATE Data.mp4	46.1 MB
5. Create Table with SELECT + UPDATE Data.vtt	25.3 KB
6. Primary and Foreign Keys.html	1.6 KB
7. DELETE, TRUNCATE, and DROP Commands.mp4	42.8 MB
7. DELETE, TRUNCATE, and DROP Commands.vtt	23.9 KB
8. Working With Database Indexes.mp4	30.5 MB
8. Working With Database Indexes.vtt	19.1 KB
9. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).mp4	66.5 MB
9. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).vtt	31.7 KB
/
[FreeCourseLab.com].url	0.1 KB
Total files 75