Thread by @niketkedia

Continuing the #learningpath series.
Next skill in #DataScience industry is SQL (One of the most In-Demand Skills )
⭐There are 1,000,000+ jobs available in USA with requirement of SQL as a skill

Step by step learning SQL for data scientists

A thread🧵
#data #datascience #sql

1. SQL Basics
⭐ Creating Tables
⭐ Inserting values
⭐ Adding a New column in the existing Table
⭐ Deleting a Column from a Table
⭐ Deleting the Table

2. SQL start with Commands
⭐ Learn basic SQL commands: SELECT, FROM and WHERE
⭐ Learn logical operators in SQL
⭐ Learn commands: IN , AND, OR, NOT, LIKE, NULL, ISNULL, BETWEEN

3. SQL Joins
⭐ Learn to join different type of joins
⭐ LEFT, RIGHT, INNER, OUTER joins

4. SQL Sorting and Grouping
⭐ Learn GROUP BY , ORDER BY, HAVING

5. SQL Aggregations and Arithmetic operations
⭐ Learn Excel Functions: AVG, COUNT, SUM, MIN, MAX, UPPER, LOWER, LENGTH, REPLACE, TRIM, MID
⭐ Learn to write common aggregations: AVG, COUNT, SUM, MIN and MAX
⭐ Learn to write DATE function
⭐ Mathematical and String Functions

6. SQL Update
⭐ Learn to write CASE
⭐ Learn to write UPDATE statements
⭐ MERGE and UPDATE statements

7. SQL subqueries and Temp Tables
⭐ Learn to write subqueries and multiple queries together
⭐ Learn to use temp tables to access table with more than one query

8. SQL Data cleaning
⭐ Learn to perform data cleaning in SQL
⭐ Learn removing duplicates, removing NULLs
⭐ Learn FIND and REPLACE values

9. SQL Window Functions
⭐ Learn to use WINDOW functions in SQL
⭐ Aggregate Window Functions: SUM(), MAX(), MIN(), AVG(). COUNT()
⭐ Ranking Window Functions: RANK(), DENSE_RANK(), ROW_NUMBER(), NTILE()
⭐ Value Window Functions: LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE()

Replying to
@niketkedia

Thanks for reading

Follow @niketkedia for more threads on #datascience #sql #DataAnalytics #Datavisualization #datafam #pythonlearning and building audience.

analytics-tuts.com

Retweet the first tweet if you liked this.

https://twitter.com/niketkedia/status/1483716559977971712?s=20