Microsoft 70-229: SQL Fundamentals/ SQL 2000 Implementation/Design

Exam-Pack 70-229

Not rated 2 Reviews
Trainer: Jeff Abbott | Videos: 20 | Time: 11 hrs
Microsoft has retired the 70-229 exam. However, the information in this exam-pack remains relevant to the needs of those administering Server 2000 and Server 2008 technologies.

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.

All trademarks and copyrights are the property of their respective holders.

Buy/Subscribe

An Introduction to SQL Server

Prerequisites

CompTIA A+, Network+ and SQL Fundamentals/SQL 2000 Admin are recommended prerequisites.

Course Materials

What You'll Learn

  • Video 1: Basic Database Concepts|34:33

  • Video 2: An Introduction to Transact SQL|45:57

  • Video 3: Beginning Transact SQL|27:45

  • Video 4: Intermediate Transact SQL|47:50

  • Video 5: An Introduction to SQL Server|34:10

  • Video 6: Creating Databases|47:29

  • Video 7: Creating Tables|39:23

  • Video 8: Introduction to Data Integrity|47:31

  • Video 9: Creating Views|35:09

  • Video 10: Programming Concepts|40:29

  • Video 11: Creating Stored Procedures|33:07

  • Video 12: Creating Triggers|37:03

  • Video 13: Creating User Defined Functions|40:42

  • Video 14: Architecting Indexes|26:29

  • Video 15: Creating Indexes|25:21

  • Video 16: Creating Distributed Queries|39:18

  • Video 17: Performance Analysis|34:27

  • Video 18: Performance Considerations|25:43

  • Video 19: Managing Transactions and Locks|25:10

  • Video 20: Implementing Security|26:25

Member Reviews

View All Reviews

  • Anonymous

    I just wanted to say how great your products have been. I have used the SQL Server materials and am working with the VB.NET stuff when I have time. The content and quality have been excellent and the casual style of the instructors makes the whole experience very personal and effective.

  • Anonymous

    I received my first CD-ROM on SQL Fundamentals and programming. These courses are GREAT! I have Oracle 9i on my laptop and after viewing the first set of course I was writing SQL in the SQL Work Sheet by the afternoon. It sure was great to be able to go back and review portions of the video any time I wanted.

Related Series

Related Certifications

All trademarks and copyrights are the property of their respective holders.