Developing SQL Databases (20762)

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

Developing SQL Databases (20762)

Atlanta, GA Class Schedule

GTR

Guaranteed to Run

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

Atlanta Training Center

Address


260 Peachtree Street NW


Atlanta, GA 30303

Call Us

US Toll Free 844-238-8607

Email Us


info@productivitypointls.com

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

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.