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
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
Practice exercises and quizzes
A certification exam voucher
Course Handbook
Course Topics
Database Object Management using DDL
Data Manipulation using DML
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
There are multiple ways to apply for this course, please check out the different options below.
FETCH is the further education and training course finder. To apply for this course use the button below.
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.
Skills to Advance is the further education and training initiative for people in employment.
