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.
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.
There are no academic entry requirements for this course, and it is open to students of all academic backgrounds.
|Tools for Creating Views||00:11:00|
|Updating Data Using a View||00:13:00|
|Columns and Indexed Views||00:18:00|
|Introduction Stored Procedures||00:18:00|
|Creating Stored Procedures||00:19:00|
|Testing and Debugging||00:17:00|
|Execute with Result Sets||00:11:00|
|Overview and Scalar Functions||00:20:00|
|Inline Table Valued Functions||00:11:00|
|Views and Stored Procedures||00:18:00|
|Applications and Transactions||00:13:00|
|Creating Explicit Transactions||00:29:00|
|Structured Error Handling||00:25:00|
|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|
|Order your Certificate||00:00:00|
No Reviews found for this course.