The SQL Fundamentals/SQL Implementation and Design Combo Package is designed to help you learn and prepare for Microsoft Exam 70-229. Tshis exam combined with 70-215, 70-216 and 70-228 make up the Microsoft Certified Database Administrator (MCDBA) certification.

SQL Implementation and Design covers writing queries, using the Transact SQL language, creating programming objects, programming across multiple servers, designing applications, joining multiple tables, using sub queries, creating data types, implementing data integrity, creating indexes and traps and managing transactions and locks.

If this sounds like a lot, it is. We want to give you a complete education on the intricacies of SQL programming. This isn't just "text book" knowledge, there are real world analogies to help you understand the content, not just memorize it.

Instructor Jeff Abbott's enthusiastic approach to teaching database design is wonderfully refreshing. As always, he's managed to take complex tasks and break them down into easy to understand "nuggets" of information.

Basic computer network and database knowledge, such as the A+/Network+ combo package and SQL 2000 Administration video series are recommended before beginning this video series. We've included our SQL Fundamentals videos in this combo pack to give you a primer or a quick refresher to SQL Server and Transact SQL.

The SQL Fundamentals/SQL Implementation and Design video series provides more than 10 hours of training containing a total of 20 videos. Each 25-35 minute video segment covers a specific task. The content contained in this course is the equivalent of more than a week of classroom instruction.
Download

Thank you!