About This Site | Databases - Wyatt's Notes

Wyatt’s Notes delivers comprehensive study materials for database design and SQL. These notes cover relational database theory, SQL queries, normalisation, indexing, and modern database systems, building the skills needed for effective data management.

These notes are created by Wyatt, an educator and content developer with expertise in database systems and data engineering. Content follows a structured progression from relational theory through query optimisation to practical database administration.

Materials emphasise the theoretical foundations that underpin good database design — normalisation, relational algebra, and transaction semantics — alongside practical SQL skills. Every concept includes worked examples and explains the performance implications of different design choices.

• Relational theory covering normalisation, functional dependencies, and relational algebra
• SQL with queries, joins, subqueries, and window functions
• Indexing and performance covering B-trees, hash indexes, and query optimisation
• Transaction management with ACID properties and concurrency control
• Modern databases including NoSQL, NewSQL, and distributed systems

Wyatt develops resources across databases, programming, and computer science, providing the full-stack perspective that enhances database materials. Content is informed by database theory, industry standards, and production database administration.

• Computer Science — Computer science theory notes
• Programming — Programming language resources
• Tools — Development tools resources

Start with relational theory to build the foundation for good database design. Each topic progresses from theory to practical SQL and administration. Use the practice problems to develop your query writing and design skills.

Visit wyattsnotes.wyattau.com for the full network of study resources.

This site provides comprehensive study materials covering:

• SQL
• Normalisation
• Indexing
• Transactions
• NoSQL

Each topic includes detailed explanations, worked examples, and practice problems designed to build deep understanding.

1. Start with fundamentals — begin with the core topics before moving to advanced material
2. Work through examples — every concept includes worked examples with step-by-step solutions
3. Test yourself — use the practice problems and diagnostic tests to identify knowledge gaps
4. Cross-reference — related topics on other sites in the Wyatt’s Notes network provide additional perspectives

• Flashcards — spaced repetition flashcards for key concepts and formulas
• Practice Problems — graded problems from basic to advanced
• Diagnostic Tests — identify your strengths and weaknesses
• Worked Examples — step-by-step solutions to common problems

These notes are informed by standard university textbooks including Date, Elmasri & Navathe, Ramakrishnan. While the notes follow the general structure of these texts, they are not a substitute for reading the primary sources.

basic programming

Wyatt’s Notes is a network of 45+ study sites covering physics, mathematics, computer science, programming languages, and more. Each site is built with Astro and Starlight, using SolidJS for interactive components.

• Mathematics — University-level mathematics
• Physics — University-level physics
• Computer Science — Algorithms, data structures, and theory
• Programming — Programming fundamentals and practice

For questions, corrections, or suggestions, visit wyattsnotes.wyattau.com or open an issue on GitHub.

• Databases
• Complete Database Design Study Guide
• Introduction to Databases

This topic covers the fundamental principles and applications in depth. Each concept is explained with clear definitions, worked examples, and practice problems to reinforce understanding.

Understanding these core concepts is essential for mastering this topic. They form the foundation for more advanced study and are frequently examined.

Worked examples demonstrate how to apply the concepts to solve problems. Each example is broken down into clear steps with explanations.

• Rushing through foundational material
• Not practising problems after reading
• Failing to connect concepts across topics

Consult the recommended textbooks and additional resources for deeper understanding of this topic.

This topic covers the fundamental principles and applications in depth. Each concept is explained with clear definitions, worked examples, and practice problems to reinforce understanding.

Understanding these core concepts is essential for mastering this topic. They form the foundation for more advanced study and are frequently examined.

Worked examples demonstrate how to apply the concepts to solve problems. Each example is broken down into clear steps with explanations.

• Rushing through foundational material
• Not practising problems after reading
• Failing to connect concepts across topics

Consult the recommended textbooks and additional resources for deeper understanding of this topic.

This topic covers the fundamental principles and applications in depth. Each concept is explained with clear definitions, worked examples, and practice problems to reinforce understanding.

Understanding these core concepts is essential for mastering this topic. They form the foundation for more advanced study and are frequently examined.

Worked examples demonstrate how to apply the concepts to solve problems. Each example is broken down into clear steps with explanations.

• Rushing through foundational material
• Not practising problems after reading
• Failing to connect concepts across topics

Consult the recommended textbooks and additional resources for deeper understanding of this topic.