SQL server certification training courses online
SQL server certification training online

SQL Server
Training Course
Info and Order

 

SQL Server Training Courses Online

dick cleaning utility

Visual Studio
SQL Server
PhotoShop Tutorial
Flash Tutorial
Java Tutorial
C++ Tutorial
Visual Basic Tutorial
DreamWeaver Tutorial
Microsoft Certification
Microsoft Access Tutorial
Microsoft Excel Tutorial
Power Point Tutorial
XML Tutorial
Windows Server 2003
Access Tutorial
MCSE Training
Software Training
Sybase Tutorial
SAS Tutorial
Project Management Training
Flash Animation Training
Technical Training
Management Training
Java Training
Cisco Training
Computer Programming Tutorial
Excel Training
Oracle Training
Excel Tutorial
Access 2002
Microsoft Access
Outlook 2002
Microsoft Outlook
PowerPoint 2002
Microsoft Project 2000
Microsoft Word
Microsoft Works
Microsoft Excel
Excel 2003
Office 2000
Microsoft Office
Cisco CCNA
Sybase Tutorial
Cisco Certification
Exchange Server
FrontPage Tutorial
HTML Tutorial
Java Script
Oracle Database
Oracle Certification
SAS Programming
Java Programming
MCSE Certification
Red Hat Linux
WebSphere
ASP NET
Java Programming
Database Management
Time Management
Visual Basic
QuickBooks Tutorial
Web Page Design
Crystal Reports
Microsoft Visio
MySql
XML
XML Tutorial
Cisco CCNA
Lotus Notes
Lotus Notes Tutorial
Dream Weaver
Dream Weaver Tutorial


Online Courses

hit
counter
 

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