Skip to content
eCollege Logo
  • Courses
    • Office Productivity

      ECDL

      Digital Design

      Digital Marketing

    • Computer Programming

      Programming

      Databases

      Databases

    • Data Science

      Data Science

      IT Professional

      IT Professional

    • Business

      Business

      Sustainability

      miscellaneous

  • Apply
  • Login
  • Courses
    • Office Productivity
    • Digital Design
    • Computer Programming
    • Databases
    • Data Science
    • IT Professional
    • Business
    • Sustainability
  • Apply
  • Login

Information Technology Specialist Databases

Information Technology Specialist Databases2023-01-27T16:20:28+00:00
  • Overview

  • Content

  • Requirements

  • Progression

  • Apply

  • Overview

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:

  • Design Databases
  • Perform Database Management using DDL
  • Perform Data Retrieval
  • Perform Data Manipulation using DML
  • Perform 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
  • Content

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

  • Requirements

Prerequisites & Requirements

Prerequisites

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.

Is this course for me?

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

What are the hardware requirements?

  • 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.

What software will I need?

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. .
  • Progression

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:

  • Oracle Certified Associate Database SQL
  • Apply

Course Code: NC12388 – IT Specialist in Databases

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

FETCH Courses

FETCH is the further education and training course finder. To apply for this course use the button below.

Apply Now

Unemployed - Intreo

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

Employed - Skills to Advance

Skills to Advance is the further education and training initiative for people in employment.

Find out more

Related Courses

2023-01-27T16:17:32+00:00
IT Specialist Python

Information Technology Specialist Python

2023-01-27T16:17:48+00:00
Oracle Certified Associate Database SQL Featured Image

Oracle Certified Associate Database SQL

2023-01-27T16:18:54+00:00
Software Testing

Software Testing – ISTQB Certified Tester – Foundation Level

2023-01-27T16:18:41+00:00
Java Professional

Java Professional Developer SE8 (Programmer II)

2023-01-27T16:18:28+00:00
Java Associate

Java Associate Developer SE8 (Programmer I)

2023-01-27T16:18:07+00:00
Java Foundation

Java Foundations Certified Junior Associate

2023-01-27T16:17:18+00:00
JavaScript

Information Technology Specialist JavaScript

2023-01-27T16:21:10+00:00
HTML and CSS

Information Technology Specialist HTML and CSS

Quick Links

  • News
  • FETCH Courses
  • Frequently Asked Questions
  • Study Tips
  • Privacy
  • Complaint and Cancellation Policies
  • Accessibility

Contact Us

  • 1800 855 831
  • ecollegeinfo@solas.ie

News

  • CompTIA IT Fundamentals
  • Information Technology Specialist Update
  • Microsoft Office Specialist 2019

Solas Logo

Government of Ireland Logo

Login

log in to eCollege
Forgotten your username or password?
 
Copyright 2023 eCollege | All Rights Reserved
Page load link
Go to Top