Introduction to Microsoft Excel Basics 

Day 1: Understanding the Excel Interface

• Overview of the Excel interface (ribbon, cells, columns, rows)
• Navigating and selecting cells
• Introduction to Excel terminology (workbook, worksheet, cell, range)

Day 2: Data Entry and Formatting

• Entering data into cells (text, numbers, dates)
• Basic text formatting (font, size, bold, italic, underline)
• Introduction to cell formatting (alignment, borders, fill color)

Basic Formulas and Functions

Day 1: Formulas and Cell References

• Introduction to basic mathematical operators (+, -, *, /)
• Creating simple formulas
• Understanding cell references (relative, absolute)

Day 2: Common Functions

• Introduction to common functions (SUM, AVERAGE, MAX, MIN)
• Practical exercises using functions
• Tips for troubleshooting formulas

Data Management and Analysis

Day 1: Sorting and Filtering Data

• Sorting data in Excel
• Filtering data using AutoFilter
• Custom filtering options

Day 2: Data Validation and Data Tools

• Setting up data validation rules
• Introduction to Data Tools (Text to Columns, Remove Duplicates)
• Overview of Flash Fill for data manipulation

Charts and Graphs, Advanced Features

Day 1: Creating Charts and Graphs

• Introduction to chart types (bar, line, pie)
• Creating and customizing charts
• Adding data labels and legends

Day 2: Advanced Excel Features

• Introduction to PivotTables
• Data consolidation techniques
• Overview of conditional formatting
• Protecting worksheets and workbooks

SQL Fundamentals (Beginner to Intermediate)

Session 1: Introduction to SQL and Database Concepts

Key Concepts:

• Overview of SQL and its importance
• Basics of relational databases and tables
• Introduction to SQL commands (SELECT, INSERT, UPDATE, DELETE)

Hands-On Exercises:

• Setting up a basic database
• Writing and executing simple SELECT queries

Session 2: Data Filtering and Sorting

Key Concepts:

• Using WHERE clause for data filtering
• ORDER BY clause for sorting results
• Combining filters and sorting in queries

Hands-On Exercises:

• Filtering data based on conditions
• Sorting query results effectively

Session 3: SQL Joins and Subqueries

Key Concepts:

• Understanding different types of joins (INNER, LEFT, RIGHT)
• Utilizing subqueries for data retrieval
• Combining multiple tables in a query

Hands-On Exercises:

• Performing various types of joins
• Writing subqueries for practical scenarios

Session 4: Aggregation and Grouping

Key Concepts:

• Applying aggregate functions (COUNT, SUM, AVG, MAX, MIN)
• GROUP BY clause for data grouping
• HAVING clause for filtering grouped data

Hands-On Exercises:

• Calculating aggregates in queries
• Grouping data for meaningful analysis

Session 5: Introduction to SQL Constraints and Indexes

Key Concepts:

• Primary keys, foreign keys, and unique constraints
• Implementing indexes for query optimization
• Ensuring data integrity with constraints

Hands-On Exercises:

• Creating and managing constraints
• Implementing indexes to improve performance

Session 6: SQL Views and Stored Procedures

Key Concepts:

• Creating and utilizing SQL views
• Introduction to stored procedures and their benefits
• Use cases for views and stored procedures

Hands-On Exercises:

• Building views for simplified querying
• Writing basic stored procedures

Session 7: SQL Transactions and Locks

Key Concepts:

• Understanding transactions and their importance
• Types of locks in SQL
• Managing concurrency issues with transactions

Hands-On Exercises:

• Implementing transactions for data consistency
• Handling locking scenarios effectively

Session 8: Intermediate Project

Project:

• Participants will work on a practical project, applying SQL fundamentals to solve a real-world scenario.

Feedback and Discussion:

• Peer review and feedback session on projects

Advanced SQL Techniques

Session 9: Advanced Query Optimization Techniques

Key Concepts:

• Analyzing query execution plans
• Index optimization strategies
• Query hints and tips for optimization

Hands-On Exercises:

• Identifying and resolving performance bottlenecks
• Optimizing queries for efficiency

Session 10: Working with Date and Time Functions

Key Concepts:

• Date and time functions in SQL
• Performing date calculations
• Handling time zones and daylight-saving time

Hands-On Exercises:

• Using date and time functions in queries
• Solving practical problems involving date and time

Session 11: Advanced Subqueries and Nested Queries

Key Concepts:

• Nested subqueries and their applications
• Correlated subqueries
• Common table expressions (CTEs)

Hands-On Exercises:

• Writing complex subqueries
• Using CTEs for improved readability

Session 12: Advanced Views and Materialized Views

Key Concepts:

• Materialized views for improved performance
• Updating and refreshing materialized views
• Use cases for advanced view structures

Hands-On Exercises:

• Creating and managing materialized views
• Leveraging advanced view features

Session 13: SQL Security and Permissions

Key Concepts:

• Managing user access and permissions
• Implementing row-level security
• Best practices for securing SQL databases

Hands-On Exercises:

• Setting up user permissions
• Implementing row-level security scenarios

Session 14: SQL Performance Tuning and Indexing Strategies

Key Concepts:

• Techniques for performance tuning
• Indexing strategies for different scenarios
• Monitoring and optimizing database performance

Hands-On Exercises:

• Implementing performance tuning measures
• Analyzing and optimizing index usage

Session 15: Advanced Stored Procedures and Functions

Key Concepts:

• Advanced stored procedure techniques
• Error handling and transactions in stored procedures
• Dynamic SQL and parameterized queries

Hands-On Exercises:

• Writing complex stored procedures
• Handling errors and implementing transactions

Session 16: Final Project and Certification

Project:

Participants will work on an advanced project incorporating complex SQL concepts.

Presentation:

Final project presentations and discussions.

Session 1: Working with variables in Python

• Printing to the console in Python
• String manipulation and code intelligence
• Python input function
• Python variables
• Variables naming
• Band name generator project

Session 2: Understanding Data types and how to manipulate strings

• Python primitive Data Types
• Type error, Type checking and Type conversion
• Mathematical operations in Python
• Number manipulation and F strings in Python
• Exercise on Life in weeks and Tip calculator

Session 3: Control flow and Logical Operators

• Control flow with If / Else conditional operators
• Odd or Even numbers Exercise
• Nested if and elif statements
• Exercise: BMI, Leap year, Treasure Island
• Multiple IF statements in succession
• Logical operators
• Ex: Love Calculator

Session 4: Randomization and Python Lists

• Random module
• Exercise: Heads or Tails
• Understanding the offset and appending items to lists
• Index errors and working with nested lists
• Ex: Pick a random character from a given string
• Ex: Generate a random password that is 10 characters long, contain at least 2 uppercase letters, 1 digit and 1 special symbol

Session 5: Python Loops

• For loops
• Using for loops with python lists
• Ex: Print the first 10 natural numbers
• Ex: Average height
• For loops and the range() function
• Ex: display all prime numbers within a range
• Ex: Display elements from a given list present at odd index positions
• Ex: Calculate the cube of all numbers from 1 to 20
• Exercise: adding even numbers, Password Generator
• Printing a pattern with For loop

Session 6: Python functions

• Defining and calling python functions
• Indentation in python 
• While loops
• Ex: Finding the sum of numbers in a list using while loop
• Ex: Reversing a string with while loop

Session 7: Hangman game

• Breakdown a complex problem into a flow chart
• Ex: Picking a random word and checking the answer
• How to check the User’s answer
• Replacing blanks with guesses

Session 8: Function Parameters and Ceaser Cipher 

• Functions with inputs
• Positional vs Keyword Argument
• Exercise: Paint Area Calculator, Prime Number Checker

Session 9: Ceaser Cipher

• Part 1: Encryption
• Part 2: Decryption
• Part 3: Reorganizing our code
• Part 4: User Experience Improvements and Final touches

Session 10: Dictionaries and Nesting

• Python Dictionaries
• Ex: Grading Program
• Ex: A python script to concatenate various dictionaries into one
• Ex: A python script to check whether a particular key exists in a dictionary
• Ex: A Python script to iterate over dictionaries using for loops
• Ex: A python code to multiply all the items in a dictionary
• Nesting lists and Dictionaries
• Dictionary in list

Session 11: Functions with Outputs

• Functions with outputs
• Multiple return values
• Ex: days in a month
• Docstrings
• Ex: Calculator part 1: combining dictionaries and functions
• Print vs Return
• Ex: Calculator part 2.

Session 12: Project

• Library catalog System
• To-do list manager
• Recipe book
• Students Database

Session 13: Scope and Number Guessing Game

• Local vs Global scope
• How to modify a global variable
• Python constants and Global scope
• Number guessing game

Session 14: Debugging: How to find and fix bugs

• Introduction to debugging
• Common programming errors
• Debugging tools
• Reading error messages
• Using print statements
• Debugging challenges
• Best practices

Session 15: Local Development Environment

• Installing Python locally on your computer
• Download PyCharm for Windows or Mac
• How to install PyCharm on Windows
• Coffee Machine Project

Session 16: Object Oriented Programming

• Why the need for OOP and how does it work?
• Classes and Objects
• Constructing objects and accessing their attributes and methods
• Building the coffee Machine Project with OOP

Session 17: Object Oriented Programming continued

• How to create your own class in Python
• Working with attributes, class constructors, and the unit function
• Adding methods to a class
• Project