Learn Oracle SQL from Scratch - Step by Step Approach
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,772 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Oracle SQL from Scratch - Step by Step Approach to your Wishlist.

Add to Wishlist

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,772 students enrolled
Created by Vibhav Kumar
Last updated 2/2016
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 4 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
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
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




Who is the target audience?
  • Startup folks
  • Non-technical folks
  • Recent College Grad
  • Job Seekers
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 24 Lectures Collapse All 24 Lectures 01:50:22
+
Introduction
3 Lectures 06:46
+
Setup Installation
2 Lectures 00:00
How to install Oracle Database
6 pages

How to install JDK and SQL Developer
1 page
+
Database Concepts
5 Lectures 26:19

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
+
Understand our Database Model
1 Lecture 04:58
HR Schema
04:58
+
Retrieve Data from Database (Select)
6 Lectures 27:16
Mission Impossible
01:16

Retrieve All Data from a Table
10:02

Retrieve Selective Data from a Table
05:31


Summary of Section
03:21

It's Quiz Time
2 pages
+
Restrict Data (Where)
3 Lectures 11:46
Restrict Data using Where Clause
04:42

Filter data on Character & Date values
07:04

Quiz Time
2 pages
+
Comparison Operators
4 Lectures 22:17
Basic Comparison Opertors
07:43

IN & Not IN Operators
05:34

Between & Not Between Operators
04:24

All & Any Operators
04:36
About the Instructor
Vibhav Kumar
4.2 Average rating
64 Reviews
4,120 Students
2 Courses
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.