MCSA-SQL Server 2016 Database Development Boot Camp

Category ID Duration Level Price
SQL Server 13681 6 Day(s) Intermediate $3,900.00

MCSA-SQL Server 2016 Database Development Boot Camp

Atlanta, GA Class Schedule

GTR

Guaranteed to Run

Delivery Format Date Time Register
Classroom Virtual 10/26/2020 - 10/31/2020 10:00 AM - 5:00 PM EDT Register
Classroom Virtual 12/07/2020 - 12/12/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

The primary goal of this boot camp is to help each student pass the exams required to earn the MCSA SQL 2016 Database Development certification. To do this, your knowledgeable instructor will blend hands-on labs with lecture and practice exams to prepare you to pass each exam. The practice exams identify knowledge gaps that the instructor will fill with customized, hands-on labs and tailored lectures.

This boot camp is designed to introduce students to Transact-SQL. This instructor-led boot camp also provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The boot camp focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.

Course Objectives

After successfully completing this course, you will be able to:
Describe key capabilities and components of SQL Server 2016.
Describe T-SQL, sets, and predicate logic.
Write a single table SELECT statement.
Write a multi-table SELECT statement.
Write SELECT statements with filtering and sorting.
Describe how SQL Server uses data types.
Write DML statements.
Write queries that use built-in functions.
Write queries that aggregate data.
Write subqueries.
Create and implement views and table-valued functions.
Use set operators to combine query results.
Write queries that use window ranking, offset, and aggregate functions.
Transform data by implementing pivot, un-pivot, rollup and cube.
Create and implement stored procedures.
Add programming constructs such as variables, conditions, and loops to T-SQL code.
Design and Implement Tables.
Describe advanced table designs
Ensure Data Integrity through Constraints.
Describe indexes, including Optimized and Column-store 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.

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.