107 AWS Certified Database courses

Duration 3 Days 18 CPD hours This course is intended for This course is intended for Solution Architects Overview At the end of this course, you will be able to: Apply the AWS Well-Architected Framework Manage multiple AWS accounts for your organization Connect an on-premises datacenter to AWS cloud Move large data from an on-premises datacenter to AWS Design large datastores for AWS cloud Understand different architectural designs for scalability Protect your infrastructure from DDoS attack Secure your data on AWS with encryption Enhance the performance of your solutions Select the most appropriate AWS deployment mechanism Building on concepts introduced in Architecting on AWS, Advanced Architecting on AWS is intended for individuals who are experienced with designing scalable and elastic applications on the AWS platform. Building on concepts introduced in Architecting on AWS, this course covers how to build complex solutions which incorporate data services, governance, and security on AWS. This course introduces specialized AWS services, including AWS Direct Connect and AWS Storage Gateway to support Hybrid architecture. It also covers designing best practices for building scalable, elastic, secure, and highly available applications on AWS. MODULE 1: AWS ACCOUNT MANAGEMENT * Multiple accounts * Multi-account patterns * License management * Manage security and costs with multiple accounts * AWS Organizations * AWS Directory Service * Hands-on lab: Multi-VPC connectivity using a VPN MODULE 2: ADVANCED NETWORK ARCHITECTURES * Improve VPC network connections * Enhance performance for HPC workloads * VPN connections over AWS * AWS Direct Connect * AWS Transit Gateway * Amazon Route 53 * Exercise: Design a hybrid architecture MODULE 3: DEPLOYMENT MANAGEMENT ON AWS * Application lifecycle management * Application deployment using containers * AWS Elastic Beanstalk * AWS OpsWorks * AWS CloudFormation MODULE 4: DATA * Optimize Amazon S3 storage * Amazon ElastiCache * AWS Snowball * AWS Storage Gateway * AWS DataSync * Backup and archival considerations * Database migration * Designing for big data with Amazon DynamoDB * Hands-on lab: Build a failover solution with Amazon Route 53 and Amazon RDS MODULE 5: DESIGNING FOR LARGE SCALE APPLICATIONS * AWS Auto Scaling * Migrating over-provisioned resources * Blue-green deployments on AWS * Hands-on lab: Blue-green deployment with AWS MODULE 6: BUILDING RESILIENT ARCHITECTURES * DDoS attack overview * AWS Shield * AWS WAF * Amazon GuardDuty * High availability using Microsoft SQL Server and Microsoft SharePoint on AWS * High availability using MongoDB on Amazon EC2 * AWS Global Accelerator * Hands-on lab: CloudFront content delivery and automating AWS WAF rules MODULE 7: ENCRYPTION AND DATA SECURITY * Encryption primer * DIY key management in AWS * AWS Marketplace for encryption products * AWS Key Management Service (AWS KMS) * Cloud Hardware Security Module (HSM) * Comparison of key management options * Hands-on lab: AWS KMS with envelope encryption

Duration 4 Days 24 CPD hours This course is intended for Database Administrators Administrator Overview Describe the Oracle Clusterware architecture Describe how Grid Plug and Play affects Clusterware Describe the benefits of Oracle RAC Explain the necessity of global resources Describe global cache coordination Install the Oracle database software Create a cluster database Perform post-database-creation tasks Convert a single-instance Oracle database to RACs Explain the principles and purposes of clusters Define redo log files in a RAC environment Define undo tablespaces in a RAC environment Start and stop RAC databases and instances Modify initialization parameters in a RAC environment Configure the RAC database to use ARCHIVELOG mode and the fast recovery area Configure RMAN for the RAC environment This Oracle Database 12c: RAC Administration training will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion. This Oracle Database 12c: RAC Administration training will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion. ADDITIONAL COURSE DETAILS: Nexus Humans Oracle Database 12c - RAC Administration 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 Database 12c - RAC Administration 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 5 Days 30 CPD hours This course is intended for This beginning DB2 basic course is for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z/OS environment. Overview Describe several services provided in a z/OS environmentExplain workloads in the batch environmentExplain workloads in the online environmentDescribe job roles in a z/OS environmentLog On to TSO/ENavigate TSO/E and ISPFUse TSO commandsSetup and utilize JCL (Job Control Language)Utilize SDSFDescribe the different types of data sets in a z/OS environmentAllocate data sets and list data set information and contentCreate and modify data set contentGive an overview of the DB2 9 environmentDescribe and utilize DB2 ObjectsDescribe and utilize several DB2 UtilitiesDescribe the DB2I (DB2 Interactive Facility) environmentUse SPUFI (SQL Processing Using File Input) to compose and execute SQLSetup and execute DB2 CommandsUnderstand DB2 LoggingDescribe DB2 program preparation processUnderstand DB2 startup and shutdownUnderstand and utilize DB2 recovery strategies This course is intended for students looking to develop fundamental skills or recognition through lectures and hands-on exercises of TSO/E and ISPF, data sets, DB2 objects, Structured Query Language, DB2 commands, JCL and SDSF. DAY 1 * Welcome * Unit 1: Introduction * Unit 2: TSO/E and ISPF * Exercise 1: TSO and ISPF * Exercise 1 Review * Unit 3: Data Sets (Data Sets and Sequential Data Sets) * Exercise 2: Sequential Data Sets * Exercise 2 Review DAY 2 * Unit 3: Data Sets (Partitioned Data Sets) * Exercise 3: Partitioned Data Sets * Exercise 3 Review * Unit 3: Data Sets (VSAM Data Sets) * Exercise 4: VSAM Data Sets * Exercise 4 Review * Unit 4: JCL and SDSF * Exercise 5: JCL and SDSF * Exercise 5 Review DAY 3 * Unit 5: DB2 Relational Database Concepts * Unit 6: Structured Query Language (SQL) and SPUFI * Exercise 6: SQL and SPUFI * Exercise 6 Review * Unit 7: DB2 Objects (Databases and Table Spaces) * Exercise 7: Databases and Table Spaces * Exercise 7 Review * Unit 7: DB2 Objects (Tables, Indexes, and Views) * Exercise 8: Tables, Indexes, and Views * Exercise 8 Review DAY 4 * Unit 7: DB2 Objects (Qualified Names, Implicit Object Creation, and SQL Statements) * Exercise 9: Qualified Names, Implicit Object Creation, and SQL Statements * Exercise 9 Review * Unit 8: The DB2 System * Exercise 10: The DB2 System * Exercise 10 Review * Unit 9: DB2 Commands and Program Preparation * Exercise 11: DB2 Commands * Exercise 11 Review DAY 5 * Unit 10: DB2 Utilities * Exercise 12: DB2 Utilities * Exercise 12 Review * Unit 11: DB2 Shutdown, Startup, and Recovery * Exercise 13: DB2 Recovery * Exercise 13 Review * Unit 12: Course Summary ADDITIONAL COURSE DETAILS: Nexus Humans CV041 IBM z/OS and DB2 Basics for DB2 for z/OS DBA Beginners 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 CV041 IBM z/OS and DB2 Basics for DB2 for z/OS DBA Beginners 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 5 Days 30 CPD hours This course is intended for Database Administrators Data Warehouse Administrator Support Engineer Technical Consultant Technical Administrator Overview Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure. Describe the Oracle Database architecture components related to backup and recovery operations. Plan effective backup and recovery procedures. Configure the database for recoverability. Use Recovery Manager (RMAN) to create backups and perform recovery operations. Use the Data Recovery Advisor to diagnose and repair failures. Use Oracle Flashback Technologies to recover from human error. Perform an encrypted database backup and restore. Perform tablespace point-in-time recovery. Describe additional high availability features such as Oracle Data Guard. This Oracle Database 12c: Backup and Recovery Workshop will teach you how to evaluate your own recovery requirements. You'll develop appropriate strategies for backup, restore and recovery procedures from provided scenarios. This Oracle Database 12c: Backup and Recovery Workshop will teach you how to evaluate your own recovery requirements. You'll develop appropriate strategies for backup, restore and recovery procedures from provided scenarios. ADDITIONAL COURSE DETAILS: Nexus Humans Oracle Database 12c - Backup and Recovery Workshop 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 Database 12c - Backup and Recovery Workshop 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 4 Days 24 CPD hours This course is intended for This course is intended for Administrator, Architect, and Database Administrator Overview Upon successful completion of this course, students will be able to Manage PDB snapshots, Encrypt data in PDBs and isolate PDB keystore, Monitor performance in CDBs and PDBs, Audit users in CDB and PDBs, Protect data with Database Vault policies in CDB and PDBs, Manage a CDB fleet, and Manage resource allocation between PDBs and within a PDB. This Oracle Database: Managing Multitenant Architecture course covers all aspects of the multitenant architecture, providing detailed information on the components of an Oracle multitenant container database. CDB BASICS CDB AND REGULAR PDBS APPLICATION PDBS AND APPLICATION INSTALLATION PDB CREATION CDB AND PDB MANAGEMENT STORAGE SECURITY BACKUP AND DUPLICATE RECOVERY AND FLASHBACK PERFORMANCE MONITORING RESOURCES ALLOCATION DATA MOVEMENT UPGRADE METHODS ADDITIONAL COURSE DETAILS: Nexus Humans Oracle Database - Managing Multitenant Architecture 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 Database - Managing Multitenant Architecture 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 5 Days 30 CPD hours This course is intended for Oracle Database Administrator Data Warehouse Administrator Support Engineer Technical Consultant Technical Administrator Overview The student benefits by gaining a deeper understanding of possibly the most important job of a DBA - backup and recovery. The concepts and architecture that support backup and recovery, along with implementation steps in various ways and situations, are presented in detail. Students gain knowledge of the Recovery Manager (RMAN) command-line interface for various backup, failure, restore, and recovery scenarios, including data duplication. The student begins by gaining a deeper understanding of possibly the most important job of a DBA - backup and recovery. The concepts and architecture that support backup and recovery, along with implementation in various ways and situations are covered in detail. Students gain knowledge of the Recovery Manager (RMAN) command-line interface for various backup, failure, restore, and recovery scenarios, including data duplication. INTRODUCTION AND CONFIGURATION * Introduction Getting Started Configuring for Recoverablility Using the RMAN Recovery Catalog BACKUP * Backup Strategies and Terminology Performing Backups Improving Your Backups Using RMAN-Encrypted Backups RECOVERY * Diagnosing Failures Restore and Recovery Concepts Performing Complete Recovery Performing Point-in-Time Recovery Performing Additional Recovery Operations ADDITIONAL TECHNOLOGIES * Using Flashback Technologies Using Flashback Database Transporting Data Duplicating a Database RMAN Troubleshooting and Tuning HANDS-ON * Backup and Recovery Workshop ADDITIONAL COURSE DETAILS: Nexus Humans Oracle Database: Backup and Recovery Workshop 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 Database: Backup and Recovery Workshop 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 5 Days 30 CPD hours This course is intended for This course is intended for Administrator, Database Administrator, Security Specialist, and Systems Administrator. Overview Upon successful completion of this course, students will be able to Enumerate Oracle auditing solutions to monitor database security requirements, Implement Oracle Audit Vault and Database Firewall, Configure Oracle Audit Vault and Database Firewall, Explain Oracle Compliance Framework, and Configure basic Compliance Framework rules. In the Oracle Database Security: Detective Controls course, students learn how they can use Oracle Database administration auditing features to meet the compliance requirements of their organization. INTRODUCTION USING UNIFIED AUDIT USING FINE-GRAINED AUDIT INTRODUCTION TO ORACLE AUDIT VAULT AND DATABASE FIREWALL (AVDF) PLANNING THE ORACLE AUDIT VAULT AND DATABASE FIREWALL IMPLEMENTATION INSTALLING THE AUDIT VAULT SERVER CONFIGURING THE AUDIT VAULT SERVER CONFIGURING ORACLE AVDF AND DEPLOYING THE AUDIT VAULT AGENT NETWORKING AND ORACLE AVDF INSTALLING A DATABASE FIREWALL CONFIGURING ORACLE AVDF AND DEPLOYING DATABASE FIREWALL USING HOST MONITORING CONFIGURING HIGH AVAILABILITY CREATING CUSTOM COLLECTION PLUG-INS MANAGING THE AUDIT VAULT SERVER MANAGING THE DATABASE FIREWALLS OVERVIEW OF THE AUDITING AND REPORTING FEATURES PERFORMING ADMINISTRATIVE TASKS CREATING AUDIT POLICIES FOR ORACLE DATABASES CREATING DATABASE FIREWALL POLICIES ORACLE AVDF REPORTS MANAGING ENTITLEMENTS ADDITIONAL COURSE DETAILS: Nexus Humans Oracle Database Security - Detective Controls 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 Database Security - Detective Controls 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 5 Days 30 CPD hours This course is intended for Database DesignersSupport EngineerTechnical AdministratorDatabase AdministratorsData Warehouse Administrator Overview Use Oracle Restart to manage components.Upgrade database to Oracle Database 12c.Install Oracle Grid Infrastructure for a Standalone Server.Create a container database.Create an Oracle DatabaseInstall Oracle Database 12c software.Monitor the Database.Manage Database Performance.Implement Database Auditing.Configure the Database Instance Such That Resources Are Appropriately Allocated Among Sessions and Tasks.Schedule Jobs to Run Inside or Outside of the Database.Configure Oracle Net Services.Configure your Database For Backup and Recovery Operations.Describe Oracle Database Architecture.Manage the Oracle Database Instance.Manage Oracle Database Storage structures. This course will will teach you about the Oracle Database architecture and you will discover how to effectively manage an Oracle Database instance. You will also be provided key information on how to install and administer Oracle Database 12c. This course will will teach you about the Oracle Database architecture and you will discover how to effectively manage an Oracle Database instance. You will also be provided key information on how to install and administer Oracle Database 12c.

Duration 2 Days 12 CPD hours This course is intended for Oacle Database Administrators System Administrators Developers Overview Understand the concept, benefits, configuration, and usage of the new features and enhancements in database overall area Understand the concept, benefits, configuration, and usage of the new features and enhancements in the security area Understand the concept, benefits, configuration, and usage of the new features and enhancements in the availability area Understand the concept, benefits, configuration, and usage of the new features and enhancements in the performance area Understand the concept, benefits, configuration, and usage of the new features and enhancements in big data and data warehousing area Understand the concept, benefits, configuration, and usage of the new features and enhancements in diagnosability area Understand the concept, benefits, configuration, and usage of the new features and enhancements in sharding area The course provides the Oracle Database 19c new features and enhancements related to database overall, security, availability, performance, data warehousing, and diagnosability. In the lessons, you learn the new and enhanced features of Oracle Database 19c amongst different areas such as database overall, security, availability, performance, big data and warehousing, and diagnosability. USING GENERAL DATABASE OVERALL ENHANCEMENTS USING SECURITY ENHANCEMENTS USING AVAILABILITY ENHANCEMENTS USING PERFORMANCE ENHANCEMENTS USING BIG DATA AND DATA WAREHOUSING ENHANCEMENTS USING DIAGNOSABILITY ENHANCEMENTS SHARDING ENHANCEMENTS