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

Bryan · Business and Technology · Comp. Network Admin - ITSE


Database Programming
ITSE-2309

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

Meeting Times


Lecture

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

Lab

  • 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: cit.blinn.edu

Office Hours

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

Schedule an appointment for best results.

Description


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.

Requisites

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.

Outcomes


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.

Materials


MySQL

  • 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.

Evaluation


Criteria

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

 

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


Schedule


Spring 2019

                 

Week Day Meeting Details Weekly
Contact
Hours
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