Oracle SQL - Step by Step SQL

Discover essential SQL skills necessary to transform you into SQL developer which can earn you $70k+ in the IT Industry
4.4 (713 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.
8,736 students enrolled Bestselling in SQL
Instructed by Amarnath Reddy IT & Software / Other
$19
$200
90% off
Take This Course
  • Lectures 126
  • Length 6.5 hours
  • Skill Level All Levels
  • Languages English, captions
  • 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 2/2015 English Closed captions available

Course Description

Update 10/06/2016: Added new exercises

Update 01/04/2016: Closed Captions/Sub Titles are added to the Lectures.

Learn to become a fee-earning SQL developer in just seven weeks.

This fast, easy and effective course will take you from zero sql writing skills to being able to make money as a SQL developer.

This one-stop-shot-style SQL course will teach you everything you need to know about SQL, from learning various database concepts to writing SQL to interact with the database.

Throughout this SQL course I will be using the below methodology to make you think and help in forming the SQL statement.

Business Need:

Manager asks you to give you a report containing total sales volume for January month by day and city

Questions in your mind to build your SQL query

  • Give?                                                                  SELECT 
  • What columns?                                                 DAY, CITY 
  • Summary?                                                          SUM(VOLUME) 
  • Preposition?                                                      FROM 
  • Which table contains sales orders data?      SALES 
  • Filter?                                                                WHERE SALES_DATE BETWEEN ’01-JAN-2015’ and ’31-JAN-2015’ 
  • Grouping?                                                         GROUP BY DAY, CITY


Combine the above answers to form the below SQL

SELECT day, city, SUM(volume)
FROM sales
WHERE sales_date BETWEEN ’01-JAN-2015’ AND ’31-JAN-2015’
GROUP BY day, city;

In this course participants will learn

  • Relational databases Concepts
  • Retrieving Data from Database using SQL Commands (Select)
  • Filtering Data based on business requirements using SQL Command (Where)
  • Creating Tables and modifying its structure using SQL commands (Create, Alter)
  • Joining Data from various Tables using SQL Joins
  • Grouping Data and calculating summaries using SQL GROUP BY and SQL Aggregate functions
  • Combining data from 2 or more tables using SQL keywords (UNION, UNION ALL, INTERSECT, MINUS)
  • Enforcing Constraints on Tables using SQL commands (Create. Alter)
  • Creating views using SQL command (Create View)
  • Creating other database objects (SYNONYMS, SEQUENCES) using the SQL commands
  • Controlling the access to the users using SQL commands (GRANT, REVOKE)
  • Improving performance using SQL command (create Index )
  • Project Work at the summarize the SQL concepts we learnt.
  • and many more interesting things..

Softwares used

  • Oracle Database 11g
  • SQL Developer

What are the requirements?

  • Any Student with computer operation knowledge is good enough to understand this course

What am I going to get from this course?

  • Understand Database terminology
  • Retrieving Data from Database using SQL Commands (Select)
  • Filtering Data based on business requirements using SQL Command (Where)
  • Creating Tables and modifying its structure using SQL commands (Create, Alter)
  • Joining Data from various Tables using SQL Joins
  • Grouping Data and calculating summaries using SQL GROUP BY and SQL Aggregate functions
  • Combining data from 2 or more tables using SQL keywords (UNION, UNION ALL, INTERSECT, MINUS)
  • Enforcing Constraints on Tables using SQL commands (Create. Alter)
  • Creating views using SQL command (Create View)
  • Creating other database objects (SYNONYMS, SEQUENCES) using the SQL commands
  • Controlling the access to the users using SQL commands (GRANT, REVOKE)
  • Improving performance using SQL command (create Index )
  • Project Work at the summarize the SQL concepts we learnt.
  • and many more interesting things..

What is the target audience?

  • This SQL course is meant for newbies who are not familiar with SQL syntax and/or students looking for a quick refresher on SQL and some important Database concepts. No programming knowledge is needed.

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

Closed Captions/Sub Titles for the course
1 page
Welcome!!
Preview
05:45
How to make best use of the program
Preview
1 page
Section 1: Software Installation
Installing Oracle
04:07
Installing Java SDK
02:20
Installing SQL Developer
03:21
Running scripts necessary for the course
02:12
Scripts for our Lab Exercises
Preview
4 pages
Section 2: Database Concepts
What is a Table?
02:23
What is a Database?
03:15
What is a Relational Database (RDBMS)?
01:47
What is a Transaction?
02:27
What is ACID??
02:40
RDBMS Vendors
01:17
Section 3: Enter the Dragon (Database)
Article

Download this SQL Template and stick it on the Wall so that it will help you in forming the SQL statement....

How do you talk with a Database?
01:59
What are the most common commands?
02:43
What type of Data can we store?
03:12
Data Model for our Course
01:46
Section 4: Lets see the Data...
What data can I see?
03:45
How do I see data (SELECT) ?
Preview
02:51
How do I see a part of the data (SELECT) ?
02:57
Lab 1 (Exercises with Answers)
3 pages
Section 5: Lets limit the data we see (Filtering)
Filtering Data (WHERE command)
Preview
03:21
Comparison Operators
01:38
Filtering Data (More Examples...)
03:34
Filters on Character and Date values...
04:39
Filtering based on a column in a table...
04:02
Lab 2 (Exercises with Answers)
2 pages
Section 6: Logical Operators
BETWEEN and NOT BETWEEN
Preview
02:32
IN and NOT IN
02:52
LIKE operator
04:17
ALL and ANY
03:33
Lets learn about NULL...
02:08
IS NULL and IS NOT NULL
03:18
AND and OR
05:27
Lab 3 (Exercises with Answers)
2 pages
Section 7: Arithmetic operators
They are simple!!! (10 + 20 = 30)
Preview
02:42
Lab 4 (Exercises with Answers)
2 pages
Section 8: Lets sort the data we see (Sorting)
ORDER BY clause
04:04
How are NULL values treated while Sorting Data?
02:06
Lab 5 (Exercises with Answers)
2 pages
Section 9: How do we combine data from 2 tables?
SET Operators
02:39
UNION operator
04:22
UNION ALL operator
Preview
01:28
INTERSECT operator
02:00
MINUS operator
02:24
Lab 6 (Exercises with Answers)
3 pages
Section 10: Lets group the data...
Aggregate/Summary Functions
Preview
05:28
GROUP BY clause
04:08
GROUP BY with multiple columns
05:00
GROUP BY with HAVING clause
03:21
Lab 7 (Exercises with Answers)
Preview
4 pages
Section 11: Joining data from 2 or more tables (JOINS)
Why Joins?
03:53
Inner Join
05:08
Left Outer Join
02:43
Right Outer Join
02:35
Full Outer Join
02:26
Cross Join
02:58
Natural Join
02:22
Joining the 3rd table
01:59
Joining the 4th table and so on...
01:26
Adding filters to Joins
03:34
Lab 8 (Exercises with Answers)
2 pages
Section 12: Functions available for us to use...
DUAL (What is this?)
02:37
Why do we need functions?
01:28
NUMBER related functions
04:09
CHARACTER related functions
04:07
DATE related functions
04:56
Lab 9 (Exercises with Answers)
Preview
2 pages
Section 13: Interesting THINGS!!!
IF THEN ELSE (CASE statement)
03:19
Alternative Name (ALIAS name)
04:03
DISTINCT values
03:18
PSEUDO Columns
03:26
Section 14: Data Definition Language (DDL)
Let's create a table (CREATE)
02:57
Let's change the structure of a table (ALTER)
04:50
Let's delete the table (DROP)
01:01
Create Table AS - CTAS
03:30
Lab 11 (Exercises with Answers)
3 pages
Section 15: Data Manipulation Language (DML)
COMMIT and ROLLBACK
01:28
Insert data into a table (INSERT)
05:14
Delete data from a table (DELETE)
03:32
Modify existing data in a table (UPDATE)
03:49
Delete all the data from a table (TRUNCATE)
03:01
Lab 12 (Exercises with Answers)
4 pages

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Amarnath Reddy, Oracle Architect

Amarnath has a Masters Degree in computer science with around 15 years of experience in the IT industry. He has successfully designed and implemented projects for clients in South Africa, India and USA. Currently his main focus is on Datawarehouse Architecture.

Amarnath is currently working for a fortune 500 company in USA and has pioneered the data architecture discipline. His Innovative and simple architectural designs have won accolades in the company.

Today, he brings leadership and technical expertise to enable customers to optimize and modernize their IT environments leveraging Business Intelligence tools, Big Data, social, mobile, and the Internet of Things.

Ready to start learning?
Take This Course