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
4. SQL SubQueries & Temporary Tables
SubQuery can be complex and difficult to understand but if you see the entire output as a table and picture every Subquery as a table that needs to be brought together to get a single table, you might just have an easy ride
#SQLOnBirdApp
SubQuery can be complex and difficult to understand but if you see the entire output as a table and picture every Subquery as a table that needs to be brought together to get a single table, you might just have an easy ride
#SQLOnBirdApp
5. Data Cleaning in SQL
Leveraging on what you've learnt from 1-4 above, you can combine this to clean data better, converting and transforming Date Value, Missing Data analysis, etc..
#SQLOnBirdApp
Leveraging on what you've learnt from 1-4 above, you can combine this to clean data better, converting and transforming Date Value, Missing Data analysis, etc..
#SQLOnBirdApp
6. Now moving to the advance stage "SQL Windows Functions"
Windows Functions allow you to compare one row to another without doing any joins. This concept is powerful.
#SQLOnBirdApp
Windows Functions allow you to compare one row to another without doing any joins. This concept is powerful.
#SQLOnBirdApp
7. Advanced SQL JOINs and Query Performance Tuning
Writing Optimal queries is powerful.
This is what different interview test cases are testing.
Beyond having a query that runs successfully, it will be exposed to several use cases to validate if it's optimal.
#SQLOnBirdApp
Writing Optimal queries is powerful.
This is what different interview test cases are testing.
Beyond having a query that runs successfully, it will be exposed to several use cases to validate if it's optimal.
#SQLOnBirdApp
I will recommend you check your knowledge for the above listed areas and make sure you understand and can defend them one by one.
You can know where to better focus when addressing your learning needs.
I cannot overemphasized PRACTICING.
you need to practice everyday if possible
You can know where to better focus when addressing your learning needs.
I cannot overemphasized PRACTICING.
you need to practice everyday if possible
Another site will be mode.com
There are several other great SQL resources out there like Danny Ma SQL 8 Weeks Challenge.
#SQLOnBirdApp
There are several other great SQL resources out there like Danny Ma SQL 8 Weeks Challenge.
#SQLOnBirdApp
I will also recommend this course
udacity.com/course/sql-for…
Feel free to add to this thread resources and tips that help you in your SQL journey
#SQLOnBirdApp
udacity.com/course/sql-for…
Feel free to add to this thread resources and tips that help you in your SQL journey
#SQLOnBirdApp
• • •
Missing some Tweet in this thread? You can try to
force a refresh
