Contact

Request Information

Please complete the form below, and an admissions advisor will contact you shortly.

800-628-8648

Apply Now

Ready to take the next step?

The application process is easy. We accept and review applications year-round, and qualified applicants can begin classes any month of the year, depending on your program and location.

Click Apply Now to get started on the next exciting chapter of your life!

Apply Now

DAT615 Advanced Database Programming

Lead Faculty: Dr Pradip Peter Dey

Course Description

This course teaches the skills for implementing and maintaining databases using Structured Query Language (SQL), including Data Design Language and Data Manipulation Language. Topics include creating databases using Transact-SQL and Data Transformation Services (DTS) to manipulate data; programming business logic using stored procedures, triggers, user-defined functions, and views.

Learning Outcomes

  • Create and Manage Constraints, Views, Indexes, and Other Specialized Objects.
  • Specify primary and foreign keys and use indexes.
  • Create Database Instance.
  • Create and Mange Queries and update data.
  • Develop stored procedures and triggers.
  • Use advanced techniques for program control and data manipulation.
  • Develop applications with embedded SQL and ODBC.