SQL Server Tutorial

SQL Server tutorial internet based course

The self-paced sql server tutorial is exceptional. Our sql server tutorial meet or exceed exam objectives, teaching precisely what you need to know.

Microsoft SQL
Server 2000

Webmaster Certification

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

This tutorial is for database administrators who want a tutorial how to administer SQL Server 7.0 or who are preparing for the MCSE exam 70-028.

Security Strategy shows users how to plan the security policies for a 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 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 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 jobs events alerts linked servers and remote servers.
Monitoring Events shows users how to monitor and trace engine events.
Watching & Optimizing shows users how to monitor and tune resource usage.
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.

During the courses, you will learn how to:

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 roles
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
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 the prerequisites
Install the Database component
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 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 servers including 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 SQLAgentMail for job notification and alerts
Set up linked servers
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

Our courses have special design features listed below:

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
Microsoft Approved Courseware Logo - to prepare you for a Microsoft certification
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.