TutorialGenius: SQL Video Tutorials Remastered

4296195

TutorialGenius: SQL Video Tutorials Remastered

H264 | English | 1024x752 | MP4 | 23.98 fps 1056 kbps | AAC 44100 Hz | 647 MB
Genre: eLearning


This course teaches you SQL from the absolute basics to advanced topics of the subject. The course consists of 8 Chapters and 30 Tutorials for your learning pleasure. After watching this series of video tutorials, you will be able to apply your SQL knowledge to any SQL-Orientated project, weather it is for business or personal use.
Orignal Download Provider --> Freshwap.com

Introduction
Introduction to SQL (10:22)

Basics
Creating Tables Describe Function (10:14)
SELECT Statement ? Basic View (05:26)
Using Calculated Fields Renaming Fields (07:03)
SELECT > WHERE Clause (17:00)
SELECT > Basic Functions & Phantom Tables (05:11)
NVL Function (02:20)
Functions ? COUNT, MIN, MAX etc. (03:33)

Statements
INSERT Statement Code Comments (07:23)
UPDATE Statement (03:51)
DELETE Statement (06:08)

Clauses
SELECT > ORDER BY Clause (04:07)
SELECT > GROUP BY Clause (05:20)
SELECT > HAVING Clause (03:02)

Keys
Primary Keys (05:31)
Foreign Keys (07:40)

Functions
UNIQUE Function (04:02)
CHECK Function (06:46)
CONSTRAINT Function (03:24)
ALTER Function (10:22)

Joins
Equi-Joins (06:41)
Non Equi-Joins (05:25)
Self-Joins (06:14)
Outer Joins (04:40)

Advanced
Sub Queries (05:21)
DCL ? Sharing/Permissions (06:27)
PROMPT and ACCEPT (04:51)
Views (04:21)
Indexes (02:57)
Reports (06:34)


کد:
http://www.filesonic.com/file/4330377044/SQL_Video_Tutorials.part1.rar
http://www.filesonic.com/file/4330377134/SQL_Video_Tutorials.part2.rar
http://www.filesonic.com/file/4330377074/SQL_Video_Tutorials.part3.rar
Mirror:

کد:
http://www.uploadstation.com/file/fjsB6Qx/SQL_Video_Tutorials.part1.rar
http://www.uploadstation.com/file/y3ba5Hx/SQL_Video_Tutorials.part2.rar
http://www.uploadstation.com/file/WfS9TXD/SQL_Video_Tutorials.part3.rar
Mirror2:

کد:
http://www.filejungle.com/f/jfYxmk/SQL_Video_Tutorials.part1.rar
http://www.filejungle.com/f/5Qu6B5/SQL_Video_Tutorials.part2.rar
http://www.filejungle.com/f/bP456q/SQL_Video_Tutorials.part3.rar