Developing SQL Databases (part of MCSA SQL 2016)

Training

Inhouse

Save 20%
£ 1,032 VAT exempt

Description

  • Type

    Training

  • Methodology

    Inhouse

  • Duration

    68 Days

  • Start date

    Different dates available

All courses available also on-site

This four-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.

Facilities

Location

Start date

Inhouse

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Server
  • IT
  • Database
  • SQL
  • Database training
  • MCSA training
  • MCSA
  • Teaching
  • Design
  • SQL Database

Teachers and trainers (1)

Matthew Bennett

Matthew Bennett

Instructor

Director - MBIT Training Ltd Microsoft Certified Trainer, MCSA, MCITP, MCDST, Microsoft Partner Microsoft Dynamics consultant CompTIA A+ / Network+ / Security+ Author: Network+ study guide, A+ study guide (currently writing)

Course programme

This four-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.

Audience Profile:

The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2016 product features and technologies for implementing a database.

The secondary audiences for this course are individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server 2016 database.

At Course Completion:

After completing this course, students 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.

(cited from Microsoft Learning website)

Developing SQL Databases (part of MCSA SQL 2016)

£ 1,032 VAT exempt