Development
Databases
Oracle SQL
The Complete Oracle SQL Certification Course
4.5 (20,195 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
76,938 students enrolled

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!
Bestseller
4.5 (20,195 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
76,938 students enrolled
Created by Imtiaz Ahmad
Last updated 7/2020
English
English [Auto], French [Auto], 5 more
  • German [Auto]
  • Italian [Auto]
  • Polish [Auto]
  • Portuguese [Auto]
  • Spanish [Auto]
Preview this course
The Complete Oracle SQL Certification Course
Current price: $126.99 Original price: $194.99 Discount: 35% off
2 days left at this price!
Buy now
30-Day Money-Back Guarantee
This course includes
  • 16 hours on-demand video
  • 6 articles
  • 39 downloadable resources
  • 2 Practice Tests
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
Course content
Expand all 63 lectures 16:15:58
+ – Database Basics
3 lectures 29:58
Oracle Database Introduction & Basics of Tables
Preview 19:43
Creating the Workspace in Oracle
Preview 06:33

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.

IMPORTANT: Prepare the Sample Data
03:42
+ – Single Table Queries (Exercises & Solutions in the Lectures)
8 lectures 02:13:47
Oracle Exams and Certification Information
00:27
Retrieving Data Using the SELECT Clause
14:42
Using the WHERE Clause in a Query
19:37
Using Operators in the WHERE Clause
19:47
Combining WHERE, AND & OR with Operators
19:16
Query Filtering Continued BETWEEN, IN and NULL
Preview 20:02
Query Filtering Conditions & Operator Precedence
19:56
Ordering, Concatenating & Aliasing Query Results
20:00
In this assignment, you'll have the opportunity to practice everything you've learned in this section. DO NOT SKIP THIS ASSIGNMENT!
Practice with single table queries
9 questions
+ – Single Row Functions (Exercises and Solutions In the Lectures)
6 lectures 01:35:53
Single Row Functions (SRF) & Using The Dual Table
19:37
Using Functions in WHERE And Character Based SRFs
20:00
Numeric and Date Data type SRFs
19:53
Conversion SRFs and Date Formatting
19:39
Some More Date Functions
00:26
Concluding SRFs & NULL / NULLIF Functions
16:18
In this assignment, you'll get practice applying everything you learned about single row functions.
Practice with Single Row Functions
9 questions
+ – Grouping Functions (Exercises and Solutions In the Lectures)
3 lectures 51:53
Grouping Functions MIN, MAX, AVG, COUNT etc.
19:42
GROUP BY Clause & HAVING Clause
19:59
More Practice With The GROUP BY Clause
12:12
+ – Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)
8 lectures 02:04:14
SELECT within SELECT (Subqueries)
23:58
Relating Tables Together Using JOINs
19:21
Joins Continued INNER & OUTER Joins
21:30
Correlated Subqueries with EXISTS & NOT EXIST operators
21:14
SELF JOIN
11:10
CROSS JOIN, NATURAL JOIN and the USING CLAUSE
08:43
EQUIJOIN and NON-EQUIJOINs
09:38
CASE Statements
08:40
+ – Analytical Functions using OVER and PARTITION with ORDER BY
5 lectures 01:07:04
OVER Clause with PARTITION BY
18:31
Compute Running Totals with Ordering and Partitioning
18:47
Unbounded Preceding Order in Over Clause
08:42
Slicing Windows and Filtering with Analytic Functions
05:59
Rank, Dense_rank, Lead, and Lag Functions
15:05
+ – Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)
17 lectures 03:57:52
Creating Your Own Tables & Design Considerations
21:01
Inserting Data Into Our Table
19:41
Create Table With a Primary Key Constraint
21:35
INSERT ALL for Multi-table & Conditional Inserts
11:24
Using ALTER to modify the table structure
16:34
Create Table with SELECT + UPDATE Data
19:56
MERGE Statement in Oracle
16:57
Primary and Foreign Keys
00:52
Sequence Statements
12:27
DELETE, TRUNCATE, and DROP Commands
18:50
Working With Database Indexes
14:21
System Tables, Pseudo Columns & Deleting Duplicates (Newly Added)
24:06
Views and Other Objects and Commands (Newly Added)
23:33
SQL could be tricky, check this out!
00:44
Granting and Revoking Privileges
15:08
BECOME A SQL QUERY WIZARD!
00:18
Bonus Lecture: Lifetime Access to All My Courses
00:24
+ – ADDITIONAL TOPICS + REVIEW for EXAM 170-071
8 lectures 02:13:51
OFFSET and FETCH
09:55
ERD Diagrams
18:34
Commit, Rollback, and Savepoint
14:36
Large Objects and Interval Data Types
17:33
Using Cascade Constraints and On Delete Cascade
17:56
UNUSED Columns
07:36
External Tables
14:59
SQL Plus and Substitution Variables
32:42
+ – Exam Question Walkthrough Videos + 2 Exams
3 lectures 01:18:22
QA 1- DML, DDL, and Transaction Control
24:19
QA 2- Fetch and Substitution Variables
25:13
QA 3- Conversion Functions, T0_CHAR, TO_DATE, and NVL
28:50
Practice Test 1
20 questions

Practice Test 2
25 questions
+ – APPENDIX - Installing Oracle on Windows
2 lectures 23:03
Install Oracle Database 19c in Windows
09:36
Install Oracle SQL Developer in Windows
13:27
Requirements
  • Absolutely no programming experience is required to master the content in this course
Description

LAST UPDATED: JUNE 2020

(Source Code Included for 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)

Who this course is for:
  • 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!
Featured review
Pratiksha deshmukh
Pratiksha deshmukh ( 8 courses, 2 reviews )
2 months ago
Hi im assistant professor, dbms is very easy subject as SQL is easy query language compared to other programming languages. So we think that we know it, but after studying this video, making things i forgot n some little stuff is new for me Explanation is in very simple language and amazing, i will definitely recommend this course to my students as well as who want to learn sql programming in detail. Thankyou for this amazing videos.