Thank you for watching my video
Microsoft Database Fundamentals l Complete 7 Hour Course MTA 98-364
This is a full database course for the Microsoft MTA 98-364 exam. This exam retires in June 2022. Our CompTIA Data+ course is launching soon so please check it out.
https://www.howtonetwork.com/courses/comptia/comptia-data-da0-001/
Here is the MTA Database Fundamentals Microsoft page:
https://docs.microsoft.com/en-us/learn/certifications/exams/98-364
MODULE 1 - Understanding Core Database Concepts
===========================================
0:00:00 - Introduction
0:3:56 - Understand how data is stored in tables
0:29:35 - Understand relational database concepts
0:50:02 - Understand data manipulation language (DML)
0:58:08 - Understand data definition language (DDL)
MODULE 2 - Creating database objects
===============================
1:34:18 - Choose data types - Part 1
1:59:49 - Choose data types - Part 2
2:25:56 - Understand tables and how to create them
2:50:18 - Create views
3:03:02 - Create stored procedures and functions
MODULE 3 - Manipulating Data
=========================
3:33:48 - Select data - Part 1
4:01:28 - Select data - Part 2
4:26:09 - Insert and update data
4:40:04 - Delete data
MODULE 4 - Understanding Data Storage
=================================
4:57:23 - Understand normalization
5:28:55 - Understand primary, foreign and composite keys
5:44:28 - Understand indexes
MODULE 5 - Administering a Database
===============================
5:56:18 - Understand database security concepts
6:23:38 - Understand database backups and restore
Check out my IT books on Amazon:
Cisco CCNA Simplified - https://amzn.to/2Kqfvin
Cisco CCNA in 60 Days - http://amzn.to/2yr9aMA
101 Labs - Cisco CCNA - https://amzn.to/32Jj7q6
101 Labs - Linux LPIC1 - https://amzn.to/2zKby2Q
101 Labs - Wireshark WCNA - https://amzn.to/32JhLvp
101 Labs - CompTIA Network+ - https://amzn.to/2B6JlEX
101 Labs - IP Subnetting - https://amzn.to/2qWljqh
101 Labs - Cisco CCNP - https://amzn.to/3kA4gEN
IP Subnetting - Zero to Guru - https://amzn.to/2DMA9Hy
ABOUT OUR CHANNEL
IT certification videos, exams, and follow-along labs.
We've been helping people from all walks of life pass their IT exams and enjoy awesome careers since 2002. Let us help you too. With access to all areas pass, you get all the video training, practice exams, and access to live Cisco racks 24/7.
CHECK OUT OUR OTHER VIDEOS
️ Top 10 Hot Certifications In IT For 2022:
https://youtu.be/33YD-Rjj2cc
️ Programming Networks & Automation | APIs & Python Scripts - Beginners Guide:
https://youtu.be/rz1JdzlIGhU
️ Intrusion Detection and Prevention Systems (IDC/IPS):
https://youtu.be/rnk31R-3LUQ
️ Microsoft MTA Exam 98-349 - Windows Operating System Fundamentals | Complete Workbook |:
https://youtu.be/C8U1v4lU-gg
️ Lesson and Lab on Rapid Spanning Tree Protocol:
https://youtu.be/na9Ija2fNCg
FIND US AT
https://www.howtonetwork.com/
FOLLOW US ON SOCIAL
Facebook - https://www.facebook.com/howtonetwork
101 Labs - Cisco CCNP - https://amzn.to/3kA4gEN
Related Searches :
What is the Microsoft database fundamentals certification
Does MTA Database Fundamentals expire
What is MTA Database Fundamentals
MTA 98-364 Database Fundamentals Preparation Course