System Design Essentials: Storage And Database Fundamentals

Database fundamentals, Storage concepts, system design

What you'll learn

Basics of storage component from system design perspective

Understand database as subset of storage components

Feature based classification of databases to ensure students can select the appropriate one for thier use cases.

Mapping any storage solution to absolute fundamentals.

Requirements

No programming exprience is needed. But having some exprience will make applying the knowledege easier.

Description

Welcome to Storage and Database Fundamentals in System Design, a concise and engaging one-hour course designed specifically for early-stage software professionals. In this course, we'll introduce you to the core concepts of storage systems and databases, equipping you with the foundational knowledge needed to make informed decisions in your software development journey.Our course is structured as a series of bite-sized, reel-style lectures that are easy to follow and highly engaging. By the end of this course, you'll have a solid understanding of storage and database fundamentals and be ready to explore more advanced topics in system design.Course Outline:Introduction to System Design and StorageThe Role of Storage in system designTypes of storage: Volatile and Non-VolatileStorage hierarchy and trade-offsDatabase BasicsWhat is a database and why do we need it?Database components: tables, schemas, and indexesKey database operations: CRUD (Create, Read, Update, Delete)Types of DatabasesRelational Databases: Concepts and examplesNoSQL Databases: Types and use casesData Storage and Retrieval TechniquesIndexingPartitioning: Horizontal and Vertical partitioningSharding and ReplicationKey Factors to Consider in Database SelectionScalabilityConsistencyAvailabilityData ModelResources and Next StepsRecommended books, articles, and online resourcesPopular database management toolsExploring advanced topics in storage and databasesBy the end of this course, you will be better prepared to choose the right storage solutions and database systems for your projects. You will also be able to identify resources for further study to deepen your understanding and enhance your skills in system design. Enroll now and embark on your journey toward becoming a proficient software professional!

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Data and Stack

Lecture 3 Data and Heap

Lecture 4 Storing data on disks

Lecture 5 Data storage formats

Section 2: Introduction to Database as storage systems

Lecture 6 Are databases silver bullets when it comes to storing information or data?

Lecture 7 In database and storage, Need for Speed is the ultimate game!

Lecture 8 The feature and requirements for persisting the data

Lecture 9 Storing information as Key Value pairs

Lecture 10 Storing data as collection of fields

Section 3: ACID Properites: The must knows for every developer and software tester

Lecture 11 Section Introduction

Lecture 12 ACID properties

Lecture 13 Atomicity : A in the ACID

Lecture 14 Consistency : C in ACID

Lecture 15 Isolation : I in ACID

Lecture 16 Durability : D in ACID

Lecture 17 Transcations in Databases

Lecture 18 SQL doesnot mean Relational Database!

Section 4: Types of Databases

Lecture 19 Types of Databases

Lecture 20 Relational Database

Lecture 21 Key Value Stores

Lecture 22 Document Databases

Lecture 23 Wide Column Databstores

Lecture 24 Graph Databases

Lecture 25 Time Series Databases

Lecture 26 Search Index

Section 5: Types of database deployments

Lecture 27 Section introduction

Lecture 28 Database server instances

Lecture 29 Embededded Databases

Lecture 30 Replication in databases. Primary-Secorndary, Master-Master

Section 6: Database Nuances and additional features

Lecture 31 Section Introduction

Lecture 32 SQL : Facts, Myths and Pitfalls

Lecture 33 Horizontal Scaling vs Vertical Scaling?

Lecture 34 Sharding data vs Partitioning Data?

Lecture 35 Storage Engine: Row Store, Column store

Lecture 36 Indexes in databases

Lecture 37 Query Tuning for getting optimal performance from databases

Lecture 38 Concept Read Heavy Vs Write Heavy, Change Data Capture

Section 7: Conclusion

Lecture 39 Closing Remarks, Multi Version Concurrency Control, Snapshot Isolation

Lecture 40 [Bonus Lecture]

Begineer software developers curious about storage technologies.,Computer science students eager to learn production technologies.,Software developers seeking fundamental preparation material for system design interview.