Introduction to SQL & NoSQL Database Management (C1801)

À qui s'adresse la formation?

This course is perfect for people who are new to tech or changing careers - whether you're a project manager, admin, marketer, or just curious about data.
You don’t need to know how to code; we start from the basics and guide you through each concept clearly.

Durée

45,00 heure(s)

15 weeks, 1 x 3 hours per week

Langues(s) de prestation

Prochaine session

Contacter l'organisme

Prérequis

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.

Objectifs

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