#Query

28 maswali

Eleza INNER, LEFT, RIGHT na FULL JOIN.SQL#joinJunior
Kauli ya SELECT inafanyaje kazi?SQL#queryJunior
Unachujaje safu kwa kutumia WHERE?SQL#queryJunior
Aggregate functions ni nini (COUNT, SUM, AVG, n.k.)?SQL#queryJunior
GROUP BY na HAVING zinafanyaje kazi?SQL#queryJunior
ORDER BY na LIMIT zinafanyaje kazi, na unawekaje pagination?SQL#queryJunior
INSERT, UPDATE na DELETE zinafanyaje kazi?SQL#queryJunior
Unashughulikiaje nakala-zinazojirudia kwa kutumia DISTINCT?SQL#queryJunior
Subqueries ni nini na unazitumiaje?SQL#queryMiddle
UNION, INTERSECT na EXCEPT ni nini?SQL#queryMiddle
Inafanyaje kazi expression ya CASE?SQL#queryMiddle
Ni zipi functions za kawaida za string na tarehe?SQL#queryMiddle
Ni nini self-join?SQL#queryMiddle
Ni nini window functions?SQL#querySenior
Ni nini Common Table Expressions (CTEs)?SQL#querySenior
UPSERT (INSERT ON CONFLICT) ni nini?PostgreSQL#queryJunior
Kifungu cha RETURNING kinafanya nini?PostgreSQL#queryJunior
CTEs na recursive queries zinafanyaje kazi katika PostgreSQL?PostgreSQL#queryMiddle
Operesheni za CRUD zinafanyaje kazi katika MongoDB?MongoDB#queryJunior
MongoDB hutoa waendeshaji gani wa kuuliza?MongoDB#queryJunior
Mauliza ya find na projections yanafanyaje kazi?MongoDB#queryJunior
Unaingizaje, kusasisha na kufuta nyaraka?MongoDB#queryJunior
Upangaji na ukurasaji vinafanyaje kazi katika MongoDB?MongoDB#queryJunior
Unachanganyaje masharti kwa waendeshaji wa mantiki?MongoDB#queryJunior
Aggregation pipeline ni nini?MongoDB#queryMiddle
MongoDB hutoa waendeshaji gani wa usasishaji?MongoDB#queryMiddle
Ni vipengele gani vya hali ya juu vya aggregation ambavyo MongoDB hutoa?MongoDB#querySenior
Geospatial queries hufanya kazi vipi katika MongoDB?MongoDB#queryMiddle