SQL Server Database Development
USQLT Querying SQL Server with Transact-SQL
2 days This course provides students with the technical skills required to write Transact-SQL queries for Microsoft SQL Server. USQLD
Topics: Introduction to Transact-SQL. Using Transact-SQL Querying Tools. Retrieving Data.Grouping and Summarizing 5-day Course
Data. Joining Multiple Tables. Working with Subqueries. Modifying Data. T-SQL extensions. Introduction to Developing and
Programming Objects. optimizing
SQL Server 2008
USQLD Developing and optimizing databases using SQL Server 2008/2012
5 days This course focuses on using the SQL Server database to develop applications. It discusses basic as well as some of
the advanced features of SQL Server. Topics: Introduction to SQL Server and its Toolset. Working with Data Types. + EXAM 70-433
Designing and Implementing Tables. Designing and Implementing Views. Planning for SQL Server Indexing.
Implementing Table Structures in SQL Server. Reading SQL Server Execution Plans. Improving Performance through
Non-clustered Indexes. Designing and Implementing Stored Procedures. Merging Data and Passing Tables. Creating
Highly Concurrent SQL Server Applications. Handling Errors in T-SQL Code. Designing and Implementing User-
Defined Functions. Ensuring Data Integrity through Constraints. Responding to Data Manipulation via Triggers. SQL Server 2008
Implementing Managed Code in SQL Server. Topics upon request: Storing XML Data in SQL Server. Querying XML Database Development
Data in SQL Server. Working with SQL Server Spatial Data. Working with Full-Text Indexes and Queries. See page 32.
SQL Server Database Administration
USQLA Administering Databases and Servers using SQL Server 2008/2012
5 days This course focuses on installing, configuring and maintaining a SQL server 2012 or SQL Server 2008 database. Topics: USQLA
Introduction to SQL Server and its Toolset. Preparing Systems for SQL Server . Installing and Configuring SQL Server.
Working with Databases. Understanding SQL Server Recovery Models. Backup of SQL Server Databases. Restoring SQL Administering Databases
and Servers using
Server Databases. Importing and Exporting Data. Authenticating and Authorizing Users. Assigning Server and SQL Server 2008
Database Roles. Authorizing Users to Access Resources. SQL Server Environments. Automating SQL Server
Management. Configuring Security for SQL Server Agent. Monitoring SQL Server with Alerts and Notifications.
Performing Ongoing Database Maintenance. Tracing Access to SQL Server. Monitoring SQL Server. Managing Multiple
+ EXAM 70-432
Servers. See page 32.
SQL Server 2008
Upgrade to SQL Server 2012
USQLUP What's new in SQL Server 2012
5 days SQL Server 2012 contains many improvements as well as complete new features in administration, development as well as the business intelligence functionality.
Developer and administration. Topics: FileTables, SQL Server Developer Tools, Full Text Improvements, ColumnStore indexes, UTF-16 support, THROW keyword, ORDER
BY paging, Contained databases, restore GUIs, AlwaysOn Availability groups and failover clusters, security improvements. BI Topics: Data Quality Services, SSIS project
deployment model, ODBC source and destination, Change Data capture support, GUI improvements in SSIS, developing tabular models, working with DAX, PowerView,
Data alerts. See page 33.
30 : www.u2u.net & + 32 2 466 00 16 + email@example.com
SQL Server Business Intelligence
USQLBI Overview of SQL Server 2008/2012 Business Intelligence
5 days In this course, you get an overview of the features of the server side Business Intelligence tools that Microsoft ships with USQLAS
SQL Server: Integration Services, Analysis Services and Reporting Services. Besides these, we briefly discuss smaller serv- 5-day Course
ices that can help you building your BI infrastructure: Master Data Services and Data Quality Services. See page 34. Microsoft SQL
Design, Build and Administer Data Warehouses with SQL Server Integration Services 2008
5 days Students will learn both the theory behind data warehouse design, as well as hands-on experience with Microsoft SQL
Server Integration Services, which can be used to load and maintain the data in a data warehouse. Topics: The need for
a data warehouse, dimensional modeling, building a time dimension, slowly changing dimensions, advanced dimension-
al modeling, integration services introduction, data flow, control flow, debugging packages, scripting, checkpoints,
transactions, integration services performance tuning, deployment, administration. See page 35. USQLIS
Implementing Data Warehouses with Integration Services 2012 Microsoft SQL Server
USQLIS12 Integration Services
5 days Students will learn how to create a data warehouse with SQL Server 2012, implement ETL with SQL Server Integration
Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
Topics: Introduction to Data Warehousing. Data Warehouse Hardware Considerations. Designing and Implementing a
Data Warehouse. Design and implement a schema for a data warehouse. Implementing Control Flow in an SSIS
Package. Debugging and Troubleshooting SSIS Packages. Implementing an Incremental ETL Process. Incorporating Data
from the Cloud in a Data Warehouse. Enforcing Data Quality. Using Master Data Services. Extending SSIS. Deploying USQLRS
and Configuring SSIS Packages. Consuming Data in a Data Warehouse. 5-day Course
Microsoft SQL Server
USQLAS SQL Server 2008/2012 Analysis Services Reporting Services
5 days OLAP (OnLine Analytical Processing) cubes provide performant aggregation querying over large amounts of data in a 2008 (including R2)
user-friendly way. In this course, you learn how to build, maintain and query OLAP cubes with Microsoft SQL Server
Analysis Services. Topics: Introduction, Loading the relational data, building and deploying basic cubes, browsing the
data, aggregation desing, processing cbes and dimensions, multi-dimesnional expressions (MDX), key performance indi- + EXAM 70-448
cators (KPI), translations, actions, perspectives, special dimensions, the other faces of SSAS, administration. See page 35.
USQLMDX SQL Server 2008/2012 - Implementing Business Solutions with MDX
3 days This course provides students with the knowledge and skills necessary to use multidimensional expressions (MDX) to
add calculated members, named sets and other calculated values to a Microsoft SQL Server Analysis Services cube. SQL Server 2008
Topics: Using multidimensional terminology. Adding calculated members to a cube. Using MDX member functions to Development
navigate within a hierarchy. Working with tuples. Using MDX time functions to compare values over time. Using MDX and Maintenance
set functions in a query statement. Using functions to manipulate sets of members. Using functions to aggregate values
from a set of members. Applying MDX to make a cube change dynamically. Calculating formulas for specific blocks of
cells. Controlling the order of calculations within a cube .
SQL Server 2008/2012 Data Mining 2-day Course
3 days The goal of this course is twofold. First is to introduce participants in the world of data mining by means of a methodol- Querying SQL Server
ogy. The second goal is to become familiar with the SQL Server data mining tool: study and apply the different data with Transact-SQL
mining modeling techniques (decision trees, neural networks...) and the model evaluation tools available in SQL Server
Analysis Services. Topics: Data mining introduction. The CRISP-DM methodology. Business and Data understanding.
Data preparation. Modeling. SQL Server modeling techniques. Evaluation. Data mining clients.
+ EXAM 461
USQLRS SQL Server 2008/2012 Reporting Services
5 days This course introduces the SQL Server Reporting Services platform, and practices the necessary skills to develop, deploy
and maintain reporting services reports on SQL Server 2008 and SQL Server 2012. Topics: Introduction to Microsoft SQL USQLA
Server Reporting Services. Authoring Basic Reports . Enhancing Basic Reports . Manipulating Data Sets . Managing 5-day Course
Content . Administering Reporting Services . Programming Reporting Services . Report enhancements. Report on OLAP Administering Databases
data. Ad hoc queries with Report Builder. Advanced Report Components. Self-service reporting. Report rendering. and Servers using
Report Administration. See page 34. SQL Server 2008/2012
USP10BI Developing Business Intelligence solutions on SharePoint 2010
5 days In this course you’ll learn to develop Business Intelligence solutions on SharePoint Server 2010, using powerful features + EXAM 462
like interactive dashboards and scorecards, using well-known applications and interfaces. Topics: Overview of the
Microsoft Business Intelligence Stack. PowerPivot for Excel and SharePoint. SharePoint Business Intelligence Center.
Integration Reporting Services and SharePoint 2010. Excel Services. Visio Services. PerformancePoint Services.
See page 28. USQLIS12
Developing Tabular Models and PowerView Reports with SQL Server 2012 Implementing Data
USP10BI-2 Warehouses with
2 days In this training we focus on the new SQL Server 2012 features and learn how to build tabular models in Analysis Integration
Services 2012, extending these models with Data Analysis eXpressions (DAX), and delivering the data to end users with Services 2012
PowerView reports in SharePoint. Topics: Introduction PowerView. Building Tabular models. Enhancing Tabular models
with DAX. Deploying tabular models to SharePoint. Authoring PowerView reports. See page 28.
+ EXAM 463
SQL Server 2012
: www.u2u.net & + 32 2 466 00 16 + firstname.lastname@example.org 31
Developing and optimizing SQL Server 2008/2012 Databases
Introduction to SQL Server and its Toolset Merging Data and Passing Tables
Introduction to SQL Server Platform. Working with SQL Using the MERGE Statement. Implementing Table Types.
Server Tools. Configuring SQL Server Services. Using Table Types as Parameters.
Working with Data Types Creating Highly Concurrent SQL Server Applications
Using Data Types, Working with Character Data. Introduction to Transactions. Introduction to Locks.
Converting Data Types. Specialized Data Types. Management of Locking. Transaction Isolation Levels.
Designing and Implementing Tables Handling Errors in T-SQL Code
Designing Tables. Working with Schemas. Creating and Designing T-SQL Error Handling. Implementing T-SQL Error
course code Altering Tables. Handling. Implementing Structured Exception Handling.
days USQLD Designing and Implementing Views Designing and Implementing User-Defined
Introduction to Views. Creating and Managing Views. Functions
Performance Considerations for Views. Designing and Implementing Scalar Functions. Designing
and Implementing Table-valued Functions. Implementation
Planning for SQL Server Indexing Considerations for Functions. Alternatives To Functions.
Learning Goals Core Indexing Concepts. Data Types and Indexes. Single
This course focuses on using the SQL Server Column and Composite Indexes. Ensuring Data Integrity through Constraints
database to develop applications. It discusses Enforcing Data Integrity. Implementing Domain Integrity.
basic and advanced features of SQL Server: Table Structures in SQL Server Implementing Entity. Referential Integrity.
creating tables, views, functions and stored SQL Server Table Structures. Working with Clustered
procedures, the integration of the .Net frame- Indexes. Designing Effective Clustered Indexes. Responding to Data Manipulation via Triggers
work… We focus on solving common ques- Designing DML Triggers. Implementing DML Triggers.
Reading SQL Server Execution Plans Advanced Trigger Concepts.
tions: how to design indexes, deal with trans- Execution Plan Core Concepts. Common Execution Plan
actions and locking… We discuss the new data Elements. Working with Execution Plans. Implementing Managed Code in SQL Server
types, such as the spatial data types. Introduction to SQL CLR Integration. Importing and
Improving Performance through Nonclustered Configuring Assemblies. Implementing SQL CLR
Target audience Indexes
IT Professionals wanting to become skilled on Integration.
Designing Effective Nonclustered Indexes. Implementing
SQL Server 2008/2012 product features and Nonclustered Indexes. Using the Database Engine Tuning If time permits / Upon request
technologies for implementing a database. Advisor. Storing XML Data in SQL Server. Querying XML Data in SQL
Prerequisites Server. Working with SQL Server Spatial Data. Working with
Designing and Implementing Stored Procedures Full-Text Indexes and Queries.
Parts of this course are using .NET program- Introduction to Stored Procedures. Working With Stored
ming languages (C# and VB.NET) as well as Procedures. Implementing Parameterized Stored
XML. This course assumes the participants Procedures. Controlling Execution Context.
already have a basic knowledge of these
technologies, as well as a basic understand-
ing of relational databases in general. Prior
knowledge of SQL Server is not required.
Administering Microsoft SQL Server 2008/2012
Course Outline Assigning Server and Database Roles
Working with Server Roles. Fixed Database Roles. Creating
Introduction to SQL Server and its Toolset User-defined Database Roles.
Intro to SQL Server Platform. Working with SQL Server
Tools. Configuring SQL Server Services. Authorizing Users to Access Resources
Authorizing User Access to Objects. Authorizing Users to
Preparing Systems for SQL Server Execute Code. Configuring Permissions at the Schema Level.
Overview of SQL Server Architecture. Planning Server Resource
Requirements. Pre-installation Testing for SQL Server. Auditing SQL Server Environments
Options for Auditing Data Access in SQL Server. Implementing
Installing and Configuring SQL Server SQL Server Audit. Managing SQL Server Audit.
Preparing to Install SQL Server. Installing SQL Server.
course code Upgrading and Automating Installation. Automating SQL Server Management
5 Automating SQL Server Management. Working with SQL
days USQLA Working with Databases Server Agent. Managing SQL Server Agent Jobs.
Overview of SQL Server Databases. Working with Files and
Filegroups. Moving Database Files. Configuring Security for SQL Server Agent
SQL Server Agent Security. Configuring Credentials.
SQL Server Recovery Models Configuring Proxy Accounts.
Learning Goals Backup Strategies. SQL Server Transaction Logging.
This course focuses on installing, configuring and Planning a SQL Server Backup Strategy. Monitoring SQL Server with Alerts and Notifications
maintaining a SQL Server database. It covers typ- Configuration of Database Mail. Monitoring SQL Server
ical administrative topics: installation, backup and Backup of SQL Server Databases Errors. Configuring Operators. Alerts and Notifications.
restore, setting up security, monitoring, automat- Backing up Databases and Transaction Logs. Managing
ing tasks, data transfer and high availability. We Database Backups. Working with Backup Options. Performing Ongoing Database Maintenance
also focus on index design, maintenance, setting Ensuring Database Integrity. Maintaining Indexes.
Restoring SQL Server Databases Automating Routine Database Maintenance.
up statistics... We discuss features such as the The Restore Process. Restoring Databases. Point-in-time
resource governor, the new auditing, and the Recovery. Restoring System Databases and Files. Tracing Access to SQL Server
policy based management. Capturing Activity using SQL Server Profiler. Improving
Importing and Exporting Data Performance with the Database Engine Tuning Advisor.
Target audience Transferring Data To/From SQL Server. Importing &
IT Professionals wanting to become skilled Working with Tracing Options.
Exporting Table Data. Insert Data in Bulk.
on SQL Server product features and tech- Monitoring SQL Server
nologies for maintaining a database. Authenticating and Authorizing Users Monitoring Activity. Capturing and Managing Performance
Authenticating Connections to SQL Server. Authorizing Data. Analyzing Collected Performance Data.
Prerequisites Logins to Access Databases. Authorization Across Servers.
Basic knowledge about the windows operating Managing Multiple Servers
system and relational databases in general. Working with Multiple Servers. Virtualizing SQL Server.
Prior knowledge of SQL Server is not required. Deploying and Upgrading Data-Tier Apps.
32 : www.u2u.net & + 32 2 466 00 16 + email@example.com
What's new in SQL Server 2012
Day 1 to 2: Relational Databases Day 3 to 5: Business Intelligence
What’s new for Developers What’s new in SSIS
• FileTables extend the Filestream technology and make it • Data correction transformation uses Data Quality Services
possible to store a hierarchy of files and documents in for testing Data Quality Rules.
special SQL Server tables, yet programmatically access • Change Data Capture source, transformation and task
them as if they are on the file system, transactional or simplifies retrieving only modified records from the
non-transactional. source database.
• SQL Server Developer Tools is a Visual Studio plugin • ODBC source and destination for improved performance
5 which offers rich database development tools, including when accessing e.g. SQL Azure or Hadoop.
days USQLUP intellisence, integration with entity framework, both
online and offline development…
• Expression task makes it easier to modify the values of
• Full Text improvements: Statistical Semantic Search allows • Support for .Net 4.0 scripts.
finding similar documents and detecting key phrases, as • New project deployment model, which makes it easier to
well as common key phrases between two documents, manage packages in SQL Server, using build-in stored
Property search allows searching the meta-data of e.g. procedures, views and reports.
office documents, as well as additional other improve- • Also .Net object model and PowerShell can be used to
The new SQL Server 2012 contains many
ments. deploy and manage SSIS packages.
improvements as well as complete new fea-
• Enhanced debugging in SSMS: supports SQL Server 2005 • Variables and shared connection managers makes it easier
tures in administration, development as well
and later, breakpoint conditions, hit counts, breakpoint fil- to share connections and other settings amongst multiple
as the business intelligence functionality. This
ters, watch and quick watch windows, tooltip inspection,… packages.
course presents you with the new features
• ColumnStore indexes store data column-by-column • GUI changes: BIDS has been updated to provide a more
and improved functionality and the many
instead of row-by-row, which can greatly improve query productive development experience: Undo support, revised
hands-on labs allow you to familiarize your-
performance and memory use, especially for data-ware- toolbox, better support for reconnecting objects, …
self with all the new functionality.
house type of queries. • Memory improvements on the Merge and Merge Join
• Snippets: both code snippets and Surround-with snippets transformation.
are supported. • .dtsx improvements: The structure of the new dtsx files
This course is intended for developers and
• UTF-16 Collations. makes it easier to compare and merge dtsx files, making
administrators (both relational and in the BI
• Order BY clause supports paging. it easier in source control tools.
environment) who consider an upgrade to
• Sequence object generates subsequent numbers, unrelat-
SQL Server 2012.
ed to a particular table. What’s new in SSAS
• Geometry and Geography improvement: SQL Server now • Tabular Model databases provide another way to analyze
supports circular arc, extending the list of methods sup- data. Instead of the traditional OLAP modeling in dimen-
The course requires participants to have sig-
ported on these data types. Also, full globe geography sions and hierarchies, tabular mode sticks to tables, but
nificant hands-on experience with SQL Server
objects are supported. uses the Vertipaq engine for efficient querying. This caus-
2008 or SQL Server 2008 R2, as well as a
• THROW allows throwing and rethrowing exceptions for es many changes to Analysis Services, including a com-
good knowledge of T-SQL. Certain parts of
the try-catch blocks. plete new GUI to create and edit tabular models, partition
this course relate to SharePoint; for this the
• New T-SQL functions for type conversion, date and time, them, using memory paging to create tabular models
participants should have at least some famil-
string manipulation, IIF and CHOOSE, as well as new ana- larger than RAM, setting up tabular security roles and row
iarity with SharePoint
lytical functions (LEAD, LAG, …) level security, as well as hierarchies.
• SQL Express LocalDB support. • DirectQuery is roughly the Rolap equivalent of tabular
• Miscellaneous: improved OVER function, more partition- models, where users query the underlying table directly
ing, online index rebuilds on blobs. via SSAS, without using the SSAS cache.
• Extended Events were already available in the relational
What’s new for Administrators SQL Server, but are now also available in SSAS, and allow
• Contained databases simplify migrating databases from capturing about 40 types of events.
one server to another by keeping their users decoupled • DAX is the query language used by tabular models. DAX
from server logins. was already available in PowerPivot, but has been extend-
• Improved GUI for Point-In-Time restore and page restore. ed with more than 30 new functions.
• Improved Data-tier Applications: supports schema and • PowerShell cmdlets for Analysis Management Objects
data, for more database objects. (AMO) and PowerPivot for SharePoint
• PowerShell 2.0 support and extra cmdlets for backup and • Performance and storage improvements: Scalable String
restore. storage allows storing more than 4 GB of strings in
• Database engine tuning advisor supports query plan dimensions and distinct count aggregates, tables with
cache as workload. more than 2 billion rows are supported.
• Additional and Improved Dynamic Management Views
• AlwaysOn Failover clusters: clustering without shared stor- What’s new in SSRS
age, but using data replication: disaster recovery + high • PowerView is an interactive ad-hoc reporting tool for data
availability. Also improved failure detection, results in stored in tabular models in Analysis Services. It is accessed
more flexible failover policies. from within SharePoint 2010.
• AlwaysOn Availability groups: Allows a set of databases to • Improved SharePoint integration with support for claims-
act as a single failover entity with at least one replica. -based authentication, cross-farm support.
• Indirect Checkpoints: checkpoints at database (i.s.o. serv- • Data alerts inform end-users of certain changes in the
er) level. data of the reports of their interest. A data alert designer
• User-defined server roles. is provided to create these alert rules.
• Database access for contained databases. • Office 2007 rendering types allow users to render reports
• Audit improvements and enhancements. as docx or xlsx files.
What is Data Quality Services?
• Data Quality Services is a new SQL Server service which
helps in data cleaning tasks such as deduplication and
domain validation. It is a combination of knowledge bases
describing correct data and rules, as well as tools to vali-
date the data. It links with SSIS via the data correction
transformation, and links with Master Data Services.
: www.u2u.net & + 32 2 466 00 16 + firstname.lastname@example.org 33
Overview of SQL Server 2008/2012 Business Intelligence
Introduction Data Mining Introduction
The need for Business Intelligence. Business Intelligence in Problems that cannot be solved with pivot tables. Creating
SQL Server. SQL Server Data Tools. mining structures and mining models. Browsing, testing
and interpreting mining models. Data mining from within
Designing IS Control flows Excel.
Overview of tasks. Precedence constraints. Containers and
loops. Introduction to Microsoft SQL Server Reporting
Designing IS Data Flow Overview of Microsoft SQL Server Reporting Services. Tour
Data Sources. Data Transformations. Data Destinations.
of Reporting Services. Overview of Reporting Services
5 Introducing Master Data Services (MDS) Architecture.
days USQLBI The need for Master data. Manipulating data with MDS.
Authoring Basic Reports
Retrieving data from MDS.
Creating a Basic Table Report. Formatting Report Pages.
Introducing Data Quality Services (DQS) Calculating Values.
What is Data Quality Services. Setting up a DQS Knowledge
Learning Goals Advanced Reporting options
Base. Cleaning data with the SSIS DQS cleaning transfor-
In this course, you get an overview of the fea- Multi-select parameters. Interactive column sorting.
tures of the server side Business Intelligence Floating headers. Using the OLAP query builder.
tools that Microsoft ships with SQL Server: Loading the relational data in AS Ad hoc queries with Report Builder
Integration Services, Analysis Services and Data Sources and Impersonation. Data Source Views.
Introducing Report Builder. Create Report Builder reports.
Reporting Services. Besides these, we briefly Exploring the data.
discuss Master Data Services and Data Quality Building and deploying basic cubes
Services. This course focuses mainly on how to The auto build wizard. Inspecting the meta-data. Deploying
get started developing BI solutions with the cubes. Processing cubes.
three BI server-side Microsoft products. It doesn't
discuss administration nor maintenance. Building Tabular Models
Target audience Introducing PowerPivot. Loading and linking tabular data.
Business intelligence developers as well Extending tabular models with simple DAX calculations.
project managers or other non-developers. Browsing the cubes
Browsing from within Visual Studio. Browsing with Excel.
Participants must be familiar with the relation-
al SQL Server and the T-SQL query language.
Microsoft SQL Server 2008/2012 Reporting Services
Course Outline Report on OLAP data
Brief introduction into OLAP and MDX. Running Analysis
Day 1 to 3 - Essentials Services. Using the OLAP query builder.
The first part introduces the SQL Server Reporting Services
platform, and practices the necessary skills to develop, Ad hoc queries with Report Builder 1
deploy and maintain reporting services reports on SQL Introducing Report Builder. Create Report Builder reports.
Server 2008 and 2012. Creating and maintaining Report Models.
Introduction to SQL Server Reporting Services Day 4 to 5 - In depth
Overview of SQL Server Reporting Services. Tour of This part focuses on the new features added to the 2008
Reporting Services. Overview of Reporting Services and 2012 release of SQL Server reporting services. It builds
Architecture. on top of the basic reporting services features. Major topics
5 Authoring Basic Reports
are the self-service reporting options, where developers
days USQLRS Creating a Basic Table Report. Formatting Report Pages.
can create query and report components that can be used
by end-users to easily assemble reports, and the advanced
Calculating Values. report authoring options, where new components such as
Enhancing Basic Reports maps, gauges, sparklines and Key Performance Indicators
Interactive Navigation. Displaying Data. make it a lot easier to build enterprise reports.
This course introduces the SQL Server Manipulating Data Sets Report Components
Reporting Services platform, and practices Defining Report Data. Using Parameters and Filters. Using Advanced report formatting with placeholders. Embedding
the necessary skills to develop, deploy and Parameter Lists. HTML is reports. Tablix replaces Table, List and Matrix.
maintain reporting services reports on SQL Advanced charting. Working with Gauges. Plotting data on
Server 2008 and SQL Server 2012. Managing Content maps. Visualizing KPIs and sparklines.
Publishing Content. Executing Reports. Creating Cached
Target audience Instances. Creating Snapshots and Report History. Creating Self-service reporting
This course is intended for database adminis- Report Subscriptions. Report Builder 2.0 and Report Builder 3.0. Creating and
trators and database developers who which configuring shared data sets. Developing shared report
to learn building, deploying and managing Administering Reporting Services parts. Building reports with shared data sets and report
SQL Server Reporting Services reports. Server Administration. Performance and Reliability parts.
Monitoring. Database Administration. Security
Prerequisites Administration. Report rendering
Before attending this course, students must Word rendering. Brief PivotTable introduction. Consuming
be able to write T-SQL queries and be Programming Reporting Services reports as Atom feed in PowerPivot. Changes in Report
familiar with the SQL Server Management Querying Server Information. Automating Report execution. Working with report and group variables.
studio. Management. Rendering Reports. Creating Custom Code. Designing render format dependant reports.
Report enhancements Report Administration
Multi-select parameters. Interactive column sorting. Running reporting services without IIS. Managing cached
Floating headers. shared data sets. Administering shared report parts.
34 : www.u2u.net & + 32 2 466 00 16 + email@example.com
Microsoft SQL Server 2008/2012 Analysis Services
Introduction Key Performance Indicators (KPI)
The need for Analysis Services. Business Intelligence in SQL What are KPIs. Designing KPIs. Using the KPI browser.
Server. Using SQL Server Data Tools (SSDT).
Loading the relational data Dimension translations. Cube translations. Testing translat-
Data Sources and Impersonation. Data Source Views. ed cubes.
Exploring the data.
Building and deploying basic cubes Types of actions. Creating Actions. Using Actions.
Analysis Services terminology. Building dimensions with the
course code wizard. Fine-tuning dimensions. Handling attribute-rela- Perspectives
5 The need for perspectives. Creating perspectives. Browsing
days USQLAS tionships. Building and finetuning cubes in SSDT. Deploying
cubes and dimensions. perspectives.
Browsing the data Special dimensions
Browsing from within SSDT and Management Studio. Different types of dimensions. Many-to-many dimensions.
Browsing from Excel. Browsing with Reporting Services. Other types of dimensions.
In this course you will learn to create and man- Access cubes from a custom .Net application. The other faces of Analysis Services
age Analysis Services cubes, using features such Aggregation design Data mining overview. Introduction into PowerPivot and
as translations, Key Performance Indicators and MOLAP, ROLAP and HOLAP storage modes. Partitioning SSAS tabular models.
calculated members. You will become able to the cube. Creating aggregations. Usage based aggregation
process cubes, design aggregations, decide
design. Pro-active caching. Installing Analysis Services. Migrating AS2000 and AS2005
upon which type of storage is optimal.
Processing Cubes and Dimensions cubes. Backup and Restore. Securing Analysis Services.
Target audience Different types of processing. Processing dimensions.
Developers and administrators who want to learn Processing cubes.
the skills to develop Analysis Services cubes.
Administrators who want to acquire a deeper Multi-Dimensional Expressions (MDX)
knowledge of the server they are managing. MDX expressions and queries. Calculated members. Named
Prerequisites sets. Adding Business Intelligence.
Basic knowledge of the SQL Server relational
database and the T-SQL query language.
Design, Build and Administer Data Warehouses
with Microsoft SQL Server 2008 Integration Services
Course Outline Tools
Overview of tools. Brief introduction into the Microsoft
Day 1 to 2: Designing Data Warehouses using Data Warehousing tools.
The first part focusses on Dimensional Modeling, mainly Day 3 to 5:
following the Kimball approach. We study key concepts SQL Server 2008 Integration Services
such as dimensions and fact tables, star and snowflake The focus of this part is on using SQL Server Integration
schemas. We dive in advanced scenarios such as degener- Services, Microsoft's Extract Transform and Load (ETL) tool.
ated dimensions, bridge tables and many-to-many rela- We investigate this tool can be used to transport and
tionships. We conclude with physical database design and transform data from one data source to another.
related topics such as index design for data warehouses.
5 Intro to SQL Server 2008 Integration Services
days USDWH The need for Data Warehousing The need for Integration Services. Business Intelligence in
SQL Server. Business Intelligence Development Studio.
Data Warehouse definitions and terminology. Issues with
live database reporting. Data Warehouse advantages. User
interviews. Prioritizing the requirements. Documenting the Designing Control flows
requirements. Overview of tasks. Precedence constraints. Containers and
Learning Goals loops.
The goal of this five day course is to study
the design of Data Warehouses and to focus Designing Data Flow
Advantages and disadvantages of normalizing data. Fact
on the implementation, maintenance and Data Sources. Data Transformations. Data Destinations.
tables. Dimension tables. Star versus snowflake dimensions.
administration of the ETL packages needed
to build actual Data Warehouses. This 5-day Debugging packages
Designing the Time Dimension
course combines the 2-day course USDWH-1 Setting breakpoints in Control Flow Tasks. Adding data
Why do we need a time dimension. Designing the time
and the 3-day course USQLIS. viewers to data streams. Setup package logging.
dimension. Useful tools and scripts.
Target audience Working with Slowly Changing Dimensions Advanced package settings
This course is intended for SQL Server data- Events. Setting up Event Handlers. Package configuration.
Type I, II and III slowly changing dimensions. Designing for
base developers and BI project managers
SCD. Advanced SCD types.
who are responsible for designing or imple- Ad hoc tasks and transformations
menting Data Warehouses.
Advanced dimensional design Creating .NET tasks. Creating .NET data sources. Creating
Early arriving facts. Late arriving facts. Dealing with curren- .NET transformations. Creating .NET data destinations.
Prerequisites cy conversion. Dealing with hierarchies. Modeling many to Introducing custom components.
Participants should be familiar with the con-
cepts of relational database design (tables, Administration
foreign keys, constraints, indexes). SQL Server
Physical database design Executing Packages. Migrating DTS2000 packages. Package
will be used as a data source in this course, deployment. Integrating packages in .NET applications.
Staging tables. Table design. Indexing.
so basic familiarity with SQL Server is recom-
: www.u2u.net & + 32 2 466 00 16 + firstname.lastname@example.org 35