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

This is self-paced, internet-based course -- there are no books to purchase and no scheduled classes to attend.

Data Modeling and Database Creation provides an overview of data modeling with an emphasis on relational database systems, and shows users how to implement a logical design by creating a database in SQL Server 2000.
Database Objects shows users how to create and alter tables, define data types, and ensure integrity by implementing constraints.
Retrieving and Modifying Data shows users how to retrieve, filter, and modify data using Transact-SQL, and explains techniques for importing and exporting data in SQL Server 2000.
Indexes and Views explains the types of indexes and views available in SQL Server 2000, and shows how they can be used to enhance and control access to data.
Database Programming shows users how to create and use stored procedures, triggers, functions, user-defined functions (UDFs), transactions, cursors, and locks in database application programming.
Remote Data Access and XML explains techniques for accessing heterogeneous data using linked servers, ad hoc queries, and pass-through queries, and shows users how to retrieve and write data using XML.
Optimization and Security shows users the tools and techniques that can be used to monitor and optimize the performance of a SQL Server 2000 database, and how to design and implement a database security plan.
Exam Preparation provides practice questions with explanatory feedback for Microsoft Exam 70-229: "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition."

After completing our courses, the user should be able to:

Data modeling
Logical design
Components of the logical model
Entity relationships
Normalization
Data integrity and constraints
Physical design considerations
The SQL Server 2000 software
System files and tables
Database files and filegroups
Creating a database
Altering a database
Other database modifications
Useful functions and stored procedures
Creating and altering database objects
Tables and data types
Creating tables
Modifying and deleting tables
System-supplied data types
User-defined data types
Designing attribute integrity
Cascading referential integrity/disabling constraints
Replication and data types
Generating column values
Creating DEFAULT and RULE objects
Referring to a SQL Server object
Transact-SQL
System functions
Collation precedence
Using the SELECT statement
Clauses for the SELECT statement
Subqueries
Using the DELETE statement
Using the UPDATE statement
Using the INSERT statement
Bulk copy operations
Data Transformation Services
Types of indexes
Creating indexes
Using the Create Index Wizard
Analyzing index performance
Altering indexes
Using views
Guidelines for views
Creating views
Analyzing CREATE VIEW statements
Modifying a view
Using views to modify data
Creating partitioned views
Using indexed and XML views
Introduction to stored procedures
Guidelines for creating stored procedures
Creating stored procedures
Modifying stored procedures
Working with stored procedures
Error handling within stored procedures
Introduction to triggers
Creating triggers
Using INSTEAD OF triggers
Modifying triggers
Introduction to functions and UDFs
Scalar-valued and table-valued UDFs
System UDFs and functions
Obtaining information about UDFs
Transactions
Transaction isolation levels
Cursors
Locks
Linked servers
Ad hoc queries
Pass-through queries
XML and Internet Information Services (IIS)
The FOR XML clause
The OPENXML statement
Monitoring performance
Configuring Windows 2000 Server
Configuring SQL Server 2000
Using SQL Profiler
Analyzing performance
Login authentication
Permissions
Database user accounts
Roles
Authentication modes
The database security plan
Developing a logical data model
Implementing the physical database
Retrieving and modifying data
Programming business logic
Tuning and optimizing data access
Designing a database security plan

Our courses have special design features listed below:

Certificates of Completion
Instructional steps -- walk through a procedure
Exercises -- try it out
Notes - See additional information related to the topic in the text
Tips - See a different, faster, or easier way of doing something
Quick References - See a quick reference guide to the features introduced in a chapter
Details - Display more detailed information related to the current topic
Hotwords - See related information
Navigation Bar - Maneuver easily through the courses
Microsoft Approved Courseware Logo - to prepare you for a Microsoft certification
Course Topics and Index -- with searching feature and hyper-links
Printable Exercises - PDF downloadable files
Sample Application Files - PDF downloadable files
Course Glossary
Skill Assessment - can be used for pre and post-testing -- tracking first try, best try and course grade - if passed, green check mark will appear as 'mastered' - hyperlinks to units within the course to go back and re-take a certain unit again. Use as pre-test to determine which course topics you want to focus on and to go directly into that unit.

Technical Requirements

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Internet Explorer 5.0 or higher required. Minimum Connection Speed: 28.8k. Authorware recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Learning comes to life with challenging labs, critical assessment and real-world insight from experts with vast experience in the subject matter. Engage in dynamic learning where multiple senses help reinforce learning concepts. Our proven methodology provides an unequalled experience with exceptional results Learning that's Easy, Convenient and Affordable! High-quality, online, self-paced courses designed to help you achieve your goals. Affordable annual subscription plans give you unlimited access to an entire suite of topics at prices that you just won't find anywhere else.

Our courses are based on sound principles, from extensive research in instructional design, adult learning and information processing. All courses are design so that new knowledge and skills will be remembered and retrieved for future use. Each course include a 30-questions skill assessment, which evaluates your knowledge of the course material. You can be assured that this high-quality, instructionally-sound online product will enchance your professional and personal growth.

Sign up for our courses right now, and join the ranks of people who are taking financial advantage of the explosion in the Information Technology field.