Microsoft SQL Server 7 Admin, Config, Install: 1 Security Strategy
Description
This course shows users how to plan the security policies for a SQL Server 7 installation.
Objectives
- 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
- Plan the security requirements for linked databases
Microsoft SQL Server 7 Admin, Config, Install: 2 System Requirements
Description
This course shows users how to prepare for the hardware needs of a SQL Server 7.0 installation.
Objectives
- 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
- Assess whether to use clustering
Microsoft SQL Server 7 Admin, Config, Install: 3 Migration Planning
Description
This course shows users how to migrate data from other sources into a SQL Server 7.0 installation.
Objectives
- 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
- Use the Import Wizard
Microsoft SQL Server 7 Admin, Config, Install: 4 Replication Plans
Description
This course shows users how to develop a strategy for system replication.
Objectives
- Design an appropriate replication model
- Choose a replication type
- Select an appropriate subscription model and type
- Evaluate data type requirements
Microsoft SQL Server 7 Admin, Config, Install: 5 Installing the Server
Description
This course shows users how to go through the installation process for servers and clients.
Objectives
- 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
- Install and configure the SQL Server 7.0 client software on client machines
Microsoft SQL Server 7 Admin, Config, Install: 6 Other Installations
Description
This course shows users how to perform unattended setups or upgrade from a previous version of SQL Server.
Objectives
- 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
- Validate and verify the upgrade of the system
Microsoft SQL Server 7 Admin, Config, Install: 7 Configuring
Description
This course shows users how to configure SQL server and its services.
Objectives
- 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
- 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
Microsoft SQL Server 7 Admin, Config, Install: 8 Security Management
Description
This course shows users how to assign access and roles to server users and databases.
Objectives
- 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
- Create and assign SQL Server roles
Microsoft SQL Server 7 Admin, Config, Install: 9 Managing Accounts
Description
This course shows users how to administer login IDs, Database IDs, and roles.
Objectives
- Create and assign SQL server roles
- Manage login IDs and database User IDs
Microsoft SQL Server 7 Admin, Config, Install:10 Managing Permissions
Description
This course shows users how to administer permissions and monitor server and database activity.
Objectives
- Grant to database users and roles the appropriate permissions on database objects and statements
- Audit server and database activity
Microsoft SQL Server 7 Admin, Config, Install:11 Database Management
Description
This course shows users how to create and maintain SQL server databases.
Objectives
- 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
- Delete a database
Microsoft SQL Server 7 Admin, Config, Install:12 Loading Databases
Description
This course shows users how to load data from other sources into SQL Server databases.
Objectives
- 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)
- Load data using the BULK INSERT command
Microsoft SQL Server 7 Admin, Config, Install:13 Backups and Restores
Description
This course shows users how to back up and restore data on SQL Servers.
Objectives
- Back up system databases and user databases
- Restore system databases and user databases
Microsoft SQL Server 7 Admin, Config, Install:14 Managing Replication
Description
This course shows users how to create and administer database replication.
Objectives
- Configure servers, including distributors, publishers, and subscribers
- Create publications
Microsoft SQL Server 7 Admin, Config, Install:15 Management Tasks
Description
This course shows users how to manage a variety of administrative tasks, including server jobs, events, alerts, linked servers, and remote servers.
Objectives
- 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
- Set up security for linked databases
Microsoft SQL Server 7 Admin, Config, Install:16 Monitoring Events
Description
This course shows users how to monitor and trace engine events.
Objectives
- 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
- Modify and replay traces
Microsoft SQL Server 7 Admin, Config, Install:17 Watching and Optimizing
Description
This course shows users how to monitor and tune resource usage by SQL Server.
Objectives
- Monitor SQL Server performance
- Tune and optimize SQL Server
- Limit resources used by queries
Microsoft SQL Server 7 Admin, Config, Install:18 Server Repair
Description
This course shows users how to troubleshoot problems with installation upgrading and access to servers.
Objectives
- Diagnose and resolve problems with upgrading from SQL Server 6.x
- Use the Client Configuration utility to diagnose and resolve client connectivity problems
- Diagnose and resolve problems regarding access to SQL Server databases and database objects
Microsoft SQL Server 7 Admin, Config, Install:19 More Troubleshooting
Description
This course shows users how to resolve problems with database management and linked server issues.
Objectives
- Diagnose and resolve problems with backup and restore operations
- Diagnose and resolve replication problems
- Diagnose and resolve job or alert failures
- Diagnose and resolve distributed query problems
Before you order a single course, check out our Value Pack Deals!
Prices shown are per person. For group orders Click Here.