arrow_back अभ्यास
Phase 2 • Week 06

SQL foundations, Arrays FAQs finish, The Data Toolkit

verified_user

Weekly Production Deliverable

Target Output
Deliverable: Arrays fully done. The Data Toolkit (NumPy/Pandas/Matplotlib/Seaborn) done; Kaggle account live; second GitHub project (EDA) shipped.
Weeks: W06 Active W07 W08 W09 W10

Monday

0 / 2 done
DSA Sort an array of 0s, 1s and 2s; Kadane's Algorithm
1.5h
AI/ML NumPy Mastery
Keith Galli's NumPy tutorial (YouTube): arrays, multi-dimensional indexing, broadcasting, mathematical operations, vectorization
2.5h

Tuesday

0 / 2 done
DSA Next Permutation
1.5h
CORE SQL Foundations
Intro to SQL, Why SQL Exists, How Databases Work, DDL vs DML, Database & Table Basics, Data Types, Constraints (Primary/Foreign Key, Unique, Check, Default)
2.5h

Wednesday

0 / 2 done
DSA Majority Element-II
1.5h
AI/ML Pandas Mastery
Keith Galli's Pandas tutorial: Series, DataFrames, CSV reading, boolean indexing, filtering rows, groupby, aggregations, merge, handling missing data
2.5h

Thursday

0 / 2 done
DSA Find the repeating and missing number
1.5h
CORE Query Fundamentals & Practice
SELECT, FROM, WHERE, operators, ORDER BY, LIMIT, DISTINCT, AS + TRIM() / LTRIM() / RTRIM() + Quiz + solve: Large Nations, Profitable Customers, Available Seat Streaks, Email Duplicates, Odd Non-Boring Movies, Exceeding Tweet Length
2.5h

Friday

0 / 2 done
DSA Count Inversions; Reverse Pairs
1.5h
AI/ML Data Visualization & First Kaggle EDA Project
Matplotlib & Seaborn crash course (freeCodeCamp YouTube) + set up Kaggle account + perform full Exploratory Data Analysis (EDA) on a real dataset (e.g. Titanic) + push notebook with README to GitHub
2.5h
Weekend High-Load Execution • 8.0h Daily Deep Focus Lab

Saturday

0 / 3 done
DSA Maximum Product Subarray; Merge two sorted arrays without extra space
1.5h
AI/ML NumPy & Pandas Intensive Lab (4.0h)
Kaggle Learn "Python" & "Pandas" micro-courses (earn certificates); complete 20 vector manipulation exercises in Jupyter notebook.
4.0h
APT Quant M6 & Verbal
Quant M6 Trains, Boats and Streams (Basic & Advance) + Verbal: Idioms and Phrases (Basic & Advance)
2.5h

Sunday

0 / 3 done
DSA Revision + Contest
redo 3 array problems cold
1.5h
AI/ML Kaggle Titanic End-to-End EDA Lab (4.0h)
Kaggle Learn "Data Visualization" certificate; perform comprehensive EDA on Titanic dataset with seaborn/matplotlib; submit first Kaggle notebook.
4.0h
APT Logical & SQL Query Practice
Logical: Syllogism (Basic & Advance) + Filtering Essentials (IS NULL, IN, BETWEEN, LIKE) + solve: Non-Referred Customers, Employee Work Time Summary
2.5h
edit_note

Week 06 Technical Notes & Journal

#LeetCode #Java #DSA #Week06