Databases In-Depth – Complete Course

Learn all about databases in this course designed to help you understand the complexities of database architecture and optimization. From understanding the foundational components like transaction management and storage engines to mastering advanced indexing techniques and exploring the inner workings of SQLite, this course equips you with the knowledge to efficiently manage and optimize data systems. ✏️ Course developed by @KeertiPurswani Resources: https://register.educosys.com/new-courses/25-databases ❤️ Try interactive Databases courses we love, right in your browser: https://scrimba.com/freeCodeCamp-Databases (Made possible by a grant from our friends at Scrimba) ⭐️ Contents ⭐️ 0:00:00 Coming Up 0:00:49 Intro 0:01:49 Course structure 0:03:56 Client and Network Layer 0:05:39 Frontend Component 0:09:46 About Educosys 0:11:26 Execution Engine 0:12:41 Transaction Management 0:16:59 Storage Engine 0:21:58 OS Interaction Component 0:22:41 Distribution Components 0:25:01 Revision 0:30:14 RAM Vs Hard Disk 0:31:56 How Hard Disk works 0:34:26 Time taken to find in 1 million records 0:37:46 Educosys 0:39:26 Optimisation using Index Table 0:47:11 Multi-level Indexing 0:49:21 BTree Visualisation 0:50:06 Complexity Comparison of BSTs, Arrays and BTrees 0:57:06 Structure of BTree 0:59:56 Characteristics of BTrees 1:06:41 BTrees Vs B+ Trees 1:08:06 Intro for SQLite 1:09:35 SQLite Basics and Intro 1:12:07 MySQL, PostgreSQL Vs SQLite 1:13:05 GitHub and Documentation 1:14:05 Architecture Overview 1:27:48 Educosys 1:29:30 Code structure 1:32:24 Tokeniser 1:35:15 Parser 1:38:33 ByteCode Generator 1:44:25 VDBE 1:52:58 Pager, BTree and OS Layer 1:56:03 Write Ahead Logging, Journaling 2:07:44 Cache Management 2:11:40 Pager in Detail 2:20:00 Pager Code walkthrough 2:25:51 Intro to next section 2:27:41 How to compile, run code, sqlite3 file 2:32:56 Debugging Open DB statement 2:36:13 Educosys 2:37:56 Reading schema while creating table 2:40:14 Tokenisation and Parsing Cre