Learn Oracle SQL from Scratch - Step by Step Approach

One-stop shop to learn SQL from Scratch, become Oracle certified and earn $100K in IT Industry
3.4 (46 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.
2,771 students enrolled
Instructed by Vibhav Kumar IT & Software / Other
25% off
Take This Course
  • Lectures 24
  • Length 2 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2016 English

Course Description

This unique introductory SQL tutorial not only provides easy-to-understand Oracle SQL instructions, but it allows you to prepare for SQL Interviews and Oracle Certifications. This course bundles Basic + Intermediate + Advanced SQL + SQL Interview Questions + Oracle Certification Preparation.

This Course is for beginners who doesn't have any knowledge about SQL. I have taught the course in such a way that any non-technical person will understand easily all Database Concepts and SQL Commands.

In this course, you will learn:

  • Oracle Database 11g Installation
  • Databases Concepts
  • Retrieving & Filtering Data from Database
  • Using various Database Functions
  • Creating Tables and modifying its structure
  • Joining Data from various Tables
  • Grouping Data and calculating summaries
  • Enforcing Constraints on Tables

Softwares used in Course

  • Oracle Database 11g
  • SQL Developer

On course completion, You will be Mastered in SQL and can implement Successfully it in your work place or will surely land on High Paying Job

What are the requirements?

  • No previous technical knowledge required
  • No need to download & install any software beforehand, we'll cover this all in Course
  • Access to the Internet & a Machine(PC/Laptop) to solve exercises
  • An open mind and a willingness to learn something new and interesting

What am I going to get from this course?

  • Understand Database terminology
  • Make data-driven decisions
  • Will get complete knowledge of SQL
  • Will be able to clear Oracle Certification Exam
  • "Last but not least" you will be able to clear any Interview of Oracle SQL

Who is the target audience?

  • Startup folks
  • Non-technical folks
  • Recent College Grad
  • Job Seekers

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Introduction
Breakup of Course
The Simple secret of Success
Section 2: Setup Installation
How to install Oracle Database
6 pages
How to install JDK and SQL Developer
1 page
Section 3: Database Concepts
What is an Oracle Database
What is Database model & RDBMS
What is a Table
Transaction and ACID Properties
Overview of SQL and its Commands
Section 4: Understand our Database Model
HR Schema
Section 5: Retrieve Data from Database (Select)
Mission Impossible
Retrieve All Data from a Table
Retrieve Selective Data from a Table
Retrieve Unique Data from a Table (Distinct)
Summary of Section
It's Quiz Time
2 pages
Section 6: Restrict Data (Where)
Restrict Data using Where Clause
Filter data on Character & Date values
Quiz Time
2 pages
Section 7: Comparison Operators
Basic Comparison Opertors
IN & Not IN Operators
Between & Not Between Operators
All & Any Operators

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Vibhav Kumar, Trainer, Oracle Architect (OCP)

Vibhav Kumar, Trainer, has a Masters Degree in computer science from a top-notch college with around 10 years of experience in the IT industry. He has successfully designed and implemented projects for clients in USA, Uk and Singapore. Currently he is working in a Fortune 500 Company as an Architect.

Here, he is to train and groom students through efficacious pedagogy and modern teaching tools, to get employed with great skills required to work anywhere in the world.

Ready to start learning?
Take This Course