dots bg

DSCUS-24JUN23

Course Instructors Dataisgood Kunal Bhardwaj

FREE

dots bg

Course Overview

Schedule of Classes

Course Curriculum

1 Subject

DSCUS-24JUN23

15 Exercises • 50 Learning Materials

PYTHON (SEMESTER 1)

L1: Introduction to Python and Data Science

ZIP

L1: Introduction to Python and Data Science (DPP)

Exercise

L2: Working with Python Data Structures

ZIP

L2: Working with Python Data Structures (DPP)

Exercise

L3: Control Flow Statements

ZIP

L3: Control Flow Statements (DPP)

Exercise

L4: Functions in Python

ZIP

L4: Functions in Python (DPP)

Exercise

L5: File Handling in Python

ZIP

L5: File Handling in Python (DPP)

Exercise

L6: Regular Expressions

ZIP

L6: Regular Expressions (DPP)

Exercise

L7: Object Oriented Programming

Audio

L7: Object Oriented Programming (DPP)

Exercise

L8: Advance Data Structures

ZIP

L8: Advance Data Structures (DPP)

Exercise

Exploring_hacker_news

ZIP

Chicago Census Data File

ZIP

SQL (SEMESTER 1)

SQL File

PDF

SQL PPT-2

PDF

L1: Introduction to SQL and MySQL installation

ZIP

L1 Introduction to SQL and MySQL installation (Daily Practice Problem)

Exercise

L2: Data Creation and Retrieval

ZIP

L2 Data Creation and Retrieval (Daily Practice Problem)

Exercise

L3: Data Filtering

ZIP

L3: Data Filtering (Daily Practice Problem)

Exercise

L4: Data Analysis using aggregate functions and group by

ZIP

L4: Data Analysis using aggregate functions and group by (Daily Practice Problem)

Exercise

L5: Joins and Keys (Daily Practice Problem)

Exercise

L6: Subqueries and Views

ZIP

L6: Subqueries and Views (Daily Practice Problems)

Exercise

L7: Window/Analytical Functions

ZIP

L7: Window/Analytical Functions

Exercise

Case Study

PDF

L5: Joins and Keys

ZIP

Supercar sql file

ZIP

Tik-tok Database

ZIP

Data salary file

ZIP

SQL Cheat Sheet

PDF

Class Notes

L1_python_operators

ZIP

L2-Python_Data_Structures

ZIP

L4_python_functions

ZIP

L5_module_file_handling

ZIP

L6_regular_expression

ZIP

PY201_L8_Project

ZIP

L2: Data Creation and Retrieval

ZIP

storedProcedures_and_interview_questions

ZIP

Excel Dashboard

Audio

Excel_completed_dashboard

Audio

Excel Assignment

Audio

Statistics Presentation

PDF

SP101 Workbook Datasets

Audio

Stats Variance Stdev Jupyter Notebook

ZIP

stdev variance class notes (excel)

Audio

Hypothesis Testing

PDF

Missing Data Handling

ZIP

Marketing Data FE

ZIP

Day 5: Feature Extraction and Transformation

ZIP

Day 6: Feature Selection and Dimensionality Reduction

ZIP

DIG Books

PY-201 Python Fundamentals

PDF

SQL-103

PDF

EXL-301

PDF

SP101 Statistics & Probability

PDF

Stats Workbook

PDF

Assignment

Assignment

ZIP

Course Instructor

tutor image

Dataisgood

478 Courses   •   210448 Students


tutor image

Kunal Bhardwaj