This repository contains a selection of SQL queries to retrieve and analyze information from the 1999 Czech Financial Database, a real anonymized database of Bank Transactions, and the Sakila Sample Database from a Movie Rental Store.
If you landed here by accident or because you are interested in SQL, you can also use the material in this repository to refresh your knowledge and the syntax of SQL. The SQL statements documented here are related to the following topics: Functions, DateTime, Data Cleaning, Operators, Main clauses, Aggregations, Window Functions, Rank, Joins, Joins on Multiple Temporary Tables and Cross and Self-Joins. You can also find here some SQL cheat sheet that clearly synthesized the syntax of the queries.
- More information about the 1999 Czech Financial Database
- To download the Sakila Sample Database
- SQL cheat sheet with common SQL statements
- SQL Cheat Sheet with fundamentals calculations
The queries documented in this repository were created during my training in Data Analytics at Ironhack - Berlin. Some of them were modified by the tutors and/or colleagues during the lessons and exercises, and thus they are part of an organic learning process.Please fork and make a change if you believe there are better ways to complete the exercises or if you want to contribute to expanding this documentation.Likewise, if you believe some queries or material provided here should be removed, please contact me.