Skip to content

Latest commit

 

History

History
98 lines (78 loc) · 4.88 KB

README.md

File metadata and controls

98 lines (78 loc) · 4.88 KB

GitHub last commit GitHub repo size GitHub Issues or Pull Requests

Table of Contents

Getting Started

Download with Git:

  1. Clone the repository:

    git clone https://github.com/EvilConundrum/mastering-ccinfom.git

  2. Navigate to the repository directory:

    cd mastering-ccinfom

  3. Open the curriculum directory to access the content.

Download Without Git:

  1. Go to the top of this page and click the green Code button.

  2. In the sub-menu, click "Download ZIP" as seen below:

  1. Unzip the files.

  2. Have fun (?) with the materials!

Course Content

mastering-ccinfom/
├── curriculum/
│   ├── Fundamentals of Databases/
│   │   └── ...
│   ├── Writing SQL Queries/
│   │   └── ...
│   └── Database Design and Modeling/
│       └── ...
├── resources/
│   ├── fonts/
│   └── images/
└── README.md

Key Topics Covered

Fundamentals of Databases

  • Introduction to Databases: Overview of what databases are, their purpose, and their role in managing and organizing data effectively.
  • Roles in the Database Environment: Explanation of key roles such as database administrators, designers, and operators, and their responsibilities in managing databases.
  • Data & Information: Differentiates between raw data and processed information, focusing on how databases transform data into useful insights.
  • File-based vs. Database Systems: Comparison of traditional file-based systems and modern database systems in terms of efficiency, scalability, and functionality.
  • ANSI-SPARC and the Database Environment: Introduction to the ANSI-SPARC architecture and its layers (external, conceptual, and internal) as a framework for database management.

Writing SQL Statements

  • Filters and Aggregates: Learn how to use WHERE, GROUP BY, HAVING, and aggregate functions like SUM, AVG, and COUNT to filter and summarize data.
  • Joins: Understand how to combine data from multiple tables using INNER JOIN, LEFT JOIN, and RIGHT JOIN.
  • Subqueries: Explore nested queries and their applications in filtering, aggregation, and creating complex queries.

Database Design and Modeling

  • Database Design: Guidelines and principles for structuring databases to meet specific requirements.
  • Data Models: Overview of conceptual, logical, and physical data models used in database systems.
  • Relations: Explanation of relationships between tables, including one-to-one, one-to-many, and many-to-many.
  • Database Design Techniques: Methods to create efficient, scalable, and maintainable database designs.
  • Database Normalization: Steps to organize data into tables, reduce redundancy, and maintain integrity through normalization forms (1NF, 2NF, and 3NF).

Problem Sets and Reviewers

  • DBHR Complete Set: A comprehensive set of problem sets covering all major SQL Writing concepts.
  • DBHR Curated20: A curated selection of 20 challenging problems from the DBHR Complete Set for focused practice.
  • Clive's Case Studies 1 - 3: Fictional scenarios requiring database design, optimization, and problem-solving.
  • Oli's Design Exercise: A practical exercise to apply database design principles to a real-world use case.
  • Mock Concept Exam: An exam focusing on foundational database concepts, designed to test understanding and identify areas for improvement.

Further Reading

Contact

For questions, mistakes, or feedback, feel free to reach out via: