![]() Related Products20464: Developing Microsoft SQL Server DatabasesNetworking/Server/Operating Systems
Schedules
Delivery Type (Must Select One)
Instructor-Led
Online Live Instructor-Led
Optional
A+ Test Voucher ($390) - Set of 2 - $195 Each
A+ Practice Exam ($70.00)
IT Online Library (1 Year Subscription - $1595.00)
Quantity
If quantity is more than 1, Please add all Attendees' Names /Voucher #/ Learning Credit below separated with a comma. If not specified, we will contact you prior to the class start date.
Special Instructions
This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course. Also this course helps you prepare for the Exam 70-464. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
Module 1: Introduction to Database Development
Lab : Introduction to Database Development After completing this module, you will be able to:
Lab : Designing and Implementing Tables After completing this module, you will be able to:
Lab : Ensuring Data Integrity through Constraints After completing this module, you will be able to:
Lab : Implementing Indexes After completing this module, you will be able to:
Lab : Designing Optimized Index Strategies After completing this module, you will be able to:
Lab : Using Columnstore Indexes After completing this module, you will be able to:
Lab : Designing and Implementing Views After completing this module, you will be able to:
Lab : Designing and Implementing Stored Procedures After completing this module, you will be able to:
Lab : Designing and Implementing User-Defined Functions After completing this module, you will be able to:
Lab : Responding to Data Manipulation via Triggers After completing this module, you will be able to:
Lab : In-Memory OLTP After completing this module, you will be able to:
Lab : Implementing Managed Code in SQL Server 2014 After completing this module, you will be able to:
Lab : Storing and Querying XML Data in SQL Server 2014 After completing this module, you will be able to:
Lab : Working with SQL Server Spatial Data After completing this module, you will be able to:
Lab : Implementing a Solution for Storing Data Files
After completing this course, students will be able to:
The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2014 product features and technologies for implementing a database. The secondary audiences for this course are individuals who are developers from other product platforms or previous versions of SQL Server looking to become skilled in the implementation of a SQL Server 2014 database.
This course requires that you meet the following prerequisites:
You may cancel this class 10 or more business days prior to the start date of the class for a full refund. No shows or cancellations made within
10 days will forfeit all fees paid.
|