Introduction to Database Engineering
- Description
- Curriculum
- FAQ
- Reviews
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.
-
10
Getting Started with Indexing -
11
Key vs Non-Key Column Database Indexing
-
12
Index Scan vs Index Only Scan
-
13
Combining Database Indexes for Better Performance
-
14
Horizontal vs Vertical Partitioning
-
15
Database Partitioning (With Postgres)
-
16
Database Sharding (With Postgres)
-
17
Bloom Filters
-
18
Working with Billion-Row Table
-
19
When to Shard your Database?
-
25
Introduction to Database Replication
Scripts and commands
docker run --name pgmaster -v /Users/HusseinNasser/postgres/v/master_data:/var/lib/postgresql/data -p 5432:5432 -e POSTGRES_PASSWORD=postgres -d postgres
docker run --name pgstandby -v /Users/HusseinNasser/postgres/v/standby_data:/var/lib/postgresql/data -p 5433:5432 -e POSTGRES_PASSWORD=postgres -d postgres
In standby node update postgresql.conf
primary_conninfo = 'application_name=standby host=husseinmac port=5432 user=postgres password=postgres’
add file standby.signal
touch standby.signal
In master update postgresql.conf
first 1 (standby1)
select * from pg_stat_replication
-
26
Master/Standby Replication
-
27
Multi-master Replication
-
28
Synchronous vs Asynchronous Replication
-
29
Replication Demo with Postgres 13
-
30
Pros and Cons of Replication
-
33
Introduction
Database engines or storage engines or sometimes even called embedded databases is software library that a database management software uses to store data on disk and do CRUD (create update delete)
Resources
https://youtu.be/V_C-T5S-w8ghttps://mariadb.com/kb/en/library/changes-improvements-in-mariadb-102/
https://mariadb.com/kb/en/library/why-does-mariadb-102-use-innodb-instead-of-xtradb/
https://github.com/facebook/rocksdb/wiki/Features-Not-in-LevelDB
https://mariadb.com/kb/en/library/aria-storage-engine/
https://dev.mysql.com/doc/refman/8.0/en/innodb-index-types.html https://eng.uber.com/mysql-migration/
-
34
What is a Database Engine?
-
35
Row-Based vs Column-Based Databases
-
44
Most Popular Database Engines
-
45
Switching Database Engine with mySQL
Using docker we will spin up a mySQL database instance and then create two tables with myISAM and one InnoDB and demonstrate the difference.
Code here.
https://github.com/hnasr/javascript_playground/tree/master/mysql_transaction_myisam_innodb
-
46
How to Secure Your Postgres Database by Enabling TLS/SSL
-
47
Deep Look into Postgres Wire Protocol with Wireshark
-
48
Deep Look Into MongoDB Wire Protocol with Wireshark
-
49
Encrypted Database Search with Homomorphic Encryption (IBM technology)
-
50
Best Practices Working with REST & Databases
-
51
Database Permissions and Best Practices for Building REST API
-
52
What is the Largest SQL Statement that You can Send to Your Database
