Oracle12c Release 1 & 2 New Features For AdministratorsCourse: OR1212NF
Duration: 5 Days
Level: I
Course Summary
This course provides a complete, hands-on introduction to the newest releases of Oracle Enterprise Edition. Key features of this product are fully discussed and demonstrated. Topics Covered In This Course
CHAPTER 1 – SQL ENHANCEMENTSMAJOR ENHANCEMENTSTOP N AND BOTTOM N QUERIESUSING EXTENDED DATATYPESCONCURRENT UNION / UNION ALL EXECUTIONSEQUENCES WITH DEFAULT VALUESSEQUENCES WITH GLOBAL TEMPORARY TABLESIDENTITY COLUMNSNEW SEQUENCE FUNCTIONALITY FOR ORACLE REPLAYINVISIBLE COLUMNSTEMPORAL VALIDITYPATTERN MATCHINGDATA VALIDATIONDATA-BOUND COLLATIONSETTING COLLATION AT THE SCHEMA LEVELSETTING COLLATION AT THE TABLE AND COLUMN LEVELSSETTING COLLATION FOR VIEWS USING COLLATESPECIFYING COLLATION FOR AN EXPRESSIONCASE-INSENSITIVE DATABASEUNICODE 7.0 SUPPORTMISCELLANEOUS NEW SQL FEATURESTHEY BROKE LOGIN.SQL!DATA MODEL REVIEWLAB 1: SQL ENHANCEMENTSLAB 1 SOLUTIONS: SQL ENHANCEMENTSCHAPTER 2 – PL/SQL ENHANCEMENTSWHITE LISTSTHE WITH CLAUSE FOR FUNCTIONSPRAGMA UDFNEW INQUIRY DIRECTIVESNEW DBMS_SQL FUNCTIONALITYENHANCED LANGUAGE INTERFACE FEATURESTHE IMPACT OF DATA-BOUND COLLATIONNEW VIEWS FOR USE WITH PL/SCOPEMISCELLANEOUS NEW PL/SQL FEATURES FOR ORACLE12CLAB 2: PL/SQL ENHANCEMENTSLAB 2 SOLUTIONS: PL/SQL ENHANCEMENTSCHAPTER 3 – INSTALLATION / UPGRADINGOVERVIEW OF DATABASE CREATIONIN THE BEGINNINGTHE ORACLE UNIVERSAL INSTALLERPREREQUISITE TASKSMEMORY REQUIREMENTSHARDWARE REQUIREMENTSSOFTWARE REQUIREMENTSPACKAGE REQUIREMENTSWHAT ABOUT WINDOWS?RUNNING THE INSTALLERPOST INSTALLATIONENVIRONMENTUSING THE DATABASE CONFIGURATION ASSISTANTUSING THE DATABASE CONFIGURATION ASSISTANT – SHORT FORMDATABASE TEMPLATESUPGRADING THE DATABASEUSING THE COMPATIBLE PARAMETERDATABASE CONTROL REMOVALUPGRADE PREREQUISITESTIME WARP FROM CHAPTER 8REMOVING ORACLE SOFTWARELAB 3: INSTALLATION / UPGRADINGLAB 3 SOLUTIONS: INSTALLATION / UPGRADINGCHAPTER 4 – ENTERPRISE MANAGER ENHANCEMENTSDATABASE MANAGEMENT USING EMDEENVIRONMENTAL VARIABLESACCESSING ENTERPRISE MANAGER DATABASE EXPRESSMODIFIED FUNCTIONALITY WITH EMDECHANGING PARAMETERSMODIFICATION OF PHYSICAL STRUCTURESDELETED FUNCTIONALITY IN EMDEDATABASE ADMINISTRATION WITH OTHER TOOLSEMDE ACCESS FOR NON-DBA USERSEMDE ACCESS TO PLUGGABLE DATABASES/LAB 4: ENTERPRISE MANAGER ENHANCEMENTSLAB 4 SOLUTIONS: ENTERPRISE MANAGER ENHANCEMENTSCHAPTER 5 – SQL DEVELOPER / SQL*PLUSSQL DEVELOPER NEW FEATURESINSTANCE VIEWERMULTITENANT CONNECTION CONSIDERATIONSUSING SQL DEVELOPERSQL*PLUS FOR ORACLE12CNEW SHOW COMMANDSLAST LOGIN TIMESUPPORT FOR THE NEW ADMINISTRATIVE PRIVILEGESSUPPORT FOR PLUGGABLE DATABASESWE HAVE HISTORY! (R2)PERFORMANCE SETTINGS (R2)CSV OPTION FOR MARKUP (R2)FEEDBACK ONLY (R2)SUPPORT FOR LONG IDENTIFIERS (R2)APPLICATION CONTINUITY FLAG (R2)INPUT BINDING (R2)A BRIEF WORD ON SQL DEVELOPER 17.2LAB 5: SQL DEVELOPER / SQL*PLUSLAB 5 SOLUTIONS: SQL DEVELOPER / SQL*PLUSCHAPTER 6 – MULTITENANT DATABASESTHE IMPACT OF MULTITENANT ARCHITECTUREMAJOR BENEFITS OF MULTITENANT ARCHITECTURETHE BIRD’S EYE VIEWWALKING THE DIRECTORIES OF A CONTAINER DATABASEWHO? WHAT? WHEN? WHERE? HOW?IMPACTS OF MULTITENANT ARCHITECTURETOOLS FOR USE WITH MULTITENANT ARCHITECTURE
LAB 6: MULTITENANT DATABASESLAB 6 SOLUTIONS: MULTITENANT DATABASESCHAPTER 7 – MULTITENANT BASICSCREATING CDBSFEATURES UNSUPPORTED FOR MULTITENANT ARCHITECTURETHE CREATE DATABASE COMMAND FOR CDBSSEED DATA FILESCONFIGURING ENTERPRISE MANAGER DATABASE EXPRESS FOR CDBSUSING SQL DEVELOPER WITH CDBS AS A DBALAB 7: MULTITENANT BASICSLAB 7 SOLUTIONS: MULTITENANT BASICSCHAPTER 8 – INTERMEDIATE MULTITENANTOPTIONS AVAILABLETHE CREATE PLUGGABLE DATABASE STATEMENT
PREPARING TO CREATE PDBSCREATING PDBS USING THE CDB SEED
CLONING AN EXISTING LOCAL PDB
CLONING AN EXISTING REMOTE PDB
Effects Of Cloning A Remote PDBHOT CLONINGREFRESHABLE PDBSUNPLUGGING A PDBCREATING A PDB BY PLUGGING IN AN UNPLUGGED PDBENHANCEMENTS TO UNPLUG/PLUG IN RELEASE 2CREATING A PDB FROM A NON-CDB DATABASEUsing DBMS_PDBHOT CLONING NON-CDBSPDB RELOCATENEW TRIGGER TYPES FOR PDBSThe BEFORE UNPLUG TriggerThe AFTER CLONE TriggerLAB 8: INTERMEDIATE MULTITENANTLAB 8 SOLUTIONS: INTERMEDIATE MULTITENANTCHAPTER 9 – ADVANCED MULTITENANTUSING DATA PUMP EXPORT AND IMPORTUSING EXP AND IMPDROPPING PDBSUSING CLOUD CONTROL TO CREATE AND DROP PDBSADMINISTRATION DETAILSSPECIAL ROLES FOR CDBSOTHER ADMINISTRATIVE CONSIDERATIONS FOR CDBSMANAGEABILITY CONSIDERATIONSOBJECTS IN CDBSSERVICESSESSIONSCOMMON LISTENERSCONNECTING TO PDBS IN MOUNT MODELOGIN TRIGGERS AND THE SET CONTAINER CLAUSEPACKAGE STATES AND CONTAINERSEXECUTE IMMEDIATE AND SET CONTAINEREXECUTING ACROSS ALL PLUGGABLE DATABASES USING DBMS_SQLLOGGING ERRORS FOR MULTIPLE CONTAINERSALTER DATABASE IN A CDBTABLESPACES IN CDBSUSING FORCE ON PDBSCLOSE VS. CLOSE IMMEDIATESPECIFYING PDBS IN ALTER PLUGGABLE DATABASEDEFAULT AND TEMPORARY TABLESPACES FOR PDBSLAB 9: ADVANCED MULTITENANTLAB 9 SOLUTIONS: ADVANCED MULTITENANTCHAPTER 10 – ULTIMATE MULTITENANTTHE STARTUP COMMAND WITHIN PDBSSTARTUP PLUGGABLE DATABASESHUTDOWN WITHIN PDBSALTER SYSTEM SET STATEMENTS IN CDBSTHE CONTAINER CLAUSE IN DDL STATEMENTSRUNNING SCRIPTS IN ALL CONTAINERSAUTOMATING TNSNAMES.ORA MAINTENANCELAB 10: ULTIMATE MULTITENANTLAB 10 SOLUTIONS: ULTIMATE MULTITENANTCHAPTER 11 – MULTITENANT ROUNDUPRENAMING A PLUGGABLE DATABASEMOVING A PDBUSING ORACLE MANAGED FILES WITH CDBSTHIS IS FOR YOUR OWN GOOD!A BRIEF WORD ON DATA GUARDMULTITENANT ENHANCEMENTS IN RELEASE 2
DEFAULT TABLESPACE CLAUSE IN CLONINGRELAXED CHARACTER SET RESTRICTIONSSUPPORT FOR INDIVIDUALIZED PDB TIME ZONESFLASHBACK DATABASERELOCATING PDBS ONLINELAB 11: MULTITENANT ROUNDUPLAB 11 SOLUTIONS: MULTITENANT ROUNDUPCHAPTER 12 – STORAGE AND SECURITYNEW SUPER USERSENHANCED SECURITY FOR CDBSTEMPORARY TABLESPACE CONSIDERATIONS FOR CDBSHARDENING A CDBSTORAGE CLAUSES RELEVANT TO PDBSALTER SYSTEM IN A PDBSCOPE = SPFILE In PDBsSERVICES AND PDBSVIEWS IN CDBSCON_ID DetailsOTHER INTERESTING CDB VIEWSCDB VIEW EXAMPLESNEW FUNCTIONS FOR CONTAINERSTRIGGERS IN A CDBMOVING DATAFILES ONLINERAW PARTITIONSDATABASE SMART FLASH CACHE SUPPORTNETWORK FILE SYSTEM CAPABILITYLAB 12: STORAGE AND SECURITYLAB 12 SOLUTIONS: STORAGE AND SECURITYCHAPTER 13 – BACKUP AND RECOVERY FOR CDBSCONTAINER DATABASE CONSIDERATIONSBACKUP SETUPBACKING UP THE ENTIRE CDBBACKING UP JUST THE ROOT CONTAINERBACKING UP PDBSBACKING UP TABLESPACES AND DATAFILES FROM WITHIN A PDBEXECUTING RMAN ACROSS PDBSREDO LOG, ARCHIVE LOG AND CONTROLFILE BACKUPS IN CDBSCOMPLETE RECOVERY OF A CDBCOMPLETE RECOVERY OF A PDBCOMPLETE RECOVERY OF THE ROOT CONTAINERINCOMPLETE RECOVERY OF THE ENTIRE CDBINCOMPLETE RECOVERY OF PDBSLOSS OF SYSTEM TABLESPACE IN A PDBRMAN RESTRICTIONS IN PDBSPRIOR BACKUPS AND ARCHIVELOGS FOR CONVERTED NON-CDBSFLASHBACK AND CDBSDATA PUMP AND CDBSLAB 13: BACKUP AND RECOVERY FOR CDBSLAB 13 SOLUTIONS: BACKUP AND RECOVERY FOR CDBSCHAPTER 14 – AUTOMATIC DATA OPTIMIZATIONSTORAGE AND COMPRESSION TIERINGTHE HEAT MAPAUTOMATIC DATA OPTIMIZATIONCOMPRESSION LEVELSDATA DICTIONARY VIEWS FOR ADOLAB 14: AUTOMATIC DATA OPTIMIZATIONLAB 14 SOLUTIONS: AUTOMATIC DATA OPTIMIZATIONCHAPTER 15 – IN-DATABASE ARCHIVINGTO KEEP OR NOT TO KEEPTHE ROW ARCHIVAL CLAUSEORA_ARCHIVE_STATEROW ARCHIVAL VISIBILITYLAB 15: IN-DATABASE ARCHIVINGLAB 15 SOLUTIONS: IN-DATABASE ARCHIVINGCHAPTER 16 – AUDITING ENHANCEMENTSUNIFIED AUDITINGENABLING UNIFIED AUDITINGDISABLING UNIFIED AUDITINGHANDLING EARLIER AUDIT RECORDSCREATING A SEC_ADMIN ACCOUNTCREATING A UNIFIED AUDIT POLICYAUTOMATIC AUDITS WITH UNIFIED AUDITINGDISABLING / DROPPING AUDIT POLICIESIMMEDIATE-WRITE VS. QUEUED-WRITE MODEAUDIT DATA CLEANUPNEW UNIFIED AUDITING FEATURES IN RELEASE 2LAB 16: AUDITING ENHANCEMENTSLAB 16 SOLUTIONS: AUDITING ENHANCEMENTSCHAPTER 17 – PRIVILEGE ENHANCEMENTSCONSIDERATIONS REGARDING PASSWORD CASE SENSITIVITYPROFILES AND PASSWORD POLICIESROLES IN ORACLE12CSEPARATION OF DUTYINHERIT [ ANY ] PRIVILEGESPERMISSION CONTROL WITHIN VIEWSDATABASE PRIVILEGE ANALYSISRESTRICTIONS ON PRIVILEGE ANALYSISPOTENTIAL BENEFITS OF PRIVILEGE ANALYSISPRIVILEGE ANALYSIS IN CONTAINER DATABASESPRIVILEGE ANALYSIS POLICIESDISABLING A PRIVILEGE ANALYSIS POLICYGENERATING A PRIVILEGE ANALYSIS REPORTDROPPING A PRIVILEGE ANALYSIS POLICYSIGNIFICANT CHANGES TO ROLES AND PRIVILEGESLAB 17: PRIVILEGE ENHANCEMENTSLAB 17 SOLUTIONS: PRIVILEGE ENHANCEMENTSCHAPTER 18 – DATA REDACTIONOVERVIEW OF DATA REDACTIONEXEMPTION FROM REDACTION POLICIESHOW AND WHEN REDACTION OCCURSREDACTION EXAMPLESFUNCTION_PARAMETERS FOR PARTIAL REDACTIONUSING REGULAR EXPRESSIONSUSING RANDOM VALUES IN REDACTIONTHE EXPRESSION PARAMETERENABLE / DISABLE / DROP REDACTION POLICIESUSING RES FOR PARTIAL VARCHAR2 REDACTIONSNEW REDACTION PROCEDURES IN RELEASE 2REDACTION_POLICIES / REDACTION_COLUMNSLAB 18: DATA REDACTIONLAB 18 SOLUTIONS: DATA REDACTIONCHAPTER 19 – RMAN ENHANCEMENTSNEW BACKUP SUPER USERRMAN CONNECTIONSSELECT AND DESCRIBE FROM WITHIN RMANSIMPLER SQL COMMANDSDUPLICATE WITH NOOPENCROSS-PLATFORM BACKUP AND RESTORERECOVERY OVER A NETWORKSTORAGE SNAPSHOT TECHNOLOGYTABLE AND PARTITION RECOVERYMULTISECTION BACKUPS ON VERY LARGE FILESACTIVE DATABASE DUPLICATION ENHANCEMENTSTABLESPACE TRANSPORTS ACROSS PLATFORMS AND ENDIANNESSCONVERT AT SOURCERESTORE FROM CONVERTED AT SOURCECONVERT AT TARGETRESTORE FROM CONVERTED AT TARGETSTANDBY DATABASE UPDATINGDATA GUARD ENHANCEMENTSORACLE SCHEDULER SCRIPT JOBSMEMORY-RESIDENT (A.K.A. IN-MEMORY) SCHEDULER JOBSENHANCEMENTS ADDED IN ORACLE 12C RELEASE 2CHAPTER 20 – DB OPERATIONSDATABASE OPERATIONSDO MONITORING USE CASESENABLING DATABASE OPERATIONS MONITORINGDB OPERATIONS MONITORING ARCHITECTURE OVERVIEWDO ATTRIBUTESUSING DBMS_SQL_MONITORBEGIN_OPERATION FunctionEND_OPERATION ProcedureREPORT_SQL_MONITOR FunctionSIMPLE DATABASE OPERATIONS MONITORING EXAMPLETHE ACTIVE REPORT TYPENEW OPTIMIZER HINTSLAB 20: DB OPERATIONSLAB 20 SOLUTIONS: DB OPERATIONSCHAPTER 21 – SCHEMA AND DATA CHANGESDATABASE CHANGESCHANGE MANAGEMENT CAPABILITIESTHE DBMS_COMPARISON PACKAGETHE CREATE COMPARISON PROCEDURETHE COMPARE FUNCTIONDISCOVERING DIFFERENCESTHE CONVERGE PROCEDURETHE RECHECK FUNCTIONTHE DBA_COMPARISON_COLUMNS VIEWLAB 21: SCHEMA AND DATA CHANGESLAB 21 SOLUTIONS: SCHEMA AND DATA CHANGESCHAPTER 22 – SQL TUNINGADAPTIVE EXECUTION PLANSDBMS_XPLAN AND ADAPTIVE EXECUTION PLANSSQL PLAN DIRECTIVES / EXTENDED STATISTICSENHANCED STATISTICS GATHERINGHISTOGRAM ENHANCEMENTSLAB 22: SQL TUNINGLAB 22 SOLUTIONS: SQL TUNINGCHAPTER 23 – REAL-TIME ADDM / PERFORMANCETHE AUTOMATIC DATABASE DIAGNOSTIC MONITORREAL-TIME ADDMEMERGENCY MONITORING / CURRENT ADDM FINDINGSMONITORING THE DATABASE WITH THE NEW EMDEUSING THE PERFORMANCE HUB
WORKLOAD REPOSITORY REPORTSMODIFYING AUTOMATIC SNAPSHOT SETTINGSUSING OTHER ADVISORS
DATABASE REPLAY
SECUREFILESPGA_AGGREGATE_LIMITREAL APPLICATION TESTINGPATCH INVENTORY PACKAGESTATISTICS ENHANCEMENTSAUTOMATIC COLUMN GROUP DETECTIONCONCURRENT STATISTICS GATHERINGINCREMENTAL STATISTICS ENHANCEMENTSGLOBAL TEMPORARY TABLES SESSION-PRIVATE STATISTICSREPORTING MODEPAST STATISTICS COLLECTION REPORTSLAB 23: REAL-TIME ADDM / PERFORMANCELAB 23 SOLUTIONS: REAL-TIME ADDM / PERFORMANCECHAPTER 24 – RESOURCE MANAGER FOR CDBSRESOURCE MANAGER AND CDBSCDB RESOURCE PLANSTHE INITIAL DEFAULT DIRECTIVE ATTRIBUTES FOR PDBSPDB RESOURCE PLANSBACKGROUND AND ADMINISTRATIVE TASKSCREATING THE RESOURCE PLAN FOR THE CDBUPDATING THE CDB RESOURCE PLANADDING A NEW PLAN DIRECTIVE FOR A PDBDELETING A PDB’S PLAN DIRECTIVEENABLING THE CDB RESOURCE PLANDISABLING THE CDB RESOURCE PLANDELETING THE ENTIRE CDB RESOURCE PLANCREATING / MODIFYING PDB RESOURCE PLANSENABLING / DISABLING PDB RESOURCE PLANSRESOURCE MANAGER VIEWSENABLING RESOURCE MANAGER IN PDBSUSING CLOUD CONTROL WITH RESOURCE MANAGERRUNAWAY QUERY MANAGEMENTDBMS_SCHEDULER WITH A CDBRELEASE 2 ENHANCEMENTSLAB 24: RESOURCE MANAGER FOR CDBSLAB 24 SOLUTIONS: RESOURCE MANAGER / PERFORMANCECHAPTER 25 – TABLE / INDEX ENHANCEMENTSCREATING MULTIPLE INDEXES ON COLUMNSADVANCED ROW COMPRESSIONONLINE REDEFINITION ENHANCEMENTSSPLIT PARTITION AND SUBPARTITION (R1)OTHER RELEVANT RELEASE 1 NEW FEATURESDML_LOCK_TIMEOUTEDITIONING ENHANCEMENTSCONVERSION OF A NONPARTITIONED TABLECREATE TABLE FOR EXCHANGE (CTFE)MONITORING INDEX USAGEDBA_INDEX_USAGEV$INDEX_USAGE_INFOOPTIMIZER STATISTICS ADVISORSUBPARTITIONED INTERVAL PARTITIONSLIST PARTITIONING ENHANCEMENTSLAB 25: TABLE / INDEX ENHANCEMENTSLAB 25 SOLUTIONS: TABLE / INDEX ENHANCEMENTSCHAPTER 26 – ADR / NETWORK ENHANCEMENTSADR DIRECTORY STRUCTUREADR COMMAND INTERPRETER ENHANCEMENTSADVANCED NETWORK COMPRESSIONMULTIPROCESS / MULTITHREADED ARCHITECTUREVERY LARGE NETWORK BUFFERSCHAPTER 27 – DATA LOADING ENHANCEMENTSDATA PUMP ENHANCEMENTSDATA PUMP VIEWS_AS_TABLESTRANSFORM CLAUSE ENHANCEMENTSNEW PARAMETERSLOG MINER ENHANCEMENTSFULL TRANSPORTABLE EXPORT / IMPORTSQL*LOADER ENHANCEMENTS
SQL*LOADER ENHANCEMENTSSQL*LOADER / EXTERNAL TABLE COMMON ENHANCEMENTSEXTERNAL TABLE PARAMETER OVERRIDEEXTERNAL TABLE ENHANCEMENTSREAL-TIME MATERIALIZED VIEWSLAB 27: DATA LOADING ENHANCEMENTSLAB 27 SOLUTIONS: DATA LOADING ENHANCEMENTSCHAPTER 28 – PARTITIONING ENHANCEMENTSMOVING PARTITIONS ONLINEINTERVAL-REFERENCE PARTITIONINGENHANCED CASCADE FUNCTIONALITYOPERATING ON MULTIPLE PARTITIONSPARTIAL INDEXESGLOBAL INDEX MAINTENANCECONTROLLING STATISTICS GATHERING FOR PARTITIONSCHAPTER 29 – NEW FEATURES IN 12.1.0.2ABOUT 12.1.0.2ADVANCED INDEX COMPRESSIONAPPROX_COUNT_DISTINCTENHANCED APPROXIMATIONS IN RELEASE 2
ATTRIBUTE CLUSTERINGBIG TABLE CACHINGFLASHBACK DATA ARCHIVE SUPPORT FOR CDBSFULL DATABASE CACHINGIN-MEMORY AGGREGATIONIN-MEMORY COLUMN STORE
DATA PUMP AND INMEMORYENHANCEMENTS IN RELEASE 2SUPPORT FOR JSONFIPS 140 ENCRYPTION PARAMETERPDB CONTAINERS CLAUSE IN QUERIESOMF FILE REPLACEMENT FOR PDBSTHE PDB LOGGING CLAUSEPDB METADATA CLONESPDB REMOTE CLONESPLATFORM SUPPORT FOR PDB SNAPSHOT CLONINGTHE PDB STANDBYS CLAUSESTATE MANAGEMENT FOR PDBS ACROSS PDB RESTARTPDB SUBSET CLONINGRAPID HOME PROVISIONINGZONE MAPSCHAPTER 30 – SQLCLTHE DEATH OF SQL*PLUS?INSTALLATIONCONNECTINGEDITING / AUTOCOMPLETE
SQLFORMAT ANSICONSOLENEW COMMANDS
MISCELLANEOUSLAB 30: SQLCLLAB 30 SOLUTIONS: SQLCLCHAPTER 31 – APPLICATION EXPRESS 5.0PACKAGED APPLICATIONSPAGE DESIGNER
UNIVERSAL THEMEUSER INTERFACE ENHANCEMENTSIMPROVED APPLICATION BUILDER DESIGNINTERACTIVE REPORTINGMOBILE ENHANCEMENTSALL NEW CALENDARAPEX EXAMPLES
CHAPTER 32 – RESOURCE MANAGEMENT IN R2MEMORY MANAGEMENT FOR PDBSI/O MANAGEMENT FOR PDBSCPU MANAGEMENT FOR PDBSSYSTEM ACCESSLOCKDOWN PROFILESCREATE LOCKDOWN PROFILEALTER LOCKDOWN PROFILEDROP LOCKDOWN PROFILESETTING PDB_LOCKDOWNEXAMPLESLAB 32: RESOURCE MANAGEMENT IN R2LAB 32 SOLUTIONS: RESOURCE MANAGEMENT IN R2CHAPTER 33 – ORACLE SHARDINGORACLE SHARDINGSHARDING BENEFITSSHARDING COMPONENTSAPPLICATION SUITABILITYCHAPTER 34 – APPLICATION CONTAINERSWHAT ARE APPLICATION CONTAINERS?APPLICATION CONTAINER CREATIONAPPLICATION CREATIONAPPLICATION PDB CREATIONAPPLICATION CONTAINER MANAGEMENTAPPLICATION SEED CREATIONCONTAINERS QUERY HINTSLAB 34: APPLICATION CONTAINERSLAB 34 SOLUTIONS: APPLICATION CONTAINERSCHAPTER 35 – DEPRECATIONS & DESUPPORTSDEPRECATED FEATURES FOR RELEASE 1DESUPPORTED FEATURES FOR RELEASE 1DEPRECATED PARAMETERS FOR RELEASE 1
DEPRECATED VIEWS FOR RELEASE 1DEPRECATED FEATURES FOR RELEASE 2DESUPPORTED FEATURES FOR RELEASE 2DEPRECATED PARAMETERS FOR RELEASE 2DESUPPORTED PARAMETERS FOR RELEASE 2DEPRECATED VIEWS FOR RELEASE 2PARAMETER DEFAULT CHANGES FOR RELEASE 2What You Can Expect
This new course covers both Release 1 and Release 2. Since Release 2 had major impacts on most of the new features of Release 1, an integrated course is an ideal approach to bring Oracle professionals up to date. Who Should Take This Course
This course is appropriate for anyone needing to learn key new features of Oracle12c from Release 1 (12.1.0.1.0) through Release 2 (12.2.0.1.0). That would include end users, business analysts, application developers, database administrators and IT management. Recommended Prerequisites
A thorough knowledge of Oracle11g database administration is required. Full familiarity with Oracle11g PL/SQL is highly desirable. Training Style
Interactive involving each student Hands-on Labs and workshop oriented Instructor-led Related Courses
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year. You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details. |
|
|||||||||||||||||||||
Can't find the course you want? Call us at 800.533.3893, or email us at [email protected] |
||||||||||||||||||||||