4 hours

Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator

To provide students with a comprehensive overview of SQL Server 7.0 architecture and features

After this course the student should be able to:
1. Identify the principal design goals for SQL Server 7.0
2. Point out the core components and advanced features of SQL Server 7.0
3. List the operating systems compatible with SQL Server 7.0
4. Describe the SQL Server 7.0 Relational and Storage Engine
5. Overview the security architecture and Distributed Management Framework of SQL Server 7.0 6. outline Microsoft's Universal Data Access strategy

4 hours

An understanding of relational database theory

To provide students with an introduction to the Transact-SQL programming language

After this course the student should be able to:
1. Describe the SQL Server programming tools
2. Create basic Transact-SQL programs

4 hours

Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator

To provide a SQL Server database administrator or developer with the knowledge required to create and maintain SQL Server databases and tables

After this course the student should be able to:
1. Analyze the hardware and software requirements for a new SQL Server database
2. Create a SQL Server database
3. Compare the different database options
4. Distinguish between the different system-supplied datatypes
5. Create user-defined datatypes

4 hours

Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator

To explain how to create and maintain data integrity and to import and export SQL Server data from different sources

After this course the student should be able to:
1. Discuss data integrity
2. Choose between different data integrity enforcement methods
3. Implement data integrity using constraints, rules, and defaults
4. Choose between the different SQL Server data loading methods

4 hours

Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator

To explain how to create and manage table indexes and views

After this course the student should be able to:
1. Discuss how indexes improve query performance
2. Understand the difference between clustered and nonclustered indexes
3. Discuss how to manage and optimize indexes

3 hours

Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator

To explain how to create queries to retrieve data from multiple tables and to return summary data

After this course the student should be able to:
1. Explain the different join types
2. Determine the best method of querying data from multiple tables
3. Explain how to use subqueries
4. Create queries to retrieve data from multiple tables
5. Explain how to summarize data

4 hours

Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator

To enable the student to identify and use stored procedures and triggers

After this course the student should be able to:
1. Describe the use of triggers and stored procedures in implementing business rules
2. Choose between stored procedures and triggers
3. Compile a stored procedure
4. Define a trigger
5.

4 hours

Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator

To enable the student to understand the concept of a transaction and how to set up linked servers, access distributed data, and create distributed transactions

After this course the student should be able to:
1. Outline the concept of a transaction
2. Point out how to create and manage transactions
3. Determine the best locking option to use
4. Assess the locking level being used
5. Define the concept of distributed data 6. Understand the use of linked servers

5 hours

Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator

To enable students to monitor, maintain, tune, and troubleshoot SQL Server 7.0

After this course the student should be able to:
1. describe SQL Server 7.0's monitoring and tuning tools
2. discuss the principal factors that affect the performance of SQL Server 7.0 running on Windows NT
3. show how to use Performance Monitor and SQL Server Profiler to monitor SQL Server 7.0 performance
4. point out how to manage SQL Server user accounts and audit permissions
5. distinguish between using log files, T-SQL stored procedures, DBCC commands, and the Current Activity window to gather data and monitor performance
6. describe how to analyze queries using Query Analyzer and the SHOWPLAN options
7. show how to use the Index Tuning Wizard to tune SQL Server 7.0 queries and indexes
8. summarize how to use the sp_configure stored procedure to optimize SQL Server 7.0
performance 1. describe how to use the Database Maintenance Plan Wizard to establish and implement a regular maintenance plan