Data Science Immersive Bootcamp Program - Flex

Welcome to the Data Science Immersive Bootcamp Program - a job guaranteed training program. You will get access to learning modules in this course along with all the other features such as on-demand 1:1 mentorship, weekly doubt clearing sessions and placement services.

Highlights of the Program

  • 100% Job Guarantee*

  • Learning Modules with flexible learning

  • On Demand 1:1 Mentorships with Industry Practitioners

  • 12+ Tools

  • 20+ Projects

  • * For 100% Job Guarantee Terms and Conditions click here

Course curriculum

  • 1
    Welcome To Bootcamp Flex
    • Bootcamp Vision and Ideology
    • Introduction to Bootcamp Flex
    • How will your journey look like?
    • Job Guarantee and Placement Services
  • 2
    Week 1 - Excel
    • Introduction FREE PREVIEW
    • Course Overview FREE PREVIEW
    • Excel Installation FREE PREVIEW
    • Practice Datasets
    • Excel Interface
    • Keyboard shortcuts
    • Setting Printing Area
    • Excel Basics Exercise
    • Excel Bonus
    • Excel Basic Formatting
    • Basic Formating Exercise
    • Select, Cut, Copy, Paste
    • Autofill, Find and Search
    • Insert & Delete
    • Auto Fill Exercise
    • Sheet Operations
    • Sheet Operations Exercise
    • Getting Started with Excel Formulas
    • Referencing
    • Referencing Exercise
    • Paste Special & Format Painter
    • Copy Paste function Exercise
    • DateTime Function
    • Date Time Exercise
    • Left,Right,Mid,Len,Concatenate
    • TEXTJOIN
    • Find & Search
    • Find & Search Exercise
    • Replace & Substitute
    • Text and Value
    • Sum, Product, Mod, Sqrt, Fact
    • Round, RoundUp, Rounddown, SumIFS
    • MAXIFS
    • MINIFS
    • Mathematical Function Exercise
    • Present Value and Future Value
    • NPV and IRR
    • Financial Functions in Excel
    • Financial Function Exercise
    • Vlookup and Hlookup
    • Match
    • Index
    • Lookup Funciton Exercise
    • AND, OR, NOT, ISERROR, ISNUMBER, ISBLANK, ISTEST
    • IF, IFERROR
    • IFS
    • Logical Function Exercise
    • Hide & Unhide
    • Weekly Doubt Clearing Session
  • 3
    Week 2 - Excel
    • Week-2: Introduction
    • Count, Counta, Countblank, Countifs
    • Mean, Median, Mode, Std, Rank, Quartiles, Corr
    • Statistical Function Exercise
    • Sort
    • Filter
    • Sort Fillter Exercise
    • Advanced Filter
    • Filter With One Condition
    • Filter with AND and OR operators
    • Advance Filter Exercise
    • Pivot Table I
    • Pivot Table II
    • Hide and Show Grand Totals
    • Sorting Rows and Columns
    • Calculated Fields
    • Auto Width Disable
    • Difference From Previous Value
    • Make Pivot Tables Dynamic
    • Slicers
    • Timeline Slicer
    • Pivot Table Exercise
    • Getting Started with Excel Charts
    • Components of Charts
    • How to Create a Chart
    • Column Chart in Excel
    • Bar Chart in Excel
    • Line Chart in Excel
    • Area Chart in Excel
    • Pie Chart in Excel
    • Scatter Chart in Excel
    • Data Visualisation Exercise
    • Bubble Chart in Excel
    • Dual Axis Chart in Excel
    • How to Choose Charts
    • Sparklines in Excel
    • Waterfall Chart in Excel
    • Advance Charts Exercise
    • Highlight Cells Rules
    • Top-Bottom Rules, Multiple Cells And Heatmaps
    • Duplicate and Unique Values
    • Unique Function
    • Unique with Filter
    • Case Sensitivity of Unique Function
    • Unique With All Parameters
    • What Is Spill
    • Goal-Seek and Solver
    • Scenario Manager
    • Data Tables
    • What IF Exercise
    • Data Validation
    • Data Validation Exercise
    • Protecting Cell, Sheet, Workbook
    • Data Validation II Exercise
    • Hyperlink
    • Hyperlink Exercise
    • Text to Column
    • Excel vs. Google Sheets
    • Understanding the Problem Statement
    • Simulation Sample Sheet
    • A Look at the Data
    • Formulating the Framework - Business Understanding
    • Breaking Down the Framework
    • Yearly Business Prediction
    • Month-Wise Business Forecast
    • Adding Flexibility to our Simulation
    • Performing Simulation in Excel!
    • Simulation Assignment
    • Weekly Doubt Clearing Session
  • 4
    Week 3 - Power BI
    • Introduction to the course
    • Course Handout
    • What is Business Intelligence?
    • Components of BI
    • Quiz: Business Intelligence
    • What is Power BI?
    • Installation of Power BI
    • Introduction to Power BI Interface
    • Understanding the problem statement
    • Importing Data in Power BI
    • Data View and Formatting the Columns
    • Building your first Power BI Report
    • Chart Formatting and Other Visuals
    • Uploading Reports to Power BI Service
    • Quiz: Power BI Basics
    • What is Data Modeling?
    • Relationships and Cardinality
    • Creating Calculated Columns
    • Building Reports with Multiple Tables
    • Introduction to Measures
    • Creating our first Measure
    • Using Measures to perform row-by-row operations
    • CALCULATE Function to create Measures
    • Time Intelligence Functions
    • Creating Reports with Measures
    • Quiz: DAX
    • Filters in Power BI Reports
    • Hierarchy and Drill modes
    • Quiz: Filter and Slicers
    • Introduction to Parameters
    • Parameters in Power BI
    • Data Storytelling
    • Shapes and Buttons
    • Managing Roles and RLS
    • Power BI Gateway for Data Refresh
  • 5
    Week 5 - SQL
    • Course Overview
    • Course Handout
    • Week-5: Introduction
    • Why do we need databases
    • What is a database
    • Some properties of a good Database
    • Types of Databases
    • How data is Stored in Relational Databases
    • ACID Properties of Relational Databases
    • Companies using MySQL
    • Quiz - Introduction to Databases
    • Architecture - Client and Server
    • MySQL Distributions
    • Local Installation on Mac
    • Local Installation on Linux
    • Local Installation on Windows
    • Quiz - Installing MySQL
    • Getting Started with SQL
    • What is SQL
    • Connecting to MySQL on Windows
    • Connecting to MySQL on Linux
    • Connecting to MySQL on Mac
    • Exploring Databases
    • Creating a Table
    • Datatypes in MySQL
    • Describe Command
    • Describing Tables
    • Insert Command
    • Inserting Records
    • Retrieving Records
    • NULL vs NOT NULL
    • Dealing with NULL values
    • Quiz - Getting Started with SQL
    • Update Command
    • Updating Records
    • Delete Command
    • Deleting Records
    • Alter Command
    • Altering Table Structure
    • Drop Table
    • Dropping Table
    • Quiz - Modifying Table Structure
    • Importing data from CSV to MySQL
    • Counting Records
    • Aggregation Functions
    • Extreme Values Identification
    • Quiz - Basic Querying 1
    • Slicing Data
    • Limiting Data
    • Sorting Data
    • Quiz - Basic Querying 2
    • Pattern Matching
    • Quiz - Basic Querying 3
    • Grouping Records
    • Filtering in Groups
    • Quiz - Basic Querying 4
    • Exporting data from MySQL to CSV
    • Backing up Databases
    • Restoring Databases
    • Importing and Exporting Datasets Troubleshooting Guide
    • Quiz - Importing and Exporting data in MySQL
    • Description Analytics of FIFA 19 Players
    • Data Eyeballing
    • Data Dictionary
    • Questions we need answers of
    • Analyzing data and creating table structure
    • Loading data to our MySQL table
    • Data Analysis – Simple Queries
    • Data Analysis – Advanced Queries
    • FIFA19 Players Dataset
    • String Concatenation
    • String Case Conversion
    • Trimming Strings
    • Extracting Substrings
    • Understanding RegEx
    • Matching String patterns with RegEx
    • Current Date and Time
    • Extracting Date and Time
    • Formatting Date and Time as Strings
    • Numeric functions
    • Conditional Flow
    • Writing Conditional Statements
    • SQL CheatSheet
    • Quiz - MySQL built-in functions
    • Why we need Subqueries
    • What are Subqueries
    • Types of Subqueries
    • Implementing Subquery
    • Quiz - Subqueries
    • Weekly Doubt Clearing Session
  • 6
    Week 6 - SQL
    • Week-6: Introduction
    • What are Constraints
    • Domain Constraint
    • NOT NULL Constraint
    • DEFAULT Constraint
    • Adding NOT NULL and DEFAULT Constraints
    • UNIQUE Constraint
    • CHECK Constraint
    • Adding UNIQUE and CHECK Constraints
    • Key Constraint
    • Implementing KEYS in SQL
    • Quiz - Constraints in SQL
    • Working with multiple tables
    • What is Foreign Key
    • Types of Relationships
    • Quiz - Working with Multiple Tables
    • Movie TIcket Project Dataset
    • Joins Overview
    • Inner Join
    • Implementing Inner Join
    • Left Join
    • Implementing Left Join
    • Right Join
    • Implementing Right Join
    • UNION Clause
    • Full Outer Join
    • Implementing Full Outer Join
    • Cross Join
    • Implementing Cross Join
    • Self Join
    • Implementing Self Join
    • Multiple Tables with Sub-queries
    • Quiz - Joins