microsoft sql server training online tutorial

Microsoft SQL Server Training Online
Info and Order

microsoft exchange
sql server tutorial
exchange
computer tutorial
online computer
windows 2000
access 2000
word 2000
a+ certification
quickbooks
office
lotus notes
exchange
java
cisco
focus
oracle
power builder
html
mcse
visual basic
MOUS

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

• 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 communication requirements
• Choose the appropriate backup and restore strategies
• Assess whether to use a standby
• 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
• Choose an appropriate character set, Unicode collation sequence, and sort order
• 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

This course has the following features:

• Exercises that allow users to practice the skills needed to develop a security strategy
• A file containing the text of the exercises
• Activities that allow users to apply concepts in an interactive questioning environment
• A course index
• A glossary
• A Skill Assessment

All courses are included in Online MCSE Training Pack.