Category: Full Course

Reading Time: 2 minutes

Reading Time: 3 minutes

JQuery

Module 1: jQuery Introduction

• Target Background
• References
• Unit Topics
• What Is jQuery?
• Benefits of Using a JavaScript Library
• jQuery Example
• CSS Selectors
• How to Use jQuery
• Practical Usage Notes
• Background – DOM
• Background – DOM Ready Events
• Background – JavaScript Functions
• The jQuery Function Object
• What Does the $() Function Take as Argument?
• What Does the $() Function do?
• The jQuery Wrapper
• The jQuery Wrapper as an Array-Like Object
• Note: innerHTML() vs. .html()
• jQuery Wrapper Chaining
• API Function Notation
• Handling DOM Ready Event
• xhtml Note

Module 2: Selectors

• Background: The Sizzle Selector Engine
• Selecting Elements by Attribute
• Pseudo-Selectors
• Form Pseudo-Selectors
• Faster Selection
• Selecting Elements Using Relationships
• Selecting Elements Using Filters
• More on Chaining: .end()
• Testing Elements
• Is the Selection Empty?
• Saving Selections
• Iterating Through Selected Elements Using .each()
• JavaScript Methods
• JavaScript “this”
• Function Context
• The Function call() Method
• .each() Revisited

Module 3: Style Class Manipulation

• Two Options
• Specifying Style Properties
• Setting Style Properties
• .addClass() / .removeClass()
• Defining a Stylesheet
• Setting & Getting Dimensions
• Attributes

Module 4: DOM Manipulation

• The $ Function Revisited
• Getters and Setters
• The text() Element Method
• Appending DOM Elements
• Removing DOM Elements
• Performance

Module 5: Events

• Event Overview
• Old School: Event Handling Using HTML Element Attributes
• Unobtrusive JavaScript
• Unobtrusive JavaScript Example
• Multiple Handlers
• Using jQuery Wrapper Event Registration Methods
• The .bind() Method
• Event Propagation
• Handlers for Elements Before They Exist!
• The Event Object
• Triggering Events

Module 6: Utility Functions

• The jQuery Object Revisited
• Functions May Have Methods
• A jQuery Utility Function: $.trim()
• $.each()
• Example jQuery Utility Functions

Module 7: Ajax

• Ajax Overview
• The Browser & the Server
• The Ajax Request
• The Ajax Response
• Sending an Ajax Request With jQuery – The General Case
• When this code is executed…
• Sending an Ajax Request With jQuery – Simpler, Typical Case
• Data Types
• The .data() method

Module 8: Advanced Ajax

• A Form Example
• An Ajax Form Example
• Serialize()
• Get vs. Post
• More on Query Strings
• ajaxStart() and ajaxError()

Module 9: Animations and Effects with jQuery and jQuery UI

• What is jQuery UI?
• Can I do Animations and Effects using jQuery only?
• Hiding Elements with jQuery
• Using .hide() and .show() in jQuery
• Alternating an Element’s Visibility in jQuery
• Adjusting the Speed in jQuery
• Providing a Handler in jQuery
• Using .slideUp() / .slideDown() methods in jQuery
• jQuery UI Categories
• jQuery UI Interactions: Droppable and Draggable
• Droppable and Draggable More Complete Exampl
• jQuery UI Widgets: Datepicker
• jQuery UI Widgets: Autocomplete

Module 10: Parsing JSON

• JSON
• Reading JSON from the Server Using Ajax
• Example file contents
• Using the Results
• Optimized Version
• Getting More From the Response
• jqXHR Methods
• POST vs. GET
• Invalid JSON
• Using $.ajaxSetup()

Module 11: Plugins

• What is a plugin?
• Goal
• Self-Executing Anonymous Functions
• Meeting Our Goal
• Prototype Objects
• The jQuery Wrapper Class Revisited
• Example Plugin
• Using the Plugin

Reading Time: 3 minutes

DB2 DBA UDB

Module 1: Overview of DB2 9.7 on Windows
• Contrast the DB2 Family of products
• Identify the DB2 Tools
• Functions of DB2 components
• Explore installation and parameters

Module 2: Command Line Processor (CLP) & GUI Usage

• Use the Command Line Processor
• Explore the GUI environment
• Describe the DAS role with GUI tools

Module 3: The DB2 Environment

• Key features of an Instance
• Create and drop an Instance
• Use db2start and db2stop
• Distinguish b/w types of Config.
• Describe and modify the Database Manager Configuration

Module 4: Creating Databases and Data Placement

• Creating a Database.
• Explore system Catalog tables, views
• Compare DMS Vs SMS table Spaces.
• Database with Automatic Storage.
• Differentiate between table spaces, containers, extents, and pages
• Define table spaces
• Get snapshot for table spaces
• Explore Database Config. Parameter.

Module 5: Creating Database Objects

• List DB2 object hierarchy and physical directories & files
• Creating objects: Schema, Table, View, Alias, and Index
• Explore the use of table partitioning
• Review the use of Temporary Tables
• Implementation of Check Constraints, Referential Integrity and Triggers
• Exploring the use of Large Objects

Module 6: Moving Data

• Discuss the INSERT statement and Recognize its limitations
• Explain the differences between IMPORT and LOAD
• Explain the EXPORT, IMPORT, and LOAD syntax
• Create and use Exception Tables and Dump-Files
• Distinguish and Resolve Table States: Load Pending and Set Integrity Pending
• Use the SET INTEGRITY command
• Discuss the db2move and db2look commands

Module 7: Backup And Recovery

• Describe the major principles and methods for backup and recovery
• State the three types of recovery used by DB2
• Explain the importance of logging for backup & recovery
• Describe how data logging takes Place –circular & archival logging
• Use the BACKUP, RESTORE, and ROLLFORWARD commands
• Perform a table space backup and recovery
• Restore a database to the end of logs or to a point-in-time
• Backup and recovery scenarios

Module 8: Locking And Concurrency

• Explain why locking is needed
• List objects that can be locked
• Describe and discuss the various lock modes and their compatibility
• Explain four different levels of data protection
• Set isolation level and lock time out for current activity
• Explain lock conversion & escalation
• Describe causes of Deadlocks

Module 9: Problem Determination

• Collect information for problem analysis and resolution
• Use error logs for basic problem analysis
• Describe four types of monitors: Snapshot Monitor, Event Monitor, Activity Monitor and Health Monitor
• Basic commands to better work with connections and Sessions
• Retrieve statistics and information from a running DB2 instance

Module 10: Application Issues and Performance

• Prepare applications that access DB2 data for execution
• Describe the application alternatives available to access DB2 data
• Define the concept of clustering, and determine the proper cluster sequence
• Use RUNSTATS, REORGCHK, and REORG to enhance application performance
• Work with the EXPLAIN facility

Module 11: Security

• Use Access Control Mechanisms to implement database security
• Use group IDs to create a control hierarchy
• Describe Label Based Access Control
• Describe privileges within a database
• Describe privileges required for binding and executing a package
• Describe the difference between explicit privileges & implicit privileges
• Describe the different level of authorization

Reading Time: 5 minutes

SalesForce

Module 1 : Salesforce Overview

• Learning Objectives
• Introduction to Salesforce
• Salesforce Editions
• Home page Customization
• User Management
• Creating and Customizing Tabs
• Creating an App
• Uploading a Company Logo
• Company Information Page
• System Overview Page
• Updating the Fiscal Year
• Case study
• Key Takeaways

Module 2 : Salesforce Objects

• Learning Objectives
• Standard Object Components
• Renaming Standard Objects
• Modifying Standard Objects
• Understanding External Objects
• Creating Custom Objects
• Case study
• Key Takeaways

Module 3 : Field Types

• Learning Objectives
• Modifying Standard Fields
• Creating Auto-Number Fields
• Creating Formula Fields
• Creating Roll-Up Summary Fields
• Creating Lookup and Master-Detail Fields
• Creating Checkbox Fields
• Creating Currency, Number, and Percent Fields
• Creating Date Fields and Date and Time Fields
• Creating Phone and Email Fields
• Creating Geolocation Fields
• Creating Picklist and Multi-Select Picklist Fields
• Creating Text and Text Area Fields
• Creating Text Area Long and Text Area Rich Fields
• Considerations for Field Type Change
• Field Deleting Implications
• Creating Encrypted Fields
• Creating URL Fields
• Case study
• Key Takeaways

Module 4 : Validation Rules

• Learning Objective
• Creating Validation Rules
• Creating Formulas
• Creating Error Messages
• Case study
• Key Takeaways

Module 5 : Security Controls

• Learning Objective
• Viewing Object Security
• Changing Default Record Access
• Sharing Settings
• Field Accessibility
• Password Policies
• Session Settings
• Login Flows
• Network Access
• Activations
• Session Management
• Login Access Policies
• Certificate and Key Management
• Viewing Setup Audit Trail
• Executing Expire All Passwords
• Delegated Administrations
• Remote Site Settings
• Named Credentials
• File Upload and Download Security
• Case Study
• Key Takeaways

Module 6 : Profiles

• Learning Objective
• Overview of Standard Profiles
• Assigning Page Layouts
• Field-Level Security
• Custom App Settings and Access
• Tab Settings
• Record Type Settings
• Administrative Permissions
• General User Permissions
• Standard Object Permissions
• Custom Object Permissions
• Password Policies and Session Timeout
• Login Hours and IP Ranges
• Enabling Apex and Visualforce Access
• Case Study
• Key Takeaways

Module 7 : Role Hierarchy

• Learning Objective
• Viewing Role Hierarchy
• Creating Roles
• Enabling Field History
• Creating Groups
• Creating Permission Sets
• Assigning Roles to Users
• Case Study
• Key Takeaways

Module 8 : Workflow Rules

• Learning Objective
• Creating a Workflow Rule
• Creating a Workflow Rule Field Update
• Creating a Workflow Rule Task Assignment
• Creating a Workflow Rule Email Alert
• Outbound Message
• Time-Dependent Workflow Action
• Time-Dependent Workflow Action – Considerations
• Overview of Approval Process
• Components of an Approval Process
• Case Study
• Key Takeaways

Module 9 : Data Management

• Learning Objective
• Importing Leads
• Data Import Wizard
• Importing Contacts and Accounts
• Using Mass Delete
• Installing Data Loader
• Installing Data Loader
• Importing Records with Data Loader
• Updating Records with Data Loader
• Deleting Records with Data Loader
• Exporting Records with Data Loader
• Adding a Field in the Schema Builder
• Scheduling a Data Export
• Creating and Using Sandbox
• Mass Transferring Records
• Reporting Snapshots
• Working with Tags
• Case Study
• Key Takeaways

Module 10 : Reports

• Learning Objective
• Understanding Report Formats
• Tabular Reports
• Summary Reports
• Matrix Reports
• Join Reports
• Creating Leads Report
• Creating Contacts and Accounts Report
• Creating an Opportunity Report
• Adding Leads to a Campaign from a Report
• Creating a Report Chart
• Scheduling Reports
• Creating a Campaign Report
• Summarizing Report Data
• Creating a Report Formula
• Exporting Reports to Excel
• Date Filters
• Bucket Fields
• Custom Report Types
• Case Study 1
• Case Study 2
• Key Takeaways

Module 11 : Dashboards

• Learning Objective
• Understanding Dashboard Components
• Creating a Dashboard
• Refreshing a Dashboard
• Modifying Columns on Dashboards
• Adding Filters to a Dashboard
• Managing Access to Reports
• Adding a Report as a Dashboard Component
• Setting Up Dynamic Dashboards
• Enabling Dashboards for iPad
• Modifying Report and Dashboard Interfaces
• Activating the Report Builder on Profiles
• Case Study
• Key Takeaways

Module 12 : Chatter

• Learning Objective
• Chatter Overview
• Enabling Chatter
• Enabling Chatter Feeds on Records
• Configuring Chatter Groups
• Creating Customer Groups
• Creating a Free Customer Chatter User
• Customizing Chatter Email Notifications
  Configuring Salesforce to Salesforce

• Accepting a Salesforce Connection
• Sharing an Account via Salesforce to Salesforce
• Enabling Ideas
• Configuring Idea Themes
• Enabling Social Accounts
• Enabling Libraries and Content
• Customizing Libraries and Content
• Uploading Documents to Libraries and Content
• Configuring Salesforce1
• Case Study
• Key Takeaways

Module 13 : Change Sets and Deployment

• Learning Objective
• Outbound Change Sets
• Inbound Change Sets
• Deployment Settings
• Deployment Status
• Eclipse IDE
• Case Study
• Key Takeaways

Module 14 : Application Lifecycle

• Learning Objective
• Key Milestones and Considerations
• Using Sandboxes for Development
• Using Change Sets
• Using Unmanaged Packages
• Case Study
• Key Takeaways

Module 15 : Visual Workflow, Process Builder, and Schema Builder

• Learning Objective
• Creating a Visual Flow
• Modifying Existing Flows
• Creating a Process in the Process Builder
• Creating Fields in the Schema Builder
• Case Study
• Key Takeaways

Module 16 : Lightning Components

• Learning Objective
  Installing Lightning Components

• Lightning Component Capabilities
• Lightning Components vs. Visualforce
• Case Study
• Key Takeaways

Module 17 : Creating Buttons, Links, and Actions

• Learning Objective
  Global Action

• Object Specific Action
• Object Specific Action – Types
• Action Layout in Salesforce1
• Creating New Records with Actions
• Logging a Call with Actions
• Updating a Record with Actions
• Creating Custom Buttons
• Creating Custom Links
• Case Study
• Key Takeaways

Module 18 : Sales Cloud

• Learning Objective
• Leads Home Page
• Creating List Views
• Creating and Converting Leads
• Creating Accounts
• Creating Contacts
• Creating Email Templates
• Four Sales Productivity Features
• Sending Individual Emails
  Sending Mass Emails

• Creating and Managing Price Books
• Creating Products
• Creating Opportunities
• Creating Activities
• Creating a Web-to-Lead Form
• Creating a Lead Assignment Rule
• Creating a Lead Queue
• Creating an Auto-Response Rule
• Creating Campaigns
• Record Types
• Case Study 1
• Case Study 2
• Key Takeaways

Module 19 : Quote Templates

• Creating a Quote Record
• Creating a Quote Template
• Generating a Quote PDF
• Emailing a Quote PDF
• Modifying Quote Templates
• Case Study
• Key Takeaways

Module 20 : Service Cloud

• Learning Objective
• Creating Cases
• Creating Case Assignment Rules
• Creating Case Escalation Rules
• Enabling Solutions
• Creating Solutions
• Attaching Solutions to Cases
• Enabling Knowledge
• Configuring Knowledge
• Creating a Web-to-Case Form
• Create an Email-to-Case Address
• Case Study 1
• Case Study 2
• Key Takeaways

Module 21 : – Communities

• Creating a New Community
• Partner Portal
• Customer Portal
• Communities
• Topic Management
• Reputation Management
• Adding Members
• Managing Tabs and Branding
• Login and Registration
• Community Preferences
• Case Study
  Key Takeaways

Module 22 : User Interface

• Learning Objective
• User Interface General Options
• User Interface Sidebar Options
• User Interface Calendar Options
• User Interface Name Settings
• User Interface Setup Options
• Case Study
• Key Takeaways

Module 23 : Help and Training

• Using Answers
• Using Ideas
• Searching for a Help Topic
• Contacting Support
• Trust Site
• Known Issues
• Case Study
• Key Takeaways

Module 24 : AppExchange

• Learning Objective
• AppExchange Overview
• Finding and Selecting an App
• Finding a Developer
• Finding a Consultant
• Case Study
• Key Takeaways

Module 25 : Other Important Concepts

• Learning Objective
• SalesforceA
• SalesforceA – Actions
• Salesforce and Outlook – Integration
• Many-to-Many Relationship
• Many-to-Many Relationship — Example
• Self Relationship
• Hierarchy Relationship

Reading Time: 3 minutes

J2EE

Module 1: JDBC

• Introduction to JDBC
• Databases and Drivers
• Types of Driver
• Loading a driver class file
• Establishing the Connection to different
• Database with different Driver
• Executing SQL queries by ResultSet,Statements , PreparedStatment interface.
• Using CallableStatement
• Transaction Management & BatchUpdate
• Programs/Interview related Question and Answer

Module 2: JSP

• Basics Of Jsp
• Life cycle of JSP
• JSP API
• JSP in Eclipse and other IDE’s
• Programs/Interview related Question and Answer.
• Scripting Elements
• scriptlet tag
• expression tag
• declaration tag
• Implicit Objects
• out
• request
• response
• config
• application
• session
• pageContext
• page
• exception
• Directive Elements
• page directive
• include directive
• taglib directive
• Exception Handling
• Action Elements
• jsp:forward
• jsp:include
• Bean class
• jsp:useBean
• jsp:setProperty & jsp:getProperty
• Displaying applet in JSP
• Expression Language
• What is expression and how to use it
• Define expression and use over the service flow
• The way to be achieve same in JSP
• Mvc In Jsp
• MVC pattern
• Working flow implementation of MVC
• CRUD operation using MVC
• Design a real time web application using MVC
• JSTL
• Discussion on the tag library
• How to implement and use
• Custom Tags
• Custom Tag : What and Why?
• Custom Tag API?
• Custom Tag Example
• Attributes
• Iteration
• Custom URI

Module 3: Servlet

• Basics of Servlet
• Servlet: What and Why?
• Basics of Web
• Servlet API
• Servlet Interface
• GenericServlet
• HttpServlet
• Servlet Life Cycle
• Working with Apache Tomcat Server
• Steps to create a servlet in Tomcat
• How servlet works?
• servlet in Myeclipse
• servlet in Eclipse
• servlet in Netbeans
• Servlet request
• Servlet Request methods
• Registration example with DB
• Servlet Collaboration
• Request Dispatcher
• send Redirect
• Servlet Configure
• Servlet Configure methods
• Servlet Configure example
• Servlet Context
• Servlet Context methods
• Servlet Context example
• Session Tracking
• Cookies
• Hidden Form Field
• URL Rewriting
• HttpSession

Module 4: Concurrent and implementation of collection

• Implemenation of ArrayList
• Implemenation of LinkedList
• Implemenation of HashMap
• Implementation of Queue/PriorityQueue/Deque

Module 5: Advanced Multi-Threading

• Implemenation of Executor pool service and working mechanism with real time
• Big file(Single , multiple ) processing using multiple thread
• Implemenation to achieve thread class and runnable interface

Module 6: Javamail Api

• Sending Email
• Sending email through Gmail server
• Receiving Email
• Sending HTML content

Module 7: Design Pattern

• Singleton
• DAO
• DTO
• MVC
• Front Controller
• Factory Method
• Abstract

Module 8: Junit

• JUnit: What and Why?
• Annotations used in JUnit
• Assert class
• Test Cases

Module 9: Maven

• Maven: What and Why?
• Ant Vs Maven
• How to install Maven?
• Maven Repository
• Understanding pom.xml
• Maven Example
• Maven Web App Example
• Maven using Eclipse

Module 10: Project Guidance

Reading Time: < 1 minute

Apache Spark

Module 1: Introduction to Spark and Hadoop platform
• What is Hadoop platform
• Why Hadoop platform
• What is Spark
• Why spark
• Evolution of Spark

Module 2: Introduction to Scala

• Functional Programing Vs Object Orient Programing
• Scalable language
• Scala Overview

Module 3: SPARK Environment

• Configuring Apache Spark

Module 4: SCALA Enivronment

• JAVA Setup
• SCALA Editor
• Interprepter
• compiler

Module 5: Deep Dive into Scala

• Benefits of Scala
• Language Offerings
• Type inferencing
• Variables
• Functions
• LOOPS
• Control Structures
• Vals
• Arrays
• Lists
• Tuples
• Sets
• Maps
• Traits and Mixins
• Classes and Objects
• First class functions
• Clousers
• Inheritance
• Sub classes
• Case Classes
• Modules
• Pattern Matching
• Exception Handling
• FILE Operations

Module 6: Deep Dive into Spark

• Spark Shell
• Parallel Programming
• context
• RDD
• Transformations
• Programming with RDD
• Actions
• Broadcast Variables
• Accumulators

Module 7: Spark EcoSystem

• Spark Streaming
• MLlib
• GraphX
• Spark SQL

Reading Time: 3 minutes

EMC Storage

Module 1: Storage Fundamentals

• Introduction to Information Storage
• Data Center Environment
• Intelligent Storage Systems & Components Of Storage System
• Raid Concepts
• Storage Protocols And Topologies
• Direct Attached Storage (DAS)
• Network Attached Storage (NAS)
• Storage Area Network (SAN)
• Difference Between SAN & NAS, FC SAN & Ip SAN Technologies
• Introduction To Fiber Chanel And How It Works In SAN
• FC Layers & Fabric Port Types and Fiber Connectors
• Cables & FC Well-Known Adresses, FC Topologies & Terminology
• Architecture of a Storage Subsystem and Storage Management Softwares
• Multipathing Softwares, Storage Virtualization and Storage Tiering
• Introduction To Business Continuity Management
• Backup And Archive
• Local Replication And Remote Replication
• Cloud Computing
• Securing And Managing Storage Infrastructure

Module 2: Brocade & Cisco Switch Management

• Introduction To Brocade And Cisco Switches And Various Models
• Installation Of New Switches
• Overview Of Fabric Topologies
• Overview Of Fabric Components, Switch Firmware Upgrade
• User Account Management, Fabric-Wide Settings & Local Switch Settings
• Zoning & Types Of Zoning (Port Zoning And WWN Zoning) Along With Practical Explanation
• Using Cli And Web Tools Gui
• Using Dcfm
• Generating Reports
• Monitoring Switch Logs
• Inter Switch Linking (Isl) And Trunking
• Inter Chasis Linking (Icl)
• Merging Fabrics Along With Practical Explanation
• Multipathing Software Overview – Powerpath Explanation With Commands
• Access Gateway Mode, N-Port Id Virtualization – Npiv

Module 3: Emc Clariion

• Introduction To Emc Clariion Cx Series Architecture
• Clariion Features, Clariion Management Utilities (Navisphere Manager, Navicli)
• Clariion Storage Provisioning
• Traditional (Raid Groups) And Thin (Thin Pools) Provisioning
• Solaris And Windows Integration
• Access Logix
• Powerpath
• Snapview Snapshots
• Snapview Clones
• Mirrorview Configuration & Management
• Sancopy Configuration & Management
• Advanced Lun Managaement
• Lun Migration
• Data Migration
• Event Monitor
• Navisphere Analyzer

Module 4: Emc Vnx

• Introduction To Unified Storage & Vnx
• Vnx Management Utilities (Unisphere & Cli Environment)
• Basic Architecture Of Vnx And Vnxe Series
• Vnx Models And Features
• Vnx Basic Components
• Vnx Modular Architecture
• Dae And Drive Options For Vnx Series
• Vnx Features and Vnx Software And Their Components
• Vnx Storage Provisioning and Thin Provisioning In Vnx
• Emc Symmetrix (Dmx And Vmax) and Introduction To Symmetrix Dmx And Vmax Series
• Dmx And Vmax Storage Architecture
• Differences Between Dmx And Vmax Storage Systems
• Dmx Director Pairing And Rule 17, Fa, Da & Cache Concepts
• Symmetrix Mirror Positions and Symmetrix Device Attributes
• Dynamic Lun Addressing, Symmetrix Management Software
• Symmetrix Solutions Enabler (Symcli) and Symmetrix Management Console (Smc)
• Emc Control Center (Ecc), Confiuration Manager and Symmetrix Storage Provisioning
• Symmetrix Device Creation/Deletion, Forming & Dessolving Meta Devices
• Mapping & Unmapping, Masking, Unmasking and Symmetrix Thin Provisioning
• Monitoring Thin Pools and Vmax Auto Provisioning Groups
• Vmax Fully Automated Storage Tiering (Fast & Fast Vp)
• Virtual Lun Migration, Timefinder Configuration And Management and Mirror/Bcv, Clone
• Snap, Srdf Overview And Concepts
• Srdf Configuration And Mangement and Srdf Synchronous Operations
• R1/R2 Device Pairs Creations Using Configuration Manager
• Dynamic Srdf Pairing

Module 5: Introduction To Other Storage Products

• Introduction To Netapp Fas 30xx
• 60xx Filers
• Netapp Data Ontap Administration Basics
• Difference Between Operation Of EMC Storage And Other Storage

Reading Time: 8 minutes

Data Science

Module 1: Introduction to Data Science with R

• What is Data Science, significance of Data Science in today’s digitally-driven world, applications of Data Science, lifecycle of Data Science, components of the Data Science lifecycle, introduction to big data and Hadoop, introduction to Machine Learning and Deep Learning, introduction to R programming and R Studio.

• Hands-on Exercise –Installation of R Studio, implementing simple mathematical operations and logic using R operators, loops, if statements and switch cases.

Module 2: Data Exploration

• Introduction to data exploration, importing and exporting data to/from external sources, what is data exploratory analysis, data importing, dataframes, working with dataframes, accessing individual elements, vectors and factors, operators, in-built functions, conditional, looping statements and user-defined functions, matrix, list and array.

• Hands-on Exercise –Accessing individual elements of customer churn data, modifying and extracting the results from the dataset using user-defined functions in R.

Module 3: Data Manipulation

• Need for Data Manipulation, Introduction to dplyr package, Selecting one or more columns with select() function, Filtering out records on the basis of a condition with filter() function, Adding new columns with the mutate() function, Sampling & Counting with sample_n(), sample_frac() & count() functions, Getting summarized results with the summarise() function, Combining different functions with the pipe operator, Implementing sql like operations with sqldf.

• Hands-on Exercise – Implementing dplyr to perform various operations for abstracting over how data is manipulated and stored.

Module 4: Data Visualization

• Introduction to visualization, Different types of graphs, Introduction to grammar of graphics & ggplot2 package, Understanding categorical distribution with geom_bar() function, understanding numerical distribution with geom_hist() function, building frequency polygons with geom_freqpoly(), making a scatter-plot with geom_pont() function, multivariate analysis with geom_boxplot, univariate Analysis with Bar-plot, histogram and Density Plot, multivariate distribution, Bar-plots for categorical variables using geom_bar(), adding themes with the theme() layer, visualization with plotly package & building web applications with shinyR, frequency-plots with geom_freqpoly(), multivariate distribution with scatter-plots and smooth lines, continuous vs categorical with box-plots, subgrouping the plots, working with co-ordinates and themes to make the graphs more presentable, Intro to plotly & various plots, visualization with ggvis package, geographic visualization with ggmap(), building web applications with shinyR.

• Hands-on Exercise –Creating data visualization to understand the customer churn ratio using charts using ggplot2, Plotly for importing and analyzing data into grids. You will visualize tenure, monthly charges, total charges and other individual columns by using the scatter plot.

Module 5: Introduction to Statistics

• Why do we need Statistics?, Categories of Statistics, Statistical Terminologies,Types of Data, Measures of Central Tendency, Measures of Spread, Correlation & Covariance,Standardization & Normalization,Probability & Types of Probability, Hypothesis Testing, Chi-Square testing, ANOVA, normal distribution, binary distribution.

• Hands-on Exercise –– Building a statistical analysis model that uses quantifications, representations, experimental data for gathering, reviewing, analyzing and drawing conclusions from data.

Module 6: Machine Learning

• Introduction to Machine Learning, introduction to Linear Regression, predictive modeling with Linear Regression, simple Linear and multiple Linear Regression, concepts and formulas, assumptions and residual diagnostics in Linear Regression, building simple linear model, predicting results and finding p-value, introduction to logistic regression, comparing linear regression and logistics regression, bivariate & multi-variate logistic regression, confusion matrix & accuracy of model, threshold evaluation with ROCR, Linear Regression concepts and detailed formulas, various assumptions of Linear Regression,residuals, qqnorm(), qqline(), understanding the fit of the model, building simple linear model, predicting results and finding p-value, understanding the summary results with Null Hypothesis, p-value & F-statistic, building linear models with multiple independent variables.

• Hands-on Exercise –Modeling the relationship within the data using linear predictor functions. Implementing Linear & Logistics Regression in R by building model with ‘tenure’ as dependent variable and multiple independent variables.

Module 7: Logistic Regression

• Introduction to Logistic Regression, Logistic Regression Concepts, Linear vs Logistic regression, math behind Logistic Regression, detailed formulas, logit function and odds, Bi-variate logistic Regression, Poisson Regression, building simple “binomial” model and predicting result, confusion matrix and Accuracy, true positive rate, false positive rate, and confusion matrix for evaluating built model, threshold evaluation with ROCR, finding the right threshold by building the ROC plot, cross validation & multivariate logistic regression, building logistic models with multiple independent variables, real-life applications of Logistic Regression.

• Hands-on Exercise –Implementing predictive analytics by describing the data and explaining the relationship between one dependent binary variable and one or more binary variables. You will use glm() to build a model and use ‘Churn’ as the dependent variable.

Module 8: Decision Trees & Random Forest

• What is classification and different classification techniques, introduction to Decision Tree, algorithm for decision tree induction, building a decision tree in R, creating a perfect Decision Tree, Confusion Matrix, Regression trees vs Classification trees, introduction to ensemble of trees and bagging, Random Forest concept, implementing Random Forest in R, what is Naive Bayes, Computing Probabilities, Impurity Function – Entropy, understand the concept of information gain for right split of node, Impurity Function – Information gain, understand the concept of Gini index for right split of node, Impurity Function – Gini index, understand the concept of Entropy for right split of node, overfitting & pruning, pre-pruning, post-pruning, cost-complexity pruning, pruning decision tree and predicting values, find the right no of trees and evaluate performance metrics.

• Hands-on Exercise –Implementing Random Forest for both regression and classification problems. You will build a tree, prune it by using ‘churn’ as the dependent variable and build a Random Forest with the right number of trees, using ROCR for performance metrics.

Module 9: Unsupervised learning

• What is Clustering & it’s Use Cases, what is K-means Clustering, what is Canopy Clustering, what is Hierarchical Clustering, introduction to Unsupervised Learning, feature extraction & clustering algorithms, k-means clustering algorithm, Theoretical aspects of k-means, and k-means process flow, K-means in R, implementing K-means on the data-set and finding the right no. of clusters using Scree-plot, hierarchical clustering & Dendogram, understand Hierarchical clustering, implement it in R and have a look at Dendograms, Principal Component Analysis, explanation of Principal Component Analysis in detail, PCA in R, implementing PCA in R.

• Hands-on Exercise –Deploying unsupervised learning with R to achieve clustering and dimensionality reduction, K-means clustering for visualizing and interpreting results for the customer churn data.

Module 10: Association Rule Mining & Recommendation Engine

• Introduction to association rule Mining & Market Basket Analysis, measures of Association Rule Mining: Support, Confidence, Lift, Apriori algorithm & implementing it in R, Introduction to Recommendation Engine, user-based collaborative filtering & Item-Based Collaborative Filtering, implementing Recommendation Engine in R, user-Based and item-Based, Recommendation Use-cases.

• Hands-on Exercise –Deploying association analysis as a rule-based machine learning method, identifying strong rules discovered in databases with measures based on interesting discoveries.

Module 11: Introduction to Artificial Intelligence (self paced)

• Introducing Artificial Intelligence and Deep Learning, what is an Artificial Neural Network, TensorFlow – computational framework for building AI models, fundamentals of building ANN using TensorFlow, working with TensorFlow in R.

Module 12: Time Series Analysis (self paced)

• What is Time Series, techniques and applications, components of Time Series, moving average, smoothing techniques, exponential smoothing, univariate time series models, multivariate time series analysis, Arima model, Time Series in R, sentiment analysis in R (Twitter sentiment analysis), text analysis.

• Hands-on Exercise –Analyzing time series data, sequence of measurements that follow a non-random order to identify the nature of phenomenon and to forecast the future values in the series.

Module 13: Support Vector Machine – (SVM) (self paced)

• Introduction to Support Vector Machine (SVM), Data classification using SVM, SVM Algorithms using Separable and Inseparable cases, Linear SVM for identifying margin hyperplane.

Module 14: Naïve Bayes (self paced)

• What is Bayes theorem, What is Naïve Bayes Classifier, Classification Workflow, How Naive Bayes classifier works, Classifier building in Scikit-learn, building a probabilistic classification model using Naïve Bayes, Zero Probability Problem.

Module 15: Text Mining (self paced)

• Introduction to concepts of Text Mining, Text Mining use cases, understanding and manipulating text with ‘tm’ & ‘stringR’, Text Mining Algorithms, Quantification of Text, Term Frequency-Inverse Document Frequency (TF-IDF), After TF-IDF.

Module 16: Case Study The Market Basket Analysis (MBA) case study

• This case study is associated with the modeling technique of Market Basket Analysis where you will learn about loading of data, various techniques for plotting the items and running the algorithms. It includes finding out what are the items that go hand in hand and hence can be clubbed together. This is used for various real world scenarios like a supermarket shopping cart and so on.

Logistic Regression Case Study

• In this case study you will get a detailed understanding of the advertisement spends of a company that will help to drive more sales. You will deploy logistic regression to forecast the future trends, detect patterns, uncover insights and more all through the power of R programming. Due to this the future advertisement spends can be decided and optimized for higher revenues.

Multiple Regression Case Study

• You will understand how to compare the miles per gallon (MPG) of a car based on the various parameters. You will deploy multiple regression and note down the MPG for car make, model, speed, load conditions, etc. It includes the model building, model diagnostic, checking the ROC curve, among other things.

Receiver Operating Characteristic (ROC) case study

• You will work with various data sets in R, deploy data exploration methodologies, build scalable models, predict the outcome with highest precision, diagnose the model that you have created with various real world data, check the ROC curve and more.

Reading Time: 4 minutes

NetApp Storage

Module 1: The NetApp Storage Environment

• Key features and functions
• Advantages
• Distinguish between NAS and SAN topologies
• Describe NetApp Unified Storage Architecture

Module 2: WAFL Simplified

• WAFL (Write Anywhere File Layout) file system
• WAFL file system concepts
• including consistency points (CPs)
• RAID management, and storage levels
• RAID is used to protect disk data
• WAFL file system processes write and read requests

Module 3: Basic Administration

• Connect remotely to a FAS system
• Using the console and a remote host
• Access NetApp System Manager
• Execute commands
• Use commands to analyze a FAS system
• Configure and manage the NetApp AutoSupport tool

Module 4: Physical Storage

• Data ONTAP RAID technology
• Identify a disk in a disk shelf based on its ID
• Execute commands to determine a disk ID
• Identify a hot-spark disk in a FAS system
• Describe the effects of using multiple disk types
• Create a 32-bit aggregate and a 64-bit aggregate
• Execute aggregate commands
• Calculate usable disk space

Module 5: Logical Storage

• Volumes in the Data ONTAP operating system
• Define and create a flexible volume
• Execute vol commands
• Define and create qtrees

Module 6: Administration Security

• Restrict administrative access
• Restrict console and NSM access
• Configure a client machine

Module 7: Networking

• Identify the configuration of network settings
• Components in the Data ONTAP operating system
• Explain and configure name resolution services
• Configure routing tables in the Data ONTAP OS
• Define and create interface groups
• Discuss the operation of virtual LANs (VLANs)

Module 8: NFS

• NFS implementation in the Data ONTAP O/S
• License NFS on a storage system
• Explain the purpose and format of /etc/ exports
• List and define the export specification options
• Describe the use of the exportfs command
• Mount an export on a UNIX host

Module 9: CIFS

• Describe the CIFS environment
• Configure the storage system
• Share a resource on the storage system
• Map a drive from a client

Module 10: NAS Management

• Security methods for protecting data
• Security style setting for a volume and a qtree
• Tracking and restricting storage usage
• Explain, create, and manage quotas
• Data ONTAP FPolicy file-screening policy

Module 11: SAN

• Explain the purpose of a SAN
• Identify supported SAN configurations
• Distinguish between Fibre Channel (FC)
• Fibre Channel over Ethernet (FCoE) and
• iSCSI protocols
• Define a LUN and explain LUN attributes
• Use the LUN setup command
• Create iSCSI-attached LUNs
• Access and manage a LUN from a Windows host
• Define SnapDrive data management software

Module 12: Snapshot Copies

• Describe the function of Snapshot copies
• Explain the benefits of Snapshot copies
• Identify and execute Snapshot commands
• Create and delete Snapshot copies
• Configure and modify Snapshot options
• Explain the importance of the .snapshot directory
• Schedule Snapshot copies
• Configure and manage the Snapshot copy reserve

Module 13: Space Management

• Storage efficiency techniques
• Factors that impact space consumption
• Explain how to guarantee writes for a file
• Deduplication and compression techniques

Module 14: High-Availability

• Describe high-availability (HA) solutions
• How HA increases the reliability of storage
• Define HA controller configuration
• Describe the three modes of HA operation

Module 15: Virtualization Solutions

• Virtualize a storage controller
• Configure MultiStore software
• Assign client protocols on MultiStore software

Module 16: Backup and Recovery Methods

• Methods available to back up and recover data
• Use ndmpcopy to process full and incremental data transfers
• Discuss dump and restore
• Describe, enable, and configure NDMP on a storage system

Module 17: Data Collection Tools

• Use the sysstat, stats, and statit commands
• Factors that affect RAID performance
• Commands to collect data about write and read throughputs
• Verify the operation of hardware, and network components
• Commands that are used to obtain configuration and status

Module 18: Data ONTAP Upgrades

• Access the NetApp Support site for the following documents
• Data ONTAP Upgrade Guide
• Data ONTAP Release Notes
• Use a configuration worksheet to collect data for installation
• How to perform Data ONTAP software upgrades and reboots
• Use the setup command to configure a storage system

Reading Time: 5 minutes

Oracle RAC

Module 1: Oracle Real Application Clusters Overview

• Oracle RAC Features
• Oracle RAC Technology Hierarchy
• Oracle RAC Capabilities
• Oracle RAC Components
• Tools for Installing, Configuring and Managing Oracle RAC

Module 2: Oracle Grid Infrastructure Overview

• Cluster Overview
• Grid Foundation Components and Architecture
• Oracle Clusterware Components and RAC
• Oracle Clusterware Software and Storage
• Oracle Storage Subsystems
• File Types used by a RAC Database
• Methods used to Share Database Files across a Cluster
• ASM Architecture
• Create and Manage ASM Disk Groups
• Create and Manage ASM Cluster Filesystems
• An Overview of RAC Services
• Network Configuration

Module 3: RAC Installation Tasks

• Oracle RAC Pre-installation Tasks
• Create Oracle Groups, User Accounts and Directories
• Validate and Prepare the Hardware and the Operating System
• Network Configuration

Module 4: Install Oracle Grid Infrastructure and Real Application Clusters

• Install the Oracle Grid Infrastructure
• Cluster Verification Utility (CVU, CLUVFY)
• Install Oracle Database Software and Create a Cluster Database
• Verify the Installation
• Post Installation Tasks
• Configure Client Connections with Oracle Net Manager
• Convert an Oracle Database to a RAC Database
• Use the DBCA for Single Instance Conversion
• Use rconfig for Single Instance Conversion
• RAC Specific Background Processes

Module 5: RAC Cluster Database and Database Instance Administration

• RAC Initialization Parameters
• Manage Undo Tablespaces in a RAC Environment
• Manage Redo Log Files and Groups in a RAC Environment
• Oracle Enterprise Manager Cluster Database Pages
• Start and Stop Oracle RAC Databases and Instances
• Administer Database Storage
• Transparent Data Encryption and Wallets in RAC

Module 6: Administer Oracle Clusterware Components

• Manage CRS Commands
• CRSCTL Commands to Stop, Start and Administer Clusterware
• Backup and Recover Voting Disks
• Add and Remove Voting Disks
• The ocrcheck Utility
• The ocrdump Command
• Administer the Oracle Cluster Registry (OCR)
• Backup and Restore OCR
• Troubleshoot the OCR with ocrcheck

Module 7: ASM Instance Administration

• ASM Initialization Parameters
• Create an ASM Instance using ASMCA
• Start and Stop an ASM Instance using srvctl
• Start and Stop an ASM Instance using ASMCMD
• Start and Stop an ASM Instance Containing Cluster Files
• Start and Stop the ASM Listener

Module 8: ASM Disk Group Administration

• Create and Delete ASM Disk Groups
• ASM Disk Group Attributes
• ASM Disk Group Maintenance Tasks
• Preferred Read Failure Groups
• ASM Disk Statistics

Module 9: ASM Cluster File System Administration

• ASM Dynamic Volume Manager
• Manage ASM Volumes
• Create an ASM Cluster File System (ACFS)
• Manage a ACFS File System
• ACFS Snapshots
• Manage ACFS with Command Line Tools

Module 10: RAC Management Commands

• RAC Management Commands
• RAC Administration with SVRCTL
• SVRCTL Cluster Database Configuration Tasks
• SVRCTL Cluster Database Administration Tasks
• Check the Current Configuration
• SVRCTL Command Summary
• Administer Databases and Instances
• Administer Services and Node Applications
• Bring a Cluster Database online and offline
• Introduction to CRS
• Cluster Services

Module 11: Managing the Database Workload using Services

• Manage the Database Workload using Services
• Create and Administer Services in a RAC Environment
• Services and Client Applications
• Manage Services with Enterprise Manager and from the Command Line
• Configure Oracle Net to Support Services
• Configure Service Level Thresholds
• Configure Clients for Failover

Module 12: High Availability of Connections

• RAC High Availability Framework
• Failure Detection with Cluster Services
• Oracle RAC and Hardware Failover
• Connection Failover
• Transparent Application Failover (TAF)
• Server, Client And Runtime Load Balancing
• Fast Application Notification (FAN)
• Server and Client Side Oracle Notification Services

Module 13: Backup and Recover a RAC Database

• Configure a Fast Recovery Area for use with RAC
• Tune Instance Recovery in RAC
• Parallel Recovery in RAC
• Initiate Archiving
• Configure RMAN Backup and Recovery Settings
• Backup a RAC Database using RMAN
• Restore and Recover a RAC Database using RMAN
• Display Backup Reports

Module 14: Create Duplicate and Standby Databases with RAC

• Duplicate a RAC Database with RMAN
• Standby Database in a RAC Configuration
• Configure Data Guard for a RAC Environment
• Possible Combinations of Instances in the RAC Primary and Standby Databases
• Multi Instance Primary with a Single Instance Standby
• Set up a Primary in a RAC Environment
• Set up a Single Instance Standby Database
• Set up a Multiple Instance Primary and Cluster Standby
• Configure RAC Primary and Standby Databases
• Data Protection Modes
• Role Transition Switchovers and Failovers
• Switchover Failover in an Oracle RAC Configuration

Module 15: RAC Performance Tuning

• Monitoring and Performance Guidelines
• RAC Monitoring Tools
• RAC Performance Recommendations
• Analyze Performance Issues using OS Watcher and LTOM
• Use the Automatic Workload Repository in RAC
• Use the Automatic Database Diagnostic Monitor in RAC
• Use Statspack with RAC
• Global Cache Services (GCS) Monitoring
• V$cache_transfer Views
• Monitor the GES Processes
• Monitor and Tune the RAC Cluster Environment using Enterprise Manager

Module 16: Add and Delete Nodes and Clusters

• Prepare a New Node
• Extend the Oracle Grid Infrastructure Home to the New Node
• Extend the Oracle RAC Home Directory
• Add the New Node to the Cluster
• Create an Instance on the New Node
• Delete an Instance from the Cluster Database
• Remove a Node from the Cluster

Module 17: Manage Oracle Software and Apply Patches

• Configure the EM Patch Interface
• Obtain Patches
• Apply Rolling Patches to a RAC System
• Apply a Patchset with the opatch Utility
• Apply a Patchset with OUI