DESCRIPTION AND BENEFITS

During this two-day HANDS-ON workshop you will:

• learn all about the facilities and components of Microsoft SQL Server™
• have plenty of opportunity to experiment with our live SQL Server™ network
• explore Microsoft's SQL Server™ security and control features and find out what the system administrators should be doing
• learn how to extract information from SQL Server™ and how to interpret it
• be shown how to audit a SQL Server™ environment and learn how to extract audit information by writing simple enquiries in T-SQL
• take away not only a valuable hands-on experience, but also a fully documented course manual complete with Audit Workpacks showing all the detailed audit tests you need to perform and questions to ask when auditing a Microsoft SQL Server™ system.
  

We’ll cover all recent versions including Microsoft SQL Server 2000™ and Microsoft SQL Server 7™

Here is a wonderful opportunity to find out how Microsoft SQL Server™ works, and through hands-on access, to play with a real live system. We'll show you where the main security weaknesses lie and exactly what needs to be done to put things right.

This is a highly functional environment where communication across a Microsoft network is very easy to achieve - too easy perhaps? As with all highly functional products the downside is insecurity. Learn in a hands-on environment what this means, and how to conduct a thorough audit to check that all is well.

WHAT WILL BE COVERED

Introduction
• an overview of Microsoft SQL Server™
• architecture
••• • database structure

HANDS-ON
Introducing Microsoft SQL Server™ and security
• data storage
• exchanging information between servers
••• • data transformation services
••• • linked servers
• log-in and user security
••• • permissions and privileges
• application security
• auditing facilities
••• • audit trails using triggers
• automation features
• web publication of SQL Server™ data
• replication
• SQL Server™ security
••• • the underlying operating system

HANDS-ON
Auditing Microsoft SQL Server™
• audit tests to perform and questions to ask
• how to use your Audit Workpacks
• using the audit trail
• using triggers to obtain audit data
• using T-SQL for audit

To Course Index Page

To Bookings Page