Course
Number: IT123
MCSD Microsoft Certified Solution Developer
Module 5: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
- Introduction
to Transact-SQL\
- Using
Transact-SQL Querying Tools
- Retrieving
Data
- Grouping
and Summarizing Data
- Joining
Multiple Tables
- Working
with Sub queries
- Modifying
Data
- Querying
Full-Text Indexes
- Introduction to Programming Objects
- SQL
Server Overview
- Overview
of Programming SQL Server
- Creating
and Managing Databases
- Creating
Data Types and Tables
- Implementing
Data Integrity
- Planning
Indexes
- Creating
and Maintaining Indexes
- Implementing
Views
- Implementing
Stored Procedures
- Implementing
User-defined Functions
- Implementing
Triggers
- Programming
Across Multiple Servers
- Optimizing
Query Performance
- Analyzing
Queries
- Managing
Transactions and Locks
For more details, please contact our Technical Adviser at 503-725-2395 or email it@pdx.edu.
