Responsive menu button

About This Course

Databases courses have increased in popularity as companies all over the world have moved to housing all their information online. Database learning is one of the few areas of learning that is represented in all IT learning streams. If you’re working towards a career as an IT professional, the MTA Database Fundamentals course is perfect for teaching you the basics.

It teaches you core database concepts and how to correctly create database objects without issues. It makes sure you know how to manipulate data, helping your understanding of how to administer data and data storage.

The content of this course will prepare you for Microsoft’s 98-364 certification exam.

Duration: 16 Weeks
Participants: 25
Certification: Microsoft's 98-364 MTA Database Fundamentals certification

Learning Outcomes

Upon completion of this course participants will be able to:

  • Understand Core Database Concepts
  • Create Database Objects
  • Manipulate Data
  • Understand Data Storage
  • Administer a Database

Who Should Attend

If you are unemployed and new to IT this course is perfect for teaching you the basics of Databases. It is a great starting point for a career in IT or Data Analytics. Students taking this course can then progress through the Database pathway in the Microsoft Certified Path.

Course Syllabus

Module 1: Core Database Concepts

  • Understand how data is stored in tables
  • Relational Database concepts
  • Data Manipulation Language (DML)
  • Data Definition Language (DDL)

Module 2: Create Database Objects

  • Understanding Data Types and how they are used.
  • Understanding Tables and how to create them
  • Create Views
  • Create Stored Procedures and Functions

Module 3: Manipulating Data

  • Utilise SELECT queries to extract data from one table, extract data by using joins, combine result sets by using UNION and INTERSECT
  • Understand how data is inserted into a database, how to use INSERT statements
  • Update data in a database and learn how to write the updated data to the database by using the appropriate UPDATE statements, update by using a table
  • Delete data from single or multiple tables, ensure data and referential integrity by using transactions

 Module 4: Understanding Data Storage

  • Normalisation
  • Primary Keys, Foreign Keys and Composite Keys
  • Understanding Indexes

Module 5: Administering a Database

  • Database Security Concepts
  • Database backup and Storage
© 2021 Future In Tech