|
|
1. Creating Your Own Tables & Design Considerations.mp4
|
MP4
|
117.5 MB
|
|
|
1. Grouping Functions MIN, MAX, AVG, COUNT etc..mp4
|
MP4
|
100.9 MB
|
|
|
1. Install Oracle Database 19c in Windows.mp4
|
MP4
|
78.5 MB
|
|
|
1. OFFSET and FETCH.mp4
|
MP4
|
65.9 MB
|
|
|
1. OVER Clause with PARTITION BY.mp4
|
MP4
|
118.1 MB
|
|
|
1. Oracle Database Introduction & Basics of Tables.mp4
|
MP4
|
67.5 MB
|
|
|
1. Oracle Exams and Certification Information.html
|
HTML
|
716 B
|
|
|
1. QA 1- DML, DDL, and Transaction Control.mp4
|
MP4
|
167.9 MB
|
|
|
1. SELECT within SELECT (Subqueries).mp4
|
MP4
|
127.2 MB
|
|
|
1. Single Row Functions (SRF) & Using The Dual Table.mp4
|
MP4
|
96.5 MB
|
|
|
1.1 Code for Creating Your Own Tables & Design Considerations.txt
|
TXT
|
204 B
|
|
|
1.1 Code for Grouping Functions MIN, MAX, AVG, COUNT etc.txt
|
TXT
|
819 B
|
|
|
1.1 Code for SELECT within SELECT (Nested Queries Subqueries).txt
|
TXT
|
1.2 KB
|
|
|
1.1 Code for Single Row Functions (SRF) & Using the Dual Table.txt
|
TXT
|
307 B
|
|
|
10. DELETE, TRUNCATE, and DROP Commands.mp4
|
MP4
|
114.2 MB
|
|
|
10.1 Code for Delete, Truncate and Drop Commands.txt
|
TXT
|
409 B
|
|
|
11. Working With Database Indexes.mp4
|
MP4
|
80.4 MB
|
|
|
11.1 Code for Database Indexes.txt
|
TXT
|
614 B
|
|
|
12. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).mp4
|
MP4
|
159.1 MB
|
|
|
12.1 Code for System Tables, Pseudo Columns, & Deleting Duplicate Data.txt
|
TXT
|
1.2 KB
|
|
|
13. Views and Other Objects and Commands (Newly Added).mp4
|
MP4
|
138.3 MB
|
|
|
13.1 Code for Other Objects and Commands VIEWs UNIONALL etc.txt
|
TXT
|
1.6 KB
|
|
|
14. SQL could be tricky, check this out!.html
|
HTML
|
1.2 KB
|
|
|
15. Granting and Revoking Privileges.mp4
|
MP4
|
339.9 MB
|
|
|
16. BECOME A SQL QUERY WIZARD!.html
|
HTML
|
716 B
|
|
|
17. Bonus Lecture Lifetime Access to All My Courses.html
|
HTML
|
1 KB
|
|
|
2. Compute Running Totals with Ordering and Partitioning.mp4
|
MP4
|
128.3 MB
|
|
|
2. Creating the Workspace in Oracle.mp4
|
MP4
|
50.4 MB
|
|
|
2. ERD Diagrams.mp4
|
MP4
|
61.9 MB
|
|
|
2. GROUP BY Clause & HAVING Clause.mp4
|
MP4
|
99.2 MB
|
|
|
2. Inserting Data Into Our Table.mp4
|
MP4
|
113.8 MB
|
|
|
2. Install Oracle SQL Developer in Windows.mp4
|
MP4
|
95.1 MB
|
|
|
2. QA 2- Fetch and Substitution Variables.mp4
|
MP4
|
177 MB
|
|
|
2. Relating Tables Together Using JOINs.mp4
|
MP4
|
110.3 MB
|
|
|
2. Retrieving Data Using the SELECT Clause.mp4
|
MP4
|
25.3 MB
|
|
|
2. Using Functions in WHERE And Character Based SRFs.mp4
|
MP4
|
103.4 MB
|
|
|
2.1 Code for GROUP BY Clause & HAVING CLAUSE.txt
|
TXT
|
204 B
|
|
|
2.1 Code for Inserting Data Into our Table.txt
|
TXT
|
1 KB
|
|
|
2.1 Code for Relating Tables together using JOINs .txt
|
TXT
|
1.2 KB
|
|
|
2.1 Code for Select Clause.txt
|
TXT
|
102 B
|
|
|
2.1 Code for Using Functions in WHERE and Character Based SRFs.txt
|
TXT
|
307 B
|
|
|
3. Commit, Rollback, and Savepoint.mp4
|
MP4
|
54.4 MB
|
|
|
3. Create Table With a Primary Key Constraint.mp4
|
MP4
|
146.5 MB
|
|
|
3. IMPORTANT Prepare the Sample Data.mp4
|
MP4
|
24.3 MB
|
|
|
3. Joins Continued INNER & OUTER Joins.mp4
|
MP4
|
137.5 MB
|
|
|
3. More Practice With The GROUP BY Clause.mp4
|
MP4
|
65.3 MB
|
|
|
3. Numeric and Date Data type SRFs.mp4
|
MP4
|
98.6 MB
|
|
|
3. QA 3- Conversion Functions, T0_CHAR, TO_DATE, and NVL.mp4
|
MP4
|
213.9 MB
|
|
|
3. Unbounded Preceding Order in Over Clause.mp4
|
MP4
|
61.1 MB
|
|
|
3. Using the WHERE Clause in a Query.mp4
|
MP4
|
93.9 MB
|
|
|
3.1 Code for Create Table With Primary Key Constraint.txt
|
TXT
|
1.9 KB
|
|
|
3.1 Code for JOINS Continued INNER & OUTER Joins.txt
|
TXT
|
1.2 KB
|
|
|
3.1 Code for More Practice with the GROUP BY Clause.txt
|
TXT
|
102 B
|
|
|
3.1 Code for Numeric and Date Datatype SRFs.txt
|
TXT
|
1.1 KB
|
|
|
3.1 Code for WHERE Clause.txt
|
TXT
|
102 B
|
|
|
3.1 course_data.txt
|
TXT
|
716 B
|
|
|
4. Conversion SRFs and Date Formatting.mp4
|
MP4
|
95.1 MB
|
|
|
4. Correlated Subqueries with EXISTS & NOT EXIST operators.mp4
|
MP4
|
122.6 MB
|
|
|
4. INSERT ALL for Multi-table & Conditional Inserts.mp4
|
MP4
|
77.1 MB
|
|
|
4. Large Objects and Interval Data Types.mp4
|
MP4
|
131.3 MB
|
|
|
4. Practice Test 1.html
|
HTML
|
204 B
|
|
|
4. Slicing Windows and Filtering with Analytic Functions.mp4
|
MP4
|
44.8 MB
|
|
|
4. Using Operators in the WHERE Clause.mp4
|
MP4
|
122.9 MB
|
|
|
4.1 Code for Conversion SRFs & Date Formatting.txt
|
TXT
|
512 B
|
|
|
4.1 Code for More JOINS with Correlated Subqueries .txt
|
TXT
|
1.1 KB
|
|
|
4.1 Code for Multi-Table Insert Using INSERT ALL.txt
|
TXT
|
1 KB
|
|
|
4.1 Code for Using Operators in the WHERE Clause.txt
|
TXT
|
307 B
|
|
|
5. Combining WHERE, AND & OR with Operators.mp4
|
MP4
|
104.5 MB
|
|
|
5. Practice Test 2.html
|
HTML
|
204 B
|
|
|
5. Rank, Dense_rank, Lead, and Lag Functions.mp4
|
MP4
|
107.9 MB
|
|
|
5. SELF JOIN.mp4
|
MP4
|
59 MB
|
|
|
5. Some More Date Functions.html
|
HTML
|
716 B
|
|
|
5. Using ALTER to modify the table structure.mp4
|
MP4
|
100 MB
|
|
|
5. Using Cascade Constraints and On Delete Cascade.mp4
|
MP4
|
114.7 MB
|
|
|
5.1 Code for Alter Table and Modify Column Attributes.txt
|
TXT
|
716 B
|
|
|
5.1 Code for Combining WHERE, AND & OR Operators.txt
|
TXT
|
204 B
|
|
|
5.1 code for cascade constraints.txt
|
TXT
|
819 B
|
|
|
6. CROSS JOIN, NATURAL JOIN and the USING CLAUSE.mp4
|
MP4
|
53.1 MB
|
|
|
6. Concluding SRFs & NULL NULLIF Functions.mp4
|
MP4
|
78.3 MB
|
|
|
6. Create Table with SELECT + UPDATE Data.mp4
|
MP4
|
123.5 MB
|
|
|
6. Query Filtering Continued BETWEEN, IN and NULL.mp4
|
MP4
|
109.9 MB
|
|
|
6. UNUSED Columns.mp4
|
MP4
|
38.7 MB
|
|
|
6.1 Code for Concluding SRFs & NULLNULLIF Functions.txt
|
TXT
|
819 B
|
|
|
6.1 Code for Create Table with SELECT and UPDATE existing Data.txt
|
TXT
|
716 B
|
|
|
6.1 Code for Query Filtering Continued BETWEEN, IN & NULL.txt
|
TXT
|
307 B
|
|
|
7. EQUIJOIN and NON-EQUIJOINs.mp4
|
MP4
|
45.9 MB
|
|
|
7. External Tables.mp4
|
MP4
|
107.6 MB
|
|
|
7. MERGE Statement in Oracle.mp4
|
MP4
|
117.4 MB
|
|
|
7. Practice with Single Row Functions.html
|
HTML
|
204 B
|
|
|
7. Query Filtering Conditions & Operator Precedence.mp4
|
MP4
|
110.1 MB
|
|
|
7.1 Code for EQUI and NON-EQUI Joins.txt
|
TXT
|
409 B
|
|
|
7.1 Code for MERGE Statement.txt
|
TXT
|
1.1 KB
|
|
|
7.1 Code for Query Filtering Conditions & Operator Precedence.txt
|
TXT
|
307 B
|
|
|
7.1 code for external tables.txt
|
TXT
|
1 KB
|
|
|
7.2 merge_sql_example.txt
|
TXT
|
2.9 KB
|
|
|
8. CASE Statements.mp4
|
MP4
|
61.6 MB
|
|
|
8. Ordering, Concatenating & Aliasing Query Results.mp4
|
MP4
|
109.5 MB
|
|
|
8. Primary and Foreign Keys.html
|
HTML
|
1.6 KB
|
|
|
8. SQL Plus and Substitution Variables.mp4
|
MP4
|
225.5 MB
|
|
|
8.1 Code for CASE Statement.txt
|
TXT
|
409 B
|
|
|
8.1 Code for Ordering, Concatenating & Aliasing Query Results.txt
|
TXT
|
307 B
|
|
|
9. Practice with single table queries.html
|
HTML
|
204 B
|
|
|
9. Sequence Statements.mp4
|
MP4
|
64.6 MB
|
|
|
9.1 Code for Sequence Statements.txt
|
TXT
|
307 B
|
|
|
Download - Lynda,Udemy,Skillshare,Teamtreehouse,Frontend Masters,Pluralsight,Phlearn,Coursera,Egghead,MasterClass.txt
|
TXT
|
204 B
|
|
|
Downloaded from Ahlanedu.com.txt
|
TXT
|
1 KB
|
|
|
Visit us at www.Ahlanedu.com.url
|
URL
|
0 B
|
![Udemy - The Complete Oracle SQL Certification Course 2020-6 [AhLaN]](/upload_files/torrents-posters/356/356d50844dcb83e838158d15dd1b7758.gif "Udemy - The Complete Oracle SQL Certification Course 2020-6 [AhLaN]")
