The Complete Oracle SQL Certification Course

سرفصل های دوره

Don't Just Learn the SQL Language, Become Job-Ready and Launch Your Career as a Certified Oracle SQL Developer!

01 - Database Basics

001 Oracle Database Introduction & Basics of Tables

002 Creating the Workspace in Oracle

003 IMPORTANT Prepare the Sample Data

003 course-data.txt

004 Dedicated TA Support

005 Join our Online Community (Discord).html

006 How to Proceed in This Course

02 - Single Table Queries (Exercises & Solutions in the Lectures)

001 Oracle Exams and Certification Information.html

002 Code-for-Select-Clause.txt

002 Retrieving Data Using the SELECT Clause

003 Code-for-WHERE-Clause.txt

003 Using the WHERE Clause in a Query

004 Important Information from Instructor

005 Code-for-Using-Operators-in-the-WHERE-Clause.txt

005 Using Operators in the WHERE Clause

006 Some Inspiration

007 Code-for-Combining-WHERE-AND-OR-Operators.txt

007 Combining WHERE, AND & OR with Operators

008 Code-for-Query-Filtering-Continued-BETWEEN-IN-NULL.txt

008 Query Filtering Continued BETWEEN, IN and NULL

009 What Will Make you Grow as a Software Developer

010 Code-for-Query-Filtering-Conditions-Operator-Precedence.txt

010 Query Filtering Conditions & Operator Precedence

011 Code-for-Ordering-Concatenating-Aliasing-Query-Results.txt

011 Ordering, Concatenating And Aliasing Query Results

012 Assignment 1 Practice with Single Table Queries.html

03 - Single Row Functions (Exercises and Solutions In the Lectures)

001 Code-for-Single-Row-Functions-SRF-Using-the-Dual-Table.txt

001 Single Row Functions (SRF) & Using The Dual Table

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

002 Using Functions in WHERE And Character Based SRFs

003 Code-for-Numeric-and-Date-Datatype-SRFs.txt

003 Numeric and Date Data type SRFs

004 Code-for-Conversion-SRFs-Date-Formatting.txt

004 Conversion SRFs and Date Formatting

005 Some More Date Functions.html

006 Code-for-Concluding-SRFs-NULL-NULLIF-Functions.txt

006 Concluding SRFs & NULL NULLIF Functions

007 Assignment 2 Practice with Single Row Functions.html

04 - Grouping Functions (Exercises and Solutions In the Lectures)

001 Code-for-Grouping-Functions-MIN-MAX-AVG-COUNT-etc.txt

001 Grouping Functions MIN, MAX, AVG, COUNT etc

002 Code-for-GROUP-BY-Clause-HAVING-CLAUSE.txt

002 GROUP BY Clause & HAVING Clause

003 Code-for-More-Practice-with-the-GROUP-BY-Clause.txt

003 More Practice With The GROUP BY Clause

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)

001 Code-for-SELECT-within-SELECT-Nested-Queries-Subqueries.txt

001 SELECT within SELECT (Subqueries)

002 Code-for-Relating-Tables-together-using-JOINs.txt

002 Relating Tables Together Using JOINs

003 Code-for-JOINS-Continued-INNER-OUTER-Joins.txt

003 Joins Continued INNER & OUTER Joins

004 Career Advice

005 Code-for-More-JOINS-with-Correlated-Subqueries.txt

005 Correlated Subqueries with EXISTS & NOT EXIST operators

006 SELF JOIN

007 CROSS JOIN, NATURAL JOIN and the USING CLAUSE

008 Code-for-EQUI-and-NON-EQUI-Joins.txt

008 EQUIJOIN and NON-EQUIJOINs

009 CASE Statements

009 Code-for-CASE-Statement.txt

009 Oracle-COALESCE-Function.pdf

06 - Analytical Functions using OVER and PARTITION with ORDER BY

001 OVER Clause with PARTITION BY

002 Compute Running Totals with Ordering and Partitioning

003 Unbounded Preceding Order in Over Clause

004 Slicing Windows and Filtering with Analytic Functions

005 Rank, Dense rank, Lead, and Lag Functions

006 Assignment Application of Window Functions and SELF JOIN.html

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)

001 Code-for-Creating-Your-Own-Tables-Design-Considerations.txt

001 Creating Your Own Tables & Design Considerations

002 Code-for-Inserting-Data-Into-our-Table.txt

002 Inserting Data Into Our Table

003 Code-for-Create-Table-With-Primary-Key-Constraint.txt

003 Create Table With a Primary Key Constraint

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

004 INSERT ALL for Multi-table & Conditional Inserts

005 Code-for-Alter-Table-and-Modify-Column-Attributes.txt

005 Using ALTER to modify the table structure

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

006 Create Table with SELECT + UPDATE Data

007 Code-for-MERGE-Statement.txt

007 MERGE Statement in Oracle

007 merge-sql-example.txt

008 Primary and Foreign Keys.html

009 Sequence Statements in Oracle

010 Code-for-Delete-Truncate-and-Drop-Commands.txt

010 DELETE, TRUNCATE, and DROP Commands

011 Code-for-Database-Indexes.txt

011 Working With Database Indexes

012 Code-for-System-Tables-Pseudo-Columns-Deleting-Duplicate-Data.txt

012 System Tables, Pseudo Columns & Deleting Duplicates (Newly Added)

013 Code-for-Other-Objects-and-Commands-VIEWs-UNION-ALL-etc.txt

013 Views and Other Objects and Commands (Newly Added)

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

015 Granting and Revoking Privileges

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071

001 OFFSET and FETCH

002 ERD Diagrams

003 Commit, Rollback, and Savepoint

004 Large Objects and Interval Data Types

004 code-for-building-lease-example.txt

005 Using Cascade Constraints and On Delete Cascade

005 code-for-cascade-constraints.txt

006 UNUSED Columns

007 External Tables

007 code-for-external-tables.txt

008 SQL Plus and Substitution Variables

09 - Exam Question Walkthrough Videos + 2 Exams

001 QA 1- DML, DDL, and Transaction Control

002 QA 2- Fetch and Substitution Variables

003 QA 3 - Conversion Functions, TO CHAR, NVL, and TO DATE

004 Practice Test 1.html

005 Practice Test 2.html

10 - APPENDIX - Installing Oracle on Windows

001 Install Oracle Database 19c in Windows

002 Install Oracle SQL Developer in Windows

11 - Course Extras!

001 Bonus Lecture.html

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy