**NOTE** All Online Course Tutorials require Internet Explorer 5.0 or higher and the Macromedia Flash 4.0 or higher plugin installed as they will not work with AOL, Netscape or Mozilla browsers.**

Microsoft SQL Server 2000 Database Design MCSE 70-229 Online Course Tutorial Details

Total Lessons: 9
Total Time: 21 hour(s)
Subscription Term: 12 month(s)

Click Here to buy the 70-229 Online Course Tutorial Now!

Summary:

This series of courses serves as preparation for Microsoft Exam 70-229: "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition," which is one of several electives for the MCSE certification track, and a core requirement for MCDBA certification. Topics covered include developing a logical data model, implementing the database and objects, retrieving and modifying data using Transact-SQL and XML, using indexes and views, programming business logic (stored procedures, functions, views, triggers), tuning and optimizing data access, and designing a database security plan. This series is tightly focused on exam preparation and review, not on providing general knowledge. Some background knowledge and hands-on experience with enterprise systems and relational databases is assumed.

Features and Benefits of our Tutorial:
* Exercises that allow users to practice the application
* A file containing the text of the exercises
* Activities that allow users to apply course concepts in an interactive questioning environment
* Simulations that allow users to practice course skills, even if they don't have access to the application
* A glossary
* A Skill Assessment

Lesson 1 Data Modeling and Database Creation - 4 hours

Objectives: After completing this lesson, students will be able to:
* Gather database requirements
* Build a logical data model
* Create and alter databases, files, and filegroups
* View and change database properties and options

Lesson 2 Database Objects - 2 hours

Objectives: After completing this lesson, students will be able to:
* Create and alter database objects
* Create and alter tables
* Design and create constraints
* Alter database objects to support replication

Lesson 3 Retrieving and Modifying Data - 2 hours

Objectives: After completing this lesson, students will be able to:
* Use the Transact-SQL Data Manipulation Language statements SELECT, INSERT, UPDATE, and DELETE to retrieve and modify data
* Use SQL Server built-in functions, including CASE, CONVERT, and CAST
* Define a collation at the server, database, or column level
* Use the Transact-SQL BULK INSERT statement, the BCP utility, or Data Transformation Services (DTS) to import and export data

Lesson 4 Indexes and Views - 3 hours

Objectives: After completing this lesson, students will be able to:
* Create various types of indexes
* Create and modify table views
* Modify table data through a view
* Partition data using views

Lesson 5 Database Programming - 2 hours

Objectives: After completing this lesson, students will be able to:
* Create, modify, and execute stored procedures
* Create and modify triggers
* Create and execute user-defined functions
* Work with transactions, cursors, and locks

Lesson 6 Remote Data Access and XML - 2 hours

Objectives: After completing this lesson, students will be able to:
* Create a linked server
* Create ad hoc and pass-through queries
* Set up the SQL Server to return XML results
* Request, retrieve, and parse XML data

Lesson 7 Optimization and Security - 2 hours

Objectives: After completing this lesson, students will be able to:
* Configure Windows 2000 Server and SQL Server 2000
* Use SQL Profiler, Query Analyzer, and other tools to monitor database activity
* Design a database security plan

Lesson 8 Exam Preparation 1 - 1 hour

Objectives: After completing this lesson, students will be able to:
* Demonstrate familiarity with the concepts of developing a logical data model
* Demonstrate familiarity with the concepts of implementing the physical database
* Demonstrate familiarity with the concepts of retrieving and modifying data
* Demonstrate familiarity with the concepts of programming business logic
* Demonstrate familiarity with the concepts of tuning and optimizing data access
* Demonstrate familiarity with the concepts of designing a database security plan

Lesson 9 Exam Preparation 2 - 1 hour

Objectives: After completing this lesson, students will be able to:
*Practice for and evaluate thier current skill level for the SQL Server 2000 Database Design 70-229 Exam