Skill · Data formats · Query, modify and evolve a relational database with SQL
Automate SQL operations reliably and safely
Use psql in a script or CI that stops at the first error, export to CSV, and neutralize SQL injection with parameterized queries.
Start lesson 1The Data formats domain
- 2 lessons
- ~1 h 20 of reading
- 2 quizzes
- 0 proof lab
The path
Where it comes from, where it leads
What you need to know first, where you stand on this skill, and what it opens next. Your status is computed in your browser, from what you have read and passed.
Before · 2 prerequisites
This skill, for you
Automate SQL operations reliably and safely
Computing
It unlocks · nothing yet
No other skill requires it: it is an end-of-path skill.
The path through the foundations From the most upstream foundation to this skill: what is in place, what remains to read.
Lessons
How to learn it
2 lessons, about ~1 h 20, in program order. Each lesson ends with its quiz.
The program
2 lessons · ~1 h 20
Beyond the lessons
Assess, practise, pass the proof
Reading a lesson confirms nothing. A skill is confirmed by a passed quiz, practised in a guided lab, and put to the test by a challenge or a mission; an imported lab result is not verified by the site.
Assess yourself
2 quizzes
At the end of the lessons: passed at 70%, they confirm the skill.
Practice
No guided lab
No guided lab practices it yet.
Proof
No proof
Neither a challenge nor a mission with a proof yet.
Placement test
Preparing the questions…
Your answers in detail
For each question asked: your answer, the correct answer, its explanation and the page to reread.
Around it
Who requires it, who teaches it
Required by
Taught by
Same block · Query, modify and evolve a relational database with SQL