The Complete Oracle SQL Certification Course from Udemy

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)

What's inside

Learning objectives

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

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

Syllabus

Learn the very basics of what is a database and how SQL is used to interact with it.

Oracle Database Introduction & Basics of Tables

Creating the Workspace in Oracle

In this lecture, we'll prepare the data in our database. This will setup the playground you'll need to practice SQL throughout the course. Follow the instructions provided in this video for running the commands in the accompanying file.

Dedicated TA Support

Join our Online Community (Discord)

How to Proceed in This Course

Learn about the basic SELECT statement and how it can be used to retrieve data from a single table

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

Learn how single row functions (SRFs) can be used in SQL queries

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

Learn how to summarize data using the GROUP BY Clause in SQL

Grouping Functions MIN, MAX, AVG, COUNT etc.

GROUP BY Clause & HAVING Clause

More Practice With The GROUP BY Clause

Learn how to Join multiple tables to get information from data relationships.

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

Analytical Functions using OVER and PARTITION with ORDER BY

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

Learn about creating new tables and modify existing ones along with updating their data

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

We'll tie all the loose ends in this section by reviewing and supplementing our knowledge of Oracle SQL to better prepare for the exam!

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

This section contains a series of tests to practice the content you learned in the course.

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

APPENDIX - Installing Oracle on Windows

Install Oracle Database 19c in Windows

Install Oracle SQL Developer in Windows

Course Extras!

Bonus Lecture

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Learn the very basics of what is a database and how SQL is used to interact with it

Become Job Ready to Start Contributing as a Database Developer Day 1

Taught by Job Ready Programmer, who are recognized for their work in SQL

Develops skills, knowledge, and/or tools that are useful for personal growth and development

Examines a variety of database-related topics, which is highly relevant in industry

Examines a variety of database-related topics, which is highly relevant in academia

Reviews summary

Learn oracle sql basics

According to students, this introductory course is good for beginners who have no experience with Oracle SQL. Learners say the course is a good starting point and is a great help with getting on the right track to eventually mastering Oracle SQL. Although not mentioned in this review, it's possible this course could include lectures, readings, assignments, and a certificate upon completion.

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in The Complete Oracle SQL Certification Course with these activities:

Read SQL Queries for Mere Mortals

Show steps

Review the fundamentals of SQL and querying data before beginning the course.

View SQL Queries for Mere Mortals on Amazon

Show steps

Read the first three chapters of the book.
Complete the practice exercises at the end of each chapter.

Follow SQL Tutorial for Beginners

Show steps

Enhance understanding of SQL concepts by following a structured tutorial that provides step-by-step guidance.

Browse courses on SQL

Show steps

Go to the TutorialsPoint SQL Tutorial page.
Start from the beginning and work through the tutorial.
Complete the practice exercises provided in each section.

Write SQL Code Snippets

Show steps

Solidify understanding by writing and explaining SQL code snippets to demonstrate specific concepts.

Browse courses on SQL

Show steps

Choose a specific SQL concept or operation.
Write a code snippet that demonstrates the concept.
Write a brief explanation of the code snippet, including the purpose and usage.

Ten other activities

Expand to see all activities and additional details

Show all 13 activities

Review SQL Basics

Show steps

Brush up on the essential SQL concepts, such as data types, operators, and basic queries, to strengthen your foundation for this course.

Browse courses on SQL

Show steps

Go through your notes and assignments from previous SQL courses or tutorials.
Complete practice problems or quizzes related to SQL basics.

Follow Online SQL Courses or Tutorials

Show steps

Complement your learning by exploring additional online SQL courses or tutorials to expand your knowledge and gain insights from different perspectives.

Browse courses on Database Management Systems

Show steps

Identify reputable online platforms offering SQL courses or tutorials.
Review the course content and select one that aligns with your learning goals.
Follow the lessons and complete the exercises provided in the course.

Complete SQL Practice Exercises

Show steps

Practice writing and executing SQL queries to reinforce understanding and strengthen proficiency.

Browse courses on SQL

Show steps

Visit the W3Schools SQL Exercises page.
Select a set of exercises and complete them.
Review the solutions provided to check your answers.

Join a SQL Study Group

Show steps

Enhance your learning by joining a study group where you can discuss concepts, share knowledge, and work on SQL projects with peers.

Show steps

Find or create a study group with other SQL learners.
Meet regularly to discuss course material and work on projects.
Collaborate on assignments and provide feedback to each other.

SQL Coding Exercises

Show steps

Engage in hands-on SQL coding exercises to reinforce your understanding of the concepts covered in this course and improve your proficiency in writing SQL queries.

Browse courses on SQL Programming

Show steps

Find online SQL coding challenges or practice platforms.
Solve SQL coding problems to practice applying SQL concepts and syntax.
Review your solutions and identify areas for improvement.

Build a Simple Database Project

Show steps

Apply SQL skills to a practical project to cement understanding and develop problem-solving abilities.

Browse courses on SQL

Show steps

Choose a simple database project idea, such as creating a personal budget tracker or a recipe collection.
Design the database schema and create the tables.
Populate the database with sample data.
Write SQL queries to retrieve, update, and manage the data.
Validate the results and refine the queries as needed.

SQL Tutorial Project

Show steps

Create a comprehensive SQL tutorial or guide that covers the concepts and techniques learned in this course, providing a valuable resource for future reference and sharing with others.

Browse courses on Database Management

Show steps

Organize your notes and materials from the course.
Write clear and concise explanations of SQL concepts and syntax.
Include examples and practical exercises to illustrate the concepts.
Share your tutorial with others for feedback and improvement.

Create a Data Visualization Dashboard

Show steps

Enhance data analysis skills by creating an interactive dashboard that visualizes data retrieved using SQL queries.

Browse courses on Data Visualization

Show steps

Identify a dataset that can be visualized.
Write SQL queries to extract and format the data.
Choose a data visualization tool and create the dashboard.
Configure interactive elements and filters.
Present the dashboard and explain the insights derived from the visualization.

Mentor Junior SQL Developers

Show steps

Reinforce your knowledge and solidify your understanding of SQL concepts by mentoring junior developers, providing guidance and support as they learn the language.

Browse courses on Peer Support

Show steps

Identify opportunities to mentor junior SQL developers through programs or initiatives.
Share your knowledge and experience to help them overcome challenges and develop their skills.
Provide constructive feedback and support to foster their growth.

Contribute to Open Source SQL Projects

Show steps

Deepen your understanding of SQL by contributing to open source projects, collaborating with other developers, and gaining exposure to real-world SQL applications.

Show steps

Explore open source SQL projects on platforms like GitHub.
Identify areas where you can contribute your skills and knowledge.
Submit pull requests, participate in discussions, and collaborate with the project community.

Career center

Learners who complete The Complete Oracle SQL Certification Course will develop knowledge and skills that may be useful to these careers:

Database Administrator

As a Database Administrator, you will be in charge of maintaining the databases used by a company or organization and its employees. This course will teach you how to work with databases, how to create and modify data, and how to run comprehensive reports on data stored in a database. It will be a massive help for those wanting to pursue a career as a Database Administrator, and all the more so because it focuses on Oracle, the most popular relational database in the world.

See salaries and explore the career path for Database Administrator

Software Developer Manager

As a Software Developer Manager, you will be in charge of managing a team of Software Developers. This course will help build a strong foundation for your career in Software Development Management as you work with a database and master the art of data manipulation using SQL. This will be a helpful resource for those who want to become Software Developer Managers, especially as it focuses on Oracle, the most popular relational database in the world.

See salaries and explore the career path for Software Developer Manager

Software Engineer

As a Software Engineer, you will lead the charge in creating and maintaining user-facing software. SQL is the most prevalent language for interacting with databases, making it a prime skill for those who wish to excel as Software Engineers. This course will help build a strong foundation for your career in software development as you work with a database and master the art of data manipulation using SQL.

See salaries and explore the career path for Software Engineer

Data Analyst

As a Data Analyst, your job will be working with large amounts of data in order to extract insights and present them to clients so they can make informed decisions. This course will teach you how to interact with a database using SQL, which is a necessary skill for a Data Analyst to have. As you work through this course, you will start to learn how to perform various database queries, a vital part of the data analysis process.

See salaries and explore the career path for Data Analyst

IT Auditor

As an IT Auditor, you will be responsible for evaluating the IT systems and practices of a company or organization. A solid knowledge of databases and the SQL language will be very helpful for an IT Auditor to have. This course will teach you how to interact with databases, how to create and modify data, and how to run comprehensive reports on data stored in a database.

See salaries and explore the career path for IT Auditor

IT Consultant

An IT Consultant will assist businesses in selecting, implementing, and maintaining software. Understanding databases and SQL will be a big help for those who wish to become an IT Consultant. This course focuses on Oracle, the most popular relational database system in the world, making it a valuable addition to your resume!

See salaries and explore the career path for IT Consultant

Information Security Analyst

As an Information Security Analyst, you will be responsible for protecting the data and systems of a company or organization. A solid understanding of SQL will help you excel as an Information Security Analyst, as it is a prevalent language for interacting with and managing data. This course will be helpful, teaching you how to interact with a database, filter data, edit data, and much more.

See salaries and explore the career path for Information Security Analyst

IT Manager

As an IT Manager, you will manage the IT systems and resources of an organization. A strong understanding of databases and SQL is very useful for an IT Manager to have. As you work through this course, you will get practice interacting with databases and using SQL to manage and manipulate data.

See salaries and explore the career path for IT Manager

Business Analyst

As part of your job as a Business Analyst, you will study business problems and processes and identify ways to improve them. This course will introduce you to the basics of working with databases and using SQL, the language used to interact with them. This course will be a valuable tool for your career as a Business Analyst, giving you a solid foundation from which to build your knowledge.

See salaries and explore the career path for Business Analyst

Technical Writer

A Technical Writer will be tasked with taking complex technical information and turning it into something easier to understand for laypeople. This course will teach you skills that will be very helpful for a Technical Writer to have, teaching you how a database is structured, how to access data, and how to manipulate it using SQL.

See salaries and explore the career path for Technical Writer

Web Developer

As a Web Developer, you will design and develop websites. A good understanding of databases and SQL will be very beneficial for a Web Developer to have. This course will help you develop a strong foundation in working with databases and using SQL to access, manipulate, and manage data.

See salaries and explore the career path for Web Developer

Data Scientist

Your job as a Data Scientist is to apply mathematics, statistics, and machine learning to problems related to data. This course will introduce you to databases - huge repositories of data - and SQL, the language used to access and manipulate data in them. This course may be helpful for a future career as a Data Scientist.

See salaries and explore the career path for Data Scientist

System Analyst

As a System Analyst, you will observe and analyze existing systems, then outline ways in which they can be improved. This course will teach you the basics of working with databases and using SQL, the language used to interact with them. This course may be helpful as you work towards becoming a System Analyst, providing a good basis for you to build on.

See salaries and explore the career path for System Analyst

Software Test Engineer

As a Software Test Engineer, you will be tasked with testing, evaluating, and reporting on the quality of software programs. This course may be helpful for those seeking to become Software Test Engineers, giving a thorough introduction to interacting with a database and using SQL to access, manipulate, and manage data.

See salaries and explore the career path for Software Test Engineer

Network Engineer

Network Engineers will be tasked with the installation, maintenance, and repair of networks. This course may prove helpful for those hoping to become Network Engineers, giving an introduction to databases and how they are used.

See salaries and explore the career path for Network Engineer