> For the complete documentation index, see [llms.txt](https://meska.gitbook.io/db-notes/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://meska.gitbook.io/db-notes/readme.md).

# README

## Advanced Database Notes \[🏗 updated periodically]

![Untitled Design](https://user-images.githubusercontent.com/42917814/209810128-4d37e43b-a33d-4394-928c-38879c2f3b22.png)

For a list of changes, see the [CHANGELOG](/db-notes/changelog.md).

## 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](/db-notes/articles.md)
* [Carnegie Mellon University Notes](https://github.com/MrBomber0x001/db-notes/blob/main/cmu/README.md)
* [DataCamp Notes](/db-notes/datacamp.md)
* [ITI DB Notes](/db-notes/iti_db_notes.md)
* [Internals of Databases](/db-notes/internals.md)
* [MongoDB](/db-notes/mongodb.md)
* [Problem Solving](https://github.com/MrBomber0x001/db-notes/blob/main/Problem_Solving/README.md)
* [Redis](https://github.com/MrBomber0x001/db-notes/blob/main/redis/README.md)
* [Technical Interviews](https://github.com/MrBomber0x001/db-notes/blob/main/Technical_Interviews/Technical_Interviews.md)

### 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](https://planetscale.com/learn/courses/mysql-for-developers)
* [Database Engines](https://www.udemy.com/course/database-engines-crash-course/?couponCode=ST16MT70224)
* [Relational Internals](https://www.youtube.com/playlist?list=PLE8kQVoC67PzGwMMsSk3C8MvfAqcYjusF)
* [Brentozar training](https://training.brentozar.com/courses) for advanced topics.
* [Fundamentals of Database Engineering](https://www.udemy.com/course/database-engines-crash-course/)
* [Postgres Scaling - \[YouTube\]](https://www.youtube.com/c/ScalingPostgres/videos)

#### Books and Articles

* [MySQL High Performance (Book)](https://www.oreilly.com/library/view/high-performance-mysql/9781492080503/)
* [Database Internals (Book)](https://www.oreilly.com/library/view/database-internals/9781492040330/)
* [Redis Explained](https://architecturenotes.co/p/redis)
* [Database Sharding Explained](https://architecturenotes.co/p/database-sharding-explained)
* [PostgreSQL internals](http://www.interdb.jp/pg/pgsql01.html)
* [PostgreSQL vacuum cleaner](https://www.red-gate.com/simple-talk/databases/postgresql/uncovering-the-mysteries-of-postgresql-auto-vacuum/)
* [Red Gate Blog](https://www.red-gate.com/blog/database-development)

#### Other Important Resources

* [Database Internals: How Distributed Database Systems Work!](https://www.oreilly.com/library/view/database-internals/9781492040330/)
* [Concise Guide to Database](https://www.oreilly.com/library/view/concise-guide-to/9780128043991/)
* [Database Systems Concepts](https://www.db-book.com/)

### My Articles:

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

* [Transaction and concurrency control in practice](https://meska54.hashnode.dev/transactions-concurrency-control-theory-and-practice)
* [Triggers In depth](https://meska54.hashnode.dev/triggers-in-depth-part-2)
* [Optimizing Trigger for better execution and monitoring](https://meska54.hashnode.dev/how-to-properly-optimize-triggers-in-t-sql-part-3)
* [Definitive Guide to handle your SQL Errors](https://meska54.hashnode.dev/how-to-handle-t-sql-errors-efficiently)

### Star History

[![Star History Chart](https://api.star-history.com/svg?repos=MrBomber0x001/db-notes\&type=Date)](https://star-history.com/#MrBomber0x001/db-notes\&Date)