Training Center
Computer Training courses online, at your pace !

Computer Training Online


Or call 800 639 0160








SQL Server 7 Admin
 Join over 1 million people who learn online, with these complete interactive computer training courses.




See How It Works
This online course includes: Time Needed
Security Strategy 3 hours
System Requirements 3 hours
Migration Planning 3 hours
Replication Plans 3 hours
Installing the Server 4 hours
Other Installations 2 hours
Configuring 3 hours
Security Management 3 hours
Managing Accounts 2 hours
Managing Permissions 4 hours
Database Management 3 hours
Loading Databases 3 hours
Backups and Restores 4 hours
Managing Replication 3 hours
Management Tasks 3 hours
Monitoring Events 3 hours
Watching & Optimizing 3 hours
Server Repair 4 hours
More Troubleshooting 4 hours
Estimated time needed to complete entire course 60 hours


Receive your login ID to take the training courses online, as many times as you wish, for 1 year.  Click here for group orders.

Buy this entire online training course with one easy payment of $67

OR

Buy the Microsoft Pack, and receive this course plus many more, for only $197



Benefits
  • Unlimited access for 1 year
  • Learn anytime, anywhere
  • You control the pace
  • Start & stop wherever you want
  • No books to read
  • No software needed
  • Value Packs include Free online tech support
  • Double guarantee
  • 100% Money back guarantee
  • One time payment No monthly fee
  • Use the course index for review anytime
  • Answer course questions with at least 70% accuracy and print your own certificates of completion to prove that you have mastered each training course.
  • Free status reports for company managers

Requirements
All you need is a PC with Windows, the Microsoft Internet Explorer (browser) and an Internet connection.
Note: The online computer training is designed to work only with Internet Explorer.  Prices shown are per user.




What You will Learn
This online training course is designed to help you prepare for the MCSE Exam 70 028: Administering Microsoft SQL Server 7.0. The online training course covers 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.




Security Strategy
  • 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
  • Plan the security requirements for linked databases
  • 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



System Requirements
  • 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 whether to use clustering
  • Assess the server's communication requirements
  • Choose the appropriate backup and restore strategies
  • Assess whether to use a standby server



Migration Planning
  • 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



Replication Plans
  • Design an appropriate replication model
  • Select an appropriate subscription model and type
  • Choose a replication type
  • Evaluate data type requirements 



Installing the Server
  • 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



Other Installations
  • Perform an unattended installation and uninstallation of Microsoft SQL Server 7.0
  • Prepare for upgrading a SQL Server system
  • Validate and verify the upgrade of the system 
  • Use the Upgrade Wizard to upgrade operations from SQL Server 6.x to SQL Server 7.0



Configuring
  • 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



Security Management
  • Assign SQL Server access through Windows NT accounts, SQL Server logins, and built in administrator logins
  • Create and assign SQL Server roles
  • Assign database access to Windows NT accounts, SQL Server login accounts, the Guest account, and the DBO user account



Managing Accounts
  • Create and assign SQL server roles
  • Manage login IDs and database User IDs



Managing Permissions
  • Grant to database users and roles the appropriate permissions on database objects and statements
  • Audit server and database activity



Database Management
  • 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



Loading Databases
  • 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



Backups and Restores
  • Back up system databases and user databases
  • Restore system databases and user databases



Managing Replication
  • Configure servers, including distributors, publishers, and subscribers
  • Create publications




Management Tasks
  • 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




Monitoring Events
  • Monitor SQL Server engine event performance
  • Explain tracing and trace architecture
  • Run and save traces
  • Create traces using the Create Trace Wizard SQL Server Profiler and extended stored procedures
  • Modify and replay traces




Watching & Optimizing
  • Monitor SQL Server performance
  • Tune and optimize SQL Server
  • Limit resources used by queries




Server Repair
  • 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 



More Troubleshooting
  • 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 





 

 

Copyright © 2007 TrainingCenter.com