sql certification training online course
online sql certification training

SQL Certification Training Course
Info and Order

SQL Certification Training Online



The self-paced sql certification training is exceptional. Our online sql certification training course meet or exceed exam objectives, teaching precisely what you need to know.

FREE Online Courses

FREE Certification Exams

QuickBooks

HTML Tutorial

Flash MX

Cisco CCNA

Oracle
9i Training

Visual Basic

SQL Server

A+ Certification

Network+ Certification

Webmaster Certification

Java Certification
310-025

MCSE Training

MOUS Training

Windows 2000
Training Courses

70-210 Courses

70-215 Courses

70-216 Courses

70-217 Courses

70-218 Courses

70-219 Courses

70-220 Courses

70-221 Courses

70-224 Courses

70-229 Courses

70-270 Courses

Microsoft Office
Training Courses

Office XP

Access 2000

Excel 2000

Word 2000

Power Point

Project

Outlook 2000

Works

Internet Explorer

FrontPage

Exchange Server

Novell

PhotoShop

Crystal Reports

Lotus Notes

LINUX

UNIX

X.M.L.


This sql training 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: Administering Microsoft SQL Server 7.0.

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

This is self-paced, internet-based training course -- there are no books to purchase and no scheduled classes to attend.

  • Security Strategy shows users how to plan the security policies for a SQL Server 7 installation.
  • System Requirements shows users how to prepare for the hardware needs of a SQL Server 7.0 installation.
  • Migration Planning shows users how to migrate data from other sources into a SQL Server 7.0 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 of SQL Server.
  • Configuring shows users how to configure SQL 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 server and database activity.
  • Database Management shows users how to create and maintain SQL server databases.
  • Loading Databases shows users how to load data from other sources into SQL Server databases.
  • Backups and Restores shows users how to back up and restore data on SQL Servers.
  • Managing Replication shows users how to create and administer database replication.
  • Management Tasks shows users how to manage a variety of administrative tasks including server 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 by SQL Server.
  • Server 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.

After completing our courses, the user should be able 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 SQL Server roles
  • Assess whether to map Windows NT groups directly into a database or use SQL Server logins
  • Choose which NT accounts will be used to run SQL Server 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 Server
  • 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 of Microsoft SQL Server
  • 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 SQL Server 7.0 prerequisites
  • Install the SQL Server 7.0 Database Server component
  • Choose an appropriate character set Unicode collation sequence and sort order
  • Install network libraries and protocols
  • Install the SQL Server 7.0 services and the appropriate startup options
  • Install and configure the SQL Server 7.0 client software on client machines
  • Perform an unattended installation and uninstallation of Microsoft SQL Server 7.0
  • Prepare for upgrading a SQL Server system
  • Use the Upgrade Wizard to upgrade operations from SQL Server 6.x to SQL Server 7.0
  • Validate and verify the upgrade of the system
  • Register a server with a SQL Server network
  • Configure Microsoft SQL Server 7 including installing and configuring SQL 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 SQL Server access through Windows NT accounts SQL Server logins and built-in administrator logins
  • Assign database access to Windows NT accounts SQL Server login accounts the Guest account and the DBO user account
  • Create and assign SQL Server roles
  • Create and assign SQL server 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 SQL Server 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 SQL Server engine event performance
  • Explain tracing and trace architecture
  • Create traces using the Create Trace Wizard SQL Server Profiler and extended stored procedures
  • Run and save traces
  • Modify and replay traces
  • Monitor SQL Server performance
  • Tune and optimize SQL Server
  • Limit resources used by queries
  • Diagnose and resolve problems with upgrading from SQL Server 6.x
  • Use the Client Configuration utility to diagnose and resolve client connectivity problems
  • Diagnose and resolve problems regarding access to SQL Server 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

This course has the following features:

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



Bass Computer Services
Independent Technology Consultant