About Course
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.
Course Content
MTA: Database Fundamentals
-
DBA Fundamentals
00:00 -
Multiple Table – Queries
00:00 -
Modifying Data
00:00 -
Database Normalization
00:00 -
Keys and constraints
00:00 -
Indexes
00:00 -
Security
00:00 -
Continual Maintenance
00:00 -
Backup and Recovery
00:00 -
Complex conditions Database
00:00 -
Basic Queries
00:00 -
Different types of Databases Database
00:00 -
Relational Database Concepts
00:00 -
Database Data types
00:00 -
The SQL Language
00:00 -
Introduction to SSMS SQL Server
00:00 -
Creating and Using Tables
00:00 -
Creating and Using Views
00:00 -
Creating Stored Procedures
00:00 -
DBA Exam preparation (98-364) certification exam
00:00
Student Ratings & Reviews
No Review Yet