MYSQL VTC Tutorials

Getting Started
Welcome (01:20)
What You Will Need (07:24)

Database Basics
What Is A Database? (03:28)
RDBMSs (05:09)
Tables and Data Pt 1 (05:59)
Tables and Data Pt 2 (05:55)

SQL Basics
Finding Your Way About (05:55)
Creating a Database (02:34)
Creating a Table (04:38)
Column Types-String Pt 1 (05:16)
Column Types-String Pt 2 (04:44)
Column Types-Numeric Pt 1 (08:23)
Column Types-Numeric Pt 2 (06:55)
Retrieving Data With Search Criteria (05:34)
Changing Existing Data (04:35)
Altering A Table (05:53)
Keys And Indexes (05:31)
Basics Syntax Recap (04:24)

Operators in MySQL
Arithmetic Operators (05:03)
Numeric Comparison Operators (08:07)
String Comparison Operators (05:34)
Logical Operators (08:48)
Bitwise Operators (07:21)
Regular Expressions 1 (08:41)
Regular Expressions 2 Pt 1 (06:38)
Regular Expressions 2 Pt 2 (05:10)
Operators Syntax Recap (04:53)

Querying Your Data
Sorting Retrieved Data (03:37)
Specifying Numbers of Results (03:05)
Joining Tables Pt 1 (05:25)
Joining Tables Pt 2 (03:37)
More On Joining Tables (07:55)
Data Aggregation (08:05)
Queries Syntax Recap (03:00)

More Complex SQL
Using Default Data (08:09)
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:49)
SET column type Pt 1 (06:51)
SET column type Pt 2 (05:28)
Using Variables (03:12)
Conditional: IF() (05:25)
Complex Syntax Recap (03:18)

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:11)
Normalization Pt 2 (03:56)
Optimizations (13:32)

Security
Users And Privileges (07:31)
More About Users And Privileges (08:08)
The mysql Database Pt 1 (04:37)
The mysql Database Pt 2 (04:16)
Encryption (05:43)
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:49)
Creating The Database Pt 1 (06:25)
Creating The Database Pt 2 (04:33)
Logging In And Out (06:38)
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:51)
Hiring And Firing Employees Pt 1 (04:45)
Hiring And Firing Employees Pt 2 (04:28)
Listing Debtors (08:03)

download:

password=tactools.org

http://rapidshare.com/files/229460050/MYSQL_VTC_Tutorials.rar

VTC Microsoft SQL Server 2005 Administration Tutorials

VTC Microsoft SQL Server 2005 Administration Tutorials | 166 MB

SQL Server 2005 is Microsoft's latest release of their enterprise database solution product. SQL Server 2005 is the result of five years of research, development and collection of suggestions and wish lists from database administrators and developers. Microsoft continues to drive the enterprise database market with the added features and capabilities of this new product. Microsoft Certified Database Administrator and Certified Trainer Mark Long covers the basics of SQL Server 2005 administration in this course. To begin learning simply click the links.
Download from HotFile
01 | 02 | 03

Download from FileFactory
01 | 02 | 03

SQL tutorial video by Microsoft certified Systems Engineer

SQL tutorial video
13 MB + 95 MB

This Transact SQL tutorial video is instructed by Microsoft certified Systems Engineer and Database administrator Mark Long. In this tutorial, you will not only learn about this data definition, manipulation, and control language, but you will also become better prepared for the MCDBA certification. It will also help you become a better Database Administrator.
Mark Long begins by introducing you to the origins and capabilities of Transact SQL. He will give a brief history of databases and will cover some language basics, including scripts, batches, functions, and views. From there, he moves onto more advanced ideas by teaching you about TSQL tools, such as the Query Analyzer and the Enterprise Manager. He then goes into great depth explaining the 4 main commands: SELECT, INSERT, UPDATE, and DELETE. You will also learn about indexes, variables, and stored procedures.
To allow you to evaluate the quality of these Microsoft Transact SQL training videos we have made the first 8 chapters of this tutorial available for free viewing online.
Links:
Download part1
Download part2