INFO 2642 - Transact SQL

4.5 Credits

Students gain the skills needed to access and manipulate data in the SQL Server Database management system. The course covers basic through advanced level SQL commands.

Prerequisites: (1) INFO 1620

Recommended: INFO 2630

Lecture Hours: 4.5
Lab Hours: 0.0
Internship Hours: 0.0
Clinical or Practicum Hours: 0.0

Course Objectives

Write queries and subqueries.
Use aggregation functions to summarize data.
Demonstrate JOINs and UNIONs.
Apply appropriate data types to various use cases.
Illustrate the use of functions.
Illustrate the use of views.
Create and use database programming objects.
Manage database transactions.
Discuss best practices of query optimization.

View Class Schedule