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
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
Practice exercises and quizzes
A certification exam voucher
For privacy reasons Vimeo needs your permission to be loaded.I Accept
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.
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.
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