IT Training Spacer Image
Free IT Training
Free Training Demo
Forces ELCAS
Forces ELCAS Resettlement Training Courses
Basic/ Office Courses
View Basic & Office Training
CompTIA Courses
View CompTIA Training Courses
Microsoft Courses
View Technical Microsoft Training Courses
Cisco Courses
View Cisco Training Courses
Web Design Courses
View Web Design Training Courses
Other IT Courses
View all other IT Training Courses
IT Pay & Jobs
Jobs and Career Search
 

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
 
Buy SQL Server 2000 Database Design Training Free IT Training Demo Live Labs Tutor Support Contact e-careers computer training


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

 

First Name

* Required
Last Name

* Required
Home / Work Phone

* Required
Home / Mobile Phone

* Required
Email

* Required
Comments
   
 
 

 

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

Career Training Helpline

 

 

 

Bottom IT Training Spacer
Bottom Spacer for Career Training home page