Database Theory and MySQL

Course Number: WT 225
Transcript Title: Database Theory and MySQL
Created: April 3, 2015
Updated: May 21, 2021
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

Prerequisites

WR 115, RD 115 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 or equivalent placement test scores; WT 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

Texts and Materials

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

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)

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