Microsoft SQL Server 2000 Database Design MCSE 70-229 Training Online Course
SQL Server 2000 Database Design MCSE 70-229 Training Total Time: 21 hour(s)
This SQL Server 2000 Database Design MCSE 70-229 Training Online Course 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 Optimising 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.
| |
Try A Free Demo
|
Live Labs Available
|
24/7 Tutor Available
|
Need help? Click Here
|
| |
 |
 |
 |
 |
 |
SQL Server 2000 Database Design MCSE 70-229 Training Online Course Lessons:
1 Data Modeling and Database Creation
- Gather database requirements
- Build a logical data model
- Create and alter databases, files, and filegroups
- View and change database properties and options
|
Duration 4 hours |
2 Database Objects
- Create and alter database objects
- Create and alter tables
- Design and create constraints
- Alter database objects to support replication
|
Duration 2 hours |
3 Retrieving and Modifying Data
- 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
|
Duration 2 hours |
4 Indexes and Views
- Create various types of indexes
- Create and modify table views
- Modify table data through a view
- Partition data using views
|
Duration 3 hours |
5 Database Programming
- Create, modify, and execute stored procedures
- Create and modify triggers
- Create and execute user-defined functions
- Work with transactions, cursors, and locks
|
Duration 4 hours |
6 Remote Data Access and XML
- 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
|
Duration 2 hours |
7 Optimization and Security
- Configure Windows 2000 Server and SQL Server 2000
- Use SQL Profiler, Query Analyser, and other tools to monitor database activity
- Design a database security plan
|
Duration 2 hours |
8 Exam Preparation 1
- 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 Optimising data access
- Demonstrate familiarity with the concepts of designing a database security plan
|
Duration 1 hours |
9 Exam Preparation 2
- 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 Optimising data access
- Demonstrate familiarity with the concepts of designing a database security plan
|
Duration 1 hours |
|
Telephone: 0871 222 8790
Alternate Number: 01279 814 876
Fax: 01279 816 093
E-Mail: info@e-careers.co.uk
Address:
10 Riverside Business Park,
Stony Common Road,
Stansted Mountfitchet,
Essex,
CM24 8PL

|
|