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

**abb** · #1 (**permalink**) 07-30-2007, 08:58 AM

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**) 05-26-2008, 03:03 PM

Thank you brother for sharing

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MySQL Books Collection - All you need to work with MySQL	japbd	Programing Book	0	08-04-2008 04:28 AM
Microsoft MSCE complete cert set VTC	abb	Video Training	1	01-07-2008 05:41 AM
MySQL Administrator's Guide	FED	Technical Book	0	09-25-2007 07:43 AM
Beginning PHP and MySQL 5: From Novice to Professional	abb	Programing Book	0	08-08-2007 09:26 AM
Expert MySQL	abb	Programing Book	0	05-23-2007 08:46 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)