Enrolment options
- Enrolled students: There are no students enrolled in this course.
Guests cannot access this course. Please log in.
Course content
Sections:
1
•
Activities:
1
•
Resources:
143
- Announcements
- 001 Welcome to the Course GW4Y gitir
- 002 Course Note 1 PWf1 gitir
- 003 Course Note 2 XAL3 gitir
- 004 Course Note 3 fvT3 gitir
- 007 Introduction to ACID iIq7 gitir
- 008 What is a Transaction QLQO gitir
- 009 Atomicity YxgM gitir
- 010 Isolation yfjs gitir
- 011 Consistency Wx2I gitir
- 012 Durability Yhkj gitir
- 013 ACID by Practical Examples 4WbY gitir
- 014 Phantom Reads fGYx gitir
- 015 Serializable vs Repeatable Read 5HiE gitir
- 016 Eventual Consistency ZrYe gitir
- 018 How tables and indexes are stored on disk MUST WATCH before continue tVSo gitir
- 019 Row Based vs Column Based Databases EJu2 gitir
- 020 Primary Key vs Secondary Key What you probably didn t know WT7C gitir
- 022 Create Postgres Table with a million Rows from scratch TLQM gitir
- 023 Getting Started with Indexing zOoO gitir
- 024 Understanding The SQL Query Planner and Optimizer with Explain rTVw gitir
- 025 Bitmap Index Scan vs Index Scan vs Table Scan Vmne gitir
- 026 Key vs Non Key Column Database Indexing XOWQ gitir
- 027 Index Scan vs Index Only Scan JWf0 gitir
- 028 Combining Database Indexes for Better Performance Aozl gitir
- 029 How Database Optimizers Decide to Use Indexes hscF gitir
- 030 Create Index Concurrently Avoid Blocking Production Database Writes 47Ti gitir
- 031 Bloom Filters BFLb gitir
- 032 Working with Billion Row Table fdt2 gitir
- 036 B Tree Section s Introduction Agenda MFKb gitir
- 037 Full Table Scans Qr0w gitir
- 038 Original B Tree ICUA gitir
- 039 How the Original B Tree Helps Performance 9hEE gitir
- 040 Original B Tree Limitations t4TN gitir
- 041 B Tree FnIn gitir
- 042 B Tree DBMS Considerations w7ZR gitir
- 043 B Tree Storage Cost in MySQL vs Postgres Ur7b gitir
- 044 B Tree Section s Summary gFXN gitir
- 045 Introduction to Database Partitioning r0P8 gitir
- 046 What is Partitioning Ubi5 gitir
- 047 Vertical vs Horizontal Partitioning r0Jv gitir
- 048 Partitioning Types VFm3 gitir
- 049 The Difference Between Partitioning and Sharding fnxU gitir
- 050 Preparing Postgres Database Table Indexes vrsb gitir
- 051 Execute Multiple Queries on the Table xWPh gitir
- 052 Create and Attach Partitioned Tables jH5L gitir
- 053 Populate the Partitions and Create Indexes yLOh gitir
- 054 Class Project Querying and Checking the Size of Partitions DLna gitir
- 055 The Advantages of Partitioning 1EKL gitir
- 056 The Disadvantages of Partitioning oZws gitir
- 057 Section Summary Partitioning LiCT gitir
- 058 How to Automate Partitioning in Postgres ciLi gitir
- 059 Introduction to Database Sharding qj4i gitir
- 060 What is Database Sharding 5oX3 gitir
- 061 Consistent Hashing 0tyE gitir
- 062 Horizontal partitioning vs Sharding RdaZ gitir
- 063 Sharding with Postgres rbNn gitir
- 064 Spin up Docker Postgres Shards w4ms gitir
- 065 Writing to a Shard nMtX gitir
- 066 Reading from a Shard znna gitir
- 067 Advantages of Database Sharding S08V gitir
- 068 Disadvantages of Database Sharding zXUm gitir
- 069 Database Sharding Section Summary NISA gitir
- 070 When Should you consider Sharding your Database 03Iz gitir
- 071 Shared vs Exclusive Locks ZbEA gitir
- 072 Dead Locks 4frq gitir
- 073 Two phase Locking ugxg gitir
- 074 Solving the Double Booking Problem Code Example I1tl gitir
- 075 Double Booking Problem Part 2 Alternative Solution and explination 74Og gitir
- 076 SQL Pagination With Offset is Very Slow M9B6 gitir
- 077 Database Connection Pooling SbDJ gitir
- 078 Introduction to Database Replication 2vDN gitir
- 079 Master Standby Replication cYwm gitir
- 080 Multi master Replication RHS9 gitir
- 081 Synchronous vs Asynchronous Replication kGdQ gitir
- 082 Replication Demo with Postgres 13 FNsT gitir
- 083 Pros and Cons of Replication 6Xjf gitir
- 084 Twitter System Design Database Design XAVc gitir
- 085 Building a Short URL System Database Backend m26b gitir
- 086 Introduction 6T1A gitir
- 087 What is a Database Engine j1dz gitir
- 088 MyISAM DsGJ gitir
- 089 InnoDB 2D4v gitir
- 090 XtraDB 27Vg gitir
- 093 BerkeleyDB QwN1 gitir
- 094 LevelDB pXPE gitir
- 095 RocksDB aFU3 gitir
- 096 Popular Database Engines vyeO gitir
- 097 Switching Database Engines with mySQL xUg7 gitir
- 098 What are Database Cursors UWJT gitir
- 099 Server Side vs Client Side Database Cursors hLkV gitir
- 100 Inserting Million Rows with Python in Postgres using Client Side Cursor BnaS gitir
- 101 Querying with Client Side Cursor TgTj gitir
- 102 Querying with Server Side Cursor ofpV gitir
- 103 Pros and Cons of Server vs Client Side Cursors 6c1k gitir
- 105 MongoDB Architecture RdU8 gitir
- 108 How to Secure Your Postgres Database by Enabling TLS SSL RBIe gitir
- 109 Deep Look into Postgres Wire Protocol with Wireshark jJnB gitir
- 110 Deep Look Into MongoDB Wire Protocol with Wireshark wU3W gitir
- 111 What is the Largest SQL Statement that You can Send to Your Database YZ58 gitir
- 112 Best Practices Working with REST Databases GyXj gitir
- 113 Database Permissions and Best Practices for Building REST API FQL3 gitir
- 114 Introduction to Homomorphic Encryption L2QV gitir
- 115 What is Encryption Jvpz gitir
- 116 Why Can t we always Encrypt 9JTu gitir
- 117 What is Homomorphic Encryption l7pz gitir
- 118 Homomorphic Encryption Demo WA4N gitir
- 119 Clone and Build the Code H8B6 gitir
- 120 Going Through the Code and the Database sf69 gitir
- 121 Searching The Encrypted Database dKY0 gitir
- 122 Is Homomorphic Encryption Ready OIiU gitir
- 123 Heap Index scan instead of Index only scan why jcT5 gitir
- 124 What is the unit of the Cost in Postgres Planner KhGa gitir
- 125 All Isolation Levels Explained Details uz4W gitir
- 126 Snapshot and Repeatable Read Isolation difference N3un gitir
- 127 I have an Index why is the database doing a full table scan QAOw gitir
- 128 Why Databases Read Pages instead of Rows RkQS gitir
- 129 How does Indexing a column with duplicate values work Ellx gitir
- 130 Should I drop unused indexes N17t gitir
- 131 Why use serializable Isolation Level when we have SELECT FOR UPDATE gJnI gitir
- 132 Can I use the same database connection for multiple clients IoF7 gitir
- 133 Do I need a transaction if I m only reading Cmdp gitir
- 134 Why does an update in Postgres touches all indexes Tylx gitir
- 135 What is the value of bitmap index scan q6Nx gitir
- 136 What does Explain Analyze actually do iEL2 gitir
- 138 Does Create Index block writes and Why 1ZrQ gitir
- 139 WAL Redo and Undo logs si6r gitir
- 140 SELECT COUNT can impact your Backend Application performance here is why GklR gitir
- 141 How Shopify Switched from UUID as Primary Key gXZa gitir
- 142 How does the Database Store Data On Disk 9yE5 gitir
- 143 Is QUIC a Good Protocol for Databases iQiP gitir
- 144 What is a Distributed Transaction qqyR gitir
- 145 Hash Tables and Consistent Hashing zmln gitir
- 146 Indexing in PostgreSQL vs MySQL DMYU gitir
- 147 Why Uber Moved from Postgres to MySQL Discussion m2Up gitir
- 148 Can NULLs Improve your Database Queries Performance TNsH gitir
- 149 Write Amplification Explained in Backend Apps Database Systems and SSDs DNVZ gitir
- 150 Optimistic vs Pessmistic Concurrency Control Ef8u gitir
- 152 Introduction to ACID Archived xZ50 gitir
- 153 What is a Transaction Archived YEJn gitir
- 154 Atomicity Archived rdLJ gitir
- 155 Isolation Archived EoLI gitir
- 156 Consistency Archived j7pT gitir
- 157 Durability Archived 2IbK gitir