|
Day
1
Module 1:
Microsoft SQL Server Overview
What is SQL Server?
SQL Server architecture
SQL Server components
Working with SQL Server
Module 2:
Transact-SQL Overview
SQL Server
programming tools
The Transact-SQL
programming language
Elements of Transact-SQL
Ways to execute
Transact-SQL statements
Day
2
Module 3:
Creating Databases
Introduction to databases
Working with databases
Modifying databases
Creating filegroups
Creating data types
Creating tables
Generating scripts
Module 4:
Implementing Data Integrity
Introduction to
data integrity
Using constraints
Using defaults and rules
Module 5:
Planning and Creating Indexes
Implementing indexes
Creating and
dropping indexes
Types of indexes
Characteristics of indexes
Indexing guidelines
Create Index options
Maintaining indexes
Day
3
Module 6:
Performing Advanced Queries
Using joins to
combine data from multiple tables
Manipulating a
result set
Using subqueries
Modifying data
with joins or subqueries
Querying a remote
SQL Server |
Module 7:
Summarizing Data
Using aggregate functions
Generating a
summary value for a column
Generating
aggregate values within result sets
Listing the top n values
Day
4
Module 8:
Managing Transactions and Locks
Introduction to
transactions and locks
Managing transactions
Managing locks
Managing
distributed transactions
Module 9:
Implementing Views
Views: an
alternate way to look at data
Advantages of views
Creating views
Altering views
Modifying data
through views
Day
5
Module 10:
Implementing Stored Procedures
Introduction to
stored procedures
Creating,
executing, and modifying stored procedures
Using parameters
in stored procedures
Handling error messages
Module 11:
Implementing Triggers
Introduction to triggers
Creating,
dropping, and altering triggers
Examples of triggers
|
Desktop Courses 
Implementing a Database in Microsoft SQL Server 7.0