MS-BI ( SSIS,SSRS,SSAS ) : -
SQL Server Integration Services
MS-BI 2012
1. Basics
a. Understanding SSIS
b. BIDS
c. Building and Executing a Package
2. Control Flow
a. Control Flow
b. Control Flow Constraints
3. Data Flow
a. Data Flow
b. Data Flow Transformations
4. Variables
a. Variables
b. Data Flow Variables
c. Control Flow Variables
5. Containers
a. Containers
b. For Loop Containers
c. Transaction Report
6. Logging and Errors
a. Checkpoints and Handling Errors
b. Outputs and Break Points
c. Package Logging
7. Advanced SSIS
a. Event Handling
b. Advanced Data Flow
c. Slowly Changing Dimensions
8. Deployment
a. Deploying Packages
b. Installing Packages
9. Security
a. Managing Packages
b. Packages and Security
10. Scripting
a. Scripting
b. Data Flow Scripting
11. Best Practices
a. Package Design Best Practices
SQL Server Analysis Services (SSAS)
1. Build and Connect
2. Building a Cube
3. Connecting using Excel
4. Cube Modelling
5. Using Visio
6. Cube Modelling
7. Data Source and Data Source Views
8. Creating a Cube
9. KPIs and Perspectives
10. Translations
11. DataBus
12. Slowly Changing Dimensions
13. Aggregations – MOLAP
14. Profiler
15. Partitions - MOLAP, ROLAP and HOLAP
16. MDX Queries
17. MDX Functions
18. Calculated Members
19. MDX Scripts
20. Security
SQL Serer Reporting Services(SSRS)
1. Introduction to SSRS
a. Features
b. SSRS Architecture
c. Reporting Services projects
2. Creating Reports
a. Creating Tabular Report
b. Adding Controls
c. Creating List Report
3. Expressions and Formatting
a. Creating Expressions
b. Global Collections
c. Formatting
4. Playing with Reports
a. Creating Groups
b. Calculating Totals
c. Interactive Sorting
5. Parameters
a. Creating Parameters
b. Drop Down List
c. Parameter Sorting
6. Matrix and Charts
a. Creating Matrix Reports
b. SSRS 2008 Matrix Features
c. Creating a Chart
d. Adding Guages
7. Deployment
a. Deploy Reports
b. Report Manager
8. Security
a. Reporting Services Security
b. SSL
c. Data Source Security
9. Subscriptions
1. Basics
a. Understanding SSIS
b. BIDS
c. Building and Executing a Package
2. Control Flow
a. Control Flow
b. Control Flow Constraints
3. Data Flow
a. Data Flow
b. Data Flow Transformations
4. Variables
a. Variables
b. Data Flow Variables
c. Control Flow Variables
5. Containers
a. Containers
b. For Loop Containers
c. Transaction Report
6. Logging and Errors
a. Checkpoints and Handling Errors
b. Outputs and Break Points
c. Package Logging
7. Advanced SSIS
a. Event Handling
b. Advanced Data Flow
c. Slowly Changing Dimensions
8. Deployment
a. Deploying Packages
b. Installing Packages
9. Security
a. Managing Packages
b. Packages and Security
10. Scripting
a. Scripting
b. Data Flow Scripting
11. Best Practices
a. Package Design Best Practices
SQL Server Analysis Services (SSAS)
1. Build and Connect
2. Building a Cube
3. Connecting using Excel
4. Cube Modelling
5. Using Visio
6. Cube Modelling
7. Data Source and Data Source Views
8. Creating a Cube
9. KPIs and Perspectives
10. Translations
11. DataBus
12. Slowly Changing Dimensions
13. Aggregations – MOLAP
14. Profiler
15. Partitions - MOLAP, ROLAP and HOLAP
16. MDX Queries
17. MDX Functions
18. Calculated Members
19. MDX Scripts
20. Security
SQL Serer Reporting Services(SSRS)
1. Introduction to SSRS
a. Features
b. SSRS Architecture
c. Reporting Services projects
2. Creating Reports
a. Creating Tabular Report
b. Adding Controls
c. Creating List Report
3. Expressions and Formatting
a. Creating Expressions
b. Global Collections
c. Formatting
4. Playing with Reports
a. Creating Groups
b. Calculating Totals
c. Interactive Sorting
5. Parameters
a. Creating Parameters
b. Drop Down List
c. Parameter Sorting
6. Matrix and Charts
a. Creating Matrix Reports
b. SSRS 2008 Matrix Features
c. Creating a Chart
d. Adding Guages
7. Deployment
a. Deploy Reports
b. Report Manager
8. Security
a. Reporting Services Security
b. SSL
c. Data Source Security
9. Subscriptions
HADOOP ( BIGDATA ) : -
HADOOP CONSULTANT Program
Architecture Planning
• Introduction to Big Data / Hadoop
• Understanding of Eco-System Build
• Understanding Cluster Setup Activites
• HIVE Architecture
• PIG Architecture
• Introduction to NoSql
• HBASE Architecture
Hadoop Architecture Deployment & Understanding
• Best Practices for Cluster Setup
• How MapReduce Works .
• Install Pseudo cluster.
• Install Multi node cluster.
• Configuration.
• Setup cluster on Cloud - EC2.
• Tools.
• Install and configure - Hive, Pig, HBase
• Metadata & Data Backups.
• Filesystem check (fsck).
• File system Balancer.
• Commissioning and decommissioning nodes.
• Using DFSAdmin.
• Using Web Interfaces.
• Hadoop Log Files.
• Intro to HBASE Architecture
Data Ingestion:
• Sqoop – HDFS Loading
• Sqoop Hive Loading
• Sqoop Hbase Loading
• Flume – HDFS Loading
• Hadoop -put commands
Hadoop Application Development (AKA Data Analytics)
• Developing MapReduce Application
• How MapReduce Works
• MapReduce Types
• MapReduce Formats
• Mapreduce Features
• Working with HIVE.
• Hive – Basic Commands
• Hive – UDF’s
• Working with PIG
• Pig Commands
• Pig UDF’s
• Work Flow Management through Oozie
• Developer Use Cases
New Developments
• Into To Yarn
• Overview of Cloudera Manager
• Project Use - Cases
• Entertainment Use Case
• Twitter Use Case
• Health Care Use Case
• E-Commerce Use Case
• Bio-Informatics Use Case
•
Hadoop Application Development (AKA Data Analytics)
• Developing MapReduce Application
• How MapReduce Works
• MapReduce Types
• MapReduce Formats
• Mapreduce Features
• Working with HIVE.
• Hive – Basic Commands
• Hive – UDF’s
• Working with PIG
• Pig Commands
• Pig UDF’s
• Work Flow Management through Oozie
• Developer Use Cases
New Developments
• Into To Yarn
• Overview of Cloudera Manager
• Project Use - Cases
• Entertainment Use Case
• Twitter Use Case
• Health Care Use Case
• E-Commerce Use Case
• Bio-Informatics Use Case
•
SHAREPOINT ( ADMIN, DEVELOPMENT ) : -
Development
Introduction
• SharePoint overview
• Architecture of SharePoint
• SharePoint version History
• SharePoint Features
• Software and Hardware Requirements
• SharePoint Topology
SharePoint Structure
• Farm
• Web Application
• Root Site/ Top Level Site
• Site Collection
• Sub Site/ Web Site
• Lists/Library
• Items
Site Collections, webs, Lists and libraries
• Creating site collections
• Creating sub sites/ webs
• Working with site Templates
• Working with site Definition
• Creating and Managing Lists, Libraries
• Site Columns and Site Content Types
Web Parts
• Introduction to Web Parts
• Web Part architecture
• Working With Custom Web Parts
• Web part Custom Properties
• Connectable Web Parts
• Visual Web Parts
• Standard Web Parts
Features
• Web Application Level
• Site Collection Level
• Site Level
Workflows
• Introduction to Workflows
• Types of Workflow
1. Sequential Workflows
2. State Machine Workflows
• SharePoint Default Workflows
1. Approval
2. Signature
3. Three State
4. Signature
5. Disposition
• SharePoint Designer
1. List Workflow
2. Site Workflow
3. Reusable Workflow
• Visual Studio Workflows
SharePoint Business Intelligence (BI)
• Introduction
• Excel Services
• Access Services
• Report Services (SSRS)
• Performance Point Services
• Business Connectivity Service
• Visio
Business Connectivity Service
• Configuration of BCS
• Creating External content type
• Creating External List
• Sync data in both sides (DB to List and List to DB)
• Add All Authenticated Users
• Part of creating secure store service
Search
• Introduction
• Default search
• Fast search 2010
• No Fast search in 2013
Event Receivers
• Synchronous
• Asynchronous
InfoPath
• Overview of InfoPath
• Creating InfoPath form
• Publishing Form in Form Library
• Understanding Rules and Controls
Server Side object Model
• Server side API
• Server side Data Access
• CAML, SPSite and SPSiteData Query
• LINQ to SharePoint
• Event Receivers
• Workflows
Client Side Object Model
• Introduction to Client API (CSOM)
• Developing Using .Net, Silverlight and ECMA script
• WCF Data Service/OData/REST
Apps
• Introduction
• What is the use
Deployment Solutions
• Farm Solution
• Sandbox Solution
Designer/Look and Feel
Designer
• Master pages
• Site Pages
• Application Pages
• Page Layouts
• BCS
• External Content Type
• External List
• Workflows
• Java script
• HTML
• CSS
Look and Feel
• Navigation
• Look and feel
• Versioning
• Ribbon control
• Edit page
SharePoint administrator
1. Introduction to SharePoint
• SharePoint servers
• Architecture
• SharePoint server 2010 editions
• Hardware and software
2. Installing SharePoint server
• Understanding farm topologies
• Understanding standalone installation
• Service applications architecture
• Creating dedicated accounts in AD
• Installing SharePoint
• Creating Farm , Content and Central Admin DB
3. Configuring SharePoint
• Introduction of Central Admin
• Creating managed accounts
• Creating service applications
• Managing Timer Jobs
• How to use Configuration Wizard
4. Creating web applications
• Creating web Application
• Manage web application
• Web application settings
• Configure DNS and Host Headers
• Configure alternate access mapping
5. Site Collection Management
• Sites and site Collection
• Creating groups and managing
• Site collection features
• Site collection settings
• Site collection administrator
• Audit Logs
• Navigation
• Look and feel in site collection level
• Local Managed Meta Data
6. Configure service applications
• Search service application
• User profile service application
• Business connectivity service
• Excel service
• Managed Metadata service
• Etc…..
7. Power shell
• Backup and Restore
• Import and export
• Solution scripts
• Update solution
8. Health Monitoring
• Taking Logs and investigation using ULS.exe
• Event logs
• Computer usage
• Logging database
• Monitoring database logs size
9. Working with User Profile and MySite
• Understanding the user profile
• User profile properties
• Creating MySite
• Following documents, peoples and sites
Designer/Look and Feel
Designer
• Master pages
• Site Pages
• Application Pages
• Page Layouts
• BCS
• External Content Type
• External List
• Workflows
• Java script
• HTML
• CSS
Look and Feel
• Navigation
• Look and feel
• Versioning
• Ribbon control
• Edit page
Administration
Authentication
• Clasic Based
• CLAIMS Based
SHAREPOINT ( ADMIN, DEVELOPMENT ) => Experience - 10
Development
Introduction
• SharePoint overview
• Architecture of SharePoint
• SharePoint version History
• SharePoint Features
• Software and Hardware Requirements
• SharePoint Topology
SharePoint Structure
• Farm
• Web Application
• Root Site/ Top Level Site
• Site Collection
• Sub Site/ Web Site
• Lists/Library
• Items
Site Collections, webs, Lists and libraries
• Creating site collections
• Creating sub sites/ webs
• Working with site Templates
• Working with site Definition
• Creating and Managing Lists, Libraries
• Site Columns and Site Content Types
Web Parts
• Introduction to Web Parts
• Web Part architecture
• Working With Custom Web Parts
• Web part Custom Properties
• Connectable Web Parts
• Visual Web Parts
• Standard Web Parts
Features
• Web Application Level
• Site Collection Level
• Site Level
Workflows
• Introduction to Workflows
• Types of Workflow
1. Sequential Workflows
2. State Machine Workflows
• SharePoint Default Workflows
1. Approval
2. Signature
3. Three State
4. Signature
5. Disposition
• SharePoint Designer
1. List Workflow
2. Site Workflow
3. Reusable Workflow
• Visual Studio Workflows
SharePoint Business Intelligence (BI)
• Introduction
• Excel Services
• Access Services
• Report Services (SSRS)
• Performance Point Services
• Business Connectivity Service
• Visio
Business Connectivity Service
• Configuration of BCS
• Creating External content type
• Creating External List
• Sync data in both sides (DB to List and List to DB)
• Add All Authenticated Users
• Part of creating secure store service
Search
• Introduction
• Default search
• Fast search 2010
• No Fast search in 2013
Event Receivers
• Synchronous
• Asynchronous
InfoPath
• Overview of InfoPath
• Creating InfoPath form
• Publishing Form in Form Library
• Understanding Rules and Controls
Server Side object Model
• Server side API
• Server side Data Access
• CAML, SPSite and SPSiteData Query
• LINQ to SharePoint
• Event Receivers
• Workflows
Client Side Object Model
• Introduction to Client API (CSOM)
• Developing Using .Net, Silverlight and ECMA script
• WCF Data Service/OData/REST
Apps
• Introduction
• What is the use
Deployment Solutions
• Farm Solution
• Sandbox Solution
Designer/Look and Feel
Designer
• Master pages
• Site Pages
• Application Pages
• Page Layouts
• BCS
• External Content Type
• External List
• Workflows
• Java script
• HTML
• CSS
Look and Feel
• Navigation
• Look and feel
• Versioning
• Ribbon control
• Edit page
SharePoint administrator
1. Introduction to SharePoint
• SharePoint servers
• Architecture
• SharePoint server 2010 editions
• Hardware and software
2. Installing SharePoint server
• Understanding farm topologies
• Understanding standalone installation
• Service applications architecture
• Creating dedicated accounts in AD
• Installing SharePoint
• Creating Farm , Content and Central Admin DB
3. Configuring SharePoint
• Introduction of Central Admin
• Creating managed accounts
• Creating service applications
• Managing Timer Jobs
• How to use Configuration Wizard
4. Creating web applications
• Creating web Application
• Manage web application
• Web application settings
• Configure DNS and Host Headers
• Configure alternate access mapping
5. Site Collection Management
• Sites and site Collection
• Creating groups and managing
• Site collection features
• Site collection settings
• Site collection administrator
• Audit Logs
• Navigation
• Look and feel in site collection level
• Local Managed Meta Data
6. Configure service applications
• Search service application
• User profile service application
• Business connectivity service
• Excel service
• Managed Metadata service
• Etc…..
7. Power shell
• Backup and Restore
• Import and export
• Solution scripts
• Update solution
8. Health Monitoring
• Taking Logs and investigation using ULS.exe
• Event logs
• Computer usage
• Logging database
• Monitoring database logs size
9. Working with User Profile and MySite
• Understanding the user profile
• User profile properties
• Creating MySite
• Following documents, peoples and sites
Designer/Look and Feel
Designer
• Master pages
• Site Pages
• Application Pages
• Page Layouts
• BCS
• External Content Type
• External List
• Workflows
• Java script
• HTML
• CSS
Look and Feel
• Navigation
• Look and feel
• Versioning
• Ribbon control
• Edit page
Administration
Authentication
• Clasic Based
• CLAIMS Based
SHAREPOINT : -
SharePoint 2013 Training
SharePoint 2013 Developer Training Outline
1) Understanding SharePoint 2013
a. SharePoint 2013 Overview
b. SharePoint Product Topology & Architecture
c. Capabilities
d. SharePoint Deployment Options
e. Development & Extensibility Option Overview
f. Office 365 versus SharePoint On-premises
g. Working with Team Sites in SharePoint 2013
2) SharePoint Security
a. Authentication & Authorization
b. Claims Based Authentication
c. Programming Security
d. Securing Apps
e. App Identity
f. OAuth& Server-to-Server (S2S)
3) Working with Lists, Content Typesand Events
a. Working with Lists
b. Creating Site Columns
c. Designing Content Types
d. Using Content Types in Lists
e. List Instances
f. Event Receivers (Sites, Lists & List Items)
g. Remote Event Receivers
4) Document Libraries and Document Sets
a. Sites, Files, Folders and Pages
b. Document Libraries
c. Document Templates
d. Wiki Page Libraries
e. Document Sets
5) Pages and Navigation
a. SharePoint + ASP.NET
b. Master Pages
c. Site & Application Pages
d. Navigation
e. Chrome Control
f. Ribbon Extensibility
6) Developing SharePoint Solutions
a. Solution Packages
b. Farm Solutions
c. Sandbox Solutions
d. Breaking Out of the Sandbox
e. SharePoint Features
7) Server-Side SharePoint Development
a. Server-Side API Overview
b. Server-Side Data Access
c. CAML, SPQuery&SPSiteDataQuery
d. LINQ for SharePoint
e. Working with Large Data Sets
8) Client-Side SharePoint Development
a. Programming with JavaScript
b. Client Side Object Model (CSOM)
c. WCF Data Services / OData / REST API
d. Client-Side Cross Domain Calls
e. JavaScript Controls (Notifications, Status Messages, Toast Messages & Dialogs)
9) Developing Workflows
a. Understanding the Workflow Architecture
b. Windows Azure Workflow
c. Workflow Stages
d. Dynamic Values
e. Creating Workflows with SharePoint Designer 2013
f. Creating Workflows with Visual Studio 2012
10) Creating Custom Forms using InfoPath 2013
a. InfoPath 2013 Overview
b. Creating InfoPath Forms
c. Understanding Rules and Controls
d. Using Secondary Connections
e. Publishing InfoPath Forms to a Forms Library
f. Uploading a Reusable Info Form
11) Workflow in SharePoint 2013
a. SharePoint 2010 Workflow Architecture
b. SharePoint 2013 Workflow Architecture
c. Advantages to using SharePoint 2013 Workflows
d. Creating Workflows with SharePoint Designer
e. Deploying and Reusing Custom Workflow Logic
12) Business Connectivity Services
a. Business Connectivity Services (BCS) Architecture
b. Creating & Using External Content Type Models
c. BCS Apps
d. .NET Assembly Connectors
e. Authentication Options
f. Working with External Content Types
g. Connecting to OData Data Sources
13) Working with Enterprise Content Management and Managed Metadata
a. Document Management
b. Records Management
c. Document Sets
d. Managing Large Content Sets
e. eDiscovery
f. Managed Metadata
g. Programming with Managed Metadata (server & client side)
h. Managed Metadata Service
i. Creating Term Sets with Managed Metadata
j. Configuring Content Types Syndication
k. Records Management in SharePoint 2013
l. eDiscovery Center
14) Publishing Sites in SharePoint 2013
a. Publishing Sites in SharePoint 2010
b. Understanding Metadata-driven Navigation
c. Topic Pages, Content Pages and Page Layouts
d. Creating a Custom Brand with Designer Manager
e. Cross-site Publishing using a Product Catalog
f. Understanding Channels and Renditions
15) Developing SharePoint App Models
a. SharePoint App Model Overview
b. SharePoint Hosted Apps
c. Developer/Self-Hosted Apps
d. Azure Auto-Hosted Apps
e. Public & Corporate Marketplace
16) SharePoint Search
a. SharePoint Search Architecture
b. Search Web Parts
c. Customizing Search
d. Programming with the Search API
e. Entity Extraction
f. SharePoint 2013 Search Architecture
g. Configuring the Search Service
h. Executing Queries using KQL
i. Understanding Result Sources and Result Types
j. Creating Custom Query Rules and Result Types
17) Using Excel Services in SharePoint 2013
a. Excel Services Architecture
b. Publishing Workbooks
c. Publishing Charts and Tables
d. Exposing Excel Tables as OData Data Sources
e. Creating Pivot Charts and Pivot Reports
18) Configuring reporting services for SharePoint2013 integration 2013
a. SharePoint 2013 Reporting Overview
b. Understanding SQL Server Reporting Services
c. Creating SSRS Reports using Report Builder
d. Configuring SSRS Connections
e. Publishing SSS Reports to a Dashboard
f. Configuring reporting services for SharePoint integrated mode
g. Configuring the SharePoint 2010 reporting services add-in
h. Testing the reporting services configuration
19) Working with User Profiles and MySites
a. Understanding the User Profile Service
b. Extending User Profiles with Custom Properties
c. Exploring the SharePoint 2013 MySites
d. Sharing Documents and Content
e. Following People, Sites and Documents
20) Developing and deploying PerformancePoint analytic reports
a. Types of reports
i. Analytic charts
ii. Analytic grid
iii. Decomposition tree
iv. Show details
v. Excel Services
vi. KPI Details
vii. ProClarity Analytics Server Page
viii. Reporting services
ix. Strategy map
x. Web page
b. Creating your first report
c. Extending the report
• Conclusion
SharePoint 2013 Administration Training Objectives
• Install SharePoint Server 2013
• Scale a SharePoint 2013 farm
• Use the Central Administration site to perform day-to-day administrative activities
• Use the Windows Azure Access Control Service (ACS)
• Create and manage the content databases associated with a Web application
• Use the standard site templates available in SharePoint 2013
• Create and configure SharePoint tenancies
• Understand the Business Data Connectivity Service (BCS)
• Create External Content Types
• Configure a site collection as a Content Type Publishing Hub
• Create taxonomies of managed metadata
• Create and configure a User Profile Service Application
• Understand the search architecture and how to use it in custom solutions
• Configure the Sandboxed Code Service and monitor sandboxed solutions running within your farm
• Restore a SharePoint 2013 farm in the event of catastrophic server failure
• Migrate site content from a SharePoint 2010 farm to a SharePoint 2013 farm
SharePoint 2013 Administration Training Outline
• Getting started with SharePoint 2013
o SharePoint Foundation Architecture
o SharePoint 15 Product SKUs
o What`s New in SharePoint 2013
o Windows PowerShell Primer
• Installing SharePoint Server 2013
o Hardware Requirements
o Installing Prerequisite Software
o Creating Dedicated Service Accounts
o Installing SharePoint Server 2013
o Creating the Farm and Configuration Database
• Topology and Configuration
o Understanding Farm Topologies
o Configuring Managed Accounts
o Managing Timer Jobs
o Creating and Configuring Service Applications by hand
o Creating and Configuring Service Applications using PowerShell
• Configuring Security and User Authorization
o The Fundamentals of Claims-based Security
o Configuring Integrated Windows Authentication with Kerberos vs. NTLM
o Configuring Forms-based Authentication (FBA)
o Outsourcing User Management to External Identity Providers such as Windows Live
o Configuring a Trust to the Windows Azure Access Control Service (ACS)
• Creating and Configuring Web Applications
o Creating New Web Applications
o Configuring Web Application
o Managing Content Databases
o Creating Site Collections
o Configuring Self-service Site Collections
• Managing Site Collections and Tenancies
o Site Templates
o Capacity Planning
o Site Collection Security
o Understanding Tenancies
o Configuring Subscriptions
• Business Connectivity Services
o BCS Architecture External Data Sources
o Creating and Configuring External Contents Types
o Configuring Profile Pages and External Lists
o BCS Enhancements involving OData Support
o Using The Secure Store Service to configure Advanced Authentication Techniques
• The Managed Metadata Service
o Overview of the Managed Metadata Service
o Enhancement to the Managed Metadata Service in SharePoint 2013
o Creating and Managing Term Sets, Terms and Taxonomies
o Working with Document Sets
o Configuring a site collection as a Content Type Publishing Hub
• Configuring the User Profile Service
o Overview of User Profiles and Social Networking
o Create and Configuring a User Profile Service Application (UPA)
o Create and Configuring The User Profile Synchronization Service (UPS)
o Creating and configuring Audiences
o Creating and Managing My Sites
o Understanding User Task Synchronization using the Work Management Service
• Configuring a Search in SharePoint 2013
o The New Unified Search Architecture of SharePoint 2013
o Creating and Configuring Content Sources
o Understanding the Content Processing Pipeline
o Introduction to Result Sources, Result Types and Query Rules
o Working with Managed Properties
• Health Monitoring and Optimization
o The Developer Dashboard
o Working with ULS Logs
o The Logging Database
o Health Analyzer and Usage Reporting
o Timer Jobs and Server Affinity
o The New Request Manager in SharePoint 2013
• Deploying and Monitoring Custom Solutions
o Deploying and Managing Farm solutions and Sandboxed Solutions
o Introduction to the new SharePoint App Model
o Configuring SharePoint App Authentication using OAuth
o Configuring SharePoint App Authentication using Server-to-server (S2S) Trusts
• Preparing for Backup, Restore, and Disaster Recovery
o Versioning and Restoring Documents
o Configuring Recycle Bin Behavior
o Backup and Restore of site collections, Content Database and Farms
o Preparing for Disaster Recovery
o Recovering the Farm After Server Failure
• Upgrading Content from SharePoint 2010 to SharePoint 2013
o Upgrade Concepts and Terminology
o Deprecated Upgrade Techniques from SharePoint 2010
o Preparing for Database Attach
o Migrating Content
o SharePoint 2010 UI Mode versus SharePoint 2013 UI Mode
• Data security overview in SharePoint 2010
o Managed accounts
o Unattended service account
o Best practices
o
• Conclusion
Selector Example Selects
*
$("*") All elements
#id
$("#lastname") The element with id="lastname"
.class
$(".intro") All elements with class="intro"
.class,.class
$(".intro,.demo") All elements with the class "intro" or "demo"
element
$("p") All
elements
el1,el2,el3
$("h1,div,p") All
,
and
elements
:first
$("p:first") The first
element
:last
$("p:last") The last
element
:even
$("tr:even") All even
elements
:odd
$("tr:odd") All odd
elements
:first-child
$("p:first-child") All
elements that are the first child of their parent
:first-of-type
$("p:first-of-type") All
elements that are the first
element of their parent
:last-child
$("p:last-child") All
elements that are the last child of their parent
:last-of-type
$("p:last-of-type") All
elements that are the last
element of their parent
:nth-child(n)
$("p:nth-child(2)") All
elements that are the 2nd child of their parent
:nth-last-child(n)
$("p:nth-last-child(2)") All
elements that are the 2nd child of their parent, counting from the last child
:nth-of-type(n)
$("p:nth-of-type(2)") All
elements that are the 2nd
element of their parent
:nth-last-of-type(n)
$("p:nth-last-of-type(2)") All
elements that are the 2nd
element of their parent, counting from the last child
:only-child
$("p:only-child") All
elements that are the only child of their parent
:only-of-type
$("p:only-of-type") All
elements that are the only child, of its type, of their parent
parent > child
$("div > p") All
elements that are a direct child of a
element
parent descendant
$("div p") All
elements that are descendants of a
element
element + next
$("div + p") The
element that are next to each
elements
element ~ siblings
$("div ~ p") All
elements that are siblings of a
element
:eq(index)
$("ulli:eq(3)") The fourth element in a list (index starts at 0)
:gt(no)
$("ulli:gt(3)") List elements with an index greater than 3
:lt(no)
$("ulli:lt(3)") List elements with an index less than 3
:not(selector)
$("input:not(:empty)") All input elements that are not empty
:header
$(":header") All header elements
,
...
:animated
$(":animated") All animated elements
:focus
$(":focus") The element that currently has focus
:contains(text)
$(":contains(`Hello`)") All elements which contains the text "Hello"
:has(selector)
$("div:has(p)") All
elements that have a
element
:empty
$(":empty") All elements that are empty
:parent
$(":parent") All elements that are a parent of another element
:hidden
$("p:hidden") All hidden
elements
:visible
$("table:visible") All visible tables
:root
$(":root") The document`s root element
:lang(language)
$("p:lang(de)") All
elements with a lang attribute value starting with "de"
[attribute]
$("[href]") All elements with a href attribute
[attribute=value]
$("[href=`default.htm`]") All elements with a href attribute value equal to "default.htm"
[attribute!=value]
$("[href!=`default.htm`]") All elements with a href attribute value not equal to "default.htm"
[attribute$=value]
$("[href$=`.jpg`]") All elements with a href attribute value ending with ".jpg"
[attribute|=value]
$("[title|=`Tomorrow`]") All elements with a title attribute value equal to `Tomorrow`, or starting with `Tomorrow` followed by a hyphen
[attribute^=value]
$("[title^=`Tom`]") All elements with a title attribute value starting with "Tom"
[attribute~=value]
$("[title~=`hello`]") All elements with a title attribute value containing the specific word "hello"
[attribute*=value]
$("[title*=`hello`]") All elements with a title attribute value containing the word "hello"
:input
$(":input") All input elements
:text
$(":text") All input elements with type="text"
:password
$(":password") All input elements with type="password"
:radio
$(":radio") All input elements with type="radio"
:checkbox
$(":checkbox") All input elements with type="checkbox"
:submit
$(":submit") All input elements with type="submit"
:reset
$(":reset") All input elements with type="reset"
:button
$(":button") All input elements with type="button"
:image
$(":image") All input elements with type="image"
:file
$(":file") All input elements with type="file"
:enabled
$(":enabled") All enabled input elements
:disabled
$(":disabled") All disabled input elements
:selected
$(":selected") All selected input elements
:checked
$(":checked") All checked input elements
SharePoint 2013 Training
SharePoint 2013 Developer Training Outline
1) Understanding SharePoint 2013
a. SharePoint 2013 Overview
b. SharePoint Product Topology & Architecture
c. Capabilities
d. SharePoint Deployment Options
e. Development & Extensibility Option Overview
f. Office 365 versus SharePoint On-premises
g. Working with Team Sites in SharePoint 2013
2) SharePoint Security
a. Authentication & Authorization
b. Claims Based Authentication
c. Programming Security
d. Securing Apps
e. App Identity
f. OAuth& Server-to-Server (S2S)
3) Working with Lists, Content Typesand Events
a. Working with Lists
b. Creating Site Columns
c. Designing Content Types
d. Using Content Types in Lists
e. List Instances
f. Event Receivers (Sites, Lists & List Items)
g. Remote Event Receivers
4) Document Libraries and Document Sets
a. Sites, Files, Folders and Pages
b. Document Libraries
c. Document Templates
d. Wiki Page Libraries
e. Document Sets
5) Pages and Navigation
a. SharePoint + ASP.NET
b. Master Pages
c. Site & Application Pages
d. Navigation
e. Chrome Control
f. Ribbon Extensibility
6) Developing SharePoint Solutions
a. Solution Packages
b. Farm Solutions
c. Sandbox Solutions
d. Breaking Out of the Sandbox
e. SharePoint Features
7) Server-Side SharePoint Development
a. Server-Side API Overview
b. Server-Side Data Access
c. CAML, SPQuery&SPSiteDataQuery
d. LINQ for SharePoint
e. Working with Large Data Sets
8) Client-Side SharePoint Development
a. Programming with JavaScript
b. Client Side Object Model (CSOM)
c. WCF Data Services / OData / REST API
d. Client-Side Cross Domain Calls
e. JavaScript Controls (Notifications, Status Messages, Toast Messages & Dialogs)
9) Developing Workflows
a. Understanding the Workflow Architecture
b. Windows Azure Workflow
c. Workflow Stages
d. Dynamic Values
e. Creating Workflows with SharePoint Designer 2013
f. Creating Workflows with Visual Studio 2012
10) Creating Custom Forms using InfoPath 2013
a. InfoPath 2013 Overview
b. Creating InfoPath Forms
c. Understanding Rules and Controls
d. Using Secondary Connections
e. Publishing InfoPath Forms to a Forms Library
f. Uploading a Reusable Info Form
11) Workflow in SharePoint 2013
a. SharePoint 2010 Workflow Architecture
b. SharePoint 2013 Workflow Architecture
c. Advantages to using SharePoint 2013 Workflows
d. Creating Workflows with SharePoint Designer
e. Deploying and Reusing Custom Workflow Logic
12) Business Connectivity Services
a. Business Connectivity Services (BCS) Architecture
b. Creating & Using External Content Type Models
c. BCS Apps
d. .NET Assembly Connectors
e. Authentication Options
f. Working with External Content Types
g. Connecting to OData Data Sources
13) Working with Enterprise Content Management and Managed Metadata
a. Document Management
b. Records Management
c. Document Sets
d. Managing Large Content Sets
e. eDiscovery
f. Managed Metadata
g. Programming with Managed Metadata (server & client side)
h. Managed Metadata Service
i. Creating Term Sets with Managed Metadata
j. Configuring Content Types Syndication
k. Records Management in SharePoint 2013
l. eDiscovery Center
14) Publishing Sites in SharePoint 2013
a. Publishing Sites in SharePoint 2010
b. Understanding Metadata-driven Navigation
c. Topic Pages, Content Pages and Page Layouts
d. Creating a Custom Brand with Designer Manager
e. Cross-site Publishing using a Product Catalog
f. Understanding Channels and Renditions
15) Developing SharePoint App Models
a. SharePoint App Model Overview
b. SharePoint Hosted Apps
c. Developer/Self-Hosted Apps
d. Azure Auto-Hosted Apps
e. Public & Corporate Marketplace
16) SharePoint Search
a. SharePoint Search Architecture
b. Search Web Parts
c. Customizing Search
d. Programming with the Search API
e. Entity Extraction
f. SharePoint 2013 Search Architecture
g. Configuring the Search Service
h. Executing Queries using KQL
i. Understanding Result Sources and Result Types
j. Creating Custom Query Rules and Result Types
17) Using Excel Services in SharePoint 2013
a. Excel Services Architecture
b. Publishing Workbooks
c. Publishing Charts and Tables
d. Exposing Excel Tables as OData Data Sources
e. Creating Pivot Charts and Pivot Reports
18) Configuring reporting services for SharePoint2013 integration 2013
a. SharePoint 2013 Reporting Overview
b. Understanding SQL Server Reporting Services
c. Creating SSRS Reports using Report Builder
d. Configuring SSRS Connections
e. Publishing SSS Reports to a Dashboard
f. Configuring reporting services for SharePoint integrated mode
g. Configuring the SharePoint 2010 reporting services add-in
h. Testing the reporting services configuration
19) Working with User Profiles and MySites
a. Understanding the User Profile Service
b. Extending User Profiles with Custom Properties
c. Exploring the SharePoint 2013 MySites
d. Sharing Documents and Content
e. Following People, Sites and Documents
20) Developing and deploying PerformancePoint analytic reports
a. Types of reports
i. Analytic charts
ii. Analytic grid
iii. Decomposition tree
iv. Show details
v. Excel Services
vi. KPI Details
vii. ProClarity Analytics Server Page
viii. Reporting services
ix. Strategy map
x. Web page
b. Creating your first report
c. Extending the report
• Conclusion
SharePoint 2013 Administration Training Objectives
• Install SharePoint Server 2013
• Scale a SharePoint 2013 farm
• Use the Central Administration site to perform day-to-day administrative activities
• Use the Windows Azure Access Control Service (ACS)
• Create and manage the content databases associated with a Web application
• Use the standard site templates available in SharePoint 2013
• Create and configure SharePoint tenancies
• Understand the Business Data Connectivity Service (BCS)
• Create External Content Types
• Configure a site collection as a Content Type Publishing Hub
• Create taxonomies of managed metadata
• Create and configure a User Profile Service Application
• Understand the search architecture and how to use it in custom solutions
• Configure the Sandboxed Code Service and monitor sandboxed solutions running within your farm
• Restore a SharePoint 2013 farm in the event of catastrophic server failure
• Migrate site content from a SharePoint 2010 farm to a SharePoint 2013 farm
SharePoint 2013 Administration Training Outline
• Getting started with SharePoint 2013
o SharePoint Foundation Architecture
o SharePoint 15 Product SKUs
o What`s New in SharePoint 2013
o Windows PowerShell Primer
• Installing SharePoint Server 2013
o Hardware Requirements
o Installing Prerequisite Software
o Creating Dedicated Service Accounts
o Installing SharePoint Server 2013
o Creating the Farm and Configuration Database
• Topology and Configuration
o Understanding Farm Topologies
o Configuring Managed Accounts
o Managing Timer Jobs
o Creating and Configuring Service Applications by hand
o Creating and Configuring Service Applications using PowerShell
• Configuring Security and User Authorization
o The Fundamentals of Claims-based Security
o Configuring Integrated Windows Authentication with Kerberos vs. NTLM
o Configuring Forms-based Authentication (FBA)
o Outsourcing User Management to External Identity Providers such as Windows Live
o Configuring a Trust to the Windows Azure Access Control Service (ACS)
• Creating and Configuring Web Applications
o Creating New Web Applications
o Configuring Web Application
o Managing Content Databases
o Creating Site Collections
o Configuring Self-service Site Collections
• Managing Site Collections and Tenancies
o Site Templates
o Capacity Planning
o Site Collection Security
o Understanding Tenancies
o Configuring Subscriptions
• Business Connectivity Services
o BCS Architecture External Data Sources
o Creating and Configuring External Contents Types
o Configuring Profile Pages and External Lists
o BCS Enhancements involving OData Support
o Using The Secure Store Service to configure Advanced Authentication Techniques
• The Managed Metadata Service
o Overview of the Managed Metadata Service
o Enhancement to the Managed Metadata Service in SharePoint 2013
o Creating and Managing Term Sets, Terms and Taxonomies
o Working with Document Sets
o Configuring a site collection as a Content Type Publishing Hub
• Configuring the User Profile Service
o Overview of User Profiles and Social Networking
o Create and Configuring a User Profile Service Application (UPA)
o Create and Configuring The User Profile Synchronization Service (UPS)
o Creating and configuring Audiences
o Creating and Managing My Sites
o Understanding User Task Synchronization using the Work Management Service
• Configuring a Search in SharePoint 2013
o The New Unified Search Architecture of SharePoint 2013
o Creating and Configuring Content Sources
o Understanding the Content Processing Pipeline
o Introduction to Result Sources, Result Types and Query Rules
o Working with Managed Properties
• Health Monitoring and Optimization
o The Developer Dashboard
o Working with ULS Logs
o The Logging Database
o Health Analyzer and Usage Reporting
o Timer Jobs and Server Affinity
o The New Request Manager in SharePoint 2013
• Deploying and Monitoring Custom Solutions
o Deploying and Managing Farm solutions and Sandboxed Solutions
o Introduction to the new SharePoint App Model
o Configuring SharePoint App Authentication using OAuth
o Configuring SharePoint App Authentication using Server-to-server (S2S) Trusts
• Preparing for Backup, Restore, and Disaster Recovery
o Versioning and Restoring Documents
o Configuring Recycle Bin Behavior
o Backup and Restore of site collections, Content Database and Farms
o Preparing for Disaster Recovery
o Recovering the Farm After Server Failure
• Upgrading Content from SharePoint 2010 to SharePoint 2013
o Upgrade Concepts and Terminology
o Deprecated Upgrade Techniques from SharePoint 2010
o Preparing for Database Attach
o Migrating Content
o SharePoint 2010 UI Mode versus SharePoint 2013 UI Mode
• Data security overview in SharePoint 2010
o Managed accounts
o Unattended service account
o Best practices
o
• Conclusion
Selector Example Selects
*
$("*") All elements
#id
$("#lastname") The element with id="lastname"
.class
$(".intro") All elements with class="intro"
.class,.class
$(".intro,.demo") All elements with the class "intro" or "demo"
element
$("p") All
elements
el1,el2,el3
$("h1,div,p") All
,
and
elements
:first
$("p:first") The first
element
:last
$("p:last") The last
element
:even
$("tr:even") All even
elements
:odd
$("tr:odd") All odd
elements
:first-child
$("p:first-child") All
elements that are the first child of their parent
:first-of-type
$("p:first-of-type") All
elements that are the first
element of their parent
:last-child
$("p:last-child") All
elements that are the last child of their parent
:last-of-type
$("p:last-of-type") All
elements that are the last
element of their parent
:nth-child(n)
$("p:nth-child(2)") All
elements that are the 2nd child of their parent
:nth-last-child(n)
$("p:nth-last-child(2)") All
elements that are the 2nd child of their parent, counting from the last child
:nth-of-type(n)
$("p:nth-of-type(2)") All
elements that are the 2nd
element of their parent
:nth-last-of-type(n)
$("p:nth-last-of-type(2)") All
elements that are the 2nd
element of their parent, counting from the last child
:only-child
$("p:only-child") All
elements that are the only child of their parent
:only-of-type
$("p:only-of-type") All
elements that are the only child, of its type, of their parent
parent > child
$("div > p") All
elements that are a direct child of a
element
parent descendant
$("div p") All
elements that are descendants of a
element
element + next
$("div + p") The
element that are next to each
elements
element ~ siblings
$("div ~ p") All
elements that are siblings of a
element
:eq(index)
$("ulli:eq(3)") The fourth element in a list (index starts at 0)
:gt(no)
$("ulli:gt(3)") List elements with an index greater than 3
:lt(no)
$("ulli:lt(3)") List elements with an index less than 3
:not(selector)
$("input:not(:empty)") All input elements that are not empty
:header
$(":header") All header elements
,
...
:animated
$(":animated") All animated elements
:focus
$(":focus") The element that currently has focus
:contains(text)
$(":contains(`Hello`)") All elements which contains the text "Hello"
:has(selector)
$("div:has(p)") All
elements that have a
element
:empty
$(":empty") All elements that are empty
:parent
$(":parent") All elements that are a parent of another element
:hidden
$("p:hidden") All hidden
elements
:visible
$("table:visible") All visible tables
:root
$(":root") The document`s root element
:lang(language)
$("p:lang(de)") All
elements with a lang attribute value starting with "de"
[attribute]
$("[href]") All elements with a href attribute
[attribute=value]
$("[href=`default.htm`]") All elements with a href attribute value equal to "default.htm"
[attribute!=value]
$("[href!=`default.htm`]") All elements with a href attribute value not equal to "default.htm"
[attribute$=value]
$("[href$=`.jpg`]") All elements with a href attribute value ending with ".jpg"
[attribute|=value]
$("[title|=`Tomorrow`]") All elements with a title attribute value equal to `Tomorrow`, or starting with `Tomorrow` followed by a hyphen
[attribute^=value]
$("[title^=`Tom`]") All elements with a title attribute value starting with "Tom"
[attribute~=value]
$("[title~=`hello`]") All elements with a title attribute value containing the specific word "hello"
[attribute*=value]
$("[title*=`hello`]") All elements with a title attribute value containing the word "hello"
:input
$(":input") All input elements
:text
$(":text") All input elements with type="text"
:password
$(":password") All input elements with type="password"
:radio
$(":radio") All input elements with type="radio"
:checkbox
$(":checkbox") All input elements with type="checkbox"
:submit
$(":submit") All input elements with type="submit"
:reset
$(":reset") All input elements with type="reset"
:button
$(":button") All input elements with type="button"
:image
$(":image") All input elements with type="image"
:file
$(":file") All input elements with type="file"
:enabled
$(":enabled") All enabled input elements
:disabled
$(":disabled") All disabled input elements
:selected
$(":selected") All selected input elements
:checked
$(":checked") All checked input elements
MS-AX DYNAMIC TECHNICAL & CRM : -
GPS INFOTECH
MS_AX 2012 (TECHNICAL)
Basics of X++ and Syntax issues:
1. Variables and Data Types
a) Primitive Data Types
b) Composite Data Types
c) Extended Data Types (EDTs)
d) Conversion of Data Types
2. Statements and Loops
a) Exception Handling
b) Print Statements
c) Comments
3. TODO Comments for X++ Developer Tasks
4. Conditional Statements
a. Operators
b. Assignment Operators
c. Arithmetic Operators
d. Expression Operators: Is and As for Inheritance
e. Relational Operators
5. Data Selection and Manipulation
a) Select
b) Insert
c) Update
d) Delete
6. Attributes on X++ Types and Methods
7. Classes and Methods
a. Classes in X++
b. Methods in X++
c. Interfaces Overview
d. Microsoft Dynamics AX Class Overview(Standard classes)
8. Functions and Macros
a. X++ Functions
b. X++ Function Categories and their Functions
c. Macros in X++
9. X++ Syntaxes
Development Issues:
1. Development Environment and Tools
1. Development environment
2. Files (Client, Application, Server )
3. Transfer of modifications to test environment
4. AOS setup
5. Application architecture
6. X-references
7. Application hierarchy browser
8. Microsoft Visio
9. Performance/ Monitoring
10. Debugger
11. System Monitoring
12. Method Trace
13. Development Warnings
14. SQL Trace
15. Query Time Limit
16. Dead Locks
17. Database Trace
18. Code Profiler
19. Application upgrade
20. Upgrade project
21. Compare tool
2. Fetching Data
1. Query (Structure, Properties)
2. Cost based optimizer
3. While select (Syntax, Qualifiers, Field lists, Join, Placeholders/Literals)
4. Caching
5. Locking
6. Temporary tables
3. Classes
1. Object Oriented implementation in Microsoft Dynamics AX
2. Most important differences from the standard application and C#, VB.NET and Java examples
3. Class declaration
4. Variables
5. Data members
6. Methods (Qualifiers, parameters and return value)
7. Overriding/Overloading
8. Access modifiers
9. Types of Microsoft Dynamics AX Classes (Examples in parenthesis) Application classes
10. Basic functionality (Dialog)
11. Wrapping of general routines (Number Sequence)
12. Form support classes (Ledger Journal Engine)
13. Table “polymorphism” (Sales Table Type)
14. API to the modules (Ledger Voucher, CustVoucher)
15. Batch processing (Run Base) Kernel classes
16. Tools(Binary, Dialog Box, Record Sorted List)
17. Application objects (Form Data Source, Query Build Range), Integration (COM, ODBC, IO)
18. System classes (xApplication, xCompany, xInfo)
19. Run base framework
20. Args objects
4. Forms
1. Architecture
2. AOT (general methods, data source, design)
3. Kernel classes and object model
4. Properties
5. Best practice (initializing via args, Design, Validation/Modification)
6. Placement of code (priority : Table, Support Class, Data source, Design)
7. Top ten methods to use
8. Handles to the objects in forms
9. Interaction between form and Run base classes
10. Queries Synchronizing (Active/Passive), Joins, Modify by
11. Code (Filtering, Sorting, Aggregation)
12. Special controls in short (ActiveX, List view, Table, Tree, Window)
13. Special forms (Lookup, Wizard)
14. Activate a form from X++ using Class Factory
MS_AX 2012 (TECHNICAL)
Basics of X++ and Syntax issues:
1. Variables and Data Types
a) Primitive Data Types
b) Composite Data Types
c) Extended Data Types (EDTs)
d) Conversion of Data Types
2. Statements and Loops
a) Exception Handling
b) Print Statements
c) Comments
3. TODO Comments for X++ Developer Tasks
4. Conditional Statements
a. Operators
b. Assignment Operators
c. Arithmetic Operators
d. Expression Operators: Is and As for Inheritance
e. Relational Operators
5. Data Selection and Manipulation
a) Select
b) Insert
c) Update
d) Delete
6. Attributes on X++ Types and Methods
7. Classes and Methods
a. Classes in X++
b. Methods in X++
c. Interfaces Overview
d. Microsoft Dynamics AX Class Overview(Standard classes)
8. Functions and Macros
a. X++ Functions
b. X++ Function Categories and their Functions
c. Macros in X++
9. X++ Syntaxes
Development Issues:
1. Development Environment and Tools
1. Development environment
2. Files (Client, Application, Server )
3. Transfer of modifications to test environment
4. AOS setup
5. Application architecture
6. X-references
7. Application hierarchy browser
8. Microsoft Visio
9. Performance/ Monitoring
10. Debugger
11. System Monitoring
12. Method Trace
13. Development Warnings
14. SQL Trace
15. Query Time Limit
16. Dead Locks
17. Database Trace
18. Code Profiler
19. Application upgrade
20. Upgrade project
21. Compare tool
2. Fetching Data
1. Query (Structure, Properties)
2. Cost based optimizer
3. While select (Syntax, Qualifiers, Field lists, Join, Placeholders/Literals)
4. Caching
5. Locking
6. Temporary tables
3. Classes
1. Object Oriented implementation in Microsoft Dynamics AX
2. Most important differences from the standard application and C#, VB.NET and Java examples
3. Class declaration
4. Variables
5. Data members
6. Methods (Qualifiers, parameters and return value)
7. Overriding/Overloading
8. Access modifiers
9. Types of Microsoft Dynamics AX Classes (Examples in parenthesis) Application classes
10. Basic functionality (Dialog)
11. Wrapping of general routines (Number Sequence)
12. Form support classes (Ledger Journal Engine)
13. Table “polymorphism” (Sales Table Type)
14. API to the modules (Ledger Voucher, CustVoucher)
15. Batch processing (Run Base) Kernel classes
16. Tools(Binary, Dialog Box, Record Sorted List)
17. Application objects (Form Data Source, Query Build Range), Integration (COM, ODBC, IO)
18. System classes (xApplication, xCompany, xInfo)
19. Run base framework
20. Args objects
4. Forms
1. Architecture
2. AOT (general methods, data source, design)
3. Kernel classes and object model
4. Properties
5. Best practice (initializing via args, Design, Validation/Modification)
6. Placement of code (priority : Table, Support Class, Data source, Design)
7. Top ten methods to use
8. Handles to the objects in forms
9. Interaction between form and Run base classes
10. Queries Synchronizing (Active/Passive), Joins, Modify by
11. Code (Filtering, Sorting, Aggregation)
12. Special controls in short (ActiveX, List view, Table, Tree, Window)
13. Special forms (Lookup, Wizard)
14. Activate a form from X++ using Class Factory
PEGA BPM : -
PEGA 7(PRPC) Content
• Introduction to BPM
• Introduction to PRPC
• Pega 7.1 Software Installation
• Creating Organization Setup
• Operator ID
• Creating Application
• Creating Rule Set
• Ruleset Versions
• Creating Users & Portals
• Building New Application
• DCO
• Application Profiler
• Application Accelerator
• Application Express
• Introduction to Class Structure
• Types of Classes
• Creating Abstract Class
• Creating Concrete Class
• Selecting Class Structure
• Working with Class group/Work pool
• Introduction to Data Model
• Creating Data Tables
• Types of Properties & Models
• Creating Properties
• Change the Appearance of a property
• Create Embedded Properties
• Introduction to User Interface and Form Design
• Introduction to Process Definition
• Check-in/Check-Out Functionality
• User Interface
• Create a Section
• Create a Section Containing Multiple Layouts
• Adding a Section to a Flow Action
• Calling another Section in a Section
• Selecting the Layout
• Creating Flow Action
• Creating Harness
• Process Definition
• Different Shapes used in Flow & their purpose
• Create Main Flow/Process flow
• Create a Sub-flow/Screen flow
• How to run the flow or creating work object
• Create Tabbed/Tree navigation Screen Flow
• Call a Sub-flow from another flow or from same flow
• Design and Implement Screen flow
• How to select Screen flow types
• Advanced UI
• Create a Dynamic Select Control
• Repeat Layout (Row/Column)
• Conditionally display a Section
• Activities and Methods
• Explain the purpose of different taps in Activity
• Understand purpose of Pages & Classes
• Different Methods used in Activities
• How to call Activity from another activity
• Different ways to call Activities
• Types of Activities
• Validations
• Types of Validations
• Rule-Edit-Validtion
• Rule-Obj-Validation
• Constraints
• Difference between Rule-Edit-Validation and Rule-Object-Validation
• Difference between ROV & Constraints
• Decision Rules
• Decision Table
• Decision Tree
• Calling Decision Rules in Flow
• Calling Decision rules in Expressions
• Declarative Rules
• Declare Expressions
• Declare Constraints
• Declare On Change
• Declare Pages
• Advanced Activities
• Create an Activity with a precondition and a Transition
• Create an Activity to populate a Dynamic Select
• Creating activity for Calling SOAP Services
• Assigning the Work
• Introduction on Routing
• To Work List
• To Work Basket
• Creating Work Group/Work basket
• SLA (Service Level Agreements)
• Define an SLA
• Assigning SLA to Assignment
• Testing SLA
• How to Send a Correspondence (E-mail)
• Configuring E-mail (Inbound/Outbound)
• Work Parties
• Creating Work-Party
• Adding Work-party to Flow
• Agents
• Reports
• Migration/Deployment (Import & Export)
• Debugging Tools
• Clipboard
• Tracer
• Preflight
• Brace
• PAL
• Documenting the Application
• Connecting to External Database Using Connect-SQL
• How to Use Dynamic SQL When connecting to External DB
• Configuring Web Services (SOAP)
• Integration Connect & Service SOAP
• New Features in Pega 7
• Difference between Versions
• PRPC Guardrails
• Direct Capture of Objectives
• Project Implementation Methodology
• Resume Preparation
• Interview Tips
• Introduction to BPM
• Introduction to PRPC
• Pega 7.1 Software Installation
• Creating Organization Setup
• Operator ID
• Creating Application
• Creating Rule Set
• Ruleset Versions
• Creating Users & Portals
• Building New Application
• DCO
• Application Profiler
• Application Accelerator
• Application Express
• Introduction to Class Structure
• Types of Classes
• Creating Abstract Class
• Creating Concrete Class
• Selecting Class Structure
• Working with Class group/Work pool
• Introduction to Data Model
• Creating Data Tables
• Types of Properties & Models
• Creating Properties
• Change the Appearance of a property
• Create Embedded Properties
• Introduction to User Interface and Form Design
• Introduction to Process Definition
• Check-in/Check-Out Functionality
• User Interface
• Create a Section
• Create a Section Containing Multiple Layouts
• Adding a Section to a Flow Action
• Calling another Section in a Section
• Selecting the Layout
• Creating Flow Action
• Creating Harness
• Process Definition
• Different Shapes used in Flow & their purpose
• Create Main Flow/Process flow
• Create a Sub-flow/Screen flow
• How to run the flow or creating work object
• Create Tabbed/Tree navigation Screen Flow
• Call a Sub-flow from another flow or from same flow
• Design and Implement Screen flow
• How to select Screen flow types
• Advanced UI
• Create a Dynamic Select Control
• Repeat Layout (Row/Column)
• Conditionally display a Section
• Activities and Methods
• Explain the purpose of different taps in Activity
• Understand purpose of Pages & Classes
• Different Methods used in Activities
• How to call Activity from another activity
• Different ways to call Activities
• Types of Activities
• Validations
• Types of Validations
• Rule-Edit-Validtion
• Rule-Obj-Validation
• Constraints
• Difference between Rule-Edit-Validation and Rule-Object-Validation
• Difference between ROV & Constraints
• Decision Rules
• Decision Table
• Decision Tree
• Calling Decision Rules in Flow
• Calling Decision rules in Expressions
• Declarative Rules
• Declare Expressions
• Declare Constraints
• Declare On Change
• Declare Pages
• Advanced Activities
• Create an Activity with a precondition and a Transition
• Create an Activity to populate a Dynamic Select
• Creating activity for Calling SOAP Services
• Assigning the Work
• Introduction on Routing
• To Work List
• To Work Basket
• Creating Work Group/Work basket
• SLA (Service Level Agreements)
• Define an SLA
• Assigning SLA to Assignment
• Testing SLA
• How to Send a Correspondence (E-mail)
• Configuring E-mail (Inbound/Outbound)
• Work Parties
• Creating Work-Party
• Adding Work-party to Flow
• Agents
• Reports
• Migration/Deployment (Import & Export)
• Debugging Tools
• Clipboard
• Tracer
• Preflight
• Brace
• PAL
• Documenting the Application
• Connecting to External Database Using Connect-SQL
• How to Use Dynamic SQL When connecting to External DB
• Configuring Web Services (SOAP)
• Integration Connect & Service SOAP
• New Features in Pega 7
• Difference between Versions
• PRPC Guardrails
• Direct Capture of Objectives
• Project Implementation Methodology
• Resume Preparation
• Interview Tips
.NET ( C# , ASP , ADO ) : -
.Net Course content
Introduction to .NET Framework
• .NET Framework
• OverView
• CLR,CLS
• MSIL
• Assemblies
• NameSpaces
• .NET Languages
• Dll’s(Vs)Exe’s
Basics:
• Getting Started
• Using Variables and Arrays
• Methods and Parameters
• Decision Structures and Loops
• Handling Errors and Exceptions
OBJECT ORIENTED PROGRAMMING
• Classes, structures and enums
• Constructors
• Destructors
• Properties
• Inheritance
-Shadowing(new methods)
-Overriding
• Method Overloading
• this and base Keyword
• Sealed classes
• Interfaces, Abstract Classes
• Working with Delegates
• Designing and Implementing Events
• Generics
• Sealed classes and Partial classes
• C#.NET Application Architecture
• Solution, Projects
• Compiling, Debugging and Running in IDE
INTRODUCTION TO GUI PROGRAMMING
• System.Windows.Forms Assembly
• System.Drawing
• Visual Inheritance
WORKING WITH COLLECTIONS, IO
System.IO
• Readers and Writers
• Streams
System.Collections
• Hashtable
• ArrayList
ADO.NET I:
• Introduction
• Architecture
• System.Data.Dll
• System.Data.Oledb
• System.Data.SqlClient
• Data Readers
• Command Object
• Procedure Execution (PL/SQL)
ADO.NET II : Data Adapters and DataSets
• Data Tables
• Data Relations
• Data Views
ASP.NET
ASP.NET
• Basics
• Web Programming
• HTML, DHTML
• JavaScript
• IIS
• ASP
ASP.NET INTRODUCTION
• Difference Between ASP and ASP.NET
• Architecture
• Inline Technique & Code-Behind Technique
• Code Render Blocks
• Server Controls
• Page Basics, Page lifecycle
• Post back Request
• View State, Directives
PROGRAMMING WITH SERVER CONTROLS
• Html Server Controls
• Web Server Controls
• Basic Web Controls
• List Controls, Data Controls
• Adv Controls, User Controls
CUSTOM CONTROL Development
THEMES AND SKINS
MASTERPAGES AND SITE NAVIGATION
ADO.NET PROGRAMMING
• Architecture
• DataReaders and DataSets
• Command Object
• Procedure Execution
• Data Adapter and Data Set
• Data Tables
• Data Relation
• Data Views
• Updating Dataset
ADO.NET AND ASP.NET
• Working with Data Controls
• GridView
-Inserting, Updating, Deleting
-Sorting in Data Grid
-Paging in Data Grid
• DataSource Controls
• Dataset
• DetailsView
• FormView
• Data List
• Repeater Control
• Crystal Reports
STATE MANAGEMENT WITH ASP.NET
• Context
• View State
• Cookie State
• Session State
• Session Tracking
• Application Object
• Session and Application Events
ASP .NET APPLICATION TUNING
• Machine.Config & Web.Config.
• App Setting
• Compilation Settings
• Custom Error Settings
• Session State Settings
• InProcess & OutProcess Sesstion States
• State Server & SQL Server
• Cookieless Session State
• Application and Global.ASAX
CACHING
• Introduction to Caching
• Types of Caching
• Page Caching
• Diff. between Webuser Controls & Custom Controls
• Page fragmentation Caching
• Data Caching
• Data Caching – Application Object
WEB SERVICES
• Architecture
• WSDL, SOAP, UDDI
• Publishing and Consuming Web Services
• Web Client
• Windows Client
• Caching Web Services
• Security in Web Services
MVC Training Course Overview
ASP.NET MVC Introduction
MVC Basics
• Controller
• Action Methods
• View
• Model
• MVC Architecture
• View Engine
• Razor View Engine & Syntaxes
• Execution Flow of MVC
Layout Views
HTML Helpers
Working with Forms in MVC
Scaffold Templates
CRUD (Create, Retrieve, Update, Delete Operations on a db table)
Validations in MVC
Data Annotations
Partial Views
Action Filters
URL Routing
jQuery-AJAX in MVC
Return Types of Action Methods
.Net Course content
Introduction to .NET Framework
• .NET Framework
• OverView
• CLR,CLS
• MSIL
• Assemblies
• NameSpaces
• .NET Languages
• Dll’s(Vs)Exe’s
Basics:
• Getting Started
• Using Variables and Arrays
• Methods and Parameters
• Decision Structures and Loops
• Handling Errors and Exceptions
OBJECT ORIENTED PROGRAMMING
• Classes, structures and enums
• Constructors
• Destructors
• Properties
• Inheritance
-Shadowing(new methods)
-Overriding
• Method Overloading
• this and base Keyword
• Sealed classes
• Interfaces, Abstract Classes
• Working with Delegates
• Designing and Implementing Events
• Generics
• Sealed classes and Partial classes
• C#.NET Application Architecture
• Solution, Projects
• Compiling, Debugging and Running in IDE
INTRODUCTION TO GUI PROGRAMMING
• System.Windows.Forms Assembly
• System.Drawing
• Visual Inheritance
WORKING WITH COLLECTIONS, IO
System.IO
• Readers and Writers
• Streams
System.Collections
• Hashtable
• ArrayList
ADO.NET I:
• Introduction
• Architecture
• System.Data.Dll
• System.Data.Oledb
• System.Data.SqlClient
• Data Readers
• Command Object
• Procedure Execution (PL/SQL)
ADO.NET II : Data Adapters and DataSets
• Data Tables
• Data Relations
• Data Views
ASP.NET
ASP.NET
• Basics
• Web Programming
• HTML, DHTML
• JavaScript
• IIS
• ASP
ASP.NET INTRODUCTION
• Difference Between ASP and ASP.NET
• Architecture
• Inline Technique & Code-Behind Technique
• Code Render Blocks
• Server Controls
• Page Basics, Page lifecycle
• Post back Request
• View State, Directives
PROGRAMMING WITH SERVER CONTROLS
• Html Server Controls
• Web Server Controls
• Basic Web Controls
• List Controls, Data Controls
• Adv Controls, User Controls
CUSTOM CONTROL Development
THEMES AND SKINS
MASTERPAGES AND SITE NAVIGATION
ADO.NET PROGRAMMING
• Architecture
• DataReaders and DataSets
• Command Object
• Procedure Execution
• Data Adapter and Data Set
• Data Tables
• Data Relation
• Data Views
• Updating Dataset
ADO.NET AND ASP.NET
• Working with Data Controls
• GridView
-Inserting, Updating, Deleting
-Sorting in Data Grid
-Paging in Data Grid
• DataSource Controls
• Dataset
• DetailsView
• FormView
• Data List
• Repeater Control
• Crystal Reports
STATE MANAGEMENT WITH ASP.NET
• Context
• View State
• Cookie State
• Session State
• Session Tracking
• Application Object
• Session and Application Events
ASP .NET APPLICATION TUNING
• Machine.Config & Web.Config.
• App Setting
• Compilation Settings
• Custom Error Settings
• Session State Settings
• InProcess & OutProcess Sesstion States
• State Server & SQL Server
• Cookieless Session State
• Application and Global.ASAX
CACHING
• Introduction to Caching
• Types of Caching
• Page Caching
• Diff. between Webuser Controls & Custom Controls
• Page fragmentation Caching
• Data Caching
• Data Caching – Application Object
WEB SERVICES
• Architecture
• WSDL, SOAP, UDDI
• Publishing and Consuming Web Services
• Web Client
• Windows Client
• Caching Web Services
• Security in Web Services
MVC Training Course Overview
ASP.NET MVC Introduction
MVC Basics
• Controller
• Action Methods
• View
• Model
• MVC Architecture
• View Engine
• Razor View Engine & Syntaxes
• Execution Flow of MVC
Layout Views
HTML Helpers
Working with Forms in MVC
Scaffold Templates
CRUD (Create, Retrieve, Update, Delete Operations on a db table)
Validations in MVC
Data Annotations
Partial Views
Action Filters
URL Routing
jQuery-AJAX in MVC
Return Types of Action Methods
MVC, WCF, WWF, : -
MVC Training Course Overview
ASP.NET MVC Introduction
MVC Basics
• Controller
• Action Methods
• View
• Model
• MVC Architecture
• View Engine
• Razor View Engine & Syntaxes
• Execution Flow of MVC
Layout Views
HTML Helpers
Working with Forms in MVC
Scaffold Templates
CRUD (Create, Retrieve, Update, Delete Operations on a db table)
Validations in MVC
Data Annotations
Partial Views
Action Filters
URL Routing
jQuery-AJAX in MVC
Return Types of Action Methods
MVC Training Course Overview
ASP.NET MVC Introduction
MVC Basics
• Controller
• Action Methods
• View
• Model
• MVC Architecture
• View Engine
• Razor View Engine & Syntaxes
• Execution Flow of MVC
Layout Views
HTML Helpers
Working with Forms in MVC
Scaffold Templates
CRUD (Create, Retrieve, Update, Delete Operations on a db table)
Validations in MVC
Data Annotations
Partial Views
Action Filters
URL Routing
jQuery-AJAX in MVC
Return Types of Action Methods
TABLEAU : -
Course Descriptions
Introduction and Overview
• Why Tableau? Why Visualization?
• Level Setting – Terminology
• Getting Started – creating some powerful visualizations quickly
• The Tableau Product Line
• Things you should know about Tableau
Getting Started
• Connecting to Data and introduction to data source concepts
o Working with data files versus database servers
• Understanding the Tableau workspace
• Dimensions and Measures
• Using Show Me!
• Tour of Shelves (How shelves and marks work)
• Building Basic Views
• Help Menu and Samples
• Saving and Sharing your work
Concepts and Options when Connecting to Data
•Overview of other connection options
o Joining multiple tables
o Copy and Paste
o Data Extracts
o Custom SQL
o Publishing and Re-using Data Connections
• Understand how to deal with data changes in your data source such as field addition,
Deletion or name change
• Re-using and sharing data connections – the concept of meta data
• Working with multiple connections in the same workbook
Analysis
•Creating Views
o Marks
o Size and Transparency
o Highlighting
o Working with Dates
o Date aggregations and date parts
o Discrete versus Continuous
o Dual Axis / Multiple Measures
o Combo Charts with different mark types
o Geographic Map
o Page Trails
o Heat Map
o Density Chart
o Scatter Plots
o Pie Charts and Bar Charts
o Small Multiples
o Working with aggregate versus disaggregate data
Analyzing
o Sorting & Grouping
o Aliases
o Filtering and Quick Filters
o Cross-Tabs (Pivot Tables)
o Totals and Subtotals
o Drilling and Drill Through
o Aggregation and Disaggregation
o Percent of Total
o Working with Statistics and Trend lines
Getting Started with Calculated Fields
• Working with String Functions
• Basic Arithmetic Calculations
• Date Math
• Working with Totals
• Custom Aggregations
• Logic Statements
Formatting
• Options in Formatting your Visualization
• Working with Labels and Annotations
• Effective Use of Titles and Captions
• Introduction to Visual Best Practices
Working with Data
• Data Types and Roles
o Dimension versus Measures
o Data Types
o Discrete versus Continuous
o The meaning of pill colors
• Database Joins
• Working with the Data Engine / Extracts and scheduling extract updates
• Working with Custom SQL
• Switching to Direct Connection
• Building meta data via shared Data Source connections
• OLAP considerations (Overview)
Building Interactive Dashboards
• Combining multiple visualizations into a dashboard
• Making your worksheet interactive by using actions and filters
• An Introduction to Best Practices in Visualization
Sharing Workbooks
• Publish to Reader
• Packaged Workbooks
• Publish to PDF
• Publish to Tableau Server and Sharing over the Web
Putting it all together
• Scenario-based Review Exercises
• Best Practices
Security
• Manage users, groups, sites, and permissions in Tableau Server
o Add, edit, and delete user accounts
Where to get Further Assistance
• The Help File / Manual
• Knowledge base
• Forums
• Whitepapers & Books
• Technical Support
• Why Tableau? Why Visualization?
• Level Setting – Terminology
• Getting Started – creating some powerful visualizations quickly
• The Tableau Product Line
• Things you should know about Tableau
Getting Started
• Connecting to Data and introduction to data source concepts
o Working with data files versus database servers
• Understanding the Tableau workspace
• Dimensions and Measures
• Using Show Me!
• Tour of Shelves (How shelves and marks work)
• Building Basic Views
• Help Menu and Samples
• Saving and Sharing your work
Concepts and Options when Connecting to Data
•Overview of other connection options
o Joining multiple tables
o Copy and Paste
o Data Extracts
o Custom SQL
o Publishing and Re-using Data Connections
• Understand how to deal with data changes in your data source such as field addition,
Deletion or name change
• Re-using and sharing data connections – the concept of meta data
• Working with multiple connections in the same workbook
Analysis
•Creating Views
o Marks
o Size and Transparency
o Highlighting
o Working with Dates
o Date aggregations and date parts
o Discrete versus Continuous
o Dual Axis / Multiple Measures
o Combo Charts with different mark types
o Geographic Map
o Page Trails
o Heat Map
o Density Chart
o Scatter Plots
o Pie Charts and Bar Charts
o Small Multiples
o Working with aggregate versus disaggregate data
Analyzing
o Sorting & Grouping
o Aliases
o Filtering and Quick Filters
o Cross-Tabs (Pivot Tables)
o Totals and Subtotals
o Drilling and Drill Through
o Aggregation and Disaggregation
o Percent of Total
o Working with Statistics and Trend lines
Getting Started with Calculated Fields
• Working with String Functions
• Basic Arithmetic Calculations
• Date Math
• Working with Totals
• Custom Aggregations
• Logic Statements
Formatting
• Options in Formatting your Visualization
• Working with Labels and Annotations
• Effective Use of Titles and Captions
• Introduction to Visual Best Practices
Working with Data
• Data Types and Roles
o Dimension versus Measures
o Data Types
o Discrete versus Continuous
o The meaning of pill colors
• Database Joins
• Working with the Data Engine / Extracts and scheduling extract updates
• Working with Custom SQL
• Switching to Direct Connection
• Building meta data via shared Data Source connections
• OLAP considerations (Overview)
Building Interactive Dashboards
• Combining multiple visualizations into a dashboard
• Making your worksheet interactive by using actions and filters
• An Introduction to Best Practices in Visualization
Sharing Workbooks
• Publish to Reader
• Packaged Workbooks
• Publish to PDF
• Publish to Tableau Server and Sharing over the Web
Putting it all together
• Scenario-based Review Exercises
• Best Practices
Security
• Manage users, groups, sites, and permissions in Tableau Server
o Add, edit, and delete user accounts
Where to get Further Assistance
• The Help File / Manual
• Knowledge base
• Forums
• Whitepapers & Books
• Technical Support
DEVOPS : -
Tools Matrix:
Sl no Modules Course Requirement
1 Scripting :
Shell scripting
Fundamentals of Perl Programming
Advanced Perl Programming
Python programming
Ruby on Rails
2 DevOps :
Chef/Puppet for Configuration Management.
Docker/Packer for Containerization
Vagrant for Provisioning
AWS for Cloud computing
Jenkins for Automated Installation and Deployment.
Nagiosfor Infra-Monitoring
Rundeckfor Deployment Automation
Elasticsearch for storage & distributed search engine
Kibana for data visualization
logstash to process & transport logs
Serf for Service orchestration and management tool
3 SCM :
SVN
Git
Clearcase
Perforce
4 Build Management :
Ant
Maven
Makefile
Msbuild
5 CI :
Hudson/Jenkins
6 Static Code analysis :
Sonar for Java & .Net
7 Binary Repository Manager :
Nexus
Artifactory
8 Web/Application Server :
Tomcat
GlassFish
Jboss
Websphere
9 Infrastructure Monitoring :
Nagios
Mmonit
10 Database :
Mysql
MongoDB