Microsoft SQL Server Tutorial Online Microsoft SQL
Server Tutorial
SQL Server
Tutorial Online
Info and Order

SQL Server 7 Database Administration

The self-paced SQL Server 7 Database Administration tutorial is exceptional. Our online SQL Server 7 Database Administration training is easy, convenient and affordable! High-quality, online, self-paced training designed to help you achieve your goals. Affordable annual subscription plans give you unlimited access to an entire suite of training topics at prices that you just won't find anywhere else.

This SQL Server 7 Database Administration course is for database administrators who want to learn how to administer SQL Server 7.0, or who are preparing for the MCSE exam 70-028:

SQL Server
Cisco CCNA
Cisco CCDA
Cisco Tutorial
A+ Certification Training
Network+ Certification
Microsoft Certification
MCSE Certification
MOUS Certification
Internet Training
Exchange Server
IIS4
TCP/IP
Windows NT
Windows 2000 Professional
Windows 2000 Server
MS Access 2000
Excel 2000
Excel 2000 Expert
Word 2000
Word 2000 Expert
PowerPoint Tutorial
Microsoft Project
Office 2000
Office 97
Outlook 2002
Oracle 8i
E-Commerce
Novell
Lotus Notes
Visual Basic Tutorial
FrontPage Tutorial
Java Certification
HTML Tutorial
Visual InterDev
PowerBuilder
FOCUS
UNIX Tutorial
Sybase
PhotoShop
S.A.S.
S.A.P.
QuickBooks
MS Works
Computer Security
Crystal Reports
XML
RPG IV

Fruta Vida
Business Opportunity

The following Microsoft SQL Server 7 Database Administration training courses are available online:

  • Security Strategy shows users how to plan the security policies for a SQL Server 7 installation.
  • System Requirements shows users how to prepare for the hardware needs of a SQL Server 7.0 installation.
  • Migration Planning shows users how to migrate data from other sources into a SQL Server 7.0 installation.
  • Replication Plans shows users how to develop a strategy for system replication.
  • Installing the Server shows users how to go through the installation process for servers and clients.
  • Other Installations shows users how to perform unattended setups or upgrade from a previous version.
  • Configuring shows users how to configure SQL server and its services.
  • Security Management shows users how to assign access and roles to server users and databases.
  • Managing Accounts shows users how to administer login IDs, Database IDs, and roles.
  • Managing Permissions shows users how to administer permissions and monitor server and database activity.
  • Database Management shows users how to create and maintain databases.
  • Loading Databases shows users how to load data from other sources into databases.
  • Backups and Restores shows users how to back up and restore data.
  • Managing Replication shows users how to create and administer database replication.
  • Management Tasks shows users how to manage a variety of administrative tasks, including server jobs, events, alerts, linked servers, and remote servers.
  • Monitoring Events shows users how to monitor and trace engine events.
  • Watching and Optimizing shows users how to monitor and tune resource usage.
  • Server Repair shows users how to troubleshoot problems with installation, upgrading, and access to servers.
  • More Troubleshooting shows users how to resolve problems with database management and linked server issues.

After completing our courses, the user should be able to:

  • Assess whether to use Windows NT or SQL Server accounts
  • Decide whether to use the Windows NT group structure for installation
  • Plan the use and structure of roles
  • Assess whether to map Windows NT groups directly into a database or use logins
  • Choose which NT accounts will be used to run services
  • Plan an n-tier application security strategy and determine whether to use application roles or other mid-tier security mechanisms such as MTS
  • Plan the security requirements for linked databases
  • 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
  • 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 prerequisites
  • Install Database Server component
  • Choose an appropriate character set, Unicode collation sequence, and sort order
  • Install network libraries and protocols
  • Install services and the appropriate startup options
  • Install and configure client software on client machines
  • Perform an unattended installation and uninstallation
  • Prepare for upgrading a system
  • Use the Upgrade Wizard to upgrade operations
  • Validate and verify the upgrade of the system
  • Register a server with network
  • 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 access through Windows NT accounts, logins, and built-in administrator logins
  • Assign database access to Windows NT accounts, login accounts, the Guest account, and the DBO user account
  • Create and assign roles
  • Manage login IDs and database User IDs
  • 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
  • Diagnose and resolve problems with upgrading
  • Use the Client Configuration utility to diagnose and resolve client connectivity problems
  • Diagnose and resolve problems regarding access to databases and database objects

High-quality, online, self-paced training designed to help you achieve your goals. Affordable annual subscription plans give you unlimited access to an entire suite of training topics at prices that you just won't find anywhere else. With training available in multiple formats, you get engaging instruction in an interactive setting with real world solutions to real life situations. See the steps, hear the instruction, and perform the exercises. It's a proven method of learning designed with people in mind.
Web based courses are empowering, engaging and cost-effective. It's done entirely over the internet. It's learning that can be taken anytime, anywhere. Most importantly, it works.

Training with CD-ROMs is a cost effective method that meets the critical demands of computer users. Experience expert-led courses in a comfortable and convenient environment. You get the feel of classroom delivered through flexible and familiar technology. Training comes to life with our full motion video, challenging labs, critical assessment and real-world insight from experts with vast experience in the subject matter. Engage in dynamic learning where multiple senses help reinforce learning concepts. See the steps, hear the explanations then put your skills to work. Our proven methodology provides an unequalled training experience with exceptional results

CD-ROMs feature:

  • Full Motion Video: Our Expert Instructors takes you step-by-step through the learning experience including interactive simulations.
  • Pre and Post Testing: Comprehensive testing lets you diagnose the best areas for concentration and helps you track your improvement.
  • Coach Feature: At any point in the course you can select the "Coach" button for focused learning on specific topics.
  • Printed Courseware: The CD-ROM set comes complete with printed courseware, a valuable reference tool after your training is complete.

If you are looking to learn new IT skills to aid in your current job, increase your chances of finding that perfect job or just to learn for personal use, then our courses are just what you have been looking for. We have hundreds of professionally developed online IT and Softskills courses available for a wide range of skill levels. Gain access to a wealth of IT and Softskills content aimed at all audiences from Beginners through to Intermediate and Advanced users in many areas. Access over 35,000 pages of training available in a structured, easy to learn system. Each training course has been professionally developed by Courseware provider that have years of experience in their subject field.

Sign up for our courses right now, and join the ranks of people who are taking financial advantage of the explosion in the Information Technology field.