SQL SERVER Basics and T-SQL Course Contents:
SQL Server Basics &
Queries
SQL Server Introduction
SQL Server 2008 R2
Installation
Basic T-SQL Concepts
T-SQL Programming
Table & Column Constraints
Need For Stored Procedures
Stored Procedures & RESULT
Data Integrity & Consistency
SETS
IDENTITY Property and
SQL Server 2012 Installation
Dynamic Stored Procedures
Limitations
SQL Server Views and
Database Design Planning
User Defined Functions (UDF)
Security
Logical Database Design & Aliasing and Naming
System Functions & Usage
Planning
Conventions
System Views & Metadata
DDL Triggers and DML
Physical Database Design
Access
Triggers
Filegroup Sizing and File
T-SQL JOINS and Usage
Cursors Usage and Limitations
Locations
Physical Table Design (File
Sub Queries & Nested Queries Procedure Cache & Memory
Level)
Filegroups and Table
Nested Queries and Sub
Synonyms Usage and
Mappings
Queries
Limitations
T-SQL Data Types and
PREDICATES and Sub
Transactions and ACID
Variants
Queries
Properties
SELECT, WHERE,
Need For Indexes and Design T-SQL Transaction Types
BETWEEN
SELECT INTO & Bulk
Indexes Use and Performance Nested Transactions and Rules
Operations
SELECT Statement and
Index Selectivity & Options Impact of Open Transactions
Variants
GROUP BY, HAVING, IN, Session Level SET Options & T-SQL Transaction Save
EXISTS
Use
Points
Microsoft Business Intelligence Training Highlights
[MSBI]:SQL Server 2008 R2 and 2012 versions
SQL SERVER
SQL SERVER ANALYSIS
INTEGRATION SERVICES
SERVICES (SSAS)
(SSIS)
Multidimensional
Need for SSIS & Scope of Use
DataWarehouse
SSIS Configuration & Catalog Multidimensional, Tabular
DB
Modes
Control Flow & Data Loads
SSAS Architecture &
SQL SERVER
REPORTING SERVICES
(SSRS)
Need for SSRS & Report
Tools
SSRS 2012 Configuration &
Keys
Web Services & Service
SQL SERVER
SQL SERVER ANALYSIS
INTEGRATION SERVICES
SERVICES (SSAS)
(SSIS)
(ETL)
Schemas
Cube Design & Format
Data Integrity & Consistency
Options
Dynamic Precedence &
Cube and Dimension
Loading
Browsers
SSIS Configuration Options
SSIS Variables and Parameters
SCD Types and Datawarehouse
OLTP and DW Delta Loads
Checkpoints & SSIS Logging
Transactions and Isolation
Levels
CHECKSUM Transformation
& DW
Error Handling & Event
Handling
TDS Packets & Buffer Sizing
.NET Integration & Scripting
SSIS 2012 Deployment Tools
Package Deployment &
Security
Scheduling SSIS Package Jobs
Package Migrations & Reports
Package Backups & Upgrades
SSIS Performance Tuning Tips
Realtime Case Study on SSIS
SQL SERVER
REPORTING SERVICES
(SSRS)
Accounts
Data Sources & Shared Data
Sets
Remote Data Sets & Report
Parts
Table Reports and Matrix
Hierarchies & Attribute Keys
Reports
SSAS 2012 Deployment
Report Designer Paging
Issues
Options
MDX Queries, Joins and
Global Variables and Data
Functions
Sets
MDX Calculations and
Drill-down Reports & Bar
Scripts
Charts
Cube Partitions & Storage
Parameters & DataSet Filters
Modes
SSAS Aggregations and
SSRS 2012 Dashboard
Tuning
Design
Parent, Child KPIs and
Chart Reports & Map
Actions
Reports
Joining Local, Shared
Aggregations & Perspectives
Datasets
Time based Expressions &
SSRS 2008 R2 Report
Keys
Models
Proactive Caching & KPI
SSRS Deployment &
Tuning
Options
Excel Pivot Tables & Pie
Cache Refresh and Snapshots
Charts
Data Mining & Forecasts
SSRS Snapshots and History
(DMX)
XMLA & DAX : Security
Security Management &
Options
Roles
Deployment Process &
Cube Based Reports with
Migrations
MDX
BI Enhancements &
Report Builder
Granularity
Configuration)
SSRS Report Monitoring &
New Features in SSAS 2012
Tuning
Realtime Case Study on
Realtime Case Study on SSAS
SSRS
SQL Server Integration Services - Training Highlights
[SSIS]:SQL Server 2008 R2 and 2012 versions
Basic SSIS Development
Introduction to SSIS
Advanced SSIS Development
Custom Activities
SSIS Deployment and
Security
Deployment Procedures
Need for SSIS
Components
Data Analytics &
Debugging
Preparing for
Deployment
Architecture &
Installation
Custom Code Handling
SSIS Deployment
Phases
SSIS Catalogs and
SSIS DB
Event Notifications &
Emails
Deployment Options
& ISPAC
Type I and Type II SCDs
CHECKSUM
Transformation
Package Validation
Techniques
SSIS Architecture
Control Flow Tasks &
Usage
Data Flow Tasks
Architecture
Data Pipelines and
Usage
TDS Sizing, CDC
Transformation
Package Controls
File System Deployment
File System
Deployment
Package Execution
Options
File System
Encryptions
SSIS Isolation Levels
Conditional
Precedence
SSIS Checkpoints and
Usage
Basic SSIS Entities
CACHE Transformation SQL Server Deployment
CHECKSUM
Transformation
IS Data Types &
Conversions
SSIS Local & Global Package Configurations
Variables
Configurations and
Dynamic Precedence
benefits
Flow
SSIS Configuration
Dynamic SSIS
Options
Connections
Global Configurations
Data Flow Transformations
Column
Choosing correct
providers
SQL Server
Deployment
SSIS Catalogs and
Security
SQL Server Package
Security
Catalog DB and SSIS
Reports
Deployment Management
Package Migration
Basic SSIS Development
Advanced SSIS Development
SSIS Deployment and
Security
Transformations
MERGE Vs UNION
ALL
Lookup and Fuzzy
Grouping
SORT Vs
AGGREGATE
OLE-DB
Transformations
PIVOT & FastLoad
Options
SSIS Customizations
SCRIPT Task (.NET)
in SSIS
Expressions and
Iterations
SSIS Expressions
SSIS Parameters
Usage
Control Flow
Breakpoints
Data Flow Data
Viewers
Utilities
Command-Line
Deployments
Scheduling
Deployments
Error Handling
System Events and
Audits
Package Event Handling
Event Bubbling
Escalations
Managing Security
Package Security
Options
Encrypting SSIS
packages
Package Store and
msdb
Event Logging
Activities
SSIS Logging Actions
Benefit of SSIS Logging
Event Logs and SSIS
Package Execution
Audits
Processing XML Data
XML nodes and Data
Profiler & ADO
Connections
Upgrading Packages
Migrating DTS
packages
MSDB and SSIS
Catalog Files
SSIS 2008 R2 & 2012
ISPAC & Package
Migrations
SQL Server Analysis Services - Training Highlights [SSAS
& MDX]:SQL Server 2008 R2 & 2012 versions
SSAS Development
Introduction to SSAS
Advanced Cube Design
Cube Operations & MDX
Calculations and
Cube Deployments
SSAS Logs and Cube Audits
Benefits of SSAS
SSAS Development
Advanced Cube Design
Cube Deployments
Need for SSAS Tools
Tabular &
Multidimensional
MDX Scripting for
Calculations
Choosing log
providers
SSAS 2008 R2 &
2012
Calculation Sets and
Options
Managing SSAS Log
Providers
Defining KPIs and
Goals
Warehouse Implementation
Cubes & Measures
Facts and Dimensions
Measures &
Aggregates
Attributes and
Hierarchies
Expressions
Perspectives with MDX
SSAS Actions and
FILTERS
Partitions, Aggregations
Need for Cube Partitions
Datawarehouse with
SSAS
Need for Storage
Models
Staging Data Usage
Basic SSAS Entities
MDX based
Aggregations
Logging
OLAP(DW) Management
Tabular Database
Backups
Restore Options,
Partitions
Scripting Backups
and XMLA
Scheduling Backups
and Jobs
DB Synchronizations
(XMLA)
Partitions and
Caching (XMLA)
DB Reports and
Dashboards
Monitoring Execution
Plans
MDX Programming
Data Source &
Connections
Sub Queries with MDX
Manipulating DSVs
Complex MDX Queries
Computed, Named
Queries
MDX Functions &
Limitations
Building Entity
Relationships
Conditional MDX
JOINS
Optimizations and
Audits
Datawarehouse
Design
Cube, Dimension
Writebacks
Aggregations in UBO
MDX Query
Transactions
OLAP Restore and
XMLA
Database Dimensions
Dimensions & Builds
Data Mining and Forecast
Usage Based Optimizations
Managing Security
SSAS Development
Advanced Cube Design
Cube Deployments
Attributes, Member
Names
SSAS Security Roles
Object Level Access
and MDX
Data Mining Structures
Data Mining Algorithms
Hierarchies and
Limitations
Item Level Security
and DAX
DMX and Forecast
Reports
Attribute Relations &
Uses
Dynamic Security
(MDX)
Windows
Authentications
MDX Query Logs
Applying Time
Dimensions
Levels and
Hierarchies
Deployment Procedures
Composite Attribute
Keys
Multidimensional Cubes
Identifying Cube
Entries
Measures and
Additives
Prediction Functions
Multidimensional Mode
Tabular Mode & MDX Schedules and Upgrades
Deployment Options,
Tools
Scheduling SSAS
operations
Processing Options,
stages
Upgrading OLAP
Databases
SSAS 2008 R2 &
2012
SQL Server Reporting Services - Training Highlights
[SSRS]:SQL Server 2008 R2 and 2012 versions
SSRS Development
Advanced Reports Design
Managing Reports
Report Server Architecture Using Report Designer
Managing Reports
Report Life Cycle
Dynamic Parameters
SSRS Configuration Keys
SSRS Architecture
& Configuration
Report Filters in Data
Sets
Report Manager Options
Report Uploads &
Downloads
Creating Global Schedules
Scheduling Snapshots
SSRS 2012 and
WebServices
SSRS DB and
TempDB Usage
Sub Reports, Nested
Reports
Guage Reports,
Indicators
SSRS Development
Report Builder
Configuration
Introduction to SSRS Tools
Report Designer
Usage
Report Builder
Usage
Report Manager
and Usage
RS Planning and Design
SSRS Report
Planning
Enterprise, Ad-hoc
Reports
Optimizing Data
Sources
Report DataSet Queries
Joining DataSets
Dynamic DataSets
Report Design Templates
Wizard Based
Reports
Tables and Matrix
Chart Based
Reports
SSRS Expressions
& Globals
Sub Reports and
Advanced Reports Design
Managing Reports
Pie Charts and Data
Bars
ReportServerTempdb
Usage
Exporting Reporting
Data
Managing Reporting
Engine
SSRS using OLAP Sources
System Events and Audits
SSRS Report Tuning
Datawarehouse
Reports
KPIs and Measures
Cube & MDX
Reports
Report Models
Need for Report
Models
Identifying Report
Entities
Numerical
Aggregations
SSRS Logging
SSRS 2012 Logging
Options
Report Execution Audits
Scheduling Subscriptions
Standard Subscriptions
Data-Driven Subscriptions
Tuning Subscriptions
Report Server Security
Calculations and
Measures
Report Data Source
Security
Managing Data
Sources
Report Server Security
Levels
Understanding SMDL
Entries
Report Server DB Security
Report Builder
Using Report Builder
Report Downloads
and Uploads
Report Designer &
Builder
Server Upgrades
Upgrading SSRS Reports
Upgrading SSRS
Databases
Scale-out Deployments
SSRS Development
Options
Report Testing
Options
BUILD and
DEPLOY Options
Advanced Reports Design
Monitoring Reports
Report Server
Configurations
Report Migration
Wizard
Managing Reports
