Restricted Operations Due to Coronavirus Outbreak

For the safety of our community, UWPCE has restricted operations due to the coronavirus outbreak.

For more information, see our FAQ

Database Programming Using T-SQL

collapse

Course Details

  • Location: Online
  • Duration: 9 weeks
  • Times: Evenings
  • Cost : $1,199

Next Start Date:

January 14, 2021

This course is part of a certificate program. You can also take it without enrolling in the program.

Get Details & Apply

About this Course


This course builds on the concepts from the first course and provides the basics of Transact-SQL (T-SQL) programming extensions. Gain hands-on experience with the use of scalar and table-valued functions, branching and conditional logic, using transactions and concurrency, and more advanced data structures. Build and deploy a database application.

Topics include:

  • Introduction to database programming
  • Using SQL: thinking in sets
  • Understanding transactions and error handling
  • Database programming with T-SQL
  • Developing functions and stored procedures
  • Developing database triggers and cursors
  • Writing advanced SQL queries
  • Understanding concurrency: locking and  blocking
  • Data access security
  • Query optimization and performance tuning

Program Overview

This course is part of the Certificate in SQL Server Development.

Learning Format

Online With Real-Time Meetings

Combine the convenience of online learning with the immediacy of real-time interaction. You’ll stream courses online and interact with your instructors and fellow students via chat, web conferencing or phone, all in real time. Learn More »

Course Sessions

Online With Real-Time Meetings

Online

NONCREDIT COURSE

You'll earn 3 continuing education units (CEUs) for successfully completing this course. Learn more about noncredit courses.

Closed Sessions

Online

Meet your instructor

Jim Simonson

Principal SQL Server Software Engineer | Global Relay Communications

NONCREDIT COURSE

You'll earn 3 continuing education units (CEUs) for successfully completing this course. Learn more about noncredit courses.

  Stay up to date with emails featuring career tips, event invitations and program updates.       Sign Up Now