Scribd
Upload
4 views

Roadmap to Learn SQL in 30 Days ?

Uploaded by

Sana Shaik
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views

Roadmap to Learn SQL in 30 Days ?

Uploaded by

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

30-Day SQL Learning Roadmap

Days 1-5: Introduction to Databases and Basic SQL


Commands

● Learn:
○ Fundamentals of databases and how they work.
○ Basic SQL commands: CREATE, INSERT, SELECT,
UPDATE, DELETE.
○ Using WHERE clauses, functions, aliases (AS), and
pattern matching with LIKE.

Days 6-10: Understanding Keys and Constraints

● Learn:
○ Different types of keys: Primary Key, Foreign Key,
Candidate Key.
○ Implementing constraints: UNIQUE, NOT NULL, CHECK
to ensure data integrity.

Days 11-15: Data Organization and Management

● Learn:
○ Sorting and grouping data using ORDER BY and GROUP
BY.
○ Removing data with TRUNCATE and deleting tables with
DROP.
○ Introduction to aggregate functions: SUM, COUNT, MIN,
MAX, AVG.
Days 16-20: Advanced Querying Techniques

● Learn:
○ Utilising aggregate functions in combination with GROUP
BY.
○ Filtering grouped data using the HAVING clause.
○ Writing subqueries for complex data retrieval.
○ Using advanced operators: IN, BETWEEN, EXISTS, ANY,
ALL.

Days 21-25: Working with Multiple Tables and CTEs

● Learn:
○ Performing joins: INNER JOIN, LEFT JOIN, RIGHT
JOIN, FULL OUTER JOIN.
○ Combining query results with UNION and UNION ALL.
○ Understanding and using Common Table Expressions
(CTEs) with the WITH clause.

Days 26-30: Advanced SQL Concepts and Window


Functions

● Learn:
○ Implementing window functions: ROW_NUMBER(),
RANK(), DENSE_RANK(), LAG(), LEAD().
○ Using CASE statements for conditional logic.
○ Applying CTEs and window functions in complex
queries.

You might also like