KEMBAR78
SSIS, SSAS, SSRS, C#, ASP.NET Guide | PDF | C Sharp (Programming Language) | Computer Programming
Scribd
Upload
55 views9 pages

SSIS, SSAS, SSRS, C#, ASP.NET Guide

This document covers tutorials on developing applications using Microsoft technologies including SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), C#, and ASP.NET. The SSIS section covers creating and managing packages, debugging errors, and deployment. The SSAS section discusses cubes, dimensions, KPIs, and administration. The SSRS section includes creating reports, scheduling, and server configuration. The C# section has an overview of syntax, data types, OOP concepts. The ASP.NET section touches on the page lifecycle, controls, validation, databases and deployment.

Uploaded by

Prem Nath R
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
55 views9 pages

SSIS, SSAS, SSRS, C#, ASP.NET Guide

This document covers tutorials on developing applications using Microsoft technologies including SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), C#, and ASP.NET. The SSIS section covers creating and managing packages, debugging errors, and deployment. The SSAS section discusses cubes, dimensions, KPIs, and administration. The SSRS section includes creating reports, scheduling, and server configuration. The C# section has an overview of syntax, data types, OOP concepts. The ASP.NET section touches on the page lifecycle, controls, validation, databases and deployment.

Uploaded by

Prem Nath R
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 9

Developing SSIS Packages

Debugging and Error Hndling in SSIS

Deploying and Configuring SSIS Packages

Administering ,Securing and Ececuting SSIS Packages

Status
Creating SSIS Packages and Data Sources
Creating and Editing control flow objects
Using Data Flow Adapters and Transformations
Configuring Packages Transactions and Checkpoints
Identifying Package Status,Enabling Logging and Handling Task Erros
Handling Data Flow Errors and Debugging
Using Packages Configuration and Expressions
Deploying SSIS Packages
Managing the SSIS Service and Configuring Packages Security
Executing and Scheduling Packages

Developing SSAS Cubes

Extending SSAS Cubes

Managing SSAS Storage, Processing, and Deployment

Securing and Administering SSAS

Working with SSAS Data Mining

Create Data and Data Source Views


Creating and Modifiying SSAS Cubes
Creating and Modifiying Dimensions

Define User Hierarchies and Dimension Relationships


Creating KPIs,Actions,Translations, and Perspectives
Creating Calculatons and Wueries by Using MDX
orage, Processing, and Deployment
Define Measure Group Partitions and Aggregations
Deploying SSAS Objects
Processing SSAS Objects
inistering SSAS
Setting Up SSAS Server Security
Managing SSAS High Availability,Backups and Object Scripting
S Data Mining
Preparing and Creating Data Mining Strucutres
Creating Models and Applying Algorithms
Validating Models, Using DMX Queries and Using Prediction Wueries in Reports
Securing and Processing Data Mining Models

Developing SSRS Reports

Extending and Deploying SSRS Reports

Scheduling and Securing Deployed Reports and Data Sources

Configuring and Administering the SSRS Server

Creating SSRS Projects and Reports in BIDS


Creating a Dataset from a Data Source
Working with Advanced Report Object Properties
Applying Dataset Filters and Regions
Assigning Parameters Within Reports
using Expressions to Perform Advanced Report Properies by using Expressions
Deploying new Reports and Changes
Using Reports in Your Code
Administering SSRS Item-Level Permissions and Site Security Roles
Creating Report Schedules and Subscriptions
Managing Report Caching and Execution Properties in Report Manager
Installing and Configuring Initial Instances of SSRS
Configuring Advanced SSRS Setting and Scale-Out Deployment

C# Basic Tutorial
Overview
Environment
Program Structure
Basic Syntax
Data Types
Type Conversion
Variables
Constants
Operators
Decision Making
Loops
Encapsulation
Methods
Nullables
Arrays
Strings
Struct
Enums
Classes
Inheritance
Polymorphism
Operator Overloading
Interfaces
Namespaces
Preprocessor Directives
Regular Expressions
Exception Handling
File I/O
C# Advanced Tutorial
Attributes
Reflection
Properties
Indexers
Delegates
Events
Collections
Generics
Anonymous Methods
Unsafe Codes
Multithreading

ASP.NET Tutorial

Introduction
Environment
Life Cycle
First Example
Event Handling
Server Side
Server Controls
HTML Server
Client Side
Basic Controls
Directives
Managing State
Validators
Database Access
ADO.net
File Uploading
Ad Rotator
Calendars
Multi Views
Panel Controls
AJAX Control
Data Sources
Data Binding
Custom Controls
Personalization
Error Handling
Debugging
LINQ
Security
Data Caching
Web Services
Multi Threading
Configuration
Deployment

You might also like