Hi, [ Opportunity to learn Premium SQL Server Development Concepts which are in demand now in the market which will give you an edge over existing .Net Professionals ]
Warm Greetings from PrimeSource IT Solutions.
Welcoming Software Engineers to experience a touch of real time project development experience and upgrading themselves on some demanding Technologies and making swift pathway into Major MNC's as a Core Developer with hands on Practical exposure. Please go through the complete mail for the detail and drop into our office once to know more about us and a way for us to help you in a right and truthful way. Welcoming you all…Big people have Big dream….So let's dream big…
About PrimeSource:
We are one of the top Premier institute in Bangalore giving trainings on Microsoft .Net Niche Technologies. Our Broad spectrum of technical expertise include BizTalk Server R2 2006, SharePoint Server MOSS 2007, .Net 3.0 and 3.5 ( WCF, WPF, WWF ), SQL Server ( includes Reporting, Integration Services ), UML Design Patterns, Microsoft Dynamics, Silverlight etc to name a few Microsoft niche skills.
We also Operate as:
PrimeSource Career Solutions – Recruitment and Outsourcing Wing of PrimeSource IT Solutions
PrimeITExperts– Development Wing of PrimeSource IT Solutions
PrimeToonz – Animation Training and development wing of PrimeSource IT Solutions
Target Audience for Training:
Database Developers / .Net Developers / Senior Developers / Leads / Architects
***Attractive Group discounts for more than 3 members for this batch….Call back on 9900113004 / 9986915142 for further discounts
Please find below complete details of the course in a more elaborate way for better understanding of the concepts that will be covered within our course which is starting from Saturday i.e. 10th October 2009.Thanking you for letting us take this opportunity to teach SQL Server from PrimeSource and enhancing your knowledge in much better ways. Assuring you quality from our end and support in all ways possible to make you learn and grow in a bigger way for this niche Microsoft Technology.
About the Guest Trainer
Why should you select PrimeSource for your career enhancement
Address: No 39/9. 3rd Floor Opposite Kamat Hotel Avenue Road Bangalore - 560002
Landmark: Near Mysore Bank
Topics Covered within Course in Detail:
SQL Server Analysis Services
Introduction to AS
Understanding OLAP and Analysis Services
SQL 2005 AS Architecture
Server Architecture
Client Architecture
What is Unified Dimension Mode?
Creating a Cube
Introduction to Cube
Exercise:
Create Cube
Generate Schema using Template
Processing and Browsing a Cube.
What is Dimension?
Exercise:
Creating a Data Source View
Using the Dimension Wizard
Deploying a Dimension
Changing Attribute Properties
Working with a Time Dimension
Modifying a Data Source View
Creating a Time Dimension
Working with Role-Playing Dimensions
Creating a Parent-Child Dimension
Adding an Employee Dimension
Totaling Data for NonLeaf-Level Data Members
Managing Levels within a Parent-Child Dimension
Designing Measure Groups and Measures
What is Measure Group?
Exercise:
Adding Measure Groups to a Cube
Building a Cube
Changing Properties for Measure Groups and Measures
Specifying Dimension Usage
Browsing Multiple Measure Groups
Aggregating Semi additive Measures
Adding a Measure Group to an Existing Cube
Using a Semi additive Aggregate Function
Calculating Distinct Counts
Creating Simple Calculations
Adding a Calculation to a Cube
Applying Conditional Formatting
Designing Aggregations and Hierarchies
Aggregations and Aggregation Designs
User-Defined Hierarchies
Exercise:
Understanding Aggregation Design
Using the Aggregation Design Wizard
Inspecting Aggregations
Changing Partition Counts
Adding Attributes to the Aggregation Design
Designing User Hierarchies
Adding a User Hierarchy
Aggregating User Hierarchies
Optimizing Aggregations
Using the Query Log
Viewing Usage Data
Using the Usage-Based Optimization Wizard
Maintaining the Query Log
Advance Topics
Analysis Services Tutorials
Exploring Special Feature
Introduction to Many-to-Many Dimensions
Attribute Relationships
Loading Aggregate Data
SQL Server Reporting Services
SQL Server 2005 Reporting Services End to End Overview
Product Features
Architecture and Components
Server Components
Implementing Reporting Solutions
Designing Reports - The Report Designer
Deploying Reports to a Report Server
Configuring and Managing a Report Server
The Report Manager
Schedules
Accessing Reports
Reporting Services Programming
Reporting Services Extensions
Reporting Services Diagnostics
Printing Reports
Report navigation and viewing through
Microsoft SharePoint web parts
Designing Reports in SQL Server 2005 Reporting Services
Report Design Features
Grouping and Sorting
Multi Data Region Reports
Rendering Images
Report Parameters and Data Filters
Sub-reports
Drill-down and Drill-through
Links and Bookmarks
Document maps
Report Expressions
Embedded code and custom .NET Assemblies
Report Designer
Report Builder
RDL (Report Definition Language)
Model Designer
Support for custom-built report items
Updated expression editor
Improved integration with other SQL Server components
Reporting Service Management
Viewing Reports in IE using the Report Manager
Configuring and Managing a Report Server
Report Execution and Caching
Report history
Data Source connections
Role-based Security
Subscriptions and Delivery
Managing Schedules
Configuring Site-wide Settings
Tool Support – The Report Manager
API Support – The RS Website API
New report viewer controls that are included in Microsoft Visual Studio 2005
Exporting Reports to a Desktop Format
Changes made to Setup
The new Reporting Services Configuration tool
SQL Server Management Studio and SQL
Server Configuration Manager
Custom Assemblies
Reporting Services Diagnostics
Setup Logging
Execution Tracing
Component Tracing
Fully configurable tracing
Log Files location: <drive>:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles
Performance Monitor Counters
Performance Object: RS Web Service
Performance Object: RS Windows Service
Reporting Services Programming
URL Access
Web Services API
Embedded Code
Integrating Report Rending in Custom Applications
URL Access
Web Service API
SOAP Endpoints
WMI Provider
Reporting Services Extensions
Data Extensions
Delivery Extensions
Rendering Extensions
Security Extensions
Reporting Services: Oracle Data Sources
Accessing Analysis Services Data Sources in SQL Server 2000 Reporting Services
Reporting Services: Importing Access Reports
Reporting Services: Deployment
The new Reporting Services Configuration Tool
Server Configuration Manager
SQL Server Integration Services
Integration Services Objects and Concepts
Integration Services Packages
Control Flow Elements
Data Flow Elements
Integration Services Connections
Integration Services Event Handlers
Integration Services Containers
Creating Packages in SSIS Designer
Creating Package Event Handlers
Creating Connection Managers
How to: Run a Package Using the DTExecUI Utility
Debugging Control Flow
Debugging Script
Debugging Data Flow
Saving Packages
Integration Services Tools and Utilities
Deploying Integration Services Packages
Creating Package Configurations
Migrating Data Transformation Services Packages
Using the Package Migration Wizard
Command Prompt Utilities (SSIS)
dtExec Utility
dtUtil Utility
Integration Services Log Providers
Implementing Logging in Packages
Security Considerations for Integration Services
Setting the Protection Level of Packages
Integration Services Roles
Protecting Access to Running Packages
Package Samples
Advance Topic
Migration from SQL Server 2000
Batches in Pipeline
Other Course starting: 5 Weekend Batch
SharePoint Server MOSS 2007
BizTalk Server R2 2006
.Net 3.0 and .Net 3.5
About Certification:
Guidance will be provided to take up Certification but monetary aspects has to be taken care by the trainee.
Note: If any concerns please feel free to reach me on 9900113004 / 9986915142 / 080 4210 8838 / muddassir@primesource.co.in or drop in to our office anytime between 10 AM - 7 PM
Regards,
Muddassir Shariff
Chief Business Consultant - PrimeSource IT Solutions
#39 / 9, 3rd Floor Opposite Kamat Hotel
Avenue Road, Bangalore - 560002
Ph: 080 42108546 - 080 42108838
Mob: 9900113004 / 9986915142
Email: muddassir@primesource.co.in
Web: www.primesource.co.in
"We become whatever we are committed to. Nothing shapes our lives more than the commitments we choose to make"
Warm Greetings from PrimeSource IT Solutions.
Welcoming Software Engineers to experience a touch of real time project development experience and upgrading themselves on some demanding Technologies and making swift pathway into Major MNC's as a Core Developer with hands on Practical exposure. Please go through the complete mail for the detail and drop into our office once to know more about us and a way for us to help you in a right and truthful way. Welcoming you all…Big people have Big dream….So let's dream big…
About PrimeSource:
We are one of the top Premier institute in Bangalore giving trainings on Microsoft .Net Niche Technologies. Our Broad spectrum of technical expertise include BizTalk Server R2 2006, SharePoint Server MOSS 2007, .Net 3.0 and 3.5 ( WCF, WPF, WWF ), SQL Server ( includes Reporting, Integration Services ), UML Design Patterns, Microsoft Dynamics, Silverlight etc to name a few Microsoft niche skills.
We also Operate as:
PrimeSource Career Solutions – Recruitment and Outsourcing Wing of PrimeSource IT Solutions
PrimeITExperts– Development Wing of PrimeSource IT Solutions
PrimeToonz – Animation Training and development wing of PrimeSource IT Solutions
Target Audience for Training:
Database Developers / .Net Developers / Senior Developers / Leads / Architects
***Attractive Group discounts for more than 3 members for this batch….Call back on 9900113004 / 9986915142 for further discounts
Please find below complete details of the course in a more elaborate way for better understanding of the concepts that will be covered within our course which is starting from Saturday i.e. 10th October 2009.Thanking you for letting us take this opportunity to teach SQL Server from PrimeSource and enhancing your knowledge in much better ways. Assuring you quality from our end and support in all ways possible to make you learn and grow in a bigger way for this niche Microsoft Technology.
Batches successfully concluded :
· BizTalk Server 2006 / R2
· MOSS SharePoint Server 2007
· .Net 3.5 / 3.0
· .Net Design Pattern
· Team Foundation Server
· Microsoft Dynamics
· SQL Server 2008 etc.
About the Guest Trainer
- From a Large US Based MNC with Database development on SQL Server and Oracle throughout his career on both older as well as newer version.
- Currently working as Subject Matter Expert on SQL Server which will give the candidate a broad spectrum of technical knowledge from the trainer.
- Good Onsite Exposure and Industry insights to guide you in a right way.
- Excellent Communication with Good Presentation skills.
- Good mentoring ability on .Net Technologies.
- Currently a part of team imparting knowledge on SQL Server [Up to Architects] in the current company and part of panel interviewing SQL Server candidates for new projects.
Why should you select PrimeSource for your career enhancement
· Guest Faculty directly from Software MNCs compared to teaching faculty at other institutes for real time experiences.
· Hands on Practical sessions on all the aspects covered within the course directly mentored by guest faculty.
· All the Classes starts with real time scenarios explained using Projector based presentation followed by Practical Implementation of the same by trainees mentored by Guest Faculty on the same day with similar assignments for the whole week to practice from home.
· You can use our Full fledged lab for your practical purposes / we will be providing you with trial version of all the software's for you to practice at home.
· Excellent PDF's, Video Links and PPT's would be shared for references.
· Microsoft Certification Guidance would be provided with reference materials.
· Each and every trainer is accessible on all the days of week through PrimeSource blog for their respective skillsets.
· PrimeSource Website contains loads of PPT's and PDF's to be downloaded by the trainees [ Separate ID's would be created for each trainee to access all the documents published and printed by PrimeSource ]
Course Fee:· Complete Course covers most of the concepts which would be beneficial to start-up with SQL Server, covering up major advanced development concept and helping you in Clearing major interviews and to clear certification to wind up the course in a complete professional way
· Soft copies of all the programmes will be given which includes PDF and PPT documents within the package with live implementation experience using real time scenarios.
· We are Charging a nominal fees of Rs 8500 / - for this complete course on SQL Server [Please call back for attractive group discounts for more than 3 members]
· Great Discounts for other advanced courses, if you are rejoining us after the completion of this course
Regular Batch Details:· Batch Commencing from Saturday i.e. 10th October 2009.
· 6 Weekend batch on Saturday and Sunday
· Timings: 10 AM – 1 30 PM
· Total Course Duration: 40-50 Hours Theory + Practical Sessions and will wind up within a duration of 6 Weekends
· Targeting only 14-16 Trainees for the batch
· Note: Prerequisite being good experience on SQL Server Technologies for the courses as more inclined towards Advanced concepts
Corporate office:Address: No 39/9. 3rd Floor Opposite Kamat Hotel Avenue Road Bangalore - 560002
Landmark: Near Mysore Bank
Topics Covered within Course in Detail:
· SQL Server Analysis Services
· SQL Server Reporting Services
· SQL Server Integration Services
SQL Server Analysis Services
Introduction to AS
Understanding OLAP and Analysis Services
SQL 2005 AS Architecture
Server Architecture
Client Architecture
What is Unified Dimension Mode?
Creating a Cube
Introduction to Cube
Exercise:
Create Cube
Generate Schema using Template
Processing and Browsing a Cube.
What is Dimension?
Exercise:
Building a Standard Dimension
Adding a Data SourceCreating a Data Source View
Using the Dimension Wizard
Deploying a Dimension
Changing Attribute Properties
Working with a Time Dimension
Modifying a Data Source View
Creating a Time Dimension
Working with Role-Playing Dimensions
Creating a Parent-Child Dimension
Adding an Employee Dimension
Totaling Data for NonLeaf-Level Data Members
Managing Levels within a Parent-Child Dimension
Designing Measure Groups and Measures
What is Measure Group?
Exercise:
Adding Measure Groups to a Cube
Building a Cube
Changing Properties for Measure Groups and Measures
Specifying Dimension Usage
Browsing Multiple Measure Groups
Aggregating Semi additive Measures
Adding a Measure Group to an Existing Cube
Using a Semi additive Aggregate Function
Calculating Distinct Counts
Creating Simple Calculations
Adding a Calculation to a Cube
Applying Conditional Formatting
Designing Aggregations and Hierarchies
Aggregations and Aggregation Designs
User-Defined Hierarchies
Exercise:
Understanding Aggregation Design
Using the Aggregation Design Wizard
Inspecting Aggregations
Changing Partition Counts
Adding Attributes to the Aggregation Design
Designing User Hierarchies
Adding a User Hierarchy
Aggregating User Hierarchies
Optimizing Aggregations
Using the Query Log
Viewing Usage Data
Using the Usage-Based Optimization Wizard
Maintaining the Query Log
Advance Topics
Analysis Services Tutorials
Exploring Special Feature
Introduction to Many-to-Many Dimensions
Attribute Relationships
Loading Aggregate Data
SQL Server Reporting Services
SQL Server 2005 Reporting Services End to End Overview
Product Features
Architecture and Components
Server Components
Implementing Reporting Solutions
Designing Reports - The Report Designer
Deploying Reports to a Report Server
Configuring and Managing a Report Server
The Report Manager
Schedules
Accessing Reports
Reporting Services Programming
Reporting Services Extensions
Reporting Services Diagnostics
Printing Reports
Report navigation and viewing through
Microsoft SharePoint web parts
Designing Reports in SQL Server 2005 Reporting Services
Report Design Features
Grouping and Sorting
Multi Data Region Reports
Rendering Images
Report Parameters and Data Filters
Sub-reports
Drill-down and Drill-through
Links and Bookmarks
Document maps
Report Expressions
Embedded code and custom .NET Assemblies
Report Designer
Report Builder
RDL (Report Definition Language)
Model Designer
Support for custom-built report items
Updated expression editor
Improved integration with other SQL Server components
Reporting Service Management
Viewing Reports in IE using the Report Manager
Configuring and Managing a Report Server
Report Execution and Caching
Report history
Data Source connections
Role-based Security
Subscriptions and Delivery
Managing Schedules
Configuring Site-wide Settings
Tool Support – The Report Manager
API Support – The RS Website API
New report viewer controls that are included in Microsoft Visual Studio 2005
Exporting Reports to a Desktop Format
Changes made to Setup
The new Reporting Services Configuration tool
SQL Server Management Studio and SQL
Server Configuration Manager
Custom Assemblies
Reporting Services Diagnostics
Setup Logging
Execution Tracing
Component Tracing
Fully configurable tracing
Log Files location: <drive>:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles
Performance Monitor Counters
Performance Object: RS Web Service
Performance Object: RS Windows Service
Reporting Services Programming
URL Access
Web Services API
Embedded Code
Integrating Report Rending in Custom Applications
URL Access
Web Service API
SOAP Endpoints
WMI Provider
Reporting Services Extensions
Data Extensions
Delivery Extensions
Rendering Extensions
Security Extensions
Reporting Services: Oracle Data Sources
Accessing Analysis Services Data Sources in SQL Server 2000 Reporting Services
Reporting Services: Importing Access Reports
Reporting Services: Deployment
The new Reporting Services Configuration Tool
Server Configuration Manager
SQL Server Integration Services
Integration Services Objects and Concepts
Integration Services Packages
Control Flow Elements
Data Flow Elements
Integration Services Connections
Integration Services Event Handlers
Integration Services Containers
Creating Packages in SSIS Designer
Creating Package Event Handlers
Creating Connection Managers
How to: Run a Package Using the DTExecUI Utility
Debugging Control Flow
Debugging Script
Debugging Data Flow
Saving Packages
Integration Services Tools and Utilities
Deploying Integration Services Packages
Creating Package Configurations
Migrating Data Transformation Services Packages
Using the Package Migration Wizard
Command Prompt Utilities (SSIS)
dtExec Utility
dtUtil Utility
Integration Services Log Providers
Implementing Logging in Packages
Security Considerations for Integration Services
Setting the Protection Level of Packages
Integration Services Roles
Protecting Access to Running Packages
Package Samples
Advance Topic
Migration from SQL Server 2000
Batches in Pipeline
- BizTalk Server R2 / 2009
- SharePoint Server MOSS 2007
- .Net Design Patterns
- Microsoft Dynamics
- Java Niche technologies like Struts, Hibernate, Spring, JSF etc
- Mobile Based Symbian Testing
- QTP, Loadrunner, Silk Testing
- Perl, Shell, VB Scripting
- Expert Excel and VBA Macros
Other Course starting: 5 Weekend Batch
SharePoint Server MOSS 2007
BizTalk Server R2 2006
.Net 3.0 and .Net 3.5
About Certification:
Guidance will be provided to take up Certification but monetary aspects has to be taken care by the trainee.
Note: If any concerns please feel free to reach me on 9900113004 / 9986915142 / 080 4210 8838 / muddassir@primesource.co.in or drop in to our office anytime between 10 AM - 7 PM
Regards,
Muddassir Shariff
Chief Business Consultant - PrimeSource IT Solutions
#39 / 9, 3rd Floor Opposite Kamat Hotel
Avenue Road, Bangalore - 560002
Ph: 080 42108546 - 080 42108838
Mob: 9900113004 / 9986915142
Email: muddassir@primesource.co.in
Web: www.primesource.co.in
"We become whatever we are committed to. Nothing shapes our lives more than the commitments we choose to make"
