Skip to main content
Main menu
Includes navigation links and user settings
Browse products
Sign up
Log in
Cohort 147 - (Da/Ds/GenAI - DK)
Course content
26 sections | 50 lessons
Expand all sections
Link , Passcode & Updates
1 Lessons
26th April
2 Lessons
2nd May
2 Lessons
3rd May
2 Lessons
1. Introduction to Data Analytics 2. Introduction to Python
2 Lessons
1. IDE installation 2. Basic Programming with Python
2 Lessons
1. Data types in Python 2. Basic data entry in excel with - custom list, datedif, countif, if-else
2 Lessons
1. Excel analytics: Dashboard, Pivot table, Charts, Vlookup, XLookup 2. Python: f-string
2 Lessons
1. Excel case study, assignment 1 2. Python: Different operators in Python, Introduction to Conditions (if elif else)
2 Lessons
1. Conditions in Python: if elif else 2. Nested conditions 3. Loops introduction in Python 4. Program using For loop and While loop
2 Lessons
30th May
1 Lessons
31st May
2 Lessons
1. Dictionary in Python 2. Sets in Python 3. Introduction to Functions in Python
2 Lessons
Entire Functions tutorial: Arguments, types of arguments, return values, doc string. examples
2 Lessons
1. Class and Objects in Python 2. Exception handling in Python 3. Database introduction
2 Lessons
Database design: ER Diagram, understanding different types of relationships
2 Lessons
1. DDL Statements: Create, Alter, Drop, Rename - Tables 2. DML: Insert and Update tables
2 Lessons
Multiple inserts 2. insert by importing using Import wizard and import query 3. Select: Distinct, where, Like, In, Between, Order By 4. Limit 5. Sub query
2 Lessons
1. Aggregate Functions 2. Group By 3. Order By 4. Having 5. Limit & Offset 6. Joins
2 Lessons
1. DML - Update, Delete 2. DDL: Truncate 3. Windows Functions in MYSQL 4. Normalization 5. Dimensional Modelling 6. Data Analysis and Data Wrangling 7. Database Admin 8. Describe and Show commands 9. Assignments - Python and SQL Assignment 2 10. Projects to Practice
2 Lessons
1. SQL: Temporary table, VIEWS, Stored Procedures 2. Statics: Types of data, Descriptive Stats (Measure of central tendency & Measure of variability)
2 Lessons
1. Analyzing Univariate and Bivariate data 2. Visualization: Histogram, Scatter plot
2 Lessons
Bivariate analysis text test Chi Square test
2 Lessons
1. statistical tests 2. Skewness 3, Kurtosis 4. Errors
2 Lessons
1. Probability Distribution 2. Intro to Numpy
2 Lessons
1. Numpy: complete tutorial 2. Mini Project
2 Lessons
₹100,000
one-time purchase
Buy now