BEM content 

(for all partners) 

 Title/name of the credential  Structured Query Language (SQL) Fundamentals and Advanced Querying 
Function of the micro-credentials / purpose   This microcredential aims to give learners basic to intermediate training on SQL, needed to design, manage, and query relational databases. By the end of this course, learners will acquire the skills necessary to function properly in a database environment and will successfully be prepared for careers in data management, analysis and software development. 

 
Possible target groups  Individuals of all backgrounds and ages interested in starting their career as data scientists  

 
Branch/sector of application  Information Technologies  

Data Management   

 
Fields of application / work environment  Database Administration 

Data Manipulation and Analysis 

Business Intelligence 

 

 
Typical work/professional tasks  Designing and creating relational databases; 

Execute simple and complex SQL queries to insert, update and delete data, as well as to produce  joins, subqueries, and grouping of data; 

Combine and manipulate data from multiple tables; 

Generate reports and conduct data analysis; 

Integrate data from different sources.  

 

 

 
Learning outcomes (personal and job related)  Knowledge  Skills  Competences 
Knowledge: 

Understanding the core principles of Relational Database Management System (RDBMS) – the architecture, functionality and purpose, including concepts like tables, relationships, and primary/foreign keys. 

In-depth knowledge of SQL commands, joins, subqueries, data combination techniques, functions for grouping data, calculating aggregates and of advanced SQL functions for more complex data analysis.  

 

Skills: 

Ability to: 

  • Design and structure databases, including defining tables, specifying appropriate data types, and establishing relationships between tables; 
  • Write and execute basic SQL queries to retrieve and manipulate data; 
  • Conduct more complex SQL operations, such as performing joins, writing subqueries, and combining data from different tables; 
  • Use SQL to group data, compute aggregates and perform advanced calculations. 

 

 

 

Learning outcomes should be formulated in commonly accepted way, see the link:https://eurspace.eu/ecvet/pedagogicalkit/framework-for-defining-learning-outcomes-knowledge-skills-competence/ 

Can be used the formulation format of National Qualification Framework descriptors, adjusting and applying that format for relevant job. 

 

 

 

 

 

 
Validation   criteria  procedures 

Validation will be conducted through a practical assignment. 

 

Procedure:  

Students will be given a task to design and create a functioning relational database, where they will also define relationships and carry out basic and complex database functions, such as: insertion, updating, deletion of records, joins, subqueries, grouping and data manipulation. 

  

Criteria:  

Fully operational database with correct table structures, relationships, and data manipulation using SQL. 

 
Recognised/accepted (documented by MoU)  Name of companies 

Target Group  

 
Provider(s)  Private EduTech companies, Vocational-Educational schools  

 
Additional information 

(if needed) 

 Entry level / prerequisites 

 

No pre-knowledge needed  

 

20 hours (10 theoretical + 1o practical) 
Possible duration (recommendation) 
Specific content (national) 

(if needed) 

 Position in the chain of educational programmes  1st out of 2 micro credentials on SQL 
Reference to NQF 
Credits