📊SQL for PM Assessments

Learning SQL can be a game changer as almost 25% companies have it in their online assessments and some ask SQL-based questions during interviews.

Why SQL for PM assessments?

It's not just about data; it’s about making informed decisions, understanding customer needs better, and driving your projects with real insights.

Plus, it's an underrated but essential skill that can set you apart in the product world. Do check out this blog if you're interested to know more:

SQL Skills for Product Managers - Department of ProductDepartment of Product

What SQL topics should I cover while preparing for PM assessments?

Here are the topics to cover that will equip you well for the assessments:

1. SQL Basics

   • Start with a SQL-based RDBMS like MySQL

   • How to perform CRUD operations (Create, Read, Update, Delete)

   • Understanding basic SQL syntax, clauses like SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.

2. Joins and Subqueries

   • Using JOIN operations to merge rows from two or more tables

   • Writing subqueries to perform nested queries

3. Aggregate Functions (e.g., COUNT, SUM, AVG, MAX, MIN)

4. Date and Time Functions

5. Data Manipulation and Cleaning

   • Data type conversions and handling nulls

   • String functions for cleaning and manipulating textual data

6. Window Functions

7. Basics of Regular Expressions (REGEX)

How to get started?

1. You can refer to W3Schools to learn key SQL concepts. Alternatively, you can refer to individual topics from Datacamp (this takes a lot more time, so beware!)

SQL Tutorial

Data Science Courses in Python, R, SQL, and more | DataCampDataCamp

If you like to watch videos instead, refer to these YouTube playlists!

1. https://youtube.com/playlist?list=PLavw5C92dz9HQQ_COgGb7kf_1H8UWUBxO&feature=shared

2. https://youtube.com/playlist?list=PLavw5C92dz9FD9XspliRM_HZM_jK7tkii&feature=shared

3. https://youtube.com/playlist?list=PLavw5C92dz9GbmgiW4TWVnxhjMFOIf0Q7&feature=shared

1. Start exploring databases on your PC using an IDE or online SQL editors. You can try Programiz's editor at this link.

Online SQL Editor

1. Start solving problems from either InterviewBit (more relevant) or HackerRank in parallel.

2. Once you finish the basics, complete the SQL50 set from LeetCode to strengthen your learning.

SQL 50 - Study Plan - LeetCodeLeetCode

What Next?

1. Get your hands on previous year's questions, and find new or random problems to solve every day.

2. Reattempt the harder questions from the sets, and verify that it’s easier for you the second time.

3. If you still have a lot of time left, find a friend who shares the same vision and challenge each other with new questions every now and then. Start preparing for interviews.

SQL for PM Interviews

PS - This part will be updated and moved to Preparing for Interviewslater this month.

📊SQL for PM Interviews