'; ?>

Course Details

Buy source code - Codeintra
Course Image Fundamentals of Database Engineering - Free Course Pro
Author Logo Hussein Nasser

Fundamentals of Database Engineering

Course Info

Category

Development

Total Lectures

157

Total Duration

27 hours

Views

17

Requirements

Have worked with databases before but wish to get deeper understandingBasic SQL knowledge
Free Source Code - Codeintra

Course 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 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.

What you'll learn

Learn and understand ACID PropertiesDatabase IndexingDatabase PartitioningDatabase ReplicationDatabase ShardingDatabase CursorsConcurrency Control (Optimistic, Pessimistic)B-Trees in Production Database SystemsDatabase System DesignsDifference between Database Management System, Database Engine and Embedded databaseDatabase Engines such as MyISAM, InnoDB, RocksDB, LevelDB and MoreBenefits of Using one database engine over the otherSwitching Database Engines with MySQLDatabase SecurityHomomorphic Encryption

Who this course is for

Software Engineers and Database Engineers

Rate this course using proper Emoji expressions

  • 0

  • 0

  • 0

  • 0

  • 0

  • DISCLAIMER

    The courses provided on freecourse.pro are sourced from freely available resources and are not hosted on our platform. We disclaim any responsibility for the usage of these files. The files are intended solely for educational purposes and we strongly discourage any other use. Downloading copyrighted material is against the law. We respect the hard work and effort put in by the course creators, developers, and owners. We strongly urge you to support them by purchasing the genuine version from the official website here.

    Trending Courses

    More