Mastering Microsoft® SQL Server Seminar training classes conferences & workshops presented by CareerTrack Seminars register for training on FindaSeminar.com

Home

Add your seminars

Training Calendar Creator Seminar Venues Training Provider Directory
 

New Seminar Search:  

 
find similar training...
Search by state...
Email this event ...

Customer Support


Do you need help finding the right class, date, or location or other assistance?

Request information about upcoming training seminars workshops and conferences in   and other cities listed on FindaSeminar.com Submit a support request and receive a prompt reply.

We guarantee this CareerTrack Seminars training seminar

We are an authorized partner of CareerTrack Seminars

 

Price protection. The price to attend Mastering Microsoft® SQL Server is set by the training providerThere is no added charge for our services.

We honor most training provider coupons
*.   Call  a representative to see if your discount coupon applies.


Privacy. Your personal information won't be shared with anyone but the training provider CareerTrack Seminars.


Security. When you register for this seminar on FindaSeminar.com your personal data and payment information is safely collected and processed using secure SSL encryption technology.

Flexibility. FindaSeminar.com offers you three ways to register for Mastering Microsoft® SQL Server seminar by CareerTrack Seminars.
Register online, by phone, or fax.
Who should attend Mastering Microsoft® SQL Server
IT professionals, IS professionals, Systems Administrators, IT support personnel, Database administrators
Reviews
Write and read CareerTrack Seminars reviews and reviews about the training seminar Mastering Microsoft® SQL Server on the Seminar News Network and the Training News Network.
 

Frequently asked questions and registration options for the training seminar Mastering Microsoft® SQL Server

 
Find Training Near You
Use our clickable map to find training near you
Use Our Clickmap
 
Education and training domain names

Education and training news articles

hotel seminars meeting space directory
hotel meeting space training facilities restaurant and lodging

 

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 FindaSeminar.com Find similar training.. Find and register for other training seminars by CareerTrack Seminars on FindaSeminar.com Other seminars from CareerTrack Seminars

By:

training seminars by CareerTrack Seminars CareerTrack Seminars   

For:

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

Cost:   

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

DAY 1

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
  • FILESTREAM Data
  • Large User-Defined Types (UDTs)
  • CLR User-Defined Types
  • DATE/TIME Data Types
  • Improved XML Support

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

  • 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 TIME:

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

 

 

     
 

 
     

 

  Also try the advanced seminar search tool

   FindaSeminar HomeComputer Training

unix training
training classes

 © 2002-2014 FindaSeminar.com™ All Rights Reserved.  Terms of Use |  Privacy Policy |  Training News Network

   

Custom Search