KEMBAR78
HackerRank SQL Certification Roadmap | PDF | Databases | Data Management
Scribd
Upload
81 views3 pages

HackerRank SQL Certification Roadmap

The document outlines a SQL certification roadmap provided by HackerRank, detailing three levels: Basic, Intermediate, and Advanced. Each level includes key topics to cover, important notes, and example SQL queries to illustrate concepts. Additionally, a 21-day practice plan is provided to help learners reinforce their skills through targeted tasks and mock tests.

Uploaded by

aicatai890
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
81 views3 pages

HackerRank SQL Certification Roadmap

The document outlines a SQL certification roadmap provided by HackerRank, detailing three levels: Basic, Intermediate, and Advanced. Each level includes key topics to cover, important notes, and example SQL queries to illustrate concepts. Additionally, a 21-day practice plan is provided to help learners reinforce their skills through targeted tasks and mock tests.

Uploaded by

aicatai890
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

🧠 SQL Certification Roadmap –

HackerRank (Basic, Intermediate,


Advanced)
🌱 Level 1: SQL Basic Certificate
🔗 https://www.hackerrank.com/skills-verification/sql_basic

✅ Topics to Cover:
1. SELECT statements
2. WHERE clause
3. DISTINCT keyword
4. ORDER BY (ASC/DESC)
5. LIMIT and OFFSET
6. Basic Filtering with AND/OR/NOT
7. Simple Math Functions: COUNT, SUM, AVG

📒 Key Notes:
- SQL is case-insensitive, but best practice is to use UPPERCASE for keywords.
- Use WHERE to filter rows before grouping.
- ORDER BY sorts results — default is ascending.
- Example:
SELECT name, salary
FROM employees
WHERE department = 'Sales'
ORDER BY salary DESC
LIMIT 5;

🌿 Level 2: SQL Intermediate Certificate


🔗 https://www.hackerrank.com/skills-verification/sql_intermediate

✅ Topics to Cover:
1. JOINs (INNER, LEFT, RIGHT)
2. GROUP BY + Aggregations
3. HAVING Clause
4. Subqueries (in SELECT, WHERE)
5. CASE WHEN THEN
6. DATE Functions (YEAR, MONTH, DATEDIFF, NOW())
📒 Key Notes:
- Use GROUP BY with HAVING to filter grouped results.
- JOIN is used to combine rows from multiple tables.
- Example:
SELECT d.department_name, COUNT(e.employee_id) AS total_employees
FROM departments d
LEFT JOIN employees e ON d.department_id = e.department_id
GROUP BY d.department_name
HAVING total_employees > 10;

🌳 Level 3: SQL Advanced Certificate


🔗 https://www.hackerrank.com/skills-verification/sql_advanced

✅ Topics to Cover:
1. Advanced Subqueries (Nested, Correlated)
2. Window Functions (RANK, DENSE_RANK, ROW_NUMBER)
3. CTE (WITH clause)
4. Views
5. CASE + Logic inside SELECT
6. Self JOINs
7. UNION, INTERSECT, EXCEPT
8. Analytical Queries (Running totals, Partitions)

📒 Key Notes:
- Use window functions for ranking and analytics.
- WITH clause (CTE) simplifies complex queries.
- Example:
WITH ranked_salaries AS (
SELECT employee_id, department_id,
salary,
RANK() OVER (PARTITION BY department_id ORDER BY salary DESC) AS dept_rank
FROM employees
)
SELECT * FROM ranked_salaries WHERE dept_rank <= 3;

21-Day SQL Practice Plan


Days Topics Tasks
1-3 SELECT, WHERE, Solve 10+ Basic
ORDER, LIMIT Select Problems
4-6 Aggregations, Focus on grouped
GROUP BY, HAVING filtering &
SUM/COUNT logic
7-9 JOINs (INNER, LEFT, Practice 10+ join
RIGHT) problems with
multiple tables
10-12 Subqueries, IN, Learn correlated
EXISTS, CASE subqueries and
conditions
13-15 CTEs, Views, Nested Practice multi-step
Queries queries using WITH
+ CASE
16-18 Window Functions RANK,
ROW_NUMBER,
DENSE_RANK with
PARTITION
19-21 Mixed Practice + Take mock tests for
Sample Tests HackerRank
certificates

You might also like