Fundamentals of SQL Programming - Writing Advanced SQL Queries on Oracle

100% OFF/DEAL, PAID NOW FREE/UDEMY PROMO CODE, SQL, TECH AND PROGRAMMING

Writing Advanced SQL Queries on Oracle

17 Jun , 2018  

Requirements
  • Basic SQL
  • Basic knowledge of database concepts
 
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.

Who is the target audience?
  • Beginner DBA
  • Anyone who wants to learn something new
yH5BAEAAAAALAAAAAABAAEAAAIBRAA7 - Writing Advanced SQL Queries on Oracle

Best Related Posts

, , ,