Learn all about databases in this coruse 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:
⭐️ 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 Create Statement
2:44:55 Initialisation, Create Schema Table
2:51:24 Creation of Schema Table
2:55:41 Debugging Select Query
3:06:26 Creation of SQLite Temp Master
3:10:41 Creating Index and Inserting into Schema Table for Primary Key
3:16:36 Not Null and End Creation
3:17:55 Revision
3:22:15 Update Schema Table
3:26:01 Journaling
3:30:11 Finishing Creation of Table
3:35:24 Insertion into Table
3:40:21 Thank You!🎉 Thanks to our Champion and Sponsor supporters:
👾 Drake Milly
👾 Ulises Moralez
👾 Goddard Tan
👾 David MG
👾 Matthew Springman
👾 Claudio
👾 Oscar R.
👾 jedi-or-sith
👾 Nattira Maneerat
👾 Justin Hual
--
Learn to code for free and get a developer job:
Read hundreds of articles on programming:
10 views
312
89
4 weeks ago 00:13:17 1
Stray Cats • “Rumble In Brighton/Storm The Embassy/Stray Cat Strut” • LIVE 1981 [RITY Archive]
2 months ago 00:13:43 1
Cheap Trick • “Need Your Love” (w/ extended solos) • 1979 [Reelin’ In The Years Archive]
2 months ago 00:03:33 1
Little Feat • Interview/ “Rock-n-Roll Doctor” • 1974 [Reelin’ In The Years Archive]
2 months ago 00:07:43 1
The Rolling Stones- “Lady Jane“/Interview/“Paint It Black“ 1966 [Reelin’ In The Years Archive]
2 months ago 00:04:17 1
Amii Stewart • “Knock On Wood” • 1979 [Reelin’ In The Years Archive]
2 months ago 00:05:05 1
Shirley Ellis • “The Name Game“ • 1965 [Reelin’ In The Years Archive]
2 months ago 01:15:17 1
Time is an illusion (lunchtime doubly so) / Andreas Heigl (bitExpert AG)
2 months ago 00:08:45 2
Paul Butterfield & Mike Bloomfield • “Last Night” • 1971 [Reelin’ In The Years Archive]
2 months ago 03:41:20 10
Databases In-Depth – Complete Course
2 months ago 00:06:41 1
Gerry Rafferty- “Baker Street“ LIVE 1978 [Reelin’ In The Years Archives]
2 months ago 00:09:59 1
What Is Your Alien Soul Origin & What Are Starseeds? | Overview | Astral Legends
2 months ago 00:05:32 1
Whitney & Cissy Houston • (“Ain’t No Way/You Send Me“) • LIVE 1983 [Reelin’ In The Years Archive]
3 months ago 00:04:22 1
U2 • Interview (First Tour Of Australia) • 1985 [Reelin’ In The Years Archive]
3 months ago 00:03:19 1
Billie Holiday - “Strange Fruit“ Live 1959 [Reelin’ In The Years Archives]
3 months ago 00:02:48 1
Garth Brooks accused of rape in lawsuit from hair-and-makeup artist | Canada Tonight
3 months ago 00:05:31 1
AI Crypto | AI-driven DePin Roll App | Best Investment
3 months ago 00:06:52 1
Rage Against The Machine • “Freedom” • 1993 [Reelin’ In The Years Archive]
3 months ago 00:03:07 1
Badfinger • “Day After Day” • 1972 [Reelin’ In The Years Archive]
3 months ago 00:10:21 1
Email Extractor Tutorial: Scrape emails from Google Maps & Domains with Leads-Sniper🚀
3 months ago 00:06:22 1
Elvis Costello & The Attractions • “Pump It Up” • 1983 [Reelin’ In The Years Archive]
4 months ago 00:05:19 1
Iron Maiden- “Wasted Years“ on Countdown 1986
4 months ago 00:04:46 1
Mariah Carey • “Love Takes Time” LIVE • 1991 [Reelin’ In The Years Archive]
4 months ago 00:04:45 1
Gateron Smoothie Sound Test | Absolutely Amazing Linear Switches!
4 months ago 00:03:57 1
A-ha • “Take On Me” • 1985 [Reelin’ In The Years Archive]