Skip to main content
Main menu
Includes navigation links and user settings
Browse products
Sign up
Log in
Cohort 122 - (Da/Ds/GenAi - VC)
₹100,000
one-time purchase
Buy now
Course content
25 sections | 45 lessons
Expand all sections
Link, Passcode & Updates Section
1 Lessons
What is analytics ? A) Introduction to data qnalytics B) Types of analytics C) Scope and role of analytics in business. D) Fundamentals of data
2 Lessons
Basics of Excel - A) Introduction to Excel B) Datatypes in excel C) Basic analysis logical aptitude. D) Fundamentals analysis.
1 Lessons
3)Basics of Excel ? A) Formatting to Excel B) Functions in excel C) Data cleaning in Excel.
2 Lessons
Excel advanced functions and project. a) Beginner end to end excel project with dashboard. b) Advances excel functions. c) SUMIF,SUMIFS,COUNTIF,COUNTIFS,Pivot charts d) Dashboard creation in excel.
2 Lessons
1) Basics of SQL 2) Need of SQL
1 Lessons
1]Basic intuition and understanding of querying data and its applications. 2) Select , aggregate functions, group by , order by , where, comparison operators, Cast, Replace , Round , Floor , ceil.
1 Lessons
SQL functions
1 Lessons
10th May
1 Lessons
11th May
1 Lessons
1. Database basics 2. Excel basics for Excel project
2 Lessons
1. Excel Project - part 2 2. Database design (Relationships, Normalization, ER Diagram)
2 Lessons
1. Create database 2. Create table 3. Alter Table
2 Lessons
1. Add data to table: INSERT, LOAD FILE, using UI 2. Delete and Truncate data 3. Update existing data in the table 4. Basic Select statement
2 Lessons
WHERE Clause in SQL Query: Logical, Relational, BETWEEN, IN, LIKE
2 Lessons
1. Project 2 (SQL Project 1) 2. JOINS - complete tutorial 3. Aggregate Functions 4. Having 5. Group By 6. Order By
2 Lessons
1. Triggers 2. Views 3. Temporary Tables 4. Indexes 5. Windows functions in SQL
4 Lessons
1. Introduction to programming 2. Introduction to algorithms 3. Python installation
2 Lessons
1. Python basics 2. f string 3. variables 4. data types
2 Lessons
1. Escape sequence 2. end command in Python 3. Input() 4. Operations (Arithmetic operators & Relational operators)
2 Lessons
1. Logical operators 2. Membership operators 3. Conditions in Python 4. Nested conditions in Python
2 Lessons
1. Examples in IF Condition 2. Loops discussion 3. For loop explanation and examples 4. While loop explanation
2 Lessons
Practice examples based on Conditions and loops in Python
2 Lessons
1. Wrapping up loops and condition 2. Match Case 3. Strings in Python
2 Lessons
1. String (finishing) 2. List 3. Tuple 4. Dictionary (start)
2 Lessons
