SQL Server 7 Admin Training Courses

Course List
Specials
Site Map
Free Training Tutorials
Microsoft Certification




Computer Training Courses Catalog
(PDF Format)

You will receive Unlimited Access to all of the SQL Server 7 Admin tutorials listed below. Your online training courses will be available from anywhere you have internet access.

Summary:

This series is designed to help users prepare for the MCSE Exam 70-028: Administering Microsoft SQL Server 7.0. The series 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.

This e-learning computer training series includes all of the online training tutorials listed below and is provided in an interactive e-learning format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 1 year unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit .

StaffKit is an e-learning leader in providing computer training tutorials and online education. We have satisifed online learning customers in over 40 countries.

Certification: Microsoft Certification

Includes:

SQL Server 7 Admin 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
• 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

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

• 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

• 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

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

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

• 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

• 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

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

• 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

• 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

• 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

• 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

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

• 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

• 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

• 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

• 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

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

Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 1 year unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit CEU credit.


Questions about SQL Server 7 Admin? We now offer 24x7 online support with access to real live experts! Get answers from real experts within minutes via our online chat service. For just $40.00 additional you add our Instant Mentoring service and get your SQL Server 7 Admin questions quickly answered anytime from anywhere.

SQL Server 7 Admin... ... $59.95
SQL Server 7 Admin + 1 Year Instant Mentoring... ... $99.95

You might also be interested in our Microsoft Certifications Package which includes all of the SQL Server 7 Admin training courses listed above plus over 1144 hours of additional courses.

About Us News Contact Us Features Certification

Reviews:

"this is a must have resource"
TheTechMag.com

"this is the Ultimate Career Development Package."
MidWest Technology Journal

Great Service and Excellent Training Product - Great People
Kenosha, WI

Excellent program, this is a real winner. Thanks. A+
Arlington, TX

Read more customer reviews about our e-learning training tutorials.