Preview Workflow

The CIM Courses system will be down temporarily undergoing routine maintenance.

Viewing: CSCI 6441 : Database Management Systems

Last approved: Fri, 02 Jun 2017 08:03:54 GMT

Last edit: Thu, 18 May 2017 20:03:56 GMT

Programs referencing this course
School of Engineering and Applied Sciences
Computer Science (CSCI)
CSCI
6441
Database Management Systems
Database Management Systems
Fall 2017
3
Course Type
Lecture
Default Grading Method
Letter Grade

No
No
CSCI 6221 and CSCI 6461
Corequisites

30

Frequency of Offering
Every Year
Term(s) Offered
Spring
Are there Course Equivalents?
No
 
No
Fee Type


No


Design and architecture of relational database management systems; query languages, data models, index structures, database application design. Students cannot receive credit for CSCI 2441W or 2541W taken while an undergraduate and CSCI 6441 taken while a graduate student. Students in the combined BS/MS program cannot receive credit for CSCI 2441W or CSCI 2541W and CSCI 6441.
1. Apply relational database technology to design OLTP databases for fast transactional systems.
2. Apply datawarehouse database design principles to design large databases for business intelligence applications.
3. Use database modeling tools such as the Oracle Datamodeler to build and deploy database schemas for OLTP and OLAP applications.
4. Use the SQL language to write scripts to create and change database schemas using DDL commands and write reports and transactions using DML, DCL, and transaction control commands.
5. Write database programs using the Oracle PL/SQL and other languages to access databases using JCBC, ODBC, and other database connectivity techniques and cursors.
6. Optimize the design of database and database applications.
7. Manage database systems implementation, integrity, and security. Design backup and recovery systems and accesses control policies.
8. Manage semi-structured data in the databases using XML and JSON.
9. Evaluate the utilization of text search technologies using Lucene in relational databases.
10. Analyze the management of large amounts of non-structured data using Big Data databases like Hadoop.
11. Evaluate when to use relational databases, datawarehouse technology, index searching, and Big Data applications.
12. Build database servers.
13. Build, deploy, and maintain database schemas and integrate the databases with three tier Web Applications
Uploaded a Course Syllabus

Course Attribute
CCAS - Professional

Key: 2208