Closed Captions/Sub Titles for the course :
Closed Captions/Sub Titles for the course
How to make best use of the program
Software Installation :
Installing Java SDK
Installing SQL Developer
Running scripts necessary for the course
Scripts for our Lab Exercises
Database Concepts :
What is a Table?
What is a Database?
What is a Relational Database (RDBMS)?
What is a Transaction?
What is ACID??
Enter the Dragon (Database) :
Building SQL Template...
How do you talk with a Database?
What are the most common commands?
What type of Data can we store?
Data Model for our Course
Lets see the Data... :
What data can I see?
How do I see data (SELECT) ?
How do I see a part of the data (SELECT) ?
Lab 1 (Exercises with Answers)
Lets limit the data we see (Filtering) :
Filtering Data (WHERE command)
Filtering Data (More Examples...)
Filters on Character and Date values...
Filtering based on a column in a table...
Lab 2 (Exercises with Answers)
Logical Operators :
BETWEEN and NOT BETWEEN
IN and NOT IN
ALL and ANY
Lets learn about NULL...
IS NULL and IS NOT NULL
AND and OR
Lab 3 (Exercises with Answers)
Arithmetic operators :
They are simple!!! (10 + 20 = 30)
Lab 4 (Exercises with Answers)
Lets sort the data we see (Sorting) :
ORDER BY clause
How are NULL values treated while Sorting Data?
Lab 5 (Exercises with Answers)
How do we combine data from 2 tables? :
UNION ALL operator
Lab 6 (Exercises with Answers)
Lets group the data... :
GROUP BY clause
GROUP BY with multiple columns
GROUP BY with HAVING clause
Lab 7 (Exercises with Answers)
Joining data from 2 or more tables (JOINS) :
Left Outer Join
Right Outer Join
Full Outer Join
Joining the 3rd table
Joining the 4th table and so on...
Adding filters to Joins
Lab 8 (Exercises with Answers)
Functions available for us to use... :
DUAL (What is this?)
Why do we need functions?
NUMBER related functions
CHARACTER related functions
DATE related functions
Lab 9 (Exercises with Answers)
Interesting THINGS!!! :
IF THEN ELSE (CASE statement)
Alternative Name (ALIAS name)
Data Definition Language (DDL) :
Let's create a table (CREATE)
Let's change the structure of a table (ALTER)
Let's delete the table (DROP)
Create Table AS - CTAS
Lab 11 (Exercises with Answers)
Data Manipulation Language (DML) :
COMMIT and ROLLBACK
Insert data into a table (INSERT)
Delete data from a table (DELETE)
Modify existing data in a table (UPDATE)
Delete all the data from a table (TRUNCATE)
Lab 12 (Exercises with Answers)
Lets put some restrictions on a table (Constraints) :
No empty data allowed (NOT NULL)
No Duplicate data (UNIQUE)
What is NOT NULL + UNIQUE = PRIMARY KEY
Accept only few values (CHECK)
Check data in other table before inserting/deleting (FOREIGN KEY)
Constraints on multiple columns
Adding constraints to an existing table
More operations on Constraints...
Lab 13 (Exercises with Answers)
Lets modify an existing view
Lets update View Data
Create View from more than 1 Table
Lab 14 (Exercises with Answers)
Other Database Objects :
Alternative name for Objects (SYNONYMS)
Series of Numbers (SEQUENCE)
Giving Permissions to other users (GRANT) :
I like him (GRANT)
I don't like him (REVOKE)
List of all GRANT's
SUB Queries :
What is a SUB Query?
Sub queries on multiple columns (Pairwise Comparision)
Sub queries on multiple columns (Non-Pairwise Comparision)
Sub queries in the FROM clause
Sub queries in the WITH clause
Scalar Sub queries
Correlated SUB Query
Advanced Topics - Index :
Lets create an Index...
Dropping and Renaming an Index
Bonus: Lets Recap with a 5 Step Process :
Scripts for this Section
Step 1: Let's Select all the columns needed...
Step 2: Let's add the necessary Filters...
Step 3: Let's perform the Grouping...
Step 4: Let's perform Filtering at Group level...
Step 5: Lets Sort the data...
Recap the 10 things we have done...
Where to Go From Here :
Advanced Database concepts you can explore!!!
There are currently no items in your shopping cart.