Discover and read the best of Twitter Threads about #sqlonbirdapp

Most recents (2)

SQL Learning Resources Thread
As a Beginner learning Data Analysis, Data Science + SQL, it is always good to connect the dots through projects and use cases.
In this growing thread, I will first share some resources with possible SQL projects to test your skill
#SQLOnBirdApp
It will be good to start with a foundational course. there are lots of resources in this space so I will list them:

Foundation
1. Udacity Free SQL Course: udacity.com/course/sql-for…
2. W3Schools. Don't joke with this site. highly valuable and resourceful. You also have the opportunity of trying out the queries without installing any software on your laptop.
w3schools.com/sql/
Read 10 tweets
Learning SQL can be very interesting if you are just watching video but nay, watching video or reading SQL Blog doesn't take you anywhere.
Structure your learning and practice in this form
1. Basic SQL: select, filter using where, like, in, etc...
#SQLOnBirdApp
2. SQL Joins: focus on learning how to combine data from multiple tables.
I will recommend you learn Set theory and try to solve set questions with 3 subjects involved. It really break down the whole logic and possible relationships.

#SQLOnBirdApp
3. SQL Aggregation: Learn how to aggregate data using functions like SUM, AVG, COUNT, CASE, HAVING, and DATE.

#SQLOnBirdApp
Read 11 tweets

Related hashtags

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.00/month or $30.00/year) and get exclusive features!

Become Premium

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

Donate via Paypal Become our Patreon

Thank you for your support!