Retrieving Data from Oracle Database with SQL

[TheCornor]

Retrieving Data from Oracle Database with SQL

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 4 Hours | Lec: 45 | 603 MB

Genre: eLearning | Language: English

 

Learn to use Oracle SQL

 

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

 

Topics we will cover in this course includes:

 

Using SELECT Statements

 

Learn to use Oracle SQL

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

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

We will start off by ing 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 retrieve data.

Topics we will cover in this course includes:

Retrieving Data

Using SELECT Statements

Using FROM clause

Using WHERE Clause for filtering data

Using NOT Operator

Using the LIKE Operator

Using IS NULL

Using ORDER BY Clause

Using DISTINCT

Using Describe

Using and creating views

Using Sub-Query

Restricting and Sorting Data

Using ORDER BY Clause

Using GROUP BY and HAVING Clause

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

Retrieving Data with SET Operators

Using UNION ALL SET Operator

UNION SET Operator

Using INTERSECT Operator

Using Minus Operator

By the end of this course you will have enough skill to retrieve data from an oracle database.

 

DOWNLOAD

uploadgig

https://uploadgig.com/file/download/12904df83B789af8/aAgoBqHj_Retrieving_Data_from_Oracle_Database_with_SQL.part1.rar

https://uploadgig.com/file/download/D7266e02Fd737917/aAgoBqHj_Retrieving_Data_from_Oracle_Database_with_SQL.part2.rar

 

nitroflare

http://nitroflare.com/view/44D52015C3325CA/aAgoBqHj_Retrieving_Data_from_Oracle_Database_with_SQL.part1.rar

http://nitroflare.com/view/E762F8BB39BC104/aAgoBqHj_Retrieving_Data_from_Oracle_Database_with_SQL.part2.rar

 

rapidgator

https://rapidgator.net/file/c881ec046e951e87e22c151eaefbed6e/aAgoBqHj_Retrieving_Data_from_Oracle_Database_with_SQL.part1.rar.html

https://rapidgator.net/file/628dd30389e071c7113df7745ba03ebc/aAgoBqHj_Retrieving_Data_from_Oracle_Database_with_SQL.part2.rar.html

 

turbobit

http://turbobit.net/lbiy5x9o12is/aAgoBqHj_Retrieving_Data_from_Oracle_Database_with_SQL.part2.rar.html

http://turbobit.net/hxc9xdgutdbp/aAgoBqHj_Retrieving_Data_from_Oracle_Database_with_SQL.part1.rar.html