This course covers Microsoft’s SQL Server database programming techniques using Transact-SQL programming constructs, with an emphasis on stored procedures and scripts. This course also involves writing SQL scripts of increasing complexity. Topics: creating and implementing functions using T-SQL and SQL CLR; views, triggers, and transactions; how to protect your data with constraints; and structured error handling.
Prerequisites: SQL: Structured Query Language: (SQL) Level 1 and Structured Query Language: (T-SQL) Level 2 or equivalent.
See our detailed course information including course content, learning objectives, and prerequisites.