Build and manage relational databases using SQL, Oracle, and MySQL.
Most business and technical data consists of multiple tables with interlocking relationships. Such databases must provide reliable storage, transaction management, access security and multi-user support. In this course, you will learn the concepts and design for a Relational Database Management System (RDBMS) and focus on the Structured Query Language (SQL) to define and manipulate data.
The course covers how to create conceptual, logical and physical designs of relational databases in response to a set of user requirements. Instructions will be provided through the use of several case studies. You will learn design methodology, entity-relationship diagrams (ERD) and normalization principles. You will use an Oracle database to design the ERD and implement a working database. SQL is the query language used to access, maintain and share data with the relational database. You will learn methods for producing readable output, creating and manipulating tables and creating and managing constraints using SQL.
The concepts and SQL language learned here apply to all major RDBMS. You will gain understanding of the relational DB and have hands-on experience in creating database and working with data. The instructor recommends MySQL as an example database.
Familiarity with general database concepts and ability to install software or databases on a personal computer.
Note: Based on the requirements for special programs, such as CMU, students may complete this course early and receive a letter grade before the official end date. Click here for details.
Online Self-Paced courses have a structured learning environment where students are allowed to complete the work at their own pace. Students may complete the coursework early or use the entire duration of the course. This course is largely self-study with instructor guidance and includes online learning modules, assignments, and/or quizzes. All course materials and assignments will be available at the beginning of the course on Canvas, our learning management system.
For this section, student access begins on September 8, but you may still enroll until October 14. All course work must be completed by 11:59 pm on December 9, 2025.
Electronic Course Materials: You will be granted access in Canvas to your course site and course materials approximately 24 hours prior to the published start date of the course.
System Requirements: Students are required to have access to a computer with a 8GB of RAM preferred (4GB minimum) and the ability to install software. For further details, see https://www.mysql.com/support/supportedplatforms/workbench.html.
Recommended Text:
Murach's MySQL, 3rd Edition, Joel Murach, Mike Murach & Associates, 2019. ISBN-10: 1943872368 ISBN-13: 978-1943872367
Teach Yourself SQL in 24 Hours, 5th Edition, Ryan Stephens, et al., Sams Publishing, ISBN-10: 0672335417 ISBN-13: 978-0672335419
Students may enroll until the second meeting.
This class meets simultaneously in a classroom and remotely via Zoom. Students are expected to attend and participate in the course, either in-person or remotely, during the days and times that are specified on the course schedule. Students attending remotely are also strongly encouraged to have their cameras on to get the most out of the remote learning experience. Students attending the class in-person are expected to bring a laptop to each class meeting.
2 "no meetings" TBA. To see all meeting dates, click "Full Schedule" below.
Electronic Course Materials: You will be granted access in Canvas to your course site and course materials approximately 24 hours prior to the published start date of the course.
System Requirements: Students are required to have access to a computer with a 8GB of RAM preferred (4GB minimum) and the ability to install software. For further details, see https://www.mysql.com/support/supportedplatforms/workbench.html.
*Students attending onsite are required to bring a laptop.
Required Tools and Materials: MySQL software
Recommended Text: Sams Teach Yourself SQL in 24 Hours; Stephens, Plew, and Jones; Pearson Education, 2011.
ISBN: 978-0132603911.
Note: Based on the requirements for special programs, such as CMU, students may complete this course early and receive a letter grade before the official end date. Click here for details.
Online Self-Paced courses have a structured learning environment where students are allowed to complete the work at their own pace. Students may complete the coursework early or use the entire duration of the course. This course is largely self-study with instructor guidance and includes online learning modules, assignments, and/or quizzes. All course materials and assignments will be available at the beginning of the course on Canvas, our learning management system.
For this section, student access begins on November 4, but you may still enroll until December 9. All course work must be completed by 11:59 pm on February 3, 2025.
Electronic Course Materials: You will be granted access in Canvas to your course site and course materials approximately 24 hours prior to the published start date of the course.
System Requirements: Students are required to have access to a computer with a 8GB of RAM preferred (4GB minimum) and the ability to install software. For further details, see https://www.mysql.com/support/supportedplatforms/workbench.html.
Recommended Text:
Murach's MySQL, 3rd Edition, Joel Murach, Mike Murach & Associates, 2019. ISBN-10: 1943872368 ISBN-13: 978-1943872367
Teach Yourself SQL in 24 Hours, 5th Edition, Ryan Stephens, et al., Sams Publishing, ISBN-10: 0672335417 ISBN-13: 978-0672335419
Online Self-Paced courses have a structured learning environment where students are allowed to complete the work at their own pace. Students may complete the coursework early or use the entire duration of the course. This course is largely self-study with instructor guidance and includes online learning modules, assignments, and/or quizzes. All course materials and assignments will be available at the beginning of the course on Canvas, our learning management system.
For this section, student access begins on January 6, but you may still enroll until February 10. All course work must be completed by 11:59 pm on April 7, 2026.
You will be granted access in Canvas to your course site and course materials approximately 24 hours prior to the published start date of the course.
Note: Based on the requirements for special programs, such as CMU, students may complete this course early and receive a letter grade before the official end date. Click here for details.
System Requirements: Students are required to have access to a computer with a 8GB of RAM preferred (4GB minimum) and the ability to install software. For further details, see https://www.mysql.com/support/supportedplatforms/workbench.html.
Recommended Text:
Murach's MySQL, 3rd Edition, Joel Murach, Mike Murach & Associates, 2019. ISBN-10: 1943872368 ISBN-13: 978-1943872367
Teach Yourself SQL in 24 Hours, 5th Edition, Ryan Stephens, et al., Sams Publishing, ISBN-10: 0672335417 ISBN-13: 978-0672335419
This class meets simultaneously in a classroom and remotely via Zoom. Students are expected to attend and participate in the course, either in-person or remotely, during the days and times that are specified on the course schedule. Students attending remotely are also strongly encouraged to have their cameras on to get the most out of the remote learning experience. Students attending the class in-person are expected to bring a laptop to each class meeting.
No meetings on January 19 and February 16, 2026. To see all meeting dates, click “Full Schedule” below.
You will be granted access in Canvas to your course site and course materials approximately 24 hours prior to the published start date of the course.
System Requirements: Students are required to have access to a computer with a 8GB of RAM preferred (4GB minimum) and the ability to install software. For further details, see https://www.mysql.com/support/supportedplatforms/workbench.html.
*Students attending onsite are required to bring a laptop.
Recommended Text:
Teach Yourself SQL in 24 Hours, 5th Edition, Ryan Stephens, et al., Sams Publishing.
