Storage and Database Fundamentals for Novice Programmers
- Description
- Curriculum
- FAQ
- Reviews
Welcome to “System Design Essentials: Storage and Database Fundamentals” – a concise and engaging one-hour course designed specifically for early-stage software professionals. Gain foundational knowledge in storage systems and databases to make informed decisions throughout your software development journey.
Unlock the Core Concepts of Storage and Database Systems
In this course, you will:
– Get introduced to essential storage and database concepts
– Explore various types of storage and their trade-offs
– Understand the role of databases and their components
– Learn about different database systems and their use cases
– Discover data storage and retrieval techniques
– Identify key factors for database selection
Course Highlights: Engaging, Bite-sized Lectures
Our course is structured as a series of reel-style lectures, making it easy to follow and highly engaging. By the end of this course, you’ll have a solid understanding of storage and database fundamentals, preparing you to explore more advanced topics in system design.
What You Will Learn:
1. Introduction to System Design and Storage: The role of storage in system design, types of storage, storage hierarchy, and trade-offs
2. Database Basics: What is a database, its components, key database operations (CRUD), and why databases are essential, ACID properties
3. Types of Databases: Relational and NoSQL databases, their concepts, examples, and use cases
4. Data Storage and Retrieval Techniques: Indexing, partitioning, sharding, and replication
5. Key Factors in Database Selection: Scalability, consistency, availability, and data model
6. Resources and Next Steps: Recommended books, articles, online resources, popular database management tools, and advanced topics to explore
Upon completing this course, you’ll be better equipped to choose the right storage solutions and database systems for your projects. Plus, you’ll have access to resources for further study, deepening your understanding and enhancing your skills in system design. Enroll now and embark on your journey toward becoming a proficient software professional!
-
6Are databases silver bullets when it comes to storing information or data?Video lesson
-
7In database and storage, Need for Speed is the ultimate game!Video lesson
-
8The feature and requirements for persisting the dataVideo lesson
-
9Storing information as Key Value pairsVideo lesson
-
10Storing data as collection of fieldsVideo lesson
-
11Section IntroductionVideo lesson
-
12ACID propertiesVideo lesson
-
13Atomicity : A in the ACIDVideo lesson
-
14Consistency : C in ACIDVideo lesson
-
15Isolation : I in ACIDVideo lesson
-
16Durability : D in ACIDVideo lesson
-
17Transcations in DatabasesVideo lesson
-
18SQL doesnot mean Relational Database!Video lesson
-
31Section IntroductionVideo lesson
-
32SQL : Facts, Myths and PitfallsVideo lesson
-
33Horizontal Scaling vs Vertical Scaling?Video lesson
-
34Sharding data vs Partitioning Data?Video lesson
-
35Storage Engine: Row Store, Column storeVideo lesson
-
36Indexes in databasesVideo lesson
-
37Query Tuning for getting optimal performance from databasesVideo lesson
-
38Concept Read Heavy Vs Write Heavy, Change Data CaptureVideo lesson

External Links May Contain Affiliate Links read more