MTA: Database Fundamentals

Wishlist Share
Share Course
Page Link
Share On Social Media

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.

>

Show More

What Will You Learn?

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

Course Content

MTA: Database Fundamentals

  • DBA Fundamentals
    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
  • Basic Queries
    00:00
  • Complex conditions Database
    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
  • DBA Exam preparation (98-364) certification exam
    00:00

Student Ratings & Reviews

No Review Yet
No Review Yet
ResearcherStore

Want to receive push notifications for all major on-site activities?