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, and 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:

  • Database Design
  • Database Object
  • Management using DDL
  • Data Retrieval
  • Data Manipulation using DML
  • Troubleshooting

  • Duration: 16 weeks

  • Exam: IT Specialist in Databases (ITS-201). Read more about the certification.

    The IT Specialist in Databases (ITS-201) is an official entry-level accreditation. It proves you have taken the first step toward building a successful career in information technology by displaying 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

Course Topics

Topic 1

Database Design

Topic 2

Database Object Management using DDL

Topic 3

Data Retrieval

Topic 4

Data Manipulation using DML

Topic 5

Troubleshooting

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 will be required to install Microsoft SQL Server and a development tool called SQL Server Management Studio. If you cannot install this software, an online tool can be used as an alternative. .

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 IT Specialist in Databases (ITS-201) certificate you can further your studies by enrolling in the following course through eCollege:

Course Code: NC12388 – IT Specialist in Databases

Is this course for you?

There are multiple ways to apply for this course, please check out the different options below.

At the moment, Solas has made eCollege courses available to the public. You can apply for the course using the button below.

Apply Now

If you are currently unemployed, you will find the contact details for your local Intreo office by using the button below. An Intreo officer will be able to guide you through your application.

Learn More

Skills To Advance aims to equip employees with the skills to progress in their current job, or to take advantage of new job opportunities.

Employees – Learn MOre
Employers – Learn More

Related Courses