Diploma in SQL 2014 Developer

This free online course will introduce you to the basics of T-SQL and .NET codes with respect to SQL 2014 Developer. SQL Server 2014 delivers mission-critical performance across all workloads with in-memory built-in, faster insights from any data with familiar tools, and a platform for hybrid cloud enabling organizations to easily build, deploy and manage solutions that span on-premises and cloud-based capabilities.

What You Will Learn In This Free Course

Views

In this module, you will be introduced to Views in SQL 2014 Developer. Next, you will learn about the tools that are used for creating Views and how they are used. You will also learn about how to create views that select data from other views, how to update data using a view and common table expressions in the context of views. Lastly, you will learn about Columns and Indexed views

Stored Procedures

In this module, you will learn about Stored Procedures, the syntax for creating them as well as their features in SQL. Next, you will learn about how to create Stored Procedures and how parameters let you write generalize code that works in a variety of situations. You will also learn how to return data from a stored procedure and declare multiple variables at the same time in a single statement

Working with Stored Procedures

In this module, You will be introduced to Testing and Debugging Stored Procedures. You will learn about the rich support that debugging has in language development tools such as Visual Studio and how to use the debugging tool in Management Studio. You will also how to execute with Result Sets as well as how to create Triggers and the different types of Triggers in SQL Server.

Functions

In this module, you will be introduced to Overview and Scalar Functions. Next, you will learn about the Inline Table-Valued Function and the Multi-Statement Table-Valued Function. You will learn about the syntax of these functions as well as how they are implemented. Then you will learn about Views and Stored Procedures in SQL

Transactions

In this module, you will learn about Transaction Concepts and how they are used in applications that interact with SQL Server. Next, you will learn about Application Transactions and the guidelines you can use to create efficient transaction applications. You will also learn about creating explicit transactions as well as structured error handling in SQL

Common Language Runtime

In this module, you will be introduced to the Common Language Runtime (CLR) in SQL. Next, you will learn how to write and deploy SQL CLR applications and run them within SQL Server. The module further analyzes the SQL Data types, their similarities as well as their differences. Then you will learn about the three layers of security involved in accessing external resources and SQLCLR Permission Sets

Course assessment