Udemy - The Complete Oracle SQL Certification Course 2020-6 [AhLaN]

File Name

Size

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/15. Granting and Revoking Privileges.mp4

340 MB

Downloaded from Ahlanedu.com.txt

996 B

Visit us at www.Ahlanedu.com.url

51 B

1. Database Basics/1. Oracle Database Introduction & Basics of Tables.mp4

68 MB

1. Database Basics/2. Creating the Workspace in Oracle.mp4

50 MB

1. Database Basics/3. IMPORTANT Prepare the Sample Data.mp4

24 MB

1. Database Basics/3.1 course_data.txt

764 B

2. Single Table Queries (Exercises & Solutions in the Lectures)/1. Oracle Exams and Certification Information.html

688 B

2. Single Table Queries (Exercises & Solutions in the Lectures)/2. Retrieving Data Using the SELECT Clause.mp4

25 MB

2. Single Table Queries (Exercises & Solutions in the Lectures)/2.1 Code for Select Clause.txt

132 B

2. Single Table Queries (Exercises & Solutions in the Lectures)/3. Using the WHERE Clause in a Query.mp4

94 MB

2. Single Table Queries (Exercises & Solutions in the Lectures)/3.1 Code for WHERE Clause.txt

130 B

2. Single Table Queries (Exercises & Solutions in the Lectures)/4. Using Operators in the WHERE Clause.mp4

123 MB

2. Single Table Queries (Exercises & Solutions in the Lectures)/4.1 Code for Using Operators in the WHERE Clause.txt

277 B

2. Single Table Queries (Exercises & Solutions in the Lectures)/5. Combining WHERE, AND & OR with Operators.mp4

104 MB

2. Single Table Queries (Exercises & Solutions in the Lectures)/5.1 Code for Combining WHERE, AND & OR Operators.txt

199 B

2. Single Table Queries (Exercises & Solutions in the Lectures)/6. Query Filtering Continued BETWEEN, IN and NULL.mp4

110 MB

2. Single Table Queries (Exercises & Solutions in the Lectures)/6.1 Code for Query Filtering Continued BETWEEN, IN & NULL.txt

281 B

2. Single Table Queries (Exercises & Solutions in the Lectures)/7. Query Filtering Conditions & Operator Precedence.mp4

110 MB

2. Single Table Queries (Exercises & Solutions in the Lectures)/7.1 Code for Query Filtering Conditions & Operator Precedence.txt

326 B

2. Single Table Queries (Exercises & Solutions in the Lectures)/8. Ordering, Concatenating & Aliasing Query Results.mp4

110 MB

2. Single Table Queries (Exercises & Solutions in the Lectures)/8.1 Code for Ordering, Concatenating & Aliasing Query Results.txt

331 B

2. Single Table Queries (Exercises & Solutions in the Lectures)/9. Practice with single table queries.html

159 B

3. Single Row Functions (Exercises and Solutions In the Lectures)/1. Single Row Functions (SRF) & Using The Dual Table.mp4

96 MB

3. Single Row Functions (Exercises and Solutions In the Lectures)/1.1 Code for Single Row Functions (SRF) & Using the Dual Table.txt

295 B

3. Single Row Functions (Exercises and Solutions In the Lectures)/2. Using Functions in WHERE And Character Based SRFs.mp4

103 MB

3. Single Row Functions (Exercises and Solutions In the Lectures)/2.1 Code for Using Functions in WHERE and Character Based SRFs.txt

281 B

3. Single Row Functions (Exercises and Solutions In the Lectures)/3. Numeric and Date Data type SRFs.mp4

99 MB

3. Single Row Functions (Exercises and Solutions In the Lectures)/3.1 Code for Numeric and Date Datatype SRFs.txt

1.1 kB

3. Single Row Functions (Exercises and Solutions In the Lectures)/4. Conversion SRFs and Date Formatting.mp4

95 MB

3. Single Row Functions (Exercises and Solutions In the Lectures)/4.1 Code for Conversion SRFs & Date Formatting.txt

528 B

3. Single Row Functions (Exercises and Solutions In the Lectures)/5. Some More Date Functions.html

723 B

3. Single Row Functions (Exercises and Solutions In the Lectures)/6. Concluding SRFs & NULL NULLIF Functions.mp4

78 MB

3. Single Row Functions (Exercises and Solutions In the Lectures)/6.1 Code for Concluding SRFs & NULLNULLIF Functions.txt

778 B

3. Single Row Functions (Exercises and Solutions In the Lectures)/7. Practice with Single Row Functions.html

159 B

4. Grouping Functions (Exercises and Solutions In the Lectures)/1. Grouping Functions MIN, MAX, AVG, COUNT etc..mp4

101 MB

4. Grouping Functions (Exercises and Solutions In the Lectures)/1.1 Code for Grouping Functions MIN, MAX, AVG, COUNT etc.txt

865 B

4. Grouping Functions (Exercises and Solutions In the Lectures)/2. GROUP BY Clause & HAVING Clause.mp4

99 MB

4. Grouping Functions (Exercises and Solutions In the Lectures)/2.1 Code for GROUP BY Clause & HAVING CLAUSE.txt

200 B

4. Grouping Functions (Exercises and Solutions In the Lectures)/3. More Practice With The GROUP BY Clause.mp4

65 MB

4. Grouping Functions (Exercises and Solutions In the Lectures)/3.1 Code for More Practice with the GROUP BY Clause.txt

98 B

5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/1. SELECT within SELECT (Subqueries).mp4

127 MB

5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/1.1 Code for SELECT within SELECT (Nested Queries Subqueries).txt

1.2 kB

5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/2. Relating Tables Together Using JOINs.mp4

110 MB

5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/2.1 Code for Relating Tables together using JOINs .txt

1.2 kB

5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/3. Joins Continued INNER & OUTER Joins.mp4

138 MB

5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/3.1 Code for JOINS Continued INNER & OUTER Joins.txt

1.2 kB

5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/4. Correlated Subqueries with EXISTS & NOT EXIST operators.mp4

123 MB

5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/4.1 Code for More JOINS with Correlated Subqueries .txt

1.1 kB

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

59 MB

5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/6. CROSS JOIN, NATURAL JOIN and the USING CLAUSE.mp4

53 MB

5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/7. EQUIJOIN and NON-EQUIJOINs.mp4

46 MB

5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/7.1 Code for EQUI and NON-EQUI Joins.txt

421 B

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

62 MB

5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/8.1 Code for CASE Statement.txt

379 B

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

118 MB

6. Analytical Functions using OVER and PARTITION with ORDER BY/2. Compute Running Totals with Ordering and Partitioning.mp4

128 MB

6. Analytical Functions using OVER and PARTITION with ORDER BY/3. Unbounded Preceding Order in Over Clause.mp4

61 MB

6. Analytical Functions using OVER and PARTITION with ORDER BY/4. Slicing Windows and Filtering with Analytic Functions.mp4

45 MB

6. Analytical Functions using OVER and PARTITION with ORDER BY/5. Rank, Dense_rank, Lead, and Lag Functions.mp4

108 MB

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/1. Creating Your Own Tables & Design Considerations.mp4

118 MB

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/1.1 Code for Creating Your Own Tables & Design Considerations.txt

158 B

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/2. Inserting Data Into Our Table.mp4

114 MB

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/2.1 Code for Inserting Data Into our Table.txt

984 B

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/3. Create Table With a Primary Key Constraint.mp4

146 MB

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/3.1 Code for Create Table With Primary Key Constraint.txt

1.9 kB

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/4. INSERT ALL for Multi-table & Conditional Inserts.mp4

77 MB

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/4.1 Code for Multi-Table Insert Using INSERT ALL.txt

1.0 kB

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/5. Using ALTER to modify the table structure.mp4

100 MB

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/5.1 Code for Alter Table and Modify Column Attributes.txt

690 B

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/6. Create Table with SELECT + UPDATE Data.mp4

124 MB

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/6.1 Code for Create Table with SELECT and UPDATE existing Data.txt

706 B

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

117 MB

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7.1 Code for MERGE Statement.txt

1.1 kB

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

2.9 kB

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/8. Primary and Foreign Keys.html

1.6 kB

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

65 MB

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/9.1 Code for Sequence Statements.txt

315 B

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/10. DELETE, TRUNCATE, and DROP Commands.mp4

114 MB

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/10.1 Code for Delete, Truncate and Drop Commands.txt

397 B

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/11. Working With Database Indexes.mp4

80 MB

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/11.1 Code for Database Indexes.txt

601 B

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/12. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).mp4

159 MB

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/12.1 Code for System Tables, Pseudo Columns, & Deleting Duplicate Data.txt

1.2 kB

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/13. Views and Other Objects and Commands (Newly Added).mp4

138 MB

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/13.1 Code for Other Objects and Commands VIEWs UNIONALL etc.txt

1.6 kB

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/14. SQL could be tricky, check this out!.html

1.2 kB

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

170 B

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/16. BECOME A SQL QUERY WIZARD!.html

704 B

7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/17. Bonus Lecture Lifetime Access to All My Courses.html

995 B

8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/1. OFFSET and FETCH.mp4

66 MB

8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/2. ERD Diagrams.mp4

62 MB

8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/3. Commit, Rollback, and Savepoint.mp4

54 MB

8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/4. Large Objects and Interval Data Types.mp4

131 MB

8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/5. Using Cascade Constraints and On Delete Cascade.mp4

115 MB

8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/5.1 code for cascade constraints.txt

798 B

8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/6. UNUSED Columns.mp4

39 MB

8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/7. External Tables.mp4

108 MB

8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/7.1 code for external tables.txt

1.0 kB

8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/8. SQL Plus and Substitution Variables.mp4

226 MB

9. Exam Question Walkthrough Videos + 2 Exams/1. QA 1- DML, DDL, and Transaction Control.mp4

168 MB

9. Exam Question Walkthrough Videos + 2 Exams/2. QA 2- Fetch and Substitution Variables.mp4

177 MB

9. Exam Question Walkthrough Videos + 2 Exams/3. QA 3- Conversion Functions, T0_CHAR, TO_DATE, and NVL.mp4

214 MB

9. Exam Question Walkthrough Videos + 2 Exams/4. Practice Test 1.html

155 B

9. Exam Question Walkthrough Videos + 2 Exams/5. Practice Test 2.html

155 B

10. APPENDIX - Installing Oracle on Windows/1. Install Oracle Database 19c in Windows.mp4

78 MB

10. APPENDIX - Installing Oracle on Windows/2. Install Oracle SQL Developer in Windows.mp4

95 MB