003 How Shopify Switched from UUID as Primary Key_part3 - Free IT Course Platform

Skip to content

Course List
Free Ebook
Knowledge Sharing
Search for:

Course Content

Subtitle Guide – Hướng dẫn thêm phụ đề

0/1

Set up subtitle for video – Hướng dẫn thêm phụ đề

01 – Course Updates

0/9

Download Resource Files

001 Welcome to the Course_part1

001 Welcome to the Course_part2

002 Course Note 1

003 Course Note 2_part1

003 Course Note 2_part2

004 Course Note 3_part1

004 Course Note 3_part2

004 Course Note 3_part3

02 – ACID

0/12

Download Resource Files

001 Introduction to ACID

002 What is a Transaction

005 Consistency

007 ACID by Practical Examples_part1

007 ACID by Practical Examples_part2

008 Phantom Reads

009 Serializable vs Repeatable Read

010 Eventual Consistency

03 – Understanding Database Internals

0/5

Download Resource Files

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

002 Row-Based vs Column-Based Databases

003 Primary Key vs Secondary Key – What you probably didn’t know_part1

003 Primary Key vs Secondary Key – What you probably didn’t know_part2

04 – Database Indexing

0/17

Download Resource Files

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

002 Getting Started with Indexing_part1

002 Getting Started with Indexing_part2

003 Understanding The SQL Query Planner and Optimizer with Explain

004 Bitmap Index Scan vs Index Scan vs Table Scan

005 Key vs Non-Key Column Database Indexing_part1

005 Key vs Non-Key Column Database Indexing_part2

006 Index Scan vs Index Only Scan

007 Combining Database Indexes for Better Performance

008 How Database Optimizers Decide to Use Indexes_part1

008 How Database Optimizers Decide to Use Indexes_part2

008 How Database Optimizers Decide to Use Indexes_part3

009 Create Index Concurrently – Avoid Blocking Production Database Writes

010 Bloom Filters

011 Working with Billion-Row Table_part1

011 Working with Billion-Row Table_part2

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

0/10

Download Resource Files

001 B-Tree Section’s Introduction & Agenda

002 Full Table Scans

003 Original B-Tree

004 How the Original B-Tree Helps Performance

005 Original B-Tree Limitations

007 B+Tree DBMS Considerations

008 B+Tree Storage Cost in MySQL vs Postgres

009 B-Tree Section’s Summary

06 – Database Partitioning

0/15

Download Resource Files

001 Introduction to Database Partitioning

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

07 – Database Sharding

0/18

Download Resource Files

001 Introduction to Database Sharding

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_part1

007 Writing to a Shard_part2

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_part1

012 When Should you consider Sharding your Database_part2

012 When Should you consider Sharding your Database_part3

012 When Should you consider Sharding your Database_part4

012 When Should you consider Sharding your Database_part5

08 – Concurrency Control

0/10

Download Resource Files

001 Shared vs Exclusive Locks

003 Two-phase Locking

004 Solving the Double Booking Problem (Code Example)_part1

004 Solving the Double Booking Problem (Code Example)_part2

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

006 SQL Pagination With Offset is Very Slow

007 Database Connection Pooling

09 – Database Replication

0/8

Download Resource Files

001 Introduction to Database Replication

002 MasterStandby Replication

003 Multi-master Replication

004 Synchronous vs Asynchronous Replication

005 Replication Demo with Postgres 13_part1

005 Replication Demo with Postgres 13_part2

006 Pros and Cons of Replication

10 – Database System Design

0/10

Download Resource Files

001 Twitter System Design Database Design_part1

001 Twitter System Design Database Design_part2_part1

001 Twitter System Design Database Design_part2_part2

001 Twitter System Design Database Design_part3

001 Twitter System Design Database Design_part4

001 Twitter System Design Database Design_part5_part1

001 Twitter System Design Database Design_part5_part2

002 Building a Short URL System Database Backend_part1

002 Building a Short URL System Database Backend_part2

11 – Database Engines

0/13

Download Resource Files

001 Introduction

002 What is a Database Engine

011 Popular Database Engines

012 Switching Database Engines with mySQL

12 – Database Cursors

0/7

Download Resource Files

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

13 – SQL vs NoSQL Architecture

0/6

Download Resource Files

001 MongoDB Architecture_part1

001 MongoDB Architecture_part2

001 MongoDB Architecture_part3

001 MongoDB Architecture_part4

001 MongoDB Architecture_part5

14 – Database Security

0/13

Download Resource Files

001 How to Secure Your Postgres Database by Enabling TLSSSL

002 Deep Look into Postgres Wire Protocol with Wireshark_part1

002 Deep Look into Postgres Wire Protocol with Wireshark_part2

003 Deep Look Into MongoDB Wire Protocol with Wireshark_part1

003 Deep Look Into MongoDB Wire Protocol with Wireshark_part2

003 Deep Look Into MongoDB Wire Protocol with Wireshark_part3

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

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

005 Best Practices Working with REST & Databases_part1

005 Best Practices Working with REST & Databases_part2

006 Database Permissions and Best Practices for Building REST API_part1

006 Database Permissions and Best Practices for Building REST API_part2

15 – Homomorphic Encryption – Performing Database Queries on Encrypted Data

0/10

Download Resource Files

001 Introduction to Homomorphic Encryption

002 What is Encryption

003 Why Can’t 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

0/24

Download Resource Files

001 Heap Index scan instead of Index only scan why_part1

001 Heap Index scan instead of Index only scan why_part2

002 What is the unit of the Cost in Postgres Planner

003 All Isolation Levels – Explained Details_part1

003 All Isolation Levels – Explained Details_part2

003 All Isolation Levels – Explained Details_part3

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_part1

007 How does Indexing a column with duplicate values work_part2

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 I’m only reading

012 Why does an update in Postgres touches all indexes_part1

012 Why does an update in Postgres touches all indexes_part2

013 What is the value of bitmap index scan_part1

013 What is the value of bitmap index scan_part2

014 What does Explain Analyze actually do

016 Does Create Index block writes and Why_part1

016 Does Create Index block writes and Why_part2

016 Does Create Index block writes and Why_part3

17 – Database Discussions

0/61

Download Resource Files

001 WAL, Redo and Undo logs_part1

001 WAL, Redo and Undo logs_part2

001 WAL, Redo and Undo logs_part3

001 WAL, Redo and Undo logs_part4

001 WAL, Redo and Undo logs_part5

001 WAL, Redo and Undo logs_part6

001 WAL, Redo and Undo logs_part7

001 WAL, Redo and Undo logs_part8

001 WAL, Redo and Undo logs_part9

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

003 How Shopify Switched from UUID as Primary Key_part1

003 How Shopify Switched from UUID as Primary Key_part2

003 How Shopify Switched from UUID as Primary Key_part3

004 How does the Database Store Data On Disk_part1

004 How does the Database Store Data On Disk_part2

004 How does the Database Store Data On Disk_part3

004 How does the Database Store Data On Disk_part4

005 Postgres Architecture_part1

005 Postgres Architecture_part2

005 Postgres Architecture_part3

005 Postgres Architecture_part4

005 Postgres Architecture_part5

005 Postgres Architecture_part6

006 Is QUIC a Good Protocol for Databases_part1

006 Is QUIC a Good Protocol for Databases_part2

006 Is QUIC a Good Protocol for Databases_part3

007 What is a Distributed Transaction_part1

007 What is a Distributed Transaction_part2

007 What is a Distributed Transaction_part3

007 What is a Distributed Transaction_part4

008 Hash Tables and Consistent Hashing_part1

008 Hash Tables and Consistent Hashing_part2

008 Hash Tables and Consistent Hashing_part3

008 Hash Tables and Consistent Hashing_part4

008 Hash Tables and Consistent Hashing_part5

008 Hash Tables and Consistent Hashing_part6

009 Indexing in PostgreSQL vs MySQL_part1

009 Indexing in PostgreSQL vs MySQL_part2

009 Indexing in PostgreSQL vs MySQL_part3

010 Why Uber Moved from Postgres to MySQL (Discussion)_part1

010 Why Uber Moved from Postgres to MySQL (Discussion)_part2

010 Why Uber Moved from Postgres to MySQL (Discussion)_part3

010 Why Uber Moved from Postgres to MySQL (Discussion)_part4

010 Why Uber Moved from Postgres to MySQL (Discussion)_part5

010 Why Uber Moved from Postgres to MySQL (Discussion)_part6

010 Why Uber Moved from Postgres to MySQL (Discussion)_part7

011 Can NULLs Improve your Database Queries Performance_part1

011 Can NULLs Improve your Database Queries Performance_part2

011 Can NULLs Improve your Database Queries Performance_part3

011 Can NULLs Improve your Database Queries Performance_part4

011 Can NULLs Improve your Database Queries Performance_part5

012 Write Amplification Explained in Backend Apps, Database Systems and SSDs_part1

012 Write Amplification Explained in Backend Apps, Database Systems and SSDs_part2

012 Write Amplification Explained in Backend Apps, Database Systems and SSDs_part3

012 Write Amplification Explained in Backend Apps, Database Systems and SSDs_part4

012 Write Amplification Explained in Backend Apps, Database Systems and SSDs_part5

013 Optimistic vs Pessmistic Concurrency Control_part1

013 Optimistic vs Pessmistic Concurrency Control_part2

013 Optimistic vs Pessmistic Concurrency Control_part3

013 Optimistic vs Pessmistic Concurrency Control_part4

18 – Archived Lectures

0/7

Download Resource Files

001 Introduction to ACID (Archived)

002 What is a Transaction (Archived)

003 Atomicity (Archived)

004 Isolation (Archived)

005 Consistency (Archived)

006 Durability (Archived)

Fundamentals of Database Engineering

Join the conversation

Please contact me via telegram

DMCA.com Protection Status

Quick Links

About us
Contact
Privacy Policy
Terms and Conditions
DCMA
Disclaimer
Search for:

Resource

Course List
Recommend New Courses
For IT Students
Search for:

© 2024 - freestudy247.com