Oracle SQL - Step by Step SQL

6 Hours | Video: AVC (.MP4) 1280x720 30fps | Audio: AAC 44.1KHz 2ch | 652MB

Genre: eLearning | Language: English

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

* Lectures 111

Learn to become a fee-earning SQL developer in just

seven weeks

.

Question Answer

Give? SELECT

What columns? DAY, CITY

Summary? SUM(VOLUME)

Preposition? FROM

Which table contains sales orders data? SALES

Filter? WHERE SALES_DATE BETWEEN ’01-JAN-2015’ and ’31-JAN-2015’

Grouping? GROUP BY DAY, CITY

*Relational databases Concepts

*Retreiving Data from Database

*Filtering Data based on business requirements

*Creating Tables and modifying its structure

*Joining Data from various Tables

*Grouping Data and calculating summaries

*Enforcing Constraints on Tables

*Improving performance using Index

*and many more interesting things..

*Oracle Database 11g

*SQL Developer