0(0)

MTA: Database Fundamentals

  • Course level: Intermediate

Description

http://https://youtu.be/CBcuTERS2Sk

MTA: Database Fundamentals. This is a practical course for someone new to relational databases that moves you through basic concepts right into real-world usage, demonstrating core tasks in Microsoft SQL Server itself.

You’ll not only gain new knowledge but cement that knowledge by seeing it in action and being able to follow along at home. I’ll cover the objectives tested on the Microsoft Technology Associate (MTA) 98-364 Database Fundamentals Exam. I’ll be taking you from the basic understanding of database concepts to writing your own queries, selecting data, modifying data, and creating database structures. Along the way, I’ll explain the key concepts, demonstrate the syntax, and give you an opportunity to test the skills you have acquired during this course.

This MTA course consists of presentations to cover the theoretical objectives of the exam and demonstrations to cover the practical skills required to pass the exam.

>

What Will I Learn?

  • Fundamentals of Relational Databases
  • Core Database Concepts
  • Query Relational Databases
  • Fundamentals of Creating Database Objects
  • Database Administration Fundamentals

Topics for this course

20 Lessons

MTA: Database Fundamentals

DBA Fundamentals00:00:00
Different types of Databases Database00:00:00
Relational Database Concepts00:00:00
Database Data types00:00:00
The SQL Language00:00:00
Introduction to SSMS SQL Server00:00:00
Creating and Using Tables00:00:00
Creating and Using Views00:00:00
Creating Stored Procedures00:00:00
Basic Queries00:00:00
Complex conditions Database00:00:00
Multiple Table – Queries00:00:00
Modifying Data00:00:00
Database Normalization00:00:00
Keys and constraints00:00:00
Indexes00:00:00
Security00:00:00
Continual Maintenance00:00:00
Backup and Recovery00:00:00
DBA Exam preparation (98-364) certification exam00:00:00
MTA
75 £

Enrolment validity: Lifetime

Requirements

  • SQL Server
  • SQL Server Management Studio