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:

• Install Microsoft SQL Server right the first time
• Master automation of SQL Server and gain hours in productivity
• Prevent 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

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 1-919-847-0331 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'
Birmingham , AL - Arthur's Conference Center - 1730405 - Fee $ 899.00 - 06/24/08 - 06/25/08 Anaheim , CA - Sheraton Park Hotel - 1734114 - Fee $ 899.00 - 08/07/08 - 08/08/08 North Hollywood , CA - Beverly Garland's Holiday Inn - 1734113 - Fee $ 899.00 - 08/05/08 - 08/06/08 Denver , CO - The Curtis Hotel - 1732053 - Fee $ 899.00 - 07/29/08 - 07/30/08 Oak Brook , IL - Residence Inn - 1730402 - Fee $ 899.00 - 06/05/08 - 06/06/08 Indianapolis , IN - Embassy Suites Downtown - 1725456 - Fee $ 899.00 - 05/08/08 - 05/09/08 Louisville , KY - Hyatt Regency - 1725455 - Fee $ 899.00 - 05/06/08 - 05/07/08 Baton Rouge , LA - Marriott Hotel - 1730406 - Fee $ 899.00 - 06/26/08 - 06/27/08 Grand Rapids , MI - Hilton Inn Airport - 1730403 - Fee $ 899.00 - 06/17/08 - 06/18/08 Livonia , MI - Radisson - 1730404 - Fee $ 899.00 - 06/19/08 - 06/20/08 Kansas City , MO - Hilton President Downtown - 1731813 - Fee $ 899.00 - 07/15/08 - 07/16/08 Charlotte , NC - Courtyard Charlotte City Ctr - 1725859 - Fee $ 899.00 - 05/27/08 - 05/28/08 Edison , NJ - Clarion Hotel And Towers - 1734128 - Fee $ 899.00 - 08/14/08 - 08/15/08 New York , NY - Radisson Hotel Martinique - 1734127 - Fee $ 899.00 - 08/12/08 - 08/13/08 Cincinnati , OH - Crowne Plaza - 1725601 - Fee $ 899.00 - 05/13/08 - 05/14/08 Columbus , OH - Hyatt Regency At Ohio Center - 1725602 - Fee $ 899.00 - 05/15/08 - 05/16/08 Tulsa , OK - Embassy Suites - 1731812 - Fee $ 899.00 - 07/17/08 - 07/18/08 Nashville , TN - Willis Conference Center - 1725860 - Fee $ 899.00 - 05/29/08 - 05/30/08 Salt Lake City , UT - Royal Garden Inn - 1732054 - Fee $ 899.00 - 07/31/08 - 08/01/08 Brookfield , WI - Sheraton Hotel - 1730401 - Fee $ 899.00 - 06/03/08 - 06/04/08

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-847-0331. Please mention the meeting number specified above and BE SURE TO STATE VIP CODE "919-120001-000 -- Training Registry".