[go: up one dir, main page]
Scribd
Upload
139 views10 pages

SQL Learning Plan To Become Data Analytics Pro

This 6-week SQL learning plan outlines a curriculum to become proficient in SQL and data analytics. The plan covers introductory SQL concepts in week 1, the SELECT statement in week 2, aggregate functions and grouping in week 3, joins and subqueries in week 4, data modification and management in week 5, and advanced topics and data visualization in week 6. The document recommends practicing on online SQL editors and the Leetcode platform. It also offers 1:1 mentorship sessions to gain real-world experience in data analytics.

Uploaded by

chetan topre
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
139 views10 pages

SQL Learning Plan To Become Data Analytics Pro

This 6-week SQL learning plan outlines a curriculum to become proficient in SQL and data analytics. The plan covers introductory SQL concepts in week 1, the SELECT statement in week 2, aggregate functions and grouping in week 3, joins and subqueries in week 4, data modification and management in week 5, and advanced topics and data visualization in week 6. The document recommends practicing on online SQL editors and the Leetcode platform. It also offers 1:1 mentorship sessions to gain real-world experience in data analytics.

Uploaded by

chetan topre
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/ 10

Manoj Kumar

Become a
Data Analytics Pro
With This
6-Week SQL
Learning Plan

https://www.linkedin.com/in/mk-analytics
Manoj Kumar

Week 1:
Introduction to SQL

Get familiar with basic concepts and


terminology such as databases, tables,
columns, rows and data types
basic structure of SQL statements
performing simple queries

(e.g. SELECT * FROM Customers)

https://www.linkedin.com/in/mk-analytics/
Manoj Kumar

Where do I practise it ?

To practise, try online SQL editor


of SQL Tutorial (w3schools.com)

https://www.linkedin.com/in/mk-analytics/
Manoj Kumar

Week 2:
Explore SELECT Statement

Get familiar with basic concepts and


terminology such as databases, tables,
columns, rows and data types
Learn basic structure of SELECT statements
Column selection
Top N / LIMIT N
Distinct
Performing simple queries

e.g. SELECT TOP 5 * FROM Customers

https://www.linkedin.com/in/mk-analytics/
Manoj Kumar

Week 3:
Aggregate functions and GROUP
BY

Using aggregate functions such as SUM,


AVG and COUNT to perform calculations
on
data Grouping data using the GROUP BY
clause i.e. average age by country.
Using the HAVING clause to filter
grouped data
Pivoting and unpivoting data for
analysis

SELECT Country, AVG(Age)


FROM Customers
GROUP BY Country

https://www.linkedin.com/in/mk-analytics/
Manoj Kumar

Week 4:
JOINs and subqueries

JOINS: Combining data from multiple


tables using JOINs, such as Left, right, Inner,
Outer joins.

SUB QUERY: Retrieving data from multiple


tables using subqueries

SELECT c.Name, c.Email


FROM Customers AS c
left JOIN Orders AS o ON c.ID =
o.CustomerID

https://www.linkedin.com/in/mk-analytics/
Manoj Kumar

Week 5:
Data modification and
database management
Modifying data in a database such as
inserting, updating and deleting
Database management tasks such
creating tables and indexing.

SELECT c.Name, c.Email FROM


Customers AS c left JOIN Orders AS o
ON c.ID = o.CustomerID;

https://www.linkedin.com/in/mk-analytics/
Manoj Kumar

Week 6:

Advanced SQL concepts and data


visualization

Focus on advanced SQL concepts such as


views, stored procedures, and triggers.
Optimizing SQL queries for performance
Using SQL to retrieve data for visualization
in tools like Power BI or Excel

https://www.linkedin.com/in/mk-analytics/
Manoj Kumar

Time to Practise:
Sign up on Leetcode and take up their free
SQL study plan and start solving
problems!

https://leetcode.com/study-plan/sql

https://www.linkedin.com/in/mk-analytics/
Manoj Kumar

Looking for Real-World


Experience in Data
Analytics/BI?

DM me on LinkedIn to know more


Or
Use 'Book a 1:1 call' link in my profile bio

https://www.linkedin.com/in/mk-analytics

You might also like