Introduction to SQL & NoSQL Database Management (C1801)

Inter-company training

Who is the training for?

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.

Duration

45,00 hours(s)

15 weeks, 1 x 3 hours per week

Language(s) of service

EN

Next session

Prerequisites

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.

Goals

  • 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

Contents

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

Organization contact details

LLLC

These courses might interest you