{"id":198467,"date":"2023-07-25T07:30:00","date_gmt":"2023-07-25T07:30:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=198467"},"modified":"2023-11-09T13:44:14","modified_gmt":"2023-11-09T13:44:14","slug":"sql-developer-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/sql-developer-tout-savoir","title":{"rendered":"SQL Developer :  Qu&rsquo;est-ce que c&rsquo;est ? \u00c0 quoi sert cet outil ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"198467\" class=\"elementor elementor-198467\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3599573 e-flex e-con-boxed e-con\" data-id=\"3599573\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3e868bc elementor-widget elementor-widget-heading\" data-id=\"3e868bc\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Que vous soyez expert data, d\u00e9veloppeur ou administrateur syst\u00e8me, l\u2019exploration de la base de donn\u00e9es est une activit\u00e9 quotidienne. Pour cela, plusieurs outils sont mis \u00e0 votre disposition. Parmi les plus efficaces, il y a Oracle SQL Developer. Alors \u00e0 quoi sert-il ? \u00c0 qui s\u2019adresse cette solution ? Quelles sont ses fonctionnalit\u00e9s ? D\u00e9couvrez les r\u00e9ponses. <\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-96b79c8 e-flex e-con-boxed e-con\" data-id=\"96b79c8\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c6af280 elementor-widget elementor-widget-heading\" data-id=\"c6af280\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">C\u2019est quoi Oracle SQL Developer ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4229309 elementor-widget elementor-widget-text-editor\" data-id=\"4229309\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"font-weight: 400;\">Oracle SQL Developer est un environnement de d\u00e9veloppement int\u00e9gr\u00e9 (<a href=\"https:\/\/datascientest.com\/ide\">IDE<\/a>) gratuit. Gr\u00e2ce \u00e0 cette interface, vous pouvez <\/span><b>d\u00e9velopper vos applications en PL\/SQL, de A \u00e0 Z.<\/b><span style=\"font-weight: 400;\"> Et pour cause, cette solution offre aux d\u00e9veloppeurs une multitude de fonctionnalit\u00e9s comme :\u00a0 la connexion \u00e0 diverses bases de donn\u00e9es Oracle et non Oracle, la cr\u00e9ation et la gestion des objets database, l&rsquo;\u00e9dition de code, l&rsquo;exploration de donn\u00e9es, la comparaison de sch\u00e9mas, la cr\u00e9ation de rapports, la visualisation de donn\u00e9es, etc.<\/span><\/p><p><span style=\"font-weight: 400;\">L\u2019objectif est d\u2019aider les d\u00e9veloppeurs \u00e0 \u00eatre plus efficaces au moment de la conception d\u2019applications.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8c5f560 elementor-widget elementor-widget-text-editor\" data-id=\"8c5f560\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\"><strong>Bon \u00e0 savoir<\/strong> : Oracle SQL Developer s\u2019ex\u00e9cute sur tout syst\u00e8me d\u2019exploitation prenant en charge Java (Windows, OS X, et <a href=\"https:\/\/datascientest.com\/pourquoi-linux-est-il-le-systeme-dexploitation-prefere-des-developpeurs\">Linux<\/a><\/span><span style=\"font-weight: 400;\">).<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-043de58 e-flex e-con-boxed e-con\" data-id=\"043de58\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2935efa elementor-widget elementor-widget-heading\" data-id=\"2935efa\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">\u00c0 qui s\u2019adresse SQL Developer ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ea483a1 elementor-widget elementor-widget-text-editor\" data-id=\"ea483a1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Contrairement \u00e0 ce que son nom indique, SQL Developer n\u2019est pas seulement r\u00e9serv\u00e9 aux d\u00e9veloppeurs web. Voyons plus en d\u00e9tail qui peut utiliser cet IDE :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Les d\u00e9veloppeurs : <\/b><span style=\"font-weight: 400;\">gr\u00e2ce \u00e0 cette solution Oracle, les d\u00e9veloppeurs peuvent ex\u00e9cuter des requ\u00eates SQL, exporter des donn\u00e9es dans diff\u00e9rents formats, documenter les programmes de database, etc.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Les administrateurs de base de donn\u00e9es<\/b><span style=\"font-weight: 400;\"> : ils peuvent aussi utiliser cette interface pour de nombreuses t\u00e2ches critiques, comme la gestion du stockage, des utilisateurs et des r\u00f4les, les audits, etc.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Les<\/b> <a href=\"https:\/\/datascientest.com\/data-architect\">architectes d&rsquo;application<\/a> <span style=\"font-weight: 400;\">: SQL Developer leur offre de nombreuses fonctionnalit\u00e9s pour <a href=\"https:\/\/datascientest.com\/quest-ce-que-cest-le-predictive-modelling\">mod\u00e9liser les donn\u00e9es<\/a><\/span><span style=\"font-weight: 400;\">. Par exemple, la mod\u00e9lisation logique, relationnelle, physique ou dimensionnelle, les diagrammes de flux de donn\u00e9es, les scripts DDL, etc.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Les administrateurs d\u2019applications web<\/b><span style=\"font-weight: 400;\"> : gr\u00e2ce \u00e0 cette interface, il pourront d\u00e9ployer des applications, administrer Oracle REST Data Services, cr\u00e9er et modifier des services RESTful.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6d7a726 elementor-widget elementor-widget-image\" data-id=\"6d7a726\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/sql_developer_ide.png\" class=\"attachment-full size-full wp-image-198476\" alt=\"\" loading=\"lazy\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/sql_developer_ide.png 800w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/sql_developer_ide-300x169.png 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/sql_developer_ide-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-126d6bf elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"126d6bf\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-sql\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Devenir expert sur SQL Developer<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-427e2bf e-flex e-con-boxed e-con\" data-id=\"427e2bf\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-f6fa473 elementor-widget elementor-widget-heading\" data-id=\"f6fa473\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Quelles sont les fonctionnalit\u00e9s d\u2019Oracle SQL Developer ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-67d1e63 elementor-widget elementor-widget-text-editor\" data-id=\"67d1e63\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Pour permettre<\/span><span style=\"font-weight: 400;\"> le d\u00e9veloppement de A \u00e0 Z d&rsquo;applications en PL\/SQL, <\/span><span style=\"font-weight: 400;\">Oracle SQL Developer propose \u00e0 ses utilisateurs une multitude de fonctionnalit\u00e9s.\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-41187d0 elementor-widget elementor-widget-heading\" data-id=\"41187d0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Les connexions<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d26c93d elementor-widget elementor-widget-text-editor\" data-id=\"d26c93d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">\u00c0 travers SQL Developer, il est possible de <\/span><b>cr\u00e9er des connexions entre plusieurs bases de donn\u00e9es<\/b><span style=\"font-weight: 400;\"> (Oracle ou non).\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">En outre, vous pourrez \u00e9galement stocker les connexions que vous utilisez le plus, importer et\/ou exporter des connexions, etc. <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7c63d74 elementor-widget elementor-widget-heading\" data-id=\"7c63d74\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Les objets<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d7790c4 elementor-widget elementor-widget-text-editor\" data-id=\"d7790c4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Oracle SQL Developer vous permet de <\/span><b>parcourir, cr\u00e9er et modifier des objets. <\/b><span style=\"font-weight: 400;\">En effet, la solution Oracle prend en charge une grande diversit\u00e9 d\u2019objets (tableaux, index, packages, proc\u00e9dures, fonctions, d\u00e9clencheurs, types, s\u00e9quences, vues et journaux mat\u00e9rialis\u00e9s, sch\u00e9mas XML, tables et files d\u2019attente, Java, t\u00e2ches, etc.)<\/span><\/p><p><span style=\"font-weight: 400;\">Concr\u00e8tement, vous disposez de plusieurs de fonctionnalit\u00e9s pour g\u00e9rer les objets, telles que :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">La navigation des objets : tous les objets sont class\u00e9s par types, avec possibilit\u00e9 d\u2019ajouter des filtres pour simplifier la recherche.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">La cr\u00e9ation de bo\u00eetes de dialogue : vous pourrez sp\u00e9cifier des s\u00e9quences et des d\u00e9clencheurs afin de remplir vos colonnes.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">La modification : il est possible de renommer, ajouter, compiler, supprimer, d\u00e9sactiver, d\u00e9boguer, etc. G\u00e9n\u00e9ralement, les actions sont associ\u00e9es \u00e0 chaque type d\u2019objets.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-31ce820 elementor-widget elementor-widget-heading\" data-id=\"31ce820\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">La mise \u00e0 jour des donn\u00e9es<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a64e7c2 elementor-widget elementor-widget-text-editor\" data-id=\"a64e7c2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Gr\u00e2ce \u00e0 des fonctionnalit\u00e9s comme le tri, le filtre, la surbrillance ou la gestion des colonnes, il est beaucoup plus <\/span><b>facile d\u2019interroger les donn\u00e9es de votre SGBD<\/b><span style=\"font-weight: 400;\">. Et pour automatiser les mises \u00e0 jour, n\u2019h\u00e9sitez pas \u00e0 utiliser le g\u00e9n\u00e9rateur de requ\u00eates.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6efbdd0 elementor-widget elementor-widget-text-editor\" data-id=\"6efbdd0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\"><strong>Bon \u00e0 savoir<\/strong> : un journal de message vous permet de suivre toutes les modifications au sein de votre syst\u00e8me de gestion de base de donn\u00e9es. <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2d06d41 elementor-widget elementor-widget-heading\" data-id=\"2d06d41\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">La migration des bases de donn\u00e9es tierces<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-73e1e71 elementor-widget elementor-widget-text-editor\" data-id=\"73e1e71\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Vous pouvez<\/span><b> migrer n\u2019importe quelle base de donn\u00e9es externe vers Oracle Database<\/b><span style=\"font-weight: 400;\">. Par exemple, des donn\u00e9es en provenance d\u2019Access, SQL Server, Sybase ASE, DB2 ou Teradata. Par ailleurs, vous pouvez effectuer diff\u00e9rents types de migrations (migration rapide, moindres privil\u00e8ges, pas \u00e0 pas ou avanc\u00e9e).\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Au-del\u00e0 de toutes ces fonctionnalit\u00e9s, SQL Developer vous permet \u00e9galement de comparer des sch\u00e9mas, modifier le code PL\/SQL, ex\u00e9cuter et d\u00e9boguer PL\/SQL, cr\u00e9er des rapports, etc. <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a790642 elementor-widget elementor-widget-image\" data-id=\"a790642\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/sql_developer_ide3.png\" class=\"attachment-full size-full wp-image-198478\" alt=\"\" loading=\"lazy\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/sql_developer_ide3.png 800w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/sql_developer_ide3-300x169.png 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/sql_developer_ide3-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9ddc25f e-flex e-con-boxed e-con\" data-id=\"9ddc25f\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1642b74 elementor-widget elementor-widget-heading\" data-id=\"1642b74\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Ce qu\u2019il faut retenir<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-620eab9 elementor-widget elementor-widget-text-editor\" data-id=\"620eab9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Oracle SQL Developer est un environnement de d\u00e9veloppement int\u00e9gr\u00e9 (EDI) facilitant la conception d\u2019applications en PL\/SQL.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Il s\u2019adresse aussi bien \u00e0 des d\u00e9veloppeurs, qu\u2019\u00e0 des administrateurs SGBD, ou des architectes d\u2019application.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">SQL Developer dispose de nombreuses fonctionnalit\u00e9s, comme la cr\u00e9ation et la gestion des objets database, l&rsquo;\u00e9dition de code, l&rsquo;exploration de donn\u00e9es, etc. <\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-96864ae elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"96864ae\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-sql\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">D\u00e9marrer une formation sur SQL<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-12c7747 e-flex e-con-boxed e-con\" data-id=\"12c7747\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5cf650d elementor-widget elementor-widget-html\" data-id=\"5cf650d\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"C\u2019est quoi Oracle SQL Developer ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Oracle SQL Developer est un environnement de d\u00e9veloppement int\u00e9gr\u00e9 (IDE) gratuit. Gr\u00e2ce \u00e0 cette interface, vous pouvez d\u00e9velopper vos applications en PL\/SQL, de A \u00e0 Z. Et pour cause, cette solution offre aux d\u00e9veloppeurs une multitude de fonctionnalit\u00e9s comme :  la connexion \u00e0 diverses bases de donn\u00e9es Oracle et non Oracle, la cr\u00e9ation et la gestion des objets database, l'\u00e9dition de code, l'exploration de donn\u00e9es, la comparaison de sch\u00e9mas, la cr\u00e9ation de rapports, la visualisation de donn\u00e9es, etc.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"\u00c0 qui s\u2019adresse SQL Developer ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Contrairement \u00e0 ce que son nom indique, SQL Developer n\u2019est pas seulement r\u00e9serv\u00e9 aux d\u00e9veloppeurs web. Voyons plus en d\u00e9tail qui peut utiliser cet IDE : Les d\u00e9veloppeurs : gr\u00e2ce \u00e0 cette solution Oracle, les d\u00e9veloppeurs peuvent ex\u00e9cuter des requ\u00eates SQL, exporter des donn\u00e9es dans diff\u00e9rents formats, documenter les programmes de database, etc. Les administrateurs de base de donn\u00e9es : ils peuvent aussi utiliser cette interface pour de nombreuses t\u00e2ches critiques, comme la gestion du stockage, des utilisateurs et des r\u00f4les, les audits, etc. Les architectes d'application : SQL Developer leur offre de nombreuses fonctionnalit\u00e9s pour mod\u00e9liser les donn\u00e9es. Par exemple, la mod\u00e9lisation logique, relationnelle, physique ou dimensionnelle, les diagrammes de flux de donn\u00e9es, les scripts DDL, etc.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Que vous soyez expert data, d\u00e9veloppeur ou administrateur syst\u00e8me, l\u2019exploration de la base de donn\u00e9es est une activit\u00e9 quotidienne. Pour cela, plusieurs outils sont mis \u00e0 votre disposition. Parmi les plus efficaces, il y a Oracle SQL Developer. Alors \u00e0 quoi sert-il ? \u00c0 qui s\u2019adresse cette solution ? Quelles sont ses fonctionnalit\u00e9s ? D\u00e9couvrez [&hellip;]<\/p>\n","protected":false},"author":78,"featured_media":198469,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2497],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Developer : Qu&#039;est-ce que c&#039;est ? \u00c0 quoi sert cet outil ?<\/title>\n<meta name=\"description\" content=\"Gr\u00e2ce \u00e0 ces multiples fonctionnalit\u00e9s, Oracle SQL Developer vous permet de d\u00e9velopper vos applications en PL\/SQL, de A \u00e0 Z.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/sql-developer-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Developer : Qu&#039;est-ce que c&#039;est ? \u00c0 quoi sert cet outil ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/sql-developer-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T07:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:44:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/sql_developer_datascientest.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00e9my Robert\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00e9my Robert\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/sql-developer-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/sql-developer-tout-savoir\",\"name\":\"SQL Developer : Qu'est-ce que c'est ? \u00c0 quoi sert cet outil ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-07-25T07:30:00+00:00\",\"dateModified\":\"2023-11-09T13:44:14+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925\"},\"description\":\"Gr\u00e2ce \u00e0 ces multiples fonctionnalit\u00e9s, Oracle SQL Developer vous permet de d\u00e9velopper vos applications en PL\/SQL, de A \u00e0 Z.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/sql-developer-tout-savoir\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925\",\"name\":\"J\u00e9r\u00e9my Robert\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg\",\"caption\":\"J\u00e9r\u00e9my Robert\"},\"description\":\"J\u00e9r\u00e9my Robert est actuellement Directeur p\u00e9dagogique B2B chez DataScientest.com. Avant de rejoindre DataScientest, il a travaill\u00e9 en tant que Consultant Business Intelligence chez DEAPDATA, o\u00f9 il a g\u00e9r\u00e9 des projets dans les domaines de l'assurance, bancaire et industrie. Il a \u00e9galement \u00e9t\u00e9 Co-fondateur et pr\u00e9sident de Tripzer. En tant que consultant ind\u00e9pendant, J\u00e9r\u00e9my a propos\u00e9 des formations sur MicroStrategy pour divers niveaux professionnels. Il est dipl\u00f4m\u00e9 de l'Universit\u00e9 Paris Cit\u00e9 avec un Master MIAGE, combinant comp\u00e9tences en informatique et gestion.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/jeremyrobert1\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/jeremyrobert\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Developer : Qu'est-ce que c'est ? \u00c0 quoi sert cet outil ?","description":"Gr\u00e2ce \u00e0 ces multiples fonctionnalit\u00e9s, Oracle SQL Developer vous permet de d\u00e9velopper vos applications en PL\/SQL, de A \u00e0 Z.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/sql-developer-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"SQL Developer : Qu'est-ce que c'est ? \u00c0 quoi sert cet outil ?","og_url":"https:\/\/datascientest.com\/sql-developer-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-07-25T07:30:00+00:00","article_modified_time":"2023-11-09T13:44:14+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/sql_developer_datascientest.png","type":"image\/png"}],"author":"J\u00e9r\u00e9my Robert","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"J\u00e9r\u00e9my Robert","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/sql-developer-tout-savoir","url":"https:\/\/datascientest.com\/sql-developer-tout-savoir","name":"SQL Developer : Qu'est-ce que c'est ? \u00c0 quoi sert cet outil ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-07-25T07:30:00+00:00","dateModified":"2023-11-09T13:44:14+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925"},"description":"Gr\u00e2ce \u00e0 ces multiples fonctionnalit\u00e9s, Oracle SQL Developer vous permet de d\u00e9velopper vos applications en PL\/SQL, de A \u00e0 Z.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/sql-developer-tout-savoir"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925","name":"J\u00e9r\u00e9my Robert","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg","caption":"J\u00e9r\u00e9my Robert"},"description":"J\u00e9r\u00e9my Robert est actuellement Directeur p\u00e9dagogique B2B chez DataScientest.com. Avant de rejoindre DataScientest, il a travaill\u00e9 en tant que Consultant Business Intelligence chez DEAPDATA, o\u00f9 il a g\u00e9r\u00e9 des projets dans les domaines de l'assurance, bancaire et industrie. Il a \u00e9galement \u00e9t\u00e9 Co-fondateur et pr\u00e9sident de Tripzer. En tant que consultant ind\u00e9pendant, J\u00e9r\u00e9my a propos\u00e9 des formations sur MicroStrategy pour divers niveaux professionnels. Il est dipl\u00f4m\u00e9 de l'Universit\u00e9 Paris Cit\u00e9 avec un Master MIAGE, combinant comp\u00e9tences en informatique et gestion.","sameAs":["https:\/\/www.linkedin.com\/in\/jeremyrobert1\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/jeremyrobert"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/198467"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/78"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=198467"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/198467\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/198469"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=198467"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=198467"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=198467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}