Consortium for International Studies | Evaluated Learning Experience
Database (SQL, My SQL) CIS 204
Varies (self-study, self-paced).
April 2025 - Present.
Upon successful completion of the course, students will be able to: design and implement relational databases using MySQL; construct SQL queries to retrieve, modify, and manage data efficiently; apply normalization techniques to optimize database structure; develop stored procedures and functions to automate database operations; manage transactions and concurrency to ensure data consistency; implement user privileges and security measures to protect database integrity; perform database backup and recovery operations to prevent data loss; and evaluate and apply best practices in web design and development.
Major topics include relational database fundamentals, normalization, and database design principles; writing basic and advanced SQL queries using MySQL; using joins, subqueries, aggregate functions, and views to retrieve and analyze data; implementing stored procedures and functions; managing transactions and concurrency; and applying database security measures, user access controls, and backup/recovery strategies. Instruction is based on Murach’s MySQL (3rd Edition) by Joel Murach, with supplementary readings from additional SQL reference and performance texts. Students complete hands-on SQL assignments, a final project that applies core MySQL concepts, and a final exam covering database theory, SQL syntax, and administrative best practices.
In the lower division baccalaureate/associate degree category, 3 semester hours in Computer Science, Information Systems, Business, Engineering Science or Informatics (4/25).