FreeCourseSite com Udemy - The Complete Oracle SQL Certification Course

1. 1. Database Basics/1. Oracle Database Introduction & Basics of Tables.mp435.71MB
2. 1. Database Basics/2. Setting Up the SQL Development Environment (Mac & Windows).mp415.71MB
3. 1. Database Basics/3. IMPORTANT Prepare the Data in the Database.mp415.1MB
4. 2. Single Table Queries (Exercises & Solutions in the Lectures)/2. Retrieving Data Using the SELECT Clause.mp425.28MB
5. 2. Single Table Queries (Exercises & Solutions in the Lectures)/3. Using the WHERE Clause in a Query.mp442.34MB
6. 2. Single Table Queries (Exercises & Solutions in the Lectures)/4. Using Operators in the WHERE Clause.mp447.14MB
7. 2. Single Table Queries (Exercises & Solutions in the Lectures)/5. Combining WHERE, AND & OR with Operators.mp442.36MB
8. 2. Single Table Queries (Exercises & Solutions in the Lectures)/6. Query Filtering Continued BETWEEN, IN and NULL.mp444.25MB
9. 2. Single Table Queries (Exercises & Solutions in the Lectures)/7. Query Filtering Conditions & Operator Precedence.mp443.53MB
10. 2. Single Table Queries (Exercises & Solutions in the Lectures)/8. Ordering, Concatenating & Aliasing Query Results.mp443.09MB
11. 3. Single Row Functions (Exercises and Solutions In the Lectures)/1. Single Row Functions (SRF) & Using The Dual Table.mp440.78MB
12. 3. Single Row Functions (Exercises and Solutions In the Lectures)/2. Using Functions in WHERE And Character Based SRFs.mp441.7MB
13. 3. Single Row Functions (Exercises and Solutions In the Lectures)/3. Numeric and Date Data type SRFs.mp440.5MB
14. 3. Single Row Functions (Exercises and Solutions In the Lectures)/4. Conversion SRFs & Date Formatting.mp438.14MB
15. 3. Single Row Functions (Exercises and Solutions In the Lectures)/6. Concluding SRFs & NULL NULLIF Functions.mp433.34MB
16. 4. Grouping Functions (Exercises and Solutions In the Lectures)/1. Grouping Functions MIN, MAX, AVG, COUNT etc..mp440.43MB
17. 4. Grouping Functions (Exercises and Solutions In the Lectures)/2. GROUP BY Clause & HAVING Clause.mp440.21MB
18. 4. Grouping Functions (Exercises and Solutions In the Lectures)/3. More Practice With The GROUP BY Clause.mp428MB
19. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/1. SELECT within SELECT (Subqueries).mp448.09MB
20. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/2. Relating Tables Together Using JOINs.mp441.67MB
21. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/3. Joins Continued INNER & OUTER Joins.mp448.02MB
22. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/4. Correlated Subqueries with EXISTS & NOT EXIST operators.mp444.22MB
23. 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/1. Creating Your Own Tables & Design Considerations.mp442.45MB
24. 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/10. Views and Other Objects and Commands (Newly Added).mp451.59MB
25. 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/12. Granting and Revoking Privileges.mp4339.87MB
26. 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/2. Inserting Data Into Our Table.mp440.18MB
27. 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/3. Create Table With a Primary Key Constraint.mp447.4MB
28. 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/4. Using ALTER to modify the table structure.mp434.77MB
29. 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/5. Create Table with SELECT + UPDATE Data.mp443.99MB
30. 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7. DELETE, TRUNCATE, and DROP Commands.mp440.83MB
31. 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/8. Working With Database Indexes.mp429.12MB
32. 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/9. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).mp463.38MB