What is the use of a database ? What are the existing database ?
How to build and use a database ? These are some of the questions we will answer in this course
| Module 1 | Introduction |
| Introduction to database | |
| Unit 1 | What are database management system (DBMS) functionnalities ? |
| Unit 2 | Technical context |
| Unit 3 | Architecture ANSI/SPARC |
| Unit 4 | Vocabulary around database |
| Unit 5 | Introduction to relational model |
| Unit 6 | Main actors in Database Market |
| Module 2 | Basics of SQL |
| Select, Insert, Delete, Join... Learn the main queries of SQL | |
| Unit 1 | Type of data |
| Unit 2 | SQL : Create, Alter, Insert |
| Unit 3 | SQL : Select, Where |
| Unit 4 | SQL : Backup, Import, Update, Delete |
| Module 3 | SQL Advanced |
| Learn advanced SQL | |
| Unit 1 | Index |
| Unit 2 | Primary and Foreign Key |
| Unit 3 | JOIN |
| Unit 4 | Sub-queries |
| Unit 5 | Join and sub-queries |
| Unit 6 | Union of queries |
| Unit 7 | Foreign keys options |
| Unit 8 | Unicity constraint violation |
| Module 4 | Exam |
| Exam to pass the certificate | |
| Unit 1 | Exam - General |
| Unit 2 | Exam - Design a database |