MTA: Database Fundamentals
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