About This Site
About Wyatt’s Notes, Databases
Section titled “About Wyatt’s Notes, Databases”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.
Why Trust These Resources?
Section titled “Why Trust These Resources?”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.
What You’ll Find
Section titled “What You’ll Find”- 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
Credentials
Section titled “Credentials”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.
Related Sites
Section titled “Related Sites”- Computer Science, Computer science theory notes
- Programming, Programming language resources
- Tools, Development tools resources
Explore the Site
Section titled “Explore the Site”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.
Content Coverage
Section titled “Content Coverage”This site provides comprehensive study materials covering:
- SQL
- Normalisation
- Indexing
- Transactions
- NoSQL
How to Use These Notes
Section titled “How to Use These Notes”- Start with fundamentals, begin with the core topics before moving to advanced material
- Work through examples, every concept includes worked examples with step-by-step solutions
- Test yourself, use the practice problems and diagnostic tests to identify knowledge gaps
- Cross-reference, related topics on other sites in the Wyatt’s Notes network provide additional perspectives
Study Resources
Section titled “Study Resources”- 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
Textbooks and References
Section titled “Textbooks and References”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.
Prerequisites
Section titled “Prerequisites”basic programming
About Wyatt’s Notes
Section titled “About Wyatt’s Notes”Related Sites
Section titled “Related Sites”- Mathematics, University-level mathematics
- Physics, University-level physics
- Computer Science, Algorithms, data structures, and theory
- Programming, Programming fundamentals and practice
Contact
Section titled “Contact”For questions, corrections, or suggestions, visit wyattsnotes.wyattau.com or open an issue on GitHub.
See Also
Section titled “See Also”Detailed Content
Section titled “Detailed Content”Core Concepts
Section titled “Core Concepts”Worked Examples
Section titled “Worked Examples”Common Mistakes
Section titled “Common Mistakes”- Rushing through foundational material
- Not practising problems after reading
- Failing to connect concepts across topics