VTC-MySQL TrainingVideos-MOST WANTED Duration:8hrs/71lessons

**abb** · (#1 (**permalink**))

VTC-MySQL TrainingVideos-MOST WANTED Duration:8hrs/71lessons

Title: MySQL
Author: Joshua Mostafa
SKU: 33364
ISBN: 1930519745
Release Date: 2002-07-25
Price: Single User: US$ 99.95
Multi User(10): US$ 500.00
Duration: 8 hrs / 71 lessons
Compatibility: Win Vista, XP, 2000, 98SE, Mac OS X, OS 9, Linux
Work Files: Yes

- Quick and easy way to learn through a series of movies.
- No expensive classroom training courses.
- No boring hard to follow books to read.
- Learn from your own desk at a pace that suits you.
- High quality affordable training that is easy to use and follow.
- Use our unique training method, it makes learning easy no matter what your learning style.

Chapters:
1 - Getting Started
2 - Database Basics
3 - SQL Basics
4 - Operators in MySQL
5 - Querying Your Data
6 - More Complex SQL
7 - Good Practises
8 - Security
9 - Building a Database Application

*********************CONTENTS********************* ********

Getting Started
Welcome (01:19)
What You Will Need (07:24)
Database Basics
What Is A Database? (03:2

RDBMSs (05:0

Tables and Data Pt 1 (05:5

Tables and Data Pt 2 (05:54)
SQL Basics
Finding Your Way About (05:55)
Creating a Database (02:33)
Creating a Table (04:3

Column Types-String Pt 1 (05:15)
Column Types-String Pt 2 (04:44)
Column Types-Numeric Pt 1 (08:23)
Column Types-Numeric Pt 2 (06:54)
Retrieving Data With Search Criteria (05:34)
Changing Existing Data (04:34)
Altering A Table (05:53)
Keys And Indexes (05:31)
Basics Syntax Recap (04:23)
Operators in MySQL
Arithmetic Operators (05:03)
Numeric Comparison Operators (08:07)
String Comparison Operators (05:34)
Logical Operators (08:4

Bitwise Operators (07:21)
Regular Expressions 1 (08:40)
Regular Expressions 2 Pt 1 (06:3

Regular Expressions 2 Pt 2 (05:09)
Operators Syntax Recap (04:52)
Querying Your Data
Sorting Retrieved Data (03:37)
Specifying Numbers of Results (03:04)
Joining Tables Pt 1 (05:24)
Joining Tables Pt 2 (03:36)
More On Joining Tables (07:54)
Data Aggregation (08:04)
Queries Syntax Recap (02:59)
More Complex SQL
Using Default Data (08:0

Date And Time 1 Pt 1 (05:16)
Date And Time 1 Pt 2 (04:02)
Date And Time 2 (04:54)
ENUM column type (06:4

SET column type Pt 1 (06:51)
SET column type Pt 2 (05:2

Using Variables (03:12)
Conditional: IF() (05:24)
Complex Syntax Recap (03:17)
Good Practices
Using SQL batch files Pt 1 (05:14)
Using SQL batch files Pt 2 (04:41)
Data Modeling Pt 1 (05:17)
Data Modeling Pt 2 (05:55)
Normalization Pt 1 (05:10)
Normalization Pt 2 (03:55)
Optimizations (13:31)
Security
Users And Privileges (07:30)
More About Users And Privileges (08:0

The mysql Database Pt 1 (04:36)
The mysql Database Pt 2 (04:16)
Encryption (05:42)
Security Syntax Recap (03:25)
Building A Database Application
Planning The Structure (07:12)
Designing The Database Pt 1 (05:33)
Designing The Database Pt 2 (04:4

Creating The Database Pt 1 (06:24)
Creating The Database Pt 2 (04:33)
Logging In And Out (06:3

Checking Videos In And Out Pt 1 (05:59)
Checking Videos In And Out Pt 2 (07:06)
Searching For A Video (06:26)
Adding A New Title (08:05)
Signing Up A New Customer (03:50)
Hiring And Firing Employees Pt 1 (04:45)
Hiring And Firing Employees Pt 2 (04:2

Listing Debtors (08:03)

LINK:

Code: http://rapidshare.com/files/41900296/VTC_-_MySQL.zip

moreanand · (#2 (**permalink**))

Thank you brother for sharing