Fundamentals of Database Engineering

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

4.74 (7972 reviews)

Udemy

platform

English

language

Databases

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

Why take this course?

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 the Fundamental 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.

One other thing you will learn in this course is the lowest database interface that talks to the OS which is the database engine. 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.

Enjoy the course.

Screenshots

Fundamentals of Database Engineering - Screenshot_01

Fundamentals of Database Engineering - Screenshot_02

Fundamentals of Database Engineering - Screenshot_03

Fundamentals of Database Engineering - Screenshot_04

Reviews

José

April 5, 2024

The course is really good, it covers a lot of advanced database concepts and Hussein really shows he knows a lot about it. One point that I found lacking in the course is where Hussein, I think wanting to make the subject well explained, ends up rambling a lot in his answers, making the video very long and tiring. Sometimes he also ends up lowering his voice in his explanations, which makes it a little difficult to understand. I also noticed that Hussein keeps the course up to date, revising some videos when necessary, which is excellent. He also answers questions very quickly. Overall, the course is excellent and I recommend it!

Hafiz

April 4, 2024

Good course. But I must say some of these videos, I have already seen on his YouTube channel. They are an exact copy-paste from there to here. Sometimes feel a bit out of context too. But good course overall. I wish he talks a bit more clearly too.

Kirill

March 25, 2024

The only thing I am regret about is not finding thsi course earlier. Course is amazing and helps me a lot to advance in my professional development.

Gurleen

March 25, 2024

Exceptional delivery of knowledge. There may be few exceptional people out there who may be knowing all these stuff but for me it was all so much in detail and new stuff even after working few years on couple of databases. Exceptional so far

Juan

February 27, 2024

Content is good, but it could be condensed in 1/4th of the length of the course. Rather than a full-blown course, a lot of content is just a collection of loosely related DB videos, where instructor vaguely goes into a lot of random details instead of focusing on the actual point of the lesson. For the lessons where the instructor goes straight to the point, the content is really nice, although some quizzes or recaps would be nice to have for a better self-assesment of the content.

Mohammad

February 26, 2024

His information and the course information are unbelievably rich, but the way he introduces it is unbelievably boring, it is my second course with him and the same issue, videos for hours with no examples he opens his cam and tells his information, some videos do not have even a draw or a slide to explain his words, but in general the course content will drive you from zero to a hero in understanding db management

Alon

February 16, 2024

this would be a 3 star unless the final part of the videos , where you shown "notes" which i didnt realy understand at all

Rakesj

February 3, 2024

In the last video, He introduced the course curriculum which seems very exciting and also promising to deliver core knowledge of database I'm very excited.

Sankaranarayanan

January 26, 2024

There are good in-depth explanations of the concepts of database. Knowing the work going behind the scene is really important to optimise the working with databases. In this aspect this course is really useful.

Juan

January 5, 2024

I am completely satisfied with the course. I really liked the instructor's way of explaining, but above all, the approach of understanding the concepts and principles of each topic instead of being a just a tutorial to repeat steps. I strongly believe this is the best approach to truly learn and master the fundamental concepts.

Aditya

January 1, 2024

Easily one of the best courses I have ever had on Udemy. This one deals more on the engineering side of things and that's what makes it different. Appreciate Hussein for all the effort he put into this one. Fantastic work !! Hope you come up with a few more masterpieces

Jack

December 29, 2023

(Note: I am only about 15% through the course so far) I studied data science in college for 4 years. I was comfortable using databases but never covered any internal implementation details for how they work as it was probably more of a computer science topic. This course for me has been a fantastic curation of database concepts and trivia. For every lecture I have probably been able to spend an hour or more googling the terms that get introduced. This course has been doing a great job helping me demystify all of the magic that I thought databases were built on and I can now approach databases as any other piece of software, that can be broken down into parts and understood. The lectures on their own can occasionally be a bit high-level, but there is such a depth of information for free online (which the course at times helpfully links to e.g. the article on pages) that I am still very satisfied with the potential to get a deep understanding of how databases are engineered using this course.

Karim.Albakry

December 21, 2023

There aren't many coerces are discussing these topics, and Hussein expressing them very will and simplify them.

Baher

November 22, 2023

This course is really great. I really learned a lot. What I liked the most, is that Hussein explains everything and its trade-offs. He explains everything to the lowest level. This really encouraged me to buy his other courses.

Harshit

October 22, 2023

Greate course! I would recommend this course to every new engineer starting a job, research or coming out of college. Topics have been covered in great breadth and sufficient depth. Hussein is a great instructor. I've been learning from him for past 2-3 years. His way of looking at software engineering has changed my perspective :)

Charts

Price

Rating

Enrollment distribution

Fundamentals of Database Engineering - Distribution chart