IIRF Online > Development > Database Design & Development > Oracle SQL > The Complete Oracle SQL Certification Course
The Complete Oracle SQL Certification Course by Udemy
Don't Just Learn the SQL Language, Become Job-Ready and Launch Your Career as a Certified Oracle SQL Developer!
Course Highlights
- Become Job Ready to Start Contributing as a Database Developer Day 1
- Program in the SQL Language to Solve a Variety of Database Problems
- Code along with me to PRACTICE and IMPLEMENT everything you learn
- Become a SQL Ninja and Understand How the Oracle Database Works
- MASTER the Content Required to Pass the Oracle 1Z0-071 Database SQL Exam
- Obtain the Skills that are Necessary to Land a Job as a SQL Developer
- Have the Ability to Solve any SQL Problem
Skills you will learn!
Curriculum
6 Topics
Oracle Database Introduction & Basics of Tables
Creating the Workspace in Oracle
IMPORTANT: Prepare the Sample Data
Dedicated TA Support
Join our Online Community (Discord)
How to Proceed in This Course
12 Topics
Oracle Exams and Certification Information
Retrieving Data Using the SELECT Clause
Using the WHERE Clause in a Query
Important Information from Instructor
Using Operators in the WHERE Clause
Some Inspiration
Combining WHERE AND & OR with Operators
Query Filtering Continued BETWEEN IN and NULL
What Will Make you Grow as a Software Developer
Query Filtering Conditions & Operator Precedence
Ordering Concatenating And Aliasing Query Results
Assignment 1: Practice with Single Table Queries
7 Topics
Single Row Functions (SRF) & Using The Dual Table
Using Functions in WHERE And Character Based SRFs
Numeric and Date Data type SRFs
Conversion SRFs and Date Formatting
Some More Date Functions
Concluding SRFs & NULL / NULLIF Functions
Assignment 2: Practice with Single Row Functions
3 Topics
Grouping Functions MIN MAX AVG COUNT etc.
GROUP BY Clause & HAVING Clause
More Practice With The GROUP BY Clause
9 Topics
SELECT within SELECT (Subqueries)
Relating Tables Together Using JOINs
Joins Continued INNER & OUTER Joins
Career Advice
Correlated Subqueries with EXISTS & NOT EXIST operators
SELF JOIN
CROSS JOIN NATURAL JOIN and the USING CLAUSE
EQUIJOIN and NON-EQUIJOINs
CASE Statements
6 Topics
OVER Clause with PARTITION BY
Compute Running Totals with Ordering and Partitioning
Unbounded Preceding Order in Over Clause
Slicing Windows and Filtering with Analytic Functions
Rank Dense_rank Lead and Lag Functions
Assignment: Application of Window Functions and SELF JOIN
15 Topics
Creating Your Own Tables & Design Considerations
Inserting Data Into Our Table
Create Table With a Primary Key Constraint
INSERT ALL for Multi-table & Conditional Inserts
Using ALTER to modify the table structure
Create Table with SELECT + UPDATE Data
MERGE Statement in Oracle
Primary and Foreign Keys
Sequence Statements in Oracle
DELETE TRUNCATE and DROP Commands
Working With Database Indexes
System Tables Pseudo Columns & Deleting Duplicates (Newly Added)
Views and Other Objects and Commands (Newly Added)
SQL could be tricky check this out!
Granting and Revoking Privileges
8 Topics
OFFSET and FETCH
ERD Diagrams
Commit Rollback and Savepoint
Large Objects and Interval Data Types
Using Cascade Constraints and On Delete Cascade
UNUSED Columns
External Tables
SQL Plus and Substitution Variables
5 Topics
QA 1- DML DDL and Transaction Control
QA 2- Fetch and Substitution Variables
QA 3 - Conversion Functions TO_CHAR NVL and TO_DATE
Practice Test 1
Practice Test 2
2 Topics
Install Oracle Database 19c in Windows
Install Oracle SQL Developer in Windows
1 Topic
Bonus Lecture
The Complete Oracle SQL Certification Course
Related Oracle SQL Courses
Thank You!
Your review has been submitted successfully.