Table of Contents

• Getting Started
• Course Content
• Further Reading
• Contact

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:

3. Unzip the files.

4. 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

• [Book] John L. Viescas - SQL Queries for Mere Mortals.pdf
• [Video] Decomplexify - Learn Database Normalization
• [Video] FreeCodeCamp.org - Database Design Course
• [Resource] SQLZoo
• [Resource] W3Schools
• [Practice] LeetCode

Contact

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

• Email: clive_jarel_c_ang@dlsu.edu.ph
• Discord: evilconundrum or EvilC#5174
• Github Issues: Open an Issue