Course Number:
WT 225
Transcript Title:
Database Theory and MySQL
Aug 16, 2022
Aug 17, 2022
Total Credits:
Lecture Hours:
Lecture / Lab Hours:
Lab Hours:
Satisfies Cultural Literacy requirement:
Satisfies General Education requirement:
Grading Options
A-F, P/NP, Audit
Default Grading Options
Repeats available for credit:

WT 213

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. Prerequisite: WT 213. Audit available.

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

Suggested 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

Outcome #1: Create, design and implement relational databases.
  • Database security issues
    • Deployment failures
    • Broken databases
    • Data leaks
    • Lack of segregation
    • Hopscotch
    • SQL injections
    • Database Threats: Privileges, Malware, vulnerable databases
  • Working with data types
Outcome #2: Code SQL statements.
  • Queries and Subqueries
  • Using functions
  • Data Definition Language Statements
  • Data Manipulation Language Statements
  • Transaction Control Statements
  • Session Control Statements
  • Embedded SQL Statements
Outcome #3: Execute SQL statements against a database.
  • Data retrieval from single and multiple tables
  • Loops
  • CASE/IF statements
  • Error handling
  • Debugging
Outcome #4: Apply knowledge of SQL using an application program such as Hypertext Preprocessor (PHP) or MySQL (My Sequel).
  • Generating client-side code
  • Syntax:
    • Variable, Operators, Strings
    • Conditional and Looping Statements
    • Functions and Global Variables
    • Arrays
  • HTTP Requests and Forms
  • Cookies and Sessions

Suggested Texts and Materials

  • Murach’s PHP and MySQL
  • Database Design for Mere Mortals