SQL Server 2000 Database Design

The self-paced SQL Server 2000 Database Design certification training is exceptional. Our online SQL Server 2000 Database Design certification training course meet or exceed exam objectives, teaching precisely what you need to know.

FREE Online Courses

FREE Certification Exams

A+ Certification

Network+ Certification

Webmaster Certification

Java Certification
310-025

MCSE Training

MOUS Training

Windows 2000
Training Courses

Microsoft Office
Training Courses

Internet Explorer

Oracle
9i Training

Visual Basic

SQL Server

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

certification training course that's Easy, Convenient and Affordable! High-quality, online, self-paced certification training courses designed to help you achieve your goals. Affordable annual subscription plans give you unlimited access to an entire suite of courses topics at prices that you just won't find anywhere else.

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

This course has the following features:

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.

Bass Computer Services
Independent Technology Consultant