Database Programming Using T-SQL

UW Professional & Continuing Education

How long?

  • 9 weeks
  • online

UW Professional & Continuing Education

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Reviews

Comprehensive course analysis

Unbiased reviews from past participants
Global companies alumni of this course worked for
Positions of participants who took this course
Countries where most past participants are from
FREE
Individual needs analysis

About the 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

Experts

Randal Root

Randal Root is a senior consultant specializing in .NET programming, SQL Server business intelligence solutions and technical education. Although he’s been teaching network and database administration since 1998, he primarily focuses on Windows, Web and database programming along with business in...

Database Programming Using T-SQL at UW Professional & Continuing Education

From  $1,999
Add coaching to your course booking

Coaching can personalize and deepen learning for you and your organization.


Something went wrong. We're trying to fix this error.

Thank you for your application

We will contact the provider to ensure that seats are available and, if there is an admissions process, that you satisfy any requirements or prerequisites.

We may ask you for additional information.

To finalize your enrollment we will be in touch shortly.

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.