Course Structure

Total Sessions: 20

SQL: 12 Sessions
Excel: 8 Sessions
Additional Features: On-call doubt resolution, assignments, interview questions, scenario-based questions, and one-to-one projects for both SQL and Excel.

SQL Training (Sessions 1-12)

Introduction to SQL

Basics of SQL and its role in data analytics
Understanding databases and tables

DDL and DML Commands

Creating, modifying, and managing database structures (DDL)
Manipulating data with INSERT, UPDATE, DELETE (DML)

Clauses

Filtering data with WHERE, ORDER BY, and LIMIT clauses

Inbuilt Functions

Using built-in functions for data manipulation and analysis

Group By and Having

Grouping data and filtering groups using the HAVING clause

Joins

Combining data from multiple tables using INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

Self Joins

Understanding self joins and their applications

Subquery and CTE

Using subqueries and Common Table Expressions (CTE) for complex queries

Case When

Conditional logic in SQL queries using the CASE WHEN statement

Set Operators

Combining query results with UNION, INTERSECT, and EXCEPT

Window Functions

Advanced data analysis with window functions

Analytical Window Functions and Problem-Solving Sessions

Deep dive into analytical window functions
Real-world problem-solving sessions

Performance Tuning

Optimizing SQL queries for better performance

Excel Training (Sessions 13-20)

Introduction to Excel

Getting started with Excel
Understanding the interface and basic functionalities

Formulas

Using various formulas for calculations and data analysis

Conditional Formatting

Formatting data based on specific conditions

Data Validation

Controlling the type of data entered into cells

Lookups and Functions

Mastering lookup functions like VLOOKUP, HLOOKUP, and other essential functions

Pivot Tables

Creating and manipulating pivot tables for data summarization

Dashboarding

Creating interactive dashboards for data visualization

Introduction to VBA and Macros

Automating tasks in Excel with Visual Basic for Applications (VBA) and macros

Additional Features

Assignments
Regular assignments to reinforce learning and practice skills
Interview Asked Questions
Preparation for common interview questions related to SQL and Excel
Scenario-Based Questions
Training on real-world scenarios to enhance problem-solving skills
On-Call Doubt Resolution
Personalized support to resolve any doubts or questions on the go
One-to-One Project for SQL and Excel
Hands-on projects to apply your learning in practical situations

Additional Bonus

Exclusive Study Materials
Access to comprehensive study materials and resources
Mock Interviews
Practice sessions to build confidence and prepare for real-world interviews
Lifetime Access to Recorded Sessions
Revisit and review the course content anytime with lifetime access to recorded sessions

Enroll Now

Don't miss this opportunity to learn from an expert and take your data analytics skills to the next level. Limited seats are available, so secure your spot today!

Contact Information For more details and to enroll, contact me directly at +91 98708 96958. Mention my reference to avail a special discount!

Start your journey towards becoming a proficient data analyst with Pragya Rathi’s expert guidance!