Learn how to master databases!
Eligible CPF and multi-financing up to 100%
To be recalled Access to the programmeApproach 3P
Our training centre guides you in identifying the ideal training, helping you maximize funding opportunities.
We put all the keys in hand for a start with confidence.
Experience an immersive and intensive training experience, designed to dive into practical workshops and real case studies.
Learn by doing, and develop concrete skills directly applicable to your future projects.
At the end of your career, we evaluate your acquired skills, issue certification attesting to your expertise, and accompany you to ensure your success in your professional projects.
You are now ready to excel!
Description of the training
This training covers the essential concepts of modeling, and data management and querying, focusing on data structures, tables, relationships, and the use of SQL to manipulate and extract information.
Objectives of training
At the end of this training, participants will be able to:
Acquire SQL Databases: Learn how to write simple SQL queries to interact with a database.
Understanding the concepts of relational databases: To become familiar with the structure of databases, tables, and the relationships between them.
Mastering data manipulation techniques: Knowing how to insert, modify, delete and query data effectively.
Apply good data management and standardization practices.
Develop practical skills to manage and optimize databases.
Who is this training for?
The training is aimed at a wide audience, including:
Beginners in database management
Data analysts
Beginner Developers
Project managers or managers
Computer or data consultants
Prerequisites
Basic knowledge of information systems.
Programme
The training programme is structured around several main modules:
Introduction to Basic Databases and SQL Queries
- Introduction to relational databases: Database concept, tables, rows, columns, and table relationships.
- Data modeling: Understanding entities, relationships, and ER (Entity-Relation) diagrams.
- Basic SQL requests: Introduction to SQL language, writing SELECT requests for querying data.
- Table creation and modification: Syntax to create tables, define columns and data types.
- Management of Primary and Foreign Keys: Define relationships between tables and apply reference integrity.
- Introduction to joins: Types of joins (INNER JOIN, LEFT JOIN, etc.) to combine data from multiple tables.
- Aggregation Functions: Using functions like CUNT, SUM, AVG to analyze data sets.
- Standardization of databases: The principles of standardization, the normal forms (1NF, 2NF, 3NF).
- Design of a relational database: Apply standardization to avoid redundancy and improve data efficiency.
- SQL Transactions: Introduction to transactions, COMMIT and ROLLBACK commands, transaction management to ensure data integrity.
- Security and Access Control: Security terms in databases (user management, access privileges).
Training assets
Pedagogical approach alternating theory and practice.
Qualified trainers with experience in Big Data.
Access to modern teaching tools and resources.
Training accessible to all, without advanced technical prerequisites.
Pedagogical methods and tools used
Live demonstrations on SQL tools and platforms.
Real case studies with analysis of concrete solutions.
Group work to foster interaction and practical learning.
Feedback on best practices in business.
Evaluation
The evaluation is carried out in a number of ways:
- End of training QCM to test the understanding of the concepts addressed.
- Practical case studies or group discussions to apply the knowledge gained.
- Ongoing evaluation during practical sessions.
Normative References
SQL Standards:Compliance with SQL standards (SQL:1992, SQL:2003) for control of data queries and manipulations.
Good Data Management Practices:Application of standardization and reference integrity in database design.
Industrial standards:Compliance with ISO/IEC 9075 standards to ensure the quality and portability of relational databases.