SQL SERVER - TRANSACTSQL

  • Program: Information Technology/Computer Careers
  • Course: SQL Server - TransactSQL
  • Course #: CCIS2781
  • Total Credits: 4

Course Description

This course provides students with the technical skills required to utilize TransactSQL programming solutions within a Microsoft SQL Server client/server database management system.

Course Evaluation

Refer to Course Syllabus for detailed information regarding the requirements and evaluation standards for this course. The Course Syllabus will be distributed the first week of the course.

Disability Services

Hennepin Technical College offers reasonable accommodations to qualified students with disabilities. If you have a documented disability that may require accommodations, contact the college’s Disability Services Director: Sara Laviolette at Brooklyn Park (763-488-2477) or Jean Kreutter at Eden Prairie (952-995-1544).

Course Goals

The following goals will be addressed in the course:
Interpret architecture
Retrieve data using TSQL
Retrieve data from multiple data sources
Use aggregate functions
Use analytical functions
Manipulate the database using DML, DDL, and DCL
Create basic store procedure
Formulate SQL queries to retrieve data
Use relational algebra operators
Control error handling using triggers
Create transactions and record locking
Interpret database and database file

Credit Details
  • Lecture: 4
  • MnTC Goal: 0
Course Details

Apply Now Search Awards Search Courses