{"id":801,"date":"2025-10-02T12:36:39","date_gmt":"2025-10-02T10:36:39","guid":{"rendered":"https:\/\/mnugier.fr\/?page_id=801"},"modified":"2025-10-02T15:02:18","modified_gmt":"2025-10-02T13:02:18","slug":"competences-en-sql","status":"publish","type":"page","link":"https:\/\/mnugier.fr\/?page_id=801","title":{"rendered":"\u2705 Comp\u00e9tences en SQL"},"content":{"rendered":"\n

<\/p>\n\n\n\n

\ud83d\udd39 1. Structure de base d\u2019une requ\u00eate<\/strong><\/p>\n\n\n\n

SELECT colonne1, colonne2
FROM nom_table
WHERE condition;<\/p>\n\n\n\n

\ud83d\udcdd Exemple<\/strong> :<\/p>\n\n\n\n

SELECT id, email
FROM utilisateurs
WHERE statut = ‘actif’;<\/p>\n\n\n\n

<\/p>\n\n\n\n

\ud83d\udd39 2. Requ\u00eates de lecture (SELECT<\/code>)<\/strong><\/h4>\n\n\n\n

\u27a4 S\u00e9lectionner toutes les colonnes :<\/h3>\n\n\n\n

SELECT * FROM commandes;<\/p>\n\n\n\n

\u27a4 Filtrer selon une condition :<\/p>\n\n\n\n

SELECT * FROM utilisateurs
WHERE email LIKE ‘%@gmail.com’;<\/p>\n\n\n\n

\u27a4 Trier les r\u00e9sultats :<\/p>\n\n\n\n

SELECT * FROM clients
ORDER BY date_inscription DESC;<\/p>\n\n\n\n

\ud83d\udd39 3. Requ\u00eates avec jointures (JOIN<\/code>)<\/strong><\/h4>\n\n\n\n

\u27a4 Lier deux tables (ex. : commandes + clients) :<\/h3>\n\n\n\n

SELECT c.id, c.date_commande, cl.nom
FROM commandes c
JOIN clients cl ON c.id_client = cl.id;<\/p>\n\n\n\n

\ud83d\udd39 4. Regrouper et compter (GROUP BY<\/code>, COUNT<\/code>)<\/strong><\/h4>\n\n\n\n

\u27a4 Nombre de commandes par client :<\/h3>\n\n\n\n

SELECT id_client, COUNT(*) AS nb_commandes
FROM commandes
GROUP BY id_client;<\/p>\n\n\n\n

\ud83d\udd39 5. Recherches sp\u00e9cifiques<\/strong><\/h4>\n\n\n\n

\u27a4 V\u00e9rifier si un utilisateur a pass\u00e9 une commande :<\/h3>\n\n\n\n

SELECT * FROM commandes
WHERE id_client = 123;<\/p>\n\n\n\n

\u27a4 Trouver les commandes sans paiement :<\/p>\n\n\n\n

SELECT * FROM commandes
WHERE statut_paiement = ‘non_pay\u00e9’;<\/p>\n\n\n\n

\ud83d\udd39 6. Requ\u00eates de modification <\/strong><\/h4>\n\n\n\n

\u27a4 Ajouter une donn\u00e9e (INSERT<\/code>) :<\/h3>\n\n\n\n

INSERT INTO utilisateurs (nom, email, statut)
VALUES (‘Alice’, ‘alice@test.com’, ‘actif’);<\/p>\n\n\n\n

\u27a4 Modifier une donn\u00e9e (UPDATE<\/code>) :<\/p>\n\n\n\n

UPDATE utilisateurs
SET statut = ‘inactif’
WHERE email = ‘test@test.com’;<\/p>\n\n\n\n

\u27a4 Supprimer une donn\u00e9e (DELETE<\/code>) :<\/p>\n\n\n\n

DELETE FROM utilisateurs
WHERE email = ‘ancien@test.com’;<\/p>\n\n\n\n

\ud83d\udd39 7. Fonctions utiles<\/strong><\/h4>\n\n\n\n
Fonction SQL<\/th>Utilit\u00e9<\/th>Exemple<\/th><\/tr><\/thead>
NOW()<\/code><\/td>Date\/heure actuelle<\/td>WHERE date_maj < NOW()<\/code><\/td><\/tr>
DATE()<\/code><\/td>Extraire la date d\u2019un champ datetime<\/td>DATE(date_commande)<\/code><\/td><\/tr>
CONCAT()<\/code><\/td>Concat\u00e9ner deux colonnes<\/td>CONCAT(prenom, ' ', nom)<\/code><\/td><\/tr>
DISTINCT<\/code><\/td>Supprimer les doublons<\/td>SELECT DISTINCT statut FROM ...<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

\ud83d\udd39 1. Structure de base d\u2019une requ\u00eate SELECT colonne1, colonne2FROM nom_tableWHERE condition; \ud83d\udcdd Exemple : SELECT id, emailFROM utilisateursWHERE statut = ‘actif’; \ud83d\udd39 2. Requ\u00eates de lecture (SELECT) \u27a4 S\u00e9lectionner toutes les colonnes : SELECT * FROM commandes; \u27a4 Filtrer selon une condition : SELECT * FROM utilisateursWHERE email LIKE ‘%@gmail.com’; \u27a4 Trier les r\u00e9sultats […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-801","page","type-page","status-publish","hentry","wpbf-post"],"_links":{"self":[{"href":"https:\/\/mnugier.fr\/index.php?rest_route=\/wp\/v2\/pages\/801","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mnugier.fr\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/mnugier.fr\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/mnugier.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mnugier.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=801"}],"version-history":[{"count":4,"href":"https:\/\/mnugier.fr\/index.php?rest_route=\/wp\/v2\/pages\/801\/revisions"}],"predecessor-version":[{"id":963,"href":"https:\/\/mnugier.fr\/index.php?rest_route=\/wp\/v2\/pages\/801\/revisions\/963"}],"wp:attachment":[{"href":"https:\/\/mnugier.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}