• LOGIN
  • No products in the cart.

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

Course Reviews

4.9

4.9
9 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • £309.00 £20.00
  • 1 year
  • Course Certificate
  • Number of Units25
  • Number of Quizzes0
  • 7 hours, 13 minutes
559 STUDENTS ENROLLED

Top Sale Courses

ABOUT

We are a company who is best known for offering awarding body accredited courses for anyone who wishes to take their professional life to the next level.
St. Pauls College, 83 Victoria Street, London, SW1H 0HW

020 3900 1809
info@stpaulscollege.co.uk

Certificate Code

top
COPYRIGHT © 2017 STPAULSCOLLEGE.CO.UK