CSI 234 - Applied Database Development

5 Credits
This course is designed for the student who is already familiar with basic relational database theory. The focus of this course is databases in the n-tier client/server development model. Students learn and utilize more advanced program or language topics, such as enterprise-level objects, views, stored procedures, functions, indexes, constraints, transaction handling, and triggers in event-driven database applications. Additionally, the class covers best practices in administration, user management and security, including effective planning for updates, backup, and disaster recovery.

Prerequisite(s): Completion of CSI 130 with a 2.0 or higher.

Course Outcomes

Install and configure SQL Server 2017.
Create user databases and how to administer it.
Write complex SQL queries to extract information from the database.
Know the different SQL functionalities that exist.
Write more efficient SQL code.
Write procedures for code re usability.
Learn to improve query performance.
Create full database backups.