Transaction, Isolation Levels and In-Memory OLTP in T-SQL

Learn ACID, Indexing, Partitioning, Sharding, Concurrency control, Replication, DB Engines, Best Practices and More!

Created by: Hussein Nasser
Software Engineer, Author

What Will I Learn?

• Learn and understand ACID Properties
• Database Indexing
• Database Partitioning
• Database Replication
• Database Sharding
• Database Cursors
• Concurrency Control (Optimistic, Pessimistic)
• B-Trees in Production Database Systems
• Database System Designs
• Difference between Database Management System, Database Engine and Embedded database
• Database Engines such as MyISAM, InnoDB, RocksDB, LevelDB and More
• Benefits of Using one database engine over the other
• Switching Database Engines with MySQL
• Database Security
• Homomorphic Encryption

Requirements

• Have worked with databases before but wish to get deeper understanding
• Basic SQL knowledge

Target audience

• Software Engineers and Database Engineers