60 Oracle 1Z0-819 courses

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 Administrator Developer System Integrator Systems Administrator Overview Install WebLogic Server 12c Deploy applications to WebLogic Server Deploy share libraries and application that use them to WebLogic Server Backup and restore a WebLogic Server domain Create a WebLogic Server domain Configure and monitor WebLogic Server Configure WebLogic Server database resources Create and configure a WebLogic Server cluster Configure WebLogic Server's authentication provider This Oracle WebLogic Server 12c: Administration I training teaches you how to perform the most important Oracle WebLogic Server 12c administrative tasks., and gives an overview of the architecture and concepts of Oracle WebLogic Server 12c. WEBLOGIC SERVER OVERVIEW INSTALLING AND PATCHING WEBLOGIC SERVER CREATING DOMAINS STARTING SERVERS USING THE ADMINISTRATION CONSOLE CONFIGURING JDBC MONITORING A DOMAIN NODE MANAGER DEPLOYING APPLICATIONS SHARED JAVA EE LIBRARIES NETWORK CHANNELS AND VIRTUAL HOSTS CLUSTERS: OVERVIEW, CREATE, & CONFIG CLUSTERS: PROXIES & SESSIONS CLUSTERS: COMMUNICATION, PLANNING & TROUBLESHOOTING TRANSACTIONS WEBLOGIC SERVER SECURITY BACKING UP A DOMAIN AND UPGRADING WEBLOGIC SERVER

The Oracle 11g PL/SQL Part 1 course will focus on giving you the best knowledge of coding and designing PL/SQL and SQL scripts. Initially, you'll learn how to start programming in Oracle PL/SQL. You'll understand the history of PL/SQL, installing Oracle Express Edition, connecting to Database, Relational Database, Oracle SQL in an easy-to-grasp method. This course includes mostly practical examples with explanations which makes it more valuable. Upon successful completion of this course, you can have the pleasure to code in PL/SQL which further help to boost your career. From beginners to expert learner can benefit from this course. So enrol today and see what else is in the Oracle 11g PL/SQL Part 1 course. WHAT WILL I LEARN? * Prepare your environment * Work with Oracle database tools * Understand and work with language features * Work with the DECLARE clause * Work with the BEGIN clause * Work with the EXCEPTION clause * Use explicit cursors * Understand and use nested blocks * Understand the difference between nested blocks and subprograms REQUIREMENTS * Familiarity with database and programming principles WHO IS THE TARGET AUDIENCE? * Application designers and developers * Database administrators * Business users and non-technical senior end users Introduction Introduction FREE 00:03:00 Preparing Your Environment Course Setup 00:37:00 Working with Oracle Database Tools Selecting the Appropriate Database Tool 00:31:00 Language Features Understanding PL/SQL 00:18:00 PL/SQL Blocks 00:15:00 Working with SQL Plus 00:11:00 The DECLARE Clause DECLARE Clause Objects 00:16:00 PL/SQL Available Data Types 00:17:00 Declaring Simple Data Types and Assignments 00:12:00 Declaring Complex Data Types and Assignments 00:11:00 Declaring Complex RowTypes and Assignments 00:07:00 Declaring Complex Tables 00:08:00 Declaring Complex Records 00:08:00 Creating and Declaring User-Defined Types 00:09:00 The BEGIN Clause What Can Be Included in the BEGIN Clause 00:07:00 Working with CHAR and VARCHAR2 Variables 00:08:00 Handling String Literals 00:08:00 Working with Numeric Variables 00:07:00 Working with Date Variables 00:06:00 Assigning and Using Boolean Variables 00:08:00 Using Comparison Operators 00:07:00 Using SQL Functions 00:06:00 SQL DML within PL/SQL 00:15:00 Using SELECT 00:07:00 Exceptions and Embedded SQL 00:11:00 Using Sequences 00:14:00 Logic Control and Branching 00:07:00 Using GOTO 00:06:00 Working with LOOPS 00:19:00 Creating and Using the Indefinite Loop 00:07:00 Creating and Using the Conditional Loop 00:08:00 Using Nested Loops 00:12:00 Using the If-Then-Else 00:19:00 Using the CASE Statement 00:18:00 The EXCEPTION Clause What Are the Types of Exceptions 00:06:00 Trapping Exceptions 00:06:00 Identify Exception Details 00:11:00 Creating User-Defined Exceptions 00:11:00 Using SQLCODE and SQLERRM Objects 00:09:00 Understand the Implicit Cursor 00:15:00 Creating User-Defined Events 00:12:00 Explicit Cursors Understanding the Concept and Purpose of Explicit Cursors 00:18:00 Learn about Cursor Attributes 00:10:00 Using the Continue Statement 00:06:00 Working with Updateable Cursors 00:19:00 Creating and Using Cursor Parameters 00:15:00 FOR...LOOP Cursors 00:07:00 Nested Blocks Understanding Nested Blocks 00:11:00 Difference between Global vs Local Objects and Exceptions 00:13:00 Declared Subprograms Subprograms: How They Differ from Nested Blocks 00:18:00 Conclusion Conclusion 00:04:00 Course Certification

This Oracle 11g PL/SQL Part 2 course will be very advantageous for you to learn about developing database server-side PL/SQL program units within an Oracle database. This course covers a variety of topics which include understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. In addition to that, you'll take the support of advanced programming techniques such as cursor variables and cursor expressions, which broadly discussed in the course. This course is ideal to prepare yourself for the Oracle certification exams (OCP). Upon successful completion of this course, you'll stand out from your competition while you're chasing your dream job! WHAT WILL I LEARN? * Prepare your environment * Introducing Database Program Units * Creating and Maintaining Stored Procedures & Functions * Creating and Maintaining Packages * Advanced Cursor Techniques * Using System-Supplied Packages * Creating and Maintaining Database Triggers * Implementing System Event Triggers REQUIREMENTS * Familiarity with database and programming principles WHO IS THE TARGET AUDIENCE? * Application designers and developers * Database administrators * Business users and non-technical senior end users Introduction Introduction 00:03:00 Install Oracle XE 00:11:00 SQL Developer Installation 00:00:00 Workstation Setup 00:12:00 Database Program Units Introducing the Database Program Unit 00:19:00 Working with Stored Procedures and Functions Creating Stored Procedures and Functions 00:19:00 Understanding the Parameter Specification 00:23:00 Executing Procedures and Functions 00:26:00 Calling Functions from within SQL 00:13:00 Handling Compilation Errors 00:08:00 Maintaining Stored Procedures and Functions Recompiling and Dropping Programs 00:16:00 Data Dictionary Storage 00:25:00 Managing Dependencies 00:13:00 Tracking Dependencies 00:08:00 Using the Dependency Tracking Utility 00:09:00 Creating and Maintaining Packages What Is a Package? 00:10:00 Creating a Package 00:19:00 Package Definition Information 00:08:00 Advanced Programming Techniques 00:06:00 Using Persistent Global Objects 00:04:00 Including Initialization Logic 00:15:00 Object Oriented Support within Packages 00:14:00 Package Maintenance 00:18:00 Advanced Cursor Techniques Learning to Use Cursor Variables 00:24:00 Advanced Cursor Techniques Weak Cursor Definitions 00:16:00 REFCURSOR Cursor Definition 00:05:00 Using Cursor Expression 00:14:00 Using System Supplied Packages Using the DBMS OUTPUT() Package 00:12:00 Using the UTL FILE() Package 00:30:00 Creating Database Triggers Understanding the Database Trigger 00:23:00 Statement-Level Triggers 00:23:00 Row-Level Triggers 00:12:00 Row Level Trigger Example 1 00:11:00 Row Level Trigger Example 2 00:07:00 Row Level Trigger Example 3 00:08:00 Working with the INSTEAD OF Trigger 00:11:00 Using Triggers within an Application 00:09:00 Trigger Maintenance Using the CALL Statement 00:09:00 Trigger Maintenance Tasks 00:12:00 Work with Multiple Triggers for a Single Table 00:11:00 Handling Mutating Table Issues 00:22:00 Using the Compound Trigger 00:06:00 Working with System Event Triggers What Is a System Event Trigger 00:05:00 Defining Scope 00:04:00 Identifying Available System Events 00:12:00 Conclusion Conclusion 00:02:00 Course Certification

Duration 5 Days 30 CPD hours This course is intended for Data Warehouse Administrator Database Administrators Support Engineer Technical Administrator Technical Consultant Overview Use Oracle Flashback Technologies to recover from human error Use Recovery Manager (RMAN) to create backups and perform recovery operations Use the Data Recovery Advisor to diagnose and repair failures Plan effective backup and recovery procedures Describe the Oracle Database architecture components related to backup and recovery operations Perform an encrypted database backup and restore Perform tablespace point-in-time recovery Configure the database for recoverability Describe Cloud Tooling for Backup and Recovery Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure In this Oracle Database 12c R2: Backup and Recovery Workshop, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course includes an interactive workshop, with scenarios that provide participants with opportunities to diagnose and recover from several failure situations. INTRODUCTION * Curriculum Context * Assess your recovery requirements * Categories of failures * Oracle backup and recovery solutions * Oracle Maximum Availability Architecture * Oracle Secure Backup * Benefits of using Oracle Data Guard * Basic Workshop Architecture GETTING STARTED * Core Concepts of the Oracle Database, critical for Backup and Recovery * Oracle DBA Tools for Backup and Recovery * Connecting to Oracle Recovery Manager (RMAN) CONFIGURING FOR RECOVERABLILITY * RMAN commands * Configuring and managing persistent settings * Using the Fast Recovery Area (FRA) * Control File * Redo Log File * Archiving Logs USING THE RMAN RECOVERY CATALOG * Creating and Configuring the Recovery Catalog * Managing Target Database Records in the Recovery Catalog * Using RMAN Stored Scripts * Maintaining and Protecting the Recovery Catalog * Virtual Private Catalogs BACKUP STRATEGIES AND TERMINOLOGY * Backup Solutions Overview and Terminology * Balancing Backup and Restore Requirements * Backing Up Read-Only Tablespaces * Data Warehouse Backup and Recovery: Best Practices * Additional Backup Terminology PERFORMING BACKUPS * RMAN Backup Types * Incrementally Updated Backups * Fast Incremental Backup * Block Change Tracking * Oracle-Suggested Backup * Reporting on Backups * Managing Backups IMPROVING YOUR BACKUPS * Compressing Backups * Using a Media Manager * Backup and Restore for Very Large Files * Creating RMAN Multi-section Backups, Proxy Copies, Duplexed Backup Sets and Backups of Backup Sets * Creating and Managing Archival Backups * Backing Up Recovery Files * Backing Up the Control File to a Trace File * Cataloging Additional Backup Files USING RMAN-ENCRYPTED BACKUPS * Creating RMAN-Encrypted Backups * Using Transparent-Mode Encryption * Using Password-Mode Encryption * Using Dual-Mode Encryption DIAGNOSING FAILURES * Reducing Problem Diagnosis Time * Automatic Diagnostic Repository * Data Recovery Advisor * Handling Block Corruption RESTORE AND RECOVERY CONCEPTS * Restoring and Recovering * Instance Failure and Instance/Crash Recovery * Media Failure * Complete Recovery (Overview) * Point-in-Time Recovery (Overview) * Recovery with the RESETLOGS Option PERFORMING RECOVERY, PART I * RMAN Recovery in NOARCHIVELOG Mode * Performing Complete Recovery (of critical and noncritical data files) * Restoring ASM Disk Groups * Recovery with Image Files * Performing Point-in-Time (PITR) or Incomplete Recovery PERFORMING RECOVERY, PART II * Recovery of Server Parameter File, Control File (One and All) * Redo Log File Loss and Recovery * Password Authentication File Re-creation * Index, Read-Only Tablespace, and Temp file Recovery * Restoring the Database to a New Host * Disaster Recovery * Restoring RMAN Encrypted Backups RMAN AND ORACLE SECURE BACKUP * Oracle Secure Backup Overview and Interface Options * RMAN and OSB: Overview and Basic Process Flow * Starting with Oracle Secure Backup * Configuring Oracle Secure Backup for RMAN * RMAN Backup and Restore Operations * Oracle Secure Backup Jobs * Displaying OSB log files and transcripts for RMAN activities USING FLASHBACK TECHNOLOGIES * Flashback Technology: Overview and Setup * Using Flashback Technology to Query Data * Flashback Table * Flashback Transaction (Query and Back out) * Flashback Drop and the Recycle Bin * Flashback Data Archive USING FLASHBACK DATABASE * Flashback Database Architecture * Configuring Flashback Database * Performing Flashback Database * Best Practices for Flashback Database TRANSPORTING DATA * Transporting Data Across Platforms * Transporting Data with Backup Sets * Database Transport: Using Data Files PERFORMING POINT-IN-TIME RECOVERY * When to use TSPITR * TSPITR Architecture * Performing RMAN TS Point-in-time Recovery * Recovering Tables from Backups DUPLICATING A DATABASE * Using a Duplicate Database * Duplicating Database with 'push' and 'pull' techniques * Choosing Database Duplication Techniques * Creating a Backup-up Based Duplicate Database * Understanding the RMAN Duplication Operation RMAN TROUBLESHOOTING AND TUNING * Interpreting RMAN Message Output * Tuning Principles * Diagnosing Performance Bottlenecks * RMAN Multiplexing * Restore and Recovery Performance Best Practices CLOUD TOOLING FOR BACKUP AND RECOVERY * Backup Destinations * Customize Backup Configuration * On-Demand Backup and Recovery * Oracle Backup Cloud Service * Installing the Backup Module BACKUP AND RECOVERY WORKSHOP * Workshop Structure and Approach * Business Requirements for Database Availability and Procedures * Diagnosing the Failures

Duration 4 Days 24 CPD hours This course is intended for Architect Database Administrators Overview Configure and use Policy-Based Cluster Management in conjunction with Policy-Managed Database and Oracle Multitenant Architecture Migrate from a standard cluster to a Flex Cluster and configure highly available application resources on Flex Cluster Leaf Nodes Implement Oracle Database In-Memory on an existing Oracle RAC database Configure an Oracle RAC database to use Application Continuity Configure and use Global Data Services in conjunction with Oracle RAC and Data Guard Upgrade an existing database to use Oracle ASM Filter Driver Migrate from standard ASM to Flex ASM and examine the effect of using Flex ASM Perform a database rolling upgrade, from Oracle Database 11gR2 to Oracle Database 12c, using a transient logical standby database Practice configuring, administering and using noteworthy features associated with Oracle Database 12c RAC and Grid Infrastructure. Practice configuring, administering and using noteworthy features associated with Oracle Database 12c RAC and Grid Infrastructure. ADDITIONAL COURSE DETAILS: Nexus Humans Oracle Database 12c - RAC and Grid Infra Deployment 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 - RAC and Grid Infra Deployment 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 AdministratorDatabase Administrators Overview Describe the components of ASMExplain and apply Automatic Storage Management (ASM) initialization parametersManage ASM instances and associated processesMonitor ASM using the V$ASM dynamic performance viewsUnderstand Flex ASM architecture and componentsUnderstand ASM Deployment AlternativesInstall and configure Flex ASMManage Flex ASMEmploy ASM space management techniquesCreate and delete Automatic Storage Management (ASM) disk groupsSet the attributes of an existing ASM disk groupPerform ongoing maintenance tasks on ASM disk groupsExplain key performance and scalability considerations for ASM disk groupsDescribe the Automatic Storage Management (ASM) architectureUse different client tools to access ASM filesDescribe the format of a fully qualified ASM file name This Oracle Database 12c: ASM Administration training teaches you about Oracle ASM architecture. Expert Oracle University instructors will help you develop a deeper understanding of both standard ASM and Flex ASM applications. This Oracle Database 12c: ASM Administration training teaches you about Oracle ASM architecture. Expert Oracle University instructors will help you develop a deeper understanding of both standard ASM and Flex ASM applications.

DESCRIPTION The Oracle Database server composes PL/SQL units and stores it in the database.  Mainly, PL/SQL functions to hold to hold SQL declaration within its sentence structure. Do you want to know more about SL/SQL function? How does it bring optimal proficiency in 'procedural language'? if so, take a look at the Oracle 11g PL/SQL Intermediate course. It will assist you in understanding all you need to know about Oracle 11g PL/SQL. The course designs to help the learners to know its function incorporation with different strings, numbers, table row record, and error management. The Oracle 11g PL/SQL Intermediate course teaches the fundamental form and structure of the program unit saved within database, creating and managing stored methods, functions, packaged programs, and database prompts. Its contents aim to take you further in your quest to teach the effective methods including variables and cursor expressions. ASSESSMENT: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. CERTIFICATION: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. WHO IS THIS COURSE FOR? Oracle 11g PL/SQL Intermediate is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. REQUIREMENTS Our Oracle 11g PL/SQL Intermediate is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. CAREER PATH After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:03:00 Preparing Your Environment Install Oracle XE 00:11:00 SQL Developer Installation 00:20:00 Workstation Setup 00:12:00 Database Program Units Introducing the Database Program Unit 00:19:00 Working with Stored Procedures and Functions Creating Stored Procedures and Functions 00:19:00 Understanding the Parameter Specification 00:23:00 Executing Procedures and Functions 00:26:00 Calling Functions from within SQL 00:13:00 Handling Compilation Errors 00:08:00 Maintaining Stored Procedures and Functions Recompiling and Dropping Programs 00:16:00 Data Dictionary Storage 00:25:00 Managing Dependencies 00:13:00 Tracking Dependencies 00:08:00 Using the Dependency Tracking Utility 00:09:00 Creating and Maintaining Packages What Is a Package? 00:10:00 Creating a Package 00:19:00 Package Definition Information 00:08:00 Advanced Programming Techniques 00:06:00 Using Persistent Global Objects 00:04:00 Including Initialization Logic 00:15:00 Object Oriented Support within Packages 00:14:00 Package Maintenance 00:18:00 Advanced Cursor Techniques Learning to Use Cursor Variables 00:24:00 Advanced Cursor Techniques Weak Cursor Definitions 00:16:00 REFCURSOR Cursor Definition 00:05:00 Using Cursor Expression 00:14:00 Using System Supplied Packages Using the DBMS OUTPUT() Package 00:12:00 Using the UTL FILE() Package 00:30:00 Creating Database Triggers Understanding the Database Trigger 00:23:00 Statement-Level Triggers 00:23:00 Row-Level Triggers 00:12:00 Row Level Trigger Example 1 00:11:00 Row Level Trigger Example 2 00:07:00 Row Level Trigger Example 3 00:08:00 Working with the INSTEAD OF Trigger 00:11:00 Using Triggers within an Application 00:09:00 Trigger Maintenance Using the CALL Statement 00:09:00 Trigger Maintenance Tasks 00:12:00 Work with Multiple Triggers for a Single Table 00:11:00 Handling Mutating Table Issues 00:22:00 Using the Compound Trigger 00:06:00 Working with System Event Triggers What Is a System Event Trigger 00:05:00 Defining Scope 00:04:00 Identifying Available System Events 00:12:00 Conclusion Conclusion 00:02:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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.

DESCRIPTION PL/SQL is program units which are composed by the Oracle Database server and stored in the database.  The main function of PL/SQL is to hold SQL proclamation within its syntax. If you are interested to know more about SL/SQL function, and how it brings optimal competence in terms of 'procedural language', you may have a look at the Oracle 11g PL/SQL Beginner course. The course is designed in such a way that will assist the learners to know how it works with various strings, numbers, table row record, and error management. It also teaches the learner how to use different key data lexicon to synopsize and maintain the data. The learners will also be able to know about portability, productivity, and manageability of this most widely manipulative language. ASSESSMENT: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. CERTIFICATION: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. WHO IS THIS COURSE FOR? Oracle 11g PL/SQL Beginner is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. REQUIREMENTS Our Oracle 11g PL/SQL Beginner is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. CAREER PATH After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:03:00 Preparing Your Environment Course Setup 00:37:00 Working with Oracle Database Tools Selecting the Appropriate Database Tool 00:31:00 Language Features Understanding PL/SQL 00:18:00 PL/SQL Blocks 00:15:00 Working with SQL Plus 00:11:00 The DECLARE Clause DECLARE Clause Objects 00:16:00 PL/SQL Available Data Types 00:17:00 Declaring Simple Data Types and Assignments 00:12:00 Declaring Complex Data Types and Assignments 00:11:00 Declaring Complex RowTypes and Assignments 00:07:00 Declaring Complex Tables 00:08:00 Declaring Complex Records 00:08:00 Creating and Declaring User-Defined Types 00:09:00 The BEGIN Clause What Can Be Included in the BEGIN Clause 00:07:00 Working with CHAR and VARCHAR2 Variables 00:08:00 Handling String Literals 00:08:00 Working with Numeric Variables 00:07:00 Working with Date Variables 00:06:00 Assigning and Using Boolean Variables 00:08:00 Using Comparison Operators 00:07:00 Using SQL Functions 00:06:00 SQL DML within PL/SQL 00:15:00 Using SELECT 00:07:00 Exceptions and Embedded SQL 00:11:00 Using Sequences 00:14:00 Logic Control and Branching 00:07:00 Using GOTO 00:06:00 Working with LOOPS 00:19:00 Creating and Using the Indefinite Loop 00:07:00 Creating and Using the Conditional Loop 00:09:00 Using Nested Loops 00:12:00 Using the If-Then-Else 00:19:00 Using the CASE Statement 00:18:00 The EXCEPTION Clause What Are the Types of Exceptions 00:06:00 Trapping Exceptions 00:06:00 Identify Exception Details 00:11:00 Creating User-Defined Exceptions 00:11:00 Using SQLCODE and SQLERRM Objects 00:09:00 Understand the Implicit Cursor 00:15:00 Creating User-Defined Events 00:12:00 Explicit Cursors Understanding the Concept and Purpose of Explicit Cursors 00:18:00 Learn about Cursor Attributes 00:10:00 Using the Continue Statement 00:06:00 Working with Updateable Cursors 00:19:00 Creating and Using Cursor Parameters 00:15:00 FORLOOP Cursors 00:07:00 Nested Blocks Understanding Nested Blocks 00:11:00 Difference between Global vs Local Objects and Exceptions 00:13:00 Declared Subprograms Subprograms: How They Differ from Nested Blocks 00:18:00 Conclusion Conclusion 00:04:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00