mikma03/databases

Main purpose of this repository is to generate knowledge about databases in general view.

• Introduction - usefull links
• Learning SQL - interactive
• Databases - courses
• Database articles
• SQL Cheat Sheet
• Leet Code - SQL problems

Introduction - usefull links

• DB-Engines is an initiative to collect and present information on database management systems (DBMS)

  • https://db-engines.com/en/

• Apache Drill

  • https://drill.apache.org/

• Toad by Quest is a database management toolset that database developers, administrators and data analysts

  • https://www.toadworld.com/

• Presto is an open source distributed SQL query engine

  • https://github.com/prestodb/presto

---

Learning SQL - interactive

• Learn SQL with simple, interactive exercises.

  • https://sqlbolt.com/

• Databases Guide - examples and references

  • https://database.guide/

---

Databases - courses

• Database Systems - Cornell University Course - Part 1

  • https://www.youtube.com/watch?v=4cWkVbC2bNE&t=27s

• Database Systems - Cornell University Course - Part 2

  • https://www.youtube.com/watch?v=lxEdaElkQhQ&t=1s

• Complete SQL and Databases Bootcamp

  • https://www.udemy.com/course/complete-sql-databases-bootcamp-zero-to-mastery/

• NoSQL Database Tutorial

  • https://www.youtube.com/watch?v=xh4gy1lbL2k&t=68s

• Modern Big Data Analysis with SQL

  • https://www.coursera.org/specializations/cloudera-big-data-analysis-sql

---

Database articles

• Serverless databases - article
  • https://www.datastax.com/what-is-a-serverless-database?utm_source=developer-newsletter&utm_medium=newsletter&utm_campaign=Dev-Rel-News&utm_term=all-plays&utm_content=44630

---

SQL Cheat Sheet

• InterviewBit

  • https://www.interviewbit.com/sql-cheat-sheet/#sql-functions

• CodeAcademy

  • https://www.codecademy.com/resources/cheatsheets/language/sql

• SQL Tutorials W3

  • https://www.w3schools.com/sql/default.asp

---

Leet Code - SQL problems

• LeetCode Curated SQL 70

  • https://leetcode.com/problem-list/leetcode-curated-sql-70/

• SQL study path

  • https://leetcode.com/study-plan/sql/?progress=x2lpbv3v