fr
en
Master relational databases
Your applications depend on well-administered databases. Connect configuration, operation and maintenance in relational database environments to work more methodically. Strengthen your independence and ability to monitor the environment against service requirements.
- Duration
- 6 days 42 hours
- Code
- BDR-CF-FR Code
Presentation
Databases are central to our online activities, from making a bank transfer and checking email to finding directions or a weather forecast. Behind each action is a database storing the information collected. Databases provide persistent storage while ensuring security, reliability and large-scale access for users.
This introductory course provides an overview of essential current database management system knowledge. It is designed for anyone who needs to design and implement a database. Each lesson includes practical work using the main tools and methods. The course covers database design and creation, as well as SQL.
Objectives
During this database course, you will achieve the following learning objectives:
- understand how a relational database management system (RDBMS) works and how to use it;
- execute queries to extract data according to different parameters;
- execute queries with joins to retrieve information from multiple tables;
- create a relational schema based on conceptual data modelling;
- develop design models and data models.
Program
Introducing databases
- Database management system (DBMS) capabilities.
- The technical context.
- Terminology.
- The main database stakeholders.
Understanding the relational model
- Functional dependency.
- Elementary functional dependency.
- Direct functional dependency.
- Relations.
- A relation's primary key: the identifier.
- A relation's foreign keys.
- A relation's normal forms (3NF).
Representing data with a conceptual data model
- Introducing the conceptual data model.
- Entities and relationships.
- Functional integrity constraints.
- Cardinalities.
- Multiple integrity constraints.
- Functional integrity constraints on relationships.
- The concept of functional integrity.
- Identifying links.
- Inheritance and aggregation.
Using Data Query Language
- Column and table aliases.
- Comparison predicates.
- Calculations.
- Inner, left and right joins.
- Sorting data.
- Nested queries.
- Grouping data.
- Data subtraction.
Using Data Manipulation Language
- Adding a single tuple.
- Adding multiple tuples.
- Updating a tuple.
- Updating all tuples.
- Deleting a tuple.
Using Data Definition Language
- Creating tables.
- Primary keys.
- Foreign keys.
- Altering a table.
- Dropping a table.
- Managing views.
Using Data Control Language
- Creating, modifying and deleting users.
- Data management system privileges (CRUD).
- Table, view and database privileges.
- Granting and revoking privileges.
- Procedure and trigger privileges.
- Special privileges.
Managing transactions
- Transaction support.
- SQL Commit and Rollback statements.
- Syntax and usage.
- A transaction as an ACID process.
Preparing queries
- User variables.
- Principles and syntax.
- Usage and benefits.
- The stages of a prepared query.
Using stored procedures
- Syntax and parameters.
- Dropping a procedure.
- Advantages and disadvantages.
- Using stored procedures.
Creating triggers
- SQL and PSM programming languages.
- Principles and uses.
- Syntax for creating and dropping triggers.
- Event and trigger timing.
- Basic and full logging.
Audience
This course is intended for:
- anyone with good IT knowledge and some programming knowledge.
Prerequisites
The database course has the following prerequisite:
- basic software development knowledge.
Teaching and assessment methods
- Initial skills assessment
- Training materials provided to participants
- Continuous assessment throughout the course
- End-of-course feedback questionnaire
- Combination of theory and practical application
- Attendance records
- Post-course follow-up evaluation
- Practical exercises
Course highlights
An introduction to relational databases led by a software engineering trainer, with group practical exercises.
Dates and sessions
Choose the date and delivery format that suit you.
No upcoming sessions are currently available.