Mastering Microsoft® SQL Server training seminars presented by CareerTrack Seminars register now on

findaseminar logo balls
event search registration and marketing services since 2002
Advanced Search

** NOTE: All April seminars are live Virtual or Online click to view events.

Mastering Microsoft® SQL Server  

 Email information about this seminar Mastering Microsoft® SQL Server by CareerTrack Seminars to yourself your manager or associates Email this event... View and register for other training seminars like Mastering Microsoft® SQL Server by CareerTrack Seminars on Find similar training.. Find and register for other training seminars by CareerTrack Seminars on Other seminars from CareerTrack Seminars


training seminars by CareerTrack Seminars CareerTrack Seminars   


IT professionals, IS professionals, Systems Administrators, IT support personnel, Database administrators


see Registration info for seminar cost, group discount etc.

Seminar Summary:

In just 2 days, learn to install, configure, administer, and troubleshoot this power-packed database platform! (see full course description)


 Seminar / Training class dates & locations


No seminar dates for this event are currently scheduled.  Please use the seminars search box above or choose one of the following additional training search options to find similar training.

SQL+server%2Csql+database%2Cmicrosoft+sql+server%2CSQL+server+2003+SQL training seminars workshops conferences online training

Providers course catalog

Find seminars by state

Find seminars by city

Request on site training

Use Advanced Search

NEW  Don't miss training you want to attend

Receive a personal Training Alert when training you want to attend comes to your area. Create a personal Training Alert now  it's Free and only takes a minute!




share this page 

print the agenda print agenda for the Mastering Microsoft® SQL Server seminar



Training Course Syllabus:

Mastering Microsoft® SQL Server® Training Class

Covers 2008 and previous versions

Give us just 2 days, and we'll give you the basics and beyond of Microsoft SQL Server!

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.

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.

You'll learn how to install and configure SQL Server properly, create databases using the different data types supported by SQL, and work with your data using queries, views, indices, stored procedures, triggers, importing and exporting, partitioning, XML, and much more. We will familiarize you with the new features and powerful capabilities of SQL 2008, and show you how to enhance the integrity and availability of your data using replication, mirroring, notification services, and clustering. If you're new to SQL Server, this course will give you the skills and knowledge you need to implement this power-packed database platform as soon as you return to the office. If you're already a user, you'll uncover helpful tips, tools, and strategies while mastering advanced techniques the pros use to fully utilize everything this system has to offer.

This course was created to give IT professionals 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!

Mastering Microsoft SQL Server — Seminar Overview


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 (Standard, Enterprise, Express, Work Group, Web, Developer) 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 2008
  • 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 2008's preliminary system check helps you head off problems before they happen during setup
  • The necessity of Service Pack 1
  • 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
  • A look at the Surface Area Configuration Tool and Reporting Services Configuration Tool
  • DTS backward compatibility - how to determine whether your system needs it, and how to access this extra feature if it does

Spotlighting Important New Features of SQL 2008

  • Data types: XML, MAX Data types: XML, MAX size value, varbinary (MAX), varchar (MAX)
  • CLR (.NET) integration
  • Try/Catch for T-SQL statements
  • 2-node Clustering (available in Standard Edition)
  • Database Mirroring
  • Increased Memory Usability with automatic AWE
  • How the Database Snapshot works
  • DDL Triggers: description and usage
  • MERGE Operator
  • Change Data Capture
  • Table-Valued Parameters
  • Conflict Detection in Peer-to-Peer Replication
  • Spatial data with GEOGRAPHY and GEOMETRY data types
  • Virtual Earth Integration
  • Sparse Columns
  • Filtered Indexes
  • Integrated Full-Text Search
  • Large User-Defined Types (UDTs)
  • CLR User-Defined Types
  • DATE/TIME Data Types
  • Improved XML Support


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

  • How to create tables with new data types
  • Tips on importing and exporting data into your tables
  • When you're using XML: document examples
  • What you should know about working with Views, Indexes, Stored Procedures, and Triggers
  • Queries using Try/Catch
  • How to use Report Builder
  • OLAP Reports
  • A look at Office Integration

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
  • Where potential security breaches are most likely to occur, and the best ways to prevent them
  • New Group Policy Enforcement: a look at Password Complexity, Invalid Login Attempts, and Expiration
  • Schemas for advanced security — how they work, how to implement them


Seminar Check-In: 8:30 AM    Seminar Class 9:00 AM to 4:00 PM

Seminar Summary:

In just 2 days, learn to install, configure, administer, and troubleshoot this power-packed database platform! (see full course description)

print this agenda print agenda for the Mastering Microsoft® SQL Server training seminar

 view dates and locations for this seminar




Custom Search