Bac NSI 2025 - Corrigé Exercice 1 : SQL (Sujet Métropole)

📌 Detailed solution to Exercise 1 SQL from the 2025 Bac NSI exam (Metropolitan France) (25-NSIJ1ME1). 🔍 What you will learn in this video: INSERT INTO and VALUES UPDATE with WHERE SELECT + WHERE JOIN between multiple tables SUM function Common pitfalls to avoid 🎯 This video is for you if you are preparing for the Bac NSI exam and want to master SQL exercises to score points on exam day. ⏱ CHAPTERS 00:00 - Introduction 00:19 - Q1: Why is the serial number not a primary key? 00:59 - Q2: Outputting a SELECT query 01:23 - Q3: Selecting a year with a condition (WHERE) 01:40 - Q4: Sorting results in ascending order (ORDER BY) 01:58 - Q5: Modifying an entry (UPDATE) 02:18 - Relationships between multiple tables 02:29 - Q6: Table creation order & Foreign keys 03:25 - Q7: Joining two tables (JOIN) 03:52 - Q8: Deleting a record (DELETE) 04:04 - Q9: Inserting data (INSERT INTO) 04:39 - Q10: Calculating a sum (SUM) & Joining 05:04 - Conclusion and tips for succeeding in the Bac NSI exam 📺 THE COMPLETE SOLUTION to the exam (23 min, all exercises):    • Bac NSI 2025 : Corrigé COMPLET - Sujet Mét...   📚 PRIVATE TUTORING FOR THE NSI BACCALAUREATE EXAM VIA ONLINE 👉 My Superprof profile: https://www.superprof.fr/bloques-nsi-... 👉 My website: https://tutoriels-informatique.fr 📄 COMPLETE EXAM PAPERS: https://www.education.gouv.fr/sites/d... 👨‍💻 WHO AM I? Célian, Master's in Cybersecurity. I got a perfect score on the NSI Baccalaureate exam and I help high school students succeed. More solutions coming soon to the channel — subscribe so you don't miss them. #BacNSI #BacNSI2025 #SQL #Databases #BacSolutions