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
English
English
Current price: $10 Original price: $195 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • Absolutely no programming experience is required to master the content in this course
Description

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
09:35:21
+
Database Basics
2 Lectures 28:23

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

Using the WHERE Clause in a Query
19:35

Using Operators in the WHERE Clause
19:45

Combining WHERE, AND & OR with Operators
19:14

Query Filtering Continued BETWEEN, IN and NULL
19:58

Query Filtering Conditions & Operator Precedence
19:54

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

Using Functions in WHERE And Character Based SRFs
19:58

Numeric and Date Data type SRFs
19:52

Conversion SRFs & Date Formatting
19:37

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

GROUP BY Clause & HAVING Clause
19:57

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

Relating Tables Together Using JOINs
19:19

Joins Continued INNER & OUTER Joins
21:29

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

Inserting Data Into Our Table
19:39

Create Table With a Primary Key Constraint
21:34

Using ALTER to modify the table structure
16:32

Create Table with SELECT + UPDATE Data
19:55

DELETE, TRUNCATE, and DROP Commands
18:48

Working With Database Indexes (Newly Added)
14:19

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

Views and Other Objects and Commands (Newly Added)
23:31

Bonus Lecture: Lifetime Access to All My Courses
00:17

1-on-1 Skype Session with Mr. Imtiaz Ahmad
00:07
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.