Shape field (scope)

TÜV HELLAS Database Developer or Database Administrator scheme applies to employees who are involved in performing tasks of database analysis and design, extraction, import and update of data

 

Subforms / Specialisations

 

There are two levels of certification: basic and advanced. The basic level is mainly concerned with the knowledge background that a person must have in the specialisation and is introductory, while the advanced level is concerned with the competences that the professional must demonstrate if he/she has relevant experience. In the case of the advanced level only, it will be explicitly stated on the certificate.

 

Syllabus: Database developer

General knowledge of databases

• Database terminology
• Use of at least one RDBMS system from SQL Server and MySQL
• Definition of users and rights in databases

 

SQL database analysis and design

• Identification of entities and their attributes
• Identification of 1-1, 1-N, N-M relationships between entities
• DDL (Data Definition Language) commands
• Schema creation
• Identification and implementation of primary and foreign keys
• Identification and implementation of constraints
• Definition and implementation of indexes
• Definition and implementation of views
• Identification of the need to use Transactions
• Understanding of the concept of concurrency and the resulting risks (deadlocks)

 

Data management with SQL

• DML (Data Manipulation Language) commands
• SQL keywords and syntax
• Using the SELECT command to retrieve data
• Use of the INSERT command to insert data
• Using the UPDATE command to edit data
• Using the DELETE command to delete data
• concatenation according to ANSI SQL
• Use of the numeric functions COUNT, SUM, MAX, MIN, AVG
• Use of the keyword HAVING with the numeric operations
• Use of the key phrase GROUP BY with the numeric operations
• Use of synonyms - ALIASES for fields and tables
• Use of the different types of JOIN commands: INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN, CROSS JOIN
• Use of the key phrase ORDER BY
• Use of subqueries
• Use of UNION, UNION ALL, INTERSECT commands to extract combined results
• Internal order of execution in queries Examples (Code)
• DBMS systems
• SQL Quick Guide
• Oracle administration
• Design and development of web applications
• Non-relational NOSQL databases

 

Data protection

• Data security
• Personal data
• Information Systems Security
• Authentication & Encryption
• Application, Systems & Systems Security Data

 

Cognitive framework (syllabus ) Database Manager

 

Introduction to databases and general knowledge

• Database terminology
• Use of at least one RDBMS system of SQL Server and MySQL
• Definition of users and rights in databases
• Application, Systems & Systems Security Data

 

DBMS

• DBMS architecture and components
• Categories of DBMS
• MySQL Server Installation

 

Database Design and Management

• Identification of entities and their attributes
• Recognition of 1-1, 1-N, N-M relationships between entities
• Entity association model
• Role of Database Administrator
• Representation of Entity Associations

 

Databases and SQL

• Identification and implementation of primary and foreign keys
• Identification and implementation of constraints
• Defining and implementing indexes
• Defining and implementing Views
• Recognition of the need to use Transactions
• Understanding of the concept of concurrency and the resulting risks (deadlocks)

 

Data management with SQL

• DML (Data Manipulation Language) commands
• SQL keywords and syntax
• Use of SELECT, INSERT, DELETE, UPDATE commands
• Concatenation according to ANSI SQL
• Use of the numeric functions COUNT, SUM, MAX, MIN, AVG
• Use of the keyword HAVING with the numeric functions
• Use of the key phrase GROUP BY with the numeric operations
• Use of synonyms - ALIASES for fields and tables
• Use of the different types of JOIN commands: INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN, CROSS JOIN
• Use of the key phrase ORDER BY
• Use of subqueries
• Use of UNION, UNION ALL, INTERSECT commands to extract combined results
• Internal order of execution in queries Examples (Code)
• SQL Command Summary Guide

 

 

Exam methodology

 

Theoretical examination and practical examination

 

Certification requirements

 

Minimum Compulsory education