The Data Seminar

Managing data:

Database Management Systems (DBMS)

Week-01

• AuthZ vs AuthN

• SQL vs NoSQL

• Understanding Nosql records/documents

• JSON vs BSON https://www.mongodb.com/basics/bson

• Hands on MongoDB and Mongo-Express

• Hands on Mariadb and Adminer

• SQLite and https://sqlitebrowser.org

Week-02

• Indexing, Transactions, Isolation levels and Table locks in SQL
• What are file descriptors and how do they relate to DB performance
• MariaDB types of db replication
• MariaDB async and semi-sync replication exercise

Week-03

• MariaDB Configuration, logging, monitoring
• MariaDB Backup and Recovery
• Data Partitioning, Sharding and Replicasets
• CAP theorem in NoSQL, Distributed system/database
• Consistent Hashing and Quorums in NoSQL

SQL vs. NoSQL: Understanding the differences

• What is SQL
• What is NoSQL
• Why do we need a Schema?
• Schema on read (SQL) versus Schema on Write (NoSQL)

JSON and BSON

https://www.mongodb.com/basics/bson

primitive datastores

• store stuff in a file, sqlite

database systems

• Trade-offs Between SQL and NoSQL:

• Analyzing the trade-offs in performance, scalability, and consistency

• Use cases best suited for SQL vs. NoSQL

Deep Dive into NoSQL Databases:

• Types of NoSQL databases: Key-Value, Document, Column, Graph

• Popular NoSQL databases: MongoDB, Redis, Cassandra

• Real-world applications of NoSQL

NoSQL Database Uses in Scalability and High Availability

(WHY use NoSQL)

• Scalability challenges and solutions in NoSQL

• High availability concepts in NoSQL databases

• Replication and sharding

Enterprise Solutions and NoSQL (HOWs and WHYs):

• Overview of enterprise NoSQL solutions: Aerospike, Cassandra, Elasticsearch etc

• How enterprises utilize NoSQL for performance and scalability

System Design Concepts around NoSQL

• Data modeling for NoSQL databases

• Indexing strategies in NoSQL

• Partitioning and sharding in detail

Database Internals:

• Understanding the internals of SQL and NoSQL databases

• Storage engines: How data is stored and retrieved

• The role of caching in database performance

Distributed Systems and Databases:

• Fundamentals of distributed systems

• The role of databases in distributed architectures

• current trends in distributed databases

Cache databases

• How do Cache databases work.

• How to implement Redis.