Chapter 05.rar
Pobierz
Inne foldery z plikami do pobrania
-
●01 - highIMPACT -
01 Introduction -
02 Style Sheets -
03 Inheritance and Cascading -
05 Page Layout -
06 Nav Bars -
1800-PHP-Scripts-Web-Developers-Mega-Pack -
5000 Profesjonalnych czcionek -
700-Php-Scripts -
Asp.NET -
ASP.NET MVC -
Backtrack 5 r3 Premium -Update2 -
Bootstrip_templates -
C# -
CMS -
css -
Exercise Files -
Font's - Czcionki -
Hacking -
html css tutorials -
html5 -
HTML5 -
Ikony -
images -
Java Script -
Java Script jQuery tutorials -
jQuery -
js -
Lynda -
Microsoft Office Templates -
Microsoft Visual Studio KURS -
Nulled PHP SCRIPTS -
Old Paper - 01 -
PHP -
PHP & MySQL -
Programy -
PSD -
Różne -
Sciagawki dla Webmastera -
site -
Skrypty Generatorów HTML -
SQL -
SQLite 3 with PHP Essential Training -
sslstrip-0.9 -
Szablony Mobilnych Stron -
Template Monster 63 Skins -
tutorial -
Web -
WordPress 3 -
wysiwyg 10
| 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)
-----------------------------------------------------------
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)