Database Management Welcome Page

Link to Audio of Information

https://access.sensus.dk/sb4/sb4amrsp/rba07-14-04-2020-205642.mp3 Links to an external site.

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 data base management systems using Structured Query Language (SQL). The course covers fundamental data base 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

1. 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.
2. Database Fundamentals - Write SQL statements that perform fundamental database concepts, including Relational Algebra, and successfully use a Relational Database System.
3. ER Diagrams - Create and translate Entity Relationship (ER) Diagrams using a software diagramming tool.
4. Ethics - Explain common ethical issues related to the use of information technology systems and the handling of data, including privacy and security issues.
5. Structured Query Language - Write operational and correct SQL (DDL, DML and DCL) statements.
6. Data Mining and Big Data - Describe new concepts and terminology in DBMS such as Data Warehousing, Data Mining, NoSQL, and Big Data.
7. 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 be also be able to:

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

Who Should Take Course and Why

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

Instructor: