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 |