MrBomber0x001/db-notes

💾 List of Database notes and exercises from Datacamp, CMU, and others.

Advanced Database Notes [🏗 updated periodically]

For a list of changes, see the CHANGELOG.

Hola :D

This repository was created from the very beginning to serve as a single source of truth for studying databases from both science and technology POV. It should aim to prepare individuals for SQL interviews and provide valuable insights into performance optimization tips.

Contents

• DataCamp Notes and Exercises: Detailed insights and hands-on practice from my DataCamp courses.
• HackerRank Solutions: A compilation of my solutions to HackerRank database challenges.
• Carnegie Mellon University Database Course Notes:
  • Introduction to Database Concepts, Fall 2018: An overview of fundamental database concepts.
  • Advanced Databases, Fall 2018: In-depth exploration of advanced database topics.
• Book Notes: Summaries and key takeaways from the following books:
  • Concise Guide to Databases: A compact yet thorough guide to database fundamentals.
  • T-SQL Fundamentals: Essential knowledge for working with Transact-SQL.
  • Database System Concepts: A comprehensive look at database systems and their underlying concepts.
  • Architecture of Database Systems: Insights into the design and architecture of database systems.
  • Internals of Databases: A deep dive into the inner workings of database management systems.
• ITI DB Notes: Detailed noted related to 10 Days Intensive ITI Database course

Sections

Sections

• Articles
• Carnegie Mellon University Notes
• DataCamp Notes
• ITI DB Notes
• Internals of Databases
• MongoDB
• Problem Solving
• Redis
• Technical Interviews

Additional Focus

Additionally, this repository now includes:

• Redis Notes: Information and best practices for using Redis, the in-memory data structure store.
• MongoDB Notes: Insights and practical examples for working with MongoDB, the document-oriented database.

Database Learning Resources

Courses and Training

• MySQL course covering indexes
• Database Engines
• Relational Internals
• Brentozar training for advanced topics.
• Fundamentals of Database Engineering
• Postgres Scaling - [YouTube]

Books and Articles

• MySQL High Performance (Book)
• Database Internals (Book)
• Redis Explained
• Database Sharding Explained
• PostgreSQL internals
• PostgreSQL vacuum cleaner
• Red Gate Blog

Other Important Resources

• Database Internals: How Distributed Database Systems Work!
• Concise Guide to Database
• Database Systems Concepts

My Articles:

I've written bunch of articles while I was taking Datacamp Career Path "SQL Server Developer":

• Transaction and concurrency control in practice
• Triggers In depth
• Optimizing Trigger for better execution and monitoring
• Definitive Guide to handle your SQL Errors

Star History