Course Content

Module 1: Foundations of Data Science

• Introduction to Data Science & Career Paths

• Excel for Data Analysis

• SQL for Data Extraction & Queries

Module 2: Python for Data Science

• Python Basics & Data Structures

• Libraries: NumPy, Pandas, Matplotlib, Seaborn

• Data Cleaning & Preprocessing

Module 3: Machine Learning

• Supervised vs Unsupervised Learning

• Regression, Classification, Clustering

• Model Evaluation & Tuning

Module 4: Deep Learning & AI

• Neural Networks & Backpropagation

• TensorFlow & PyTorch Basics

• Computer Vision & Natural Language Processing (NLP)

Module 5: Big Data & Cloud Computing

• Introduction to Big Data & Hadoop

• Spark for Data Processing

• Cloud Platforms (AWS) for Model Deployment

Module 6: Data Visualization & Storytelling

• Visualization with Matplotlib, Seaborn, Power BI/Tableau

• Dashboard Creation & Insights

• Communicating Results Effectively

Module 7: Real-World Projects & Deployment

• End-to-End Data Analysis Projects

• ML Model Deployment with Flask/Django

• Working with APIs & Automation

Module 8: Agile & Professional Skills

• Agile Methodology & Scrum

• Collaboration Tools (Git, GitHub, JIRA)

• Preparing for Data Science Interviews

1. CYBERSECURITY FUNDAMENTALS

2. ETHICAL HACKING ESSENTIALS

3. APPLICATION SECURITY & OWASP

4. API SECURITY & PENTESTING

   Module 1: Cybersecurity Fundamentals (10 Hours)

   Session 1: Introduction to Cybersecurity - CIA Triad, threats, security domains - Cybersecurity roles & job paths

Session 2: Networking Basics for Security - OSI model, TCP/IP stack - Packet analysis using Wireshark

Session 3: Protocols & Traffic Analysis - HTTP/S, DNS, FTP, ICMP - Inspecting protocol behavior with Wireshark

Session 4: Linux Basics for Security - User management, file permissions - Bash commands & log files

Session 5: Windows Security Essentials - Event Viewer, PowerShell basics - File ACLs, services

Session 6: Virtualization & Lab Setup - Setup Kali Linux, Metasploitable - Create isolated test environment

Session 7: Malware & Threats Overview - Viruses, trojans, ransomware - Use VirusTotal, Hybrid Analysis

Session 8: Firewalls, IDS/IPS – Understand FWs, IDS/IPS

Session 9: Security Policies & Compliance - ISO 27001, NIST, GDPR basics - Real-world compliance examples

Session 10: Incident Response & SOC Tools - SOC workflow & SIEM

Module 2: Ethical Hacking Essentials (10 Hours)

Objective: Understand hacker methodologies, common vulnerabilities, and exploit techniques using Kali Linux and real tools.

Session 11: Ethical Hacking Methodology - Stages: Recon to Reporting - Setup hacking tools in Kali

Session 12: Footprinting & Reconnaissance - whois, nslookup, Shodan, Google Dorking - Maltego and online recon

Session 13: Scanning Networks - Nmap scans (TCP, UDP, service detection) - OS and version detection

Session 14: Enumeration - NetBIOS, SMB, SNMP

Session 15: Vulnerability Scanning - OpenVAS, Nessus walkthrough - Manual vulnerability triage

Session 16: Exploitation with Metasploit - MS08-067 exploit demo - Using Meterpreter sessions

Session 17: Maintaining Access & Privilege Escalation - Basic persistence and privilege tools

Session 18: Web App Footprinting - Burp Suite intercept & crawl - Analyze headers, cookies, JS files

Session 19: Password Attacks - Hydra, Hashcat, rockyou wordlists - Crack Linux shadow file or FTP creds

Session 20: Report Writing & Risk Rating - CVSS basics - Create penetration test report (template provided)

Module 3: Application Security & OWASP Top 10 (15 Hours)

Objective: Perform hands-on testing of common web application vulnerabilities using DVWA, Juice Shop, portswigger labs and Burp Suite.

Session 21: Web Application Architecture - Client-server, cookies, sessions - State management and security impact

Session 22: Identification & Auth Failures - Broken login logic, predictable tokens - Brute force login using Burp Intruder

Session 23: Broken Access Control - IDOR, Role escalation - Lab: DVWA / JuiceShop access bypass/ portswigger labs

Session 24: Cryptographic Failures - Insecure transport (HTTP), weak encryption - Analyze JWT tokens, TLS inspection

Session 25,26 & 27: Injection (SQL, OS) - SQLMap automation + manual SQLi - Command injection in web forms

Session 28 & 29: XSS – XSS types, attack scenarios. Lab challenges solving

Session 30: Security Misconfiguration - Directory listing, default creds - HTTP methods and headers test

Session 31: Vulnerable Components - Identify outdated libraries with retire.js, Snyk - Exploit known CVEs

Session 32: Software & Data Integrity, Insecure Design - Tampered software updates

Session 33 & 34: SSRF & Logging Issues - SSRF via file/image fields - Log injection, insufficient logging

Session 35: DevSecOps Intro – SAST/SCA

Module 4: API Security & Pentesting (10 Hours)

Objective: Hands-on, job-ready API pentesting module using OWASP crAPI mapped to OWASP API Top 10, including real-world attacks and professional reporting.

Session 36 & 37: API Security Basics & OWASP API Top 10 - REST, SOAP, GraphQL - Test APIs with Postman/ZAP (demo apis)

Session 38: crAPI Setup & Architecture - OWASP Mapping: N/A - Lab Tasks: - Setup crAPI using Docker - Explore frontend, backend, API gateway - Review Swagger documentation and API endpoints

Session 39: Reconnaissance & Endpoint Discovery - OWASP Mapping: API1 - Broken Object Level Authorization - Lab Tasks: - Discover endpoints via Swagger & Burp Suite - IDOR: Access unauthorized bookings /api/v1/workshop/booking/{id}

Session 40: Broken Authentication - OWASP Mapping: API2 - Broken Authentication - Lab Tasks: - Password reset without ownership - OTP Bypass / JWT abuse using insecure token

Session 41: Excessive Data Exposure - OWASP Mapping: API3 - Excessive Data Exposure - Lab Tasks: - Dump verbose JSON - Extract email, address from other users

Mass Assignment - OWASP Mapping: API6 - Mass Assignment - Lab Tasks: - POST /api/v1/me/update-details to change roles - Add unauthorized fields in payload

Session 42: Security Misconfiguration - OWASP Mapping: API7 - Security Misconfiguration - Lab Tasks: - Abuse Swagger endpoints - CORS misconfig / Unused HTTP methods

Session 43: Rate Limiting & Brute Force - OWASP Mapping: API4 - Lack of Resources & Rate Limiting - Lab Tasks: - Brute force OTP/passwords - Enumerate usernames

Session 44: Broken Function Level Authorization - OWASP Mapping: API5 - BFLA - Lab Tasks: - Delete another user’s booking - Access admin functions without elevated role

Session 45: SSRF (Server-Side Request Forgery) - OWASP Mapping: API8 - SSRF - Lab Tasks: - SSRF via profile image upload or feedback module

Full Pentest Challenge & Report Writing - OWASP Mapping: Consolidated - Lab Tasks: - Capture all crAPI challenge flags - Document vulnerabilities with: - CVSS score - Exploit steps - Screenshots - Remediation

Tools Used: - Docker Desktop (to host crAPI) - Postman - Burp Suite (Community or Pro) - Swagger UI - JWT.io - Dirsearch / Ffuf (optional)

Deliverables: - crAPI Lab Manual (step-by-step + screenshots) - API Pentest Report Template - OWASP API Top 10 to crAPI Mapping Sheet - Burp/Postman Cheat Sheet - Trainer Slides (PDF/PPT format)

Excel:

·      Introduction to Excel & Interface

·      Data Entry, Formatting and Shortcuts

·      Formulas and Functions

·      Conditional Formatting & Data Validation

·      Sorting, Filtering and Advanced Filter

·      Data Cleaning in Excel (TRIM, CLEAN, Remove Duplicates)

·      Pivot Table

·      Revision

SQL:

Introduction to SQL Databases

·      Definition and Purpose

Introduction to SQL Server

·      Introduction to Databases

·      DBMS

·      RDBMS

·      Different types of RDBMS

Commands and Data Types

·      SQL Commands

·      Data Types

SQL Queries

·      SELECT Statement

·      WHERE

·      Distinct

·      Logical Operators

·      Comparison Operators

·      Order by

·      Top/Limit

Filtering Data

·      IN and Not IN

·      Between

·      Like and Wild Cards

·      Null Concepts

Aggregate Functions

·      Count

·      Sum

·      Avg

·      Min

·      Max

·      Group By

·      Having

Database Joins

·      Inner

·      Left

·      Right

·      Full Outer

·      Self, Cross

Windows Function

·      Row number

·      Rank, Dense Rank

·      Lead, Lag

SQL Functions

·      String Functions

·      Date Functions

·      Numeric Functions

Data Definition Language

·      Create

·      Drop

·      Alter

·      Rename

·      Truncate

·      Modify

·      Comment

Data Manipulation Language

·      Insert

·      Update

·      Delete

Data Transaction Language

·      Commit

·      Rollback

·      Savepoint

SQL Advanced Topics

·      Case Statement

·      Views

·      Stored Procedures

·      Indexes

·      Unions

·      Transactions/ Functions

·      Sub Queries

·      Exception handling

Case Studies and Projects

Python:

 Introduction to Python & Setup

·      Installing Python / Anaconda

·      Jupyter Notebook basics

·      Virtual environments

·      Git & GitHub basics

Python Fundamentals

·      Variables and data types

·      Operators

·      Conditional statements (if, else, elseif)

·      Loops (for, while)

·      Functions and scope

·      Data structures: List, Tuple, Set, Dictionary

·      List comprehensions

·      Exception handling

Working with Files & Modules

·      Reading and writing files (CSV, JSON, TXT)

·      Importing modules & packages

·      Creating custom modules

·      Logging and docstrings

NumPy for Numerical Computing

·      Creating ndarrays

·      Indexing & slicing

·      Broadcasting

·      Vectorized operations

·      Mathematical & statistical functions

·      Random module and sampling

·      Linear algebra basics

Pandas for Data Manipulation

·      Series and Data Frame creation

·      Reading/writing data (CSV, Excel, SQL)

·      Selection and filtering

·      GroupBy and aggregation

·      Merging and joining datasets

·      Pivot tables and reshaping data

Data Cleaning & Feature Engineering

·      Handling missing values

·      Detecting and treating outliers

·      Data type conversions

·      Encoding categorical variables

·      Feature scaling

·      Creating new features

Data Visualization

·      Matplotlib basics (line, bar, scatter, histogram)

·      Seaborn for statistical plots

·      Customizing plots (labels, titles, legends, colors)

·      Correlation heatmaps

·      Interactive plots with Plotly (optional)

Statistics in Python

·      Descriptive statistics

·      Probability distributions

·      Sampling & Central Limit Theorem

·      Hypothesis testing (t-test, chi-square)

·      Correlation vs causation

Tableau

Introduction to Tableau

·      Overview of Tableau and its components (Tableau Desktop, Tableau Server, Tableau Online, Tableau Public)

·      Installing Tableau and understanding the interface

·      Connecting to different data sources (Excel, CSV, Databases, Cloud)

·      Live vs Extract connections

·      Basic navigation and workspace layout

Data Connection and Preparation

·      Connecting to files, databases, and web connectors

·      Data Interpreter and data cleaning options

·      Renaming, splitting, and pivoting fields

·      Managing metadata (data types, field names, default properties)

·      Data blending vs data joins

Basic Visualizations

·      Creating bar charts, line charts, pie charts, and maps

·      Using ShowMe panel for quick chart creation

·      Working with filters, sorting, and highlighting

·      Formatting charts (colors, fonts, borders, alignment)

·      Adding titles, captions, and tooltips

Intermediate Visualizations

·      Dual-axis charts and synchronized axes

·      Combined axis charts

·      Scatter plots, bubble charts, and treemaps

·      Heat maps and highlight tables

·      Gantt charts and area charts

Advanced Charts and Analytics

·      Waterfall charts, bullet charts, and funnel charts

·      Pareto charts and control charts

·      Reference lines, bands, and distributions

·      Forecasting and trend lines

·      Clustering and analytics pane features

Calculations in Tableau

·      Types of calculations (Basic, Level of Detail, Table Calculations)

·      String, date, and numeric functions

·      Logical functions (IF, CASE)

·      Aggregate vs non-aggregate calculations

·      Parameter usage with calculations

Mapping in Tableau

·      Building basic maps and filled maps

·      Geographic roles and custom geocoding

·      Custom background images

·      Layers and map styles

·      Path maps for showing movement

Dashboards

·      Creating dashboards and layout options

·      Adding and arranging multiple visualizations

·      Using containers (horizontal, vertical, tiled, floating)

·      Dashboard actions (filter, highlight, URL actions)

·      Device-specific dashboard design

 Storytelling in Tableau

·      Creating stories and story points

·      Linking dashboards in a story

·      Using annotations and descriptive text

·      Best practices for narrative flow

Performance Optimization

·      Extracts vs live connections for performance

·      Filtering strategies for large datasets

·      Reducing load time with context filters and aggregation

·      Performance recording and analysis

Tableau Server & Tableau Online

·      Publishing workbooks and dashboards

·      Permissions and user roles

·      Scheduling extracts and refreshes

·      Version control and collaboration

·      Project structure and best practices

Tableau Best Practices & Real-World Scenarios

·      Dashboard design principles

·      Color theory and accessibility in Tableau

·      Handling large datasets efficiently

·      Creating interactive, user-friendly visualizations

·      Real-time case studies and projects

Course Content:

1. Introduction to Automation Testing

• Basics of Testing & QA Concepts

• Types of Testing (Functional, Regression, UI/UX)

• Benefits of Automation Testing

2. Playwright Fundamentals

• Introduction to Playwright

• Setting up the Environment

• Cross-Browser Automation

• Playwright Selectors & Actions

• Handling Alerts, Frames, and Popups

3. TypeScript for Automation

• TypeScript Basics & Syntax

• Variables, Data Types & Functions

• Object-Oriented Programming Concepts

• Integration with Playwright Scripts

4. Advanced Playwright Automation

• Writing Modular & Reusable Test Scripts

• Handling Dynamic Elements & Async Operations

• Test Assertions & Validations

• Parallel Testing & Reporting

5. Hands-On Projects & Practical Scenarios

• Real-Time Web Application Testing

• CI/CD Integration for Automation Scripts

• End-to-End Automation Projects

TypeScript

            Introduction to Typescript

            Variables & Datatypes

            Type inference & Type assertion

            Decision making statements

            Iterative statements

            Functions & Arrays

            Classes & Objects

            Constructors

            Data Modifiers

Introduction to Playwright

            Introduction to playwright features

            Installing VS code & node.js

            Setting up playwright environment

Getting started with playwright Automation

            Create first npm project & install playwright dependencies

            Importance of Playwright Test Annotation and async & await understanding

            Browser context and Page fixtures in Playwright

Importance of Playwright configuration file and its details to run the tests

            Running Playwright tests in multiple browsers - chrome, Firefox

Playwright basic methods for web automation

            Locators supported by playwright and how to type into elements on page

            Extracting the text from browser and inserting valid expect assertions in test

            How to work with locators which extract multiple web elements in page

            Understanding how wait mechanisms works if list of elements are returned

            Techniques to wait dynamically for new page in Service based applications

Handling UI components

            Handling static select dropdown options

            Selecting radio buttons, Checkboxes and implement expect assertions

Using async await with Assertions and understand validating the attributes

Handling Child windows & Tabs with Playwright by switching browser

Learn playwright inspectors and trace viewers

            Playwright inspector and how to debug the playwright script

Codegen tool to record & Playback with generated automation script

Detailed view of Test Traces,

HTML reports, logs & Screenshots for test results

Handling dialogs, frames, event listeners

How to automate Java/JavaScript Alert popups with Playwright

How to handle & automate frames with Playwright

API testing-

            Understanding the importance of API integration calls for Web tests

Playwright request method to make API calls and grab response

Parsing API response & passing token to browser local storage with Playwright

Perform visual testing with playwright

            Capture screenshots with playwright page & partial Element level – Demo         

What is visual testing & How to perform it using Playwright

            Page object pattern & Importance of its implementation

Creating Page objects and action methods for end to end Script - Part 1

Creating Page objects and action methods for end to end Script - Part 2

Project configurations & config options

            Various options in use property & setting up Project configurations

HTML & allure reporting

            How to generate html and allure reporting

            How to create custom scripts to trigger the tests from package.json

ServiceNow ITSM & Integration - 60 Day Syllabus

Module 1: ServiceNow Platform Essentials (10 Days)

Objective: Understand the core ServiceNow platform structure and basic configurations.

Day 1 - Introduction to ServiceNow (Navigation, Application Explorer)

Day 2 - Tables, Forms, Lists, and Dictionary

Day 3 - Users, Roles, and Access Control (ACL basics)

Day 4 - UI Policies, Data Policies, Client Scripts

Day 5 - Business Rules & Script Includes

Day 6 - Notifications and Email Configuration

Day 7 - ServiceNow Studio & Scoped Applications

Day 8 - Application Files: Modules, Menus, Roles

Day 9 - Update Sets - Create, Export, Import

Day 10 - Review + Quiz/Assessment

Module 2: Core ITSM Applications (20 Days)

Objective: Learn the full lifecycle and configuration of core ITSM processes: Incident, Problem, Change, and Request.

Day 11 - Introduction to ITIL & ITSM in ServiceNow

Day 12 - Incident Management: Overview, States, Priorities

Day 13 - Incident Form, Assignment Rules, SLAs

Day 14 - Auto-routing via Business Rules & Script

Day 15 - Problem Management: Lifecycle, Root Cause

Day 16 - Problem Form Customization

Day 17 - Change Management: Normal, Standard, Emergency

Day 18 - Change Approval Policies & Workflows

Day 19 - Request Management vs Incident vs Change

Day 20 - Catalog Items, Record Producers

Day 21 - Catalog Item Variables & Variable Sets

Day 22 - Request Workflow Design using Visual Workflow Editor

Day 23 - Knowledge Management Basics

Day 24 - SLAs: Definitions, Conditions, Retroactive Start

Day 25 - Escalation Rules, Time Breach Alerts

Day 26 - CAB Workbench Overview

Day 27 - ITSM Reporting - Reports, Performance Analytics Intro

Day 28 - Dashboards and Homepages

ServiceNow ITSM & Integration - 60 Day Syllabus

Day 29 - Live Agent Chat, Virtual Agent Basics (optional)

Day 30 - ITSM Use Case Lab (Automate Ticket Lifecycle)

Module 3: Scripted Integrations (20 Days)

Objective: Perform real-world ServiceNow integrations using Scripted REST, REST Message, and Inbound APIs. No

IntegrationHub.

Day 31 - Introduction to Integrations in ServiceNow

Day 32 - REST API Concepts (Methods, Headers, JSON)

Day 33 - Using REST API Explorer

Day 34 - Scripted REST API - Create a custom API

Day 35 - Scripted REST with Input Validation & Responses

Day 36 - Consume External API with REST Message

Day 37 - REST Message Authentication (Basic Auth / OAuth profile)

Day 38 - Call External Weather/Currency APIs using Script

Day 39 - Transform JSON/XML Data

Day 40 - Test REST APIs using Postman

Day 41 - Scheduled Scripted API Call (REST polling)

Day 42 - Inbound REST: External system creates Incident

Day 43 - Use Business Rule to Trigger Outbound REST

Day 44 - REST Call Error Handling & Logging

Day 45 - Mid Project Review: End-to-End Integration

Day 46 - Import/Export JSON or CSV using Import Sets

Day 47 - Script to Trigger Notifications from External Events

Day 48 - Attachment API - Upload/Download Files via API

Day 49 - Integration Best Practices & Security (ACLs, Rate Limits)

Day 50 - Integration Lab: External Tool Creates Incident, Notifies on Closure

Module 4: Final Project & Certification Prep (10 Days)

Objective: Implement a full use case and prepare for interviews and CSA certification.

Day 51-52 - Use Case Finalization & Planning

Day 53-56 - Final Project: Scripted Integration for Ticketing

Day 57 - Presentation & Documentation

Day 58 - CSA Certification Overview & Practice Questions

ServiceNow ITSM & Integration - 60 Day Syllabus

Day 59 - Mock Test (CSA-style)

Day 60 - Career Guidance + Interview Q&A + Feedback

Tools & Deliverables

Tools:

- ServiceNow PDI

- Postman

- VS Code (optional)

- GitHub (optional)

Deliverables:

- Lab Exercises

- API Scripts

- ITSM Customization Scripts

- Final Integration Project

- CSA Mock Exam Pack

- Resume + Projects