Course
Number: IT123A
MCAD MICROSOFT CERTIFIED APPLICATION DEVELOPER
Module
3: 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.
