Developing SQL Databases (20762)

Category ID Duration Level Price
SQL Server M20762 5 Day(s) Intermediate $3,095.00

Developing SQL Databases (20762)

Anchorage, AK Class Schedule

Delivery Format Date Time Register
Classroom Virtual 12/07/2020 - 12/11/2020 10:00 AM - 5:00 PM EST Register

Anchorage Training Center


310 K Street

Suite 200

Anchorage, AK 99501

Call Us

US Toll Free 844-238-8607

Email Us

Course Overview

This official Microsoft five-day, instructor-led training course provides you with the knowledge and skills to develop a Microsoft SQL Server database. This SQL Server database development course focuses on teaching you how to use SQL Server product features and tools related to developing a database.

You will also prepare for Microsoft exam 70-762, a requirement for MCSA: SQL 2016 Database Development and MCSE: Data Management and Analytics.

Course Objectives

Upon successful completion of this course, you will be able to: · Design and Implement Tables. · Describe advanced table designs · Ensure Data Integrity through Constraints. · Describe indexes, including Optimized and Columnstore indexes · Design and Implement Views. · Design and Implement Stored Procedures. · Design and Implement User Defined Functions. · Respond to data manipulation using triggers. · Design and Implement In-Memory Tables. · Implement Managed Code in SQL Server. · Store and Query XML Data. · Work with Spatial Data. · Store and Query Blobs and Text Documents.

MCSA: SQL Server 2012/2014
MCSA: SQL 2016 Database Development
MCSE: Data Management and Analytics

To ensure successful completion of this course, we recommend the following: · Basic knowledge of the Microsoft Windows operating system and its core functionality. · Working knowledge of Transact-SQL. · Working knowledge of relational databases.

Productivity Point Learning Solutions evolved out of a desire to increase our outreach both nationally and internationally.

Productivity Point Headquarters
1580 Sawgrass Corporate Parkway
Suite 205
Sunrise, Florida 33323
United States

T 1-844-238-8607
P 1-954-425-6141
F 1-954-928-9057

© Copyright 2020 Productivity Point Learning Solutions. All Rights Reserved.