COURSE DESCRIPTION
Learn the practical way. Follow the below given metrics and build your 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
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
CURRICULUM
Why Views?
Accept only few values (CHECK)
Adding constraints to an existing table
Advanced Database concepts you can explore!!!
Advanced Topics - Index
Aggregate/Summary Functions
ALL and ANY
Alternative Name (ALIAS name)
Alternative name for Objects (SYNONYMS)
AND and OR
Arithmetic operators
BETWEEN and NOT BETWEEN
Book Index??
CHARACTER related functions
Check data in other table before inserting/deleting (FOREIGN KEY)
CODD Rules
COMMIT and ROLLBACK
Comparison Operators
Constraints on multiple columns
Correlated SUB Query
Create View from more than 1 Table
Cross Join
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Model for our Course
Database Concepts
Database Normalization
DATE related functions
Delete all the data from a table (TRUNCATE)
Delete data from a table (DELETE)
DISTINCT values
Dropping and Renaming an Index
DUAL (What is this?)
Enter the Dragon (Database)
Filtering based on a column in a table...
Filtering Data (More Examples...)
Filtering Data (WHERE command)
Filters on Character and Date values...
Full Outer Join
Function based Index
Functions available for us to use...
Giving Permissions to other users (GRANT)
GROUP BY clause
GROUP BY with HAVING clause
GROUP BY with multiple columns
How are NULL values treated while Sorting Data?
How do I see a part of the data (SELECT) ?
How do I see data (SELECT) ?
How do we combine data from 2 tables?
How do you talk with a Database?
How to make best use of the program
I don't like him (REVOKE)
I like him (GRANT)
IF THEN ELSE (CASE statement)
IN and NOT IN
Inner Join
Insert data into a table (INSERT)
Interesting THINGS!!!
INTERSECT operator
IS NULL and IS NOT NULL
Joining data from 2 or more tables (JOINS)
Lab 1 (Exercises with Answers)
Lab 11 (Exercises with Answers)
Lab 12 (Exercises with Answers)
Lab 13 (Exercises with Answers)
Lab 14 (Exercises with Answers)
Lab 2 (Exercises with Answers)
Lab 3 (Exercises with Answers)
Lab 4 (Exercises with Answers)
Lab 5 (Exercises with Answers)
Lab 6 (Exercises with Answers)
Lab 7 (Exercises with Answers)
Lab 8 (Exercises with Answers)
Lab 9 (Exercises with Answers)
Left Outer Join
Let's change the structure of a table (ALTER)
Let's create a table (CREATE)
Lets create an Index...
Let's delete the table (DROP)
Lets group the data...
Lets learn about NULL...
Lets limit the data we see (Filtering)
Lets modify an existing view
Lets put some restrictions on a table (Constraints)
Lets see the Data...
Lets sort the data we see (Sorting)
Lets update View Data
LIKE operator
List of all GRANT's
Logical Operators
MINUS operator
Modify existing data in a table (UPDATE)
More operations on Constraints...
Natural Join
No Duplicate data (UNIQUE)
No empty data allowed (NOT NULL)
NUMBER related functions
ORDER BY clause
Other Database Objects
PSEUDO Columns
RDBMS Vendors
Right Outer Join
Scripts for our Lab Exercises
Series of Numbers (SEQUENCE)
SET Operators
SUB Queries
They are simple!!! (10 + 20 = 30)
UNION ALL operator
UNION operator
UNIQUE Index
What are the most common commands?
What data can I see?
What is a Database?
What is a File?
What is a Relational Database (RDBMS)?
What is a SUB Query?
What is a Table?
What is a Transaction?
What is ACID??
What is NOT NULL + UNIQUE = PRIMARY KEY
What type of Data can we store?
Where to Go From Here
Why constraints?
Why do we need functions?
Why Joins?
LINK FOR THE FREE COURSE
100% Off, Udemy 100% Off, Udemy Coupon, Udemy Coupon Code, Udemy course, Udemy course download, Udemy course reviews, Udemy courses, Udemy courses for free, Udemy courses free, Udemy courses free download, Udemy discount, Udemy download, Udemy education, Udemy free, Udemy free course, Udemy free courses, Udemy free online courses, Udemy online, Udemy online course, Udemy online courses, Udemy online courses review, Udemy reviews, Udemy tutorial, Udemy tutorials, Udemy.com free courses,
