Internet Explorer 7, 8, and 9 are no longer supported. Please use a newer browser.

Concourse works best with JavaScript enabled.

Blinn College • Bryan • Business and Technology • Comp. Network Admin - ITSE


Database Programming ITSE-2309

  • Fall 2018
  • Section 328 CRN-13081
  • 3 Credits
  • 08/27/2018 to 12/13/2018
  • Modified 09/25/2018

Meeting Times


Lecture

  • Monday, Wednesday, 2:00 PM to 3:50 PM, F 241

Lab

  • Monday, 3:00 PM to 3:50 PM, F 241

Contact Information


Program Coordinator: Major Robert Carl Nelson II

Office Hours

  • Monday, Wednesday, 11:30 AM to 12:00 PM, F 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

 

Breakdown

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


Schedule


Fall 2018

                 

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