Name: SQL Programming Beginner
Price: 24.99 GBP
Rating: 4.9 (9 reviews)

SQL Server 2014 introduces in-memory tables and stored procedures. This SQL Programming Beginner is designed for developers new to SQL Server and planning to create and deploy applications against Microsofts market-leading database system for the Windows platform. Through the course, you’ll learn to create tables and indexes, and be introduced to best practices for securing your valuable data. You’ll learn design tradeoffs and find out how to make sound decisions resulting in scalable databases and maintainable code. This course is enhanced to cover the very latest developments in SQL Server, including the in-memory features that are introduced in SQL Server 2014. In addition to that, learn to create constraints and views in the most dynamic way possible.

By the end of the book, you’ll be able to design and create solid and reliable database solutions using SQL Server.

Method of Assessment:

This course does not involve any assessment. Upon conclusion of the course you can order your completion certificate.

Certification:

Certificates can be obtained at an additional cost of £9.99 for PDF, £16.99 for Printed Hardcopy format and £24.99 for Both for Both PDF and Hardcopy Certificates.

Requirements

There are no academic entry requirements for this course, and it is open to students of all academic backgrounds.

Course Curriculum

Module: 01
	Introduction	FREE	00:16:00
	Tools for Creating Views		00:11:00
	Examples		00:21:00
	Updating Data Using a View		00:13:00
	Columns and Indexed Views		00:18:00
Module: 02
	Introduction Stored Procedures		00:18:00
	Creating Stored Procedures		00:19:00
	Returning Data		00:14:00
Module: 03
	Testing and Debugging		00:17:00
	Execute with Result Sets		00:11:00
	Creating Triggers		00:26:00
Module: 04
	Overview and Scalar Functions		00:20:00
	Inline Table Valued Functions		00:11:00
	Multi Statement		00:16:00
	Views and Stored Procedures		00:18:00
Module: 05
	Transaction Concepts		00:30:00
	Applications and Transactions		00:13:00
	Creating Explicit Transactions		00:29:00
	Structured Error Handling		00:25:00
Module: 06
	Introduction to SQL CLR		00:08:00
	Writing SQL CLR Code		00:24:00
	Using SQL CLR Code		00:22:00
	SQL CLR Code		00:13:00
	SQL CLR Security		00:20:00
Course Certification
	Order your Certificate		00:00:00