|
Sep 07, 2024
|
|
|
|
College Catalog 2022-2023 [ARCHIVED CATALOG]
|
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.
|
|