Introduction to Database Engineering
- 4.7
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Learn ACID, Indexing, Partitioning, Sharding, Concurrency control, Replication, DB Engines, Best Practices and More!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 skillsets and patterns that you can apply in database engineering. A few of the things that you will learn are Indexing, Partitioning, Sharding, Replication, b-trees in-depth indexing, Concurrency control, database engines and security, and much more.
I believe that learning the fundamentals of database engineering will equip you with the necessary means to tackle difficult and challenging problems yourself. I always compare engineering to math, you never memorize specific formulas and equations, you know the basic proves and derive and solve any equation one throws at you. Database engineering is similar, you can't possibly say MongoDB is better than MySQL or Postgres is better than Oracle. Instead, you learn your use case and by understanding how each database platform does its own trade-offs you will be able to make optimal decisions.
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 of each engine.
Requirements
- Requirements
- Basic understanding of database systems
- Basic SQL knowledge
Knowledge
- 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
Hussein Nasser
4.7 Raiting
The Complete Android Developer Course: Beginner To Advanced!
- 4.3
-
![]()
![]()
![]()
![]()
![]()
In this complete course students will learn how to build and develop Android Applications for smartphone and beyond Welcome To The Complete Android Developer Course: Beginner To Advanced...
How You Can Master the Fundamentals of Transact-SQL
- 0.0
-
![]()
![]()
![]()
![]()
![]()
A Real World Introduction to Transact-SQL COURSE REVIEWS: "This is a great course- I would fully recommend completing it. "Finest experience with Udemy they explain each and everything so clearly....
Calculus: Single Variable Part 2 - Differentiation
- 4.8
-
![]()
![]()
![]()
![]()
![]()
Calculus is one of the grandest achievements of human thought, explaining everything from planetary orbits to the optimal size of a city to the periodicity of a heartbeat....
Introduction to Web Development with HTML, CSS, JavaScript
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Want to take the first steps to become a Cloud Application Developer? You’ll then focus on the languages you need for front-end development, working with HTML, CSS, and JavaScript....
