FreeCourseWorld Com Udemy - The Complete Oracle SQL Certification Course

1. 01 Database Basics/001 Oracle Database Introduction Basics of Tables.mp467.54MB
2. 01 Database Basics/002 Creating the Workspace in Oracle.mp450.35MB
3. 01 Database Basics/003 IMPORTANT Prepare the Sample Data.mp424.27MB
4. 02 Single Table Queries (Exercises Solutions in the Lectures)/005 Retrieving Data Using the SELECT Clause.mp425.28MB
5. 02 Single Table Queries (Exercises Solutions in the Lectures)/006 Using the WHERE Clause in a Query.mp493.85MB
6. 02 Single Table Queries (Exercises Solutions in the Lectures)/007 Using Operators in the WHERE Clause.mp4122.9MB
7. 02 Single Table Queries (Exercises Solutions in the Lectures)/008 Combining WHERE AND OR with Operators.mp4104.51MB
8. 02 Single Table Queries (Exercises Solutions in the Lectures)/009 Query Filtering Continued BETWEEN IN and NULL.mp4109.93MB
9. 02 Single Table Queries (Exercises Solutions in the Lectures)/010 Query Filtering Conditions Operator Precedence.mp4110.1MB
10. 02 Single Table Queries (Exercises Solutions in the Lectures)/011 Ordering Concatenating Aliasing Query Results.mp4109.52MB
11. 03 Single Row Functions (Exercises and Solutions In the Lectures)/012 Single Row Functions (SRF) Using The Dual Table.mp496.52MB
12. 03 Single Row Functions (Exercises and Solutions In the Lectures)/013 Using Functions in WHERE And Character Based SRFs.mp4103.36MB
13. 03 Single Row Functions (Exercises and Solutions In the Lectures)/014 Numeric and Date Data type SRFs.mp498.63MB
14. 03 Single Row Functions (Exercises and Solutions In the Lectures)/015 Conversion SRFs and Date Formatting.mp495.13MB
15. 03 Single Row Functions (Exercises and Solutions In the Lectures)/017 Concluding SRFs NULL NULLIF Functions.mp478.27MB
16. 04 Grouping Functions (Exercises and Solutions In the Lectures)/018 Grouping Functions MIN MAX AVG COUNT etc.mp4100.87MB
17. 04 Grouping Functions (Exercises and Solutions In the Lectures)/019 GROUP BY Clause HAVING Clause.mp499.16MB
18. 04 Grouping Functions (Exercises and Solutions In the Lectures)/020 More Practice With The GROUP BY Clause.mp465.32MB
19. 05 Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/021 SELECT within SELECT (Subqueries).mp4127.16MB
20. 05 Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/022 Relating Tables Together Using JOINs.mp4110.31MB
21. 05 Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/023 Joins Continued INNER OUTER Joins.mp4137.48MB
22. 05 Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/024 Correlated Subqueries with EXISTS NOT EXIST operators.mp4122.55MB
23. 05 Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/025 CASE Statements.mp461.6MB
24. 06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/026 Creating Your Own Tables Design Considerations.mp4117.44MB
25. 06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/027 Inserting Data Into Our Table.mp4113.77MB
26. 06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/028 Create Table With a Primary Key Constraint.mp4146.48MB
27. 06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/029 INSERT ALL for Multi-table Conditional Inserts.mp477.04MB
28. 06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/030 Using ALTER to modify the table structure.mp4100MB
29. 06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/031 Create Table with SELECT UPDATE Data.mp4123.52MB
30. 06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/032 MERGE Statement in Oracle.mp4117.44MB
31. 06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/034 Sequence Statements.mp464.59MB
32. 06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/035 DELETE TRUNCATE and DROP Commands.mp4114.23MB
33. 06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/036 Working With Database Indexes.mp480.44MB
34. 06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/037 System Tables Pseudo Columns Deleting Duplicates (Newly Added).mp4159.06MB
35. 06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/038 Views and Other Objects and Commands (Newly Added).mp4138.28MB
36. 06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/040 Granting and Revoking Privileges.mp4339.86MB