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 students to successfully install SQL Server 7.0

After this course the student should be able to:
1. Explain how to plan a successful installation of SQL Server 7.0
2. Outline the hardware, software, and network requirements for installing SQL Server 7.0
3. Describe the structure and layout of the SQL Server 7.0 setup program
4. Detail the setup options available when installing SQL Server 7.0
5. Demonstrate how to install SQL Server 7.0 6. Outline how to perform an unattended and a remote installation of SQL Server 7.0 7. Explain how to uninstall SQL Server 7.0 8. Show how to verify a SQL Server 7.0 installation

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 students to successfully upgrade SQL Server databases from version 6.x and earlier to version 7.0, and to describe how to migrate data from third-party RDBMS platforms to SQL Server 7.0

After this course the student should be able to:
1. Explain how to plan an upgrade from SQL Server 6.5 to version 7.0
2. Describe the various upgrade scenarios and choose the appropriate approach for a particular topology
3. Show how to perform a side-by-side upgrade from SQL Server 6.5 to SQL Server 7.0
4. Summarize the required post-upgrade activities
5. Point out how to plan a migration from Access, Oracle, and Sybase systems to SQL Server 7.0 and identify potential issues and pitfalls

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 show students how to perform basic administrative tasks using SQL Server 7.0

After this course the student should be able to:
1. Describe the post-installation system environment
2. Introduce the Microsoft Management Console and the Enterprise Manager administration interface
3. Identify the Enterprise Manager taskpads and wizards for administering SQL Server 7.0
4. Show how to register a server using Enterprise Manager
5. Outline how to configure clients and network protocols
6. Point out how to configure SQL Server Agent, SQL Server Mail, and SQL Server Agent Mail
7. summarize how to enable, create, and manage an index supporting Full-Text Search

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 students to determine and configure an appropriate backup strategy and prevent data loss using SQL Server 7.0

After this course the student should be able to:
1. Discuss SQL Server 7.0's data availability solutions
2. Identify the SQL Server 7.0 tools, utilities, and strategies for importing, exporting, and distributing data and preventing data loss
3. Explain how backups work in SQL Server 7.0
4. Choose the appropriate backup strategy for specific scenarios
5. Show how to create a backup device
6. Describe and show how to perform a full, differential, transaction log, and file/filegroup backup

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 enable students to restore and manage SQL Server 7.0 data

After this course the student should be able to:
1. Detail the data recovery process in SQL Server 7.0
2. Show how to perform a full, differential, transaction log, and file/filegroup restore
3. Explain how to restore the master and other system databases
4. Describe how to set up a standby server
5. Troubleshoot and resolve some common problems with the backup and restore process
6. Show how to create a linked server and configure secure login mappings between linked servers

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 show students how to automate the administration of SQL Server 7.0 and configure web publishing

After this course the student should be able to:
1. Distinguish between the key automation components in SQL Server 7.0
2. Show how to create, schedule, and manage jobs
3. Describe how to define operators and set alerts
4. Identify the multiserver administration components
5. Point out how to create and manage multiserver jobs
6. Outline how to resolve some job, operator, and alert failures
7. Discuss the Internet access options for SQL Server 7.0

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 students to effectively employ and administer security in SQL Server 7.0

After this course the student should be able to:
1. Identify the principal components and concepts in SQL Server 7.0's security architecture
2. Explain SQL Server 7.0's authentication methods and security modes
3. Show how to create and manage logins
4. Describe how to assign database access to NT and SQL Server accounts
5. Outline how to assign logins to fixed server and fixed database roles
6. Point out how to create and manage custom roles
7. List the three types of permission in SQL Server 7.0
8. Describe how to assign statement and object permissions to users, groups, and roles
9. Discuss how to implement application-level security using views, stored procedures, application roles, and MTS roles

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 students to successfully configure, implement, and troubleshoot replication with SQL Server 7.0

After this course the student should be able to:
1. Explain what replication is and identify the types available with SQL Server 7.0
2. Identify SQL Server 7.0's replication tools and components
3. Detail how merge, snapshot, and transactional replication work
4. Describe the replication strategies that can be catered for using SQL Server 7.0
5. Point out some of the planning issues concerning SQL Server 7.0 replication
6. Demonstrate how to configure a publisher
7. Show how to configure, implement, and verify merge, snapshot, and transactional replication