Resource Zachary Thomas’ SQL Questions: https://lnkd.in/g-JJzuD Select * SQL: https://selectstarsql.com/ Leetcode: https://lnkd.in/g3c5JGC LinkedIn Learning: https://lnkd.in/gQXFc4n Window Functions: https://lnkd.in/g3RtPCJ HackerRank: https://lnkd.in/grv_9sB W3 Schools: https://lnkd.in/gJPfrrv CodeAcademy: https://lnkd.in/gT5xmpN SQLZoo: https://sqlzoo.net/ SQL Bolt: https://sqlbolt.com/ FreeCodeCamp: SQL Tutorial - Full Database Course for Beginners
Join Full Join Inner Join Left Join Right Join Aggregation Function COUNT(). MAX(). MIN(). SUM(). AVG(). The GROUP BY statement groups rows that have the same values into summary rows, like ‘find the number of customers in each country’. The GROUP BY statement is often used with above aggregation functions to group the result-set by one or more columns.
Datasets Gathering the right data is one of the most important task for data engineers. If you are looking for data for your own, self-directed project, or for data to enrich the data for your project, below are some good resources to find interesting datasets. Analytics Google: Dataset Search Kaggle Datasets Github: Awesome Public Datasets Data.gov Dataquest: 18 places to find data sets for data science projects KDnuggets: Datasets for Data Mining and Data Science UCI Machine Learning Repository Reddit: r/datasets/ Software Development Github: Public APIs Last Call: Top 50 Most Popular APIs on RapidAPI (2018) Facebook: Graph API Example This Kaggle dataset is a good example of someone who found disparate datasets and combined them to provide an even more valuable dataset for others to analyze....
Timeline 2023 ~ Present I became a big fan of Learn in Public and on the journey of migrating all my private notes to this blog. 2021 ~ 2023 Eventually, I got tired of managing all the npm libraries dependencies, and decided to migrate with the fastest blog platform - Hugo . At this stage I am pretty happy with the combination of Hugo and PaperMod theme. 2016 ~ 2021 One day I was randomly surfing on the internet, the fancy blog theme NexT immediately caught my eyes, and I decided to migrate everything to Node....