Data Science and Analytics with AI (Cohort-01)

Class 01 – Main Clauses (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY) | Order of Operations | Commenting Queries | AS Keyword | TOPN Keyword

Data Science (Batch-01) – Session 01

02:04:25

Class 02 – TOPN PERCENT | Aggregate Functions (COUNT, AVG, MAX, MIN, SUM) | Numerical Functions (ROUND, FLOOR, CEILING, ABS) | DISTINCT Function | Date Functions (GETDATE, DATEDIFF, DATEADD, MONTH, DATENAME, DATEPART, YEAR) | Text Functions (CONCAT, LEFT, RIGHT, LEN)

Class 03 – Text Functions (UPPER, LOWER, REPLACE, CHARINDEX, SUBSTRING) | DECLARE, NVARCHAR, SET Keywords | Conditional Functions (AND, ISNULL, IN, BETWEEN. LIKE, IFF, OR)

Class 04 – Conditional Functions (ISNULL, COALESCE, CASE, WHEN, THEN, END) | CAST Function

Class 05 – Theory (DBMS Vs RDBMS, SQL Server, Instances, Databases, Data Security, Type of Database Systems) | Data Normalization | Fact Tables vs Dimension Tables | Relationship and Keys | Star vs Snowflake Schema | ER Diagram | JOINS Theory (INNER, RIGHT, LEFT, FULL)

Class 06 – JOINS (INNER, RIGHT, LEFT, FULL) | VIEWS | UNION | UNION ALL | Sub Queries (Single, Multi Rows, Correlated, Table) | Common Table Expression CTE | CRUD (CREATE, READ, UPDATE, DELETE) | INSERT INTO | UPDATE | DELETE | Window Functions (RANK, OVER, PARTITION BY)

Class 07 – Basics of Python (Punctuations, Mathematical Operators, Brackets and Craces, Logical and Comparison) | Syntax and Semantics | Conditional Statement | Python Variables (Variables, Declaring and Assigning Variables, Naming Conventions, Types) | Practical Examples and Common Errors

Class 08 – Fundamental Data Structure in Python | List (Creating, Assessing, Modifying) | List (Insert, Remove, Pop, Random, Append) Functions

Class 09 – Data Types (Integers, Floating, Point Numbers, Strings, Booleans) | Advanced Data Types (Lists, Tuples, Sets, Dictionaries) | Operators (Arithmetic, Comparison, Logical) | Conditional Statements (IF, ELIF, ELSE) | Practical Example – Employees Bonus Calculator

Class 10 – Loops (For Loop and While Loop) | Iterating over Range | Iterating over String | Loop Control Statements (Break, Continue, Pass) | Nested Loops | Data Structure (List, Tuples, Sets, Dictionaries) | List Comprehension | Practical Example (Managing a To-Do List)

Class 11 – List Practical Examples (Managing an Inventory, Collecting Feedback) | Data Structure (Tuples) – Creating, Assessing and Operations | Mutable vs Immutable Tuples | Methods | Packing and Unpacking Tuples | Nested Tuples

Class 12 – Data Structure (Dictionaries) – Creating, Assessing and Modifying | Methods | Looping over Dictionaries | Nested Dictionaries | Dictionaries Comprehensions | Functions (Introduction to Functions, Defining Functions, Calling Functions, Parameters, Variable-Length Arguments, Return Statements)

Class 13 – Lambda Map Filter | Palindrome | Recursion | Lambda Functions | map() Function | filter() Functions

Class 14 – Importing Modules in Python: Modules and Package | Custom Packages | Standard Libraries | File Operations | Working with File Paths | Object Oriented Programming (OOP)

Class 15 – OOP Basics (Classes and Object / Instance variables and instance methods), Inheritance Python (Single Inheritace / Multiple Inheritance), Polymorphism: Method Overriding

Class 16 – Polymorphism: Functions and Methods | Polymorphism (Override – ABC) | Encapsulation (Public and Private Variable, Protected Method) and Abstraction | Magic Methods | Operation Overloading

Class 17 – Visualization with Python | Data Visualization with Matplotlib | Data Visualization with Seaborn | Pakistan Covid-19 Visual Analysis

Class 18 – Visualization in Python | Data Visualization with Matplotlib (Line, Bar, Histogram, Pie, Scatterplot) | Pandas with Matplotlib for Analysis and Visualizing | SeaBorn for Advanced Visuals (BoxPlot, BarPlot, VoilinPlot, PairPlot, Heatmap) | Pakistan Covid-19 Visual Analysis

Class 19 –

Class 20 – Car Price Prediction (Advance Visualization) | Data Manipulation and Pre-processing | Visualizing Dataset | Model Training | Hyperparameter Tuning | Predictions

Class 21 – Tokenizing and Basic Terminology | Corpus | Documents | Vocabulary | Words

Class 22 –

Class 23 – Tokenization | Stemming in NLP | PorterStemmer | RegexpStemmer | Snowball Stemmer | Wordnet Lemmatizer | Stopwords | Parts of Speech Tagging

Course Content

Class 01 – Main Clauses (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY) | Order of Operations | Commenting Queries | AS Keyword | TOPN Keyword

Data Science (Batch-01) – Session 01

Class 02 – TOPN PERCENT | Aggregate Functions (COUNT, AVG, MAX, MIN, SUM) | Numerical Functions (ROUND, FLOOR, CEILING, ABS) | DISTINCT Function | Date Functions (GETDATE, DATEDIFF, DATEADD, MONTH, DATENAME, DATEPART, YEAR) | Text Functions (CONCAT, LEFT, RIGHT, LEN)

Data Science (Batch-01) – Session 02

Class 03 – Text Functions (UPPER, LOWER, REPLACE, CHARINDEX, SUBSTRING) | DECLARE, NVARCHAR, SET Keywords | Conditional Functions (AND, ISNULL, IN, BETWEEN. LIKE, IFF, OR)

Data Science (Batch-01) – Session 03

Class 04 – Conditional Functions (ISNULL, COALESCE, CASE, WHEN, THEN, END) | CAST Function

Data Science (Batch-01) – Session 04

Class 05 – Theory (DBMS Vs RDBMS, SQL Server, Instances, Databases, Data Security, Type of Database Systems) | Data Normalization | Fact Tables vs Dimension Tables | Relationship and Keys | Star vs Snowflake Schema | ER Diagram | JOINS Theory (INNER, RIGHT, LEFT, FULL)

Data Science (Batch-01) – Session 05

Class 06 – JOINS (INNER, RIGHT, LEFT, FULL) | VIEWS | UNION | UNION ALL | Sub Queries (Single, Multi Rows, Correlated, Table) | Common Table Expression CTE | CRUD (CREATE, READ, UPDATE, DELETE) | INSERT INTO | UPDATE | DELETE | Window Functions (RANK, OVER, PARTITION BY)

Data Science (Batch-01) – Session 06

Class 07 – Basics of Python (Punctuations, Mathematical Operators, Brackets and Craces, Logical and Comparison) | Syntax and Semantics | Conditional Statement | Python Variables (Variables, Declaring and Assigning Variables, Naming Conventions, Types) | Practical Examples and Common Errors

Data Science (Batch-01) – Session 07

Class 08 – Fundamental Data Structure in Python | List (Creating, Assessing, Modifying) | List (Insert, Remove, Pop, Random, Append) Functions

Data Science (Batch-01) – Session 08

Class 09 – Data Types (Integers, Floating, Point Numbers, Strings, Booleans) | Advanced Data Types (Lists, Tuples, Sets, Dictionaries) | Operators (Arithmetic, Comparison, Logical) | Conditional Statements (IF, ELIF, ELSE) | Practical Example – Employees Bonus Calculator

Data Science (Batch-01) – Session 09

Class 10 – Loops (For Loop and While Loop) | Iterating over Range | Iterating over String | Loop Control Statements (Break, Continue, Pass) | Nested Loops | Data Structure (List, Tuples, Sets, Dictionaries) | List Comprehension | Practical Example (Managing a To-Do List)

Data Science (Batch-01) – Session 10

Class 11 – List Practical Examples (Managing an Inventory, Collecting Feedback) | Data Structure (Tuples) – Creating, Assessing and Operations | Mutable vs Immutable Tuples | Methods | Packing and Unpacking Tuples | Nested Tuples

Data Science (Batch-01) – Session 11

Data Science (Batch-01) – Session 12

Class 13 – Lambda Map Filter | Palindrome | Recursion | Lambda Functions | map() Function | filter() Functions

Data Science (Batch-01) – Session 13

Class 14 – Importing Modules in Python: Modules and Package | Custom Packages | Standard Libraries | File Operations | Working with File Paths | Object Oriented Programming (OOP)

Data Science (Batch-01) – Session 14

Class 15 – OOP Basics (Classes and Object / Instance variables and instance methods), Inheritance Python (Single Inheritace / Multiple Inheritance), Polymorphism: Method Overriding

Data Science (Batch-01) – Session 15

Class 16 – Polymorphism: Functions and Methods | Polymorphism (Override – ABC) | Encapsulation (Public and Private Variable, Protected Method) and Abstraction | Magic Methods | Operation Overloading

Data Science (Batch-01) – Session 16

Class 17 – Visualization with Python | Data Visualization with Matplotlib | Data Visualization with Seaborn | Pakistan Covid-19 Visual Analysis

Data Science (Batch-01) – Session 17

Class 18 – Visualization in Python | Data Visualization with Matplotlib (Line, Bar, Histogram, Pie, Scatterplot) | Pandas with Matplotlib for Analysis and Visualizing | SeaBorn for Advanced Visuals (BoxPlot, BarPlot, VoilinPlot, PairPlot, Heatmap) | Pakistan Covid-19 Visual Analysis

Data Science (Batch-01) – Session 18

Class 19 –

Data Science (Batch-01) – Session 19

Class 20 – Car Price Prediction (Advance Visualization) | Data Manipulation and Pre-processing | Visualizing Dataset | Model Training | Hyperparameter Tuning | Predictions

Data Science (Batch-01) – Session 20

Class 21 – Tokenizing and Basic Terminology | Corpus | Documents | Vocabulary | Words

Data Science (Batch-01) – Session 21

Class 22 –

Data Science (Batch-01) – Session 22

Class 23 – Tokenization | Stemming in NLP | PorterStemmer | RegexpStemmer | Snowball Stemmer | Wordnet Lemmatizer | Stopwords | Parts of Speech Tagging

Data Science (Batch-01) – Session 23