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.8 (45 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,769 students enrolled
Instructed by Vibhav Kumar IT & Software / Other
$19
$20
5% 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

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

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

What 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.

Curriculum

Section 1: Introduction
Introduction
Preview
01:26
Breakup of Course
03:35
The Simple secret of Success
Preview
01:45
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
Preview
04:57
What is Database model & RDBMS
06:17
What is a Table
03:44
Transaction and ACID Properties
05:42
Overview of SQL and its Commands
05:39
Section 4: Understand our Database Model
HR Schema
04:58
Section 5: Retrieve Data from Database (Select)
Mission Impossible
01:16
Retrieve All Data from a Table
10:02
Retrieve Selective Data from a Table
05:31
Retrieve Unique Data from a Table (Distinct)
Preview
07:06
Summary of Section
03:21
It's Quiz Time
2 pages
Section 6: Restrict Data (Where)
Restrict Data using Where Clause
04:42
Filter data on Character & Date values
07:04
Quiz Time
2 pages
Section 7: Comparison Operators
Basic Comparison Opertors
07:43
IN & Not IN Operators
05:34
Between & Not Between Operators
04:24
All & Any Operators
04:36

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