This Database course surveys topics in database systems. The course emphasizes the effective use of database (management) systems. Topics include access methods, data models, query languages, database design, query optimization, concurrency control, recovery, security, integrity, client-server architecture, and distributed database systems. Hands-on use will be a key part of the course.
Credits: 3, prerequisites: none.
Probably the most exciting part of this course is that you will work with actual databases. This includes installing them, accessing them with the MySQL Workbench or phpMyAdmin, and then updating and querying them. For example, take a look at http://mvoortman.it.pointpark.edu/phpmyadmin/ (username is ‘anonymous’ and password is also ‘anonymous’) where you can find example databases (e.g., wpc is the Wedgewood Pacific Corporation database from the book) that will be used throughout the course. Note that instead of mvoortman.it.pointpark.edu you will actually make your own database accessible through username.it.pointpark.edu, which means you get to work like a professional database administrator!
Module 1: Getting Started
Module 2: The Relational Model I
Module 3: The Relational Model II
Module 4: Structured Query Language I
Module 5: Structured Query Language II
Module 6: Data Modeling I
Module 7: Data Modeling II
Module 8: Database Design I
Module 9: Database Design II
Module 10: Database Administration I
Module 11: Database Administration II
Module 12: Database Applications I
Module 13: Database Applications II
Module 14: Big Data
Module 15: Final Exam
- Explain the importance of database design.
- Describe what business rules are and how they influence database design.
- Define what data models are and why they are important.
- Explain the details of the relational data model.
- Perform Data Modeling with the Entity Relationship Model (ERM).
- Define normalization and its role in the design process.
- Implement the basic forms from 1NF to 4NF.
- Use basic commands and functions of SQL.
- Use SQL for data administration (to create tables, indexes, and views).
- Use SQL for data manipulation (to add, modify, delete, and retrieve data).
- Use SQL to query a database for useful information.
- Structured Query Language
- Use of Structured Query Language
- Database Normalization
- Database Design