		Member Sign In 1-888-507-6283

		Auto Renew	Licenses	Time Remaining

1-888-507-6283

Microsoft SQL 2000 Fundamentals, Implementation, and Design 70-229

Exam-Pack 70-229

IT TRAINING
The 24-Hour Solution

Try it out,
24 hrs for $24

Prepare for an upcoming exam. Make corporate training decisions without risk. Access all of our IT training for 24 hours. Learn More

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.

Videos
Purchase Options

		Title	Duration
		Basic Database Concepts Training content; Basic Database Concepts	00:34:33
		An Introduction to Transact SQL Content of training; An Introduction to Transact SQL	00:45:57
		Beginning Transact SQL Training content; Beginning Transact SQL	00:27:45
		Intermediate Transact SQL Content of training; Intermediate Transact SQL	00:47:50
		An Introduction to SQL Server Training content; An Introduction to SQL Server	00:34:10
		Creating Databases Content of training; Creating Databases	00:47:29
		Creating Tables Training content; Creating Tables	00:39:23
		Introduction to Data Integrity Content of training; Introduction to Data Integrity	00:47:31
		Creating Views Training content; Creating Views	00:35:09
		Programming Concepts Content of training; Programming Concepts	00:40:29
		Creating Stored Procedures Training content; Creating Stored Procedures	00:33:07
		Creating Triggers Content of training; Creating Triggers	00:37:03
		Creating User Defined Functions Training content; Creating User Defined Functions	00:40:42
		Architecting Indexes Content of training; Architecting Indexes	00:26:29
		Creating Indexes Training content; Creating Indexes	00:25:21
		Creating Distributed Queries Content of training; Creating Distributed Queries	00:39:18
		Performance Analysis Training content; Performance Analysis	00:34:27
		Performance Considerations Content of training; Performance Considerations	00:25:43
		Managing Transactions and Locks Training content; Managing Transactions and Locks	00:25:10
		Implementing Security Content of training; Implementing Security	00:26:25

Total Series Duration: 11 hours

RELATED SERIES
Microsoft Programming Analyzing MCSD Requirements 70-300 Microsoft ISA Server 2000 Enterprise Edition 70-227 Microsoft Windows 2000 Network Infrastructure 70-216 Microsoft Windows 2000 Security 70-214 Microsoft Windows 2000 Professional 70-210 Microsoft Windows 2000 Security Design 70-220 Microsoft Programming Visual Basic 6.0 Distributed Applications Microsoft Messaging Exchange 2000 Administration 70-224

RELATED SERIES

Which option is right for you?

Buy a Single Series

"Focus your training on one series, for one month, for one low price."

StreamOne SUBSCRIPTION

Includes ExamPrep

StreamOne is your monthly option for streaming access to Microsoft SQL 2000 Fundamentals, Implementation, and Design 70-229. One multi-user license gives you and a small team access to one full series. Cancel at any time. A StreamOne subscription gives you plenty of time to explore the benefits of CBT Nuggets, while paying for just the specific series you want.

MULTI-USER

$199

per license

$499

Download

Download Microsoft SQL 2000 Fundamentals, Implementation, and Design 70-229.

$499

DVD

Have Microsoft SQL 2000 Fundamentals, Implementation, and Design 70-229 delivered on DVD.

Buy an Annual Subscription to Everything IT

"Eliminate your limitations. An IT Nuggets streaming subscription puts our complete IT training library at the fingertips of IT pros."

All topics. From admin to programming.

IT Nuggets

Productivity for Companies and IT Advancement for Professionals

Get access to better training, and never lose it, with an IT Nuggets subscription. IT Nuggets is a multi-user product that supports all levels of your IT department, even as employees come and go. One locked-in rate gets you access to our IT training catalog, which is updated regularly and automatically at no additional charge. As long as your subscription is maintained, the rate won't change, and neither will your budget. Our full IT library is designed for Pros to keep current for career advancement and companies that want their IT Pros to reach their full potential.

YEARLY
MULTI-USER

$1999

per license

Bookmarks

Microsoft SQL 2000 Fundamentals, Implementation, and Design 70-229

Exam-Pack 70-229

No Bookmarks