| |
Oct 23, 2026
|
|
|
|
|
CSCI 1201 - Database Systems
Credits: 4
Catalog Description
This course introduces students to current techniques, methods, and results from the active field of database systems and data management. The course will define essential database terms and concepts and focus on the design, development, and use of a relational database. Topics include query planning and optimization, transaction processing and concurrency control, big data management, data warehousing and OLAP, and the theory of databases. The course uses a hands-on approach to learning.
Recommended Skills, Abilities, or Coursework: Basic programming skills, familiarity with operating systems
Additional fee to student: No
Learner Outcomes
- Understand terms related to database design and management.
- Understand the database development process.
- Understand the relational model and relational database management system.
- Assess data and information requirements.
- Construct conceptual data models.
- Develop logical data models.
- Evaluate the normality of a logical data model, and correct any anomalies.
- Develop physical data models for relational database management systems.
- Use relational algebra notation and apply it to construct SQL instructions.
- Use common Database Management Systems and modeling tools.
- Understand database performance issues.
- Understand the basics of data management and administration.
- Understand the basics of OLAP, Big Data, and data warehousing.
Major Areas of Course Content
- Data Modeling
- Database Design
- Relational Model and ERD
- Structured Query Language (SQL)
- Normalization and Dependencies of Database Tables
- Transaction Management and Concurrency Control
- Performance Tuning and Query Optimization
- OLAP, Big Data and Data Warehousing
- Database Industry Trends
Credit for Prior Learning Options
No credit for prior learning option is available for this course.
Add to Portfolio (opens a new window)
|
|
