SQL ZERO TO HERO BOOTCAMP (One to One ) 15 Hour

SQL ZERO TO HERO BOOTCAMP

Start Date: Any date after 3 days of booking.

Timings -As per availability

Days: Every Monday and Friday

Syllabus & Content for SQL:

Section 1: Introduction to SQL

• Overview of SQL
• Importance of SQL in data management

Section 2: Basic SQL Syntax

• Understanding SQL syntax
• Creating and managing databases

Section 3: Insert, Delete and Update statements

• Adding, removing, and updating data in tables

Section 4: Select, Where, Order by Clauses

• Retrieving data from tables
• Filtering and sorting data

Section 5: Aggregating Data

• Using aggregate functions (e.g., SUM, AVG, COUNT)
• Grouping data with GROUP BY clause

Section 6: Built-in functions- String/Date

• Working with string and date functions in SQL

Section 7: Case When, Set Operators

• Conditional logic with CASE WHEN
• Performing set operations (UNION, INTERSECT, EXCEPT)

Section 8: Joins – Inner, Left, Right, Outer

• Understanding different types of joins
• Applying joins to retrieve data from multiple tables

Section 9: Joins- Self, Natural and Joins on more than 2 tables

• Exploring self joins and natural joins
• Handling joins involving more than two tables

Section 10: Performance Optimization and Indexing

• Optimizing SQL queries for better performance
• Utilizing indexing to improve query execution time

Section 11: Advanced Querying Techniques

• Advanced querying with subqueries and correlated subqueries
• Using EXISTS and NOT EXISTS operators

Section 12: Advanced Joins and Table Operations

• Deep dive into advanced join techniques
• Performing table operations such as UNION ALL and CROSS JOIN

Section 13: Advanced Data Manipulation and Transactions

• Advanced data manipulation with MERGE statement
• Understanding transactions and implementing ACID properties

Section 14: Stored Procedures

• Creating and executing stored procedures in SQL
• Passing parameters to stored procedures

Section 15: Advanced Window Functions and Analytic Queries

• Analyzing data using window functions (e.g., ROW_NUMBER, RANK)
• Writing complex analytic queries

Section 16: Advanced Set Operations and Query Optimization

• Performing advanced set operations
• Optimizing SQL queries for efficiency
• Feel free to adjust the start date, timing, and days according to your preference and availability! If you have any other questions or need further assistance, just let me know.