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:
- Discover which version (Small Business?
Enterprise? Work Group?
Mobile?) of SQL Server best fits your needs
- Learn to install, configure, and secure SQL
properly the first time — no
more trial-and-error mishaps
- Become familiar
with the important new features of SQL 2005, and find out how they
can optimize your
organization's productivity
- 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
Microsoft's SQL
Server is one of the most robust, reliable database management
platforms in use today. It has been embraced by organizations
worldwide, and technical professionals applaud its vast capabilities
for maximizing the functionality and optimizing the performance of
their database management systems.
This course was created to give IT
professionals like you a solid, working knowledge of SQL Database
Administration — swiftly and economically. Sure, you could spend
hundreds of dollars more and attend a SQL training program that's 3,
4, even 5 days long ... but why bother? In this intensive, focused
workshop, we've cut out tedious theory, irrelevant information, and
boring lecture. Instead, using fast-paced, attention-grabbing adult
learning techniques, we'll get you up to speed on SQL in just 2
days. We guarantee it!
From relational database fundamentals to
advanced troubleshooting techniques, we'll cover everything you need
to know in order to effectively store, retrieve, secure, and manage
your data using SQL Server.
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
Workshop
Overview:
Day
One
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 |
|
Which of the editions (Small Business
Edition, Enterprise Edition, Workgroup Edition, Mobile
Edition) is the right one for your business |
|
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 '05 |
|
What to watch out for when installing SQL |
|
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 |
|
Space requirements on the C:\drive |
|
How SQL 2005's preliminary system check helps you head
off problems before they happen during
setup |
|
Post Install: tips
on installing Service Pack 1 for SQL 2005 to enable Database
Mirroring and fixing multiple issues with RTM
version |
|
How to change the installed components with Add/Remove
Programs |
Configuring SQL
|
An overview of
Microsoft SQL Server Management Studio |
|
The Management Console: how to use it and where common
tools and features are located |
|
Tips for using SQL Server Integration Services
(SSIS) |
|
Demonstration: Maintenance Plan Creation |
|
Tighter security, right out of the box: how to enable
new features of SQL Server, such as CLR Integration and
xp_cmdshell |
Spotlighting Important New
Features of SQL 2005
|
New data types:
XML, MAX size value, varbinary (MAX), varchar
(MAX) |
|
CLR (.NET) integration |
|
Try/Catch — for TSQL statements |
|
2-node Clustering (available in Standard
Edition) |
|
Increased Memory Usability with automatic
AWE |
|
Online operations (Enterprise Edition only): Index
Rebuilds; Database Restores |
|
DDL Triggers:
description and usage |
Day
2
Creating a Database
|
2 methods for
creating a simple database — by Script and through the
Management Console |
|
The correct way to set the Primary and Foreign
keys |
|
The different data types supported by SQL, and how to
create custom data types if needed |
Working with Data and
Reporting
Managing Your Microsoft SQL
Server
|
The role of the
Enterprise Manager in monitoring server activity |
|
How the SQL Server Logs can help you troubleshoot
potential server problems |
|
Tips for setting up an automatic database maintenance
plan to handle routine maintenance tasks |
|
The built-in reports in Management Console |
|
How to use the Database Tuning Advisor
(DTA) |
Ensuring Data
Integrity, Availability, and Security
|
The pros and cons
of Replication, Mirroring, Notification Services, and
Clustering — plus, how and why to use each
solution |
|
How to establish data access and apply
permissions |
|
SQL Server's different security levels |
|
What you can do to ensure security through linked
servers |
|
Strategies for creating and managing your security
accounts with the Enterprise Manager |
|
New Group Policy Enforcement: a look at Password
Complexity, Invalid Login Attempts, and
Expiration |
|
Schemas for
advanced security — how they work, how to use
them |
To find out more about Mastering
Microsoft SQL Server,
contact our customer service department at customerservice@pryor.com
or by phone at 1-800-780-8476.
Check-out these Best-Selling Products
and Seminars:
|
Seminars
Public Seminar
Share this Page
Download Brochure