,

Performance Tuning and Optimizing Microsoft SQL Server Databases

This property is marketed by

InnoventSys

Member Since: 3 months
94777849438
WhatsApp
https://degree.lk/wp-content/themes/propertya-child/libs/images/type.png

Offer Type

best-certificate-courses

https://degree.lk/wp-content/themes/propertya-child/libs/images/medium.png

Medium

NG

https://degree.lk/wp-content/themes/propertya-child/libs/images/method.png

Method

NG

https://degree.lk/wp-content/themes/propertya-child/libs/images/duration.png

Duration

02 Days

https://degree.lk/wp-content/themes/propertya-child/libs/images/location.png

Location

Colombo

https://degree.lk/wp-content/themes/propertya-child/libs/images/time.png

Commencement

Soon

Description

 
Audience Profile

The primary audience for this course is individuals who are database administrators and database engineers. The secondary audience of this course is individuals who work with Microsoft SQL Server as a software engineer, technical lead or an architect.

 
Participant Prerequisites

This course requires that you meet the following prerequisites:

  • Working knowledge of data related solutions
  • Working knowledge on Microsoft SQL Server database
  • Working knowledge on T-SQL

 

Course Objectives

After completing this course, you will be able to:

  • Describe design considerations of Microsoft SQL Server databases.
  • Describe design considerations of Microsoft SQL Server tables.
  • Describe table structures such as heap and cluster.
  • Describe indexing types: Rowstore and Columnstore.
  • Describe how to use and maintain indexes.
  • Describe statistics and why they are important.
  • Describe how to handle locks and blocks.
  • Describe concurreny issues and how to handle them.
  • Describe how to use memory-optimized tables and natively compiled procedures.

Details

Last Updated On: February 9th, 2024 at 8:32 am
Method:NG
medium:NG
commencement:Soon
duration:02 Days
Location:Colombo

Features

  • Alumni Association
  • Book Shop
  • Cafeteria
  • Clubs and Societies
  • Labs
  • Library
  • LMS
  • Medical Facilities
  • Parking
  • Recreation Area
  • Relaxation Area
  • Student Center
  • Study Area
  • Wi-Fi

Statistics

Schedule a Call

Similar Programs

AWS Certified Solutions Architect – Associate

InnoventSys (Pvt) Ltd, Park Street, Colombo, Sri Lanka

Beds NG
Baths NG
Size 0 NG

AWS Certified Developer – Associate

InnoventSys (Pvt) Ltd, Park Street, Colombo, Sri Lanka

Beds NG
Baths NG
Size 0 NG

CSPO – Certified Scrum Product Owner

InnoventSys (Pvt) Ltd, Park Street, Colombo, Sri Lanka

Beds NG
Baths NG
Size 2 Days

CSM – Certified Scrum Master

InnoventSys (Pvt) Ltd, Park Street, Colombo, Sri Lanka

Beds NG
Baths NG
Size 0 NG

POPM – SAFe 5.0 Product Owner / Product Manager

InnoventSys (Pvt) Ltd, Park Street, Colombo, Sri Lanka

Beds NG
Baths NG
Size 2 Days

SSM – SAFe 5.0 Scrum Master

InnoventSys (Pvt) Ltd, Park Street, Colombo, Sri Lanka

Beds NG
Baths NG
Size 2 Days

Write a Review

You should logged in first to add a review.

Compare programs
Add programs to compare.