Oracle SQL - Step by Step SQL
4.4 (1,134 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.
10,750 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle SQL - Step by Step SQL to your Wishlist.

Add to Wishlist

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
Bestselling
4.4 (1,134 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.
10,750 students enrolled
Created by Amarnath Reddy
Last updated 7/2017
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 1 Article
  • 21 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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..
View Curriculum
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 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
126 Lectures
06:20:19
+
Closed Captions/Sub Titles for the course
3 Lectures 05:45
Closed Captions/Sub Titles for the course
1 page


+
Software Installation
5 Lectures 12:27
Installing Oracle
04:07

Installing Java SDK
02:13

Installing SQL Developer
03:55

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
+
Arithmetic operators
2 Lectures 02:42

Lab 4 (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
14 More Sections
Frequently Bought Together
About the Instructor
Amarnath Reddy
4.4 Average rating
2,716 Reviews
18,804 Students
9 Courses
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.