SQL & PostgreSQL · Horumarinta Backend

Sharaxaad

Tables relational, primary keys, joins, iyo indexes waa laf-dhabarka inta badan backends production.

Tusaale code

sql

CREATE TABLE users (
  id UUID PRIMARY KEY,
  email TEXT UNIQUE NOT NULL,
  created_at TIMESTAMPTZ DEFAULT now()
);

SELECT u.email, count(s.id) AS skills
FROM users u
LEFT JOIN skills s ON s.user_id = u.id
GROUP BY u.email;

Agab waxtar leh

Dokumentiga PostgreSQL
Dokumentiga rasmiga ah ee PostgreSQL.
DocumentationBilaashRasmi90 daqiiqo
Koorsada SQL — freeCodeCamp
Koorsada SQL ee YouTube.
YoutubeBilaash240 daqiiqo

Layli

Nashqee users iyo skills foreign key, geli rows, oo qor JOIN liisaya xirfadaha user kasta.

Qoraalladaada