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/
├── resources/
│   ├── fonts/
│   └── images/
└── README.md

Key Topics Covered

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

Further Reading

• [Book] John L. Viescas - SQL Queries for Mere Mortals.pdf
• [Video] Decomplexify - Learn Database Normalization
• [Video] FreeCodeCamp.org - Database Design Course
• [Tutorial] SQLZoo
• [Tutorial] W3Schools
• [Interactive] 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