Principles of Database and applications
Objectifs pédagogiques
The goal of this course is to design, implement, and utilize relational databases. In particular, students will learn to define a relational schema from a conceptual data model and use SQL. Topics include the installation, design, querying, and SQL programming for a Relational Database Management System (RDBMS).
Capacité et compétences acquises
- Knowledge of relational database management systems (RDBMS)
- Proficiency in SQL and data-driven application development
Contenu de la formation
The course is structured into several sections, covering:
The course also introduces basic database administration concepts such as backup/restore, views, replication, indexing, and the role of a DBA (Database Administrator).
- Defining a Database Management System
- The relational model and relational database querying
- Database design and implementation
- Developing web-based applications that interact with databases
The course also introduces basic database administration concepts such as backup/restore, views, replication, indexing, and the role of a DBA (Database Administrator).
Description des modalités de validation
- Written exam
- Project
En alternance ou en formation continue en journée :
Merci de consulter directement le secrétariat pédagogique de votre formation pour obtenir le planning.
En formation « à la carte Hors Temps de Travail », en présentiel, à distance ou hybride :
Voir les dates, les lieux d'enseignement et les modalités d'inscription sur les sites internet des centres régionaux qui proposent cette formation.
