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
Course Topics
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.
A broadband connection is essential to stream video content.
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:
- Microsoft Technology Associate – Networking Fundamentals
- Microsoft Technology Associate – Software Development Fundamentals