### 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

### 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
• Filter With One Condition
• Filter with AND and OR operators
• 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
• 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
• Text to Column
• Understanding the Problem Statement
• Simulation Sample Sheet
• A Look at the Data
• Formulating the Framework - Business Understanding
• Breaking Down the Framework
• 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
• Components of BI
• 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
• 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
• 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