Microsoft SQL Server Tutorial Online
SQL Tutorial Online Training Courses

SQL Server Tutorial Online
Info and Order

SQL Tutorial Online Training Courses

The self-paced SQL Server Tutorial is exceptional. Online sql server tutorial courses with award winning content and engaging instructions. Courses meet or exceed certification exam objectives, teaching precisely what you need to know.

FREE Computer Training Courses

Video and CD
Info and Order!

Cisco CCNA
Cisco CCDA
Cisco Tutorial
A+ Certification Training
Network+ Certification
Microsoft Certification
MCSE Certification
MOUS Certification
Internet Training
Exchange Server
IIS4
SQL Server
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 Tutorial
RPG IV Programming

Click Here

This 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:
Training that's 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.

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.

Try our FREE courses right now, and see for yourself how much you will learn!

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

Course Features

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

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.

All courses are included in Online MCSE Training Pack.