SQL 2014 Developer P1: T-SQL and .NET Code

Category
Databases
Level
Intermediate
Lessons
78
Duration
7h 10m 15s
Last Updated: 2018-09-20
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
Category
Databases
Level
Intermediate
Lessons
78
Duration
7h 10m 15s
SQL 2014 Developer P1: T-SQL and .NET Code - Module 01 - Views
SQL 2014 Developer P1: T-SQL and .NET Code - Module 02 - Stored Procedures
SQL 2014 Developer P1: T-SQL and .NET Code - Module 03 - Stored Procedures Continued
SQL 2014 Developer P1: T-SQL and .NET Code - Module 04 - Functions
SQL 2014 Developer P1: T-SQL and .NET Code - Module 05 - Transactions
SQL 2014 Developer P1: T-SQL and .NET Code - Module 06 - Common Language Runtime
Don Kiely
I’m an instructor on many SQL Server and Visual Studio courses. I’m a nationally recognized author, instructor, and consultant specializing in Microsoft technologies. With many years of teaching experience, I’m the author or co-author of several programming books, and have spoken at many industry conferences and user groups. In addition, I’m a consultant for a variety of companies that develop distributed applications for public and private organizations.
Don KielyInstructor and Curriculum Developer
Other Courses by Don Kiely