CIS1896 DATABASE PROGRAMMING
3 Credit Hours
Student Level:
This course is open to students on the college level in either the freshman or sophomore year.
Catalog Description:
CIS1896 - Database Programming (3 hrs.)
An introductory course to give students an introduction to database programming. SQL will be used to create database objects and view, change, add and delete records from within a computer program. Various types of database system will be covered including relational, flat file, and XML databases.
Course Classification:
Lecture
Prerequisites:
Basic Computer Skills
Controlling Purpose:
This course is designed to help the student increase their knowledge concerning developing efficient database applications that use appropriate indexes, keys, and joins to update and query database tables. The student will learn the basics of the SQL language.
Learner Outcomes:
Upon completion of the course, the student will be able to write database applications that retrieve, update, add, and delete records from tables. The student will also be able to write SQL queries against records or database objects. In addition, working with flat file systems, web databases and XML databases will be covered.
Unit Outcomes for Criterion Based Evaluation:
The following defines the minimum core content not including the final examination period. Instructors may add other content as time allows.
UNIT 1: Database Concepts and SQL
Outcomes: After completion of this unit, the student will have a working knowledge of database systems and their components, SQL necessary to view or alter data, keys, indexes, constraints, joins, views, and stored procedures.
- Explain what a database, table, record, and field are
- Design a database and tables
- Use SQL to retrieve records
- Use SQL to update records
- Use SQL to delete records
- Use SQL to add records
- Define keys, indexes, and constraints
- Create joins, views, and stored procedures.
UNIT 2: Viewing Data Applications
Outcomes: After completion of this unit, the student will have a working knowledge of writing programs to retrieve data using various techniques.
- Write program(s) to retrieve data using simple SELECT statements
- Write program(s) to retrieve data using joins
- Write program(s) to retrieve data using SELECT/WHERE statements
- Write program(s) to retrieve data using views
UNIT 3: Manipulating Data Applications
Outcomes: After completion of this unit, the student will have a working knowledge of writing programs to alter data in a table along with implementing stored procedures.
- Write program(s) to update data
- Write program(s) to add and delete data
- Write program(s) to execute stored procedures
UNIT 4: Creating SQL Commands in Applications
Outcomes: After completion of this unit, the student will have a working knowledge of programmatically creating SQL statements to perform various functions in a database.
- Write program(s) to retrieve unique record using only a select query
- Write program(s) to use variables and functions in SQL
- Write program(s) to use wildcards and ranges of values in SQL query
- Write program(s) to find records in a table without corresponding entries
- Write program(s) to use subqueries
- Write program(s) to create, modify, and delete tables
- Write program(s) to create a new table with data from existing tables
- Write program(s) to create and call SQL user-defined functions
UNIT 5: Flat File Databases
Outcomes: After completion of this unit, the student will have a working knowledge of writing programs to maintain a flat file database.
- Write program(s) to create, add, delete, or change directories
- Write program(s) to add records
- Write program(s) to change records
- Write program(s) to delete records
- Write program(s) to view records
UNIT 6: XML Databases
Outcomes: After completion of this unit, the student will have a working knowledge of writing programs to maintain an XML database
- Write XML
- Write program(s) to add records
- Write program(s) to change records
- Write program(s) to delete records
- Write program(s) to view records
Projects Required:
Various programming projects
Textbook:
Contact Bookstore for current textbook.
Materials/Equipment Required:
None
Attendance Policy:
Students should adhere to the attendance policy outlined by the instructor in the course syllabus.
Grading Policy:
The grading policy will be outlined by the instructor in the course syllabus.
Maximum class size:
Based on classroom occupancy.
Course Timeframe:
The U.S. Department of Education, Higher Learning Commission and the Kansas Board of Regents define credit hour and have specific regulations that the college must follow when developing, teaching and assessing the educational aspects of the college. A credit hour is an amount of work represented in intended learning outcomes and verified by evidence of student achievement that is an institutionally-established equivalency that reasonably approximates not less than one hour of classroom or direct faculty instruction and a minimum of two hours of out-of-class student work for approximately fifteen weeks for one semester hour of credit or an equivalent amount of work over a different amount of time. The number of semester hours of credit allowed for each distance education or blended hybrid courses shall be assigned by the college based on the amount of time needed to achieve the same course outcomes in a purely face-to-face format.
Refer to the following policies:
402.00 Academic Code of Conduct
263.00 Student Appeal of Course Grades
403.00 Student Code of Conduct
Disability Services Program:
Cowley College, in recognition of state and federal laws, will accommodate a student with a documented disability. If a student has a disability, which may impact work in this class, which requires accommodations, contact the Disability Services Coordinator.
DISCLAIMER: THIS INFORMATION IS SUBJECT TO CHANGE. FOR THE OFFICIAL COURSE PROCEDURE CONTACT ACADEMIC AFFAIRS.
|
