{"id":1599,"date":"2023-07-13T16:49:29","date_gmt":"2023-07-13T14:49:29","guid":{"rendered":"https:\/\/www.mentorformation.fr\/?page_id=1599"},"modified":"2025-05-05T15:18:07","modified_gmt":"2025-05-05T13:18:07","slug":"concepteur-developpeur-dapplication-rncp-31678bc02","status":"publish","type":"page","link":"https:\/\/www.mentorformation.fr\/index.php\/concepteur-developpeur-dapplication-rncp-31678bc02\/","title":{"rendered":"Concepteur d\u00e9veloppeur d’application \u2013 RNCP 31678BC02"},"content":{"rendered":"\n\n\n\n\n

CONCEPTEUR DEVELOPPEUR D’APPLICATION <\/span>RNCP 31678BC02<\/span><\/font>
<\/h2>\n\n\n\n\n\n\n\n\n

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


<\/p>

CONCEPTEUR DEVELOPPEUR D’APPLICATION \u2013 <\/span>RNCP 31678BC02<\/span><\/strong>

<\/font>Cette Formation est compos\u00e9e de :<\/font><\/p><\/span><\/span><\/span>

– PHP \/ SQL<\/font><\/p>

– SQL<\/font><\/p>


<\/font><\/p>

Avec cette formation :<\/font><\/p>

– vous apprendrez le langage de programmation PHP, appr\u00e9henderez le syst\u00e8me de gestion de bases de donn\u00e9e MySQL et aborderez les interactions entre MySQL et PHP.<\/font><\/p>

– 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>

<\/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

46 Modules<\/font>
<\/p>\n\n\n\n\n

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

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

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

Oui<\/font><\/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

PROGRAMMATION PHP\/SQL<\/span>
<\/p>\n\n\n\n\n\n\n\n\n\n\n

<\/p><\/span>

<\/p><\/span>

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

<\/p>

<\/p>

<\/p>

<\/p>

<\/p>

    <\/ul>

    <\/p>

    • Introduction au cours PHP et MySQL<\/span><\/font><\/li>
    • D\u00e9couverte des variables en PHP<\/span>
      <\/li>
    • Les structures de contr\u00f4le en PHP<\/span>
      <\/li>
    • D\u00e9couverte des fonctions en PHP<\/span>
      <\/li>
    • Les variables tableaux en PHP<\/span>
      <\/li>
    • Manipuler des dates en PHP<\/span>
      <\/li>
    • Les variables superglobales PHP<\/span>
      <\/li>
    • Manipuler des fichiers en PHP<\/span>
      <\/li>
    • Utiliser les expressions r\u00e9guli\u00e8res ou rationnelles en PHP<\/span>
      <\/li>
    • Programmation orient\u00e9e objet (Poo) PHP – Concepts de base<\/span>
      <\/li>
    • Programmation orient\u00e9e objet PHP – Notions avanc\u00e9es<\/span>
      <\/li>
    • Espaces de noms, filtres et gestion des erreurs en PHP<\/span>
      <\/li>
    • Introduction aux bases de donn\u00e9es, au SQL et \u00e0 MySQL<\/span>
      <\/li>
    • Manipuler des donn\u00e9es dans des bases MySQL avec PDO<\/span>
      <\/li>
    • Jointures, union et sous requ\u00eates<\/span>
      <\/li>
    • Gestion des formulaires HTML avec PHP<\/span><\/li><\/ul>

      <\/p>

        <\/ul>
          <\/ul>
            <\/ul>
              <\/ul>
                <\/ul>
                  <\/ul>
                    <\/ul>
                      <\/ul>
                        <\/ul>
                          <\/ul>
                            <\/ul>

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

                            <\/p><\/span>

                            <\/p><\/span>

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

                            <\/p>

                            <\/p>

                            <\/p>

                            <\/p>

                            <\/p>

                              <\/ul>

                              <\/p>

                              • Pr\u00e9sentation du cours<\/span>
                                <\/li>
                              • Introduction au PHP<\/span>
                                <\/li>
                              • Environnement de travail<\/span>
                                <\/li>
                              • Les bases en PHP<\/span>
                                <\/li>
                              • Premi\u00e8res instructions<\/span>
                                <\/li>
                              • Les variables PHP<\/span>
                                <\/li>
                              • Types de valeurs et concat\u00e9nation<\/span>
                                <\/li>
                              • Op\u00e9rations sur les variables<\/span>
                                <\/li>
                              • Introduction aux conditions<\/span>
                                <\/li>
                              • Les conditions 1\/2<\/span>
                                <\/li>
                              • Les conditions 2\/2<\/span>
                                <\/li>
                              • Ternaires et switch<\/span>
                                <\/li>
                              • Les boucles<\/span>
                                <\/li>
                              • Les fonctions PHP<\/span>
                                <\/li>
                              • Port\u00e9e des variables<\/span>
                                <\/li>
                              • Constantes PHP<\/span>
                                <\/li>
                              • Les tableaux en PHP<\/span>
                                <\/li>
                              • Tableaux associatifs<\/span>
                                <\/li>
                              • Tableaux multidimensionnels<\/span>
                                <\/li>
                              • Le timestamp<\/span>
                                <\/li>
                              • Obtenir et formater une date<\/span>
                                <\/li>
                              • Validit\u00e9 des dates<\/span>
                                <\/li>
                              • Lire, ouvrir, fermer un fichier<\/span>
                                <\/li>
                              • Parcourir un fichier<\/span>
                                <\/li>
                              • Cr\u00e9er et \u00e9crire dans un fichier<\/span>
                                <\/li>
                              • \u00c9crire dans un fichier<\/span>
                                <\/li>
                              • Include et require<\/span><\/li><\/ul>

                                <\/p>

                                  <\/ul>
                                    <\/ul>
                                      <\/ul>
                                        <\/ul>
                                          <\/ul>
                                            <\/ul>
                                              <\/ul>
                                                <\/ul>
                                                  <\/ul>
                                                    <\/ul>
                                                      <\/ul>

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

                                                      PROGRAMMATION LANGAGE SQL<\/span>
                                                      <\/p>\n\n\n\n\n\n\n\n\n\n\n

                                                      <\/p><\/span>

                                                      <\/p><\/span>

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

                                                      <\/p>

                                                      <\/p>

                                                      <\/p>

                                                      <\/p>

                                                      <\/p>

                                                        <\/ul>

                                                        <\/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>
                                                          <\/li>
                                                        • Base de donn\u00e9es d’employ\u00e9s<\/span>
                                                          <\/li>
                                                        • Base de donn\u00e9es de gestion de projet<\/span>
                                                          <\/li><\/ul>

                                                          <\/p>

                                                            <\/ul>
                                                              <\/ul>
                                                                <\/ul>
                                                                  <\/ul>
                                                                    <\/ul>
                                                                      <\/ul>
                                                                        <\/ul>
                                                                          <\/ul>
                                                                            <\/ul>
                                                                              <\/ul>
                                                                                <\/ul>

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

                                                                                <\/p><\/span>

                                                                                <\/p><\/span>

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

                                                                                <\/p>

                                                                                <\/p>

                                                                                <\/p>

                                                                                <\/p>

                                                                                <\/p>

                                                                                  <\/ul>

                                                                                  <\/p>

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

                                                                                    <\/p>

                                                                                      <\/ul>
                                                                                        <\/ul>
                                                                                          <\/ul>
                                                                                            <\/ul>
                                                                                              <\/ul>
                                                                                                <\/ul>
                                                                                                  <\/ul>
                                                                                                    <\/ul>
                                                                                                      <\/ul>
                                                                                                        <\/ul>
                                                                                                          <\/ul>

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

                                                                                                          <\/p><\/span>

                                                                                                          <\/p><\/span>

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

                                                                                                          <\/p>

                                                                                                          <\/p>

                                                                                                          <\/p>

                                                                                                          <\/p>

                                                                                                          <\/p>

                                                                                                            <\/ul>

                                                                                                            <\/p>

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

                                                                                                              <\/p>

                                                                                                                <\/ul>
                                                                                                                  <\/ul>
                                                                                                                    <\/ul>
                                                                                                                      <\/ul>
                                                                                                                        <\/ul>
                                                                                                                          <\/ul>
                                                                                                                            <\/ul>
                                                                                                                              <\/ul>
                                                                                                                                <\/ul>
                                                                                                                                  <\/ul>
                                                                                                                                    <\/ul>

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

                                                                                                                                    <\/p><\/span>

                                                                                                                                    <\/p><\/span>

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

                                                                                                                                    <\/p>

                                                                                                                                    <\/p>

                                                                                                                                    <\/p>

                                                                                                                                    <\/p>

                                                                                                                                    <\/p>

                                                                                                                                      <\/ul>

                                                                                                                                      <\/p>

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

                                                                                                                                        <\/p>

                                                                                                                                          <\/ul>
                                                                                                                                            <\/ul>
                                                                                                                                              <\/ul>
                                                                                                                                                <\/ul>
                                                                                                                                                  <\/ul>
                                                                                                                                                    <\/ul>
                                                                                                                                                      <\/ul>
                                                                                                                                                        <\/ul>
                                                                                                                                                          <\/ul>
                                                                                                                                                            <\/ul>
                                                                                                                                                              <\/ul>

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

                                                                                                                                                              <\/p><\/span>

                                                                                                                                                              <\/p><\/span>

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

                                                                                                                                                              <\/p>

                                                                                                                                                              <\/p>

                                                                                                                                                              <\/p>

                                                                                                                                                              <\/p>

                                                                                                                                                              <\/p>

                                                                                                                                                                <\/ul>

                                                                                                                                                                <\/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>

                                                                                                                                                                  <\/p>

                                                                                                                                                                    <\/ul>
                                                                                                                                                                      <\/ul>
                                                                                                                                                                        <\/ul>
                                                                                                                                                                          <\/ul>
                                                                                                                                                                            <\/ul>
                                                                                                                                                                              <\/ul>
                                                                                                                                                                                <\/ul>
                                                                                                                                                                                  <\/ul>
                                                                                                                                                                                    <\/ul>
                                                                                                                                                                                      <\/ul>
                                                                                                                                                                                        <\/ul>

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

                                                                                                                                                                                        <\/p><\/span>

                                                                                                                                                                                        <\/p><\/span>

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

                                                                                                                                                                                        <\/p>

                                                                                                                                                                                        <\/p>

                                                                                                                                                                                        <\/p>

                                                                                                                                                                                        <\/p>

                                                                                                                                                                                        <\/p>

                                                                                                                                                                                          <\/ul>

                                                                                                                                                                                          <\/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>

                                                                                                                                                                                            <\/p>

                                                                                                                                                                                              <\/ul>
                                                                                                                                                                                                <\/ul>
                                                                                                                                                                                                  <\/ul>
                                                                                                                                                                                                    <\/ul>
                                                                                                                                                                                                      <\/ul>
                                                                                                                                                                                                        <\/ul>
                                                                                                                                                                                                          <\/ul>
                                                                                                                                                                                                            <\/ul>
                                                                                                                                                                                                              <\/ul>
                                                                                                                                                                                                                <\/ul>
                                                                                                                                                                                                                  <\/ul>

                                                                                                                                                                                                                  <\/p>\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 : <\/strong>2690\u20ac HT<\/span><\/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-1599","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\/1599","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=1599"}],"version-history":[{"count":13,"href":"https:\/\/www.mentorformation.fr\/index.php\/wp-json\/wp\/v2\/pages\/1599\/revisions"}],"predecessor-version":[{"id":5181,"href":"https:\/\/www.mentorformation.fr\/index.php\/wp-json\/wp\/v2\/pages\/1599\/revisions\/5181"}],"wp:attachment":[{"href":"https:\/\/www.mentorformation.fr\/index.php\/wp-json\/wp\/v2\/media?parent=1599"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}