SQL…

Article on ETL
SQL…
Photo by Evgeni Tcherkasski on Unsplash

SQL is a definite requirement for anyone who is interested in doing data work. Here are some basics from work I have done:

  1. Basic Selects With Where
  2. Subqueries in the Select and Where Clauses
  3. Basic Selects With Order By and Limit
  4. Selects with Aggregations With Group By
  5. Selects with Aggregations with Group By and Having
  6. Window Functions
  7. Joins
  8. Unions
  9. Common Table Expression (CTE)
  10. Recursive CTE

This is a preview of Clap Button, a new feedback and analytics tools for Hydejack, built by yours truly. You can try it out on localhost for free, but it will be removed (together with this message) when building with JEKYLL_ENV=production. To use Clap Button on your site, get a subscription
and set clap_button: true in your config file.

This site is a modified version of Hydejack v9.1.4 created by Erin Wills.