Ravindra BagaleCourses & study guides Track your progress

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

Show all 50 ready Cyber Security labs

    Open the Cyber Security course →

    Power BI labs 35 ready · 0 coming soon

    Show all 35 ready Power BI labs

      Open the Power BI course →

      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

      Open the Excel course →

      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

      Open the AWS Cloud course →

      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

      Open the DevSecOps course →

      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

      Open the Data Science course →

      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.