ファイル | サイズ |
---|
1. Database Basics/1. Oracle Database Introduction & Basics of Tables.mp4 | 35.71 MB |
1. Database Basics/1. Oracle Database Introduction & Basics of Tables.vtt | 27.28 kB |
1. Database Basics/2. Setting Up the SQL Development Environment (Mac & Windows).mp4 | 15.71 MB |
1. Database Basics/2. Setting Up the SQL Development Environment (Mac & Windows).vtt | 7.09 kB |
1. Database Basics/3. IMPORTANT Prepare the Data in the Database.mp4 | 15.11 MB |
1. Database Basics/3. IMPORTANT Prepare the Data in the Database.vtt | 5.91 kB |
1. Database Basics/3.1 course_data.txt.txt | 2.43 kB |
2. Single Table Queries (Exercises & Solutions in the Lectures)/1. Oracle Exams and Certification Information.html | 688.00 B |
2. Single Table Queries (Exercises & Solutions in the Lectures)/10. Practice Test For Single Table Queries.html | 151.00 B |
2. Single Table Queries (Exercises & Solutions in the Lectures)/2. Retrieving Data Using the SELECT Clause.mp4 | 25.28 MB |
2. Single Table Queries (Exercises & Solutions in the Lectures)/2. Retrieving Data Using the SELECT Clause.vtt | 18.44 kB |
2. Single Table Queries (Exercises & Solutions in the Lectures)/3. Using the WHERE Clause in a Query.mp4 | 42.34 MB |
2. Single Table Queries (Exercises & Solutions in the Lectures)/3. Using the WHERE Clause in a Query.vtt | 23.79 kB |
2. Single Table Queries (Exercises & Solutions in the Lectures)/4. Using Operators in the WHERE Clause.mp4 | 47.15 MB |
2. Single Table Queries (Exercises & Solutions in the Lectures)/4. Using Operators in the WHERE Clause.vtt | 25.61 kB |
2. Single Table Queries (Exercises & Solutions in the Lectures)/5. Combining WHERE, AND & OR with Operators.mp4 | 42.36 MB |
2. Single Table Queries (Exercises & Solutions in the Lectures)/5. Combining WHERE, AND & OR with Operators.vtt | 25.99 kB |
2. Single Table Queries (Exercises & Solutions in the Lectures)/6. Query Filtering Continued BETWEEN, IN and NULL.mp4 | 44.24 MB |
2. Single Table Queries (Exercises & Solutions in the Lectures)/6. Query Filtering Continued BETWEEN, IN and NULL.vtt | 24.81 kB |
2. Single Table Queries (Exercises & Solutions in the Lectures)/7. Query Filtering Conditions & Operator Precedence.mp4 | 43.53 MB |
2. Single Table Queries (Exercises & Solutions in the Lectures)/7. Query Filtering Conditions & Operator Precedence.vtt | 24.79 kB |
2. Single Table Queries (Exercises & Solutions in the Lectures)/8. Ordering, Concatenating & Aliasing Query Results.mp4 | 43.09 MB |
2. Single Table Queries (Exercises & Solutions in the Lectures)/8. Ordering, Concatenating & Aliasing Query Results.vtt | 24.43 kB |
2. Single Table Queries (Exercises & Solutions in the Lectures)/9. Practice with single table queries.html | 155.00 B |
3. Single Row Functions (Exercises and Solutions In the Lectures)/1. Single Row Functions (SRF) & Using The Dual Table.mp4 | 40.78 MB |
3. Single Row Functions (Exercises and Solutions In the Lectures)/1. Single Row Functions (SRF) & Using The Dual Table.vtt | 25.12 kB |
3. Single Row Functions (Exercises and Solutions In the Lectures)/2. Using Functions in WHERE And Character Based SRFs.mp4 | 41.70 MB |
3. Single Row Functions (Exercises and Solutions In the Lectures)/2. Using Functions in WHERE And Character Based SRFs.vtt | 24.82 kB |
3. Single Row Functions (Exercises and Solutions In the Lectures)/3. Numeric and Date Data type SRFs.mp4 | 40.49 MB |
3. Single Row Functions (Exercises and Solutions In the Lectures)/3. Numeric and Date Data type SRFs.vtt | 25.87 kB |
3. Single Row Functions (Exercises and Solutions In the Lectures)/4. Conversion SRFs & Date Formatting.mp4 | 38.14 MB |
3. Single Row Functions (Exercises and Solutions In the Lectures)/4. Conversion SRFs & Date Formatting.vtt | 25.08 kB |
3. Single Row Functions (Exercises and Solutions In the Lectures)/5. Some More Date Functions.html | 723.00 B |
3. Single Row Functions (Exercises and Solutions In the Lectures)/6. Concluding SRFs & NULL NULLIF Functions.mp4 | 33.34 MB |
3. Single Row Functions (Exercises and Solutions In the Lectures)/6. Concluding SRFs & NULL NULLIF Functions.vtt | 21.89 kB |
3. Single Row Functions (Exercises and Solutions In the Lectures)/7. Practice with Single Row Functions.html | 155.00 B |
4. Grouping Functions (Exercises and Solutions In the Lectures)/1. Grouping Functions MIN, MAX, AVG, COUNT etc..mp4 | 40.43 MB |
4. Grouping Functions (Exercises and Solutions In the Lectures)/1. Grouping Functions MIN, MAX, AVG, COUNT etc..vtt | 25.55 kB |
4. Grouping Functions (Exercises and Solutions In the Lectures)/2. GROUP BY Clause & HAVING Clause.mp4 | 40.20 MB |
4. Grouping Functions (Exercises and Solutions In the Lectures)/2. GROUP BY Clause & HAVING Clause.vtt | 26.18 kB |
4. Grouping Functions (Exercises and Solutions In the Lectures)/3. More Practice With The GROUP BY Clause.mp4 | 28.00 MB |
4. Grouping Functions (Exercises and Solutions In the Lectures)/3. More Practice With The GROUP BY Clause.vtt | 16.43 kB |
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/1. SELECT within SELECT (Subqueries).mp4 | 48.09 MB |
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/1. SELECT within SELECT (Subqueries).vtt | 31.58 kB |
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/2. Relating Tables Together Using JOINs.mp4 | 41.67 MB |
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/2. Relating Tables Together Using JOINs.vtt | 25.26 kB |
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/3. Joins Continued INNER & OUTER Joins.mp4 | 48.01 MB |
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/3. Joins Continued INNER & OUTER Joins.vtt | 28.33 kB |
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/4. Correlated Subqueries with EXISTS & NOT EXIST operators.mp4 | 44.21 MB |
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/4. Correlated Subqueries with EXISTS & NOT EXIST operators.vtt | 27.42 kB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/1. Creating Your Own Tables & Design Considerations.mp4 | 42.44 MB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/1. Creating Your Own Tables & Design Considerations.vtt | 28.35 kB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/10. Views and Other Objects and Commands (Newly Added).mp4 | 51.59 MB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/10. Views and Other Objects and Commands (Newly Added).vtt | 30.83 kB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/11. SQL could be tricky, check this out!.html | 1.20 kB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/12. Granting and Revoking Privileges.mp4 | 339.86 MB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/12. Granting and Revoking Privileges.vtt | 18.30 kB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/13. BECOME A SQL QUERY WIZARD!.html | 704.00 B |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/14. Bonus Lecture Lifetime Access to All My Courses.html | 663.00 B |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/2. Inserting Data Into Our Table.mp4 | 40.17 MB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/2. Inserting Data Into Our Table.vtt | 25.31 kB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/3. Create Table With a Primary Key Constraint.mp4 | 47.40 MB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/3. Create Table With a Primary Key Constraint.vtt | 30.03 kB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/4. Using ALTER to modify the table structure.mp4 | 34.77 MB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/4. Using ALTER to modify the table structure.vtt | 20.89 kB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/5. Create Table with SELECT + UPDATE Data.mp4 | 43.99 MB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/5. Create Table with SELECT + UPDATE Data.vtt | 24.67 kB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/6. Primary and Foreign Keys.html | 1.57 kB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7. DELETE, TRUNCATE, and DROP Commands.mp4 | 40.83 MB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7. DELETE, TRUNCATE, and DROP Commands.vtt | 23.32 kB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/8. Working With Database Indexes.mp4 | 29.12 MB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/8. Working With Database Indexes.vtt | 18.64 kB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/9. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).mp4 | 63.39 MB |
6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/9. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).vtt | 31.00 kB |
[FreeCourseLab.com].url | 126.00 B |