Refer a friend and get % off! They'll get % off too.

Oracle SQL - The Complete Step By Step Approach

Course Description

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 course will teach you everything you need to know, from learning various database concepts to writing SQL to interact with the database.

Throughout the 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 query

QuestionAnswer
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
  • Retreiving Data from Database
  • Filtering Data based on business requirements
  • Creating Tables and modifying its structure
  • Joining Data from various Tables
  • Grouping Data and calculating summaries
  • Enforcing Constraints on Tables
  • Improving performance using Index
  • 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?

  • Over 111 lectures and 5.5 hours of content!
  • Understand Database terminology
  • Read data from the database
  • Create data in the database
  • Enforce restrictions on what type of data can be stored
  • Improve performance using Index

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.

Curriculum

Welcome!!
05:45
How to make best use of the program
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
4 pages
Section 2: Database Concepts
What is a File?
02:05
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
Database Normalization
1 page
CODD Rules
2 slides
Section 3: Enter the Dragon (Database)
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) ?
02:51
How do I see a part of the data (SELECT) ?
02:57
Lab 1 (Exercises with Answers)
2 pages
Section 5: Lets limit the data we see (Filtering)
Filtering Data (WHERE command)
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
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)
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
01:28
INTERSECT operator
02:00
MINUS operator
02:24
Lab 6 (Exercises with Answers)
2 pages
Section 10: Lets group the data...
Aggregate/Summary Functions
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)
2 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
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
03:47
CHARACTER related functions
04:07
DATE related functions
04:56
Lab 9 (Exercises with Answers)
1 page
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
Lab 11 (Exercises with Answers)
2 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)
2 pages
Section 16: Lets put some restrictions on a table (Constraints)
Why constraints?
01:51
No empty data allowed (NOT NULL)
03:35
No Duplicate data (UNIQUE)
03:06
What is NOT NULL + UNIQUE = PRIMARY KEY
03:25
Accept only few values (CHECK)
03:26
Check data in other table before inserting/deleting (FOREIGN KEY)
04:46
Constraints on multiple columns
03:13
Adding constraints to an existing table
02:04
More operations on Constraints...
02:11
Lab 13 (Exercises with Answers)
2 pages
Section 17: Views
Why Views?
06:25
Lets modify an existing view
01:56
Lets update View Data
02:48
Create View from more than 1 Table
06:06
Lab 14 (Exercises with Answers)
2 pages
Section 18: Other Database Objects
Alternative name for Objects (SYNONYMS)
02:56
Series of Numbers (SEQUENCE)
03:34
Section 19: Giving Permissions to other users (GRANT)
I like him (GRANT)
04:33
I don't like him (REVOKE)
02:51
List of all GRANT's
2 pages
Section 20: SUB Queries
What is a SUB Query?
04:33
Correlated SUB Query
05:21
Section 21: Advanced Topics - Index
Book Index??
02:25
Lets create an Index...
03:44
UNIQUE Index
02:42
Function based Index
03:40
Dropping and Renaming an Index
01:48
Section 22: Where to Go From Here
Advanced Database concepts you can explore!!!
1 page
Practice Exercises
3 pages

You will get a ZIP (644MB) file

$ 29.99

$ 29.99

To be able to receive payments, please enter your payment details.

Discount has been applied.

Added to cart