Database Administration Fundamentals MTA

Database Administration Fundamentals MTA_2016 (MTA 2016)

This five-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.

Category

Database
Duration

24 Hours
Level

Beginner

What Will I Learn ?

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 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.

Prerequisite Knowledge

Basic knowledge of the Microsoft Windows operating system and its core functionality.

Working knowledge of Transact-SQL.
Working knowledge of relational databases.

Who can benefits ?

Opportunity Scope

Mentor shall discuss on classroom.

Modules / Chapter

Module 1: Understanding Core Database Concepts

Module 2: Creating Database Objects

Module 3: Manipulating Data

Module 4: Understanding Data Storage

Module 5: Administering a Database

Enquiry Form

Required fields are marked (*).

(Max 350 words only)

Contact Information

Address

Anamnagar - 32 Kathmandu, Nepal
Email

info@labanepal.com
Phone

+977-1-4102721, 4102722, 4244804
Opening Hours

10 AM - 5 PM

Registration Form

Required fields are marked (*).

(Max 350 words only)

Contact Information

Address

Anamnagar - 32 Kathmandu, Nepal
Email

info@labanepal.com
Phone

+977-1-4102721, 4102722, 4244804
Opening Hours

10 AM - 5 PM

LABA established in 2009 is the most advanced IT training service provider in Nepal. The training center offers blended IT learning solutions comprising Classroom training, Onsite training and E-learning directly from the global vendors.

More..

Database Administration Fundamentals Mta2016