Project Description

Overview

This online course will teach you the fundamental concepts and technologies relating to database development and administration.

You will learn about relational databases, SQL (Transact SQL, both DDL, DML), how to create a database, how to manipulate data in a database, the purpose of tables, queries, data types, normalisation, stored procedures, and administering a database: database security concepts, backup types, and more.

After completing this course, you will know how to:

  • Understand core database concepts
  • Create database objects
  • Manipulate data
  • Understand data storage
  • Administer a database

  • Duration: 16 weeks

  • Exam: Microsoft Technology Associate (MTA) in Database Fundamentals – 98-364. Read more about the certification.

    The Microsoft Technology Associate (MTA) is an official entry-level accreditation from Microsoft. It proves you have taken the first step toward building a successful career in information technology by displaying a foundational competence in the field.

  • Support: eTutor Supported

What’s Included

  • All course content

  • Practice exercises and quizzes

  • A practice exam

  • A certification exam voucher

Course Handbook

Download Course Handbook
For privacy reasons Vimeo needs your permission to be loaded.
I Accept

Course Topics

Topic 1

Understanding core database concepts

Topic 2

Creating database objects

Topic 3

Manipulating data

Topic 4

Understanding data storage

Topic 5

Administering a database

Prerequisites & Requirements

There are no mandatory requirements, however potential students should be familiar with the basic concepts of relational databases, SQL, and Microsoft’s SQL Server database management systems prior to signing up.

If you have an ambition to create databases and learn new skills in business strategy and analysis, this course will suit your needs.

  • All students should have access to a PC or laptop running a supported version of Windows (e.g Windows 10). Apple/Android devices are not supported and cannot be used for this course.
  • A broadband connection is essential to stream video content.

You only require a web browser to view the content and access web platforms.

Employment

This entry-level accreditation could be a gateway to a career in the database field. After earning your certificate you may confidently seek employment in junior roles in database development, database administration, software development or data science.

Academic

After earning your official MTA Database Fundamentals certificate you can further your studies by enrolling in the following Changing Career to IT courses through eCollege:

Is this course for you?

Find out how to apply by tapping the button below.

Please note you can only be enrolled on one eCollege course at any one time. 

Course Code: NC 11689

Apply Now

Related Courses