.
MICROSOFT SQL SERVER 2000
Database Design and Implementation
-----------------------------------------------------------------------
COURSE OUTLINE
1. Using Transact-SQL
a. SQL Server programming Tools
b. Introduction to Transact-SQL
c. Transact-SQL Syntax Elements
d. Executing Transact SQL statements
2. Designing SQL Server Database
a. Introduction to database Design
b. Planning a SQL server Database
c. Identifying system requirements
d. Developing a logical Model
3. Implementing SQL Server Database and Tables
a. Creating and managing a SQL server Database
b. Identifying data type
c. Creating and managing tables
4. Implementing Data integrity
a. Introduction to data integrity
b. Implementing integrity constraints
5. Accessing and modifying Data
a. Accessing data in a SQL server database
b. Using Advance Query techniques to Access Database
c. Modifying Data in a SQL server Database
6. Managing and manipulating Data
a. Importing and Exporting Data
b. Using Distributed Queries to Access External Data
c. Using Cursor to retrieve Data
d. Retrieving XML data
7. Implementing Stored procedures
a. Introduction to triggers
b. Creating and managing triggers
c. Programming triggers
8. Implementing Views
a. Introduction to views
b. Creating, modifying and Deleting Views
c. Accessing data through views
9. Implementing Indexes
a. Index Architecture
b. Index creation and Administration
10. Managing SQL server Transactions and Locks
a. Transaction and locking architecture
b. Managing SQL server transactions
c. Managing SQL server locking
11. Designing and Administering SQl server 2000 security
a. Overview of SQL server 2000 security
b. Designing a Database security plan
c. Database Security implementations
d. Database Security implementation and Administration
12. SQL server 2000 monitoring and tuning
a. Monitoring Database with SQL PROFILER
b. Index tuning and database partitioning
Prepared and delivered by
JOSE G. DE JESUS JR MCP,MCDBA
Mcp # 2324787
