SQL_Video_Tutorials

[tulip_flower]

​

​

​

​

​

SQL_Video_Tutorials ​

Language: English​

Extension : MP4​

Size : 580MB​

Genre: E-Learning​

It's been a long time since I created these tutorials (2003-2004), they were all provided in SWF format and were relativly small in filesize.
However, due to an update in the Flash Player, the tutorials seemed to halt or would not play at all. This was due to a bug in the inbuilt player.

Contents of the course:-


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)

Links To Download​

Wupload
http://www.wupload.com/file/1183870446
http://www.wupload.com/file/1183850696
http://www.wupload.com/file/1183826726
 
Filejungle
http://www.filejungle.com/f/pg6YnQ
http://www.filejungle.com/f/nqBq53
http://www.filejungle.com/f/Vvg67b

 

[alkamino]

جزاك الله خيرا​

​