58 Oracle Database courses

Duration 5 Days 30 CPD hours This course is intended for Application DevelopersBusiness AnalystsBusiness Intelligence DeveloperData ModelersData Warehouse AdministratorData Warehouse AnalystReports DeveloperTechnical Consultant Overview Build and run analyses to test and validate a repositorySet up query logging for testing and debuggingSet up a multiuser development environmentUse the Administration Tool wizards and utilities to manage, maintain, and enhance repositoriesEnable usage tracking to track queries and database usage, and improve query performancePerform a patch merge in a development-to-production scenarioDescribe Exalytics machine and the Summary Advisor tool used in the machineBuild simple and calculated measures for a fact tableCreate logical dimension hierarchies and level-based measuresCheck the model and then model aggregate tables to speed query processingModel partitions and fragments to improve application performance and usabilityUse variables to streamline administrative tasks and modify metadata content dynamicallyUse time series functions to support historical time comparison analysesSet up security to authenticate users and assign appropriate permissions and privilegesBuild the Physical, Business Model and Mapping, and Presentation layers of a repositoryApply cache management techniques to maintain and enhance query performance This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository. This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository. ADDITIONAL COURSE DETAILS: Nexus Humans Oracle BI 11g R1 - Build Repositories 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 BI 11g R1 - Build Repositories 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 3 Days 18 CPD hours Overview Our engaging instructors and mentors are highly-experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will explore: New Features Overview Multitenant New Features Security Features Cloud Services Networking Globalization Big Data Support Database Installation and Configuration Database Tuning Backup and Recovery Oracle 19c New Features is a hands-on course that explores the newest features such as Big Data Enhancements, Security, Multitenant features, Oracle Cloud Services, Networking, and much more. Oracle is one of the leading databases in industry today. Learn what their latest flagship product has to offer from industry experts. ORACLE 19C NEW FEATURES OVERVIEW * Introduction to Oracle 19c New Features ORACLE 19C MULTITENANT NEW FEATURES * Refreshable PDB Switchover * PDB Integration with Data Guard * PDB Snapshot Carousel * CDB Fleet Management ORACLE 19C SECURITY FEATURES * Profile Lockdown * Create a User Defined Master Encryption Key * Encrypted Passwords in Database Links and Data Pump * Create Keystores for Pluggable Databases * Datapump and Unified Auditing * Schema Only Accounts ORACLE 19C CLOUD SERVICES * Oracle IaaS * Oracle Saas * Oracle PaaS ORACLE 19C NETWORKING * Database Connection Manager * Database Proxy Support * Tenant Isolation ORACLE 19C GLOBALIZATION * New globalization for Bind Variables * New Database Local Support * Additional Unicode Support BIG DATA SUPPORT * New Analytic Support * Data Mining Data Warehouse * Additional Parallel Processing Support * Inline External Tables DATABASE INSTALLATION AND CONFIGURATION * Zero Downtime Upgrades * Dry Run Command implementation * New location for Password File * Improved Bulk Operations DATABASE TUNING * SQL Tuning Advisor and Exadata * New SQL Tuning Set API * Concurrent SQL and Sql Performance Analyzer * Database In Memory Features * In Memory Support for External Tables * In Memory Features for Analytics ORACLE 19C BACKUP AND RECOVERY * Active Pluggable Cloning * Pluggable and non Pluggable Database Migration ADDITIONAL COURSE DETAILS: Nexus Humans Oracle 19c New Features (TTOR20019) 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 New Features (TTOR20019) 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 4 Days 24 CPD hours This course is intended for This is an intermediate course for experienced DBAs and technical individuals, with experience on other relational database platforms, who plan, implement, and maintain Db2 11.1 for Linux, UNIX, and Windows databases. These skills can also be utilize to support cloud based databases using Db2 on Cloud or Db2 Hosted environments. Overview Please refer to course overview This course teaches you to perform, basic and advanced, database administrative tasks using Db2 11.1. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. The access strategies selected by the Db2 Optimizer will be examined using the Db2 Explain tools. Various diagnostic methods will be presented, including using various db2pd command options. Students will learn how to implement automatic archival for database logs and how to plan a redirected database restore to relocate either selected table spaces or an entire database. The REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces, will be discussed. We will also cover using the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases. The selection of indexes to improve application performance and the use of SQL statements to track database performance and health will be covered. This course provides a quick start to Db2 database administration skills for experienced relational Database Administrators (DBA). OVERVIEW OF DB2 11 COMMAND LINE PROCESSOR (CLP) AND GUI USAGE THE DB2 ENVIRONMENT CREATING DATABASES AND DATA PLACEMENT CREATING DATABASE OBJECTS MOVING DATA BACKUP AND RECOVERY LOCKS AND CONCURRENCY DATABASE MAINTENANCE, MONITORING AND PROBLEM DETERMINATION SECURITY DATABASE REBUILD SUPPORT DB2 DATABASE AND TABLE SPACE RELOCATION USING EXPLAIN TOOLS USING INDEXES FOR PERFORMANCE ADVANCED MONITORING

This course will teach you how Selenium WebDriver is used to test web applications. You will start by understanding the concepts of Java and gradually move toward understanding Selenium, TestNG framework, Maven, Jenkins, Cucumber, Gherkin, and a lot more interesting topics that will make you a pro in automation testing.

Duration 4 Days 24 CPD hours This course is intended for This is an intermediate level course for students that will perform Database Administration tasks, who plan, implement, and maintain D22 11.1 databases. Overview These skills can be developed by taking: DB2 SQL Workshop DB2 Fundamentals This course teaches database administrators to perform basic database administrative tasks using Db2 11.1. These tasks include creating database objects like tables, indexes and views, and loading data into the database with Db2 utilities like LOAD and INGEST. Various diagnostic methods will be presented, including using db2pd command options, and monitoring with SQL statements that reference Db2 monitor functions. Students will learn how to implement automatic archival for database logs and how to recover a database to a specific point in time using the archived logs. The course covers using EXPLAIN tools to review the access plans for SQL statements and adding indexes to improve SQL performance. We will cover the locking performed by Db2 and the effect the application isolation level has on locking and lock wait conditions. Students will learn how to implement database security, including adding a security administrator, SECADM user, and implement database roles to simplify security management. We will also describe implementing Db2 native encryption for a database. OVERVIEW OF DB2 11.1 DB2 COMMAND LINE PROCESSOR (CLP) AND GUI TOOLS THE DB2 DATABASE MANAGER INSTANCE CREATING DATABASES AND DATA PLACEMENT CREATING DATABASE OBJECTS MOVING DATA BACKUP AND RECOVERY DATABASE MAINTENANCE, MONITORING AND PROBLEM DETERMINATION LOCKING AND CONCURRENCY SECURITY

Duration 3 Days 18 CPD hours This course is intended for The ideal audience for this course includes database enthusiasts, IT professionals, and developers who are eager to expand their knowledge and skill set in database management and optimization. Roles that would greatly benefit from attending this course include: Database Developers: Those who design, implement, and maintain databases as part of their primary responsibilities and want to improve their expertise in schema design, query optimization, and advanced database features. Backend Developers: Professionals who work on server-side application logic and require a strong understanding of database management to integrate data storage and retrieval processes into their applications. Overview Upon completing this course, database developers will be able to: Design and implement efficient database schemas by employing normalization techniques, appropriate indexing strategies, and partitioning methods to optimize data storage and retrieval processes. Develop advanced SQL queries, including joining multiple tables, utilizing subqueries, and aggregating data, to extract valuable insights and facilitate decision-making processes. Implement stored procedures, functions, and triggers to automate common database tasks, enforce data integrity, and improve overall application performance. Apply database performance tuning techniques, such as query optimization, index management, and transaction control, to ensure optimal resource usage and enhanced system responsiveness. Integrate databases with various programming languages and platforms, enabling seamless data access and manipulation for web, mobile, and desktop applications. PostgreSQL is a powerful, open-source object-relational database management system that emphasizes extensibility, data integrity, and high performance. Its versatility and robust feature set make it an ideal choice for developers working on projects of all sizes, from small-scale applications to enterprise-level systems. By learning PostgreSQL, developers can tap into its advanced capabilities, such as full-text search, spatial data support, and customizable data types, allowing them to create efficient and scalable solutions tailored to their unique needs. PostgreSQL for Database Developers is a three-day hands-on course that explores the fundamentals of database management, covering everything from installation and management to advanced SQL functions. Designed for beginners and enthusiasts alike, this course will equip you with the knowledge and skills required to effectively harness the power of PostgreSQL in today's data-driven landscape. Throughout the course you?ll be immersed in a variety of essential topics, such as understanding data types, creating and managing indexes, working with array values, and optimizing queries for improved performance. You?ll gain valuable hands-on experience with real-world exercises, including the use of the psql client, writing triggers and stored procedures with PL/pgSQL, and exploring advanced SQL functions like Common Table Expressions (CTE), Window Functions, and Recursive Queries. You?ll exit this course with a solid foundation in PostgreSQL, enabling you to confidently navigate and manage your databases with ease and efficiency. INSTALLING & MANAGING POSTGRESQL * PostgreSQL installation process * Optimal configuration settings * User and role management * Database backup and restoration OVERVIEW OF POSTGRESQL DATABASE * PostgreSQL architecture overview * Understanding database objects * Efficient data storage * Transaction management basics USING THE PSQL CLIENT * Introduction to psql * Essential psql commands * Executing queries effectively * Managing databases with psql UNDERSTANDING POSTGRESQL DATA TYPES * Numeric data types explored * Character and binary types * Date, time, and boolean values * Array and other types UNDERSTANDING SEQUENCES * Sequence creation and usage * Customizing sequence behavior * Implementing auto-increment columns * Sequence manipulation and control CREATING & MANAGING INDEXES * PostgreSQL index fundamentals * Designing partial indexes * Utilizing expression-based indexes * Index management techniques USING COPY TO LOAD DATA * COPY command overview * Importing and exporting data * Handling CSV and binary formats * Performance considerations WORKING WITH ARRAY VALUES * Array value basics * Array manipulation functions * Querying arrays efficiently * Multidimensional array handling ADVANCED SQL FUNCTIONS * Mastering Common Table Expressions * Utilizing Window Functions * Regular Expressions in SQL * Crafting Recursive Queries WRITING TRIGGERS & STORED PROCEDURES WITH PL/PGSQL * PL/pgSQL variables usage * Implementing loop operations * PERFORM and EXECUTE statements * Developing PostgreSQL triggers USING THE POSTGRESQL QUERY OPTIMIZER * Query analysis and optimization * EXPLAIN command insights * PostgreSQL query operators * Identifying performance bottlenecks IMPROVING QUERY PERFORMANCE * Query performance tuning * Index optimization strategies * Efficient database partitioning * Connection and resource management WRAP UP & ADDITIONAL RESOURCES * Further learning opportunities * Staying up-to-date with PostgreSQL * Community engagement and support ADDITIONAL COURSE DETAILS: Nexus Humans PostgreSQL for Database Developers (TTDB7024) 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 PostgreSQL for Database Developers (TTDB7024) 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 Application Developers Business Analysts Developer End Users Functional Implementer Java Developer System Analysts Technical Administrator Overview Create administrator-level personalizations Personalize configurable pages Utilize advanced personalization features Implement flexfields on OA Framework-based pages Create custom look and feel definitions Create user-level personalizations This course will be applicable for customers who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1. This course will be applicable for customers who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1.

Duration 5 Days 30 CPD hours This course is intended for The course provides an intensive hands-on experience for key system administration tasks with the goal of making the system administrator job-ready. Overview Administer the Oracle Solaris 11 Host on an Existing Network Administer Oracle Solaris Zones Control Access to Systems and Files Install Oracle Solaris 11 Operating System Administer User Accounts Administer System Processes and Schedule System Tasks Manage Data by Using ZFS Manage Boot and Shutdown of a System Administer Services by Using SMF Administer Software Packages by Using IPS and Manage Boot Environments Describe the use of IPS in packaging the Oracle Solaris OS Manage boot environments Updating the OS by using IPS The Oracle Solaris 11 System Administration training covers the full range of introductory system administration tasks on Oracle Solaris 11.3 OS. The topics covered range from installing the operating system on a single system, to monitoring and basic troubleshooting. The Oracle Solaris 11 System Administration course is designed to provide new system administrators, as well as enterprise system administrators who are new to the Oracle Solaris 11 Operating System, with the skills they need to perform their job tasks successfully and efficiently. INSTALLING ORACLE SOLARIS 11 OPERATING SYSTEM * Introduction to Oracle Solaris 11 OS * Planning for Oracle Solaris 11 OS installation * Installing Oracle Solaris 11 OS by Using the Live Media Installer * Installing Oracle Solaris 11 OS Using the Text Installer * Verifying the OS Installation MANAGING BOOT AND SHUTDOWN OF SYSTEMS * Analyze the boot design and boot process * Boot a SPARC-based system * Boot an x86-based system * Shut down a system ADMINISTERING SERVICES BY USING SMF * Describing SMF and its components * Administering SMF Services ADMINISTERING SOFTWARE PACKAGES BY USING IPS AND MANAGING BOOT ENVIRONMENTS * Describing IPS, its components, and interfaces * Configuring an IPS Client to Access the Local IPS Repository * Managing Package Publishers * Managing Software Packages * Managing Signed Packages and Package Properties * Describe the use of IPS in packaging the Oracle Solaris OS * Manage boot environments * Updating the OS by using IPS MANAGING DATA BY USING ZFS * Introducing ZFS * Administering ZFS Storage Pools * Administering ZFS File Systems * Administering ZFS Properties * Administering ZFS Snapshots and Clones ADMINISTERING THE NETWORK * Reviewing Networking Fundamentals * Administering Datalink Configuration * Administering a Network Interface * Administering Profile-Based Network Configuration * Configuring a Virtual Network * Verifying the Network Operations * Managing Resources on the Virtual Network ADMINISTERING ORACLE SOLARIS ZONES * Introducing Oracle Solaris Zones * Configuring an Oracle Solaris Zone * Determining an Oracle Solaris Zone Configuration CONTROLLING ACCESS TO SYSTEMS AND FILES * Controlling Access to Systems * Controlling Access to Files * Securing Access to Remote Host ADMINISTERING USER ACCOUNTS * Getting Started with the User Administration * Setting Up User Accounts * Maintaining User Accounts * Configuring User Disk Quotas MANAGING SYSTEM PROCESSES AND SYSTEM TASKS * Managing System Processes * Scheduling System Administration Tasks