|
|
|
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 (Hotline Available NOW 24 hours a day, 7 days a week!)
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
|
|
|
