Database Theory and MySQL

Course Number: CAS 225
Transcript Title: Database Theory and MySQL
Created: April 3, 2015
Updated: July 16, 2019
Total Credits: 4
Lecture Hours: 30
Lecture / Lab Hours: 0
Lab Hours: 30
Satisfies Cultural Literacy requirement: No
Satisfies General Education requirement: No
Grading options: A-F (default), P-NP, audit
Repeats available for credit: 0


WR 115, RD 115 and MTH 20 or equivalent placement test scores

Course Description

Develops an understanding of relational database concepts and terminology, database design concepts and Structured Query Language (SQL). Introduces the use of languages and technology used to integrate data within a web site. Prerequisites: WR 115, RD 115 and MTH 20 or equivalent placement test scores; CAS 213. Audit available.

Intended Outcomes

Upon successful completion of this course, students will be able to:

  1. Create, design and implement relational databases.
  2. Code SQL statements.
  3. Execute SQL statements against a database.
  4. Apply knowledge of SQL using an application program such as Hypertext Preprocessor(PHP) or MySQL (My Sequel).

Outcome Assessment Strategies

Assessments may include:objective tests, scored assignments, or projects, class participation, quizzes, research paper, written observations, and written assignments

Course Activities and Design

The determination of teaching strategies used in the delivery of outcomes is generally left to the discretion of the instructor. Here are some strategies that you might consider when designing your course: lecture, small group/forum discussion, flipped classroom, dyads, oral presentation, role play, simulation scenarios, group projects, service learning projects, hands-on lab, peer review/workshops, cooperative learning (jigsaw, fishbowl), inquiry based instruction, differentiated instruction (learning centers), graphic organizers, etc.

Course Content (Themes, Concepts, Issues and Skills)

  • Relational database design and implementation
  • Server-side programming concepts
  • SQL coding
  • Introduction to PHP
  • Data retrieval from single and multiple tables
  • Coding queries and subqueries
  • Working with data types
  • Using functions
  • Stored program development
  • Loops, CASE/IF statements
  • Error handling and debugging
  • Database security issues
  • Introduction to MySQL and basic database concepts
  • Introduction to SQL retrieval queries