Learn by doing · free
Hands-on Labs
Reading a chapter is step one. In a lab you do it yourself, on your own laptop or your own free account, one numbered step at a time, and you check your result after every important step.
- 85 labs ready
- 117 coming soon
- One lab for every chapter
How every lab works
- A short real-world story (Suppose we are…), the goal, the time it takes and the free tools you need.
- Numbered steps with the exact clicks and commands, and a What you should see line after the important ones.
- Common mistakes with fixes, a self-check checklist, and a challenge to try at home.
Labs by course
Cyber Security labs 50 ready · 0 coming soon
- Cyber Security · Chapter 1Find Your Laptop's Private IP, Router Gateway and Public IPUse ipconfig or ifconfig to find your private IP and gateway, check your public IP in the browser, and draw your home network.Start the lab →
- Cyber Security · Chapter 2Check Which Programs on Your Laptop Are Listening and Turn On the FirewallSee every listening port on your own Windows laptop or Mac with netstat or lsof, find the program behind it and switch on the firewall.Start the lab →
- Cyber Security · Chapter 3Watch Your Own DNS (UDP) and HTTPS (TCP) Traffic in WiresharkCapture your own laptop's traffic in Wireshark, find one DNS question over UDP and one TCP 3-way handshake, and label each OSI layer.Start the lab →
- Cyber Security · Chapter 4Launch a Free-Tier EC2 Server Safely: Key Pair, My IP Only and a Budget AlertSet a zero-spend budget alert first, launch an Amazon Linux 2023 server with a new key pair, allow SSH only from your IP, connect and clean up.Start the lab →
- Cyber Security · Chapter 5Organise a Practice Folder and Set Safe Linux Permissions (644 and 755)Create a project folder with mkdir and touch, read ls -l permissions, fix them to 644 and 755 with chmod, and protect a secrets file with 600.Start the lab →
- Cyber Security · Chapter 6Read Your Server's SSH Login Log and Spot Failed Login AttemptsUse journalctl, grep, awk, sort and uniq on your own server to list failed SSH logins, count them per IP and see who logged in successfully.Start the lab →
Show all 50 ready Cyber Security labs
- Cyber Security · Chapter 7Install Nginx, Hide the Version Number and Test the Config SafelyInstall Nginx on Amazon Linux 2023, see the version leak in curl -I, turn on server_tokens off, test with nginx -t and reload without downtime.Start the lab →
- Cyber Security · Chapter 8Host a Static Page, Add Security Headers and Verify Them with curlPublish your own page on Nginx, add nosniff, frame, referrer, permissions and CSP headers in one file, and verify them with curl and browser DevTools.Start the lab →
- Cyber Security · Chapter 9Set Up LEMP with PHP-FPM and Switch Off PHP Error DisplayAdd PHP-FPM to Nginx, see how a PHP warning leaks your server's file path, then set display_errors and expose_php to Off and log errors instead.Start the lab →
- Cyber Security · Chapter 10Create a Practice Database and a Least-Privilege MySQL User That Can Only SELECTInstall MariaDB, secure it, create a shop database, and add a report user with only SELECT on that database, then prove INSERT and DROP are denied.Start the lab →
- Cyber Security · Chapter 11Back Up and Restore a MySQL Database with mysqldump, Then Remove an Unused UserBack up the shop database with mysqldump, delete data on purpose, restore it and check every row, then list and drop a user you no longer need.Start the lab →
- Cyber Security · Chapter 12Check a Domain's A, CNAME, MX and TXT Records with dig and nslookupLook up A, CNAME, MX and TXT records with nslookup and dig, check SPF and DMARC for email safety, and compare answers from two public DNS servers.Start the lab →
- Cyber Security · Chapter 13Add HTTPS with Certbot, Force the HTTP-to-HTTPS Redirect and Test RenewalGet a free Let's Encrypt certificate for your own domain with Certbot, force HTTP to HTTPS, add HSTS, check the certificate and test auto-renewal.Start the lab →
- Cyber Security · Chapter 14Keep an S3 Bucket Private and Share One File with a Presigned URLCreate a private S3 bucket, prove the object URL is denied, share one file for 5 minutes with a presigned URL, watch it expire, then clean up.Start the lab →
- Cyber Security · Chapter 15Make an RDS Database Private: No Public Access, App-Only Security Group, Backups OnCreate a free-tier RDS MySQL database with public access off, let only your EC2 app server connect, prove your laptop cannot, check backups and clean up.Start the lab →
- Cyber Security · Chapter 16Security Review of Your Reels App: Secrets Out of Code, Least-Privilege IAM Role, Private RDSReview your own project like a security engineer: search the code and Git history for secrets, switch to an IAM role scoped to one bucket, and check RDS and S3 settings.Start the lab →
- Cyber Security · Chapter 17Plan Your Safe Practice Lab: Isolated Network, Your Own Machines, Written ScopeCheck your laptop can run virtual machines, choose the lab VMs, draw an isolated host-only network and write a one-page scope you will follow.Start the lab →
- Cyber Security · Chapter 18Build an Isolated VirtualBox Lab (Host-Only Network) with a Training VMCreate a VirtualBox host-only network, add Kali Linux and the Metasploitable 2 training VM, prove they cannot reach the internet, and take clean snapshots.Start the lab →
- Cyber Security · Chapter 19Inventory the Devices and Open Services in Your Own Isolated LabUse nmap only inside your host-only lab to list live hosts and service versions on the training VM, decide what to close, close one service and re-check.Start the lab →
- Cyber Security · Chapter 20Audit Your Own Linux VM with Lynis, Rank the Findings and Plan the FixesRun the free Lynis security audit on your own Ubuntu VM, read the hardening index, warnings and suggestions, fix two items and prove the score went up.Start the lab →
- Cyber Security · Chapter 21Run OWASP Juice Shop Locally, Review Its Headers, Cookies and Error Pages, and Write the FixesRun the OWASP Juice Shop training app on your own laptop only, inspect its headers, cookies and error page with curl and DevTools, and write a developer fix for each finding.Start the lab →
- Cyber Security · Chapter 22Set Up a Password Manager and Turn On 2-Step Verification for GmailPut every password in a free Bitwarden vault, add an authenticator app to Gmail, print backup codes and test the sign-in.Start the lab →
- Cyber Security · Chapter 23Patch an Outdated Package on Your Own VM and Verify the CVE Is FixedTake a snapshot, find upgradable packages, check one CVE with pro fix and the changelog, patch OpenSSH, restart the service and prove the fixed version is running.Start the lab →
- Cyber Security · Chapter 24Compare an HTTP and an HTTPS Login in Wireshark and See Why TLS MattersSend a fake practice login to a public test service over HTTP and HTTPS, capture your own traffic in Wireshark, read the password in plain text, then see it encrypted.Start the lab →
- Cyber Security · Chapter 25Harden Your Home Wi-Fi Router: WPA3 or WPA2-AES, New Admin Password, WPS Off, Firmware UpdatedLog in to your own router, change the default admin password, switch to WPA3 or WPA2-AES, turn off WPS and remote admin, update firmware, and verify from your laptop.Start the lab →
- Cyber Security · Chapter 26Audit sudo Rights and SUID Files on Your Own Linux Server and Remove What Is Not NeededList who can use sudo, find NOPASSWD rules, list every SUID file, spot one that no package owns, and remove the extra rights safely.Start the lab →
- Cyber Security · Chapter 27Spot the Phish: Check the Sender, Links and Headers of 5 Sample Emails and Report One CorrectlyDownload 5 sample emails, check From, Reply-To, SPF/DKIM/DMARC results and real link targets, decide which are phishing, then learn the right way to report one.Start the lab →
- Cyber Security · Chapter 28Collect Evidence Safely: Hash Files with SHA-256 and Build a Simple Timeline from LogsDownload a sample evidence pack, verify its SHA-256, hash every file, prove your working copy is unchanged, then build a minute-by-minute incident timeline.Start the lab →
- Cyber Security · Chapter 29Fix-It Lab: Turn an Unsafe SQL Query in a Training App into a Parameterised QueryRun a tiny Python training app on 127.0.0.1, see the name O'Brien break its SQL query, fix it with a parameterised query and hide the error details.Start the lab →
- Cyber Security · Chapter 30Secure a New AWS Account: Root MFA, an Admin IAM User, CloudTrail and a Billing AlarmLock the root user with MFA, confirm it has no access keys, create an admin IAM user with MFA, turn on a free CloudTrail trail and a zero-spend budget, then clean up.Start the lab →
- Cyber Security · Chapter 31Read a Login Log Like a SOC Analyst: Find Brute-Force Patterns and Write a Short Incident NoteAnalyse a sample 83-line SSH log with grep, sort and uniq: count failures per IP, spot brute force and password spraying, find the one successful break-in, and write an incident note.Start the lab →
- Cyber Security · Chapter 32Harden a Fresh Linux Server: Updates, Key-Only SSH, Host Firewall and fail2banOn your own Ubuntu VM, install updates, switch SSH to keys only without locking yourself out, turn on UFW allowing only SSH, and protect SSH with fail2ban.Start the lab →
- Cyber Security · Chapter 33Check an HTTPS Certificate Chain in the Browser and Verify a Download with Its SHA-256 HashOpen a site's certificate viewer, read the leaf, intermediate and root certificates and expiry, check the same with openssl, then verify a PuTTY download against its SHA-256 list.Start the lab →
- Cyber Security · Chapter 34Prepare a Cyber-Crime Reporting Checklist for cybercrime.gov.in and the 1930 Helpline (Practice Only)Walk through a practice UPI-fraud case, list the evidence the 1930 helpline and cybercrime.gov.in need, explore the portal without submitting, and make a one-page family checklist.Start the lab →
- Cyber Security · Chapter 35Read a Real Bug Bounty Programme's Scope Page and List What Is In and Out of ScopeOpen a public bug bounty programme, read its policy and scope like a professional, and fill a one-page summary: in-scope assets, out-of-scope items, banned tests, safe harbour and disclosure rules.Start the lab →
- Cyber Security · Chapter 36Watch Your Own Login and File Events with auditd: Write Watch Rules and Search Them with ausearchInstall the Linux audit system on your own VM, watch /etc/passwd, sudoers and sshd_config, trigger safe changes, and find who changed what with ausearch and aureport.Start the lab →
- Cyber Security · Chapter 37Reduce What Your Lab Machines Share: SMBv1, NetBIOS and Default SNMP Off, Then VerifyCheck SMBv1, NetBIOS over TCP/IP, shares and SNMP on your own Windows laptop and Ubuntu VM, switch off what is not needed, and verify with PowerShell, ipconfig and nmap from your lab.Start the lab →
- Cyber Security · Chapter 38Separate Your Admin and Daily Accounts on Windows and Audit Failed Logons (Event ID 4625)Create a standard daily account, keep a separate admin account, set UAC to Always notify, turn on logon auditing with auditpol and find failed logons (4625) in Event Viewer and PowerShell.Start the lab →
- Cyber Security · Chapter 39Check a Suspicious File Safely with Hashes and a Reputation Lookup, Without Ever Running ItWatch Microsoft Defender catch the harmless EICAR test file, read Protection history, then hash a file and look up its reputation on VirusTotal by hash only, never uploading private files.Start the lab →
- Cyber Security · Chapter 40Add Rate Limiting to Nginx on Your Own Server and Confirm It Returns 429 Under a Small Load TestAdd limit_req to Nginx on your own EC2 server, test the config, send 30 quick requests to localhost, see 200s turn into 429s, and read the limiting lines in the error log.Start the lab →
- Cyber Security · Chapter 41Set Secure, HttpOnly and SameSite Cookie Flags on Your Own App and Check Them in DevToolsRun a tiny training app on localhost, see its session cookie readable by JavaScript in DevTools, add HttpOnly, Secure and SameSite in one line of code, and prove the fix.Start the lab →
- Cyber Security · Chapter 42Write and Test a Simple Detection Rule for Traffic in Your Own Lab with SuricataInstall the free Suricata IDS on your lab Ubuntu VM, write two local rules (ping and new SSH connections), test them with -T, generate the traffic yourself and read the alerts in fast.log.Start the lab →
- Cyber Security · Chapter 43Secure Your Home IoT: Change Default Passwords, Update Firmware and Move Devices to a Guest NetworkList every smart device on your home Wi-Fi from the router, secure each app account with a strong password and 2-step verification, update firmware, and move devices to a separate guest network.Start the lab →
- Cyber Security · Chapter 44Phone Security Check-Up: Screen Lock, App Permissions, Find My Device and UpdatesIn 30 minutes, check your phone's screen lock, OS updates, risky app permissions, unknown-app installs, Find My Device or Find My iPhone, and a SIM PIN, and prove each from a second device.Start the lab →
- Cyber Security · Chapter 45Mini Capstone: Harden, Monitor and Back Up One Lab Server End to EndBring together Labs 23, 26, 32 and 36 on one Ubuntu VM: patch, key-only SSH, firewall, fail2ban, auditd, a daily backup with retention, a restore test and a one-page scorecard.Start the lab →
- Cyber Security · Chapter 46Mock Interview Lab: Explain 10 Security Basics Aloud and Record a 2-Minute AnswerAnswer 10 common cyber security interview questions aloud with a simple 4-part structure, record your best answer on your phone, score it with a rubric and record it again.Start the lab →
- Cyber Security · Chapter 47Whiteboard Practice: Draw and Explain a Secure 3-Tier Web App in 10 MinutesDraw a 3-tier web app (load balancer, app servers, database) with subnets and chained security groups, add logging and backups, and explain it in 10 minutes using a scoring rubric.Start the lab →
- Cyber Security · Chapter 48Build a CEH Revision Tracker and Solve 20 Practice Questions with Notes on Every Wrong AnswerDownload a tracker for the 20 CEH v13 modules mapped to this course's labs, rate your confidence, answer 20 original practice questions, and turn each wrong answer into a revision note.Start the lab →
- Cyber Security · Chapter 49Make Your Own One-Page Defensive Command Cheat Sheet and Test Every Command in Your LabPick 20 defensive commands from your labs, group them by task (check, harden, detect, recover), test each on your own VM, record the expected output, and fit it on one printable page.Start the lab →
- Cyber Security · Chapter 50Glossary Flashcards: 30 Security Terms in English and Marathi, with a Self-TestDownload 30 key security terms with Marathi meanings, turn them into flashcards in Anki or on paper, explain each in one line, and pass a 30-term self-test.Start the lab →
Power BI labs 35 ready · 0 coming soon
- Power BI · Chapter 1Plan a One-Page KPI Report for a Food-Delivery Business on Paper Before Opening Power BITake 12 sample Swiggy-style orders, pick 6 KPIs, calculate each one by hand and sketch the one-page report before you touch Power BI.Start the lab →
- Power BI · Chapter 2Install Power BI Desktop and Find the Report, Table and Model Views and Every PaneInstall the free Power BI Desktop, load a 24-row sales file, then find each view and pane and use each one once.Start the lab →
- Power BI · Chapter 3Load a Sales CSV into Power BI Desktop and Build Your First Bar ChartLoad a 12-row sales CSV with Get data → Text/CSV, check it in Table view and build a sorted bar chart of sales by city.Start the lab →
- Power BI · Chapter 4Connect Power BI to a Local SQL Server Express Database and Compare Import with DirectQueryCreate a 24-order ShopDB in free SQL Server Express, connect it twice (Import and DirectQuery), insert one order and watch which report sees it.Start the lab →
- Power BI · Chapter 5Load a Public Web Table and a Published Google Sheet into Power BI, Then Refresh BothPull the 36 Maharashtra districts from a Wikipedia table, load city targets from your own published Google Sheet, change one target and refresh.Start the lab →
- Power BI · Chapter 6Clean a Messy Sales File in Power Query – Promote Headers, Fix Data Types, Remove Blank RowsTurn an ERP export with title rows, blank rows, a Total row, dd-mm-yyyy dates and Indian-style amounts into a clean 10-row table.Start the lab →
Show all 35 ready Power BI labs
- Power BI · Chapter 7Fix 10 Common Data Problems in One Customer File with Power QueryClean a 12-row customer list with extra spaces, mixed case, duplicates, blanks, N/A dates, M/F codes and five phone formats into 10 clean rows.Start the lab →
- Power BI · Chapter 8Add a Profit Column Twice – in Power Query and as a DAX Calculated Column – and CompareMake Profit = Sales − Cost as a Power Query custom column, as a DAX calculated column and as a measure, then see where each one lives and which to keep.Start the lab →
- Power BI · Chapter 9Combine Three Monthly Bank-Statement CSVs from a Folder and Refresh When a Fourth Month ArrivesPoint Get data → Folder at three monthly statements, combine them into one 18-row table, then drop in April and refresh to 24 rows with zero new steps.Start the lab →
- Power BI · Chapter 10Turn the File Path into a Power Query Parameter So the Report Works on Any LaptopReplace a hard-coded C:\Users\… path with a FolderPath parameter, break the report on purpose by moving the file, then fix it in 10 seconds with Edit parameters.Start the lab →
- Power BI · Chapter 11Build a Star Schema – One Sales Fact Table with Date, Product and City Dimension TablesLoad a sales fact table and two dimension CSVs, create a DAX date table, connect them one-to-many in Model view and slice sales by Category, Region and Year.Start the lab →
- Power BI · Chapter 12Create a Year › Quarter › Month Hierarchy and Group Cities into RegionsBuild a Calendar hierarchy from your date table, expand it in a matrix down to months, and group four cities into two sales zones without writing DAX.Start the lab →
- Power BI · Chapter 13Write Your First CALCULATE Measure: Total Sales for Mumbai OnlyWrite Total Sales with SUM and Mumbai Sales with CALCULATE, show them in a card and tables, and see why the city filter is replaced.Start the lab →
- Power BI · Chapter 14Build and Format Five Core Visuals – Card, Bar, Line, Table and MatrixOn the star-schema model, build three KPI cards, a sorted bar chart, a 2025-vs-2026 line chart, a product table and a City × Year matrix, then format them consistently.Start the lab →
- Power BI · Chapter 15Plot Sales by Maharashtra District on a Map and Fix Wrong Locations with Data CategoryPut 10 district sales on a bubble map, see why names like Aurangabad and Amravati can land in the wrong state, and fix them with a full place name, Data category and coordinates.Start the lab →
- Power BI · Chapter 16Drill from Year to Month on a Sales Chart and Explain Each Drill ButtonUse the Calendar hierarchy in a column chart, drill into 2025, find the weak quarter, see all 12 months, and learn what each of the four drill buttons really does.Start the lab →
- Power BI · Chapter 17Build a City Details Page and Drill Through to It from a Bar ChartMake a hidden City Details page with an order list and cards, set City as its drill-through field, then right-click Pune on the main chart and land on Pune's six orders.Start the lab →
- Power BI · Chapter 18Create a Report-Page Tooltip That Shows the Product Split When You Hover over a CityBuild a small tooltip page with a product bar chart, connect it to the city chart, and hover over Pune to see Laptop 200K, Mobile 105K, Smartwatch 25K and Headphones 16K.Start the lab →
- Power BI · Chapter 19Make a Chart/Table Toggle with Bookmarks, the Selection Pane and ButtonsStack a bar chart and a table in one spot, hide one with the Selection pane, save two bookmarks with Data turned off, and switch between them with two buttons.Start the lab →
- Power BI · Chapter 20Colour Bars Red or Green with a DAX Measure and Write a Dynamic TitleCompare each city with its target, colour the bars with a DAX colour measure (green if met, red if not), and make the title say "2 of 4 cities below target" by itself.Start the lab →
- Power BI · Chapter 21Switch the Chart's Measure with a Field Parameter and Add a Top N SelectorLet users pick Sales, Profit or Units for one chart with a field parameter, then add a numeric-range parameter and a RANKX measure so a slider decides how many cities to show.Start the lab →
- Power BI · Chapter 22Add Date, City and Product Slicers and Sync Them Across Two PagesAdd a date range, city and product slicer to an Overview page, sync Date and City to a Products page with the Sync slicers pane, and see what a hidden synced slicer does.Start the lab →
- Power BI · Chapter 23Redesign a Cluttered Report Page with the 5-Second RuleBuild a deliberately messy 11-visual page, list its 7 problems, then rebuild it as 3 KPIs, 2 charts and a small table that answer the main question in 5 seconds.Start the lab →
- Power BI · Chapter 24Build a One-Page Sales Report with KPIs, a Trend and a BreakdownTurn a five-question brief into one finished page: four KPI cards, a monthly trend, a product breakdown, a red/green city chart, a Year slicer and a phone layout.Start the lab →
- Power BI · Chapter 25Publish a Report to the Power BI Service, Pin Visuals to a Dashboard and Schedule a RefreshBuild a small report on a published Google Sheet (no gateway needed), publish it to My workspace, pin three tiles to a dashboard and set a daily 9 AM IST refresh.Start the lab →
- Power BI · Chapter 26Add Row-Level Security So Each City Manager Sees Only Their City, and Test It with View AsCreate a dynamic RLS role with USERPRINCIPALNAME() on the city table, test it with View as pune.manager@example.com, and compare it with a static Pune-only role.Start the lab →
- Power BI · Chapter 27Find the Slowest Visual with Performance Analyzer and Make It FasterPlant a deliberately heavy measure, record the page with Performance Analyzer, read DAX query vs Visual display times, find the culprit and fix it.Start the lab →
- Power BI · Chapter 28Mini Project – Build a Quick-Commerce Dashboard from Raw CSV to Published ReportTake 60 sample quick-commerce orders from four Pune dark stores, clean them, write 7 measures, build a KPI row, a store table and an hourly chart, and write 3 insights.Start the lab →
- Power BI · Chapter 29Timed Practice – Build a 3-Visual Report from a New Dataset in 45 MinutesStart a 45-minute timer, load 40 sample food orders you have never seen, build a card, a city bar and a cuisine column chart, then score yourself with the answer key.Start the lab →
- Power BI · Chapter 30Explain Your CALCULATE Measure and Filter Context Aloud in 2 MinutesUse your Mumbai Sales measure from Lab D, prepare a 5-part answer, record yourself on your phone for 2 minutes and score the recording with a checklist.Start the lab →
- Power BI · Chapter 31Solve 5 Interview-Style DAX Tasks on the Sample File and Check the AnswersFixed-year sales, % of total, product rank, year-to-date and last-year comparison: five DAX tasks MNC interviewers ask, each with an exact number to check.Start the lab →
- Power BI · Chapter 32Speed Drill – Rebuild the First Bar-Chart Lab Using Keyboard ShortcutsTime yourself rebuilding the Lab C bar chart with the mouse, then again keyboard-first with KeyTips, Ctrl+F6, Alt+Shift+F10 and the DAX formula-bar shortcuts.Start the lab →
- Power BI · Chapter 33Glossary Match-Up – 25 Power BI Terms with Your Own One-Line ExamplesMatch 25 Power BI terms to shuffled meanings in a spreadsheet, score yourself with one formula, then write a one-line example for each term from your own labs.Start the lab →
- Power BI · Chapter 35Pick a Project Brief and Write Its KPI List, Data-Model Sketch and Page PlanRead a Pune hospital's brief, write 4 KPIs with exact definitions, sketch a star schema, plan two pages and a phone layout, and list the data gaps before building anything.Start the lab →
- Power BI · Chapter 36Build a 4-KPI Card Row for One Industry (Hospital) from Sample DataLoad 40 sample hospital visits and build four cards: visits, average OPD wait, average bill and 30-day readmission %, with the right DAX for blanks and percentages.Start the lab →
Excel labs 0 ready · 31 coming soon
Labs for the Excel course are being written. Here is the plan, one lab per chapter:
- Chapter 1Coming soonCreate, save and format your first monthly expense sheet
- Chapter 2Coming soonBuild a clean data-entry sheet with drop-down lists (Data Validation) and Flash Fill
- Chapter 3Coming soonWrite SUM, AVERAGE, IF and absolute references ($) on a marks sheet
- Chapter 4Coming soonFind prices with XLOOKUP and VLOOKUP exact match, and handle #N/A
- Chapter 5Coming soonClean a messy customer list: TRIM, PROPER, Remove Duplicates and Text to Columns
- Chapter 6Coming soonTurn a range into an Excel Table, then sort and filter sales by city and date
Show all 31 planned Excel labs
- Chapter 7Coming soonBuild your first PivotTable and PivotChart: sales by city and product
- Chapter 8Coming soonMake a column, a line and a combo chart and format them for a report
- Chapter 9Coming soonUse FILTER, SORT and UNIQUE to build a live city report
- Chapter 10Coming soonImport and clean a CSV with Power Query, then refresh it with new data
- Chapter 11Coming soonFind the price needed for a target profit with Goal Seek and compare three scenarios
- Chapter 12Coming soonRecord a formatting macro, read its VBA code and run it from a button
- Chapter 13Coming soonBuild a one-page Excel dashboard with one slicer connected to two PivotTables
- Chapter 14Coming soonLock formula cells, protect the sheet and set up a clean print layout
- Chapter 15Coming soonMonthly report project: from raw data to a printable summary
- Chapter 16Coming soonTimed practice: 10 Excel tasks in 30 minutes with an answer key
- Chapter 17Coming soonExplain XLOOKUP vs VLOOKUP and PivotTables aloud with a live demo
- Chapter 18Coming soonSolve 5 interview-style Excel tasks on a sample file
- Chapter 19Coming soonShortcut drill: finish a cleaning task without touching the mouse
- Chapter 20Coming soonGlossary flashcards: 25 Excel terms with your own examples
- Chapter 21Coming soonPick one project brief and plan its sheets, formulas and charts
- Chapter 22Coming soonWrite KPI formulas (growth %, margin %, average order value) for one industry
- Chapter 23Coming soonSummarise three monthly sheets into one with 3-D SUM and links to another workbook
- Chapter 24Coming soonRelate two tables in the Data Model and write your first DAX measure in Excel
- Chapter 25Coming soonBuild your personal top-20 shortcut list for Windows or Mac and test it
- Chapter 26Coming soonTry 10 analyst tricks on one sheet: Go To Special, custom number formats and more
- Chapter 27Coming soonRebuild one industry template from scratch and compare it with the ready-made one
- Chapter 28Coming soonAsk Copilot for three formulas, then check each answer by hand
- Chapter 29Coming soonRun your first =PY() cell: a pandas summary of a sales table in Excel
- Chapter 30Coming soonDescribe a dataset with AVERAGE, MEDIAN, STDEV.S and a histogram
- Chapter 31Coming soonForecast the next 3 months with FORECAST.ETS and Forecast Sheet
AWS Cloud labs 0 ready · 27 coming soon
Labs for the AWS Cloud course are being written. Here is the plan, one lab per chapter:
- Classroom chapterComing soonFind the IP address, gateway and public IP of your laptop and your phone
- Classroom chapterComing soonOpen a page on 127.0.0.1 and list which ports your laptop is using
- Classroom chapterComing soonExplore Regions and Availability Zones in the console and choose a region for Mumbai users
- Classroom chapterComing soonLock the root user with MFA, create an IAM admin user and launch your first EC2
- Classroom chapterComing soonStop, start and reboot your EC2 and note what changes (public IP, EBS, ENI)
- Classroom chapterComing soonBuild a folder tree from a picture using pwd, ls, cd and mkdir
Show all 27 planned AWS labs
- Classroom chapterComing soonCreate and edit files with touch, cat, nano and vi
- Classroom chapterComing soonCopy files and folders with cp, cp -r, wildcards and brace ranges
- Classroom chapterComing soonRename, move and safely delete with mv, rm and rmdir, and find hidden files
- Chapter 1Coming soonTrace a website request from your laptop with ping, nslookup and traceroute
- Chapter 2Coming soonMatch real commands and tools to each OSI layer on a worksheet
- Chapter 3Coming soon20-command Linux warm-up on your EC2 server
- Chapter 4Coming soonFind, filter and archive logs with grep, find, tar and pipes
- Chapter 5Coming soonLaunch, connect over SSH and safely terminate an EC2 instance on the free tier
- Chapter 6Coming soonInstall Nginx and Apache on two servers and compare their config files
- Chapter 7Coming soonHost a static website on EC2 with Nginx and open it from your phone
- Chapter 8Coming soonChange the port, root folder and index file, then fix the 403 and 404 you create on purpose
- Chapter 9Coming soonPoint a domain and a subdomain to your EC2 with A and CNAME records
- Chapter 10Coming soonHost a PHP page on EC2 that reads from a MySQL database
- Chapter 11Coming soonDeploy a Flask app behind Nginx as a systemd service
- Chapter 12Coming soonBuild a LEMP stack on one EC2 instance step by step
- Chapter 13Coming soonAttach, format and mount a new EBS volume, then grow it without downtime
- Chapter 14Coming soonAttach an Elastic IP, create an AMI and a snapshot, and resize the instance
- Chapter 15Coming soonBuild a VPC with public and private subnets and reach the private server through a bastion host
- Chapter 16Coming soonCreate a private RDS MySQL database and connect to it only from EC2
- Chapter 17Coming soonCreate an Auto Scaling group that adds a server when CPU is high
- Chapter 18Coming soonPut an Application Load Balancer in front of two EC2 servers and watch it share traffic
DevSecOps labs 0 ready · 39 coming soon
Labs for the DevSecOps course are being written. Here is the plan, one lab per chapter:
- Chapter 1Coming soonMap one app's journey from code to production and mark where each security check fits
- Chapter 2Coming soonMeasure three golden metrics (lead time, MTTR, open vulnerabilities) for a sample repo
- Chapter 3Coming soonThreat-model a login page with STRIDE on one sheet of paper
- Chapter 4Coming soonFix three OWASP Top 10 issues in a small intentionally vulnerable training app
- Chapter 5Coming soonReview a pull request with a security checklist and suggest fixes
- Chapter 6Coming soonProtect a GitHub repo: branch protection, signed commits and secret scanning
Show all 39 planned DevSecOps labs
- Chapter 7Coming soonRecap lab: secure a tiny repo end to end using Chapters 1 to 6
- Chapter 8Coming soonHarden a Linux VM with a CIS-style checklist and record before and after scores
- Chapter 9Coming soonLock down security groups and NACLs for a 2-tier app and test what is blocked
- Chapter 10Coming soonMove a hard-coded secret into a secrets manager and rotate it
- Chapter 11Coming soonUse least-privilege tokens and pinned actions in a GitHub Actions pipeline
- Chapter 12Coming soonAdd SAST and dependency scanning to a pipeline and fix the first finding
- Chapter 13Coming soonGenerate an SBOM for a sample app and check it for known vulnerable packages
- Chapter 14Coming soonShrink and harden a Docker image: non-root user, small base image and an image scan
- Chapter 15Coming soonApply Pod Security Standards and a NetworkPolicy in a local kind cluster
- Chapter 16Coming soonScan Terraform code for misconfigurations and fix a public S3 bucket
- Chapter 17Coming soonTurn on CloudTrail, threat detection and a public-bucket check in a sandbox AWS account
- Chapter 18Coming soonReplace long-lived access keys with an IAM role for an app on EC2
- Chapter 19Coming soonAdd MFA and short-lived sessions to a sample login and test the policy
- Chapter 20Coming soonAdd authentication, rate limits and input validation to a small API
- Chapter 21Coming soonWatch container runtime events with Falco and trigger a safe test alert
- Chapter 22Coming soonSend app logs to a free log stack and write one detection rule
- Chapter 23Coming soonTabletop incident drill: leaked key, contain, rotate and write the timeline
- Chapter 24Coming soonAutomate one compliance check (encryption at rest) and produce an audit report
- Chapter 25Coming soonTriage 10 scanner findings by severity and exposure, and patch the top 3
- Chapter 26Coming soonCreate a secure "golden path" template repo with checks built in
- Chapter 27Coming soonWrite an SLO and a security error budget for a sample service
- Chapter 28Coming soonEncrypt a database at rest and in transit and restrict who can connect
- Chapter 29Coming soonGive a Lambda function least-privilege permissions and safely stored secrets
- Chapter 30Coming soonCheck a sample Android app for hard-coded secrets and insecure local storage
- Chapter 31Coming soonTest a sample chatbot against prompt-injection examples and add guardrails
- Chapter 32Coming soonDeploy with Argo CD from Git and block an unsigned image
- Chapter 33Coming soonDraw a reference architecture for a 3-tier app with security zones
- Chapter 34Coming soonSafe purple-team check: simulate one known technique in a lab and confirm the alert fires
- Chapter 35Coming soonScore a team on a DevSecOps maturity model and pick the next 3 improvements
- Chapter 36Coming soonDebug a failing security gate in CI from the logs to the fix
- Chapter 37Coming soonCompare two free scanners on the same repo and choose one with reasons
- Chapter 38Coming soonCapstone: one small app from commit to production with every security gate green
- Chapter 39Coming soonExplain your capstone pipeline in a 5-minute mock interview
Data Science labs 0 ready · 20 coming soon
Labs for the Data Science course are being written. Here is the plan, one lab per chapter:
- Chapter 1Coming soonSort 10 real business questions into analytics tasks and data science tasks
- Chapter 2Coming soonInstall Python and Jupyter, create a virtual environment and run your first notebook
- Chapter 3Coming soonWrite 10 small Python snippets on a sales list: loops, if and functions
- Chapter 4Coming soonCompute totals, averages and percentages on a NumPy array of daily sales
- Chapter 5Coming soonLoad city_sales.csv into pandas and explore it with head, info and describe
- Chapter 6Coming soonFilter the Mumbai rows and sort by sales with loc and sort_values
Show all 20 planned Data Science labs
- Chapter 7Coming soonTotal sales by city and product with groupby and agg
- Chapter 8Coming soonMerge a sales table with a city-region table and stack two months with concat
- Chapter 9Coming soonClean a messy dataset: missing values, duplicates and wrong data types
- Chapter 10Coming soonParse dates, convert UTC to IST and clean product names
- Chapter 11Coming soonTurn wide monthly data into long format with melt, and back with pivot_table
- Chapter 12Coming soonDo a 10-question EDA on a sample dataset and write 3 findings
- Chapter 13Coming soonDraw a bar chart, a line chart and a histogram with matplotlib and label them properly
- Chapter 14Coming soonMake a box plot and a heatmap with seaborn and explain what each shows
- Chapter 15Coming soonTurn a confusing chart into a clear one and write its story in 3 lines
- Chapter 16Coming soonMini project: a quick-commerce dataset from raw CSV to 5 charts and a summary
- Chapter 17Coming soonTimed practice: 10 pandas tasks in 40 minutes with hints
- Chapter 18Coming soonSolve 5 interview-style pandas questions and explain your code aloud
- Chapter 19Coming soonBuild your own pandas cheat sheet and test every line in Jupyter
- Chapter 20Coming soonGlossary flashcards: 25 data science terms with examples
Cyber security labs are defensive: you protect your own accounts, laptop and practice servers, and any testing happens only on intentionally vulnerable training apps inside your own isolated lab.