Fundamentals of Database Engineering

سرفصل های دوره

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

01 - Course Updates

001 Welcome to the Course

002 Course Note 1

003 Course Note 2

004 Course Note 3

005 Note about Docker.html

006 Slides.html

02 - ACID

001 ACID-Updated.pdf

001 ACID-Updated.pptx

001 Introduction to ACID

001 acid-updated.zip

002 What is a Transaction

003 Atomicity

004 Isolation

005 Consistency

006 Durability

007 ACID by Practical Examples

008 Phantom Reads

009 Serializable vs Repeatable Read

009 read.pdf

010 Eventual Consistency

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)

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

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

004 Databases Pages (Article).html

04 - Database Indexing

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

001 one-million-pg.txt

002 Getting Started with Indexing

002 employees.zip

003 Understanding The SQL Query Planner and Optimizer with Explain

003 grades.zip

004 1.zip

004 2.zip

004 Bitmap Index Scan vs Index Scan vs Table Scan

005 Key vs Non-Key Column Database Indexing

005 students.zip

006 Index Scan vs Index Only Scan

007 Combining Database Indexes for Better Performance

008 How Database Optimizers Decide to Use Indexes

008 multiple-indexes.pdf

009 Create Index Concurrently - Avoid Blocking Production Database Writes

010 Bloom Filters

010 bloom-filter.pdf

010 bloom-filter.pptx

010 bloom-filter.zip

011 Working with Billion-Row Table

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

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

003 Original B-Tree

004 How the Original B-Tree Helps Performance

005 Original B-Tree Limitations

006 B+Tree

007 B+Tree DBMS Considerations

008 B+Tree Storage Cost in MySQL vs Postgres

009 B-Tree Sections Summary

06 - Database Partitioning

001 Introduction to Database Partitioning

001 Partitioning.pdf

001 Partitioning.pptx

001 Partitioning.txt

001 partitioning.zip

002 What is Partitioning

003 Vertical vs Horizontal Partitioning

004 Partitioning Types

005 The Difference Between Partitioning and Sharding

006 Preparing Postgres, Database, Table, Indexes

007 Execute Multiple Queries on the Table

008 Create and Attach Partitioned Tables

009 Populate the Partitions and Create Indexes

010 Class Project - Querying and Checking the Size of Partitions

011 The Advantages of Partitioning

012 The Disadvantages of Partitioning

013 Section Summary - Partitioning

014 How to Automate Partitioning in Postgres

014 automate-partitions.zip

07 - Database Sharding

001 Introduction to Database Sharding

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

003 Consistent Hashing

004 Horizontal partitioning vs Sharding

005 Sharding with Postgres

006 Spin up Docker Postgres Shards

007 Writing to a Shard

008 Reading from a Shard

009 Advantages of Database Sharding

010 Disadvantages of Database Sharding

011 Database Sharding Section Summary

012 When Should you consider Sharding your Database

08 - Concurrency Control

001 Shared vs Exclusive Locks

002 Dead Locks

003 Two-phase Locking

004 Solving the Double Booking Problem (Code Example)

004 booking-system.zip

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

006 SQL Pagination With Offset is Very Slow

006 offset

006 offset.pdf

006 offset.zip

007 Database Connection Pooling

external-links.txt

09 - Database Replication

001 Introduction to Database Replication

001 Replication.pdf

001 Replication.pptx

001 postgres-volumes.zip

001 replication.zip

002 MasterStandby Replication

003 Multi-master Replication

004 Synchronous vs Asynchronous Replication

005 Replication Demo with Postgres 13

005 postgres-volumes.zip

006 Pros and Cons of Replication

10 - Database System Design

001 Twitter System Design Database Design

002 Building a Short URL System Database Backend

11 - Database Engines

001 Introduction

002 Database-Engines.pdf

002 Database-Engines.pptx

002 What is a Database Engine

002 database-engines.zip

003 MyISAM

004 InnoDB

005 XtraDB

006 SQLite

007 Aria

008 BerkeleyDB

009 LevelDB

010 RocksDB

011 Popular Database Engines

012 Switching Database Engines with mySQL

external-links.txt

12 - Database Cursors

001 What are Database Cursors

002 Server Side vs Client Side Database Cursors

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

004 Querying with Client Side Cursor

005 Querying with Server Side Cursor

006 Pros and Cons of Server vs Client Side Cursors

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

002 MongoDB Internals.html

003 MemCached In-Memory database Architecture.html

14 - Database Security

001 How to Secure Your Postgres Database by Enabling TLSSSL

002 Deep Look into Postgres Wire Protocol with Wireshark

003 Deep Look Into MongoDB Wire Protocol with Wireshark

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

005 Best Practices Working with REST & Databases

006 Database Permissions and Best Practices for Building REST API

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

001 commands.txt

001 homomorphic-encryption.zip

002 What is Encryption

003 Why Cant we always Encrypt

004 What is Homomorphic Encryption

005 Homomorphic Encryption Demo

006 Clone and Build the Code

007 Going Through the Code and the Database

008 Searching The Encrypted Database

009 Is Homomorphic Encryption Ready

16 - Answering your Questions

001 Heap Index scan instead of Index only scan why

002 What is the unit of the Cost in Postgres Planner

003 All Isolation Levels - Explained Details

004 Snapshot and Repeatable Read Isolation difference

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

006 Why Databases Read Pages instead of Rows

007 How does Indexing a column with duplicate values work

008 Should I drop unused indexes

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

010 Can I use the same database connection for multiple clients

011 Do I need a transaction if Im only reading

012 Why does an update in Postgres touches all indexes

013 What is the value of bitmap index scan

014 What does Explain Analyze actually do

015 Postgres vs MySQL (The fundamental differences).html

17 - Database Discussions

001 WAL, Redo and Undo logs

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

003 How Shopify Switched from UUID as Primary Key

004 How does the Database Store Data On Disk

005 Is QUIC a Good Protocol for Databases

006 What is a Distributed Transaction

007 Hash Tables and Consistent Hashing

008 Indexing in PostgreSQL vs MySQL

009 Why Uber Moved from Postgres to MySQL (Discussion)

010 Can NULLs Improve your Database Queries Performance

010 NULL.pdf

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

012 Optimistic vs Pessmistic Concurrency Control

013 Postgres Locks - A Deep Dive.html

18 - Archived Lectures

001 ACID.pdf

001 ACID.pptx

001 Introduction to ACID (Archived)

001 acid.zip

002 What is a Transaction (Archived)

003 Atomicity (Archived)

004 Isolation (Archived)

005 Consistency (Archived)

006 Durability (Archived)

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy