UPI Study, Inc. | Evaluated Learning Experience
Computer Science 281: Database Fundamentals
Varies (self-study, self-paced).
March 2021 - Present.
Upon the successful completion of this course, students will be able to: 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; differentiate between relational, hierarchical, and object-oriented databases with concrete examples; explain the roles of fundamental database components, including tables, records, and fields, within database structures; master essential terminologies like schema, query, and normalization to communicate database concepts with precision and clarity; 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 demonstrate proficiency of database management principles; and assess the advantages offered by DBMS, such as data integrity, security, and scalability, to make informed decisions regarding database management strategies.
The course is self-paced. Instruction is delivered through online video and text lessons. Students are assessed through quizzes, assignments and a proctored final exam. Major topics include 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 (Database Management System) and data processing applications; business intelligence and data warehouses; and sorting and selection in Java.
In the lower division baccalaureate/associate degree category OR in the upper division baccalaureate degree category, 3 semester hours in Computer Science or Informatics (5/24).