README.md

Databases

Welcome to the databases section of my learning journey. Here, you'll find exercises, projects, and valuable knowledge related to databases. Feel free to explore the content, learn from it, and adapt it to your needs. Happy learning!

Topics

1. Foundations of Databases
2. Database Design
3. SQL
4. NoSQL
5. Normalization
6. Denormalization
7. ACID Transactions
8. CAP Theorem
9. Database Security
10. Database Management

Resources

Books

• PAID Database Internals - by Alex Petrov
• PAID Designing Data-Intensive Applications - by Martin Kleppmann
• PAID Database Design for Mere Mortals - by Michael J Hernandez
• PAID Database Management Systems - by Raghu Ramakrishnan
• PAID Seven Databases in Seven Weeks - by Luc Perkins
• PAID SQL Cookbook - by Anthony Molinaro

Courses

• PAID Meta Database Engineer Professional Certificate - by Meta
• PAID IBM Data Engineering Professional Certificate - by IBM
• PAID Google Cloud Database Engineer Specialization - by Google
• PAID Fundamentals of Database Engineering - by Hussein Nasser
• FREE Databases: Relational Databases and SQL - by Stanford
• FREE CS50's Introduction to Databases with SQL - by Harvard
• FREE ASUx: Data Engineering - by Arizona State University
• FREE MichiganX: Database Architecture, Scale, and NoSQL with Elasticsearch - by University of Michegan
• FREE Relational Database - by FreeCodeCamp
• FREE Database Systems Concepts & Design - by Udacity

Articles

• Intro to SQL - Kaggle
• Advanced SQL - Kaggle
• DBMS Tutorial: Learn Database Management System - by GeeksforGeeks
• DBMS Tutorial - by Scaler
• What is a Database? Everything You Need to Know - by SimpliLearn
• SQL Tutorial - W3Schools
• MySQL Tutorial - W3Schools
• PostgreSQL Tutorial - W3Schools
• MongoDB Tutorial - W3Schools

Videos

• What is a Database? - by IBM
• SQL vs NoSQL, What is the Difference? - by IBM
• SQL Databases Explained - by Fireship
• 7 Databases Paradigms - by Fireship
• You need to learn SQL - by NetworkChuck
• SQL Tutorial: Full Course - by FreeCodeCamp
• NoSQL Tutorial: Full Course - by FreeCodeCamp
• PostgreSQL Tutorial - by FreeCodeCamp
• MySQL Course - by BroCode
• MongoDB Tutorial - by BroCode
• Redis Full Course - by FreeCodeCamp

Databases

SQL

• PostgreSQL
• MySQL
• MariaDB
• SQLite
• Oracle Database
• Microsoft SQL Server
• IBM Db2
• Google Cloud SQL
• Amazon RDS
• Amazon Aurora

NoSQL

• MongoDB
• Cassandra
• Couchbase
• CouchDB
• Neo4j
• Redis
• Amazon DynamoDB
• Google Cloud Firestore

Tools

• DBeaver
• DataGrip
• MongoDB Compass
• RedisInsight
• DB Fiddle
• Adminer