MTA 98-364 Database Fundamentals Preparation Course

Everything you need to know to pass the Microsoft Technology Associate 98-364 Database Fundamentals Certification Exam

4.70 (378 reviews)
Udemy
platform
English
language
IT Certification
category
instructor
1,153
students
4 hours
content
Jan 2021
last update
$64.99
regular price

What you will learn

Fundamentals of Relational Databases

Core Database Concepts

Query Relational Databases

Fundamentals of Creating Database Objects

Database Administration Fundamentals

Description

Note: This course has been remade with several improvements. Check out my SQL Server Database Fundamentals course.

Become a Microsoft Technology Associate and get recognized for demonstrating introductory knowledge of and skills with databases, including relational databases, such as Microsoft SQL Server.

In this self-paced course, 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.

In short, the following objectives will be covered:

  • Understanding core database concepts

  • Create database objects

  • Manipulate data

  • Understand data storage

  • Administer a database

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

MTA certifications are a great place to start if you would like to get into the technology field. MTA certifications address a wide spectrum of fundamental technical concepts, assess and validate core technical knowledge, and enhance technical credibility.

**This is a dedicated preparation course for the Microsoft Technology Associate: 98-364 Database Fundamentals Exam**

Content

Introduction

Welcome to this Course!
Introduction
SQL Server 2016 DE Quick Installation Guide

Core Database Concepts

Introduction to Databases
Types of Databases

Relational Database Concepts

Normalization
Constraints
Database Keys

Querying and Manipulating Data

Introduction to T-SQL
SQL Server Data Types
Introduction to SQL Server Management Studio
Querying Databases
Querying Databases - Aliasing
Querying Databases - Filtering
Querying Databases - Ordering
Querying Databases - Aggregate Functions
Querying Databases Grouping
Querying Databases - Joins
Querying Databases - SET Operators
Manipulating Data - Inserting Data
Manipulating Data - Updating Data
Manipulating Data - Deleting Data

Creating Database Objects

Tables
Views
Functions
Triggers
Stored Procedures
Introduction to Indexes

Database Administration Fundamentals

Securing a SQL Server Database
Backing up and Restoring a SQL Server Database

Assessment

Assessment
Complete set of practice questions

Screenshots

MTA 98-364 Database Fundamentals Preparation Course - Screenshot_01MTA 98-364 Database Fundamentals Preparation Course - Screenshot_02MTA 98-364 Database Fundamentals Preparation Course - Screenshot_03MTA 98-364 Database Fundamentals Preparation Course - Screenshot_04

Reviews

Marilize
March 22, 2022
If you want to pass the MTA 98-364 Database Fundamentals Exam the first time this Course is a must. It assisted me in passing the first time with 96%. The only reason why I didn't rate it 5 stars is the Computerized Voice makes the course less engaging and extremely hard to stay concentrated the whole time
ICM
July 26, 2021
Terrible Monotone voice with no practice questions and little checks for understanding. If you want to prepare for the exam look elsewhere
Russell
May 9, 2021
I wasted a lot of money on other prep courses before this one. The content is spot on, and the delivery is excellent. Seriously consider this course first.
Sergio
February 22, 2021
Good content, but the course could be much better with a less monotonous computer voice and additional exercises
Abdulaziz
January 10, 2021
Hi Rwynn, today I passed my MTA exam with 96! I would like to thank you. I tried several other courses and sample tests from other sources but there were lots of mistakes. I found yours the most accurate and during the test almost half of the questions were identical with your sample test questions. The rest was similar. I left my recommendations in test's announcement part. Thanks a lot. I am already recommending your course and tests to my friends! This course will not be enough, you should also take Rwynn's sample test and practice it a lot. The teacher is quick in response.
Peter
January 2, 2021
Amazing course! Since he cares about his students, Rwynn is not an instructor, he is a truly teacher. His explanations are flawless. If I could, I would only buy Rwynn's courses. So, please speed up with your DP-300 course :) Best regards.
Wolee
December 28, 2020
Voice synthesizer got me scared at the beginning but it's actually better than a human voice, everything is explained very nicely
Sevan
November 17, 2020
Greatly prepared course and such a good instructor, I am glad that I selected it. Rwynn is quite helpful also, if you have questions.
Deon
November 13, 2020
Having taken a database administration course before, this was a good refresher, although it did not go into T-SQL database backup.
Daniel
November 4, 2020
I really enjoyed taking this course. I've already had experience working with databases so it was a good review for me.
Radito
October 26, 2020
I purchased both Prep and the Exam example. Pass the exam with 84. Purchase both if you want to pass.
Paula
May 10, 2020
The computerized voice talks to fast at times and with no speech intonation, it makes it difficult sometimes to know when a new sentence is starting.
Mohammad
May 9, 2020
This course is a great start for understanding basic database fundamentals and concepts, specially for someone without any database background such as myself, thanks to the instructor's well crafted and easily digestible topics with practical examples, immediate responses to all related questions and support. Thank you Rwynn
David
May 7, 2020
The voice sounds like a text to speech program with no emotion. It sometimes is hard to follow along with.
Robert
May 7, 2020
I already knew almost all of the material since I have an MCP in SQL Server 2000. I just wanted to ensure I was aware of the type of material the test would cover. I don't have the time currently to study for the 70-461 and 70-462 tests which are due to retire in January of 2021.

Charts

Price

MTA 98-364 Database Fundamentals Preparation Course - Price chart

Rating

MTA 98-364 Database Fundamentals Preparation Course - Ratings chart

Enrollment distribution

MTA 98-364 Database Fundamentals Preparation Course - Distribution chart
2861116
udemy ID
3/9/2020
course created date
4/14/2020
course indexed date
Bot
course submited by