Skip to main content

National College Credit Recommendation Service

Board of Regents  |  University of the State of New York

UPI Study, Inc. | Evaluated Learning Experience

Computer Science 381: Database Programming

Length: 

Varies (self-study, self-paced).

Location: 
Various; distance learning format.
Dates: 

March 2021 - Present. 

Instructional delivery format: 
Online/distance learning
Learner Outcomes: 

Upon the successful completion of this course, students will be able to: evaluate the impact and significance of database applications across various industries; design and implement effective database schemas based on key design principles and requirements; apply normalization rules to enhance database integrity and performance; develop and optimize complex SQL queries using advanced techniques for effective data manipulation and retrieval; master the syntax and use of SQL commands including data definition, manipulation, and control to manage database systems efficiently; install and configure database management systems like MySQL and SQL Server, tailoring them to specific organizational needs; utilize SQL to perform detailed data analysis and generate insightful reports; implement robust security measures in database systems to safeguard sensitive information against threats; troubleshoot common database issues and enhance system performance through targeted optimization techniques such as indexing and query refinement; and explain the strategic role of databases in business decision-making and operational efficiency.

Instruction: 

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 relational database management systems; creating and managing database tables; populating and retrieving data in databases; manipulating data in databases; data queries in multiple tables using Joins and subqueries; views and indexes in databases; modifying tables in databases; manipulating large data sets in databases; developing and using regular expressions in databases; and Database Security.

Credit recommendation: 

In the upper division baccalaureate degree category, 3 semester hours in Database Programming, Informatics, Information Technology, MIS, or Computer Science (5/24).

Top