SQL server 2000 tutorial - Courses UK

Affordable Online Computer Courses



CCNP Training Pack CCNA Training Pack Cisco Training Pack COMPTIA Certification .NET Training Microsoft MCSE 2003 Microsoft MCSA 2003 Microsoft MCAD Microsoft MCDBA Microsoft MCSD MCDST Training Microsoft Office XP Microsoft Office 2003

Applicability:

This course is for anyone preparing for Microsoft Exam 70-229: "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition."

Get Certified!
Once you've completed your course, simply book the certification test online with Prometric.com, they have over 3,500 testing centres worldwide, they are also the provider for many of the most sought after professional qualifications, including: MCSE, CompTIA A+ and Cisco CCNA.

"Realistic Simulations"
So you can see how SQL Server 2000 really works. All Courses also include pre and post-test which identifies individual strengths and weaknesses, allowing you to take only the units you haven't mastered and test how well you've mastered the completed Module.


		The Instant Mentoring window appears directly within your courses. Instant Mentoring allows you to type a question and receive a immediate response from a subject matter expert available 24/7 to help you succeed! MORE...

SQL Server 2000 Database Design 70-229 Training




Try a Demo

Usual Price
£~~245~~

Our Price
12 Months Access:
UK:£149
US:$261
Eur:€219


	65%

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. Certification: SQL Server 2000 Database Design MCSE 70-229

EASY.....start your online training course within the hour
Available 24 hrs/day 7 days/week
High quality Web-based Training / e-Learning
Train ALL YEAR for 1 low price


	Click the "Sign up Button" (above) to sign up for 12 months access to this course or buy our MCDBA Value Pack (this Course plus 8 other courses), if bought separately £~~1,192~~ Value Pack price: Only £299! Save £893 MORE...

SQL Server 2000 Database Design 70-229 Modules Outline:

SQL Server 2000 Database Design MCSE 70-229- 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

SQL Server 2000 Database Design MCSE 70-229- Database Objects

Create and alter database objects
Create and alter tables

Design and create constraints
Alter database objects to support replication

SQL Server 2000 Database Design MCSE 70-229- 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

SQL Server 2000 Database Design MCSE 70-229- Indexes and Views

Create various types of indexes
Create and modify table views

Modify table data through a view
Partition data using views

SQL Server 2000 Database Design MCSE 70-229- Database Programming

Create, modify, and execute stored procedures
Create and modify triggers

Create and execute user-defined functions
Work with transactions, cursors, and locks

SQL Server 2000 Database Design MCSE 70-229- 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

SQL Server 2000 Database Design MCSE 70-229- Optimization and Security

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

SQL Server 2000 Database Design MCSE 70-229- 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 optimizing data access
Demonstrate familiarity with the concepts of designing a database security plan

SQL Server 2000 Database Design MCSE 70-229- 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 optimizing data access
Demonstrate familiarity with the concepts of designing a database security plan

Training Tutorials - e-Learning - Distance Learning - Self paced - Courses