Black Friday 2024: 25+ Ways to Save on Online Learning
Database Engineering

Database Engineering

Hussein Nasser via YouTube Direct link

Watch out before Adding Indexes to Your Table, Your Database Optimizer Might not Use them

66 of 96
Previous
Next

66 of 96

Watch out before Adding Indexes to Your Table, Your Database Optimizer Might not Use them

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Database Engineering

Automatically move to the next video in the Classroom when playback concludes
  1. 1 Relational Database ACID Transactions (Explained by Example)
  2. 2 B-Tree vs B+Tree in Production Database Systems
  3. 3 Key vs Non-Key Column Database Indexing
  4. 4 SELECT COUNT (*) can impact your Backend Application Performance, here is why
  5. 5 Column vs Row Oriented Databases Explained
  6. 6 Can you get Eventual Consistency in Relational Databases?
  7. 7 Database Indexing Explained (with PostgreSQL)
  8. 8 Indexing in PostgreSQL vs MySQL
  9. 9 Explain Explained in PostgreSQL - How Databases Prepare Optimal Query Plans to Execute SQL
  10. 10 Is SELECT * Expensive?
  11. 11 Bloom Filters Explained by Example
  12. 12 Database Partitioning Crash Course (with Postgres)
  13. 13 Horizontal vs Vertical Database Partitioning
  14. 14 Database Replication Crash Course ( with Postgres 13 )
  15. 15 Database Engines Crash Course (MyISAM, Aria, InnoDB, XtraDB, LevelDB & RocksDB)
  16. 16 Database Sharding Crash Course (with Postgres examples)
  17. 17 Avoid premature Database Sharding
  18. 18 Pessimistic concurrency control vs Optimistic concurrency control in Database Systems Explained
  19. 19 Two Phase Locking Explained (2PL)
  20. 20 Redis In-memory Database Crash Course
  21. 21 Spinning MongoDB, MongoShell and Mongo GUI with Docker
  22. 22 Database Exclusive lock vs Shared Lock (Explained by Example)
  23. 23 Connection Pooling in PostgresSQL with NodeJS (Performance Numbers)
  24. 24 Building a Web API with Express and PostgreSQL to Consume from Browser
  25. 25 IndexedDB Crash Course with Javascript
  26. 26 Postgres Database Cursors in Python with psycopg2
  27. 27 Database Dead Locks Explained by Example
  28. 28 Step by Step Javascript and Postgres Tutorial using node-postgres
  29. 29 Step-by-Step Python and Postgres Tutorial with psycopg2
  30. 30 Spinning multiple Postgres instances and PGAdmin with Docker
  31. 31 Step by Step Mysql 8.x and Javascript Tutorial (with mysql2 NodeJs)
  32. 32 What is a Distributed Transaction in Microservices?
  33. 33 How to Avoid Double Booking and Race Conditions in Online Web Applications
  34. 34 Multi-player System Game Design - Pros & Cons of Proposed Designs & System Design Interviews Advice
  35. 35 When should you shard your database?
  36. 36 Can the QUIC Protocol improve Database Performance in Web Applications?
  37. 37 URL Shortener System Design (Explained with Two proposed Designs with Pro and Cons of each)
  38. 38 How Do Databases Store Tables on Disk? Explained both SSD & HDD
  39. 39 Concurrent Requests and Unique Keys on Web Applications
  40. 40 Carnegie Mellon University Advanced Database Course Is a GREAT resource for Backend Engineers!
  41. 41 Keep your Servers Close and Your Database Closer
  42. 42 What is the Largest SQL Query We can Send Before The Database Process Crashes?
  43. 43 MariaDB vs MySQL SSD NVMe vs SATA Performance - Discussions on the Percona Benchmark
  44. 44 What caused the cold start performance “dip” in MariaDB .. Let us discuss (@Percona Article)
  45. 45 Best Practices Working with Billion-row Tables in Databases
  46. 46 Index Scan vs Index Only Scan on Database Systems (with Postgres)
  47. 47 Why Discord Moved from MongoDB to Apache Cassandra, Let us Discuss
  48. 48 PostgreSQL 13 Has Some Performance Boosts! Let us discuss it!
  49. 49 Opening Old Wounds - Why Uber Engineering Switched from Postgres to MySQL
  50. 50 Why Redis Became the Most Popular Database on the Cloud in 2020
  51. 51 Basic Caching Techniques Explained - Spatial, Temporal, Distributed, Write-Through, Write-Back,Aside
  52. 52 Will AWS Babelfish Succeed in Moving Developers Away from SQL Server to Postgres?
  53. 53 Meet mySQL RAPID - distributed, in-memory, columnar, query processing engine by ORACLE
  54. 54 Combining Database Indexes for Better Performance in Your Backend Applications (with PostgreSQL)
  55. 55 don’t use “offset” in your SQL
  56. 56 Burned by Docker and it was my fault
  57. 57 Bitmap Index Scan in Postgres Explained with Examples (Members only)
  58. 58 Is EventStoreDB the First Native gRPC Database?
  59. 59 Create Index Blocking Production Database Writes? Postgres Solves this with this trick
  60. 60 How to Automate Partitioning in Postgres
  61. 61 UUIDs are Bad for Performance in MySQL - Is Postgres better? Let us Discuss
  62. 62 Redis In-Memory Database Crash Course
  63. 63 Phantom Reads in Postgres Explained Compared to Other DBMS
  64. 64 Serializable vs Repeatable Read Isolation Level - When to use one over the other in Database Systems
  65. 65 How Database Cursors Help in Fetching Large Result sets from your SQL
  66. 66 Watch out before Adding Indexes to Your Table, Your Database Optimizer Might not Use them
  67. 67 Write Amplification Explained in Backend Apps, Database Systems and SSDs
  68. 68 Can NULLs Improve your Database Queries Performance? - The Backend Engineering Show
  69. 69 SELECT COUNT(*) is Slow, Estimate it Instead (with Example in Node JS and Postgres)
  70. 70 Auth0 MongoDB Gets Overloaded Causes an Major Outage
  71. 71 The Tale of OLTP, OLAP, and HTAP in Data Warehousing - The Backend Engineering Show
  72. 72 Optimizing Communication and Networking in Database Systems - The Backend Engineering Show
  73. 73 The New Postgres 14 Looks Promising - The Backend Engineering Show with Hussein Nasser
  74. 74 Primary Key vs Secondary Key - What you probably didn't know (Members ONLY)
  75. 75 All Types of Database Replication Discussed
  76. 76 My thoughts on the CAP theorem
  77. 77 B-tree vs B+ tree in Database Systems
  78. 78 Should you go with an Optimistic or Pessimistic Concurrency Control Database?
  79. 79 Can Redis be used as a Primary database?
  80. 80 Turns out MySQL Statement-based Replication might not be a good idea, Lets discuss why
  81. 81 Partial Indexing | The Backend Engineering Show
  82. 82 Update your database statistics often or your SQL queries will suffer #shorts
  83. 83 Table Clustering in MySQL and Postgres - The pros and cons
  84. 84 How Redis efficiently snapshots gigabytes of memory to disk (forking)
  85. 85 backend leaking Postgres database connections - what I did to fix it
  86. 86 on graph databases
  87. 87 On Graph Databases | The Backend Engineering Show
  88. 88 The cost rolling back transactions (postgres/mysql)
  89. 89 when indexes are useless | The Backend Engineering Show
  90. 90 What is the cost of Indexing too many columns - Udemy Q&A November 2021
  91. 91 Postgres index bloat | The Backend Engineering Show
  92. 92 what is a database index?
  93. 93 The limitations of today’s SSDs | The Backend Engineering Show
  94. 94 Why this query is fast
  95. 95 Redo, Undo and WAL logs | The Backend Engineering Show
  96. 96 Sorting in Postgres 15 is 371% faster in certain cases

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.