Nibdew bis-SQL

Is-sandbox, ir-ritmu u ċ-ċertifikat

4 min
What you'll learn
  • tiddistingwi t-trejner mis-sandbox u tagħżel fejn issolvi l-eżerċizzji u fejn tesperimenta liberament bis-SQL
  • tispjega għaliex l-esperimenti fis-sandbox ma jagħmlux ħsara lill-oriġinal: is-sandbox hija kopja iżolata tal-bażi
  • issegwi l-progress tiegħek: x'jagħtik punti Power, kif jogħla r-rank tiegħek u kif tinbena serje ta' jiem konsekuttivi (streak)

X'hemm aktar fl-istazzjon

Is-sinjal mis-settur mejjet baqa' stabbli: QUERY stabbilixxa l-kanal u fetaħ kopja tal-bażi tad-data ta' Kotomarket f'ċirkwit iżolat tal-istazzjon. Issa għandek kollox għal xogħol fit-tul — jonqos biss li ddur mal-kompartimenti.

  • It-trejner — l-eżerċizzji jimxu minn faċli għal aktar serji; bihom dak li tifhem jinbidel f'drawwa.
  • Is-sandbox — kopja iżolata tal-arkivju: l-oriġinal jibqa' intatt, u hawn tista' tagħmel li trid — tikteb SQL liberament, tipprova l-ideat tiegħek u tara d-data ta' Kotomarket minn kull angolu.
  • Progress u Power — mil-lezzjonijiet u l-eżerċizzji tiġbor punti (Power), jogħla r-rank tiegħek u tinbena serje ta' jiem konsekuttivi (streak).
  • Eżamijiet u ċertifikat — meta tlesti l-kors, tista' tagħmel l-eżami u tikseb ċertifikat b'ismek u b'verifika QR: il-liċenzja tiegħek bħala arkivist.

Jekk timxi fl-ordni, tibni quddiemek mappa sħiħa tas-SQL: mill-ewwel qari ta' tabella sa queries li tkun tista' tiddiskutihom b'kalma f'intervista — jew tippreżentahom lill-Kunsill tal-Akkademja.

QUERY: Is-sandbox hija l-kompartiment favorit tiegħi. Tkisser x'tkisser hemm ġew, l-oriġinal ma jiġrilu xejn. Ikkonfermat. Minni. Darbtejn.

Kopja tixgħel tal-arkivju fiċ-ċirkwit iżolat tas-sandbox, b'qattus-robot rieqed ħdejha
Is-sandbox: kopja eżatta tal-arkivju f'ċirkwit iżolat — hawn tista' tagħmel li trid, u l-oriġinal jibqa' intatt.

What else is on the station

The signal from the dead sector holds steady: QUERY has locked the channel and spun up a copy of the "Kotomarket" database in an isolated circuit aboard the station. Now you have everything you need for the long haul — all that’s left is to walk the bays.

  • Trainer — tasks run from easy to combat-grade; this is where you turn a topic you understand into a habit.
  • Sandbox — an isolated copy of the archive: the original stays untouchable, and here anything goes — write SQL freely, test your hunches and look at the "Kotomarket" data from every angle.
  • Progress and Power — lessons and tasks earn you points (Power), your rank grows, and a run of no-miss days (a streak) builds up.
  • Exams and certificate — once you finish the course you can sit an exam and get a named certificate with a QR check: your archivist’s license.

Go through it in order and a whole map of SQL takes shape — from your first read of a table to queries you can comfortably talk through in an interview, or lay before the Academy Council.

QUERY: The sandbox is my favorite bay. Whatever you break in there, the original won’t suffer. Confirmed. By me. Twice.

Interview question

Parir tal-arkivist: idħol kuljum, għallinqas għal blokk qasir wieħed. Is-serje (streak) tibqa' għaddejja, u s-SQL jinbena bħala ħila, mhux bħala noti. L-arkivju ma jħobbx il-għaġla — imma jħobb ir-ritmu.

QUERY dims the extra panels. One stays lit — a dark schema where you can just make out the five silhouettes of the "Kotomarket" tables.

QUERY: The signature "K." can wait. Before you read someone else’s memory, cadet, understand how it’s put together. Next watch — the map of the archive.