Bryan · Engineering, Computer Technology, and Innovation · Comp. Network Admin - ITSE
- Spring 2019
- Section 378 CRN-25872
- 3 Credits
- 01/14/2019 to 05/09/2019
- Modified 01/23/2019
- Tuesday, Thursday, 2:00 PM to 3:50 PM, Student Center 241
- Thursday, 3:00 PM to 3:50 PM, Student Center 241
Program Coordinator: Major Robert Carl Nelson II
- Email: [email protected]
- Office: Student Center 242
- Phone: 979-209-7430
- Website: cit.blinn.edu
- 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:
- Develop database applications using a structured query language.
- Create queries and reports from database tables.
- Implement data integrity.
- Optimize query performance.
- Create and maintain indexes.
- Create appropriate documentation.
- Author: Joel Murach
- Publisher: Murach
- Edition: 2nd
- ISBN: 9781890774820
- Availability: Campus Bookstore and Online
USB Flash Thumb Drive
Transfers to BAAS degree at SHSU.
Transfers to BAS-IT degree at UHCL.
Five major exams and a comprehensive final exam
A small-team course project designing a small rental company database
Numerous labs using DML, DDL, and DCL
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
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.
|R||01/17/19||Introducing Relational Databases|
|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|
|5||T||02/12/19||Summary Queries; Exam One (Chapters 1-5)||4|
|R||02/21/19||String and Numeric Data Types|
|7||T||02/26/19||Other Data Types||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|
|10||T||03/26/19||Stored Programs; Exam Three (Chapters 10-12)||4|
|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|