Oracle SQL - Step by Step SQL
4.4 (1,769 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
13,112 students enrolled

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 (1,769 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
13,112 students enrolled
Created by Amarnath Reddy
Last updated 12/2018
English
English
Current price: $11.99 Original price: $199.99 Discount: 94% off
3 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5.5 hours on-demand video
  • 1 article
  • 25 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 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..
Requirements
  • Any Student with computer operation knowledge is good enough to understand this 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
Who this course is for:
  • 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.
Course content
Expand all 126 lectures 06:19:02
+ Software Installation
5 lectures 11:10
Installing Oracle
03:08
Installing Java SDK
02:00
Installing SQL Developer
03:50
Running scripts necessary for the course
02:12
+ Database Concepts
6 lectures 13:49
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
+ Enter the Dragon (Database)
5 lectures 09:45

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

Building SQL Template...
00:05
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
+ Lets see the Data...
4 lectures 09:33
What data can I see?
03:45
How do I see a part of the data (SELECT) ?
02:57
Lab 1 (Exercises with Answers)
3 pages
+ Lets limit the data we see (Filtering)
6 lectures 17:14
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
+ Logical Operators
8 lectures 24:07
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
+ Lets sort the data we see (Sorting)
3 lectures 06:10
ORDER BY clause
04:04
How are NULL values treated while Sorting Data?
02:06
Lab 5 (Exercises with Answers)
2 pages
+ How do we combine data from 2 tables?
6 lectures 12:53
SET Operators
02:39
UNION operator
04:22
INTERSECT operator
02:00
MINUS operator
02:24
Lab 6 (Exercises with Answers)
3 pages