31 DBC courses

This program is tailored for Seniors (over the age of 65) who already speak Greek and would like to be given the chance to speak Greek MORE, to connect with people of similar background and interests and to expand their social network from the comfort of their home! Within a welcoming, lively, relaxed and fun atmosphere, we are focusing on discussion and activities about Greek music, cinema, history, society, nature, everyday life, travel, food and lots more!

Duration 5 Days 30 CPD hours This course is intended for This hands-on course is geared for experienced DBAs with basic Oracle 19c skills. Overview This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs andexercises. Working in a hands-on learning environment led by our expert facilitator, students will explore: Creating CDBs and Regular PDBs Managing CDBs and PDBs Backup and Duplicate Upgrading and Transporting CDBs and Regular PDBs Backup Strategies and Terminology Restore and Recovery Concepts Using Flashback Technologies Duplicating a Database Installing Grid Infrastructure and Oracle Database Patching Grid Infrastructure and Oracle Database Upgrading to Oracle Grid Infrastructure Using General Overall Database Enhancements Monitoring and Tuning Database Performance Managing Application PDBs Managing Security in Multitenant databases Recovery and Flashback Configuring and Using RMAN Diagnosing Failures Performing Recovery Transporting Data RMAN Troubleshooting and Tuning Creating an Oracle Database by using DBCA Oracle Restart Upgrading the Oracle Database Installing Grid Infrastructure for a Standalone server Using Availability Enhancements Tuning SQL Statements Geared for participants experienced with Oracle 19c DBA essentials Oracle 19c Database Administration II (Oracle DBA II) expands their understanding of Oracle database administration. Throughout the course students will explore coverage of Multitenant (CDB/PDB), database tuning, SQL tuning, and backup and recovery: the skills needed to keep a database running reliably and efficiently. The current release of the database is used for exercises and demonstrations, and the content back-ported as necessary for previous releases. CREATING CDBS AND REGULAR PDBS * Configure and create a CDB * Create a new PDB from the CDB seed * Explore the structure of PDBs MANAGE CDBS AND PDBS * Manage PDB service names and connections * Manage startup, shutdown and availability of CDBs and PDBs * Change the different modes and settings of PDBs * Evaluate the impact of parameter value changes * Performance management in CDBs and PDBs * Control CDB and PDB resource usage with the Oracle Resource Manager BACKUP AND DUPLICATE * Perform Backup and Recover CDBs and PDBs * Duplicate an active PDB * Duplicate a Database UPGRADING AND TRANSPORTING CDBS AND REGULAR PDBS * Upgrade an Oracle Database * Transport Data BACKUP STRATEGIES AND TERMINOLOGY * Perform Full and Incremental Backups and Recoveries * Compress and Encrypt RMAN Backups * Use a media manager * Create multi-section backups of exceptionally large files * Create duplexed backup sets * Create archival backups * Backup of recovery files * Backup non database files * Back up ASM meta data RESTORE AND RECOVERY CONCEPTS * Employ the best Oracle Database recovery technology for your failure situation * Describe and use Recovery technology for Crash, Complete, and Point-in-time recovery USING FLASHBACK TECHNOLOGIES * Configure your Database to support Flashback * Perform flashback operations DUPLICATING A DATABASE * Duplicate Databases INSTALL GRID INFRASTRUCTURE AND ORACLE DATABASE * Install Grid Infrastructure for a Standalone server Install Oracle Database software PATCHING GRID INFRASTRUCTURE AND ORACLE DATABASE * Patch Grid Infrastructure and Oracle Database UPGRADING TO ORACLE GRID INFRASTRUCTURE * Upgrade Oracle Grid Infrastructure USING GENERAL OVERALL DATABASE ENHANCEMENTS * Install Oracle Database software Create, Delete and Configure Databases using DBCA Creating CDBs and Regular PDBs Use Miscellaneous 19c New Features MONITORING AND TUNING DATABASE PERFORMANCE * Managing Memory Components Understanding the Automatic Workload Repository (AWR) Understanding the Advisory Framework Monitoring Wait Events, Sessions, and Services Managing Metric Thresholds and Alerts Understanding and Using the Performance Tuning Methodology Performing Performance Planning Understanding the Automatic Database Diagnostic Monitor (ADDM) MANAGE APPLICATION PDBS * Explain the purpose of application root and application seed Define and create application PDBs Install, upgrade and Patch applications Create and administer Application PDBS Clone PDBs and Application containers Plug and unplug operations with PDBs and application containers Comparing Local Undo Mode and Shared Undo Mode MANAGE SECURITY IN MULTITENANT DATABASES * Manage Security in Multitenant databases Manage PDB lockdown profiles Audit Users in CDBs and PDBs Manage other types of policies in application containers RECOVERY AND FLASHBACK * Restore and Recovering Databases with RMAN Perform CDB and PDB flashback CONFIGURING AND USING RMAN * Configure RMAN and the Database for Recoverability Configure and Using an RMAN recovery catalog DIAGNOSING FAILURES * Detect and repair database and database block corruption Diagnosing Database Issues PERFORMING RECOVERY * Restore and Recovering Databases with RMAN Perform Non RMAN database recovery TRANSPORTING DATA * Transport Data RMAN TROUBLESHOOTING AND TUNING * Interpret the RMAN message output Diagnose RMAN performance issues CREATING AN ORACLE DATABASE BY USING DBCA * Create, Delete and Configure Databases using DBCA ORACLE RESTART * Configure and use Oracle Restart to manage components UPGRADE THE ORACLE DATABASE * Plan for Upgrading an Oracle Database Upgrade an Oracle Database Perform Post-Upgrade tasks INSTALL GRID INFRASTRUCTURE FOR A STANDALONE SERVER * Rapid Home Provisioning USING AVAILABILITY ENHANCEMENTS * Use an RMAN recovery catalog Use Flashback Database TUNING SQL STATEMENTS * Understanding the Oracle Optimizer Using the SQL Tuning Advisor Managing Optimizer Statistics Using the SQL Access Advisor Understanding the SQL Tuning Process ADDITIONAL COURSE DETAILS: Nexus Humans Oracle 19c Database Administration II (DBA II) (TTOR20619) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle 19c Database Administration II (DBA II) (TTOR20619) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for Data Warehouse Administrator, Database Administrator, Database Designer, Support Engineer, and Technical Administrator. Overview Upon successful completion of this course, students will be able to Install Oracle Grid Infrastructure for a Standalone Server, Configure ASMLIB and create ASM disk groups, Apply the latest patch set updates to the Grid Infrastructure software, Install Oracle Database software, Use Oracle Restart to manage components, Prepare the Linux operating system for Oracle software installation, Upgrade Oracle Database, Create a container database, Install Oracle Grid Infrastructure for an Independent Server, Create an Oracle Database using DBCA, and Install the latest patch set updates to the Oracle database software. This Oracle Database: Deploy, Patch and Upgrade Workshop gives you detailed information to help you install Oracle Database software. In this course, you will be introduced to Oracle Database Cloud Service. ORACLE DATABASE OVERVIEW * Oracle Database Introduction * Oracle Database Architecture Overview * Oracle Database Instance Configurations * Oracle Database Memory Structures * Process Structures * Database Storage Architecture * Logical and Physical Database Structures * Container and Pluggable Database Overview INSTALLING ORACLE GRID INFRASTRUCTURE FOR A STANDALONE SERVER * Overview of Oracle Grid Infrastructure for a Standalone Server * System Requirements for Oracle Grid Infrastructure * Configuring Storage for Oracle Automatic Storage Management (ASM) * Installing Oracle Grid Infrastructure for a Standalone Server * Upgrading Oracle Grid Infrastructure for a Standalone Server INSTALLING ORACLE DATABASE SOFTWARE * Planning Your Installation * System Requirements for Oracle Database * Preparing the Operating System * Using 4 KB Sector Disks * Setting Environment Variables * Checking the System Requirements * Using the Oracle Universal Installer (OUI) * Performing a Silent Mode Installation CREATING AN ORACLE DATABASE BY USING DBCA * Planning the Database Storage Structure * Choosing non-CDB or CDB * Types of Databases (based on workload) * Choosing the Appropriate Character Set * Understanding How Character Sets are Used * Setting the NLS_LANG Initialization Parameter * Using the Database Configuration Assistant (DBCA) USING ORACLE RESTART * Oracle Restart Overview * Oracle Restart Process startup * Controlling Oracle Restart * Choosing the Correct SRVCTL Utility * Oracle Restart Configuration * Using the SRVCTL Utility * Obtaining Help for the SRVCTL Utility * Starting Components by Using the SRVCTL Utility INTRODUCTION TO UPGRADING TO ORACLE DATABASE * Upgrade Methods * Data Migration Methods * Supported Releases for Direct Upgrade * Overview of Upgrade Process * Performing a Rolling Upgrade * Upgrading a CBD PREPARING TO UPGRADE TO ORACLE DATABASE * Developing a Test Plan * Performance Testing * Requirements for Databases Using Oracle Label Security or Oracle Database Vault * Requirement for Databases Using Oracle Warehouse Builder * Using the Pre-Upgrade Information Tool * Backing Up the Database * Installing the Oracle Database Software * Preparing the New Oracle Home UPGRADING TO ORACLE DATABASE * Upgrading by Using the Database Upgrade Assistant (DBUA) * Manually Upgrading to Oracle Database * Migrating a non-CDB to a CDB PERFORMING POST-UPGRADE TASKS * Migrating to Unified Auditing * Performing Post-Upgrade Tasks Following a Manual Upgrade MIGRATING DATA BY USING ORACLE DATA PUMP * Data Pump Overview * Migrating by Using Data Pump * Importing by Using a Network Link

Duration 5 Days 30 CPD hours This course is intended for This course is for all Oracle Professionals. Specifically Database Administrators, Web Server Administrators, System Administrators, CIOs and other IT Management Professionals. Overview Upon successful completion of this course, students will be able to understand configuration for installation, configuration of a host system, using Oracle Restart framework, troubleshooting tips, how the database fits with other systems, internals of the database, database failures and other topics. In this course, students will focus on configuration on supported systems. Also how the database fits in with other systems. ORACLE DATABASE ARCHITERCTURE OVERVIEW * The Database Instance * Database Memory Structures * Database Process Structures * Database Storage Architecture * Oracle Clusterware CONFIGURING THE HOST FOR STANDALONE INSTALLLATION * Host Configuration Overview * Choosing a Database Host * Choosing an Operating System * Proprietary Unix vs Open-Source Linux * Making the OS Selection * Prepare an Oracle LINUX Installation * Perform Oracle LINUX Installation * Configure the LINUX Host * Step 1 - Confirm General System Requirements * Step 2 - Confirm The Operating System Platform * Step 3 - Confirm LINUX Package Requirements * Step 4 - Confirm Network Configuration * Configure Host for Virtualization * VM Technologies * Configure Oracle Linux for Virtualization * Step 1 - Download Linux Updates * Step 2 - Check Linux Kernel * Step 3 - Download Latest yum Configuration File * Step 4 - Enable Oracle Linux Add-ons * Step 5 - Install VirtualBox * Oracle Optimal Flexible Architecture * OFA Goals * ORACLE_BASE * ORACLE_HOME * Database Files * Multiple ORACLE_HOMEs * Databse Software Upgrades * Mutliple Oracle Software Installations GRID INFRASTRUCTURE CONFIGURATION * Configure the Linux Installation * About ASM Devices * Configure Linux Devices for ASM * Partioning a Device * Oracle ASMLib * Configue MS Windows Devices GRID INFRASTRUCTURE INSTALLATION * Perform the Installation * Download * Unpack the Installation Package * Launch the Installation Session * The Installation Dialog * Verify the Installation * Operating System Confirmation * Oracle Utilities Setup * SQL*Plus Confirmation * Using EM Cloud Control * Troubleshooting Problems DATABASE INSTALLATION CONFIGURAION * Configure a Linux Installation * System Groups & Users * Configure Kernel Parameters * Create the Physical Directories * Configure MS Windows Installation * Prerequisite Checks & Fixup Utility DATABASE INSTALLATION * ABOUT THE INSTALLATION * The Installation Tools * About The Installation Dialog * The Installation Session Log * PERFORM INSTALLATION ON LINUX * Download * Unpack The Installation Files * Set Environment Variables * Launch The Installation * SERVER CLASS INSTALLATION DIALOG * More About The Global Database Name * About Enterprise Manager Cloud Control * Secure The New Database * PERFORM INSTALLATION ON WINDOWS * Launch The Installation * POST---INSTALLATION CONFIGURATION * Required Environment Variables * Defining The Environment Variables * About SSH * VERIFY THE INSTALLATION * SQL*PlusConfirmation * Operating System Confirmation * Firewall Configuration * Accessing EM Database Express CREATING DATABSES USING DBCA * About DBCA * DBCA Templates * Are You Sure? * DEFAULT CONFIGURATION DATABASE * ADVANCED MODE DATABASE * File Location Variables * Database Vault and Label Security * CONFIGURE AN EXISTING DATABASE * DELETE A DATABASE * MANAGE TEMPLATES * MANUALLY CREATE A DATABASE * The CREATE DATABASE Command USING ORACLE RESTART * WHAT IS ORACLE RESTART? * What Oracle Restart Does * Is Oracle Restart Deprecated? * Registering With Oracle Restart * More About srvctl * Terminal Session Configuration * COMPONENT STATUS USING SRVCTL * Database Status * Grid Infrastructure Status * Oracle Home Status * CONFIGURATION USING SRVCTL * Examining A Database Configuration * Examining The Listener Configuration * Examining The ASM Configuration * Manual Registration * ListenerConfiguration Modification * Database ConfigurationModification * STARTUP/SHUTDOWN USING SRVCTL * Why Use srvctl? * MANAGING ORACLE RESTART * Obtaining Oracle Restart Status * Start/Stop Oracle Restart PREPARING FOR A DATABASE UPGRADE * What is a Database Upgrade? * Database Upgrade Methods * Real World Database Upgrade * Develop A Database Upgrade Plan * ABOUT THE DATABASE VERSION * Direct Upgrade * The COMPATIBLE Database Parameter * PRE-UPGRADE PREPARATIONS * Oracle Warehouse Builder * Oracle Label Security (OLS) * Oracle Database Vault * Locating The Older Database Installations * THE PRE-UPGRADE INFORMATION TOOL * Pre-Upgrade Information Tool Files * Run The Pre---Upgrade Information Tool * Examining The Pre---Upgrade Information Tool Results UPGRADE TO ORACLE DATABSE 12C * Launch DBUA * Database Upgrade Dialog POST-UPGRADE TASKS * Post-Upgrade Checklist * Enable Unified Auditing * Migrate to Unified Auditing * Database Parameter Changes * Enable New Features * Source Destination Specific Post-Upgrade Tasks ORACLE ARCHITECTURE: THE SYSTEMS INFRASTRUCTURE * About Enterprise Architectures * The Relational Database * Legacy Computing Models * The Multi-Tiered Computing Model * Scaling Up * Cloud-Based Deployment * ORACLE INFRASTRUCTURE ECOSYSTEM * USING ORACLE ENTERPRISE MANAGER * More About EM * Using EM Database Express * Using EM Cloud Control ORACLE ARCHITECTURE: THE DATABASE HOST * The Database Server Stack * PROCESSOR LAYER * CPU Resources * Memory Resources * I/O & STORAGE PROCESSING * OS LAYER PROCESSING MODES * DATABASE SERVER VIRTUALIZATION * STORAGE VIRTUALIZATION * ORACLE DATABASE SERVER STACK * ORACLE ENGINEERED SYSTEMS * Oracle Exadata Database Platform * Exalogic Cloud Machine * Exalytics BI Machine ORACLE ARCHITECTURE: PRINCILPLES & TECHNOLOGY CONCEPTS * Grid Computing Principles * Why Grid Computing? * What Is Grid Computing? * PARALLELIZATION PRINCIPLES * Hardware Parallelization * Grid Computing Devices * Clustered Database Servers * CLOUD COMPUTING PRINCIPLES * Multi-Tenancy ORACLE ARCHITECTURE: THE RDBMS INSTALLATION & THE DATABASE INSTANCE * The Database Server Software * Database Versions & Releases * Database Editions * Using PRODUCT_COMPONENT_VERSION View * The Core Database Components * Using V$VERSION View * Understanding The Database Version Number * The COMPATIBLE Database Parameter * DATABASE INSTANCE ELEMENTS * Individual Elements Of A Database Instance * Physical Database Elements * An Operational Database installation * DATABASE INSTANCE CONFIGURATIONS * Single Instance * Parameter Files & Instance Configuration * MAX_STRING_SIZE Parameter Example * Independent Instances * Clustered Instances * The Database Instance In A Multi-tenant Configuration * RECONFIGURING A DATABASE INSTANCE * Static Vs. Dynamic Parameters * Dynamic Parameter Setting * Parameter Setting Scope * Parameter Setting Level * Setting Upgrade Related Parameters * DATABASE COMPONENTS * Advanced Data Functionality Components * Security Components * High-Performance Components * Administration Components * Database F

Duration 5 Days 30 CPD hours This course is intended for This hands-on course is geared for experienced DBAs new to Oracle 19c, who can work in Linux and have basic experience with SQL scripting. Overview This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our Oracle Certified expert facilitator, students will learn how to: How to use tools to access an Oracle Database Generate database creation scripts by using DBCA How to create a container database (CDB) by using the CREATE DATABASE command Learn about Startup and shut down Oracle databases Initialization parameter files and initialization parameters Tools that are used to administer Oracle Net Services How to use the Oracle Connection Manager Control utility to administer Oracle Connection Manager How to create a new PDB from the PDB seed. Logical and physical storage structures in an Oracle database Usage of Oracle Database features that save space Explanation of DML and undo data generation Learn about general architecture of Oracle Data Pump and SQL*Loader How to use SQL*Loader to load data from a non-Oracle database (or user files) Bonus Content / Time Permitting: Explanation of maintenance windows Bonus Content / Time Permitting: Employ basic monitoring procedures and manage performance Oracle 19C Database Administration I (Oracle DBA I) is a comprehensive, hands-on course provides concrete information on the design of an Oracle Database instance and database, allowing you to manage your database investment. In this class, you will learn how to create database storage structures that align with your requirements and business models. You will also learn how to create users and administer databases as well as harden the databases to meet your business requirements. This is the foundational course for learning about Oracle Database and it does not assume prior knowledge or Oracle technologies, however you should have incoming experience working with SQL, and be comfortable with Linux and working from the command line. This training is NOT Official Oracle University training. This is independent, adjustable content that aligns with current topics, skills and tools that participants need to excel in these areas. INTRODUCTION TO ORACLE DATABASE * Oracle Multitenant Container Database * Oracle Database Instance Configurations * Database Sharding * Oracle Database Server ACCESSING AN ORACLE DATABASE * Oracle Database Tools * Database Tool Choices * SQL Developer * Enterprise Manager Database Express CREATING AN ORACLE DATABASE BY USING DBCA * Planning the Database * Choosing a Database Template * Configuration Assistant CREATING AN ORACLE DATABASE BY USING A SQL COMMAND * Creating a Container Database * Enable Pluggable Database STARTING UP AND SHUTTING DOWN A DATABASE INSTANCE * Starting the Oracle Database Instance * Shutting Down an Oracle Database Instance * Opening and Closing PDBs MANAGING DATABASE INSTANCES * Investigating Initialization Parameter Files * Viewing Initialization Parameters by Using SQL*Plus * Modifying Initialization Parameters by Using SQL*Plus * Viewing Diagnostic Information ORACLE NET SERVICES OVERVIEW * Oracle Net Services Components * Oracle Net Listener CONFIGURING NAMING METHODS * Configuring the Oracle Network to Access a Database * Creating a Net Service Name for a PDB CONFIGURING AND ADMINISTERING THE LISTENER * Exploring the Default Listener * Creating a Second Listener * Connecting to a Database Service Using the New Listener CONFIGURING A SHARED SERVER ARCHITECTURE * Configuring Shared Server Mode Configuring Clients to Use a Shared Server CONFIGURING ORACLE CONNECTION MANAGER FOR MULTIPLEXING AND ACCESS CONTROL * Oracle Connection Manager Processes * Filtering Rules * Session Multiplexing CREATING PDBS * Creating a New PDB from the PDB Seed * Cloning Remote PDBs in Hot Mode * Relocating PDBs MANAGING PDBS * Renaming a PDB * Setting Parameter Values for PDBs DATABASE STORAGE OVERVIEW * Logical and Physical Database Structures * Tablespaces and Data Files * Types of Segments * Monitoring Tablespace Space Usage CREATING AND MANAGING TABLESPACES * Viewing Tablespace Information * Creating a Tablespace * Managing Temporary and Permanent Tablespaces IMPROVING SPACE USAGE * Managing Space in Tablespaces * Using Compression * Enabling the Resumable Space Allocation Feature CREATING AND MANAGING USER ACCOUNTS * Creating Common and Local Users * Creating a Local User for an Application * Exploring OS and Password File Authentication CONFIGURING PRIVILEGE AND ROLE AUTHORIZATION * Granting a Local Role (DBA) to PDBADMIN * Using SQL*Developer to Create Local Roles CONFIGURING USER RESOURCE LIMITS * Using SQL*Developer to Create a Local Profile & Users * Configuring a Default Role for a User IMPLEMENTING ORACLE DATABASE AUDITING * Enabling Unified Auditing * Creating Audit Users * Creating an Audit Policy INTRODUCTION TO LOADING AND TRANSPORTING DATA * General Architecture * Oracle Data Pump * SQL Loader * Loading Data into a PDB from an External File * Moving Data from One PDB to Another PDB * Transporting a Tablespace USING EXTERNAL TABLES TO LOAD AND TRANSPORT DATA * Querying External Tables * Unloading External Tables AUTOMATED MAINTENANCE TASKS OVERVIEW * Automated Maintenance Tasks * Maintenance Windows * Predefined Maintenance Windows BONUS: MANAGING TASKS AND WINDOWS * Enabling and Disabling Automated Maintenance Tasks * Modifying the Duration of a Maintenance Window BONUS: DATABASE MONITORING AND PERFORMANCE TUNING OVERVIEW * Performance Planning Considerations * Automatic Workload Repository (AWR) * Advisory Framework BONUS: MONITORING DATABASE PERFORMANCE & PROCESSES * Server-Generated Alerts * Setting Metric Thresholds * Performance Monitoring * Examining the Database Background Processes BONUS: TUNING DATABASE MEMORY * Viewing Memory Configurations BONUS: ANALYZING SQL AND OPTIMIZING ACCESS PATHS * Using the Optimizer Statistics Advisor

Ideal for children! Kids in these classes benefit from personalised learning and overcome their fear of speaking Greek in front of others -and not only their teacher- from their very first lessons!

This is a customised private course designed to suit your field of specialisation. The duration of this course depends exclusively on your schedule. Just inform us about when you wish to start and we will plan each lesson according to your needs. You can sign up for this course regardless of your level of Greek, as it is offered not only to beginners but also to intermediate and advanced learners. The course is supported by readers, work books, audios and videos.

Τhis is a customised course offered only to advanced adult learners who speak and write Greek in an advanced or proficient level. The course is supported by readers, newspaper articles, audio and video files.

Developing a solid foundation in Greek grammar will help you create your own sentences correctly and will also make it easier to improve your communication skills in both spoken and written Greek. So this course has been designed to help you steadily advance with the Greek language. Here, on the Greek Online School Learning Management System (LMS) you will find all the grammar phenomena that you need to know for the A2 Level (basic knowledge) in Greek, the language that influenced all European languages.

Develop your pronunciation and fluency in speaking. Enrich your vocabulary. Become confident speakers in everyday life. Communicate effectively and interact socially in formal situations. Deal with situations when you travel to places where the language is spoken.