For More Information
about On-Site Training… Call:
1-800-944-8503
E-mail:pryoronsite@pryor.com
Mastering Microsoft® SQL Server®
In just 2 days, learn to install, configure, administer, and troubleshoot this power-packed database platform!
Covers 2008 and previous versions
You'll gain the skills you need to optimize the strength and performance of this incredible database management system! Here's just some of what we'll cover in this intensive workshop:
Determine which version (Standard? Enterprise? Express? Work Group? Web? Developer?) of SQL Server best fits your needs
Learn to install, configure, and secure SQL properly the first time — eliminate trial?and-error mishaps
Become familiar with the important new features of SQL 2008, and find out how they can optimize your organization's productivity
Create databases using data types supported by SQL
Work with data using SQL: queries, views, indices, stored procedures, triggers, importing and exporting, and much more
Master troubleshooting, maintenance and security: Make sure you know how to keep SQL operating smoothly, while protecting your company's most sensitive data and valuable assets from harm
And much, much more!
Who should attend?
IT/IS professionals who are responsible for selecting company technology products
IT/IS professionals who are interested in discovering whether Microsoft SQL is right for their organizations
System administrators or managers who are responsible for the installation, configuration, and/or daily management of their data solutions
System administrators or managers who want to get the most out of their current SQL installations
Anyone looking for information to help them persuade their managers or directors of the need to convert or upgrade to Microsoft SQL
IT Support personnel who are routinely expected to assist users with data-related concerns
Small business managers, owners, or IT/IS representatives who are interested in finding out whether Microsoft SQL would be a valuable and manageable part of their technical arsenal
Quick Bytes: 10 reasons to mark you calendar and sign up now!
Gain a working knowledge of SQL Server in just 2 days!
Master tips, tools, and techniques from SQL experts to enhance your database platform's flexibility and performance
Learn to install/configure a new installation or upgrade of SQL Server
Discover all the newest features and functions of SQL Server 2008
Find out how to use SQL's enhanced security to prevent hackers, illegal users, and system crashes from exploiting or harming sensitive information
Become a more effective database administrator — get more work done with less time and effort using skills you've learned here!
Improve the functionality and usefulness of your databases
Learn with other IT professionals in a supportive, positive environment — network, share "war stories," and make valuable, productive connections with your peers
Make a smart, educated decision on whether SQL Server is right for your organization
Delegate more easily: Train others in the skills you've learned, and get everyone on your database team up to speed on SQL Server
Introduction to SQL: Selecting a Relational Database Management System
How Microsoft's SQL Server compares to other server options (such as Oracle and IBM) currently in use today
Is Microsoft SQL right for you? How to choose the right database platform for your organization
The pros and cons of each of the SQL versions and the normal uses and benefits of each version
Installing SQL
System requirements and prerequisites for SQL Server 2008
How to use the Upgrade Analysis Tool when upgrading from a previous version of SQL Server or switching over to SQL from another platform, such as Oracle
Essential information about local and remote SQL servers
Configuring SQL
The Management Console: how to use it and where common tools and features are located
Tips for using SQL Server Integration Services (SSIS)
A look at the Surface Area Configuration Tool and Reporting Services Configuration Tool
Spotlighting Important New Features of SQL 2008
CLR (.NET) integration
Try/Catch — for TSQL statements
Database Mirroring
Increased Memory Usability with automatic AWE
Spatial data with GEOGRAPHY and GEOMETRY data types