Fundamentals of Database Engineering

Focused View

Hussein Nasser

25:16:42

75 View

01 - Course Updates

001 Welcome to the Course.mp4

06:36

002 Course Note 1.mp4

00:37

003 Course Note 2.mp4

07:36

004 Course Note 3.mp4

09:24

005 Note about Docker.html

006 Slides.html

02 - ACID

001 ACID-Updated.pdf

001 ACID-Updated.pptx

001 Introduction to ACID.mp4

03:54

001 acid-updated.zip

002 What is a Transaction.mp4

13:34

003 Atomicity.mp4

10:04

004 Isolation.mp4

31:53

005 Consistency.mp4

12:41

006 Durability.mp4

12:12

007 ACID by Practical Examples.mp4

21:21

008 Phantom Reads.mp4

07:35

009 Serializable vs Repeatable Read.mp4

08:17

009 read.pdf

010 Eventual Consistency.mp4

14:33

010 Eventual-Consistency.pdf

010 Eventual-Consistency.pptx

010 eventual-consistency.zip

03 - Understanding Database Internals

001 How tables and indexes are stored on disk (MUST WATCH before continue).mp4

21:03

001 How-tables-and-indexes-are-stored-on-disk.pdf

001 How-tables-and-indexes-are-stored-on-disk.pptx

001 how-tables-and-indexes-are-stored-on-disk.zip

002 Row-Based vs Column-Based Databases.mp4

34:15

002 Row-Based-vs-Column-Based-Databases.pdf

002 Row-Based-vs-Column-Based-Databases.pptx

002 row-based-vs-column-based-databases.zip

002 row-based-vs-column-based-databases-1.zip

003 Primary Key vs Secondary Key - What you probably didnt know.mp4

10:56

004 Databases Pages (Article).html

04 - Database Indexing

001 Create Postgres Table with a million Rows (from scratch).mp4

04:22

001 one-million-pg.txt

002 Getting Started with Indexing.mp4

18:18

002 employees.zip

003 Understanding The SQL Query Planner and Optimizer with Explain.mp4

10:16

003 grades.zip

004 1.zip

004 2.zip

004 Bitmap Index Scan vs Index Scan vs Table Scan.mp4

11:24

005 Key vs Non-Key Column Database Indexing.mp4

17:02

005 students.zip

006 Index Scan vs Index Only Scan.mp4

08:08

007 Combining Database Indexes for Better Performance.mp4

14:07

008 How Database Optimizers Decide to Use Indexes.mp4

11:19

008 multiple-indexes.pdf

009 Create Index Concurrently - Avoid Blocking Production Database Writes.mp4

03:10

010 Bloom Filters.mp4

09:18

010 bloom-filter.pdf

010 bloom-filter.pptx

010 bloom-filter.zip

011 Working with Billion-Row Table.mp4

13:08

012 Article - The Cost of Long running Transactions.html

013 Article - Microsoft SQL Server Clustered Index Design.html

013 SQL-Server-Index-Architecture-and-Design-Guide-SQL-Server-Microsoft-Docs.pdf

05 - B-Tree vs B+Tree in Production Database Systems

001 B-Tree Sections Introduction & Agenda.mp4

03:34

001 B-trees-vs-B-trees.pdf

001 B-trees-vs-B-trees.pptx

001 b-trees-vs-b-trees.zip

001 b-tree-original-paper.pdf

002 Full Table Scans.mp4

03:27

003 Original B-Tree.mp4

04:46

004 How the Original B-Tree Helps Performance.mp4

07:57

005 Original B-Tree Limitations.mp4

06:31

006 B+Tree.mp4

06:17

007 B+Tree DBMS Considerations.mp4

04:27

008 B+Tree Storage Cost in MySQL vs Postgres.mp4

04:45

009 B-Tree Sections Summary.mp4

01:07

06 - Database Partitioning

001 Introduction to Database Partitioning.mp4

01:26

001 Partitioning.pdf

001 Partitioning.pptx

001 Partitioning.txt

001 partitioning.zip

002 What is Partitioning.mp4

03:28

003 Vertical vs Horizontal Partitioning.mp4

02:07

004 Partitioning Types.mp4

01:32

005 The Difference Between Partitioning and Sharding.mp4

02:43

006 Preparing Postgres, Database, Table, Indexes.mp4

05:22

007 Execute Multiple Queries on the Table.mp4

01:18

008 Create and Attach Partitioned Tables.mp4

03:46

009 Populate the Partitions and Create Indexes.mp4

03:59

010 Class Project - Querying and Checking the Size of Partitions.mp4

05:32

011 The Advantages of Partitioning.mp4

04:41

012 The Disadvantages of Partitioning.mp4

02:48

013 Section Summary - Partitioning.mp4

01:10

014 How to Automate Partitioning in Postgres.mp4

10:06

014 automate-partitions.zip

07 - Database Sharding

001 Introduction to Database Sharding.mp4

01:06

001 Sharding.pdf

001 Sharding.pptx

001 Sharding.txt

001 commands.txt

001 links-code-commands.txt

001 sharding.zip

002 What is Database Sharding.mp4

03:31

003 Consistent Hashing.mp4

02:41

004 Horizontal partitioning vs Sharding.mp4

01:08

005 Sharding with Postgres.mp4

01:05

006 Spin up Docker Postgres Shards.mp4

07:23

007 Writing to a Shard.mp4

21:58

008 Reading from a Shard.mp4

11:19

009 Advantages of Database Sharding.mp4

01:59

010 Disadvantages of Database Sharding.mp4

03:33

011 Database Sharding Section Summary.mp4

00:45

012 When Should you consider Sharding your Database.mp4

20:06

08 - Concurrency Control

001 Shared vs Exclusive Locks.mp4

11:04

002 Dead Locks.mp4

05:31

003 Two-phase Locking.mp4

07:08

004 Solving the Double Booking Problem (Code Example).mp4

13:42

004 booking-system.zip

005 Double Booking Problem Part 2 ( Alternative Solution and explination).mp4

17:49

006 SQL Pagination With Offset is Very Slow.mp4

09:09

006 offset.mp4

00:39

006 offset.pdf

006 offset.zip

007 Database Connection Pooling.mp4

10:50

external-links.txt

09 - Database Replication

001 Introduction to Database Replication.mp4

01:19

001 Replication.pdf

001 Replication.pptx

001 postgres-volumes.zip

001 replication.zip

002 MasterStandby Replication.mp4

03:45

003 Multi-master Replication.mp4

01:23

004 Synchronous vs Asynchronous Replication.mp4

03:06

005 Replication Demo with Postgres 13.mp4

19:20

005 postgres-volumes.zip

006 Pros and Cons of Replication.mp4

03:28

10 - Database System Design

001 Twitter System Design Database Design.mp4

01:11:56

002 Building a Short URL System Database Backend.mp4

37:50

11 - Database Engines

001 Introduction.mp4

02:44

002 Database-Engines.pdf

002 Database-Engines.pptx

002 What is a Database Engine.mp4

06:41

002 database-engines.zip

003 MyISAM.mp4

06:49

004 InnoDB.mp4

06:45

005 XtraDB.mp4

02:06

006 SQLite.mp4

03:44

007 Aria.mp4

02:27

008 BerkeleyDB.mp4

02:40

009 LevelDB.mp4

06:20

010 RocksDB.mp4

04:05

011 Popular Database Engines.mp4

02:31

012 Switching Database Engines with mySQL.mp4

17:08

external-links.txt

12 - Database Cursors

001 What are Database Cursors.mp4

09:31

002 Server Side vs Client Side Database Cursors.mp4

01:44

003 Inserting Million Rows with Python in Postgres using Client Side Cursor.mp4

03:29

004 Querying with Client Side Cursor.mp4

04:42

005 Querying with Server Side Cursor.mp4

01:25

006 Pros and Cons of Server vs Client Side Cursors.mp4

04:38

007 Article - Server Side Cursor Types in SQL Server.html

007 SQLServer-ServerSide-Cursor-Types.pdf

external-links.txt

13 - SQL vs NoSQL Architecture

001 MongoDB Architecture.mp4

43:24

002 MongoDB Internals.html

003 MemCached In-Memory database Architecture.html

14 - Database Security

001 How to Secure Your Postgres Database by Enabling TLSSSL.mp4

12:01

002 Deep Look into Postgres Wire Protocol with Wireshark.mp4

14:07

003 Deep Look Into MongoDB Wire Protocol with Wireshark.mp4

24:04

004 What is the Largest SQL Statement that You can Send to Your Database.mp4

09:44

005 Best Practices Working with REST & Databases.mp4

06:53

006 Database Permissions and Best Practices for Building REST API.mp4

23:40

15 - Homomorphic Encryption - Performing Database Queries on Encrypted Data

001 Homomorphic-Encryption.pdf

001 Homomorphic-Encryption.pptx

001 Homomorphic-Encryption.txt

001 Introduction to Homomorphic Encryption.mp4

01:52

001 commands.txt

001 homomorphic-encryption.zip

002 What is Encryption.mp4

01:29

003 Why Cant we always Encrypt.mp4

04:32

004 What is Homomorphic Encryption.mp4

05:00

005 Homomorphic Encryption Demo.mp4

00:35

006 Clone and Build the Code.mp4

02:35

007 Going Through the Code and the Database.mp4

01:05

008 Searching The Encrypted Database.mp4

03:11

009 Is Homomorphic Encryption Ready.mp4

02:30

16 - Answering your Questions

001 Heap Index scan instead of Index only scan why.mp4

12:54

002 What is the unit of the Cost in Postgres Planner.mp4

06:15

003 All Isolation Levels - Explained Details.mp4

26:08

004 Snapshot and Repeatable Read Isolation difference.mp4

07:55

005 I have an Index why is the database doing a full table scan.mp4

07:37

006 Why Databases Read Pages instead of Rows.mp4

11:02

007 How does Indexing a column with duplicate values work.mp4

10:53

008 Should I drop unused indexes.mp4

08:45

009 Why use serializable Isolation Level when we have SELECT FOR UPDATE.mp4

06:59

010 Can I use the same database connection for multiple clients.mp4

07:00

011 Do I need a transaction if Im only reading.mp4

15:47

012 Why does an update in Postgres touches all indexes.mp4

23:49

013 What is the value of bitmap index scan.mp4

25:45

014 What does Explain Analyze actually do.mp4

19:37

015 Postgres vs MySQL (The fundamental differences).html

17 - Database Discussions

001 WAL, Redo and Undo logs.mp4

39:10

002 SELECT COUNT () can impact your Backend Application performance, here is why.mp4

10:37

003 How Shopify Switched from UUID as Primary Key.mp4

31:22

004 How does the Database Store Data On Disk.mp4

18:55

005 Is QUIC a Good Protocol for Databases.mp4

12:15

006 What is a Distributed Transaction.mp4

21:28

007 Hash Tables and Consistent Hashing.mp4

49:22

008 Indexing in PostgreSQL vs MySQL.mp4

13:01

009 Why Uber Moved from Postgres to MySQL (Discussion).mp4

47:13

010 Can NULLs Improve your Database Queries Performance.mp4

21:12

010 NULL.pdf

011 Write Amplification Explained in Backend Apps, Database Systems and SSDs.mp4

21:15

012 Optimistic vs Pessmistic Concurrency Control.mp4

17:36

013 Postgres Locks - A Deep Dive.html

18 - Archived Lectures

001 ACID.pdf

001 ACID.pptx

001 Introduction to ACID (Archived).mp4

01:39

001 acid.zip

002 What is a Transaction (Archived).mp4

02:31

003 Atomicity (Archived).mp4

02:39

004 Isolation (Archived).mp4

20:35

005 Consistency (Archived).mp4

13:06

006 Durability (Archived).mp4

01:44

Description

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

What You'll 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

Who is this for?

Software Engineers and Database Engineers

What You Need to Know?

Have worked with databases before but wish to get deeper understanding

Basic SQL knowledge

More details

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.

Who this course is for:
Software Engineers and Database Engineers

User Reviews

Rating

average 0

Total votes0

Focused display

My name is Hussein and I’m a software engineer. My software journey started around 1998 when my uncle gave me a book titled `Learn Programming and Visual Basic 2.0`. That book made me realized that I enjoy the craft of building software. Using every medium available I would talk about software in a form of bulletin boards, blogs, books, courses, podcasts, and videos.These days I run a YouTube channel where I cover software engineering topics with a focus on backend tech. I discuss databases, proxies, security, networking, protocols, and programming. I also cover recent news and current events in the field of software.I specialize in the field of geographic information systems (or GIS for short). Since 2005, I helped many organizations in the Middle East implement Esri GIS by designing and building mapping apps to streamline their workflows. I wrote five books on Esri’s technologies and I've been a principal engineer there since 2015.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 ask questions or share interesting problems. I would love to hear it!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.