Class 01 – SQL Main Clauses | Order of Execution | Commenting Queries | AS & TOPN Keywords
0/1
Class 02 – TOPN PERCENT | Aggregate Functions (Basic) | Numeric Functions (Basic) | DISTINCT | Date Functions | Text Functions (Basic)
0/1
Class 03 – Text Functions (Advance) | DECLARE, NVARCHAR, SET | Conditional Functions (Basic)
0/1
Class 04 – Conditional Functions (Advance) | CAST Function
0/1
Class 05 – SQL Theory (DBMS vs RDBMS, SQL Server, Instances, Databases, Data Security) | Data Normalization | Fact vs Dimension Tables | Relationships & Keys | Star vs Snowflake Schema | ER Diagrams | JOINS Theory
0/1
Class 06 – SQL JOINS | VIEWS | UNION & UNION ALL | Subqueries | Common Table Expression | CRUD Operations (INSERT, UPDATE, DELETE) | Window Functions
0/1
Class 07 – Python Basics (Punctuations, Operators, Brackets, Logical & Comparison) | Syntax & Semantics | Conditional Statements | Variables | Common Errors & Examples
0/1
Class 08 – Python Data Structures – Lists (Create, Access, Modify) | List Methods (Insert, Remove, Pop, Random, Append)
0/1
Class 09 – Python Data Types | Advanced Data Types | Operators | Conditional Statements | Practical – Employee Bonus Calculator
0/1
Class 10 – Python Loops | Iterating | Loop Controls | Nested Loops | List Comprehension | Practical – To-Do List
0/1
Class 11 – Practical Examples with Lists (Inventory & Feedback) | Tuples: Creation, Access, Operations | Mutable vs Immutable | Tuple Methods | Packing & Unpacking | Nested Tuples
0/1
Class 12 – Dictionaries: Create, Modify, Methods | Looping & Nested Dictionaries | Dictionary Comprehension | Functions: Defining, Calling, Parameters, Return Types
0/1
Class 13 – Lambda, Map, Filter Functions | Recursion | Palindrome Check
0/1
Class 14 – Python Modules & Packages | File Handling | Custom Packages | Standard Libraries | Working with Paths | Intro to OOP
0/1
Class 15 – OOP: Classes & Objects | Inheritance (Single, Multiple) | Polymorphism (Method Overriding)
0/1
Class 16 – Polymorphism (Functions & ABCs) | Encapsulation (Access Modifiers) | Abstraction | Magic Methods & Operator Overloading
0/1
Class 17 – Data Visualization (Matplotlib & Seaborn) | Pakistan Covid-19 Case Study
0/1
Class 18 – Python Visualization: Matplotlib (Line, Bar, Histogram, Pie, Scatter) | Analysis with Pandas & Matplotlib | Seaborn Visuals (BoxPlot, BarPlot, ViolinPlot, PairPlot, Heatmap) | Covid-19 Case Study (Pakistan)
0/1
Class 19 – Project: Car Price Prediction – Analyzing Data and Predicting Car Price using Pandas, NumPy, Matplotlib, SeaBorn, SkLearn (Data Manipulation and Pre-processing, Visualizing Dataset) | ExtraTreesRegressor | Random Forest Regressor
0/1
Class 20 – Project: Car Price Prediction (Advance Visualization) | Prediction Model Training | Hyperparameter Tuning | Predictions (RandomizedSearchCV)
0/1
Class 21 – Project: Car Prediction (Finalizing) | Natural Language Processing (NLP): Introduction | Tokenizing and Basic Terminology | Corpus and Documents | Vocabulary | Words
0/1
Class 22 – Roadmap to Natural Learning Processing (NLP) – Discussing Theories, Concepts and Practical Implications | Tokenizing and Basic Terminology | Corpus and Documents | Vocabulary | Words
0/1
Class 23 – Tokenization | Stemming (Snowball, RegeXp) | Wordnet Lemmatizer | Stopwords | Parts of Speech Tagging
0/1
Class 24 – Bag of Words Technique: Tokenization | Vocabulary Building | CountVectorizer | Document–Term Matrix | Stop-Words & N-Grams Impact on Feature Space
0/1
Class 25 – Named Entity Recognition (NER) using spaCy | Entity Visualization | Custom Entities | Evaluation Metrics (Precision, Recall, F1)
0/1
Class 26 – SMS Spam Detection: Data Loading & Cleaning | Text Preprocessing | TF-IDF Vectorization | Model Training (Multinomial Naive Bayes) | Evaluation (Accuracy, Confusion Matrix, Report)
0/1
Class 27 – Initiated ANN Project: Designed Feedforward Architecture (Input → Hidden → Output) | Set Activation & Loss Functions | Compiled Model with Optimizer | Trained with Epochs & Validation Split | Plotted Loss & Accuracy to Track Overfitting
0/1
Class 28 – Compared ANN vs RNN | Explained Forward & Backward Propagation | Initiated Churn Prediction Project (Environment Setup & Library Installation)
0/1
Class 29 – ANN Project Continued: Feature Engineering | Concepts of Activation Functions, Dense & Sequential Networks | Initiated Model Training and Parameter Tuning
0/1
Class 30 – ANN Project Finalization: Built and Trained Churn Prediction Model | Implemented EarlyStopping | Visualized Training with TensorBoard | Managed Logs and Saved Model with Keras (`.h5`)
0/1
Class 31 – Artificial Neural Network (ANN) Project: Churn Prediction – Finalizing and Deploying the Model
0/1
Class 32 – ANN Project Deployment: Used Hardcoded Inputs for Prediction | Developed `app.py` for Streamlit Interface | Deployed Project on GitHub and Live Testing Environment
0/1
Class 33 – Project: Salary Prediction using Regression (Data Understanding & Interpretation) | LSTM RNN: Overview, Architecture & Forget Gate Explained
0/1
Class 34 – LSTM RNN Architecture | Forget Gate | Input Gate & Candidate Memory | Output Gate
0/1
Class 35 – End-to-End LSTM & GRU RNN Project: Next Word Prediction | Data Collection & Preprocessing | Model Building & Training | Evaluation | Deployment
0/1
Class 36 – Introduction to Generative AI & LLMs | AI vs ML vs DL vs GenAI | Training Processes of ChatGPT & LLaMA 3 | Supervised Fine-Tuning | AI Model Evolution | LangChain Ecosystem Overview | Initiated Virtual Environment Setup
0/1
Class 37 – LLM App Development with LangChain LCEL | Effective Use of Language Models | PromptTemplates & OutputParsers | Message Structuring (Human/System) | Component Chaining | Clean Output Extraction | Input Simplification with Templates
0/1
Class 38 – LLM Chatbot with LangChain | Session-Based Conversation Design | Message History & Session IDs | Input Formatting with PromptTemplates | Custom System Messages | Input Variable Handling | Context Retention in Interactions
0/1
Class 39 –
0/1
Class 40 –
0/1
Class 41 –
0/1
Class 42 –
0/1
Power BI (Class 01) – Introduction of Power BI | Basics of Power Query | ETL | Basic Transformations in Power Query
0/1
Power BI (Class 02) – Text Functions | Number Functions | Basic Group By | Column Profiling, Quality and Distribution
0/1
Power BI (Class 03) – Date Tools | Categorical vs Time Series Analysis | Conditional Column | Column from Example | Orders of Operations
0/1
Power BI (Class 04) – Merge Queries | Appending Queries | Appending by Folders | Advanced Group By | Parameters
0/1
Power BI (Class 05) – Data Modelling | Star & Snow Flake Schema | Data Formatting
0/1
Power BI (Class 06) – DAX – Calculated Columns | Text Functions | Date Functions (Basic)
0/1
Power BI (Class 07) – DAX – Calculated Columns | Date Functions (Advance) | Logical Functions | Conditional Operators
0/1
Power BI (Class 08) – Advanced SWITCH Function | MID Function | Measures | Implicit vs Explicit Measures | Filter Context | Filter Flow | Aggregation Functions (SUM)
0/1
Power BI (Class 09) – Aggregation Functions | Filter Modifier Function (CALCULATE Function)
0/1
Power BI (Class 10) – CALCULATE | ALL | FILTER | Iterators (SUMX, COUNTX)
0/1
Power BI (Class 11) – Time Intelligence Functions | IFERROR | IS Functions
0/1
Power BI (Class 12) – Power BI Visual – Card Visual | Line Chart | Bar Chart
0/1
Power BI (Class 13) – Power BI Visuals – KPI Charts | Pie and Donut Chart | Table and Matrix Visuals | Filters (Basic to Advanced, TOPN) | Filters on Card Visual
0/1
Power BI (Class 14) – Power BI Visual – Slicers | Area Chart | Guage Chart | Conditional Formatting | Drill Through and Cross Filter | Multi-Row Card Visual | Tooltips | Buttons | Bookmarks
0/1
Power BI (Class 15) – Variables in DAX | Iterator Function (RANKX for Dynamic TOPN Rankings) | Advanced RANKX Function | Create Table
0/4
Power BI (Class 16) – Maven Roasters: Rounding Functions | Information Functions | Conversion Functions
0/1
Power BI (Class 17) – CALCULATE Modifier Functions
0/1
Power BI (Class 18) – Maven Roasters (SELECTCOLUMNS, ADDCOLUMNS, SUMMARIZE, Case Study (SUMMARIZE)) | Relationship Functions | Automatic Calendar Table | COALESE Function
0/3
Power BI (Class 19) – Power BI Service | PL-300 Exam Preparation
0/1
Class 43 – Tools & Agents in LangChain | Understanding Tools as External Resources | Role of Agents in Deciding Tool Usage & Timing | Strategies to Extend LLM with Real-Time Data | Laying Groundwork for Future Enhancements
0/1
Class 44 – Creating & Integrating Tools in LangChain | Custom Tools & Dynamic Agent Setup | AgentExecutor Wrapping | Streamlit UI for User Queries & Groq API Key | Defining Multiple Tools | Chain-of-Thought Reasoning | Handling Errors & Infinite Loops
0/1
Class 45 – Generative AI Project: Chat with SQL DB using LangChain SQL Toolkit & AgentType | Demo Walkthrough | Auto SQL Generation via Agents | SQLite DB Creation & Connection | MySQL Workbench Setup | Table Creation & Data Verification | Preparing Streamlit Integration for Natural Language SQL Querying
0/1
Class 46 – Chat with SQL DB: End-to-End Streamlit App Development | Developed App Supporting Both SQLite & MySQL | Fixed DB Configuration Function | Integrated User-Selected DB with SQL Agents | Displayed Query & Result in Streamlit Chat UI | Tested Agent-Generated Queries across Both DBs
0/1
Class 47 – Deployed YouTube & Website Summarization Bot with Streamlit | UI Setup (Sidebar, API Key, Summary Slider) | Content Loading via YouTube/URL Loader | Integrated ChatGroq LLM with PromptTemplate | Ran Summarizer Chain | Added Validation, UX Feedback & Structured Code
0/1
Class 48 –
0/1