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
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…
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/
w3schools.com/sql/
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
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
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
#SQLOnBirdApp
