SQL 3 Days Workshop Road Map :: 15 HRS 🚀

📅 Day 1: Basics of SQL

• Introduction to SQL and Relational Databases
• Overview of SQL 📊
• Understanding relational databases and tables 🗃️
• Installation of PgAdmin 4 💻 (Windows and Mac)
• Basic SQL SyntaxSELECT statement ✨
• FROM clause 📝
• WHERE clause 🎯
• ORDER BY clause 🔍
• LIMIT clause ⏳
• Filtering DataUsing comparison operators ↔️
• Using logical operators ∧ ∨
• Using wildcards (LIKE operator) 🃏
• Aggregation FunctionsCOUNT, SUM, AVG, MIN, MAX ➕➖
• GROUP BY clause 🔢
• Dealing with duplicates
• JoinsINNER JOIN ↔️
• LEFT JOIN ⬅️
• RIGHT JOIN ➡️
• FULL OUTER JOIN ↔️⬅️➡️
• Subqueries 🔄
• Nested Subquery
• Correlated Subquery

📅 Day 2: Intermediate SQL Concepts

• Advanced SQL FunctionsString functions 🔡
• Date functions 📅
• Numeric functions 🔢
• Case Statements
• Views & Importance
• ViewsCreating views 👀
• Altering views 🔧
• Dropping views 🗑️
• Store Procedure
• Types of store procedures
• Indexes 📈
• Data ModificationINSERT statement ➕
• UPDATE statement ✏️
• DELETE statement ❌
• Window Function
• ROW_NUMBER
• RANK
• DENSE_RANK🥇🥈🥉
• Handling NULL ValuesIS NULL, IS NOT NULL ❓❌
• COALESCE function 🔄

📅 Day 3: Advanced SQL Concepts and Projects

• Advanced JoinsSelf-joins 🔄🔄
• Cross joins ✖️
• Common Table Expressions (CTEs) 🧩
• Importing Data into PgAdmin 4Importing data from CSV files 📁

• Solving 30 Days SQL Challenge Questions 🏋️‍♂️
• Project 1: Amazon Data Analysis 🛍️
• Project 2: Hotel Booking Data Analysis 🏨
• Resources for Continued PracticeWebsites, online platforms for practicing SQL 🌐
• Recommended books, tutorials 📚
• Preparing for InterviewsTips for preparing for SQL-related job interviews 💼
• Common SQL interview questions and how to approach them ❓🗣️

🚀 Projects:

Don't miss the exciting hands-on projects where you'll analyze real-world data!

• Project 1: Amazon Data Analysis
• Project 2: Hotel Booking Data Analysis

Certifications:

• Workshop Completion Certificate 🎓
• HackerRank SQL Challenges:Basic SQL 🎓
• Medium SQL 🎓
• Advanced SQL 🎓

Additional Sessions:

• Resume building guidance 📄
• LinkedIn optimization 🔎
• Referral hacks 🔗
• Interview preparation topics 🗣️

Event Details:

• Workshop: SQL Masterclass 15 Hours
• Dates: (Duration: 3 days, 15 hours total)
• 🗓️18/05/2024 Saturday 6PM-11PM IST
• 🗓️19/05/2024 Sunday 6PM-11PM IST
• 🗓️20/05/2024 Monday 7-12AM IST

Benefits:

• Community Support for 12 Months: Gain access to an exclusive community channel where you can ask questions, seek clarification, and engage with fellow participants and instructors even after the workshop ends. Get personalized responses to your queries and continue your learning journey with ongoing support. 🤝