Course Number and Title: CIS 238 - Database Design and Programming
This course introduces students to database programming using structured query language (SQL). Students acquire working knowledge of the databases necessary to apply and manage the key features such as creating, updating, and reporting.
- Explain database design theories and the normalization process. (CCC 1, 2, 6; PGC 3)
- Develop SQL statements. (CCC 1, 2, 6; PGC 3)
- Design, create, and update a database. (CCC 2, 6; PGC 3)
- Design and maintain database security. (CCC 1, 2, 4, 6; PGC 1, 3, 6)
Upon completion of this course, the student will:
- Explain database design theories and the normalization process.
- Describe database design theories and the normalization process.
- Develop relationships between database tables.
- Construct the table structures through the data normalization process.
- Develop SQL statements.
- Describe relational database systems and SQL.
- Explain SQL commands.
- Identify system objects and processes.
- Examine the basic structure of the SELECT statement and its options.
- Construct SQL SELECT statements.
- Design, create, and update a database.
- Formulate a plan to create a database.
- Create, modify, rename, and delete database tables.
- Write database queries using SQL statements.
- Construct multiple queries and views.
- Develop and modify reports.
- Design and maintain database security.
- Identify and describe database security issues.
- Explain database administration.
- Develop a plan for database security.
- Create and maintain user accounts and groups.
- Define the constraints to protect data integrity in database tables.
- Set up access and security for database tables.
- Apply clear and effective communication skills.
- Use critical thinking to solve problems.
- Collaborate to achieve a common goal.
- Demonstrate professional and ethical conduct.
- Use information literacy for effective vocational and/or academic research.
- Apply quantitative reasoning and/or scientific inquiry to solve practical problems.
- Install, configure and secure computer applications and operating systems.
- Design, write, and debug computer programs.
- Design and integrate databases in computer programs
- Analyze and design complex computer applications to solve business problems.
- Integrate the principles of the Internet into web development.
- Incorporate the principles of networking and information security in computer application development.