Oracle Sql Step By Step Approach

  1. Home
  2. Sql
  3. Oracle Sql Step By Step Approach

Tags: SQL

Discover essential SQL skills necessary to transform you into SQL developer which can earn you $70k+ in the IT Industry

Last updated 2022-01-10 | 4.5

- Understand Database terminology
- Retrieving Data from Database using SQL Commands (Select)
- Filtering Data based on business requirements using SQL Command (Where)

What you'll 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..

* Requirements

* Any Student with computer operation knowledge is good enough to understand this course

Description

  • 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..

Course content

24 sections • 126 lectures

Closed Captions/Sub Titles for the course 3 lectures

Closed Captions/Sub Titles for the course Preview 1 page

Welcome!! Preview 05:45

How to make best use of the program Preview 1 page

Software Installation 5 lectures

Installing Oracle Preview 03:08

Installing Java SDK Preview 02:00

Installing SQL Developer Preview 03:50

Running scripts necessary for the course Preview 02:12

Scripts for our Lab Exercises Preview 4 pages

Database Concepts 6 lectures

What is a Table? Preview 02:23

What is a Database? Preview 03:15

What is a Relational Database (RDBMS)? Preview 01:47

What is a Transaction? Preview 02:27

What is ACID?? Preview 02:40

RDBMS Vendors Preview 01:17

Enter the Dragon (Database) 5 lectures

Building SQL Template... Preview 00:05

Download this SQL Template and stick it on the Wall so that it will help you in forming the SQL statement....

How do you talk with a Database? Preview 01:59

What are the most common commands? Preview 02:43

What type of Data can we store? Preview 03:12

Data Model for our Course Preview 01:46

Lets see the Data... 4 lectures

What data can I see? Preview 03:45

How do I see data (SELECT) ? Preview 02:51

How do I see a part of the data (SELECT) ? Preview 02:57

Lab 1 (Exercises with Answers) Preview 3 pages

Lets limit the data we see (Filtering) 6 lectures

Filtering Data (WHERE command) Preview 03:21

Comparison Operators Preview 01:38

Filtering Data (More Examples...) Preview 03:34

Filters on Character and Date values... Preview 04:39

Filtering based on a column in a table... Preview 04:02

Lab 2 (Exercises with Answers) Preview 2 pages

Logical Operators 8 lectures

BETWEEN and NOT BETWEEN Preview 02:32

IN and NOT IN Preview 02:52

LIKE operator Preview 04:17

ALL and ANY Preview 03:33

Lets learn about NULL... Preview 02:08

IS NULL and IS NOT NULL Preview 03:18

AND and OR Preview 05:27

Lab 3 (Exercises with Answers) Preview 2 pages

Arithmetic operators 2 lectures

They are simple!!! (10 + 20 = 30) Preview 02:42

Lab 4 (Exercises with Answers) Preview 2 pages

Lets sort the data we see (Sorting) 3 lectures

ORDER BY clause Preview 04:04

How are NULL values treated while Sorting Data? Preview 02:06

Lab 5 (Exercises with Answers) Preview 2 pages

How do we combine data from 2 tables? 6 lectures

SET Operators Preview 02:39

UNION operator Preview 04:22

UNION ALL operator Preview 01:28

INTERSECT operator Preview 02:00

MINUS operator Preview 02:24

Lab 6 (Exercises with Answers) Preview 3 pages

Lets group the data... 5 lectures

Aggregate/Summary Functions Preview 05:28

GROUP BY clause Preview 04:08

GROUP BY with multiple columns Preview 05:00

GROUP BY with HAVING clause Preview 03:21

Lab 7 (Exercises with Answers) Preview 4 pages

Joining data from 2 or more tables (JOINS) 11 lectures

Why Joins? Preview 03:53

Inner Join Preview 05:08

Left Outer Join Preview 02:43

Right Outer Join Preview 02:35

Full Outer Join Preview 02:26

Cross Join Preview 02:58

Natural Join Preview 02:22

Joining the 3rd table Preview 01:59

Joining the 4th table and so on... Preview 01:26

Adding filters to Joins Preview 03:34

Lab 8 (Exercises with Answers) Preview 2 pages

Functions available for us to use... 6 lectures

DUAL (What is this?) Preview 02:37

Why do we need functions? Preview 01:28

NUMBER related functions Preview 04:09

CHARACTER related functions Preview 04:07

DATE related functions Preview 04:56

Lab 9 (Exercises with Answers) Preview 2 pages

Interesting THINGS!!! 4 lectures

IF THEN ELSE (CASE statement) Preview 03:19

Alternative Name (ALIAS name) Preview 04:03

DISTINCT values Preview 03:18

PSEUDO Columns Preview 03:26

Data Definition Language (DDL) 5 lectures

Let's create a table (CREATE) Preview 02:57

Let's change the structure of a table (ALTER) Preview 04:50

Let's delete the table (DROP) Preview 01:01

Create Table AS - CTAS Preview 03:30

Lab 11 (Exercises with Answers) Preview 3 pages

Data Manipulation Language (DML) 6 lectures

COMMIT and ROLLBACK Preview 01:28

Insert data into a table (INSERT) Preview 05:14

Delete data from a table (DELETE) Preview 03:32

Modify existing data in a table (UPDATE) Preview 03:49

Delete all the data from a table (TRUNCATE) Preview 03:01

Lab 12 (Exercises with Answers) Preview 4 pages

Lets put some restrictions on a table (Constraints) 10 lectures

Why constraints? Preview 01:51

No empty data allowed (NOT NULL) Preview 03:35

No Duplicate data (UNIQUE) Preview 03:06

What is NOT NULL + UNIQUE = PRIMARY KEY Preview 03:25

Accept only few values (CHECK) Preview 03:26

Check data in other table before inserting/deleting (FOREIGN KEY) Preview 04:46

Constraints on multiple columns Preview 03:13

Adding constraints to an existing table Preview 02:04

More operations on Constraints... Preview 02:11

Lab 13 (Exercises with Answers) Preview 2 pages

Views 5 lectures

Why Views? Preview 06:25

Lets modify an existing view Preview 01:56

Lets update View Data Preview 02:48

Create View from more than 1 Table Preview 06:06

Lab 14 (Exercises with Answers) Preview 2 pages

Other Database Objects 2 lectures

Alternative name for Objects (SYNONYMS) Preview 02:56

Series of Numbers (SEQUENCE) Preview 03:34

Giving Permissions to other users (GRANT) 3 lectures

I like him (GRANT) Preview 04:33

I don't like him (REVOKE) Preview 02:51

List of all GRANT's Preview 2 pages

SUB Queries 7 lectures

What is a SUB Query? Preview 04:33

Sub queries on multiple columns (Pairwise Comparision) Preview 04:23

Sub queries on multiple columns (Non-Pairwise Comparision) Preview 03:11

Sub queries in the FROM clause Preview 04:47

Sub queries in the WITH clause Preview 01:31

Scalar Sub queries Preview 02:25

Correlated SUB Query Preview 05:21

Advanced Topics - Index 4 lectures

Book Index?? Preview 02:25

Lets create an Index... Preview 03:44

UNIQUE Index Preview 02:42

Dropping and Renaming an Index Preview 01:48

Bonus: Lets Recap with a 5 Step Process 8 lectures

Scripts for this Section Preview 2 pages

Business Requirement Preview 03:12

Step 1: Let's Select all the columns needed... Preview 05:41

Step 2: Let's add the necessary Filters... Preview 00:58

Step 3: Let's perform the Grouping... Preview 01:52

Step 4: Let's perform Filtering at Group level... Preview 01:04

Step 5: Lets Sort the data... Preview 00:54

Recap the 10 things we have done... Preview 01:51

Where to Go From Here 2 lectures

Project Work Preview 3 pages

Advanced Database concepts you can explore!!! Preview 1 page