ORACLE SQL Step by Step

Keep Seeding

If you like the course ...Please go to the link below and help the creator

https://www.udemy.com/oracle-sql-step-by-step-approach/

Curriculum

Lecture 1
Closed Captions/Sub Titles for the course
1 page
Lecture 2
Welcome!!
05:45
Lecture 3
How to make best use of the program
Preview
1 page
Section 1: Software Installation
Lecture 4
Installing Oracle
04:07
Lecture 5
Installing Java SDK
02:20
Lecture 6
Installing SQL Developer
03:21
Lecture 7
Running scripts necessary for the course
02:12
Lecture 8
Scripts for our Lab Exercises
Preview
4 pages
Section 2: Database Concepts
Lecture 9
What is a Table?
02:23
Lecture 10
What is a Database?
03:15
Lecture 11
What is a Relational Database (RDBMS)?
01:47
Lecture 12
What is a Transaction?
02:27
Lecture 13
What is ACID??
02:40
Lecture 14
RDBMS Vendors
01:17
Section 3: Enter the Dragon (Database)
Lecture 15
How do you talk with a Database?
01:59
Lecture 16
What are the most common commands?
02:43
Lecture 17
What type of Data can we store?
03:12
Lecture 18
Data Model for our Course
01:46
Section 4: Lets see the Data...
Lecture 19
What data can I see?
03:45
Lecture 20
How do I see data (SELECT) ?
Preview
02:51
Lecture 21
How do I see a part of the data (SELECT) ?
02:57
Lecture 22
Lab 1 (Exercises with Answers)
2 pages
Section 5: Lets limit the data we see (Filtering)
Lecture 23
Filtering Data (WHERE command)
Preview
03:21
Lecture 24
Comparison Operators
01:38
Lecture 25
Filtering Data (More Examples...)
03:34
Lecture 26
Filters on Character and Date values...
04:39
Lecture 27
Filtering based on a column in a table...
04:02
Lecture 28
Lab 2 (Exercises with Answers)
2 pages
Section 6: Logical Operators
Lecture 29
BETWEEN and NOT BETWEEN
Preview
02:32
Lecture 30
IN and NOT IN
02:52
Lecture 31
LIKE operator
04:17
Lecture 32
ALL and ANY
03:33
Lecture 33
Lets learn about NULL...
02:08
Lecture 34
IS NULL and IS NOT NULL
03:18
Lecture 35
AND and OR
05:27
Lecture 36
Lab 3 (Exercises with Answers)
2 pages
Section 7: Arithmetic operators
Lecture 37
They are simple!!! (10 + 20 = 30)
Preview
02:42
Lecture 38
Lab 4 (Exercises with Answers)
2 pages
Section 8: Lets sort the data we see (Sorting)
Lecture 39
ORDER BY clause
04:04
Lecture 40
How are NULL values treated while Sorting Data?
02:06
Lecture 41
Lab 5 (Exercises with Answers)
2 pages
Section 9: How do we combine data from 2 tables?
Lecture 42
SET Operators
02:39
Lecture 43
UNION operator
04:22
Lecture 44
UNION ALL operator
Preview
01:28
Lecture 45
INTERSECT operator
02:00
Lecture 46
MINUS operator
02:24
Lecture 47
Lab 6 (Exercises with Answers)
2 pages
Section 10: Lets group the data...
Lecture 48
Aggregate/Summary Functions
Preview
05:28
Lecture 49
GROUP BY clause
04:08
Lecture 50
GROUP BY with multiple columns
05:00
Lecture 51
GROUP BY with HAVING clause
03:21
Lecture 52
Lab 7 (Exercises with Answers)
Preview
2 pages
Section 11: Joining data from 2 or more tables (JOINS)
Lecture 53
Why Joins?
03:53
Lecture 54
Inner Join
05:08
Lecture 55
Left Outer Join
02:43
Lecture 56
Right Outer Join
02:35
Lecture 57
Full Outer Join
02:26
Lecture 58
Cross Join
02:58
Lecture 59
Natural Join
02:22
Lecture 60
Lab 8 (Exercises with Answers)
2 pages
Section 12: Functions available for us to use...
Lecture 61
DUAL (What is this?)
02:37
Lecture 62
Why do we need functions?
01:28
Lecture 63
NUMBER related functions
04:09
Lecture 64
CHARACTER related functions
04:07
Lecture 65
DATE related functions
04:56
Lecture 66
Lab 9 (Exercises with Answers)
Preview
1 page
Section 13: Interesting THINGS!!!
Lecture 67
IF THEN ELSE (CASE statement)
03:19
Lecture 68
Alternative Name (ALIAS name)
04:03
Lecture 69
DISTINCT values
03:18
Lecture 70
PSEUDO Columns
03:26
Section 14: Data Definition Language (DDL)
Lecture 71
Let's create a table (CREATE)
02:57
Lecture 72
Let's change the structure of a table (ALTER)
04:50
Lecture 73
Let's delete the table (DROP)
01:01
Lecture 74
Lab 11 (Exercises with Answers)
2 pages
Section 15: Data Manipulation Language (DML)
Lecture 75
COMMIT and ROLLBACK
01:28
Lecture 76
Insert data into a table (INSERT)
05:14
Lecture 77
Delete data from a table (DELETE)
03:32
Lecture 78
Modify existing data in a table (UPDATE)
03:49
Lecture 79
Delete all the data from a table (TRUNCATE)
03:01
Lecture 80
Lab 12 (Exercises with Answers)
2 pages
Section 16: Lets put some restrictions on a table (Constraints)
Lecture 81
Why constraints?
01:51
Lecture 82
No empty data allowed (NOT NULL)
03:35
Lecture 83
No Duplicate data (UNIQUE)
03:06
Lecture 84
What is NOT NULL + UNIQUE = PRIMARY KEY
03:25
Lecture 85
Accept only few values (CHECK)
03:26
Lecture 86
Check data in other table before inserting/deleting (FOREIGN KEY)
04:46
Lecture 87
Constraints on multiple columns
03:13
Lecture 88
Adding constraints to an existing table
02:04
Lecture 89
More operations on Constraints...
02:11
Lecture 90
Lab 13 (Exercises with Answers)
Preview
2 pages
Section 17: Views
Lecture 91
Why Views?
06:25
Lecture 92
Lets modify an existing view
01:56
Lecture 93
Lets update View Data
02:48
Lecture 94
Create View from more than 1 Table
06:06
Lecture 95
Lab 14 (Exercises with Answers)
2 pages
Section 18: Other Database Objects
Lecture 96
Alternative name for Objects (SYNONYMS)
02:56
Lecture 97
Series of Numbers (SEQUENCE)
03:34
Section 19: Giving Permissions to other users (GRANT)
Lecture 98
I like him (GRANT)
04:33
Lecture 99
I don't like him (REVOKE)
02:51
Lecture 100
List of all GRANT's
2 pages
Section 20: SUB Queries
Lecture 101
What is a SUB Query?
04:33
Lecture 102
Correlated SUB Query
05:21
Section 21: Advanced Topics - Index
Lecture 103
Book Index??
02:25
Lecture 104
Lets create an Index...
03:44
Lecture 105
UNIQUE Index
02:42
Lecture 106
Dropping and Renaming an Index
01:48
Section 22: Bonus: Lets Recap with a 5 Step Process
Lecture 107
Scripts for this Section
2 pages
Lecture 108
Business Requirement
03:12
Lecture 109
Step 1: Let's Select all the columns needed...
05:41
Lecture 110
Step 2: Let's add the necessary Filters...
00:58
Lecture 111
Step 3: Let's perform the Grouping...
01:52
Lecture 112
Step 4: Let's perform Filtering at Group level...
01:04
Lecture 113
Step 5: Lets Sort the data...
00:54
Lecture 114
Recap the 10 things we have done...
01:51
Section 23: Where to Go From Here
Lecture 115
Project Work
3 pages
Lecture 116
Advanced Database concepts you can explore!!!
1 page