National Seminars Group
National Seminars Group presents

Installing Administering and Troubleshooting Microsoft SQL SERVER On-Site Training

This on-site training class is also available as Public Schedule Seminar.

The one-stop solution to your SQL Server training needs

Course Description/Agenda

Program Description

We invite you to join us at Installing, Administering and Troubleshooting Microsoft® SQL Server, an intensive two-day training event for IT professionals at all levels of experience with SQL Server. Scheduled in your area soon, this comprehensive course is designed to get you up to speed fast on optimizing this database management software for the greatest system efficiency – and the biggest bang for your organization’s IT buck.

Your trainer is an MCSE who’ll answer your toughest questions. Your trainer will be an SQL Server expert with multiple certifications from Microsoft and a guru on database technologies and security. With more than a decade of real-world experience in database implementation and support, he’ll provide answers to all your tough questions on SQL Server. He’ll use CompEd Solutions’ exclusive “hands off” training method to help you learn more information in less time.

What You'll Learn

  • Install Microsoft SQL Server right the first time
  • Master automation of SQL Server and gain hours in productivity P
  • revent hackers from accessing your sensitive data by properly securing your databases
  • Overcome performance barriers without buying additional hardware or software
  • Save thousands of dollars in downtime by implementing an effective backup and restoration policy
  • Create queries from scratch or with the help of the Query Builder
  • Put your data on the Web in just a few simple steps
  • Use common tools, such as Microsoft Access and Excel, to work with your SQL Server databases
  • Read the server logs with a deeper level of understanding so you can better benefit from the information
  • Implement multiple servers to provide data redundancy and high availability
  • Create database structures that reduce data input errors and increase efficiency of operations
  • Use stored procedures for repeated tasks and optimal performance
  • Create sophisticated data searches with only a few lines of code
  • Go beyond the wizards to understand how your databases really work
  • Simplify the process of selecting the appropriate data types for your data
  • Integrate SQL into legacy systems without the usual hassle
  • Generate Web-ready files from triggers to provide browser-based viewing of the results
  • Increase your administrative productivity with tips and tricks the pros use to optimize their databases
  • Significantly enhance system stability and security
  • Maximize your organization’s IT investment by getting the most out of SQL Server and the underlying hardware and software, and much more!

Who Should Attend?

  • IT and IS Professionals
  • Database Administrators
  • Computer and Database Support Personnel
  • Database Programmers
  • Network Administrators
  • SQL Report Generators
  • Data Security Managers
  • Data Warehousing Specialists
  • Business Intelligence Managers

Workshop Agenda



  • Understanding relational databases
  • Discovering the SQL Server features and benefits
  • Why SQL Server’s architecture must be understood


  • Uncovering the variable hardware requirements
  • Getting the licensing right
  • Understanding various installation methods
  • Verifying and troubleshooting installations
  • Configuring the SQL Server Enterprise Manager
  • Tuning Windows Server for optimum support of the SQL Server software


  • Data structures demystified
  • Creating your first databases
  • Managing databases with ease
  • Working with database files and logs
  • Becoming skilled in database optimization techniques
  • Capacity planning Performance considerations


  • Master the 3 most important SQL Server configuration tasks
  • How to automate mundane maintenance tasks
  • Create a maintenance plan that will save you hours of effort
  • Use alerts to warn you of impending dangers
  • Troubleshooting SQL Server automation issues
  • Creating databases using scripts


  • Prevent data loss through effective backup and recovery plans
  • Exploring various methods used to back up your databases
  • Learn how to recover SQL Server when it fails
  • Understand the system database and how to recover it


SQL 101

  • Learn how the SQL language functions
  • Discover how to create SQL queries
  • Master the creation of data through SQL
  • Uncover SQL tips and tricks of the gurus


  • Understanding and implementing authentication
  • Assigning logins to users and roles
  • Assigning permissions to users and roles
  • Managing security within SQL Server
  • Managing security with views and stored procedures
  • Managing application security


  • Learn the importance of database monitoring
  • Creating a performance monitoring and tuning methodology
  • Discover the tools for monitoring SQL Server
  • Common monitoring and tuning tasks made simple


  • Introduction to transferring data
  • Find out about tools used for transferring data in

SQL Server

  • Introduction to the data transformation services
  • Transforming your data using DTS
  • Introduction to distributed data
  • Introduction to SQL Server replication
  • SQL Server replication agents
  • SQL Server replication types
  • A look at physical replication models


  • Planning and using multiple instances of SQL Server
  • Using server virtualization for increased capabilities
  • Using clustering technologies
  • Taking advantage of hardware redundancies


More Seminar Information

National Seminars Group
National Seminars Group

Delivery Method

On-Site Training On-Site Training

Also Available As

Seminar Seminar

Add to favorites Add to favorites
Email Email this page

On-Site Training
Information Request Form

Please complete the form for more information and/or a quote for this on-site class.




City and State


Number of students:
(at least 10 for consideration)

When do you want to hold the

How long would you like for the

Additional comments to trainer:

We value your privacy!