Contact
Let's work together
Technical SkillBTSDeveloping

Database Fundamentals

Competency Description

Manage relational databases (MySQL, Microsoft Access, SQL Server), execute SQL queries, and ensure data integrity and backup procedures.

Personal Confidence
Developing2/5
FoundationalDevelopingProficientAdvancedExpert

This reflects my personal confidence in applying this competency in real-world professional situations, based on hands-on experience, continuous learning, and practical outcomes.

Related Courses in BTS Program

BTS program modules covering this competency

Block 1 - Support and Provision of IT Services (Common Core)
IT Asset Management
IT asset management tools (GLPI, OCS Inventory)Backup and restore proceduresLicense and software managementHardware lifecycle management
Block 1 - Support and Provision of IT Services (Common Core)
User Support and Incident Resolution
Incident escalation proceduresUser satisfaction management
Block 1 - Support and Provision of IT Services (Common Core)
Workplace Setup and Service Deployment
Printer and peripheral managementMobile device management
Block 1 - Support and Provision of IT Services (Common Core)
Project Participation and Web Presence
Project management tools (Kanban, Gantt)Institutional website management
Block 2 - Infrastructure, Systems and Network Solutions (SISR / ex-ARLE)
Network Administration
Secure wireless access point deployment
Block 2 - Infrastructure, Systems and Network Solutions (SISR / ex-ARLE)
System Administration
Windows Server installation and configurationActive Directory and group policy managementPrint services and server roles management
Block 2 - Infrastructure, Systems and Network Solutions (SISR / ex-ARLE)
Virtualization and Cloud Computing
Virtual machine creation and managementCloud computing fundamentals (IaaS, PaaS, SaaS)
Block 2 - Infrastructure, Systems and Network Solutions (SISR / ex-ARLE)
Network Supervision and Monitoring
Log management and analysis
Block 2 - Infrastructure, Systems and Network Solutions (SISR / ex-ARLE)
Scripting and Automation
Scheduled task managementConfiguration management basics
Block 3 - Cybersecurity of IT Services
Cybersecurity Fundamentals
Personal data protection and digital identitySecurity incident response procedures
Block 3 - Cybersecurity of IT Services
Infrastructure Security (SISR Specialization)
Firewall configuration and managementVPN implementation and managementServer vulnerability auditing
Block 3 - Cybersecurity of IT Services
Data Protection and GDPR Compliance
Personal data processing legal basesData subject rightsData Protection Impact Assessment (DPIA)Breach notification procedures
Block 4 - Transversal Training
Economic, Legal and Managerial Culture (CEJM)
Management structures
Source Program

This competency was developed as part of the BTS in IT Management, ARLE specialization (Lycée Gustave Eiffel, Bordeaux).