18756 Stone Oak Park Way, Suite200, San Antonio TX 78258 USA
100 Queen St W, Brampton, ON L6X 1A4, Canada
country flagUnited States
share button

20762:Developing SQL Databases Training

Category

SQL Server

Rating
4.3
(4.3)
Price

$2875

Course Description

20762: Developing SQL Databases Training helps professionals gain the important skills and knowledge to build an MS SQL Server 2016 database. This technical course's focus is to teach professionals how to utilize SQL Server 2016 product tools and features related to building a database. It teaches them the techniques to design and apply tables and demonstrate advanced table designs. Professionals will also learn to describe indices, which include Column store and Optimizes indices. This training program is ideal for IT Professionals who want to develop their skills and knowledge of SQL Server 2016 technologies and products for implementing a database. It is also suitable for individuals who are into other product platforms and want to develop skills in the implementation of a SQL Server 2016 database. By the end of this course, trainees will know the methodology to respond to data manipulation and design Store Procedures.

This training is designed based on the objectives of the course variant 20762C.

Objectives
  • Designing and Implementing Tables.
  • Describing advanced table designs
  • Ensuring Data Integrity Constraints.
  • Describing Column store and Optimized indexes
  • Designing and Implementing Views.
  • Designing and Implementing Stored Procedures.
  • Designing and Implementing User-Defined Functions.
  • Using triggers to respond to data manipulation.
  • Designing and Implementing In-Memory Tables.
  • Implementing Managed Code within SQL Server.
  • Query and Store XML Data.
  • Working with Spatial Data.
  • Store and Query Text Documents and Blobs.
Who Should Attend?

The course is well versed for IT workers wanting to upgrade their skills on product features and technologies of SQL Server to implement databases. Individual developers of other platforms and products looking to broaden their knowledge in SQL Server databases can take this course as well.

Prerequisites
  • Knowledge of Microsoft Windows operating system and core functionality
  • Knowledge of Transact-SQL and relational databases
Course Details
  • Start Date: May 03, 2021
  • Duration: 5 Days
  • Skill Level: Intermediate
  • More Schedules: Click
  • Certification: NO
  • Enrolled: 1159
Get In Touch
Are you being sponsored by your employer to take this class?
* I authorize Microtek Learning to contact me via Phone/Email