Internet Explorer 7, 8, and 9 are no longer supported. Please use a newer browser.
Concourse works best with JavaScript enabled.
Blinn College District logo

Bryan · Engineering, Computer Technology, and Innovation · Comp. Network Admin - ITSE

Database Programming

  • Spring 2019
  • Section 378 CRN-25872
  • 3 Credits
  • 01/14/2019 to 05/09/2019
  • Modified 01/23/2019

Meeting Times


  • Tuesday, Thursday, 2:00 PM to 3:50 PM, Student Center 241


  • Thursday, 3:00 PM to 3:50 PM, Student Center 241

Contact Information

Program Coordinator: Major Robert Carl Nelson II

  • Email: [email protected]
  • Office: Student Center 242
  • Phone: 979-209-7430
  • Website:

Office Hours

  • Tuesday, Thursday, 11:30 AM to 12:00 PM, Student Center 242

Schedule an appointment for best results.


Database development using database programming techniques emphasizing database structures, modeling, and database access.

3 lecture hours and 1 lab hour per week; 64 total contact hours.  Credit: 3 semester hours.


Prerequisites: A grade of "C" or better in ITNW 1325 and ITSC 1325 or approval by the Dean or designee

Core Curriculum Statement

This course is not a core curriculum course.


Upon successful completion of this course, students will:

  1. Develop database applications using a structured query language.
  2. Create queries and reports from database tables.
  3. Implement data integrity.
  4. Optimize query performance.
  5. Create and maintain indexes.
  6. Create appropriate documentation.



  • Author: Joel Murach
  • Publisher: Murach
  • Edition: 2nd
  • ISBN: 9781890774820
  • Availability: Campus Bookstore and Online

Flash Drive

USB Flash Thumb Drive

Course Requirements

Transfers to BAAS degree at SHSU.

Transfers to BAS-IT degree at UHCL.



Type Weight Notes
Exams 50%

Five major exams and a comprehensive final exam

Course Project 20%

A small-team course project designing a small rental company database

Labs 20%

Numerous labs using DML, DDL, and DCL

Class Participation 10%

Daily contributions to discussion and labs


A [90, 100]   Exceptional knowledge of the material covered

B [80,90]      Above average knowledge of the material covered

C [70,80]      Average knowledge of the material covered

D [60,70]      Less than average knowledge of the material covered

F [0,60]         Very little knowledge of the material covered

Blinn College Policies

All policies, guidelines, and procedures in the Blinn College CatalogBlinn College Board Policies, and the Blinn College Administrative Regulations are applicable to this course.

Specific information on civility, attendance, add/drop, scholastic integrity, students with disabilities, final grade appeal, alternative retailers, campus carry and proctoring arrangements and cost.

Notice of any action taken under these protocol and procedures, by Blinn College or its employees, may be delivered by hand, through the U.S. Postal Service, or electronically to the student’s Blinn Buc e-mail account. Notice shall be deemed received upon actual receipt, on deposit in the U.S. Mail, or upon entering the information processing system used by Blinn College for Blinn Buc e-mail accounts, whichever first occurs.

Course Policies


Spring 2019


Week Day Meeting Details Weekly
1 T 01/15/19 Orientation 4
R 01/17/19 Introducing Relational Databases
2 T 01/22/19 MySQL Workbench 4
R 01/24/19 MySQL Monitor
3 T 01/29/19 SELECT Clause 4
W 01/30/19 Important - Day of Record
R 01/31/19 WHERE and Other Clauses
4 T 02/05/19 Inner and Outer Joins 4
R 02/07/19 Other Joins
5 T 02/12/19 Summary Queries; Exam One (Chapters 1-5) 4
R 02/14/19 Subqueries
6 T 02/19/19 More DML 4
R 02/21/19 String and Numeric Data Types
7 T 02/26/19 Other Data Types 4
R 02/28/19 String Functions
8 T 03/05/19 Numeric Functions 4
R 03/07/19 Database Design; Exam Two (Chapters 6-9)
Spring Break T 03/12/19 Holiday - College Closed  
R 03/14/19 Holiday - College Closed
9 T 03/19/19 Database Structures 4
R 03/21/19 Views
10 T 03/26/19 Stored Programs; Exam Three (Chapters 10-12) 4
R 03/28/19 Transactions
11 T 04/02/19 Stored Procedures 4
R 04/04/19 Stored Functions
12 T 04/09/19 Triggers and Events 4
R 04/11/19 Database Administration; Exam Four (Chapters 13-16)
13 T 04/16/19 GRANT Tables; Users and Privileges 4
R 04/18/19 Backup and Restore Databases
14 T 04/23/19 Import and Export Data 4
R 04/25/19 Exam Five (Chapters 17-19)
F 04/26/19 Last Day to Drop with a "Q"
15 T 04/30/19 Course Project Rehersal 4
R 05/02/19 Course Project Presentation
F 05/03/19 Last Day of Classes
16 T 05/07/19 from 1245-1500 Comprehensive Final Exam 4
      Total Contact Hours 64