It is every student's responsibility to do additional studying, research, and participate in assignment activities regularly. In online sections of the course, face-to-face activity is replaced with guided videos and more focus on reading activities. students will receive weekly notifications and announcements by CCP Email outlining and explaining topics and assignments. This is an Online Section of the Course, It is important to monitor your CCP Email and Canvas Announcements on a regular basis.

To follow the sequence of activities and assignments of this course online, click on the Modules tab on the left side of the screen

For information on Computer Information Systems and Computer Science programs and courses at Community College of Philadelphia try:

Computer Information Systems

Computer Science

Description

Computer Information Systems 205 - Database Management Systems
4 credits (8 hours lecture, 2 hours lab per week)

This course introduces the design and implementation of relational database management systems using Structured Query Language (SQL). The course covers fundamental database design and implementation techniques and provides hands-on exercises for applying the techniques to real-world problems using database management software such as Oracle, Maria DB, or MySQL.

Prerequisites: CIS 103.

Course Learning Outcomes

Database Management - Use a modern database management program such as Oracle, MySQL, and PostgreSQL to perform such tasks as writing operational and correct SQL (DDL, DML, and DCL) statements.
Database Fundamentals - Write SQL statements that perform fundamental database concepts, including Relational Algebra, and successfully use a Relational Database System.
ER Diagrams - Create and translate Entity-Relationship (ER) Diagrams using a software diagramming tool.
Ethics - Explain common ethical issues related to the use of information technology systems and the handling of data, including privacy and security issues.
Structured Query Language - Write operational and correct SQL (DDL, DML, and DCL) statements.
Data Mining and Big Data - Describe new concepts and terminology in DBMS such as Data Warehousing, Data Mining, NoSQL, and Big Data.
Database Design - Implement a relational database from initial requirements and conceptual design (ER Diagram) to the physical database in a modern enterprise relational database management system

Upon completion of this course students will also be able to:

Design and Create Conceptual Relational Database Using a professional modeling application
Implement Physical Database from a Conceptual Design
Work as part of a professional team to design, code, test and debug normalized databases
Correctly use the elements of Relational Algebra to retrieve result sets from relational databases
Create source code and execute SQL statements that are syntactically correct
Demonstrate knowledge of input and output routines, data types, and data operations
Demonstrate knowledge of key concepts in Database Theory

Who Should Take Course and Why

This course is structured for students wanting advanced training in designing, implementing, and interacting with relational databases using professional Relational Database Management Systems RDMS. Additionally, students wanting to survey advanced concepts in Database Theory, Database Programming, and Database Implementation should take this course.