SQL Server Training Courses Online

Online Courses

Our SQL server training courses are based on sound principles, from extensive research in instructional design, adult learning and information processing. All SQL server training courses are design so that new knowledge and skills will be remembered and retrieved for future use. Each SQL server training course include a 30-questions skill assessment, which evaluates your knowledge of the SQL server training course material. You can be assured that this high-quality, instructionaly-sound online SQL server training product will enhance your professional and personal growth and stimulate job satisfaction. All courses was designed and created to meet or exceed the strict content guidelines.

This is self-paced, SQL server tutorial -- there are no books to purchase and no scheduled classes to attend.

Here are the courses we offer:

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

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

• Assess whether to use Microsoft Windows NT or Microsoft SQL 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
• 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
• 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
• 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 multi 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