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.
Last updated
Was this helpful?
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.
Last updated
Was this helpful?
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:
Here are the topics to cover that will equip you well for the assessments:
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.
Joins and Subqueries
Using JOIN operations to merge rows from two or more tables
Writing subqueries to perform nested queries
Aggregate Functions (e.g., COUNT, SUM, AVG, MAX, MIN)
Date and Time Functions
Data Manipulation and Cleaning
Data type conversions and handling nulls
String functions for cleaning and manipulating textual data
Window Functions
Basics of Regular Expressions (REGEX)
Get your hands on previous year's questions, and find new or random problems to solve every day.
Reattempt the harder questions from the sets, and verify that it’s easier for you the second time.
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.
PS - This part will be updated and moved to Preparing for Interviewslater this month.
You can refer to to learn key SQL concepts. Alternatively, you can refer to individual topics from (this takes a lot more time, so beware!)
Start exploring databases on your PC using an IDE or online SQL editors. You can try Programiz's editor at .
Start solving problems from either (more relevant) or HackerRank in parallel.
Once you finish the basics, complete the set from LeetCode to strengthen your learning.
