Pranav Saluja
Learn Coding the Right Way – Deep Concepts with Varied Approaches for Effective Learning
Loading...
Show all photos
Pranav Saluja
Bachelors degree
/ 55 min
About your coding tutor - Pranav
I’m Pranav Saluja, a Computer Science tutor passionate about helping students build strong fundamentals and real-world problem-solving skills. I specialize in teaching Java, Python, Data Structures & Algorithms, and the fundamentals of Artificial Intelligence. With hands-on teaching experience, I focus on making complex concepts simple, intuitive, and easy to apply. My teaching style is highly structured and student-centric. Instead of just explaining theory, I emphasize deep understanding through clear explanations, practical examples, and guided problem-solving. I believe that learning happens best when students actively think, make mistakes, and improve with the right guidance. That’s why I break down each topic step-by-step and ensure you truly understand the “why” behind every concept. I also help students prepare for coding interviews, college exams, and build real-world projects. Whether you’re a beginner starting your coding journey or someone looking to improve problem-solving skills and crack top tech companies, I tailor my teaching approach based on your goals and current level. My aim is not just to teach you how to code, but to help you think like a problem solver and a strong Computer Science engineer. If you’re serious about improving and want clear, honest guidance, I’m here to help you grow consistently and confidently.
Meet Pranav
Coding tutor specialities
Exam prep
Debugging
Code Optimization
Assignment help
Homework help
Project help
Upskilling
CoTutorAI modules
Summary
Podcast
Quiz
Learnings
Flashcard
Spotlight
Zero Risk Guaranteed
15-days refund
Free tutor swap
No cancel fee
1-yr validity
24/7 support
Learner types for coding classes
Coding for beginners
Coding for advanced
Coding for intermediate
Coding for kids
Hands-on learning
Students gain confidence applying coding skills to real projects.
100% on-time college submissions
Students meet deadlines with tutor support.
Flexible lesson scheduling
90% of students find it easy to schedule lessons.
Pranav - Coding tutor also teaches
C
C++
Coding for kids
CSS
HTML
Java
Coding concepts taught by Pranav
The student and tutor reviewed fundamental and intermediate SQL concepts in preparation for an exam. They practiced writing various queries, including filtering, sorting, aggregation, and grouping data, and discussed the logical execution order of SQL commands. The tutor requested study materials to aid future sessions.
SQL Query Execution Order
Filtering Data with WHERE and HAVING
Aggregate Functions and GROUP BY
DISTINCT Keyword
Handling NULL Values
The Tutor and Student reviewed an assignment that involved creating an ERD and implementing it in Oracle SQL. They discussed table creation, foreign key constraints, and the critical need to insert mock data to enable query execution, covering various SQL query types including joins, WHERE clauses, GROUP BY, ORDER BY, subqueries, and date calculations.
Entity-Relationship Diagrams (ERD)
SQL Table Creation and Constraints
SQL Joins and WHERE Clause
SQL GROUP BY and ORDER BY Clauses
SQL Subqueries
SQL Calculated Columns and Date Functions
The student and tutor reviewed database normalization, focusing on 1NF, 2NF, and 3NF. They practiced identifying functional and transitive dependencies, applying these concepts to create normalized database tables from given scenarios. The session concluded with practice problems and a plan to continue with other assignments in the next class.
Functional Dependencies (FDs)
Database Design Strategy
Normal Forms: 1NF
2NF
3NF
Normalization: The Goal
The Tutor and Student reviewed database normalization concepts, focusing on 1NF, 2NF, and 3NF, and worked through practice exam questions to prepare for an upcoming test. They clarified definitions of normal forms, dependencies, and prime attributes, and planned to cover practice problems in a future session.
Prime vs. Non-Prime Attributes
Third Normal Form (3NF)
Second Normal Form (2NF)
First Normal Form (1NF)
Normalization in Databases
The Tutor instructed the Student on advanced SQL query concepts, covering aggregate functions (COUNT, SUM, AVG, MIN, MAX) and the GROUP BY clause. They practiced using these functions to solve business problems, such as calculating total payments per vendor, and clarified the difference between WHERE and HAVING clauses for filtering data at row and group levels, respectively.
Aggregate Functions
GROUP BY Clause
HAVING Clause vs. WHERE Clause
Aliases in SQL
The tutor and student worked through setting up the database environment and then focused on foundational SQL concepts. They covered the `SELECT` statement, `WHERE` clause for filtering, `ORDER BY` for sorting, `LIMIT` for result quantity, `DISTINCT` for uniqueness, and the `LIKE` operator for pattern matching. The next session is planned to cover joins.
Finding Unique Values with DISTINCT
Limiting Results with LIMIT
Filtering with the WHERE Clause
SQL SELECT Statement
Ordering Results with ORDER BY
Approach & tools used by coding tutor
Bitbucket
Visual Studio Code
PyCharm
Jupyter Notebook
Postman
Programming tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.