Database Management Systems

The Associate of Science in Database Management Systems program equips students with a comprehensive understanding of the principles and practices essential for the effective design, implementation, and management of databases in diverse organizational settings. This program integrates theoretical foundations with hands-on experience, preparing students for dynamic careers in the ever-evolving field of information technology.  Through practical exercises and projects, students gain expertise in Structured Query Language (SQL), enabling them to efficiently retrieve, manipulate, and manage data stored in various database systems.

20

Upon successful completion of the program, graduates will be able to:

• Design and implement relational database systems using industry-standard tools and practices.
  
• Develop proficiency in SQL and other data manipulation languages for effective data querying, reporting, and management.
  
• Apply best practices in database security to safeguard data integrity, confidentiality, and availability.
  
• Analyze and optimize database performance through effective design, indexing, and query optimization techniques.
  
• Understanding the principles of data warehousing, big data, and NoSQL databases in the context of modern data management challenges.

• Database Fundamentals: Students delve into the core concepts of databases, learning about data modeling, database design, normalization techniques, and the principles underlying relational and non-relational databases.
• SQL Proficiency: Through practical exercises and projects, students gain expertise in Structured Query Language (SQL), enabling them to efficiently retrieve, manipulate, and manage data stored in various database systems.
• Database Administration: This segment covers the principles of database administration, including security, backup and recovery, performance tuning, and maintenance strategies essential for ensuring data integrity and availability.

Course	Title	Units	Year/Semester (Y1 or S1)
CMPR112	Java Programming	3	Y1
CMPR114	Python Programming	3	Y1
CMPR115	Python for Data Analytics	3	Y1
CMPR134	Operating Systems	3	Y1
CMPR167	Access Database	3	Y1
CMPR113	Advanced Java	3	S1
CMPR168	MS SQL Database Development	3	S1
CMPR169	SQL	3	S1
CMPR213	C# Programming	3	S1
CMPR247	Windows Server Operating Systems	3	S1

---

NA

Similar programs exists at Pasadena City College, Fresno City College, Foothill College, Mt San Antonio College, Palomar College, Cypress College and Fullerton College.

20