{"id":11786,"date":"2022-04-04T19:52:12","date_gmt":"2022-04-04T17:52:12","guid":{"rendered":"https:\/\/sdform.itds.fr\/cours\/?post_type=lp_course&p=11786"},"modified":"2024-09-15T21:06:06","modified_gmt":"2024-09-15T19:06:06","slug":"oracle-administration","status":"publish","type":"lp_course","link":"https:\/\/sdform.itds.fr\/cours\/all\/base-de-donnees\/oracle-administration\/","title":{"rendered":"Oracle Administration"},"content":{"rendered":"

Description<\/h4>\n

\u2022 Comprendre le mod\u00e8le relationnel
\n\u2022 Savoir identifier les objets d’une base des donn\u00e9es Oracle
\n\u2022 Interroger et classer les donn\u00e9es d’une table
\n\u2022 Manipuler les donn\u00e9es dans les tables de la base
\n\u2022 Savoir restituer les donn\u00e9es<\/p>\n

 <\/p>\n

Programme d\u00e9taill\u00e9<\/h4>\n

 <\/p>\n

INTRODUCTION<\/em><\/p>\n

\u2022 Objectifs de l’ouvrage
\n\u2022 Pr\u00e9sentation d’Oracle Database 12c
\n\u2022 Conventions d’\u00e9criture<\/p>\n

 <\/p>\n

LES BASES DE L\u2019ARCHITECTURE ORACLE<\/em><\/p>\n

\u2022 Pr\u00e9sentation g\u00e9n\u00e9rale
\n\u2022 La base de donn\u00e9es
\n\u2022 L’instance
\n\u2022 L’administrateur de base de donn\u00e9es
\n\u2022 Le dictionnaire de donn\u00e9es<\/p>\n

 <\/p>\n

INSTALLATION<\/em><\/p>\n

\u2022 Installation du serveur
\n\u2022 Installation du client<\/p>\n

 <\/p>\n

ORACLE NET<\/em><\/p>\n

\u2022 Configuration c\u00f4t\u00e9 serveur
\n\u2022 Configuration c\u00f4t\u00e9 client
\n\u2022 Probl\u00e8mes courants et solutions<\/p>\n

 <\/p>\n

LES OUTILS D\u2019ADMINISTRATION<\/em><\/p>\n

\u2022 SQL*Plus & Oracle SQL Developer
\n\u2022 Oracle Enterprise Manager Database Express
\n\u2022 La documentation Oracle
\n\u2022 Diagnostiquer les probl\u00e8mes
\n\u2022 Les t\u00e2ches de maintenance automatis\u00e9es<\/p>\n

 <\/p>\n

DEMARAGE ET ARRET<\/em><\/p>\n

\u2022 Principes
\n\u2022 D\u00e9marrage & Arr\u00eat
\n\u2022 Automatisation et scripts<\/p>\n

 <\/p>\n

CREATION D\u2019UNE NOUVELLE BASE DE <\/em>DONNEES<\/em><\/p>\n

\u2022 Vue d’ensemble
\n\u2022 Cr\u00e9ation de la base de donn\u00e9es manuellement
\n\u2022 Cr\u00e9ation de la base de donn\u00e9es \u00e0 l’aide de l’assistant graphique<\/p>\n

 <\/p>\n

GESTION DE L\u2019INSTANCE<\/em><\/p>\n

\u2022 Gestion des param\u00e8tres d’initialisation
\n\u2022 Gestion dynamique de la m\u00e9moire<\/p>\n

 <\/p>\n

FICHIERS DE CONTROLE ET DE <\/em>JOURNALISATION<\/em><\/p>\n

\u2022 Gestion des fichiers de contr\u00f4le
\n\u2022 Gestion des fichiers de journalisation<\/p>\n

 <\/p>\n

TABLESPACES ET FICHIERS DE DONNEES<\/em><\/p>\n

\u2022 Vue d’ensemble et directives
\n\u2022 Tablespace permanent
\n\u2022 Organisation du stockage \u00e0 l’int\u00e9rieur d’un tablespace
\n\u2022 Tablespace temporaire
\n\u2022 Trouver des informations sur les tablespaces et les
\nfichiers de donn\u00e9es
\n\u2022 Utiliser EM Express
\n\u2022 Probl\u00e8mes courants et solutions<\/p>\n

 <\/p>\n

GESTION DES INFORMATIONS <\/em>D\u2019ANNULATION<\/em><\/p>\n

\u2022 Vue d’ensemble
\n\u2022 Mise en \u0153uvre de la gestion automatique
\n\u2022 Gestion du tablespace d’annulation
\n\u2022 Trouver des informations sur la gestion de l’annulation
\n\u2022 Utiliser EM Express
\n\u2022 Probl\u00e8mes courants et solutions<\/p>\n","protected":false},"excerpt":{"rendered":"

-JAVA- Les fondamentaux et le d\u00e9veloppement Java SE<\/p>\n","protected":false},"author":1,"featured_media":11973,"comment_status":"closed","ping_status":"closed","template":"","course_category":[41],"course_tag":[],"class_list":["post-11786","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category-base-de-donnees","pmpro-has-access","course"],"_links":{"self":[{"href":"https:\/\/sdform.itds.fr\/cours\/wp-json\/wp\/v2\/lp_course\/11786","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdform.itds.fr\/cours\/wp-json\/wp\/v2\/lp_course"}],"about":[{"href":"https:\/\/sdform.itds.fr\/cours\/wp-json\/wp\/v2\/types\/lp_course"}],"author":[{"embeddable":true,"href":"https:\/\/sdform.itds.fr\/cours\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sdform.itds.fr\/cours\/wp-json\/wp\/v2\/comments?post=11786"}],"version-history":[{"count":2,"href":"https:\/\/sdform.itds.fr\/cours\/wp-json\/wp\/v2\/lp_course\/11786\/revisions"}],"predecessor-version":[{"id":11807,"href":"https:\/\/sdform.itds.fr\/cours\/wp-json\/wp\/v2\/lp_course\/11786\/revisions\/11807"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sdform.itds.fr\/cours\/wp-json\/wp\/v2\/media\/11973"}],"wp:attachment":[{"href":"https:\/\/sdform.itds.fr\/cours\/wp-json\/wp\/v2\/media?parent=11786"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/sdform.itds.fr\/cours\/wp-json\/wp\/v2\/course_category?post=11786"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/sdform.itds.fr\/cours\/wp-json\/wp\/v2\/course_tag?post=11786"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}