Skip to content
The IT Specialist: Databases course provides practical and introductory training in the fundamental principles of databases. Participants will explore key concepts related to relational database design and implementation, data manipulation using SQL, database object management, and data administration and security techniques.
This course is specifically designed to prepare candidates for the official IT Specialist – Databases certification, issued by Certiport.
-
Duration
40h (Online)
Objectives
Upon completion of the course, students will be able to:
- Understand the fundamentals of relational databases and their terminology.
- Design and implement efficient database structures.
- Use SQL languages to manipulate and query data.
- Manage database objects such as tables, views, and stored procedures.
- Apply database administration and security techniques.
Program
- Module 1: Database Design.
- Fundamental concepts of relational databases.
- Schematic design and standardization.
- Definition of primary and foreign keys.
- Module 2: Data Definition Language (DDL).
- Creating and modifying tables and views.
- Implementation of constraints and relationships.
- Using indexes to optimize queries.
- Module 3: Data Manipulation Language (DML).
- Inserting, updating, and deleting records.
- Data selection and filtering queries.
- Aggregation and grouping of results.
- Module 4: Database Administration and Security.
- User and permission management.
- Data backup and recovery.
- Performance monitoring and optimization.
