Welcome to MS SQL Server 2012: Enterprise Issues and Business Rules, the third course in the SQL Server 2000 Database Implementation Certification Series.
This series is designed to:
Provide the technical skills required to implement a database solution on Microsofts SQL Server 2000
Help you prepare for the Microsofts 70-029 Exam, Designing and Implementing Databases with Microsoft SQL Server 2000
After completing the course, you will be able to:
Access data by using the stored procedure model
Create Transact-SQL scripts that incorporate control of flow methods, local and global variables, functions, and error handling techniques
Create and execute stored procedures to enforce business rules, modify data in multiple tables, perform calculations, and use input and output parameters
Create triggers that implement rules, enforce data integrity, and perform cascading updates and cascading deletes
Configure session-level settings
Assess data from static or dynamic sources by using remote stored procedures, linked servers, and
Populate the database with data from an external data source using a bulk copy program and Data Transformation Services (DTS)
Evaluate and optimize the performance of an execution plan by using
Diagnose and resolve locking problems
Identify SQL Server events and performance problems by using SQL Server Profiler
As you probably know, you can interact with SQL Server in two ways:
by issuing Transact-SQL commands and
by interacting with its GUI, or
graphical user interface.
This course uses SlideShow and MouseOvers to explain the code syntax used in Transact-SQL commands, and simulations for practicing different elements of the SQL Server GUI.
MS SQL Server 2000: Enterprise Issues and Business Rules
is the third of three courses in the
SQL Server 2000 Database Implementation Certification Series
In the next lesson, prerequisites for this course will be discussed.