This sql server tutorial 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: Administering Microsoft SQL Server 7.0.

SQL server tutorial that's Easy, Convenient and Affordable! High-quality, online, self-paced sql training courses designed to help you achieve your goals. Affordable annual subscription plans give you unlimited access to an entire suite of courses topics at prices that you just won't find anywhere else.

This is self-paced, internet-based course -- there are no books to purchase and no scheduled classes to attend.

Security Strategy shows users how to plan the security policies for installation.
System Requirements shows users how to prepare for the hardware needs of a installation.
Migration Planning shows users how to migrate data from other sources into a 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 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 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 jobs events alerts linked and remote.
Monitoring Events shows users how to monitor and trace engine events.
Watching & Optimizing shows users how to monitor and tune resource usage by.
Server Repair shows users how to troubleshoot problems with installation upgrading and access.
More Troubleshooting shows users how to resolve problems with database management and linked issues.

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

Assess whether to use Microsoft Windows NT or Microsoft SQL Server accounts
Decide whether to use the Windows NT group structure for a installation
Plan the use and structure
Assess whether to map Windows NT groups directly into a database
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 Microsoft Transaction Server
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 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 the prerequisites
Install the components
Choose an appropriate character set Unicode collation sequence and sort order
Install network libraries and protocols
Install the services and the appropriate startup options
Install and configure the 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 a network
Configure Microsoft SQL Server 7 including installing and configuring 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 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
Configure distributors publishers and subscribers
Create publications
Set up and manage subscriptions
Automate administrative tasks
Configure Agent
Define jobs and create multiserver jobs
Define operators and alerts
Set up AgentMail for job notification and alerts
Set up security for linked databases
Monitor engine event performance
Explain tracing and trace architecture
Create traces using the Create Trace Wizard Profiler and extended stored procedures
Run and save traces
Modify and replay traces
Monitor performance
Tune and optimize
Limit resources used by queries
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
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

This course has the following features:

Certificates of Completion
Instructional steps -- walk through a procedure
Exercises -- try it out
Notes - See additional information related to the topic in the text
Tips - See a different, faster, or easier way of doing something
Quick References - See a quick reference guide to the features introduced in a chapter
Details - Display more detailed information related to the current topic
Hotwords - See related information
Navigation Bar - Maneuver easily through the courses
Course Topics and Index -- with searching feature and hyper-links
Printable Exercises - PDF downloadable files
Sample Application Files - PDF downloadable files
Course Glossary
Skill Assessment - can be used for pre and post-testing -- tracking first try, best try and course grade - if passed, green check mark will appear as 'mastered' - hyperlinks to units within the course to go back and re-take a certain unit again. Use as pre-test to determine which course topics you want to focus on and to go directly into that unit.

Technical Requirements

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Internet Explorer 5.0 or higher required. Minimum Connection Speed: 28.8k. Authorware recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Learning comes to life with 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. Our proven methodology provides an unequalled experience with exceptional results Learning that's Easy, Convenient and Affordable! High-quality, online, self-paced courses designed to help you achieve your goals. Affordable annual subscription plans give you unlimited access to an entire suite of topics at prices that you just won't find anywhere else.

Our courses are based on sound principles, from extensive research in instructional design, adult learning and information processing. All courses are design so that new knowledge and skills will be remembered and retrieved for future use. Each course include a 30-questions skill assessment, which evaluates your knowledge of the course material. You can be assured that this high-quality, instructionally-sound online product will enchance your professional and personal growth.

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.