وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

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)
  • 53,700 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 20715
    حجم: 12264 مگابایت
    مدت زمان: 1517 دقیقه
    تاریخ انتشار: 15 مهر 1402
    طراحی سایت و خدمات سئو

    53,700 تومان
    افزودن به سبد خرید