01 Database Basics/001 Oracle Database Introduction Basics of Tables.mp4 67.54 MB
01 Database Basics/002 Setting Up the SQL Development Environment (Mac Windows).mp4 15.7 MB
01 Database Basics/003 course-data.txt 2.43 KB
01 Database Basics/003 IMPORTANT Prepare the Data in the Database.mp4 15.1 MB
02 Single Table Queries (Exercises Solutions in the Lectures)/004 Oracle Exams and Certification Information.html 1.53 KB
02 Single Table Queries (Exercises Solutions in the Lectures)/005 Retrieving Data Using the SELECT Clause.mp4 25.28 MB
02 Single Table Queries (Exercises Solutions in the Lectures)/006 Using the WHERE Clause in a Query.mp4 93.85 MB
02 Single Table Queries (Exercises Solutions in the Lectures)/007 Using Operators in the WHERE Clause.mp4 122.9 MB
02 Single Table Queries (Exercises Solutions in the Lectures)/008 Combining WHERE AND OR with Operators.mp4 104.51 MB
02 Single Table Queries (Exercises Solutions in the Lectures)/009 Query Filtering Continued BETWEEN IN and NULL.mp4 109.93 MB
02 Single Table Queries (Exercises Solutions in the Lectures)/010 Query Filtering Conditions Operator Precedence.mp4 110.1 MB
02 Single Table Queries (Exercises Solutions in the Lectures)/011 Ordering Concatenating Aliasing Query Results.mp4 109.52 MB
03 Single Row Functions (Exercises and Solutions In the Lectures)/012 Single Row Functions (SRF) Using The Dual Table.mp4 96.52 MB
03 Single Row Functions (Exercises and Solutions In the Lectures)/013 Using Functions in WHERE And Character Based SRFs.mp4 103.36 MB
03 Single Row Functions (Exercises and Solutions In the Lectures)/014 Numeric and Date Data type SRFs.mp4 98.63 MB
03 Single Row Functions (Exercises and Solutions In the Lectures)/015 Conversion SRFs and Date Formatting.mp4 95.13 MB
03 Single Row Functions (Exercises and Solutions In the Lectures)/016 Some More Date Functions.html 1.55 KB
03 Single Row Functions (Exercises and Solutions In the Lectures)/017 Concluding SRFs NULL NULLIF Functions.mp4 78.27 MB
04 Grouping Functions (Exercises and Solutions In the Lectures)/018 Grouping Functions MIN MAX AVG COUNT etc.mp4 100.87 MB
04 Grouping Functions (Exercises and Solutions In the Lectures)/019 GROUP BY Clause HAVING Clause.mp4 99.16 MB
04 Grouping Functions (Exercises and Solutions In the Lectures)/020 More Practice With The GROUP BY Clause.mp4 65.32 MB
05 Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/021 SELECT within SELECT (Subqueries).mp4 127.16 MB
05 Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/022 Relating Tables Together Using JOINs.mp4 110.31 MB
05 Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/023 Joins Continued INNER OUTER Joins.mp4 137.48 MB
05 Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/024 Correlated Subqueries with EXISTS NOT EXIST operators.mp4 122.55 MB
06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/025 Creating Your Own Tables Design Considerations.mp4 117.44 MB
06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/026 Inserting Data Into Our Table.mp4 113.77 MB
06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/027 Create Table With a Primary Key Constraint.mp4 146.48 MB
06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/028 Using ALTER to modify the table structure.mp4 100 MB
06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/029 Create Table with SELECT UPDATE Data.mp4 123.52 MB
06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/030 Primary and Foreign Keys.html 2.41 KB
06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/031 DELETE TRUNCATE and DROP Commands.mp4 114.23 MB
06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/032 Working With Database Indexes.mp4 80.44 MB
06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/033 System Tables Pseudo Columns Deleting Duplicates (Newly Added).mp4 159.06 MB
06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/034 Views and Other Objects and Commands (Newly Added).mp4 138.28 MB
06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/035 SQL could be tricky check this out.html 2.05 KB
06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/036 Granting and Revoking Privileges.mp4 339.86 MB
06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/037 BECOME A SQL QUERY WIZARD.html 1.53 KB
06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/038 Bonus Lecture Lifetime Access to All My Courses.html 1.84 KB
Download Info
Tips
“UD87” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.
DMCA Notice and Takedown Procedure
If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.