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....