Mr. DiGi's List: Školení

Introduction to Microsoft SQL Server Analysis Services

  
• Overview of Data Analysis Solutions
 
• Overview of SQL Server Analysis Services
 
• Installing SQL Server Analysis Services
  

Creating Multidimensional Analysis Solutions

  
• Developing Analysis Services Solutions
 
• Creating Data Sources and Data Source Views
 
• Creating a Cube
  

Working with Cubes and Dimensions

  
• Configuring Dimensions
 
• Defining Attribute Hierarchies
 
• Sorting and Grouping Attributes
  

Working with Measures and Measure Groups

  
• Working With Measures
 
• Working with Measure Groups
  

Querying Multidimensional Analysis Solutions

  
• MDX Fundamentals
 
• Adding Calculations to a Cube
  

Customizing Cube Functionality

  
• Implementing Key Performance Indicators (KPI)
 
• Implementing Actions
 
• Working with Perspectives
 
• Working with Translations
  

Deploying and Securing an Analysis Services Database

  
• Deploying an Analysis Services Database
 
• Securing an Analysis Services Database
  

Maintaining a Multidimensional Solution

  
• Configuring Processing
 
• Logging, Monitoring, and Optimizing an Analysis Services Solution
 
• Backing Up and Restoring an Analysis Services Database
  

Introduction to Data Mining

  
• Overview of Data Mining
 
• Creating a Data Mining Solution
 
• Validating Data Mining Models

Creating Databases and Database Files

  
• Creating Databases
 
• Creating Filegroups
 
• Creating Schemas
 
• Creating Database Snapshots
  

Creating Data Types and Tables

  
• Creating Data Types
 
• Creating Tables
 
• Creating Partitioned Tables
  

Creating and Tuning Indexes

  
• Planning Indexes
 
• Creating Indexes
 
• Optimizing Indexes
  

Implementing Data Integrity by Using Constraints and Triggers

  
• Data Integrity Overview
 
• Implementing Constraints
 
• Implementing Triggers
  

Using XML

  
• Using the XML Data Type
 
• Retrieving XML by Using FOR XML
 
• Shredding XML by Using OPENXML
 
• Introducing XQuery
 
• Creating XML Indexes
 
• Implementing XML Schemas
  

Implementing Views

  
• Introduction to Views
 
• Creating and Managing Views
 
• Optimizing Performance by Using Views
  

Implementing Stored Procedures

  
• Using Stored Procedures
 
• Creating Parameterized Stored Procedures
 
• Working With Execution Plans
 
• Handling Exceptions
  

Implementing Functions

  
• Introducing Functions
 
• Working with Functions
 
• Controlling Execution Context
  

Implementing Managed Code in the Database

  
• Introduction to the SQL Server Common Language Runtime
 
• Importing and Configuring Assemblies
 
• Creating Managed Database Objects
  

Managing Transactions and Locks

  
• Overview of Transactions and Locks
 
• Managing Transactions
 
• Understanding SQL Server Locking Architecture
 
• Managing Locks
  

Using Service Broker

  
• Service Broker Overview
 
• Creating Service Broker Objects
 
• Sending and Receiving Messages

Introduction to Microsoft SQL Server Reporting Services

  
• Overview of SQL Server Reporting Services
 
• Installing Reporting Services
 
• Reporting Services Tools
 

Authoring Basic Reports

  
• Creating a Basic Table Report
 
• Formatting Report Pages
 
• Calculating Values
  

Enhancing Basic Reports

  
• Interactive Navigation
 
• Displaying Data
  

Manipulating Data Sets

  
• Defining Report Data
 
• Using Parameters and Filters
 
• Using Parameter Lists
  

Using Report Models

  
• Creating Report Models
 
• Using Report Builder
  

Publishing and Executing Reports

  
• Publishing Reports
 
• Executing Reports
 
• Creating Cached Instances
 
• Creating Snapshots and Report History
  

Using Subscriptions to Distribute Reports

  
• Introduction to Report Subscriptions
 
• Creating Report Subscriptions
 
• Managing Report Subscriptions
  

Administering Reporting Services

  
• Reporting Server Administration
 
• Performance and Reliability Monitoring
 
• Administering Report Server Databases
 
• Security Administration
 
• Upgrading to Reporting Services in Microsoft SQL Server 2008
  

Programming Reporting Services

  
• Querying for Server Information Using a Web Service
 
• Automating Report Management
 
• Rendering Reports
 
• Creating Custom Code

Introduction to Business Intelligence

  
• Why?
 
• Basics of Data Warehousing.
 
• What is what in the BI world.
 
• Introduction to building BI projects on SQL Server 2005/2008
 

Integration Services

  
• Creating simple package
 
• Implementing control flow
 
• Implementing data flow
  

Reporting Services

  
• Authoring Reports
 
• Publishing Reports
 
• Reporting services capabilities
  

Analysis Services

  
• Building and deploying Analysis Services solution
 
• Analysis services capabilities
   

Data Mining

  
• Why?
 
• Terms in Data Mining
  

Clients

 
• Excel 2007
 
• Performance Point Server 2007 demontration