UD87 | 0C8B4B09F155BBFFC6CC7771571A00D43070783B

UD87

Name	UD87	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	3.6 GB
Total Files	39
Hash	0C8B4B09F155BBFFC6CC7771571A00D43070783B

/01 Database Basics/
001 Oracle Database Introduction Basics of Tables.mp4	70.8 MB
002 Setting Up the SQL Development Environment (Mac Windows).mp4	16.5 MB
003 course-data.txt	2.5 KB
003 IMPORTANT Prepare the Data in the Database.mp4	15.8 MB
/02 Single Table Queries (Exercises Solutions in the Lectures)/
004 Oracle Exams and Certification Information.html	1.6 KB
005 Retrieving Data Using the SELECT Clause.mp4	26.5 MB
006 Using the WHERE Clause in a Query.mp4	98.4 MB
007 Using Operators in the WHERE Clause.mp4	128.9 MB
008 Combining WHERE AND OR with Operators.mp4	109.6 MB
009 Query Filtering Continued BETWEEN IN and NULL.mp4	115.3 MB
010 Query Filtering Conditions Operator Precedence.mp4	115.5 MB
011 Ordering Concatenating Aliasing Query Results.mp4	114.8 MB
/03 Single Row Functions (Exercises and Solutions In the Lectures)/
012 Single Row Functions (SRF) Using The Dual Table.mp4	101.2 MB
013 Using Functions in WHERE And Character Based SRFs.mp4	108.4 MB
014 Numeric and Date Data type SRFs.mp4	103.4 MB
015 Conversion SRFs and Date Formatting.mp4	99.7 MB
016 Some More Date Functions.html	1.6 KB
017 Concluding SRFs NULL NULLIF Functions.mp4	82.1 MB
/04 Grouping Functions (Exercises and Solutions In the Lectures)/
018 Grouping Functions MIN MAX AVG COUNT etc.mp4	105.8 MB
019 GROUP BY Clause HAVING Clause.mp4	104.0 MB
020 More Practice With The GROUP BY Clause.mp4	68.5 MB
/05 Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/
021 SELECT within SELECT (Subqueries).mp4	133.3 MB
022 Relating Tables Together Using JOINs.mp4	115.7 MB
023 Joins Continued INNER OUTER Joins.mp4	144.2 MB
024 Correlated Subqueries with EXISTS NOT EXIST operators.mp4	128.5 MB
/06 Creating Altering and Updating Objects Using SQL (Exercises in Lectures)/
025 Creating Your Own Tables Design Considerations.mp4	123.1 MB
026 Inserting Data Into Our Table.mp4	119.3 MB
027 Create Table With a Primary Key Constraint.mp4	153.6 MB
028 Using ALTER to modify the table structure.mp4	104.9 MB
029 Create Table with SELECT UPDATE Data.mp4	129.5 MB
030 Primary and Foreign Keys.html	2.5 KB
031 DELETE TRUNCATE and DROP Commands.mp4	119.8 MB
032 Working With Database Indexes.mp4	84.3 MB
033 System Tables Pseudo Columns Deleting Duplicates (Newly Added).mp4	166.8 MB
034 Views and Other Objects and Commands (Newly Added).mp4	145.0 MB
035 SQL could be tricky check this out.html	2.1 KB
036 Granting and Revoking Privileges.mp4	356.4 MB
037 BECOME A SQL QUERY WIZARD.html	1.6 KB
038 Bonus Lecture Lifetime Access to All My Courses.html	1.9 KB
Total files 39