The business problem
Customer, order, payment and stock files tell different versions of the same activity.
What you will be able to do
Recognise when a relational database is useful and answer a first business question with SQL.
- Identify the limits of uncoordinated sources
- Distinguish database, DBMS, server and SQL language
- Understand tables, keys, relationships and constraints
- Connect a business need to a SQL capability
- Run and adapt a first real query
Scope of this micro-course
This micro-course targets one focused skill. It does not replace a complete path or server administration training.
Prerequisites
- No prerequisite
- A recent browser for SQL practice
Project and practice
5 verified exercises are available. Validation is based on the programme exercises.