Niket Kedia Profile picture
Jan 19 11 tweets 5 min read
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 Image
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 Image
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.

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Niket Kedia

Niket Kedia Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @niketkedia

Feb 18
Few amazing SQL experts and industry leaders to follow on Twitter and learn from them.

Do follow them 👇
🌟Aaron Nelson - @SQLvariant
🌟Andrea Allred - @RoyalSQL
🌟Andy Yun - @SQLBek
🌟Angela Henry - @SQLSwimmer
🌟Bradley Ball - @SQLBalls
🌟Brent Ozar - @BrentO
🌟Data Science Renee - @BecomingDataSci
🌟Elizabeth Noble - @SQLZelda
🌟Itzik Ben-Gan - @ItzikBenGan
🌟Jonathan Kehayias - @SQLPoolBoy
🌟Kalen Delaney - @sqlqueen
Read 5 tweets
Feb 9
⭐Continuing the #DataScience learning path series and next skill is Python
⭐There always been a debate around R v/s Python
⭐Step by step learning path for Python for data analysis
1⃣ Intro to Python -

⭐Installing and Setting up environment
⭐Install Anaconda and Python
⭐Launch a Jupyter Notebook
⭐Variables and Operators
⭐Booleans and Comparisons
⭐expressions and statements
2⃣ Basics of Python -

⭐Functions, Modules and strings
⭐Lists, Tuples, Sets, and Dictionaries
⭐Installing a Package (Pandas, Scipy, NumPy,Plotly etc.)
Read 9 tweets
Jan 31
There are 2 kind of skills needed in any job.
1. Hard skills
2. Soft skills

Data science is no different and require hard and soft skills as equal in any of the industry.

Few of the skills needed in Data Science.

Check it here 👇
⚙️ Hard Skills
💡 Programming and Specific tools skills (R, Python, SAS etc.)
💡 Algorithm, Mathematics, Statistics and Probability knowledge
💡 End to end data science project life cycle(Gathering, Cleaning, Preparing, Modelling and presenting)
💡 Upgrading to new technologies
🔣 Soft skills -
💡 Effective Communication
💡 Business acumen and knowledge
💡 Curiosity and Critical thinking
💡 Intuition
💡 Problem solving
💡 Presentation/storytelling
💡 Awareness/research
💡 Flexibility
💡 Time management
💡 Attention to detail
💡 Networking
Read 4 tweets
Jan 30
Few amazing R experts and industry leaders to follow on Twitter and learn Data Science from them.

Twitter is free university. Do follow and learn from them.

👇Follow them
🌟Alastair Rushworth - @rushworth_a
🌟Alison Presmanes Hill - @apreshill
🌟Allison Horst - @allison_horst
🌟Amelia McNamara - @AmeliaMN
🌟Caitlin Hudon - @beeonaposy
🌟Cédric Scherer - @CedScherer
🌟Elaine McVey - @eamcvey
🌟Emily Riederer - @EmilyRiederer
🌟flotsam - @researchremora
🌟Georgios Karamanis - @geokaramanis
🌟Gina Reynolds - @EvaMaeRey
🌟Hadley Wickham - @hadleywickham
🌟Isabella Velásquez - @ivelasq3
🌟Jenny Bryan - @JennyBryan
🌟Keith McNulty - @dr_keithmcnulty
🌟Kelly Bodwin - @KellyBodwin
Read 7 tweets
Jan 26
It is Estimated to have 11,000,000+ job openings 🚀in Data Science industry by 2026.

Building is portfolio to stand out is absolutely necessary.

Tips to build your #datascience portfolio. A Thread 🧵 Image
1. GitHub Profile - @github
▶️Over 65 million developers and more than 3 million companies use GitHub . GitHub says that 72% of Fortune 50 companies use the site.
▶️ There is always debate about GitHub over blog. I started with blog and later created GitHub profile
1.1 GitHub Profile - @github
▶️A crucial part of data science jobs is to be able to code, and GitHub serves as a perfect platform to access the coding skills and display hands-on ability to solve problems.
▶️If you are beginner or a student @github is must to stand out
Read 15 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

:(