Microsoft SQL Server 7 Admin, Config, Install - Online Course

This series is designed to help users understand a comprehensive array of topics, including planning a security strategy, SQL Server 7.0 system requirements, planning for system migration and replication, and server installation. System configuration, management of security, accounts, permissions, and the database, and backup and restores are also covered. Additional topics covered include the management of a variety of tasks, including replication, server jobs, events, alerts, linked servers, and remote servers; monitoring events, system optimization, and tuning resource usage. Server repair and troubleshooting strategies are also discussed.

This series is for database administrators who want to learn how to administer SQL Server 7.0. This online course contains 19 lessons and should take approximately 60 hours to complete.

Lesson 1: Security Strategy (3.0) hours

Security Strategy teaches you how to assess whether to use Microsoft Windows NT or Microsoft SQL Server accounts, decide whether to use the Windows NT group structure for a SQL Server 7.0 installation, plan the use and structure of SQL Server roles, assess whether to map Windows NT groups directly into a database or use SQL Server logins, choose which NT accounts will be used to run SQL Server services, plan an n-tier application security strategy and determine whether to use application roles or other mid-tier security mechanisms such as Microsoft Transaction Server, and plan the security requirements for linked databases. This course shows users how to plan the security policies for a SQL Server 7 installation. Topics include SQL Server Authentication Methods, Using Windows NT Groups, Planning the Use of SQL Server Roles, Developing a Security Strategy, and Other Security Issues.

Lesson 2: System Requirements (3.0) hours

System Requirements teaches you how to plan the physical placement of files, including data files and log files, plan the use of filegroups, plan for growth over time, plan the physical hardware system, assess the server's communication requirements, choose the appropriate backup and restore strategies, assess whether to use a standby server, and assess whether to use clustering. This course shows users how to prepare for the hardware needs of a SQL Server 7.0 installation. Topics include Data File Placement and Space, Capacity Planning, Communication and Backup Strategies, and Data Availability.

Lesson 3: Migration Planning (3.0) hours

Migration Planning teaches you how to plan an upgrade from a previous version of Microsoft SQL Server, plan the migration of data from other data sources, determine hardware and software requirements for migration, use the Upgrade Wizard, and use the Import Wizard. This course shows users how to migrate data from other sources into a SQL Server 7.0 installation. Topics include Planning an Upgrade, Upgrade Method and Upgrade Wizard, Migration Issues, Migrating Data from Other Sources, and Using the Import Wizard.

Lesson 4: Replication Plans (3.0) hours

Replication Plans teaches you how to design an appropriate replication model, choose a replication type, select an appropriate subscription model and type, and evaluate data type requirements. This course shows users how to develop a strategy for system replication. Topics include Choosing a Replication Model, Additional Options, Choosing a Replication Type, Designing and Planning Replication, and Data Definition Considerations.

Lesson 5: Installing the Server (4.0) hours

Installing the Server teaches you how to install the SQL Server 7.0 prerequisites, install the SQL Server 7.0 Database Server component, choose an appropriate character set, Unicode collation sequence, and sort order, install network libraries and protocols, install the SQL Server 7.0 services and the appropriate startup options, and install and configure the SQL Server 7.0 client software on client machines. This course shows users how to go through the installation process for servers and clients. Topics include Installation Prerequisites, Installing Components, Choosing Database Options, Installing Network Libraries and Protocols, and Installing Services and Clients.

Lesson 6: Other Installations (2.0) hours

Other Installations teaches you how to perform an unattended installation and uninstallation of Microsoft SQL Server 7.0, prepare for upgrading a SQL Server system, use the Upgrade Wizard to upgrade operations from SQL Server 6.x to SQL Server 7.0, and validate and verify the upgrade of the system. This course shows users how to perform unattended setups or upgrade from a previous version of SQL Server. Topics include Performing an Unattended Setup, Preparing for a Version 6.x Upgrade, Running the SQL Server Upgrade Wizard, and Completing the Upgrade.

Lesson 7: Configuring (3.0) hours

Configuring teaches you how to register a server with a SQL Server network, configure Microsoft SQL Server 7, including installing and configuring SQL Mail, and configuring the default ANSI settings, and install and configure the Full-Text Search service, including enabling Full-Text Search on specific columns and tables, and creating and managing indexes to support Full-Text Search. This course shows users how to configure SQL server and its services. Topics include Using the Register Server Wizard, Configuring the Server, Configuring SQL Mail and ANSI Settings, Installing the Full-Text Search Service, and Configuring the Full-Text Search Service.

Lesson 8: Security Management (3.0) hours

Security Management teaches you how to assign SQL Server access through Windows NT accounts, SQL Server logins, and built-in administrator logins, assign database access to Windows NT accounts, SQL Server login accounts, the Guest account, and the DBO user account, and create and assign SQL Server roles. This course shows users how to assign access and roles to server users and databases. Topics include Overview of SQL Server Security, Security Modes, Creating and Managing Logins, Database User IDs and Roles, and Using the Create Login Wizard.

Lesson 9: Managing Accounts (2.0) hours

Managing Accounts teaches you how to create and assign SQL server roles, and manage login IDs and database User IDs. This course shows users how to administer login IDs, Database IDs, and roles. Topics include Viewing ID Information, Viewing Roles, Managing Login IDs, Managing Database IDs and Roles, and Server Roles and Management Procedures.

Lesson 10: Managing Permissions (4.0) hours

Managing Permissions teaches you how to grant to database users and roles the appropriate permissions on database objects and statements, and audit server and database activity. This course shows users how to administer permissions and monitor server and database activity. Topics include Permissions, Permission Management Tools, Displaying Permissions Information, Granting and Revoking Permissions, and Auditing Server and Database Activity.

Lesson 11: Database Management (3.0) hours

Database Management teaches you how to create and manage databases, create data files, filegroups, and transaction log files, specify growth characteristics, manage database size, set database options, document and script a database, set up a database maintenance plan, and delete a database. This course shows users how to create and maintain SQL server databases. Topics include Creating a Database, Managing Database Size, Database Options and Scripts, and Managing and Deleting Databases.

Lesson 12: Loading Databases (3.0) hours

Loading Databases teaches you how to load data using the INSERT statement, load data using the SELECT INTO statement, load data using the BCP Utility, load data using the Data Transformation Services (DTS), and load data using the BULK INSERT command. This course shows users how to load data from other sources into SQL Server databases. Topics include The INSERT and SELECT INTO Statements, Bulk Copying Data, Importing and Exporting Data with DTS, and Managing DTS Packages.

Lesson 13: Backups and Restores (4.0) hours

Backups and Restores teaches you how to back up system databases and user databases, and restore system databases and user databases. This course shows users how to back up and restore data on SQL Servers. Topics include Introduction to Backups, Database Backups, Differential Backups, Transaction Log Backups, Filegroup Backups, and Backing Up System Databases.

Lesson 14: Managing Replication (3.0) hours

Managing Replication teaches you how to configure servers, including distributors, publishers, and subscribers, and create publications. This course shows users how to create and administer database replication. Topics include Using Replication, Configuring Servers, Creating Publications, and Subscribing to Publications.

Lesson 15: Management Tasks (3.0) hours

Management Tasks teaches you how to automate administrative tasks, configure SQL Server Agent, define jobs and create multiserver jobs, define operators and alerts, set up SQLAgentMail for job notification and alerts, set up linked servers, and set up security for linked databases. This course shows users how to manage a variety of administrative tasks, including server jobs, events, alerts, linked servers, and remote servers. Topics include Configuring the SQL Server Agent, Implementing Jobs, Multiserver Jobs, Managing Server Events, and Linked Servers.

Lesson 16: Monitoring Events (3.0) hours

Monitoring Events teaches you how to monitor SQL Server engine event performance, explain tracing and trace architecture, create traces using the Create Trace Wizard SQL Server Profiler and extended stored procedures, run and save traces, and modify and replay traces. This course shows users how to monitor and trace engine events. Topics include Introduction to Monitoring, Understanding Trace Architecture, Creating Traces with the Trace Wizard, Creating Traces with Other Tools, Managing Traces, and Analyzing Traces.

Lesson 17: Watching and Optimizing (3.0) hours

Watching and Optimizing teaches you how to monitor SQL Server performance, tune and optimize SQL Server, and limit resources used by queries. This course shows users how to monitor and tune resource usage by SQL Server. Topics include Monitoring Disk I/O Performance, Monitoring CPU and Memory Usage, Other Monitoring Processes, and Optimizing Server Performance.

Lesson 18: Server Repair (4.0) hours

Server Repair teaches you how to diagnose and resolve problems with upgrading from SQL Server 6.x, use the Client Configuration utility to diagnose and resolve client connectivity problems, and diagnose and resolve problems regarding access to SQL Server databases and database objects. This course shows users how to troubleshoot problems with installation upgrading and access to servers. Topics include Overview of Troubleshooting, Solving Installation Problems, Solving Upgrading Problems, More About Upgrading Problems, Troubleshooting Server Access Problems, and Troubleshooting SQL Server Permissions.

Lesson 19: More Troubleshooting (4.0) hours

More Troubleshooting teaches you how to diagnose and resolve problems with backup and restore operations, diagnose and resolve replication problems, diagnose and resolve job or alert failures, and diagnose and resolve distributed query problems. This course shows users how to resolve problems with database management and linked server issues. Topics include Troubleshooting Backups and Restores, Troubleshooting the SQL Server Agent, Troubleshooting Jobs and Alerts, Troubleshooting Replication, and Linked Server Issues and Recovery Planning.