Introduction to Database Engineering
What you'll learn
- Learn and understand ACID Properties
- Database Indexing
- Database Partitioning
- Database Replication
- Concurrency Control (Optimistic, Pessimistic)
- Database Sharding
- 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 (TLS, Homomorphic Encryption etc.)
Course content
- Preview06:36
- Preview00:37
- Preview01:40
- Preview02:31
- 02:39Atomicity
- 20:35Isolation
- 13:06Consistency
- 01:44Durability
- 15:07Eventual Consistency
Requirements
- Basic understanding of database systems
Description
Database Engineering is a very interesting sector in software engineering. If you are interested in learning about database engineering you have come to the right place. I have curated this course carefully to discuss one of the main concepts of database engineering.
This course will not teach you SQL or programming languages, however, it will teach you skillset and patterns that you can apply in database engineering. A few of the things that you will learn are Indexing, Partitioning, Sharding, Replication, Concurrency control, database engines and security, and much more.
Database engines or storage engines or sometimes even called embedded databases is a software library that a database management software uses to store data on disk and do CRUD (create update delete) Embedded means move everything in one software no network client-server. In this video course, I want to go through the few popular database engines, explain the differences between them and finally I want to spin up a database and change its engine and show the different features on each engine.
Who this course is for:
- Software Engineers and Database Engineers
Instructor
My name is Hussein and I’m a software engineer. Ever since my uncle gave me my first programming book in 1998 (Learn programming with Visual Basic 2) I discovered that software is my passion. I started my blog, and YouTube channel as an outlet to talk about software.
I specialize in the field of geographic information systems (or GIS). I helped many organizations in different countries implement GIS technology and designed, developed apps to fit their use cases and streamline their workflows since 2005. I wrote five books on Esri ArcGIS technology and I've been an engineer at Esri building cool GIS technologies since 2015.
Between my Software Engineering YouTube channel and Podcast, I have made over 500 hundred pieces of content on different topics of software engineering ranging from proxies, security, networking, and programming. I also discuss recent software news and current events on software.
Using software to solve interesting problems is one of the fascinating things I really enjoy. Feel free to contact me on my social media channels to tell your software story, ask questions or share interesting problems. I would love to hear it!