• Overview of the System Center Configuration Manager
• Benefits of Implementing System Center Configuration Manager (SCCM)
• Overview of the System Center Configuration Manager (SCCM) Hierarchy
• What Is a Central /Primary / Secondary Site?
• Configuration Manager Site System Roles
• How Data Flows and Replicates in a Hierarchy
• Monitoring Site and Component Status
• Planning a System Center Configuration Manager (SCCM) Stand-Alone Primary Site

• Exploring the System Center Configuration Manager (SCCM) Console with all prerequisites
• Extending the Active Directory Schema
• Installing and Configuring SQL Database Server
• Configuring Network Firewall Settings
• Installing a System Center Configuration Manager (SCCM) Site Server
• Exploring the Configuration Manager Console
• Searching in the Configuration Manager Console
• Monitoring and Troubleshooting a Configuration Manager Site
• Reviewing Log Files by Using Configuration Manager Trace Log Tool

• Overview of Discovery Methods
• Active DirectoryDiscovery Methods/Network Discovery/Heartbeat Discovery?
• Configuring (Forest, Groups, System, Users) discovery methods
• Configuring boundaries and boundary groups
• Configuring client assignments
• Overview and Managing user and device collections
• Create device and user collection with direct, query-based membership rules

• Overview of a Client Push method, Sitewide/Software Update Point/Group Policy/Manual/Logon Script/OSD
• Preparing the Site for Client Installation
• Configuring SCCM client deployment methods
• Configuring User and Device Policies for SCCM client deployment
• Deploying Configuration Manager Clients
• Configuring and Monitoring Client Installation Process and Status

• Configuring Asset Intelligence
• Configuring Hardware Inventory
• Configuring Software Inventory
• Configure and manage hardware and software inventory, monitor inventory data flow
• Overview, Benefit and Configuring of software metering.
• Lab: Configuring and Managing Inventory Collection

• Preparing site to run queries and reports by using SQL Server Reporting Services.
• Introduction and Managing Queries
• Configuring SQL Server Reporting Services
• Introduction to SCCM and Web portal reports
• Overview to SQL Management Studio tables and view data
• Creating custom reports by joining multiple SQL Data Tables using SQL Management Studio and SQL Report Builder

• Introduction to Applications and Packages models
• Configuring Software Distribution / Software Distribution Concepts
• Creating and deploying Application with approval flow concepts, detection method and deployment requirement
• Distributing Content to Distribution Points
• Deploying an Application to a User or a Device
• What Is a Software Center?
• Configuring the Application Catalog
• Configuring Packages and Programs
• Managing Application Deployment
• Viewing Log files, Monitoring and Troubleshooting application deployment

• Overview of Software Updates /Prerequisites for the Software Updates Feature
• Preparing the Configuration Manager Site for Software Updates
• Configuring Software Update types product classifications
• Synchronizing the Software Update Catalog Metadata with Microsoft Update Server
• Creating Software Update Groups and Deployment Packages
• Deploying and Managing Software Updates
• Configuring Automatic Deployment Rules
• Software Updates Reports
• Viewing Log files, Monitoring and Troubleshooting Software Updates

• Overview of Operating System Deployment /Prerequisites for the Operating System Deployment
• Configure DHCP Server as a prerequisite for Operating System Deployment
• Preparing the Site for Operating System Deployment
• Capturing a Reference Computer Operating System Image
• Creating an Operating System Task Sequence to Deploy an Image
• Deploying an Operating System
• Viewing Log files, Monitoring and Troubleshooting Windows Operating System Deployment

• Overview of Endpoint Protection in Configuration Manager
• Configuring and Monitoring Endpoint Protection Policies

• Overview of Compliance Settings
• Creating Configuration Item and Compliance Baseline for devices
• Configure compliance detection and remediation method
• Viewing Compliance Results

• Overview of Mobile Device Management
• Managing Mobile Devices by using the Windows Intune Connector
• Create policies and compliance settings for mobile devices.
• Enroll mobile devices using Microsoft Company Portal
• Deploying Application to Mobile Devices

• Configuring Power Management Settings
• Configuring Remote Control

• Performing Backup and Recovery of a System Center Configuration Manager (SCCM) Site
• Monitoring System Center Configuration Manager (SCCM) Site Systems

• Install a new secondary site
• Assign devices to point to the secondary site using boundary and boundary group
• Deploy applications to devices through secondary site DP
• Viewing Log files, Monitoring and Troubleshooting

• Maintenance Window Configuration
• Role-Based Administration
• Accessing SCCM console from a different computer
• Resource Explorer
• Windows 10 Servicing Model
• Office 365 Client update deployment
• Upgrade SCCM from old version to new version

• Why Site core
• Feature of Site core
• Uses of Site core
• What is CMS? Why do we need one?

• Sitecore Installation on local machine
• Sitecore simple architecture
• Sitecore Installation – Places it affects
• Sample page creation

• Manual
• Installation Wizard

• Core
• Master
• Web

• Overview of all fields

• How to access and item
• How to Access the Children of an Item
• How to Access the Parent of an Item

• Home
• View
• Presentation
• Configuration etc.

• Validation Overview
• Types of Validation
• Validation Error Levels
• Configuring Validation Rules

• The Context Item
• The Context Site
• The Home Item of the Context Site
• The Context Database
• The Context Language
• The Context Domain
• The Context User
• The Context Raw URL
• The Context Page Mode

• Statistics
• The Research Process
• Initial Observation
• Generate Theory
• Generate Hypotheses
• Data collection to Test Theory

1. What to measure
2. How to Measure

• Analyze data
• Descriptive Statistics: Overview
• Central Tendency
• Measure of variation
• Coefficient of Variation
• Fitting Statistical Models
• Conclusion

• Building statistical models
• Types of statistical models
• Populations and samples
• Simple statistical models
• The mean as a model
• The variance and standard deviation
• Central Limit Theorem
• The standard error
• Confidence Intervals
• Test statistics
• Non-significant results and Significant results:
• One- and two-tailed tests
• Type I and Type II errors
• Effect Sizes
• Statistical power

• Accessing SPSS
• To explore the key windows in SPSS

1. Data editor
2. The viewer
3. The syntax editor

• How to create variables
• Enter Data and adjust the properties of your variables
• How to Load Files and Save
• Opening Excel Files
• Recoding Variables
• Deleting/Inserting a Case or a Column
• Selecting Cases
• Using SPSS Help

• The art of presenting data
• The SPSS Chart Builder

1. Histograms: a good way to spot obvious problems
2. Boxplots (box–whisker diagrams)

• Graphing means: bar charts and error bars

1. Simple bar charts for independent means
2. Clustered bar charts for independent means
3. Simple bar charts for related means
4. Clustered bar charts for related means
5. Clustered bar charts for ‘mixed’ designs

• Line charts
• Graphing relationships: the scatterplot

1. Simple scatterplot
2. Grouped scatterplot
3. Simple and grouped -D scatterplots
4. Matrix scatterplot

• Simple dot plot or density plot
• Drop-line graph
• Editing graphs

• What are assumptions?
• Assumptions of parametric data
• The assumption of normality
• Quantifying normality with numbers
• Exploring groups of data
• Testing whether a distribution is normal
• Kolmogorov–Smirnov test on SPSS

1. Output from the explore procedure
2. Reporting the K–S test

• Testing for homogeneity of variance

1. Levene’s test
2. Reporting Levene’s test

• Correcting problems in the data

1. Dealing with outliers
2. Dealing with non-normality and unequal variances
3. Transforming the data using SPSS

• Looking at relationships
• How do we measure relationships?

1. Covariance
2. Standardization and the correlation coefficient

• The significance of the correlation coefficient
• Confidence intervals for r
• Correlation in SPSS

1. Bivariate correlation
2. Pearson’s correlation coefficient
3. Spearman’s correlation coefficient
4. Kendall’s tau (non-parametric)
5. Biserial and point–biserial correlations
6. Partial correlation
7. The theory behind part and partial correlation
8. Partial correlation using SPSS
9. Semi-partial (or part) correlations

• Comparing correlations
• Comparing independent rs
• dependent rs
• Calculating the effect size
• How to report correlation coefficients

• An introduction to regression
• Some important information about straight lines
• The method of least squares
• Assessing the goodness of fit: sums of squares, R and R2
• Doing simple regression on SPSS

1. Interpreting a simple regression
2. Overall fit of the model
3. Model parameters
4. Using the model

• Multiple regression: the basics

1. An example of a multiple regression model
2. Sums of squares, R and R2
3. Methods of regression
4. How accurate is my regression model?
5. Assessing the regression model, I: diagnostics
6. Assessing the regression model II: generalization

• How to do multiple regression using SPSS

1. Some things to think about before the analysis
2. Main options
3. Statistics
4. Regression plots
5. Saving regression diagnostics
6. Interpreting multiple regression

• Descriptive

1. Summary of model
2. Model parameters
3. Excluded variables
4. Assessing the assumption of no multicollinearity
5. Case wise diagnostics

• Checking assumptions

1. What if I violate an assumption?
2. to report multiple regression

• Dummy coding
• SPSS output for dummy variables

• Background to logistic regression
• What are the principles behind logistic regression?
• Assessing the model: the log-likelihood statistic
• Assessing the model: R and R2

1. The Wald statistic
2. The odds ratio: Exp (B)

• Methods of logistic regression

1. Assumptions
2. Incomplete information from the predictors
3. Complete separation
4. Overdispersion
5. Binary logistic regression
6. The main analysis
7. Method of regression
8. Categorical predictors
9. Obtaining residuals

• Interpreting logistic regression

1. The initial model
2. Step: intervention
3. Listing predicted probabilities
4. Interpreting residuals
5. Calculating the effect size

• How to report logistic regression
• Testing assumptions

1. Testing for linearity of the logit
2. Testing for multicollinearity

• Predicting several categories: multinomial logistic regression
• Running multinomial logistic regression in SPSS

1. Statistics
2. Other options
3. Interpreting the multinomial logistic regression output
4. Reporting the results

• Looking at differences
• A problem with error bar graphs of repeated-measures designs

1. Step: calculate the mean for each participant
2. Step: calculate the grand mean
3. Step: calculate the adjustment factor
4. create adjusted values for each variable

• The t-test
• Rationale for the t-test

1. Assumptions of the t-test
2. The dependent t-test
3. Sampling distributions and the standard error
4. The dependent t-test equation explained
5. The dependent t-test and the assumption of normality
6. Dependent t-tests using SPSS
7. Output from the dependent t-test
8. Calculating the effect size

• Reporting the dependent t-test

1. The independent t-test
2. The independent t-test equation explained
3. The independent t-test using SPSS
4. Output from the independent t-test
5. Calculating the effect size

• Reporting the independent t-test
• Between groups or repeated measures?
• The t-test as a general linear model

• The theory behind ANOVA
• Inflated error rates
• Interpreting f-test
• ANOVA as regression

1. Logic of the f-ratio
2. Total sum of squares (SST)
3. Model sum of squares (SSM)
4. Residual sum of squares (SSR)
5. Mean squares
6. The f-ratio

• Assumptions of ANOVA
• Planned contrasts
• Post hoc procedure
• Running one-way ANOVA on SPSS
• Planned comparisons using SPSS
• Post hoc tests in SPSS

1. Output from one-way ANOVA
2. Output for the main analysis
3. Output for planned comparisons
4. Output for post hoc tests
5. Calculating the effect size
6. Reporting results from one-way independent ANOVA
7. Violations of assumptions in one-way independent ANOVA

• Analyzing categorical data
• Theory of analyzing categorical data

1. Pearson’s chi-square test
2. Fisher’s exact test

• The likelihood ratio
• Yates’ correction
• Assumptions of the chi-square test
• Doing chi-square on SPSS

1. Running the analysis
2. Output for the chi-square test
3. Breaking down a significant chi-square test with standardized residuals
4. Calculating an effect size

• Reporting the results of chi-square

• What is QlikSense?
• Comparing Qlik Sense Desktop with Qlik Sense
• Installing Qlik Sense Desktop
• How Qlik Sense varies from QlikView?
• Starting with QlikSense Desktop
• Opening an app with QlikSense
• QlikSense Architecture

• Navigating in the user interface
• Data Manager
• Data Load Editor
• Data Model Viewer
• Interacting with the user interface
• Creating apps and Visualizations
• Structuring an app with Sheets

• Different type of Visualizations
• Dimensions and Measures in a CHART
• When to use and What Chart to Use
• Selections in a Visualization
• Settings and Properties of each Visualization

• Expressions, Functions and Variables
• Working with Expression Editor
• Using Functions in Charts
• Using Variables in Expressions
• Set Analysis and Set Expressions
• Working with Master Items

• Adding data from files and databases
• Loading data with the data load script
• Data Connections
• Various types of Data loads
• Profile Data with QlikSense
• Troubleshooting

• Qlik Sense Data Architecture
• Creating Star and Snowflake schemas
• Use of Joins, Keeps, Concatenate etc.
• Understanding QVD layer
• Working on synthetic keys and circular references.

• Qlik Sense Star Schema
• Link Table
• Dimensions Table
• Master Calendar
• Optimizing data models
• Best Practices of Data Modelling

• Data Storytelling
• Publishing
• Exporting and Printing
• Advanced Scripting and Chart Functions
• Qlik Tips and Techniques

• Learning about Qlik Sense App and its security features
• Providing Qlik Sense access to user sets
• Qlik Sense Security rule code

• Introduction about PPM Concepts
• Project, Program and portfolio
• About Primavera P6
• Primavera P6 Professional GUI

• Creation of Project in Primavera and Project settings
• Calendar
• WBS
• Activities

• Relationships/Logics
• Critical path method as a scheduling tool
• DCMA Analysis
• Constraints and codes

• Roles and Resource
• Resource Assignment
• Resource analysis and resource leveling
• Setting up Baseline

• Updating Project, Automatic and manual update
• Monitoring and controlling using EVA
• Generating reports in Primavera, tabular and graphical reports
• Miscellaneous: Global change, UDF, top down estimation, P6
• visualizer, reflection.

• Building Blocks of Golden Gate
• Manager
• Extract(Capture)
• Datapump(Routing)
• Replicate(Delivery)
• Trails (Extract) Files
• Checkpoints – Detailed explanation of checkpoints
• Collector (Server collector)
• Data Source
• Groups
• Transformation

Preparation & Installation of GG S/W on Source Server

• Very Important pre-requisites on Source DB
• Installing OGG S/W on Source Server
• Creating of working /mandatory directories
• Verifying DB connectivity from GG S/W

Preparation & Installation of GG on Target server

• Very Important Pre-requisites on Target DB
• Installing OGG S/W on Target Server
• Creating of working /mandatory directories
• Verifying DB connectivity from GG S/W

• Reports (.rpt)
• Parameters (.prm)
• Stdout (.out)
• Replicate checkpoints (.cpr)
• Extract checkpoints (.cpe)
• Process Status (.pcs)
• SQL Scripts (.sql)
• Database Definitions (.def)

• Memory Requirements
• Disk Requirements
• Storage for Oracle Golden Gate Trails
• To estimate required trail space
• Temporary Disk requirements
• Network
• Operating System Privileges

• Checkpoint table
• Configuring the Manager Process
• Describing the Manager Parameters
• Starting the Manager Process

• Describing the Extract process
• Explaining Extract checkpoints
• Extract Creation on source side
• Adding Extract on GG Interface
• Adding remote trail at GG Interface on source side
• Registering Extract at GG Interface on source side
• Starting Extract process
• Describing GGSCI commands
• Describing Extract trails and files
• Configuring Replicate on target side

1. Describing the Replicate process
2. Explaining Replicate checkpoints
3. Replicate Creation on target side
4. Adding Replicate on GG Interface
5. Starting replicate process on target side

• Observing Unidirectional Replication

1. Describing GGSCI commands
2. Describing Extract trails and files

Extract Configuration on Source side

• Describing the Extract process
• Explaining Extract Checkpoints
• Extract Creation on Source side
• Adding Extract on GG Interface
• Registering Extract at GG Interface on source side
• Adding local trail at GG Interface on source side
• Starting an Extract process
• Describing GGSCI commands
• Describing Extract trails and files

Datapump (Secondary Extract-Optional) Configuration on Source side

• Describing the Datapump process
• Explaining Datapump checkpoints
• Datapump Creation on source side
• Adding Datapump on GG Interface
• Adding remote trail at GG Interface on source side
• Starting Datapump process
• Describing GGSCI commands
• Describing Extract trails and files

Configuring Replicate target side

• Describing the Replicate process
• Explaining Replicate Checkpoints
• Replicate Creation on target side
• Adding Replicate on GG Interface
• Starting replicate processes on target side

Observing Unidirectional Replication

• Describing GGSCI Commands
• Describing Extract trails and files

• Instantiation through Initial Load (table level)
• Instantiation through exp & Imp (Schema/table)
• Instantiation through RMAN cloning (FULL DB)

• Importance of Discard file
• Overview of Data Definition File
• When to use Data Definition File
• Configuring Data Definition File

• Overview of Integrated Capture

• Handing Data missing errors on target side
• Handing TCP/IP Errors
• Troubleshooting process startup failures
• Troubleshooting Extract problems
• Troubleshooting missed transactions
• Using the discard file
• Using SHOWSYNTAX to view Replicate SQL statements
• Using the Log dump utility