Sharon Toler's blog

SCOM (System Center Operations Manager) Training at AmeriTeach - Denver Colorado 80111

Installing and Configuring System Center Operations Manager 2007

Course 50028: Five days; Instructor-Led

About this Course

This five-day instructor-led course provides students with the knowledge and skills to managing a Systems Center Operations Manager 2007 management group. This course is intended to develop the necessary skills to install and manage Operations Manager 2007 management servers and supporting roles.

Audience Profile

This course is intended for Windows Server 2003 or later administrators who have experience working within a Windows Active Directory domain environment and have a good understanding of Windows Server based network services. Familiarity with a support ticketing system is helpful.

At Course Completion

Course OutlineModule 1: Installing System Center Operations Manager

This module explains how to install management servers and configure a clustered Root Management Server.

Lessons

· Identifying and Installing Prerequisites
· Installing System Center Operations Manager 2007
· Post Installation

Lab : Installing System Center Operations Manager

· Installing the Operations Manager Components

Lab : Installing a Clustered RMS

· Creating Cluster Resources
· Installing the Operational Database
· Installing the RMS Node
· Installing the Secondary Management Server
· Creating the Services
· Creating the RMS Cluster Virtual Server

After completing this module, students will be able to:

· Identify the requirements for installing System Center Operations Manager 2007
· Install System Center Operations Manager 2007 and verify a successful installation

Module 2: Using the Operations Console

This module explains how to use the Operations Console, create Operator Accounts, use the Web Console and create Views.

Lessons

· Overview of the Operations Console
· Creating Operator Accounts
· Using the Web Console
· Working with Views

Lab : Creating Operator Accounts and Views

· Creating User Roles
· Creating Views

After completing this module, students will be able to:

· Install the Operations Console on another system
· Understand the workspaces and views
· Work with the Actions available for a given object

Module 3: Configuring Management Group and Agent Settings

This module explains how to define the default management group and agent settings, override the default settings for a management server and agents, and create notifications to be sent when alerts appear.

Lessons

· Global Settings
· Overriding Global Settings
· Creating Notifications

Lab : Creating Notification Settings

· Setting Management Group Notification Options
· Creating Notification Recipients
· Creating Notification Subscriptions

Module 4: Agent Installation

This module explains how to install and configure the agent.

Lessons

· Configuring Active Directory
· Automatic Installation
· Manual Installation
· Managing Agents

Lab : Agent Installation

· Manually Installing the Agent
· Approving the Manually Installed

Module 5: Management Packs

This module explains how to import, export, and manage management packs.

Lessons

· Overview of Management Packs
· Importing and Exporting Management Packs
· Creating and Sealing Management Packs

Lab : Creating Monitors

· Creating a Self-Tuning Threshold Monitor
· Creating a Correlated Windows Event Unit Monitor

Module 6: Reporting

This module explains how to install and configure Reporting Services and build the appropriate models for Operations Manager monitoring.

Lessons

· Installing and Configuring SQL Reporting Services
· Installing Operations Manager Reporting
· Creating and Viewing Reports

Lab : Creating Reports

· Creating a Model
· Creating a Report

Module 7: Agentless Exception Monitoring

This module explains how to configure the settings and group policy options for Agentless Exception Monitoring.

Lessons

· Configuring Exception Monitoring
· Managing Clients

Lab : Configuring Agentless Exception Monitoring

· Configuring Client Monitoring
· Configuring Group Policy

Module 8: Audit Collection Services

This module explains how to configure Audit Collection Services so that security auditing can be centralized within the organization.

Lessons

· Audit Collection Services Overview
· Installing Audit Collection Services
· Configuring Forwarders and Collectors

Lab : Configuring ACS Reports

· Configuring ACS Reporting

Module 9: Using Operations Manager 2007 Command Shell

This module explains how to use the new Windows PowerShell-based commands to manage the management group.

Lessons

· Command Shell Overview
· Using Command Shell with Operations Manager 2007

Lab : Using the Command Shell

· Running Individual Commands
· Scripting Commands

Module 10: Complex Environments

This module explains how to multi-home agents, work with agents in untrusted domains and configure a hierarchy of management groups.

Lessons

· Multi-homing Agents
· Untrusted Environments
· Multi-tiered Environments

Lab : Connecting Management Groups

· Configure Subscriptions
· Configure Operator Accounts

After completing this module, students will be able to:

· Multihome an agent
· Create a connector to another management group
· Create a connector subscription to a third-party management product

Module 11: Migrating from MOM 2005 to Operations Manager 2007

This module explains how to use the tools required to migrate the agents and setting from the MOM 2005 management group to the Operations Manager 2007 management group.

Lessons

· Migration Overview
· Using the Migration Tool
· Converting Management Packs

Lab : Converting Management Packs

· Using the Migration Tool

View the AmeriTeach SCOM Training Course Schedule

Find out more about Windows Server 2008 Training

Visit the AmeriTeach Website

Posted on Monday, February 15, 2010 at 08:41AM by

Sharon Toler |

Post a Comment

Updated- Course 6416 Updating your Active Directory Technology Skills to WIndows Server 2008 at AmeriTeach - Denver, Colorado 80111

Updating your Active Directory Technology Skills to Windows Server 2008

Course 6416: Five days; Instructor-Led

About this Course

This course will provide you with the knowledge and skills to work with network infrastructure and Active Directory technologies in Windows Server 2008.

Audience Profile

This course is intended for individuals who already have experience with Network Infrastructure and Active Directory technologies in Windows Server 2000 or Windows Server 2003, and who wish to upgrade their skills to Windows Server 2008.
Typical students include people who have at least one year of experience implementing and administering a network operating system and IT Professionals who work in medium and enterprise organizations with the knowledge and skills to design, implement, and manage a Windows Server 2000 or Windows Server 2003 infrastructure.

Before attending this course, students must have:

• Experience planning, implementing, managing, maintaining, and securing Windows Server 2000 or 2003, including Active Directory and Network Infrastructure server roles.
• Working knowledge of networking, for example, TCP/IP and Domain Name System (DNS).
• Experience installing, configuring, and administering Windows 2000 Server, Windows Server 2003, Windows XP Professional, or Windows Vista.
• MCSA on Windows Server 2003 or MCSE on Windows Server 2003 is recommended.

At Course Completion

After completing this course, students will be able to:
• Install and configure Windows Server 2008.
• Configure Windows Deployment Services (WDS).
• Configure networking and network services.
• Configure Network Policy Server (NPS) and remote access.
• Configure Network Access Protection (NAP).
• Configure Active Directory Domain Services (AD DS).
• Manage Active Directory Domain Services (AD DS).
• Configure Active Directory Lightweight Services (AD LDS).
• Configure Active Directory Certificate Services (AD CS).
• Configure Active Directory Federation Services (AD FS).
• Configure Active Directory Rights Management Services (AD RMS).
• Implement Software Maintenance by using Windows Server Update Services (WSUS).
• Configure storage technologies in Windows Server 2008.
• Configure high availability in Windows Server 2008.
• Configure virtualization in Windows Server 2008.

Course OutlineModule 1: Installing and Configuring Windows Server 2008This module describes how to prepare for and perform an installation of Windows Server 2008. This module also provides details on how to manage the various server roles and Server Core in Windows Server 2008.Lessons

· Installing Windows Server 2008
· Managing Server Roles and Features
· Configuring Windows 2008 Server Core

Lab : Installing and Configuring Windows Server 2008

· Installing and Configuring Server Roles and Features
· Configuring Server Core and Performing Basic Management Tasks

After completing this module, students will be able to:

• Install Windows Server 2008.
• Manage Server roles and features.
• Configure Windows 2008 Server Core.

Module 2: Configuring Windows Deployment ServicesThis module provides an overview of the Windows installation technologies. This module also describes how to create images for WDS. Finally, the module explains the procedures for deploying images by using WDS.Lessons

· Overview of Windows Installation Technologies
· Preparing Images for WDS
· Deploying Images using WDS

Lab : Configuring Windows Deployment Services

· Installing and Configuring WDS
· Adding Images to WDS
· Creating an Answer File for the WDS client
· Deploying an Image with WDS

After completing this module, students will be able to:

• Describe Windows Deployment Services in Windows Server 2008.
• Manage operating system images in the WIM image format.
• Deploy images with Windows Deployment Services.

Module 3: Configuring Networking and Network ServicesThis module describes how to configure IPv6 addressing and how to migrate from IPv4 to IPv6. Additionally, the module examines the new features in DHCP and DNS, the configuration and management of Windows Firewall. Finally, the module covers the basic concepts for wireless connectivity and the authentication options for wireless networks, and then describes how to configure wireless network settings in Group Policy.Lessons

· Configuring IP v6 Addressing
· Migrating from IPv4 to IPv6
· Configuring DHCP and DNS
· Configuring Windows Firewall
· Configuring Wireless Networks

Lab : Configuring Networking and Network Services

· Configuring an ISATAP Router
· Configuring DHCP and DNS
· Configuring Windows Firewall

After completing this module, students will be able to:

• Configure IPv6 addressing.
• Describe coexistence and migration from IPv4 to IPv6 addressing.
• Configure DHCP and DNS services.
• Configure Windows Firewall.
• Configure Wireless Networks.

Module 4: Configuring Network Policy Server and Remote Access ServicesThis module provides an overview of NPS as a RADIUS compliant server and client. The module then describes how to configure NPS and remote access.Lessons

· Overview of Network Policy Server
· Configuring Network Policy Server
· Configuring Remote Access

Lab : Configuring Network Policy Server and Remote Access Services

· Deploying Network Policy Server
· Configuring SSTP VPN

After completing this module, students will be able to:

• Understand the purpose of the Network Policy and Access Services server role
• Configure Network Policy Server (NPS)
• Configure Routing and Remote Access Service (RRAS)
• Configure remote access.

Module 5: Configuring Network Access ProtectionThis module provides an overview of Network Access Protection (NAP) and the various NAP enforcement methods such as IPsec, 802.1x, VPN, and DHCP enforcements. The module also describes how to implement NAP using System Health Validators (SHVs), health policies, remediation server groups, and NAP tracing. The module also provides details on implementing IPsec enforcement for NAP.Lessons

· Overview of Network Access Protection
· Implementing NAP
· Implementing IPSec Enforcement for NAP

Lab : Configuring Network Access Protection

· Configuring NAP for VPN Clients
· Configuring NAP for IPSec Enforcement

After completing this module, students will be able to:

• Describe the role of NAP.
• Install, configure, and monitor NAP.
• Implement IPsec enforcement for NAP.

Module 6: Configuring Active Directory Domain ServicesThis module describes the requirements and procedures for installing domain controllers and then explains how to deploy read-only domain controllers (RODCs). The module also describes how to implement fine-grained password policies. Additionally, the module covers the new features in Group Policy and provides an overview of Group Policy preferences.Lessons

· Installing Domain Controllers
· Configuring Read-Only Domain Controllers
· Configuring Fine-Grained Password Policies
· New Features in Group Policy
· Configuring Group Policy Preferences

Lab : Configuring Active Directory Domain Services

· Installing and Configuring an RODC
· Implementing Fine-Grained Password Policies

Lab : Exploring New Features in Group Policy

· Creating a Central Store
· Configuring Administrative Templates
· Configuring Preferences

After completing this module, students will be able to:

• Install domain controllers.
• Configure read-only domain controllers.
• Configure fine-grained password policies.
• Describe the new features in Group Policy.
• Configure Group Policy preferences.

Module 7: Managing Active Directory Domain ServicesThis module explains how to use the various tools included in Windows Server 2008 to monitor and manage events related to AD DS. The module then describes how to configure AD DS auditing and to maintain AD DS by using the Windows Server 2008 built-in tools.Lessons

· Managing Events
· Configuring AD DS Auditing
· Monitoring AD DS
· Maintaining AD DS

Lab : Managing Active Directory Domain Services

· Monitoring AD DS by Using Event Viewer
· Creating a Subscription
· Configuring AD DS Auditing
· Reanimating Deleted Objects

After completing this module, students will be able to:

• Manage events.
• Configure Active Directory Domain Services (AD DS) auditing.
• Monitor AD DS.
• Maintain AD DS.

Module 8: Configuring Active Directory Lightweight Directory ServicesThis module describes how to install and configure AD LDS. The module explains the procedures for configuring AD LDS instances, AD LDS replication, and AD LDS integration with AD DS.Lessons

· Installing and Configuring AD LDS
· Configuring AD LDS Instances
· Configuring AD LDS Replication
· Configuring AD LDS Integration with AD DS

Lab : Configuring Active Directory Lightweight Directory Services

· Configuring an AD LDS Instance and an Application Partition
· Configuring the AD LDS Access Control
· Configuring AD LDS Replication
· Adding AD DS Users to AD LDS Groups

After completing this module, students will be able to:

• Install and configure AD LDS.
• Configure AD LDS instances.
• Configure AD LDS replication.
• Configure AD LDS integration with AD DS.

Module 9: Configuring Active Directory Certificate ServicesThis module describes how to deploy and configure the Active Directory Certificates Services in Windows Server 2008. The module covers the procedures for managing certificate templates, certificate enrollment, certificate revocation, and certificate recovery.Lessons

· Deploying Active Directory Certificate Services
· Managing Certificate Templates
· Managing Certificate Enrollment
· Managing Certificate Revocation
· Managing Certificate Recovery

Lab : Configuring and Managing Active Directory Certificate Services

· Installing the AD CS Server Role and Configuring CAs
· Managing Certificate Revocation
· Managing Certificate Recovery

After completing this module, students will be able to:

• Deploy AD CS infrastructure.
• Manage certificate templates.
• Manage certificate enrollment.
• Manage certificate revocation.
• Manage certificate recovery.

Module 10: Configuring Active Directory Federation ServicesThis module provides an overview of identity federation and federation trusts. The module covers the various features and components of AD FS and the options, requirements, and procedure for deploying it. Finally, the module describes the various types of AD FS claims and the procedure for configuring AD FS claim mapping.Lessons

· Overview of AD FS
· Deploying AD FS
· Implementing AD FS Claims

Lab : Configuring AD FS for the Federated Web SSO Scenario

· Installing the AD FS Server Role
· Configuring Certificate Requirements
· Configuring the AD FS Web Agent
· Configuring the Web Server Application on the NWTDC01 Virtual machine
· Configuring the Federation Trust Policies
· Configuring the Account Partner Federation Service
· Configuring the Resource Partner Federation Service
· Testing the AD FS Implementation

After completing this module, students will be able to:

• Describe the features and functionality of AD FS.
• Deploy AD FS.
• Implement AD FS claims.

Module 11: Configuring Active Directory Rights Management ServicesThis module provides an overview of AD RMS features and functionality. The module then describes the requirements and procedures for deploying AD RMS servers and clients. Additionally, the module explains how to administer AD RMS templates and policies.Lessons

· Overview of Active Directory Rights Management Services
· Deploying AD RMS
· Administering AD RMS Templates
· Administering AD RMS Policies

Lab : Configuring Active Directory Rights Management Services

· Installing the AD RMS Server Role
· Managing AD RMS Rights Policy Templates
· Configuring Trust Policies
· Testing AD RMS Functionality

After completing this module, students will be able to:

• Describe Active Directory Rights Management Services (AD RMS).
• Deploy AD RMS.
• Administer AD RMS templates.
• Administer AD RMS policies.

Module 12: Software Maintenance Using Windows Server Update ServicesThis module provides an overview of WSUS and its features. The module also describes the requirements and procedures for installing, configuring, and managing WSUS.Lessons

·
· Installing and Configuring WSUS
· Managing WSUS

Lab : Maintaining Software by Using Windows Server Update Services

· Installing WSUS Prerequisites
· Installing WSUS
· Restoring a WSUS Database
· Creating a Computer Group and Managing Updates

After completing this module, students will be able to:

• Provide an overview of WSUS.
• Install and configure WSUS.
• Manage the WSUS infrastructure.

Module 13: Configuring Storage Technologies in Windows Server 2008This module describes how to configure the Distributed File System (DFS) in Windows Server 2008. The module then explains how to manage storage by using File System Resource Manager (FSRM). Finally, the module covers how to configure storage are network (SAN) connectivity.Lessons

· Configuring Distributed File System
· Managing Storage with File System Resource Management
· Configuring Storage Area Network Connectivity

Lab : Configuring Storage Technologies in Windows Server 2008

· Installing and Configuring the DFS Role Service
· Installing and Configuring the File Server Resource Manager Role Service

After completing this module, students will be able to:

• Configure DFS.
• Manage storage by using File System Resource Management.
• Describe storage area network connectivity.

Module 14: Configuring High Availability in Windows Server 2008This module describes the various options available in Windows Server 2008 that you can use to provide highly available network services. The module covers options such as Network Load Balancing (NLB) and Failover Clustering.Lessons

· Configuring Network Load Balancing
· Overview of Windows Server 2008 Failover Clusters
· Preparing for Failover Clusters
· Creating and Configuring Failover Clusters

Lab : Configuring High Availability in Windows Server 2008

· Creating and Validating a Cluster
· Clustering the Print Services Role by Using Failover Cluster Management
· Configuring Cluster Resources

After completing this module, students will be able to:

• Configure NLB.
• Describe how failover clusters work in Windows Server 2008.
• Prepare your environment for failover clustering.
• Create and configure failover clusters.

Module 15: Configuring Virtualization in Windows Server 2008This module provides an overview of virtualization in Windows Server 2008 and the features and architecture of Microsoft Hyper-V. The module also describes the requirements and considerations for installing Hyper-V. Finally, the module covers how to configure and manage virtual machines in Windows Server 2008 Hyper-V.Lessons

· Overview of Hyper-V
· Installing Hyper-V
· Configuring Hyper-V
· High Availability in a Hyper-V Environment

Lab : Configuring a Hyper-V Environment

· Configuring Hyper-V Settings
· Creating and Configuring Virtual Networks
· Creating Virtual Hard Disks
· Creating and Managing Virtual Machines

After completing this module, students will be able to:

• Describe Hyper-V and identify its key features.
• Install Hyper-V.
• Configure Hyper-V settings.
• Configure highly available virtual machines.

View the AmeriTeach Microsoft Windows Server 2008 Training Course Schedule

Find out more about Windows Server 2008 Training

Visit the AmeriTeach Website

Posted on Monday, February 15, 2010 at 08:33AM by

Sharon Toler |

Post a Comment

SQLServer 2005 Training at AmeriTeach- Denver Colorado 80111

Writing Queries Using SQL Server 2005 Transact-SQL

Course 2778-05: Three days - Instructor-Led

About this Course

This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2005.

Audience Profile

This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.

At Course Completion

After completing this course, students will be able to:

Describe the uses of and ways to execute the Transact-SQL language.
Use querying tool.
Write SELECT queries to retrieve data.
Group and summarize data by using Transact-SQL.
Join data from multiple tables.
Write queries that retrieve and modify data by using subqueries.
Modify data in tables.
Query text fields with full-text search.
Describe how to create programming objects.
Use various techniques when working with complex queries.

To get the most out of this course, you should:

Be familiar with a programming or scripting language.
Understand relational databases and the concept of data normalization

This course also helps prepare you for certification exam 70-431.

Course OutlineModule 1: Getting Started with Databases and Transact-SQL in SQL Server 2005

The student will be introduced to how client/server architecture works, and examine the various database and business tasks that can be performed by using the components of SQL Server 2005. The student will also be introduced to SQL Server database concepts such as relational databases, normalization, and database objects. In addition, the student will learn how to use T-SQL to query databases and generate reports.

Lessons

· Overview of SQL Server 2005
· Overview of SQL Server Databases
· Overview and Syntax Elements of T-SQL
· Working with T-SQL Scripts
· Using T-SQL Querying Tools

Lab : Using SQL Server Management Studio and SQLCMD

· Exploring the Components and Executing Queries in SQL Server Management Studio
· Starting and Using SQLCMD
· Generating a Report from a SQL Server Database Using Microsoft Office Excel

After completing this module, students will be able to:

Describe the architecture and components of SQL Server 2005.
Describe the structure of a SQL Server database.
Explain the basics of the SQL language.
Describe the syntax elements of T-SQL.
Explain how to manage T-SQL scripts.
Use T-SQL querying tools to query SQL Server 2005 databases.

Module 2: Querying and Filtering Data

The students will be introduced to the basic Transact-SQL (T-SQL) statements that are used for writing queries, filtering data, and formatting result sets.

Lessons

· Using the SELECT Statement
· Filtering Data
· Working with NULL Values
· Formatting Result Sets
· Performance Considerations for Writing Queries

Lab : Querying and Filtering Data

· Retrieving Data by Using the SELECT Statement
· Filtering Data by Using Different Search Conditions
· Using Functions to Work with NULL Values
· Formatting Result Sets

After completing this module, students will be able to:

Retrieve data by using the SELECT statement.
Filter data by using different search conditions.
Explain how to work with NULL values.
Format result sets.
Describe the performance considerations that affect data retrieval.

Module 3: Grouping and Summarizing Data

The students will learn to group and summarize data when generating reports in Microsoft SQL Server 2005 by using aggregate functions and the COMPUTE clause.

Lessons

· Summarizing Data by Using Aggregate Functions
· Summarizing Grouped Data
· Ranking Grouped Data
· Creating Crosstab Queries

Lab : Grouping and Summarizing Data

· Summarizing Data by Using Aggregate Functions
· Summarizing Grouped Data
· Ranking Grouped Data
· Creating Crosstab Queries

After completing this module, students will be able to:

Summarize data by using aggregate functions.
Summarize grouped data by using the GROUP BY and COMPUTE clauses.
Rank grouped data.
Create cross-tabulation queries by using the PIVOT and UNPIVOT clauses.

Module 4: Joining Data from Multiple Tables

The students will learn to write joins to query multiple tables, as well as limiting and combining result sets.

Lessons

· Querying Multiple Tables by Using Joins
· Applying Joins for Typical Reporting Needs
· Combining and Limiting Result Set

Lab : Joining Data from Multiple Tables

· Querying Multiple Tables by Using Joins
· Applying Joins for Typical Reporting Needs
· Combining and Limiting Result Sets

After completing this module, students will be able to:

Query multiple tables by using joins.
Apply joins for typical reporting needs.
Combine and limit result sets.

Module 5: Working with Subqueries

The students will be introduced to basic and correlated subqueries and how these compare with joins and temporary tables. The students will also be introduced to using common table expressions in queries.

Lessons

· Writing Basic Subqueries
· Writing Correlated Subqueries
· Comparing Subqueries with Joins and Temporary Tables
· Using Common Table Expressions

Lab : Working with Subqueries

· Writing Basic Subqueries
· Writing Correlated Subqueries
· Comparing Subqueries with Joins and Temporary Tables
· Using Common Table Expressions

After completing this module, students will be able to:

Write basic subqueries.
Write correlated subqueries.
Compare subqueries with joins and temporary tables.
Use common table expressions in queries.

Module 6: Modifying Data in Tables

The students will be able to modify the data in tables by using the INSERT, DELETE, and UPDATE statements. In addition, students will examine how transactions work in a database, the importance of transaction isolation levels, and how to manage transactions.

Lessons

· Inserting Data into Tables
· Deleting Data from Tables
· Updating Data in Tables
· Overview of Transactions

Lab : Modifying Data in Tables

· Inserting Data into Tables
· Deleting Data from Tables
· Updating Data in Tables
· Working with Transactions

After completing this module, students will be able to:

Insert data into tables.
Delete data from tables.
Update data in tables.
Describe transactions.

Module 7: Querying Metadata, XML, and Full-Text Indexes

The students will learn to query semi-structured and unstructured data. The students will also learn how SQL Server 2005 handles XML data and will query XML data. The students will also be introduced to full-text indexing in SQL Server 2005.

Lessons

· Querying Metadata
· Overview of XML
· Querying XML Data
· Overview of Full-Text Indexes
· Querying Full-Text Indexes

Lab : Querying Metadata, XML, and Full-Text Indexes

· Querying Metadata
· Querying XML Data
· Creating and Querying Full-Text Indexes

After completing this module, students will be able to:

Query metadata.
Describe the functionality of XML.
Query XML data.
Describe the functionality of full-text indexes.
Query full-text indexes.

Module 8: Using Programming Objects for Data Retrieval

The students will be introduced to user-defined functions and executing various kinds of queries by using user-defined functions. The students will be introduced to SQL Server views that encapsulate data and present users with limited and relevant information. In addition, the students will be introduced to SQL Server stored procedures and the functionalities of the various programming objects. The students will learn how to perform distributed queries and how SQL Server works with heterogeneous data such as databases, spreadsheets, and other servers.

Lessons

· Overview of Views
· Overview of User-Defined Functions
· Overview of Stored Procedures
· Overview of Triggers
· Writing Distributed Queries

Lab : Using Programming Objects for Data Retrieval

· Creating Views
· Creating User-Defined Functions
· Creating Stored Procedures
· Writing Distributed Queries

After completing this module, students will be able to:

Encapsulate queries by using views.
Encapsulate expressions by using user-defined functions.
Explain how stored procedures encapsulate T-SQL logic.
Define triggers, types of triggers, create a trigger.
Write distributed queries.

Module 9: Using Advanced Querying Techniques

The students will be introduced to best practices for querying complex data. The students will also examine how to query complex table structures such as data stored in hierarchies and self-referencing tables. The students will analyze the recommended guidelines for executing queries and how to optimize query performance.

Lessons

· Considerations for Querying Data
· Working with Data Types
· Cursors and Set-Based Queries
· Dynamic SQL
· Maintaining Query Files

Lab : Using Advanced Querying Techniques

· Using Execution Plans
· Converting Data Types
· Implementing a Hierarchy
· Using Cursors and Set-Based Queries

After completing this module, students will be able to:

Explain the recommendations for querying complex data.
Query complex table structures.
Write efficient queries.
Use various techniques when working with complex queries.
Maintain query files.

View the AmeriTeach Microsoft SQL Server Training Course Schedule

Visit the AmeriTeach Website

Posted on Monday, February 15, 2010 at 08:15AM by

Sharon Toler |

Post a Comment

Training Room Rentals with Computers at AmeriTeach - Denver, CO 80111

Are you looking for a training room classroom rental in the Denver or DTC area?

AmeriTeach offers state-of-the-art Denver Tech Center training rooms that are equipped to provide a first class learning experience.

Our rooms are spacious, well equipped, have comfortable seating, and feature bright dlp display projectors.

Our training facility has easy access from I-25 & Orchard Road (westbound exit) Map. And we are located steps away from the Orchard Light Rail Station

We are located adjacent to the Doubletree Hotel Denver Tech
For pricing and availability, please call 720-346-1710 or visit:

http://www.ameriteach.com/Rentals/

If you have any additional questions, please email or call Connie Greer in our office at 720.346.1710 ext 25.

Posted on Friday, February 5, 2010 at 11:10AM by

Sharon Toler |

Post a Comment

MDX Training at AmeriTeach - Denver, CO 80111

MDX for Analysis and Reporting Services

Course 2800: Three days; Instructor-Led

Course Outline

MDX is the fundamental language of Analysis Services – it’s the SQL of the multi-dimensional environment. From the expressions that generate the most valuable business metrics to KPIs, dynamic security, and report queries your ability to effectively use MDX will dictate how much of Analysis Service’s power you are able to unleash.

Though the Multidimensional Expressions (MDX) language can at first appear to be mysterious and complex, there are a few fundamental concepts that form the basis for understanding how MDX works and how it should be used in your solution.

In the first two days of this course we’ll use demonstrations and hands-on labs to first understand then use these fundamental concepts to develop MDX expressions, implement security, and define KPIs.

In the third day of this course we’ll use demonstrations and hands-on labs to first understand then develop optimized MDX queries for Reporting Services.

Target Audience

Business Intelligence Designers, Developers, Analysts and Consultants currently working with or considering Microsoft SQL Server Analysis and Reporting Services.

Prerequisites

This is a fast-paced course encompassing MDX from fundamentals to advanced concepts. Experience with Microsoft SQL Server Analysis Services is recommended for this challenging course but prior experience with MDX is not required. Experience with Reporting Services is recommended but not required for those attending the full three day course.

Objective

Attendees completing this course will:

· Understand the fundamental concepts of MDX
· Understand how and where MDX is used in an Analysis Services solution
· Be able to create Calculated Members and KPIs in an Analysis Services cube
· Be able to write MDX queries for reporting and validation
· Understand how MDX is used to implement security
· Understand how to generate and optimize MDX queries in Reporting Services

Course Outline (Day 1 – 2)

Introduction

Introduction of the instructor and students as well as an overview of the course agenda, class hours and other housekeeping items.

Module 1: Solution Overview

Sets the conceptual framework for understanding MDX as an intersection-based language and where MDX is used within a BI Solution. Also uses a SQL-MDX comparison to help students understand differences and similarities between the two query languages.

Module Agenda:

· Understanding the Excel Paradigm
· SQL – MDX Comparison
· MDX Usage Overview

Module 2: Using the BI Toolset

This module is an introduction to BIDS and Management Studio with an emphasis on how and by whom these tools are used in a BI solution. Emphasis is placed on functionality specific to BI including: running MDX queries in Mgmt Studio and importing SSAS databases to create project files.

Module Agenda:

· Introducing Adventure Works
· Introducing BIDS and The Management Studio

Module 3: MDX Language Fundamentals

Using primarily group activities this module introduces the fundamentals of creating MDX queries. In addition to introducing basic syntax a key emphasis of this module is to show students how queries can be an efficient and effective way to develop and validate Calculated Members.

Module Agenda:

· MDX Overview
· MDX Query Context and Execution
· Dimensional Intersections (Tuples)
· Attribute and User Hierarchies
· Creating Simple MDX Queries
· Complete and Partial Tuples
· Using Familial Relationships
· Hierarchy Navigation
· Handling Exceptions
· Null Handling
· Set Functions
· IIF / CASE expressions
· WITH clause to define Calculations and Sets

Module 4: Solving Business Problems with MDX

Building on the previous module, this module focuses on using MDX queries to solve standard business requirements that apply to many analytical applications.

Module Agenda:

· Ratios
· Sums and Differences
· Allocations
· Averages
· Time based Calculations
· Defining a sub-cube using the SCOPE statement

Module 5: Creating Key Performance Indicators

This module uses MDX functionality presented in previous modules as well as the KPI specific functions KPIValue, KPIGoal, KPIStatus, and KPITrend to understand and create Key Performance Indicators in BIDS.

Module Agenda:

· KPI Overview
· Creating KPIs
· Using the KPI Viewer

Module 6: Implementing Basic Security

This module introduces the concept of implementing data access controls using MDX expressions.

Module Agenda:

· Overview Role Based Security
· Defining Dimension Data Security
· Controlling access to Cells based on Dimension members

Module 7: Optimizing MDX Queries and Expressions

This final module is a discussion of best practices for optimizing and benchmarking MDX queries.

Module Agenda:

· Benchmarking Performance
· Best Practices for Optimizing Performance

Course Outline (Day 3)

Module 8: Using the Analysis Services Query Designer

The Analysis Services Query Designer gives developers the ability to write reports based on an Analysis Services data source without having to understand MDX. This module explores the report development using the Design Mode of the Analysis Services Query Designer.

Module Agenda:

· Analysis Services Query Designer Overview
· Building a Basic Query
· Adding Filters and Parameters

Module 9: Using MDX in the Analysis Services Query Designer

In this module, students apply the learning from the previous module by using MDX in both the Design Mode and the Query Mode of the Analysis Services Query Designer. This module also introduces additional features of the Analysis Services Query Designer facilitating query development.

Module Agenda:

· Using the Calculated Members Pane in Design Mode
· Understanding Query Structure Requirements for Reporting Services
· Using Metadata, Function Templates, and Calculation Templates in Query Mode
· Adding Filters to a Query

Module 10: Using Analysis Services Features in Report Design

After learning how to retrieve data Analysis Services by using an MDX query, students are ready to interact with Analysis Services features in the report design process. This module shows students how to work with detail and aggregated data in the result set, how to use server-side formatting properties to control the report appearance, and how to display key performance indicators defined in a cube.

Module Agenda: