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

SQL 2014 Developer P1: T-SQL and .NET Code, available at $19.99, has an average rating of 4.08, with 78 lectures, 6 quizzes, based on 6 reviews, and has 65 subscribers.

You will learn about Understand, create and update views Create and return data from stored procedures Test and debug stored procedures Create triggers Learn about scalar functions, inline table-valued functions and multi-statement functions Understand the concept of transactions and create explicit transactions Get and overview of SQL CLR This course is ideal for individuals who are Database professionals with experience in SQL Server 2014 looking to learn more advanced features and techniques of SQL Server 2014 or Candidates seeking SQL Server 2014 certifications It is particularly useful for Database professionals with experience in SQL Server 2014 looking to learn more advanced features and techniques of SQL Server 2014 or Candidates seeking SQL Server 2014 certifications.

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

Summary

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

Price: $19.99

Average Rating: 4.08

Number of Lectures: 78

Number of Quizzes: 6

Number of Published Lectures: 78

Number of Published Quizzes: 6

Number of Curriculum Items: 84

Number of Published Curriculum Objects: 84

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

Understand, create and update views

Create and return data from stored procedures

Test and debug stored procedures

Create triggers

Learn about scalar functions, inline table-valued functions and multi-statement functions

Understand the concept of transactions and create explicit transactions

Get and overview of SQL CLR

Who Should Attend

Database professionals with experience in SQL Server 2014 looking to learn more advanced features and techniques of SQL Server 2014

Candidates seeking SQL Server 2014 certifications

Target Audiences

Database professionals with experience in SQL Server 2014 looking to learn more advanced features and techniques of SQL Server 2014

Candidates seeking SQL Server 2014 certifications

The SQL 2014 Developer P1: T-SQL and .NET Code course is the first course in the three course series on SQL Server 2014. This series of courses is a comprehensive series covering all the intermediate to advanced level topics of SQL Server 2014. The topics covered in part 1 of this series are related to the Transact-SQL and .NET coding. The course covers the related sub-topics in a great detail and enables the students to implement the gained knowledge in their everyday tasks.?

The SQL 2014 Developer P1: T-SQL and .NET Code course covers the fundamental topics necessary to build, manage, and maintain databases in SQL Server 2014. The course enables the students to efficiently perform the management tasks on their databases and learn the new and advanced features available in SQL Server 2014. The course has two follow-up courses which combine to give a complete and comprehensive knowledgebase to the students working with SQL Server 2014.

Course Curriculum

Chapter 1: Chapter 01 – Views

Lecture 1: Topic A: Introduction to Views – Part 1

Lecture 2: Introduction to Views – Part 2

Lecture 3: Introduction to Views – Part 3

Lecture 4: Topic B: Tools for Creating Views – Part 1

Lecture 5: Tools for Creating Views – Part 2

Lecture 6: Tools for Creating Views – Part 3

Lecture 7: Topic C: View Examples – Part 1

Lecture 8: View Examples – Part 2

Lecture 9: View Examples – Part 3

Lecture 10: Topic D: Updating Data Using a View – Part 1

Lecture 11: Updating Data Using a View – Part 2

Lecture 12: Updating Data Using a View – Part 3

Lecture 13: Topic E: Columns and Indexed Views – Part 1

Lecture 14: Columns and Indexed Views – Part 2

Lecture 15: Columns and Indexed Views – Part 3

Chapter 2: Chapter 02 – Stored Procedures

Lecture 1: Topic A: Introduction Stored Procedures – Part 1

Lecture 2: Introduction Stored Procedures – Part 2

Lecture 3: Introduction Stored Procedures – Part 3

Lecture 4: Topic B: Creating Stored Procedures – Part 1

Lecture 5: Creating Stored Procedures – Part 2

Lecture 6: Creating Stored Procedures – Part 3

Lecture 7: Topic C: Returning Data From – Part 1

Lecture 8: Returning Data From – Part 2

Lecture 9: Returning Data From – Part 3

Chapter 3: Chapter 03 – Stored Procedures Continued

Lecture 1: Topic A: Testing and Debugging – Part 1

Lecture 2: Testing and Debugging – Part 2

Lecture 3: Testing and Debugging – Part 3

Lecture 4: Topic B: Execute with Result Sets – Part 1

Lecture 5: Execute with Result Sets – Part 2

Lecture 6: Execute with Result Sets – Part 3

Lecture 7: Topic C: Creating Triggers – Part 1

Lecture 8: Creating Triggers – Part 2A

Lecture 9: Creating Triggers – Part 2B

Lecture 10: Creating Triggers – Part 3

Chapter 4: Chapter 04 – Functions

Lecture 1: Topic A: Overview and Scalar Functions – Part 1

Lecture 2: Overview and Scalar Functions – Part 2

Lecture 3: Overview and Scalar Functions – Part 3

Lecture 4: Topic B: Inline Table-Valued Functions – Part 1

Lecture 5: Inline Table-Valued Functions – Part 2

Lecture 6: Inline Table-Valued Functions – Part 3

Lecture 7: Topic C: Multi-Statement – Part 1

Lecture 8: Multi-Statement – Part 2

Lecture 9: Multi-Statement – Part 3

Lecture 10: Topic D: Views and Stored Procedures – Part 1

Lecture 11: Views and Stored Procedures – Part 2

Lecture 12: Views and Stored Procedures – Part 3

Chapter 5: Chapter 05 – Transactions

Lecture 1: Topic A: Transaction Concepts – Part 1

Lecture 2: Transaction Concepts – Part 2A

Lecture 3: Transaction Concepts – Part 2B

Lecture 4: Transaction Concepts – Part 3

Lecture 5: Topic B: Applications and Transactions – Part 1

Lecture 6: Applications and Transactions – Part 2

Lecture 7: Applications and Transactions – Part 3

Lecture 8: Topic C: Creating Explicit Transactions – Part 1

Lecture 9: Creating Explicit Transactions – Part 2A

Lecture 10: Creating Explicit Transactions – Part 2B

Lecture 11: Creating Explicit Transactions – Part 3

Lecture 12: Topic D: Structured Error Handling – Part 1

Lecture 13: Structured Error Handling – Part 2A

Lecture 14: Structured Error Handling – Part 2B

Lecture 15: Structured Error Handling – Part 3

Chapter 6: Chapter 06 – Common Language Runtime

Lecture 1: Topic A: Introduction to SQL CLR – Part 1

Lecture 2: Introduction to SQL CLR – Part 2

Lecture 3: Introduction to SQL CLR – Part 3

Lecture 4: Topic B: Writing SQL CLR Code – Part 1

Lecture 5: Writing SQL CLR Code – Part 2A

Lecture 6: Writing SQL CLR Code – Part 2B

Lecture 7: Writing SQL CLR Code – Part 3

Lecture 8: Topic C: Using SQL CLR Code – Part 1

Lecture 9: Using SQL CLR Code – Part 2A

Lecture 10: Using SQL CLR Code – Part 2B

Lecture 11: Using SQL CLR Code – Part 3

Lecture 12: Topic D: SQL CLR Code Modules – Part 1

Lecture 13: SQL CLR Code Modules – Part 2

Lecture 14: SQL CLR Code Modules – Part 3

Lecture 15: Topic E: SQL CLR Security – Part 1

Lecture 16: SQL CLR Security – Part 2

Lecture 17: SQL CLR Security – Part 3

Instructors

Stone River eLearning
Over 1,000,000 Happy Students

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 2 votes

4 stars: 2 votes

5 stars: 2 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!