Oracle SQL - Step by Step SQL

[Alexandr 3]

 

Oracle SQL - Step by Step SQL

English | 6 hours | AVC (.MP4) 1280x720 30fps | AAC 44.1KHz 2ch | 652 Mb

Genre: eLearning

 

 

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

DOWNLOAD

 

Ukryta Zawartość

Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.