A comprehensive guide covering database fundamentals, from basic data concepts to designing structured database systems. Explores the DIKW pyramid (Data, Information, Knowledge, Wisdom), database management systems architecture, ACID properties, and various data models including relational databases, NoSQL systems, and Big Data approaches. Includes practical examples using PostgreSQL and covers essential topics like data types, domains, database design principles, and the differences between structured, semi-structured, and unstructured data.
Table of contents
Table of ContentsPrerequisites:The Role of Data in Today's Digital WorldChapter 1: What is Data?Chapter 2: What is a Database?Chapter 3: Data Management Models and TechnologiesChapter 4: Database DesignChapter 5: Relational Model (Structured Data)Chapter 6: Relational Schema DiagramChapter 7: NormalizationChapter 8: Query LanguagesChapter 9: SQL (Structured Query Language)Chapter 10: Database Design Process ExampleChapter 11: Example QueriesConclusion2 Comments
Sort: