Information Technology
Hands on Training icon
Hands On Training
Hands on Training icon

Microsoft MTA: Database Administration Fundamentals

Course Cover
compare button icon

Course Features

icon

Duration

275 minutes

icon

Delivery Method

Online

icon

Available on

Downloadable Courses

icon

Accessibility

Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Beginner

icon

Teaching Type

Self Paced

icon

Video Content

275 minutes

Course Description

This course is designed for those who are new to relational databases. It guides you from the basics of SQL Server and shows how it can be used in real life. This course will not only give you new knowledge but also cement it by allowing you to see it in action and be able to continue the discussion at home.

Course Overview

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

What You Will Learn

Learn about backup and recovery

Learn about basic queries

Learn about complex conditions

Learn about continual maintenance

Learn about creating and using tables

Learn about creating and using views

Learn about creating stored procedures

Learn about database data types

Learn about database normalization

Learn about different types of databases

Learn about indexes

Learn about introducing the sql server management studio

Learn about keys and constraints

Learn about modifying data

Learn about multi-table queries

Learn about relational database concepts

Learn about security

Learn about the sql language

Learn about database administration fundamentals

Course Cover