{"id":1289,"date":"2023-07-13T19:53:03","date_gmt":"2023-07-13T17:53:03","guid":{"rendered":"https:\/\/www.mentorformation.fr\/?page_id=1289"},"modified":"2025-05-05T16:42:59","modified_gmt":"2025-05-05T14:42:59","slug":"programmation-langage-sql","status":"publish","type":"page","link":"https:\/\/www.mentorformation.fr\/index.php\/programmation-langage-sql\/","title":{"rendered":"Programmation Langage SQL"},"content":{"rendered":"\n\n\n\n\n

Programmation Langage SQL<\/h2>\n\n\n\n\n\n\n\n\n

OBJECTIFS P\u00c9DAGOGIQUES<\/span><\/p>


<\/p>

Avec cette formation Langage SQL vous apprendrez les notions li\u00e9es \u00e0 un syst\u00e8me de gestion de base de donn\u00e9es, la syntaxe des instructions SQL et la manipulation de donn\u00e9es au travers de clauses sp\u00e9cifiques et de cas pratiques.<\/font>
<\/p><\/span><\/span><\/span>

<\/p>

<\/font><\/p>

<\/p><\/span>

<\/div>\n\n\n\n\n\n\n\n

NIVEAU DE GRANULARISATION<\/strong><\/span><\/span><\/strong><\/span><\/p>\n\n\n

2 modules interactifs soit 8 le\u00e7ons d\u2019apprentissage<\/font>
<\/p>\n\n\n\n\n

TEMPS MOYEN DE FORMATION<\/strong><\/p>\n\n\n

3 heures<\/font>
<\/p>\n\n\n\n\n

SYST\u00c8ME D\u2019\u00c9VALUATION<\/strong><\/span><\/p>\n\n\n

Oui<\/span>
<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

D\u00c9TAIL DE LA FORMATION<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n

<\/p><\/span>

<\/p><\/span>

<\/p><\/span><\/span>

<\/p>

<\/p>

  • Base de donn\u00e9es d’Air France<\/span>
    <\/li>
  • Base de donn\u00e9es d’un festival de musique<\/span><\/li>
  • Base de donn\u00e9es d’un cycle de formation d’\u00e9tudiants<\/span><\/font><\/li>
  • Base de donn\u00e9es d’employ\u00e9s<\/span><\/font><\/li>
  • Base de donn\u00e9es de gestion de projet<\/span>
    <\/li><\/ul>\n\n\n\n\n\n\n\n\n

    <\/p><\/span>

    <\/p><\/span>

    <\/p><\/span><\/span>

    <\/p>

    <\/p>

    • Base de donn\u00e9es d’une promotion d’\u00e9tudiants<\/span>
      <\/li>
    • Base de donn\u00e9es d’un cin\u00e9ma<\/span><\/font><\/li>
    • Base de donn\u00e9es des \u00e9tapes du Tour de France<\/span><\/font><\/li>
    • Base de donn\u00e9es de gestion de ventes<\/span><\/font><\/li><\/ul>\n\n\n\n\n\n\n\n\n

      <\/p><\/span>

      <\/p><\/span>

      <\/p><\/span><\/span>

      <\/p>

      <\/p>

      • Introduction<\/span>
        <\/li>
      • Concepts de base de SGBDR<\/span><\/font><\/li>
      • Sch\u00e9matisation d’une base de donn\u00e9es<\/span><\/font><\/li>
      • La syntaxe des instructions SQL<\/span><\/font><\/li>
      • Les op\u00e9rateurs<\/span><\/font><\/li><\/ul>\n\n\n\n\n\n\n\n\n

        <\/p><\/span>

        <\/p><\/span>

        <\/p><\/span><\/span>

        <\/p>

        <\/p>

        • Cr\u00e9ation et suppression d’une base de donn\u00e9es<\/span>
          <\/li>
        • Les diff\u00e9rents types de donn\u00e9es<\/span><\/font><\/li>
        • Cr\u00e9ation et suppression des tables<\/span><\/font><\/li>
        • Modifier la structure d’une table – ALTER TABLE<\/span><\/font><\/li>
        • Les contraintes<\/span><\/font><\/li><\/ul>\n\n\n\n\n\n\n\n\n

          <\/p><\/span>

          <\/p><\/span>

          <\/p><\/span><\/span>

          <\/p>

          <\/p>

          • Insertion et modifications des enregistrements – INSERT, UPDATE et DELETE<\/span>
            <\/li>
          • Extraction des donn\u00e9es – SELECT<\/span>
            <\/li>
          • Filtrer les donn\u00e9es – WHERE<\/span>
            <\/li>
          • Mod\u00e8les de recherche – LIKE<\/span>
            <\/li>
          • Trier les donn\u00e9es – ORDER BY<\/span>
            <\/li>
          • Les jointures – JOIN<\/span>
            <\/li><\/ul>\n\n\n\n\n\n\n\n\n

            <\/p><\/span>

            <\/p><\/span>

            <\/p><\/span><\/span>

            <\/p>

            <\/p>

            • Fonctions d’agr\u00e9gation – SUM, COUNT, AVG, MIN et MAX<\/span>
              <\/li>
            • Organiser des donn\u00e9es identiques en groupes – GROUP BY et HAVING<\/span>
              <\/li>
            • Les sous-requ\u00eates<\/span>
              <\/li>
            • Combiner les r\u00e9sultats de deux ou plusieurs instructions SELECT – UNION<\/span>
              <\/li>
            • Les fonctions SQL de manipulation de date<\/span>
              <\/li><\/ul>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

              \n<\/h4>

              Les plus de nos formations<\/h4>\n\n

              Nos formations sont dot\u00e9es d’une intelligence artificielle qui permet de cr\u00e9er pour chacun un parcours personnalis\u00e9 selon son niveau de d\u00e9part, ses modes d’apprentissage pr\u00e9f\u00e9r\u00e9s et ses capacit\u00e9s \u00e0 comprendre et apprendre; Ainsi le temps de formation est condens\u00e9 et focalis\u00e9 sur les points que l’apprenant maitrise le moins.

              La plupart de nos formations dispose d’un tutorat ainsi vous n’\u00eates jamais seul, d’un clic vous pouvez joindre un tuteur sp\u00e9cialiste du domaine enseign\u00e9.
              Si vous voulez tester une de nos formations vous pouvez nous en faire la demande et nous vous ferons parvenir un lien, un identifiant et un code d’acc\u00e8s.<\/p>\n\n

              Prix de la formation : 590\u20ac HT<\/strong><\/p>\n\n\n\n\n\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"tpgb_global_settings":"","pagelayer_contact_templates":[],"_pagelayer_content":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"class_list":["post-1289","page","type-page","status-publish","hentry"],"tpgb_featured_images":null,"tpgb_post_meta_info":{"get_date":"13 juillet 2023","get_modified_date":"5 mai 2025","author_name":"marcmentor","author_url":"https:\/\/www.mentorformation.fr\/index.php\/author\/marmentor\/","author_email":"mentormarchaendel@gmail.com","author_website":"","author_description":"","author_facebook":"","author_twitter":"","author_instagram":"","author_role":["administrator"],"author_firstname":"","author_lastname":"","user_login":"marcmentor","author_avatar":"","author_avatar_url":"https:\/\/secure.gravatar.com\/avatar\/573220983167308264f68611b20fbb5adf6ec1b443f6c0fc7a70a60397fa78cb?s=96&d=mm&r=g","comment_count":0,"post_likes":0,"post_views":0},"tpgb_post_category":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.mentorformation.fr\/index.php\/wp-json\/wp\/v2\/pages\/1289","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mentorformation.fr\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mentorformation.fr\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mentorformation.fr\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mentorformation.fr\/index.php\/wp-json\/wp\/v2\/comments?post=1289"}],"version-history":[{"count":9,"href":"https:\/\/www.mentorformation.fr\/index.php\/wp-json\/wp\/v2\/pages\/1289\/revisions"}],"predecessor-version":[{"id":5262,"href":"https:\/\/www.mentorformation.fr\/index.php\/wp-json\/wp\/v2\/pages\/1289\/revisions\/5262"}],"wp:attachment":[{"href":"https:\/\/www.mentorformation.fr\/index.php\/wp-json\/wp\/v2\/media?parent=1289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}