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

DAY ONE

INTRODUCING SQL SERVER

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

PLANNING AND INSTALLING SQL SERVER

  • 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

MANAGING DATABASE FILES

  • 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

PERFORMING ADMINISTRATIVE TASKS

  • 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

BACKING UP AND RESTORING YOUR DATABASES

  • 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

DAY TWO

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

MANAGING SECURITY

  • 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

MONITORING SQL SERVER FOR PERFORMANCE

  • 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

DATA REPLICATION AND TRANSFORMATION

  • 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

MAINTAINING HIGH AVAILABILITY

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

Name:

Email

Phone:

City and State

Company:

Number of students:
(at least 10 for consideration)

When do you want to hold the
seminar?

How long would you like for the
seminar?

Additional comments to trainer:

We value your privacy!