Quantcast

Start with 7 free days of training.

Gain instant access to our entire IT training library, free for your first week.
Train anytime on your desktop, tablet, or mobile devices.

Exam-Pack 70-229

This course will be retired in 250 days. If you have questions, please contact us.

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....
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.
 show less
1. Basic Database Concepts (34 min)
2. An Introduction to Transact SQL (45 min)
3. Beginning Transact SQL (27 min)
4. Intermediate Transact SQL (47 min)
5. An Introduction to SQL Server (34 min)
6. Creating Databases (47 min)
7. Creating Tables (39 min)
8. Introduction to Data Integrity (47 min)
9. Creating Views (35 min)
10. Programming Concepts (40 min)
11. Creating Stored Procedures (33 min)
12. Creating Triggers (37 min)
13. Creating User Defined Functions (40 min)
14. Architecting Indexes (26 min)
15. Creating Indexes (25 min)
16. Creating Distributed Queries (39 min)
17. Performance Analysis (34 min)
18. Performance Considerations (25 min)
19. Managing Transactions and Locks (25 min)
20. Implementing Security (26 min)

Please help us improve by sharing your feedback on training courses and videos. For customer service questions, please contact our support team. The views expressed in comments reflect those of the author and not of CBT Nuggets. We reserve the right to remove comments that do not adhere to our community standards.

comments powered by Disqus
12 hrs 20 videos

Training Features


Practice Exams
These practice tests help you review your knowledge and prepare you for exams.

Virtual Lab
Use a virtual environment to reinforce what you are learning and get hands-on experience.

Offline Training
Our iOS and Android mobile apps offer the ability to download videos and train anytime, anywhere offline.

Accountability Coaching
Develop and maintain a study plan with one-to-one assistance from coaches.

Supplemental Files
Files/materials that supplement the video training.

Speed Control
Play videos at a faster or slower pace.

Bookmarks
Included in this course
Pick up where you left off watching a video.

Notes
Included in this course
Jot down information to refer back to at a later time.

Closed Captions
Follow what the trainers are saying with ease.