Deoli Khanpur, Delhi, India - 110062
10
Details verified of Gaurav S.✕
Identity
Education
Know how UrbanPro verifies Tutor details
Identity is verified based on matching the details uploaded by the Tutor with government databases.
5 Students
Class Location
Online (video chat via skype, google hangout etc)
Student's Home
Tutor's Home
Years of Experience in Microsoft Excel Training classes
4
Teaches following Excel features
Advanced Excel, Excel VBA Training, Excel Macro Training, Basic Excel
Teaching Experience in detail in Microsoft Excel Training classes
Basic excel to advance Excel training like Vlookup Hook-up pivot table chart dashboard MIS Data validation conditional formatting etc...
Class Location
Online (video chat via skype, google hangout etc)
Student's Home
Tutor's Home
Years of Experience in Computer Classes
6
Type of Computer course taken
Software Programming, Training in Software application usage, Basics of Computer usage, Training in Computer tools usage
Teaching Experience in detail in Computer Classes
Basic excel,ms words,PPT ETC...
Class Location
Online (video chat via skype, google hangout etc)
Student's Home
Tutor's Home
Years of Experience in Script Writing classes
4
Teaching Experience in detail in Script Writing classes
Google sheets Google scripting google Data studio Email reminder WhatsApp Automation Daily follow-up automation etc...
Class Location
Online (video chat via skype, google hangout etc)
Student's Home
Tutor's Home
Years of Experience in Website Scripting Training
3
Teaching Experience in detail in Website Scripting Training
HTML,JAVA.CSS
Class Location
Online (video chat via skype, google hangout etc)
Student's Home
Tutor's Home
Years of Experience in SQL Programming Training
6
Teaching Experience in detail in SQL Programming Training
Primary Keys and Foreign Keys: Enforcing data integrity between tables Creating Tables: CREATE TABLE and table constraints ALTER TABLE: Modifying table structures Relationships: One-to-many, many-to-one, and many-to-many relationships 10. Indexing and Performance (2 hours) What are Indexes? Types of Indexes: Unique, Composite, and Full-Text indexes Creating and Dropping Indexes Query Optimization: Using indexes to speed up query performance Day 6: Advanced Topics and SQL Best Practices (4 hours) 11. Working with Views and Stored Procedures (2 hours) What are Views? Creating and querying views Benefits and use cases for views Stored Procedures: What are stored procedures? Creating and executing stored procedures Passing parameters to stored procedures 12. SQL Best Practices (2 hours) SQL Formatting and Readability Writing clean and readable queries Commenting queries Error Handling: Using TRY...CATCH blocks (in SQL Server, for example) Security: Avoiding SQL Injection Using parameterized queries for security
5 out of 5 2 reviews
Manish Kumar singh
Advance Excel Requirement for :Advanced Excel
"Very Good trainer. He teaches a lot of formulas and explain all the things easy way. So I have learnt basic excel to advance excel from Gaurav sir. "
Reply by Gaurav
Thank You so much
Manisha Singh
Advance Excel Requirement for :Advanced Excel,Basic Excel,Excel Macro Training
"Training was fantastic. He teaches step by steps formula and explain all the things easy way. So I learnt proper basic excel to advance excel from Gaurav sir. Really I was so much confused but after the join the class everything was good. "
Reply by Gaurav
Thank you so much.
Want to learn from Gaurav?
Share this Profile
Recommended Profiles
Reply to 's review
Enter your reply*
Your reply has been successfully submitted.
Certified
The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.
Sector 46,
Gurgaon
