CSI 234 - Database Development II

5 Total 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. PREREQUISITE(S): Completion of CSI 230 with a 2.0 or higher.

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.