Path Category
Loading Path Category from the AllPath API…
ALLPATHFoundationALLPATHFoundationPath Category
Loading Path Category from the AllPath API…
Path Category
Guided learning journeys that build knowledge step by step.
category · Learning · slug · learning · 7812 Paths
7812 Paths · page 415 / 782
A graduate-level learning path exploring the theoretical underpinnings of data modeling, focusing on the relational model, its formal query languages, and the connection to logic. The path progresses from foundational set theory and predicate logic through relational algebra, tuple and domain calculi, and culminates in the nested relational model (NF²), providing a comprehensive formal basis for database theory.
This learning path provides database developers with a comprehensive understanding of in-memory database architecture, focusing on memory-optimized storage, data structures, persistence mechanisms, and comparisons with disk-based systems. It covers the theoretical foundations and practical considerations for designing and using in-memory databases.
A graduate-level learning path for mastering advanced query optimization in database systems. It covers cost models, query execution algorithms, parallel execution, and adaptive optimization, building from foundational concepts to cutting-edge techniques.
This path builds a solid understanding of database security, starting with core SQL and security principles, then advancing through authentication, authorization models (DAC/MAC), SQL injection defense, transparent data encryption (TDE), and auditing. It is designed for university students and professionals seeking a career in database administration or security.
This advanced learning path equips database architects with the knowledge to design and implement data replication and sharding strategies in distributed database systems. It covers core distributed database concepts, replication models, consistency guarantees, sharding techniques, and distributed query processing, culminating in architectural decision-making.
This learning path provides a systematic journey through the architecture and challenges of distributed databases, covering core concepts such as data fragmentation, replication, the CAP theorem, and distributed transactions. It is designed for advanced database students who already have a solid foundation in database systems and networking, and it emphasizes the fundamental principles and trade-offs involved in building and operating distributed data systems.
This learning path introduces the core concepts of data warehousing and online analytical processing (OLAP). Starting from relational database fundamentals, you will explore data warehouse architecture, dimensional modeling with star and snowflake schemas, the ETL process, and OLAP cube operations. The path emphasizes practical understanding for students in data management, preparing you for real-world analytical data engineering tasks.
A focused learning path for university students and developers to understand column-family and graph NoSQL databases, including their data models, query languages, and use cases. It builds on key-value and document store basics, and covers Cassandra, HBase, and Neo4j.
This learning path introduces the principles and use cases of key-value and document NoSQL databases. Starting with relational database basics, it covers the CAP theorem, data modeling, and hands-on practice with Redis and MongoDB, culminating in a practical comparison to guide technology selection.
This learning path takes you from the fundamentals of computer storage to the physical organization of data in database systems. You will explore how data is stored on disk, how records and pages are formatted, and how different file organizations (heap, sequential, hashed) work. The path also covers the role of file systems and indexing in data retrieval.