| UD87/01 Database Basics/001 Oracle Database Introduction Basics of Tables.mp4 |
67.5 MB |
| UD87/01 Database Basics/002 Setting Up the SQL Development Environment (Mac Windows).mp4 |
15.7 MB |
| UD87/01 Database Basics/003 course-data.txt |
2 KB |
| UD87/01 Database Basics/003 IMPORTANT Prepare the Data in the Database.mp4 |
15.1 MB |
| UD87/02 Single Table Queries (Exercises Solutions in the Lectures)/004 Oracle Exams and Certification Information.html |
2 KB |
| UD87/02 Single Table Queries (Exercises Solutions in the Lectures)/005 Retrieving Data Using the SELECT Clause.mp4 |
25.3 MB |
| UD87/02 Single Table Queries (Exercises Solutions in the Lectures)/006 Using the WHERE Clause in a Query.mp4 |
93.9 MB |
| UD87/02 Single Table Queries (Exercises Solutions in the Lectures)/007 Using Operators in the WHERE Clause.mp4 |
122.9 MB |
| UD87/02 Single Table Queries (Exercises Solutions in the Lectures)/008 Combining WHERE AND OR with Operators.mp4 |
104.5 MB |
| UD87/02 Single Table Queries (Exercises Solutions in the Lectures)/009 Query Filtering Continued BETWEEN IN and NULL.mp4 |
109.9 MB |
| UD87/02 Single Table Queries (Exercises Solutions in the Lectures)/010 Query Filtering Conditions Operator Precedence.mp4 |
110.1 MB |
| UD87/02 Single Table Queries (Exercises Solutions in the Lectures)/011 Ordering Concatenating Aliasing Query Results.mp4 |
109.5 MB |
| UD87/03 Single Row Functions (Exercises and Solutions In the Lectures)/012 Single Row Functions (SRF) Using The Dual Table.mp4 |
96.5 MB |
| UD87/03 Single Row Functions (Exercises and Solutions In the Lectures)/013 Using Functions in WHERE And Character Based SRFs.mp4 |
103.4 MB |
| UD87/03 Single Row Functions (Exercises and Solutions In the Lectures)/014 Numeric and Date Data type SRFs.mp4 |
98.6 MB |
| UD87/03 Single Row Functions (Exercises and Solutions In the Lectures)/015 Conversion SRFs and Date Formatting.mp4 |
95.1 MB |
| UD87/03 Single Row Functions (Exercises and Solutions In the Lectures)/016 Some More Date Functions.html |
2 KB |
| UD87/03 Single Row Functions (Exercises and Solutions In the Lectures)/017 Concluding SRFs NULL NULLIF Functions.mp4 |
78.3 MB |
| UD87/04 Grouping Functions (Exercises and Solutions In the Lectures)/018 Grouping Functions MIN MAX AVG COUNT etc.mp4 |
100.9 MB |
| UD87/04 Grouping Functions (Exercises and Solutions In the Lectures)/019 GROUP BY Clause HAVING Clause.mp4 |
99.2 MB |
| UD87/04 Grouping Functions (Exercises and Solutions In the Lectures)/020 More Practice With The GROUP BY Clause.mp4 |
65.3 MB |
| UD87/05 Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/021 SELECT within SELECT (Subqueries).mp4 |
127.2 MB |
| UD87/05 Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/022 Relating Tables Together Using JOINs.mp4 |
110.3 MB |
| UD87/05 Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/023 Joins Continued INNER OUTER Joins.mp4 |
137.5 MB |
| UD87/05 Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/024 Correlated Subqueries with EXISTS NOT EXIST operators.mp4 |
122.5 MB |
| UD87/06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/025 Creating Your Own Tables Design Considerations.mp4 |
117.4 MB |
| UD87/06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/026 Inserting Data Into Our Table.mp4 |
113.8 MB |
| UD87/06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/027 Create Table With a Primary Key Constraint.mp4 |
146.5 MB |
| UD87/06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/028 Using ALTER to modify the table structure.mp4 |
100 MB |
| UD87/06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/029 Create Table with SELECT UPDATE Data.mp4 |
123.5 MB |
| UD87/06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/030 Primary and Foreign Keys.html |
2 KB |
| UD87/06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/031 DELETE TRUNCATE and DROP Commands.mp4 |
114.2 MB |
| UD87/06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/032 Working With Database Indexes.mp4 |
80.4 MB |
| UD87/06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/033 System Tables Pseudo Columns Deleting Duplicates (Newly Added).mp4 |
159.1 MB |
| UD87/06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/034 Views and Other Objects and Commands (Newly Added).mp4 |
138.3 MB |
| UD87/06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/035 SQL could be tricky check this out.html |
2 KB |
| UD87/06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/036 Granting and Revoking Privileges.mp4 |
339.9 MB |
| UD87/06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/037 BECOME A SQL QUERY WIZARD.html |
2 KB |
| UD87/06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/038 Bonus Lecture Lifetime Access to All My Courses.html |
2 KB |
Magnet link
