Introduction to SQL & NoSQL Database Management (C1801)

It is recommended to have basic computer handling skills. This course is open to all, with no technical prerequisites. Basic computer skills and logical reasoning are sufficient to follow the course. Curiosity about data organization is a plus, and some programming experience is helpful but not necessary. Thanks to a step-by-step approach and practical exercises, everyone can learn SQL and database modeling at their own pace. Bringing your own laptop is a must.

• Introduction to Relational Databases and SQL - Database Modeling and Relational Schema
• Data Manipulation – Introduction to SQL Queries
• Advanced Queries and Joins - Constraints Management and Data Integrity - Indexing and Query Optimization - SQL Programming and Views
• Advanced SQL: Window Functions and Complex Queries
• SQL and Programming with Python
• Security and User Management
• Introduction to NoSQL Databases
• NoSQL in Practice: MongoDB, Redis and Cassandra - Using a NoSQL Database with Python
• Personal Project: Design, Test and exploit your own DBMS and NoSQL project

Le contenu est identique aux objectifs d'apprentissage pour cette formation.