The Complete Oracle SQL Certification Course

The Complete Oracle SQL Certification Course, available at $189.99, has an average rating of 4.55, with 75 lectures, 2 quizzes, based on 49562 reviews, and has 192407 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone willing to get into the software development career or Anyone willing to Master SQL and get a job as a well paid Oracle SQL Developer or Anyone willing to work hard in mastering the SQL language or Anyone who is interested in passing the Oracle 1Z0-071 exam! It is particularly useful for Anyone willing to get into the software development career or Anyone willing to Master SQL and get a job as a well paid Oracle SQL Developer or Anyone willing to work hard in mastering the SQL language or Anyone who is interested in passing the Oracle 1Z0-071 exam!.

Enroll now: The Complete Oracle SQL Certification Course

Summary

Title: The Complete Oracle SQL Certification Course

Price: $189.99

Average Rating: 4.55

Number of Lectures: 75

Number of Quizzes: 2

Number of Published Lectures: 72

Number of Published Quizzes: 2

Number of Curriculum Items: 78

Number of Published Curriculum Objects: 74

Number of Practice Tests: 2

Number of Published Practice Tests: 2

Original Price: $189.99

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

Anyone willing to get into the software development career

Anyone willing to Master SQL and get a job as a well paid Oracle SQL Developer

Anyone willing to work hard in mastering the SQL language

Anyone who is interested in passing the Oracle 1Z0-071 exam!

Target Audiences

Anyone willing to get into the software development career

Anyone willing to Master SQL and get a job as a well paid Oracle SQL Developer

Anyone willing to work hard in mastering the SQL language

Anyone who is interested in passing the Oracle 1Z0-071 exam!

LAST UPDATED: June 2023

(Added a Comprehensive Assignment on Analyzing Sales data)

(Source Code Included for ALL Lectures)

Get ready to acquire some seriously marketable programming skills! You can’t consider yourself a complete end to end developer until you can code in SQL. Today, data has become the hottest topic in technology and a company’s biggest asset is their data. All databases require the language SQL to store and retrieve data. Salaries for junior level SQL Developers are upwards of $70,000 – $90,000 dollars a year! The great thing is, for this course, you do not need any prior experience in programming what so ever. SQL is a different animal and we’re going to demystify the language from scratch and prepare you with plenty of progressively challenging assignments so that by the time you’ve completed the course (in 2 months), you can call your self an Oracle SQL Master! Oracle is the most popular relational database in the world! This course will prepare you to be job-ready in just 1 month of study and practice.

All exercises and solutions are in the lectures. In several lectures I ask students to pause the video and complete the assignment before resuming to watch my solution. MAKE SURE YOU WORK OUT THE PROBLEMS ON YOUR OWN BEFORE MOVING ON TO MY SOLUTION!!

With over 62,000 enrolled students and a 4.5 star-rating, this is a Udemy best-selling course.

Do you have no prior experience in SQL development? This course is perfect for you. Don’t take it from me, take it from actual students that took this course:

“I am a beginner and the way this course starts is perfect for the person who has no introduction of SQL or Oracle.”

Do you have prior experience, but need a refresher or to fine-tune your skills? This is the course for you. Again, I’ll let my students do the talking:

“I had a good base of knowledge from my last employment. This course is constantly proving useful to supercharge my actual knowledge base. Very good one!“

Have you taken a SQL course before, but felt confused on certain topics or not completely satisfied in your abilities? A lot of my students had shared similar concerns:

“I had previously taken a college course about databases and SQL, but these ten hours of content were more clear and useful than the course and textbook.”

Topics covered in this course :

Basics of Tables

SELECT and WHERE Clause

WHERE, AND & OR with Operators

BETWEEN, IN and NULL

Single Table Queries

Single Row Functions

Grouping Functions

GROUP BY and HAVING Clause

Joins

Inner and Outer Joins

EXISTS & NOT EXIST Operators

Creating Your Own Tables

Using ALTER

Creating Tables with SELECT & UPDATE Data

DELETE, TRUNCATE, and DROP Commands

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

Views and Other Objects and Commands (Newly Added)

Course Curriculum

Chapter 1: Database Basics

Lecture 1: Oracle Database Introduction & Basics of Tables

Lecture 2: Creating the Workspace in Oracle

Lecture 3: IMPORTANT: Prepare the Sample Data

Lecture 4: Dedicated TA Support

Lecture 5: Join our Online Community (Discord)

Lecture 6: How to Proceed in This Course

Chapter 2: Single Table Queries (Exercises & Solutions in the Lectures)

Lecture 1: Oracle Exams and Certification Information

Lecture 2: Retrieving Data Using the SELECT Clause

Lecture 3: Using the WHERE Clause in a Query

Lecture 4: Important Information from Instructor

Lecture 5: Using Operators in the WHERE Clause

Lecture 6: Some Inspiration

Lecture 7: Combining WHERE, AND & OR with Operators

Lecture 8: Query Filtering Continued BETWEEN, IN and NULL

Lecture 9: What Will Make you Grow as a Software Developer

Lecture 10: Query Filtering Conditions & Operator Precedence

Lecture 11: Ordering, Concatenating And Aliasing Query Results

Lecture 12: Assignment 1: Practice with Single Table Queries

Chapter 3: Single Row Functions (Exercises and Solutions In the Lectures)

Lecture 1: Single Row Functions (SRF) & Using The Dual Table

Lecture 2: Using Functions in WHERE And Character Based SRFs

Lecture 3: Numeric and Date Data type SRFs

Lecture 4: Conversion SRFs and Date Formatting

Lecture 5: Some More Date Functions

Lecture 6: Concluding SRFs & NULL / NULLIF Functions

Lecture 7: Assignment 2: Practice with Single Row Functions

Chapter 4: Grouping Functions (Exercises and Solutions In the Lectures)

Lecture 1: Grouping Functions MIN, MAX, AVG, COUNT etc.

Lecture 2: GROUP BY Clause & HAVING Clause

Lecture 3: More Practice With The GROUP BY Clause

Chapter 5: Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)

Lecture 1: SELECT within SELECT (Subqueries)

Lecture 2: Relating Tables Together Using JOINs

Lecture 3: Joins Continued INNER & OUTER Joins

Lecture 4: Career Advice

Lecture 5: Correlated Subqueries with EXISTS & NOT EXIST operators

Lecture 6: SELF JOIN

Lecture 7: CROSS JOIN, NATURAL JOIN and the USING CLAUSE

Lecture 8: EQUIJOIN and NON-EQUIJOINs

Lecture 9: CASE Statements

Chapter 6: Analytical Functions using OVER and PARTITION with ORDER BY

Lecture 1: OVER Clause with PARTITION BY

Lecture 2: Compute Running Totals with Ordering and Partitioning

Lecture 3: Unbounded Preceding Order in Over Clause

Lecture 4: Slicing Windows and Filtering with Analytic Functions

Lecture 5: Rank, Dense_rank, Lead, and Lag Functions

Lecture 6: Assignment: Application of Window Functions and SELF JOIN

Chapter 7: Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)

Lecture 1: Creating Your Own Tables & Design Considerations

Lecture 2: Inserting Data Into Our Table

Lecture 3: Create Table With a Primary Key Constraint

Lecture 4: INSERT ALL for Multi-table & Conditional Inserts

Lecture 5: Using ALTER to modify the table structure

Lecture 6: Create Table with SELECT + UPDATE Data

Lecture 7: MERGE Statement in Oracle

Lecture 8: Primary and Foreign Keys

Lecture 9: Sequence Statements in Oracle

Lecture 10: DELETE, TRUNCATE, and DROP Commands

Lecture 11: Working With Database Indexes

Lecture 12: System Tables, Pseudo Columns & Deleting Duplicates (Newly Added)

Lecture 13: Views and Other Objects and Commands (Newly Added)

Lecture 14: SQL could be tricky, check this out!

Lecture 15: Granting and Revoking Privileges

Chapter 8: ADDITIONAL TOPICS + REVIEW for EXAM 170-071

Lecture 1: OFFSET and FETCH

Lecture 2: ERD Diagrams

Lecture 3: Commit, Rollback, and Savepoint

Lecture 4: Large Objects and Interval Data Types

Lecture 5: Using Cascade Constraints and On Delete Cascade

Lecture 6: UNUSED Columns

Lecture 7: External Tables

Lecture 8: SQL Plus and Substitution Variables

Chapter 9: Exam Question Walkthrough Videos + 2 Exams

Lecture 1: QA 1- DML, DDL, and Transaction Control

Lecture 2: QA 2- Fetch and Substitution Variables

Lecture 3: QA 3 – Conversion Functions, TO_CHAR, NVL, and TO_DATE

Chapter 10: APPENDIX – Installing Oracle on Windows

Lecture 1: Install Oracle Database 19c in Windows

Lecture 2: Install Oracle SQL Developer in Windows

Chapter 11: Course Extras!

Lecture 1: Bonus Lecture

Instructors

Job Ready Programmer
Senior Software Engineers and Trainers

Rating Distribution

1 stars: 276 votes

2 stars: 528 votes

3 stars: 3873 votes

4 stars: 18031 votes

5 stars: 26854 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!