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

This is self-paced, internet-based sql server tutorial -- 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.
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.
Indexes and Views explains the types of indexes and views available in SQL Server, 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 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 SQL Server 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 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
Using 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
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.

All courses are included in "Tech MCSE Pack"

All courses are design so that new knowledge and skills will be remembered and retrieved for future use. You can be assured that this high-quality, instructionally-sound online product will enchance your professional and personal growth and stimulate job satisfaction.