The Complete Oracle SQL Certification Course
4.6 (2,875 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
13,971 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Complete Oracle SQL Certification Course to your Wishlist.

Add to Wishlist

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!
Best Seller
4.6 (2,875 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
13,971 students enrolled
Created by Imtiaz Ahmad
Last updated 7/2017
Current price: $10 Original price: $195 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 9.5 hours on-demand video
  • 2 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Become Job Ready to Start Contributing as Database Developer Day 1
  • Pass the Oracle SQL Fundamentals Examinations
  • Program in the SQL Language to solve a variety of Database Problems
  • Be a SQL Ninja and understand how the Oracle Database Works
View Curriculum
  • Absolutely no programming experience is required to master the content in this course

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!!

Who is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
32 Lectures
Database Basics
2 Lectures 28:23

Setting Up the SQL Development Environment (Mac & Windows)
Single Table Queries (Exercises & Solutions in the Lectures)
7 Lectures 02:14:13
Retrieving Data Using the SELECT Clause

Using the WHERE Clause in a Query

Using Operators in the WHERE Clause

Combining WHERE, AND & OR with Operators

Query Filtering Continued BETWEEN, IN and NULL

Query Filtering Conditions & Operator Precedence

Ordering, Concatenating & Aliasing Query Results
Single Row Functions (Exercises and Solutions In the Lectures)
5 Lectures 01:35:18
Single Row Functions (SRF) & Using The Dual Table

Using Functions in WHERE And Character Based SRFs

Numeric and Date Data type SRFs

Conversion SRFs & Date Formatting

Concluding SRFs & NULL / NULLIF Functions
Grouping Functions (Exercises and Solutions In the Lectures)
3 Lectures 51:49
Grouping Functions MIN, MAX, AVG, COUNT etc.

GROUP BY Clause & HAVING Clause

More Practice With The GROUP BY Clause
Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)
4 Lectures 01:25:56
SELECT within SELECT (Subqueries)

Relating Tables Together Using JOINs

Joins Continued INNER & OUTER Joins

More Joins With Correlated Subqueries
Creating, Altering, and Updating Tables Using SQL (Exercises in Lectures)
11 Lectures 02:59:46
Creating Your Own Tables & Design Considerations

Inserting Data Into Our Table

Create Table With a Primary Key Constraint

Using ALTER to modify the table structure

Create Table with SELECT + UPDATE Data


Working With Database Indexes (Newly Added)

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

Views and Other Objects and Commands (Newly Added)

Bonus Lecture: Lifetime Access to All My Courses

1-on-1 Skype Session with Mr. Imtiaz Ahmad
About the Instructor
Imtiaz Ahmad
4.6 Average rating
8,217 Reviews
53,742 Students
8 Courses
Senior Software Engineer & Trainer @ Job Ready Programmer

Imtiaz Ahmad is a highly experienced and passionate software consultant working on big data technologies and enterprise software architectures. He's spent a considerable amount of time building financial software on Wall St. and worked with companies like S&P, Goldman Sachs, AOL and JP Morgan along with helping various startups solve mission critical software problems. In his 13+ years of experience, Imtiaz has developed software in programming languages such as Java, C++, Python, PL/SQL and Ruby. He's also the founder of Job Ready Programmer - an online programming school that prepares students of all backgrounds to become professional job-ready software developers through real-world programming courses filled with practical software development projects.