Developing SQL Databases (20762)

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

Developing SQL Databases (20762)

Seattle, WA Class Schedule

Delivery Format Date Time Register
Classroom Virtual 03/22/2021 - 03/26/2021 10:00 AM - 5:00 PM ET 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 2021 Productivity Point Learning Solutions. All Rights Reserved.