Fundamentals of Database Engineering
This course will not teach you SQL or programming languages, but it will teach you skillsets and patterns for database engineering. Indexing, Partitioning, Sharding, Replication, b-trees in-depth indexing, Concurrency management, database engines and security, and much more will be covered. They believe that learning the fundamentals of database engineering will provide you with the tools you need to tackle difficult and difficult problems on your own.
They always equate engineering to math, but you never learn specific formulae and equations; you just know how to prove, derive, and solve any equation that comes your way. Database engineering is comparable; you can't argue MongoDB is superior than MySQL or Postgres is superior to Oracle. Instead, you learn your use case and then make optimal judgments by learning how each database platform handles its particular trade-offs.
Another thing you will study in this course is the database engine, which is the lowest database interface that communicates with the operating system. Database engines, also known as storage engines or embedded databases, are software libraries that are used by database management software to store data on disk and perform CRUD operations (create update delete) Embedded means putting everything in one software and eliminating the need for a client-server network. In this video course, they'll go over a few popular database engines, explain the differences between them, and then spin up a database, change its engine, and demonstrate the various features of each engine.
What you will 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
Udemy rating: 4.7/5.0
Enroll here: udemy.com/course/database-engines-crash-course/
