• SQL
Training Course

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

Browse All Courses > Databases

Have a question while you're learning?

Get in-depth explanations, tips, further insights, and more from Certified Experts. Our experts are vetted industry professionals eager to help you learn from their experiences.

Course Syllabus(78 Lessons)

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

Course Description

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

Course Details

Level:
Intermediate
Duration:
7h 10m 53s
Students:
17

Instructor

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

Share Course

  • LinkedIn

Ready to get started?

SEE HOW IT WORKS