 |
Explain the features and limitations of SQL Server 7.0
|
|
Assess
the potential impact of the logical design on performance, maintainability,
extensibility, scalability, availability and security
|
|
Access data using the stored procedure model
|
|
Access
information using SQL in relational databases
|
|
Create
tables that enforce data integrity and referential integrity
|
|
Access
data by using the dynamic SQL model
|
|
Populate
the SQL Server database with data from an external source
|
|
Create Indexes and Views
|
|
Create and manipulate scripts using Transact-SQL
|
|
Create and execute stored procedures
|
|
Maintain
efficient databases
|
|
Module
1.
|
Overview
of SQL Server 7.0
|
|
Module
2.
|
Modeling
a database
|
|
Module
3.
|
System
Databases and Tables
|
|
Module
4.
|
Creating
Databases and Tables
|
|
Module
5.
|
Querying
data
|
|
Module
6.
|
Advanced
queries
|
|
Module
7.
|
Maintaining
data in databases
|
|
Module
8.
|
Indexing
|
|
Module
9.
|
Views
|
|
Module
10.
|
Basics of Transact-SQL programming
|
|
Module
11.
|
Stored Procedures and Transactions
|
|
Module
12.
|
Triggers
|
|
Module
13.
|
Database Maintenance
|
|
Module
14.
|
Practice
Test (contains sample questions for you to prepare for the Microsoft certification
examinations)
|
|
Module
15.
|
Course Summary (contains the complete glossary and the summary of the course)
|
|
Module
16.
|
Advanced features of SQL Server 2000
|
|
Module 17.
|
Q & A
|
