presents


National Seminars Group & Padgett Thompson
a division of Rockhurst University Continuing Education Center
Course Description


Installing, Administering, and Troubleshooting Microsoft® SQL SERVER

The one-stop solution to your SQL Server training needs

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:

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

We stand behind our seminars with a 100 percent , iron-clad, money-back guarantee of satisfaction. If for any reason you’re not completely satisfied with the solid skills, the tips, tools and shortcuts, and the crucial information you receive during this workshop, we’ll refund your money in full. Every penny. Guaranteed!

Program Hours:
9:00 a.m. to 4:00 p.m. Registration begins at
8:30 a.m.


Group Discount: When 3 enroll from your organization, a 4th attends FREE!

Lunch:
Lunch is on your own.

Continuing Education:
Continuing education credits may be recognized by your professional board. Contact your own board to find out what's required. If you cancel your registration up to five business days before the workshop,

Bring a seminar to your site! For information about bringing a course to your site please call 919-480-2550 or email the registry at .

If this course or the dates/locations below do not have what you are looking for, then click here and we will find it for you right away. It will save you a lot of time and energy finding it yourself.

** Register Online**

Select date/location from list box below (Use side arrow to scroll). Complete form and click on 'Send'

Title: Mr. Mrs. Ms
Fields with an "*" are required input.
* Attendee Name:
Position:
* E-Mail:
Company:
* Address 1:
Address 2:
* City:
* State/Province:
* Zip/Postal Code:
Country:
* Phone:
* Fax:
* Contact first and last name:
Approving supervisor first and last name:
Click here to add more attendees.
Dollar Amount of Transaction:
(Please add appropriate sales tax if in SD or WV.)

Payment Information
Invoice Me, or
Credit Card Info:
Credit Card Type: American Express VISA Mastercard
Credit Card Number:
Expiration Date:
Name on Card:
 
PO # (if applicable):
Tax Exempt #:

Additional Attendees: Use for listing additional attendees only.
Attendee 2 Name:
Attendee 3 Name:
Attendee 4 Name:
(4th is FREE when you register 3)
Attendee 5 Name:
Attendee 6 Name:
Attendee 7 Name:
Attendee 8 Name:
(8th is FREE when you register 7)

Additional Information:

National Seminars Group will e-mail confirmation soon. If you are not paying via credit card, you will receive an invoice with payment instructions.

Cancellation Policy:
If you cannot attend a workshop for which you are registered, you may send a substitute or receive a credit memo toward a future workshop. If you cancel your registration up to five business days before the workshop, your registration fee will be refunded less a $10 enrollment charge.

You can also register by emailing your registration information to us at or calling us at 919-480-2550. Please mention the meeting number specified above and BE SURE TO STATE VIP CODE "919-120001-000 -- Training Registry".

Cover Page | Padgett Thompson Seminars



The Training Registry