5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/8. CASE Statements.srt 12.1 kB
1. Database Basics/2. Creating the Workspace in Oracle.srt 10.5 kB
6. Analytical Functions using OVER and PARTITION with ORDER BY/4. Slicing Windows and Filtering with Analytic Functions.srt 10.4 kB
1. Database Basics/3. IMPORTANT Prepare the Sample Data.srt 6.0 kB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7.2 merge_sql_example.txt 2.9 kB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/3.1 Code for Create Table With Primary Key Constraint.txt 2.0 kB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/13.1 Code for Other Objects and Commands VIEWs UNIONALL etc.txt 1.6 kB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/8. Primary and Foreign Keys.html 1.6 kB
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/1.1 Code for SELECT within SELECT (Nested Queries Subqueries).txt 1.3 kB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/14. SQL could be tricky, check this out!.html 1.2 kB
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/3.1 Code for JOINS Continued INNER & OUTER Joins.txt 1.2 kB
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/2.1 Code for Relating Tables together using JOINs .txt 1.2 kB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/12.1 Code for System Tables, Pseudo Columns, & Deleting Duplicate Data.txt 1.2 kB
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/4.1 Code for More JOINS with Correlated Subqueries .txt 1.1 kB
3. Single Row Functions (Exercises and Solutions In the Lectures)/3.1 Code for Numeric and Date Datatype SRFs.txt 1.1 kB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7.1 Code for MERGE Statement.txt 1.1 kB
8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/7.1 code for external tables.txt 1.0 kB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/4.1 Code for Multi-Table Insert Using INSERT ALL.txt 1.0 kB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/17. Bonus Lecture Lifetime Access to All My Courses.html 995 Bytes
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/2.1 Code for Inserting Data Into our Table.txt 984 Bytes
4. Grouping Functions (Exercises and Solutions In the Lectures)/1.1 Code for Grouping Functions MIN, MAX, AVG, COUNT etc.txt 865 Bytes
8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/5.1 code for cascade constraints.txt 798 Bytes
3. Single Row Functions (Exercises and Solutions In the Lectures)/6.1 Code for Concluding SRFs & NULLNULLIF Functions.txt 778 Bytes
1. Database Basics/3.1 course_data.txt 764 Bytes
3. Single Row Functions (Exercises and Solutions In the Lectures)/5. Some More Date Functions.html 723 Bytes
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/6.1 Code for Create Table with SELECT and UPDATE existing Data.txt 706 Bytes
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/16. BECOME A SQL QUERY WIZARD!.html 704 Bytes
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/5.1 Code for Alter Table and Modify Column Attributes.txt 690 Bytes
2. Single Table Queries (Exercises & Solutions in the Lectures)/1. Oracle Exams and Certification Information.html 688 Bytes
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/11.1 Code for Database Indexes.txt 601 Bytes
3. Single Row Functions (Exercises and Solutions In the Lectures)/4.1 Code for Conversion SRFs & Date Formatting.txt 528 Bytes
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/7.1 Code for EQUI and NON-EQUI Joins.txt 421 Bytes
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/10.1 Code for Delete, Truncate and Drop Commands.txt 397 Bytes
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/8.1 Code for CASE Statement.txt 379 Bytes
2. Single Table Queries (Exercises & Solutions in the Lectures)/8.1 Code for Ordering, Concatenating & Aliasing Query Results.txt 331 Bytes
2. Single Table Queries (Exercises & Solutions in the Lectures)/7.1 Code for Query Filtering Conditions & Operator Precedence.txt 326 Bytes
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/9.1 Code for Sequence Statements.txt 315 Bytes
3. Single Row Functions (Exercises and Solutions In the Lectures)/1.1 Code for Single Row Functions (SRF) & Using the Dual Table.txt 295 Bytes
2. Single Table Queries (Exercises & Solutions in the Lectures)/6.1 Code for Query Filtering Continued BETWEEN, IN & NULL.txt 281 Bytes
3. Single Row Functions (Exercises and Solutions In the Lectures)/2.1 Code for Using Functions in WHERE and Character Based SRFs.txt 281 Bytes
2. Single Table Queries (Exercises & Solutions in the Lectures)/4.1 Code for Using Operators in the WHERE Clause.txt 277 Bytes
4. Grouping Functions (Exercises and Solutions In the Lectures)/2.1 Code for GROUP BY Clause & HAVING CLAUSE.txt 200 Bytes
2. Single Table Queries (Exercises & Solutions in the Lectures)/5.1 Code for Combining WHERE, AND & OR Operators.txt 199 Bytes
2. Single Table Queries (Exercises & Solutions in the Lectures)/9. Practice with single table queries.html 159 Bytes
3. Single Row Functions (Exercises and Solutions In the Lectures)/7. Practice with Single Row Functions.html 159 Bytes
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/1.1 Code for Creating Your Own Tables & Design Considerations.txt 158 Bytes
9. Exam Question Walkthrough Videos + 2 Exams/4. Practice Test 1.html 155 Bytes
9. Exam Question Walkthrough Videos + 2 Exams/5. Practice Test 2.html 155 Bytes
2. Single Table Queries (Exercises & Solutions in the Lectures)/2.1 Code for Select Clause.txt 132 Bytes
2. Single Table Queries (Exercises & Solutions in the Lectures)/3.1 Code for WHERE Clause.txt 130 Bytes
4. Grouping Functions (Exercises and Solutions In the Lectures)/3.1 Code for More Practice with the GROUP BY Clause.txt 98 Bytes