kwohyuno 2023. 2. 20. 22:45

 

1.ACID 

-Transaction

-Atomicity

-Isolation

-Consistency

-Durability

-ACID by Practical Examples

-Phantom Reads

-Serializable vs Repeatable Read

-Eventual Consistency

 

2.Understanding Database Internals

-How tables and indexes are stored on disk

-Row-Based vs Column-Based Databases

-Primary Key vs Secondary Key 

 

3.Database Indexing

4.B-Tree vs B+Tree in Production Database Systems

5.Database Partitioning

6.Database Sharding

7.Concurrency Control

8.Database Replication

9.Database System Design

10.Database Engines

11.Database Cursors

12.Database Security 

13.Homomorphic Encryption - Performing Database Queries on Encrypted Data