Writing Advanced SQL Queries on Oracle

Learn to execute more advanced queries on Oracle Database

3.65 (13 reviews)
Udemy
platform
English
language
Databases
category
Writing Advanced SQL Queries on Oracle
1,387
students
3 hours
content
Oct 2023
last update
$19.99
regular price

What you will learn

Download and Install Oracle

Download and Install TOAD

Connect TOAD to Oracle

Download and Install Oracle SQL Developer

Extract data from multiple tables

Unlock sample schema

Aggregate result data with aggregate functions

Analyse data with Analytic functions

Description

Oracle database is one of the top and most widely used relational database management systems in the world .

This more advanced beginners course will teach you how to retrieve data from an oracle database.

We will start off by downloading and installing oracle  database 11g express which is free to use. Then we will install TOAD which is a tool we will be using to connect to the oracle database and interact with it.

Topics we will cover in this course includes:


Retrieving Data with Aggregate Functions  
Introduction to aggregate functions 
Using AVG function 
Using COUNT function 
Using MAX function 
Using MIN function


Retrieving Data with Table Joins 
Introduction to Table Joins 
Using Equi Joins 
Using Non Equi Joins 
Using Cartesian Join 
Using Outer Join 
Using Self Join

Retrieving Data with Analytic Functions  
Introduction to Analytic Functions 
The Syntax 
Partition By Clause 
First and Last Function 
Row number Functions 
Dense Rank Function 
Lag Function 
LEAD Function 
RANK Function

 By the end of this course you will have enough skill to write more complex queries on  an oracle database.


SQL is the language used to interact with databases like Oracle  and others.

SQL is a standard language for accessing and manipulating databases.


What is SQL?

SQL stands for Structured Query Language

SQL lets you access and manipulate databases

SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987

What Can SQL do?

SQL can execute queries against a database

SQL can retrieve data from a database

SQL can insert records in a database

SQL can update records in a database

SQL can delete records from a database

SQL can create new databases

SQL can create new tables in a database

SQL can create stored procedures in a database

SQL can create views in a database

SQL can set permissions on tables, procedures, and views

SQL is a Standard - BUT....

Although SQL is an ANSI/ISO standard, there are different versions of the SQL language. However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.

Note: Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!


Content

Oracle Installation and Unlocking Schema

Introduction
Download and install Oracle
Download and install TOAD
Download and Install SQL Developer
Connecting TOAD to Oracle
Connecting SQL Developer to Oracle
Unlocking Schema

Extracting data from multiple tables

Introduction to Joins
Writing query for a SELF Join
Writing query for an OUTER Join
Writing query for a CARTESIAN Join
Writing query for a NON EQUI Join
Writing query for an EQUI Join

Aggregating Data using Aggregate Functions

What are aggregate functions
Writing query for AVG aggregate
Writing query for COUNT aggregate
Writing query for MIN aggregate
Writing query for MAX aggregate

Analysing Data with Analytic Functions

What are analytic functions
How to write Analytic Functions
Using the PARTITION BY Clause
Writing query for First and Last Function
Writing query for ROW Number Function
Writing query for RANK Function
Writing query for DENSE Rank Function
Writing query for LAG Function
Writing query for LEAD function

Reviews

James
September 11, 2018
Very good start to the course but needs to update the Oracle 11g express download intrusions. Oracle has changed their website links to the downloads.

Charts

Price

Writing Advanced SQL Queries on Oracle - Price chart

Rating

Writing Advanced SQL Queries on Oracle - Ratings chart

Enrollment distribution

Writing Advanced SQL Queries on Oracle - Distribution chart

Related Topics

1749824
udemy ID
6/15/2018
course created date
11/20/2019
course indexed date
Bot
course submited by