SQL SERVER - TRANSACTSQL
- Program: Information Technology/Computer Careers
- Course: SQL Server - TransactSQL
- Course #: CCIS2781
- Total Credits: 4
Course DescriptionThis course provides students with the technical skills required to utilize TransactSQL programming solutions within a Microsoft SQL Server client/server database management system.
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.
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).
The following goals will be addressed in the course:
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
Apply Now Search Awards Search Courses