Gayathri S.

Class Location

Online class via Zoom

Student's Home

Tutor's Home

Years of Experience in Class 10 Tuition

1

Class Location

Online class via Zoom

Student's Home

Tutor's Home

Years of Experience in Microsoft Excel Training classes

4

Teaching Experience in detail in Microsoft Excel Training classes

This beginner-friendly Excel class covers everything from the basics to practical applications. Learn what Microsoft Excel is, formulas, basic arithmetic functions like SUM, SUMIF and SUMIFS, keyboard shortcuts, lookup functions (VLOOKUP, HLOOKUP and XLOOKUP), Pivot Tables, Pivot Charts, date functions, error handling (IFERROR), text functions, and interactive dashboard creation. Learn step by step with practical examples and hands-on exercises.

Class Location

Online class via Zoom

Student's Home

Tutor's Home

Years of Experience in SQL Programming Training

4

Teaching Experience in detail in SQL Programming Training

Welcome to my SQL training classes! These classes are designed for beginners who want to learn SQL from scratch and develop practical database management skills. No prior programming or SQL experience is required. In this course, you will learn SQL step by step, starting with the fundamentals of databases and gradually moving towards advanced concepts. I will explain every topic in a simple and easy-to-understand manner, using practical examples and hands-on exercises. Topics covered in this course: - Introduction to SQL and databases - Understanding tables, rows, and columns - Creating databases and tables - Data types and constraints - SQL commands: DDL, DML, DQL, DCL and TCL - SELECT, INSERT, UPDATE and DELETE statements - WHERE, ORDER BY, GROUP BY and HAVING clauses - Aggregate functions such as SUM, COUNT, AVG, MIN and MAX - SQL operators and filtering conditions - Joins: INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN - Primary keys and foreign keys - Subqueries and nested queries - SQL functions and aliases - CASE statements and conditional logic - Views and indexes - Window functions and ranking functions - Practical SQL queries and exercises My Teaching Approach: My teaching approach focuses on understanding concepts rather than memorising queries. Each topic will be explained with simple examples, followed by practice questions to improve your problem-solving skills. I will also provide real-world examples and practical exercises to help you understand how SQL is used in data analysis and database management. Whether you are a school student, college student, fresher, or someone looking to improve your technical skills, these classes will help you build a strong foundation in SQL. Let's start learning SQL together and develop your database skills with confidence!