Database Management Welcome Page
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 activities are replaced with guided videos, and reading activities are more focused on. Students will receive weekly notifications and announcements via CCP Email, outlining and explaining topics and assignments. This is a Face-To-Face 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 Links to an external site.
Computer Science Links to an external site.
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 a Conceptual Relational Database Using a professional modeling application
- Implement a 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.