Database Theory and MySQL

Course Number:
WT 225
Transcript Title:
Database Theory and MySQL
Created:
Aug 16, 2022
Updated:
Jul 17, 2023
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, P/NP, Audit
Default Grading Options
A-F
Repeats available for credit:
0
Prerequisites

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

The determination of assessment strategies is generally left to the discretion of the instructor. Here are some strategies that you might consider when designing your course: writings (journals, self-reflections, pre writing exercises, essays), quizzes, tests, midterm and final exams, group projects, presentations (in person, videos, etc), self-assessments, experimentations, lab reports, peer critiques, responses (to texts, podcasts, videos, films, etc), student generated questions, Escape Room, interviews, and/or portfolios.

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