Course

Course Summary
Credit Type:
Course
ACE ID:
UPIS-0010
Organization's ID:
Computer Science 281
Organization:
Location:
Online
Length:
77 Hours
Dates Offered:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 3 Database Fundamentals
Description

Objective:

The course objective is to offer an in-depth exploration of the fundamentals of databases, relational database models, and structured query language (SQL). In this we focus on gaining proficiency in designing and implementing relational databases, understanding entity-relationship models, and executing advanced SQL commands for efficient data manipulation. Additionally, students will explore various data types, SQL variations, and relational data modeling techniques, enabling them to create robust database solutions. The curriculum also covers database administration, security measures, and distributed databases, ensuring students are equipped to manage databases effectively in diverse environments. Furthermore, students will delve into business intelligence, big data, and non-relational databases, broadening their understanding of contemporary data management practices. Students will develop the skills necessary to excel in database management, data warehousing, and business intelligence applications through hands-on projects and practical examples.

Learning Outcomes:

  • Differentiate between relational, hierarchical, and object-oriented databases, providing concrete examples to illustrate understanding
  • Showcase comprehension of fundamental database components, including tables, records, and fields, by articulating their roles within database structures
  • Analyze the significance of database records and fields, recognizing their crucial role in organizing data
  • Evaluate the purpose and functions of Database Management Systems (DBMS) and compare various DBMS models to develop a comprehensive understanding of database management principles
  • Demonstrate proficiency in database fundamentals by classifying various types of data, such as numerical, textual, and multimedia data, and elucidating their respective sources and definitions
  • Master essential terminologies like schema, query, and normalization to communicate database concepts with precision and clarity
  • Assess the advantages offered by DBMS, such as data integrity, security, and scalability, to make informed decisions regarding database management strategies

General Topics:

  • Introduction to Database Fundamentals
  • Relational Database Model
  • Structured Query Language (SQL)
  • Data Types in SQL
  • Variations of SQL Relational Data Modelling
  • Relational Database Design
  • Database Management Commands
  • Database Administration and Security
  • DBMS and Data Processing Applications
  • Business Intelligence & Data Warehouses
  • Sorting & Selection in Java
Instruction & Assessment

Instructional Strategies:

  • Computer Based Training
  • Lectures
  • Practical Exercises
  • Project-based Instruction

Methods of Assessment:

  • Examinations
  • Other
  • Quizzes
  • Assignment

Minimum Passing Score:

70%
Supplemental Materials

Other offerings from UPI Study

(UPIS-0008)
(UPIS-0019)
(UPIS-0017)
(UPIS-0020)