This course will begin with an introduction to views, tools for creating them, view examples, how to update data using a view, and columns and indexed views.
Next, we will move onto stores procedures, how to create them, how to return data, testing and debugging, execution with result sets, and creating triggers.
Next, we will outline the program’s functions, including scalar functions, inline table-valued functions, multi-statement, views, and stored procedures.
We will then explain transactions by including its concepts, applications, creating explicit transactions, and structured error handling.
We will then conclude with a discussion of common language runtime, including an introduction to SQL CLR, writing SQL CLR code, using that code and its modules, and SQL CLR security.
After taking this course it is recommend to take part 2: SQL 2014 Developer P2: VS 2012 and Data Types