1. Introduction to DSA and Complexity Analysis Importance of DSA in Problem Solving Time Complexity Big-O, Big-Theta, Big-Omega Notations Best Case, Worst Case, Average Case Analysis Complexity of Iterative
Category: Courses
Excel Data SetExcel Data Set
City-Wise Departmental Employee Count in Uttar Pradesh : City HR Sales IT Finance Marketing Lucknow 120 200 150 100 80 Kanpur 95 180 130 110 90 Varanasi 85 170 140
SQL – Practice ActivitySQL – Practice Activity
Part 1: Setting Up the Database Part 2: SQL Queries and Data Manipulation Part 3: Export Data to Excel and Analyze
SQL : Advanced SQL QueriesSQL : Advanced SQL Queries
Objectives: 1. Subqueries Definition: Syntax Overview: Example: Exercise: 2. Joins with Conditions Advanced Joins: Example: Exercise: 3. Common Table Expressions (CTEs) Definition: Syntax Overview: Example: Exercise: 4. SQL Functions Overview:
SQL : Sorting Data with ORDER BYSQL : Sorting Data with ORDER BY
Objectives: 1. Introduction to ORDER BY Clause (5 minutes) Definition: Syntax Overview: Example: 2. Sorting Data in Ascending Order (10 minutes) Syntax: Example: Exercise: 3. Sorting Data in Descending Order
SQL: Grouping Data with GROUP BYSQL: Grouping Data with GROUP BY
Objectives: 1. Introduction to GROUP BY Clause Definition: Syntax Overview: Example: 2. Using COUNT() Function Syntax: Example: Exercise: 3. Using SUM() Function Syntax: Example: Exercise: 4. Using AVG() Function Syntax:
SQL : Using JOINsSQL : Using JOINs
Objectives: 1. Introduction to JOINs (5 minutes) Definition: Types of JOINs: 2. INNER JOIN (10 minutes) Syntax Overview: Example: Exercise: 3. LEFT JOIN (10 minutes) Syntax Overview: Example: Exercise: 4.
SQL : Deleting DataSQL : Deleting Data
Objectives: 1. Introduction to DELETE Statement (5 minutes) Syntax Overview: Example: 2. Deleting a Single Row (10 minutes) Basic Syntax: Exercise: 3. Deleting Multiple Rows (10 minutes) Syntax for Multiple
SQL : Updating DataSQL : Updating Data
Objectives: 1. Introduction to UPDATE Statement (5 minutes) Syntax Overview: Example: 2. Updating a Single Column (10 minutes) Basic Syntax: Exercise: 3. Updating Multiple Columns (10 minutes) Syntax for Multiple
SQL : Inserting DataSQL : Inserting Data
Objectives: 1. Introduction to INSERT INTO Statement (5 minutes) Syntax Overview: Example: 2. Inserting a Single Row (10 minutes) Basic Syntax: Exercise: 3. Inserting Multiple Rows (10 minutes) Syntax for