Udemy The Complete Oracle SQL Certification Course 2020 AhLaN

/7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/

15. Granting and Revoking Privileges.mp4

1. Creating Your Own Tables & Design Considerations.mp4

1.1 Code for Creating Your Own Tables & Design Considerations.txt

2. Inserting Data Into Our Table.mp4

2.1 Code for Inserting Data Into our Table.txt

3. Create Table With a Primary Key Constraint.mp4

3.1 Code for Create Table With Primary Key Constraint.txt

4. INSERT ALL for Multi-table & Conditional Inserts.mp4

4.1 Code for Multi-Table Insert Using INSERT ALL.txt

5. Using ALTER to modify the table structure.mp4

5.1 Code for Alter Table and Modify Column Attributes.txt

6. Create Table with SELECT + UPDATE Data.mp4

6.1 Code for Create Table with SELECT and UPDATE existing Data.txt

7. MERGE Statement in Oracle.mp4

7.1 Code for MERGE Statement.txt

7.2 merge_sql_example.txt

8. Primary and Foreign Keys.html

9. Sequence Statements.mp4

9.1 Code for Sequence Statements.txt

10. DELETE, TRUNCATE, and DROP Commands.mp4

10.1 Code for Delete, Truncate and Drop Commands.txt

11. Working With Database Indexes.mp4

11.1 Code for Database Indexes.txt

12. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).mp4

12.1 Code for System Tables, Pseudo Columns, & Deleting Duplicate Data.txt

13. Views and Other Objects and Commands (Newly Added).mp4

13.1 Code for Other Objects and Commands VIEWs UNIONALL etc.txt

14. SQL could be tricky, check this out!.html

16. BECOME A SQL QUERY WIZARD!.html

17. Bonus Lecture Lifetime Access to All My Courses.html

/

Downloaded from Ahlanedu.com.txt

Visit us at www.Ahlanedu.com.url

Download - Lynda,Udemy,Skillshare,Teamtreehouse,Frontend Masters,Pluralsight,Phlearn,Coursera,Egghead,MasterClass.txt

/1. Database Basics/

1. Oracle Database Introduction & Basics of Tables.mp4

2. Creating the Workspace in Oracle.mp4

3. IMPORTANT Prepare the Sample Data.mp4

3.1 course_data.txt

/2. Single Table Queries (Exercises & Solutions in the Lectures)/

1. Oracle Exams and Certification Information.html

2. Retrieving Data Using the SELECT Clause.mp4

2.1 Code for Select Clause.txt

3. Using the WHERE Clause in a Query.mp4

3.1 Code for WHERE Clause.txt

4. Using Operators in the WHERE Clause.mp4

4.1 Code for Using Operators in the WHERE Clause.txt

5. Combining WHERE, AND & OR with Operators.mp4

5.1 Code for Combining WHERE, AND & OR Operators.txt

6. Query Filtering Continued BETWEEN, IN and NULL.mp4

6.1 Code for Query Filtering Continued BETWEEN, IN & NULL.txt

7. Query Filtering Conditions & Operator Precedence.mp4

7.1 Code for Query Filtering Conditions & Operator Precedence.txt

8. Ordering, Concatenating & Aliasing Query Results.mp4

8.1 Code for Ordering, Concatenating & Aliasing Query Results.txt

9. Practice with single table queries.html

/3. Single Row Functions (Exercises and Solutions In the Lectures)/

1. Single Row Functions (SRF) & Using The Dual Table.mp4

1.1 Code for Single Row Functions (SRF) & Using the Dual Table.txt

2. Using Functions in WHERE And Character Based SRFs.mp4

2.1 Code for Using Functions in WHERE and Character Based SRFs.txt

3. Numeric and Date Data type SRFs.mp4

3.1 Code for Numeric and Date Datatype SRFs.txt

4. Conversion SRFs and Date Formatting.mp4

4.1 Code for Conversion SRFs & Date Formatting.txt

5. Some More Date Functions.html

6. Concluding SRFs & NULL NULLIF Functions.mp4

6.1 Code for Concluding SRFs & NULLNULLIF Functions.txt

7. Practice with Single Row Functions.html

/4. Grouping Functions (Exercises and Solutions In the Lectures)/

1. Grouping Functions MIN, MAX, AVG, COUNT etc..mp4

1.1 Code for Grouping Functions MIN, MAX, AVG, COUNT etc.txt

2. GROUP BY Clause & HAVING Clause.mp4

2.1 Code for GROUP BY Clause & HAVING CLAUSE.txt

3. More Practice With The GROUP BY Clause.mp4

3.1 Code for More Practice with the GROUP BY Clause.txt

/5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/

1. SELECT within SELECT (Subqueries).mp4

1.1 Code for SELECT within SELECT (Nested Queries Subqueries).txt

2. Relating Tables Together Using JOINs.mp4

2.1 Code for Relating Tables together using JOINs .txt

3. Joins Continued INNER & OUTER Joins.mp4

3.1 Code for JOINS Continued INNER & OUTER Joins.txt

4. Correlated Subqueries with EXISTS & NOT EXIST operators.mp4

4.1 Code for More JOINS with Correlated Subqueries .txt

5. SELF JOIN.mp4

6. CROSS JOIN, NATURAL JOIN and the USING CLAUSE.mp4

7. EQUIJOIN and NON-EQUIJOINs.mp4

7.1 Code for EQUI and NON-EQUI Joins.txt

8. CASE Statements.mp4

8.1 Code for CASE Statement.txt

/6. Analytical Functions using OVER and PARTITION with ORDER BY/

1. OVER Clause with PARTITION BY.mp4

2. Compute Running Totals with Ordering and Partitioning.mp4

3. Unbounded Preceding Order in Over Clause.mp4

4. Slicing Windows and Filtering with Analytic Functions.mp4

5. Rank, Dense_rank, Lead, and Lag Functions.mp4

/8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/

1. OFFSET and FETCH.mp4

2. ERD Diagrams.mp4

3. Commit, Rollback, and Savepoint.mp4

4. Large Objects and Interval Data Types.mp4

5. Using Cascade Constraints and On Delete Cascade.mp4

5.1 code for cascade constraints.txt

6. UNUSED Columns.mp4

7. External Tables.mp4

7.1 code for external tables.txt

8. SQL Plus and Substitution Variables.mp4

/9. Exam Question Walkthrough Videos + 2 Exams/

1. QA 1- DML, DDL, and Transaction Control.mp4

2. QA 2- Fetch and Substitution Variables.mp4

3. QA 3- Conversion Functions, T0_CHAR, TO_DATE, and NVL.mp4

4. Practice Test 1.html

5. Practice Test 2.html

/10. APPENDIX - Installing Oracle on Windows/

1. Install Oracle Database 19c in Windows.mp4

2. Install Oracle SQL Developer in Windows.mp4

Total files 107