SQL Video Tutorials by Sean Greasley
English | 1024x752 | H264 | 23.98fps 285kbps | AAC 128kbps | 587MB
Genre: eLearning
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.
I have taken some time to remaster all of the courses in MP4 format. I have not changed anything within the course content, simple made them more user friendly and watchable once again! It's amazing that 8 years later, we still use these languages today!
Course Contents
---------------------------------------------------------------------------
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)
Download
http://www.filesonic.com/file/2657019834/SQL.Video.Tutorials.part1.rar
http://www.filesonic.com/file/2657019854/SQL.Video.Tutorials.part2.rar
http://www.filesonic.com/file/2657019844/SQL.Video.Tutorials.part3.rar
http://www.filesonic.com/file/2657019874/SQL.Video.Tutorials.part4.rar
http://www.filesonic.com/file/2657019934/SQL.Video.Tutorials.part5.rar
http://www.filesonic.com/file/2657019864/SQL.Video.Tutorials.part6.rar
Mirror
http://www.filejungle.com/f/uCDdsh
http://www.filejungle.com/f/ykHhDT
http://www.filejungle.com/f/QT2aB6
http://www.filejungle.com/f/TqCJqM
http://www.filejungle.com/f/2dDTeq
http://www.filejungle.com/f/K6MFYg
