Microsoft SQL Server 2000 Design, Implement
This series covers 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. Some background knowledge and hands-on experience with enterprise systems and relational databases is assumed.
This online course contains 9 lessons and should take approximately 21 hours to complete.
Data Modeling and Database Creation
This course 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 and teaches you how to gather database requirements, build a logical data model, create and alter databases, files, and filegroups, and view and change database properties and options.
Database Objects
This course shows users how to create and alter tables, define data types, and ensure integrity by implementing constraints and teaches you how to create and alter database objects, create and alter tables, design and create constraints, and alter database objects to support replication.
Retrieving and Modifying Data
This course shows users how to retrieve, filter, and modify data using Transact-SQL, and explains techniques for importing and exporting data in SQL Server 2000 and teaches you how to 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, and use the Transact-SQL BULK INSERT statement, the BCP utility, or Data Transformation Services (DTS) to import and export data.
Indexes and Views
This course 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 and teaches you how to create various types of indexes, create and modify table views, modify table data through a view, and partition data using views.
Database Programming
This course shows users how to create and use stored procedures, triggers, functions, user-defined functions (UDFs), transactions, cursors, and locks in database application programming and teaches you how to create, modify, and execute stored procedures, create and modify triggers, create and execute user-defined functions, and work with transactions, cursors, and locks.
Remote Data Access and XML
This course 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 and teaches you how to create a linked server, create ad hoc and pass-through queries, set up the SQL Server to return XML results, and request, retrieve, and parse XML data.
Optimization and Security
This course 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 and teaches you how to configure Windows 2000 Server and SQL Server 2000, use SQL Profiler, Query Analyzer, and other tools to monitor database activity, and design a database security plan.
Exam Preparation 1
This course provides practice questions with explanatory feedback for Microsoft Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition and teaches you how to 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, and demonstrate familiarity with the concepts of designing a database security plan.
Exam Preparation 2
This course provides practice questions with explanatory feedback for Microsoft Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition and teaches you how to 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, and demonstrate familiarity with the concepts of designing a database security plan.