Ag tosú le SQL

An bosca gainimh, rithim agus teastas

4 min
What you'll learn
  • idirdhealú a dhéanamh idir an traenálaí agus an bosca gainimh, agus fios a bheith agat cá réiteoidh tú tascanna agus cá ndéanfaidh tú turgnamh go saor le SQL
  • a mhíniú cén fáth nach mbriseann turgnaimh sa bhosca gainimh an bhunchóip: is cóip aonraithe den bhunachar atá ann
  • do dhul chun cinn a rianú: cén chaoi a dtuilleann tú pointí Power, conas a ardaíonn do chéim, agus conas a choinníonn tú sraith laethanta as a chéile (streak) beo

Cad eile atá sa stáisiún

Tá an comhartha ón earnáil mharbh cobhsaí: dhaingnigh QUERY an cainéal agus chuir sé cóip de bhunachar Kotomarket ar bun i gciorcad aonraithe an stáisiúin. Anois tá gach rud agat le haghaidh seal fada oibre — níl fágtha ach na seomraí a iniúchadh.

  • An traenálaí — téann na tascanna ó éasca go dúshlánach; is ann a iompaíonn tú ábhar atá tuigthe agat ina nós.
  • An bosca gainimh — cóip aonraithe den chartlann: fanann an bhunchóip slán, agus tá cead agat anseo gach rud a thriail — SQL a scríobh mar is mian leat, do bharúlacha a thástáil agus sonraí Kotomarket a scrúdú ó gach uillinn.
  • Dul chun cinn agus Power — tuilleann tú pointí (Power) as ceachtanna agus tascanna, ardaíonn do chéim, agus carnann tú sraith laethanta as a chéile (streak).
  • Scrúduithe agus teastas — tar éis duit an cúrsa a chríochnú, is féidir leat scrúdú a dhéanamh agus teastas pearsanta a fháil ar féidir é a sheiceáil le cód QR: do cheadúnas cartlannaí.

Má leanann tú an t-ord, tógfar léarscáil iomlán SQL duit: ó chéad léamh tábla go ceisteanna is féidir leat a phlé go muiníneach in agallamh — nó iad a chur faoi bhráid Chomhairle an Acadaimh.

QUERY: Is é an bosca gainimh an seomra is fearr liom. Pé rud a bhriseann tú ann, ní dhéanfaidh sé dochar don bhunchóip. Deimhnithe agam. Dhá uair.

Cóip lonrach den chartlann i gciorcad aonraithe an bhosca gainimh, agus cat AI ina chodladh taobh léi
An bosca gainimh: cóip chruinn den chartlann i gciorcad aonraithe — tá cead agat gach rud a thriail anseo, agus fanann an bhunchóip slán.

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

Leid ón gcartlannaí: tar isteach gach lá ar feadh bloc gairid amháin ar a laghad. Coinneoidh sé sin do shraith laethanta as a chéile (streak) beo, agus socróidh SQL i d'intinn mar scil seachas mar nótaí. Ní thaitníonn deifir leis an gcartlann — ach taitníonn rithim léi.

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.