Developing SQL Databases (20762)

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

Developing SQL Databases (20762)

Seattle, WA Class Schedule

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

Seattle Training Center

Address


1001 4th Ave


Suite 3200


Seattle, WA 98154

Map and Driving Directions

Call Us

US Toll Free 844-238-8607

Email Us


info@productivitypointls.com

Developing SQL Databases (20762)

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.

Developing SQL Databases (20762)

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

Course Prerequisites

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.

Related Courses

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

Contact
T 1-844-238-8607
P 1-954-425-6141
F 1-954-928-9057
E info@productivitypointls.com

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