FreeTutorials us the-complete-oracle-sql-certification-course

1. 01 Database Basics/001 Course Overview.mp424.05MB
2. 01 Database Basics/002 Oracle Database Introduction Basics of Tables.mp438.51MB
3. 01 Database Basics/003 Setting Up the SQL Development Environment Mac Windows.mp445.11MB
4. 02 Single Table Queries Exercises Solutions in the Lectures/004 Retrieving Data Using the SELECT Clause.mp457.13MB
5. 02 Single Table Queries Exercises Solutions in the Lectures/005 Using the WHERE Clause in a Query.mp449.53MB
6. 02 Single Table Queries Exercises Solutions in the Lectures/006 Using Operators in the WHERE Clause.mp469.89MB
7. 02 Single Table Queries Exercises Solutions in the Lectures/007 Combining WHERE AND OR with Operators.mp455.67MB
8. 02 Single Table Queries Exercises Solutions in the Lectures/008 Query Filtering Continued BETWEEN IN and NULL.mp458.46MB
9. 02 Single Table Queries Exercises Solutions in the Lectures/009 Query Filtering Conditions Operator Precedence.mp458.59MB
10. 02 Single Table Queries Exercises Solutions in the Lectures/010 Ordering Concatenating Aliasing Query Results.mp457.71MB
11. 03 Single Row Functions Exercises and Solutions In the Lectures/011 Single Row Functions SRF Using The Dual Table.mp450.35MB
12. 03 Single Row Functions Exercises and Solutions In the Lectures/012 Using Functions in WHERE And Character Based SRFs.mp453.01MB
13. 03 Single Row Functions Exercises and Solutions In the Lectures/013 Numeric and Date Data type SRFs.mp450.42MB
14. 03 Single Row Functions Exercises and Solutions In the Lectures/014 Conversion SRFs Date Formatting.mp447.95MB
15. 03 Single Row Functions Exercises and Solutions In the Lectures/015 Concluding SRFs NULL NULLIF Functions.mp442.88MB
16. 04 Grouping Functions Exercises and Solutions In the Lectures/016 Grouping Functions MIN MAX AVG COUNT etc..mp452.33MB
17. 04 Grouping Functions Exercises and Solutions In the Lectures/017 GROUP BY Clause HAVING Clause.mp451.35MB
18. 04 Grouping Functions Exercises and Solutions In the Lectures/018 More Practice With The GROUP BY Clause.mp433.6MB
19. 05 Multi-Table Queries and Joins Exercises and Solutions In the Lectures/019 SELECT within SELECT Subqueries.mp456.63MB
20. 05 Multi-Table Queries and Joins Exercises and Solutions In the Lectures/020 Relating Tables Together Using JOINs.mp449.36MB
21. 05 Multi-Table Queries and Joins Exercises and Solutions In the Lectures/021 Joins Continued INNER OUTER Joins.mp458.19MB
22. 05 Multi-Table Queries and Joins Exercises and Solutions In the Lectures/022 More Joins With Correlated Subqueries.mp452.65MB
23. 06 Creating Altering and Updating Tables Using SQL Exercises in Lectures/023 Creating Your Own Tables Design Considerations.mp450.29MB
24. 06 Creating Altering and Updating Tables Using SQL Exercises in Lectures/024 Inserting Data Into Our Table.mp447.64MB
25. 06 Creating Altering and Updating Tables Using SQL Exercises in Lectures/025 Create Table With a Primary Key Constraint.mp470.86MB
26. 06 Creating Altering and Updating Tables Using SQL Exercises in Lectures/026 Using ALTER to modify the table structure.mp441.3MB
27. 06 Creating Altering and Updating Tables Using SQL Exercises in Lectures/027 Create Table with SELECT UPDATE Data.mp452.24MB
28. 06 Creating Altering and Updating Tables Using SQL Exercises in Lectures/028 DELETE TRUNCATE and DROP Commands.mp448.79MB
29. 06 Creating Altering and Updating Tables Using SQL Exercises in Lectures/029 Working With Database Indexes Newly Added.mp434.31MB
30. 06 Creating Altering and Updating Tables Using SQL Exercises in Lectures/030 System Tables Pseudo Columns Deleting Duplicates Newly Added.mp4108.38MB
31. 06 Creating Altering and Updating Tables Using SQL Exercises in Lectures/031 Views and Other Objects and Commands Newly Added.mp461.24MB