This course provides a comprehensive overview of the principles and practices involved in the design and implementation of databases. Through a combination of theoretical foundations and practical applications, students will learn to create efficient and effective database systems to meet the information needs of organizations. The course covers essential topics such as database modeling, relational database management systems (RDBMS), normalization, SQL programming, and database administration. Successful completion of ITSM 1203 Information Technology Fundamentals and ITSM 1303 Programming logic are recommended prior to taking this course.
Faculty Contact Information
Course Information
At the end of this course, students will be able to:
- Demonstrate Understanding of Database Concepts
- Apply Database Design Principles
- Execute SQL Commands
- Design and Implement Database Systems
- Ensure Database Security and Integrity
- Utilize Advanced Database Concepts
- Analyze and Solve Database Problems
- Collaborate Effectively in Database Projects
- Evaluate Database Management Systems
- MODULE 1. INTRODUCTION TO DATABASE MANAGEMENT
- MODULE 2. THE RELATIONAL MODEL: INTRODUCTION, QBE, AND RELATIONAL ALGEBRA
- MODULE 3. THE RELATIONAL MODEL: SQL
- MODULE 4. THE RELATIONAL MODEL: ADVANCED TOPICS
- MODULE 5. DATABASE DESIGN: NORMALIZATION
- MODULE 6. DATABASE DESIGN: RELATIONSHIPS
- MODULE 7. DATABASE MANAGEMENT SYSTEMS PROCESSES AND SERVICES
- MODULE 8. DATABASE INDUSTRY CAREERS
- MODULE 9. DATABASE INDUSTRY TRENDS
Business, Technology & Human Services
Dean, Paul Carlson; 815-802-8858; V105; pcarlson@kcc.edu; Division Office – W102; 815-802-8650
College Policies, Resources and Supports
For information related to the Student Code of Conduct Policy, Withdrawal Policy, Email Policy, and Non- Attendance/Non-Participation Policy, please review the college’s Code of Campus Affairs and Regulations webpage, which can be found at catalog.kcc.edu under the Academic Regulations & Conduct Guide.
KCC offers various academic and personal resources for all students. Many services are offered virtually, as well as in person. Please visit Student Resources - Kankakee Community College to access student resources services such as:
- Clubs and organizations
- Counseling and referral services
- Office of disability services
- Student complaint policy
- Transfer services
- Tutoring services, etc.
The materials on this course are only for the use of students enrolled in this course for purposes associated with this course. Further information regarding KCC's copyright policy is available at https://kcc.libguides.com/copyright.
|Course syllabus/calendar is subject to change.