Are you completely new to SQL and do not know where to start?
Here is a simple concept roadmap for learning SQL as a complete beginner:
๐งต
Here is a simple concept roadmap for learning SQL as a complete beginner:
๐งต
1. ๐๐๐๐ซ๐ง ๐ญ๐ก๐ ๐๐๐ฌ๐ข๐๐ฌ:
- Primary Key vs Foreign Key
- Data Types
- Database diagrams
- Tables
- Records and Fields
- Naming standards for tables and fields
- Primary Key vs Foreign Key
- Data Types
- Database diagrams
- Tables
- Records and Fields
- Naming standards for tables and fields
2. ๐๐๐ญ๐ซ๐ข๐๐ฏ๐ข๐ง๐ ๐๐๐ญ๐ ๐ฐ๐ข๐ญ๐ก ๐๐๐๐๐๐:
- Learn how to write SELECT ๐ค๐ฐ๐ญ๐ถ๐ฎ๐ฏ(๐ด) FROM ๐ต๐ข๐ฃ๐ญ๐ฆ
- Combine with other keywords: WHERE, ORDER BY & LIMIT
- Learn how to use arithmetic operators in SELECT statement
- Retrieve unique values with DISTINCT keyword
- Learn how to write SELECT ๐ค๐ฐ๐ญ๐ถ๐ฎ๐ฏ(๐ด) FROM ๐ต๐ข๐ฃ๐ญ๐ฆ
- Combine with other keywords: WHERE, ORDER BY & LIMIT
- Learn how to use arithmetic operators in SELECT statement
- Retrieve unique values with DISTINCT keyword
3. ๐๐๐๐ซ๐ง ๐ญ๐จ ๐๐๐๐ ๐ญ๐๐๐ฅ๐๐ฌ
- Learn the four basic JOINS (INNER JOIN, FULL OUTER JOIN, LEFT JOIN, RIGHT JOIN)
- Study the Venn Diagrams behind each type of JOIN
- Understand relationship types (one-to-one, one-to-many, many-to-many)
- JOIN multiple tables
- Learn the four basic JOINS (INNER JOIN, FULL OUTER JOIN, LEFT JOIN, RIGHT JOIN)
- Study the Venn Diagrams behind each type of JOIN
- Understand relationship types (one-to-one, one-to-many, many-to-many)
- JOIN multiple tables
4. ๐๐๐๐ซ๐ง ๐๐๐ญ๐ ๐๐ ๐ ๐ซ๐๐ ๐๐ญ๐ข๐จ๐งย
- GROUP BY statement
- SUM, AVG, COUNT, MAX, MIN, ect....
- Learn the difference between WHERE vs HAVING
- GROUP BY statement
- SUM, AVG, COUNT, MAX, MIN, ect....
- Learn the difference between WHERE vs HAVING
5. ๐๐๐๐ซ๐ง ๐ฆ๐จ๐ซ๐ ๐๐๐ฏ๐๐ง๐๐๐ ๐๐จ๐ง๐๐๐ฉ๐ญ๐ฌ
- Learn how to use CASE-WHEN statement
- Common Table Expressions (CTEs)
- Write subqueries in SELECT, WHERE & FROM clauses to retrieve data based on condition or calculation
- Write subqueries in tandem with Aggregate Fn
- Learn how to use CASE-WHEN statement
- Common Table Expressions (CTEs)
- Write subqueries in SELECT, WHERE & FROM clauses to retrieve data based on condition or calculation
- Write subqueries in tandem with Aggregate Fn
The concepts in the above roadmap will be enough #SQL knowledge required for most entry-level data analyst reporting positions. More SQL knowledge would be required for an entry-level database developer or data engineer role
Source - Drew Zeimetz
#DataScience #MachineLearning
Source - Drew Zeimetz
#DataScience #MachineLearning
๐นIf this thread was helpful to you
1. Follow me @Sachintukumar
for daily content
2. Connect with me on Linkedin: linkedin.com
3. RT tweet below to share it with your friend
1. Follow me @Sachintukumar
for daily content
2. Connect with me on Linkedin: linkedin.com
3. RT tweet below to share it with your friend
Loading suggestions...