Get $1 credit for every $25 spent!

The Ultimate Oracle, SAP & Salesforce Training Prep Bundle

Ending In:
Add to Cart - $24.99
Add to Cart ($24.99)
$1,200
97% off
wishlist
Courses
6
Lessons
493

What's Included

Product Details

Access
Lifetime
Content
9.0 hours
Lessons
51

Oracle 11g PL/SQL Part 1

Introduction Training on PL/SQL Database Programming Language

By Intellezy | in Online Courses

The primary objective of this Oracle 11g training course is to provide an introduction to the PL/SQL database programming language covering syntax, structure, and features of the language within the context of database applications and programming. This Oracle 11g course will prepare students for the Oracle certification exams (OCP).

4.5/5 average rating: ★ ★ ★ ★

  • Access 51 lectures & 9 hours of content 24/7
  • Understand PL SQL1
  • Declare simple & complex data types and assignments
  • Declare complex row types & assignments
  • Declare complex tables & records
  • Work with CHAR & VARCHAR2 variables
  • Work with numeric & data variables
  • Assign & use Boolean variables
  • Understand the difference between global vs local objects & exceptions
"The instructor's explanations are very well organized, articulate, and thorough. One of the best online courses on PL/SQL I've sampled. Great course for beginners as well as experienced professionals looking for a refresher" – Rodney
Intellezy | Computer Training Specialists
4.4/5 average rating: ★ ★ ★ ★

Intellezy collaborates with organizations to help implement and adopt technology to its maximum potential. From our change management consulting to our learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Our online videos and quick reference guides are designed to educate and empower individuals, right when they need it. In today’s rapidly evolving workplace, it is imperative to make sure you have the skills and expertise required to succeed. Our library, recognized by top influencers such as eLearning Journal and The Craig Weiss Group, provides dynamic and task-focused videos right at your fingertips, right when you need them.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Understanding of basic database architecture

Course Outline

  • Your First Program
  • Introduction
    • Introduction - 3:06
  • Preparing Your Environment
    • Course Setup - 37:03
  • Working with Oracle Database Tools
    • Selecting the Appropriate Database Tool - 30:45
  • Language Features
    • Understanding PL SQL - 17:59
    • PL SQL Blocks - 15:19
    • Working with SQL Plus - 11:00
  • The DECLARE Clause
    • DECLARE Clause Objects - 16:25
    • PL SQL Available Data Types - 16:55
    • Declaring Simple Data Types and Assignments - 12:16
    • Declaring Complex Data Types and Assignments - 10:38
    • Declaring Complex RowTypes and Assignments - 7:02
    • Declaring Complex Tables - 7:44
    • Declaring Complex Records - 8:12
    • Creating and Declaring User-Defined Types - 8:48
  • The BEGIN Clause
    • What Can Be Included in the BEGIN Clause - 7:02
    • Working with CHAR and VARCHAR2 Variables - 7:30
    • Handling String Literals - 7:41
    • Working with Numeric Variables - 6:40
    • Working with Date Variables - 6:00
    • Assigning and Using Boolean Variables - 7:44
    • Using Comparison Operators - 7:24
    • Using SQL Functions - 6:04
    • SQL DML within PL SQL - 15:05
    • Using SELECT - 6:32
    • Exceptions and Embedded SQL - 11:16
    • Using Sequences - 14:28
    • Logic Control and Branching - 6:58
    • Using GOTO - 5:52
    • Working with LOOPS - 18:53
    • Creating and Using the Indefinite Loop - 6:59
    • Creating and Using the Conditional Loop - 8:48
    • Using Nested Loops - 11:33
    • Using the If-Then-Else - 18:54
    • Using the CASE Statement - 17:43
  • The EXCEPTION Clause
    • What Are the Types of Exceptions - 5:31
    • Trapping Exceptions - 5:32
    • Identify Exception Details - 10:57
    • Creating User-Defined Exceptions - 10:49
    • Using SQLCODE and SQLERRM Objects - 8:29
    • Understand the Implicit Cursor - 14:37
    • Creating User-Defined Events - 12:26
  • Explicit Cursors
    • Understanding the Concept and Purpose of Explicit Cursors - 18:10
    • Learn about Cursor Attribute - 10:12
    • Using the Continue Statement - 5:44
    • Working with Updateable Cursors - 19:25
    • Creating and Using Cursor Parameters - 14:45
    • FOR...LOOP Cursors - 6:53
  • Nested Blocks
    • Understanding Nested Blocks - 10:46
    • Understanding the Difference between Global vs Local Objects and Exceptions - 12:35
  • Declared Subprograms
    • What Are Subprograms and How Are They Different from Nested Blocks - 17:37
  • Conclusion
    • Course Recap - 3:52

View Full Curriculum


Access
Lifetime
Content
10.0 hours
Lessons
46

Oracle 11g PL/SQL Part 2

Advanced Programming Techniques to Prepare You for the Oracle Certification Exams (OCP)

By Intellezy | in Online Courses

In Oracle 11g PL/SQL Volume II, you'll dive into topics such as understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. Additional topics include taking advantage of advanced programming techniques such as cursor variables and cursor expressions. This Oracle 11g course will prepare students for the Oracle certification exams (OCP).

4.5/5 average rating: ★ ★ ★ ★

  • Access 46 lectures & 10 hours of content 24/7
  • Understand the basic form and structure of program units stored within the database
  • Create stored procedures & functions
  • Understand the parameter specification Execute procedures & functions
  • Recompile & drop programs
  • Manage & track dependencies
"Great course. If you need to get up and running quickly with PL/SQL, this is definitely a great choice." – Matúš Dúbrava
Intellezy | Computer Training Specialists
4.4/5 average rating: ★ ★ ★ ★

Intellezy collaborates with organizations to help implement and adopt technology to its maximum potential. From our change management consulting to our learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Our online videos and quick reference guides are designed to educate and empower individuals, right when they need it. In today’s rapidly evolving workplace, it is imperative to make sure you have the skills and expertise required to succeed. Our library, recognized by top influencers such as eLearning Journal and The Craig Weiss Group, provides dynamic and task-focused videos right at your fingertips, right when you need them.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Oracle PL/SQL Part 1

Course Outline

  • Introduction
    • Introduction - 2:40
  • Preparing Your Environment
    • Install Oracle XE - 10:59
    • SQL Developer Installation - 19:47
    • Workstation Setup - 12:14
  • Database Program Units
    • Introducing the Database Program Unit - 19:05
  • Working with Stored Procedures and Functions
    • Creating Stored Procedures and Functions - 18:44
    • Understanding the Parameter Specification - 22:57
    • Executing Procedures and Functions - 26:11
    • Calling Functions from within SQL - 13:05
    • Handling Compilation Errors - 8:19
  • Maintaining Stored Procedures and Functions
    • Recompiling and Dropping Programs - 16:06
    • Data Dictionary Storage - 24:47
    • Managing Dependencies - 12:52
    • Tracking Dependencies - 8:25
    • Using the Dependency Tracking Utility - 9:25
  • Creating and Maintaining Packages
    • What Is a Package? - 10:02
    • Creating a Package - 19:03
    • Package Definition Information - 7:51
    • Advanced Programming Techniques - 6:06
    • Using Persistent Global Objects - 3:36
    • Including Initialization Logic - 15:17
    • Object Oriented Support within Packages - 13:44
    • Package Maintenance - 17:47
  • Advanced Cursor Techniques
    • Learning to Use Cursor Variables - 23:38
    • Weak Cursor Definitions - 16:10
    • REFCURSOR Cursor Definition - 5:06
    • Using Cursor Expressions - 13:36
  • Using System Supplied Packages
    • Using the DBMS OUTPUT () Package - 11:38
    • Using System Supplied Packages Using the UTL_FILE() Package - 29:29
  • Creating Database Triggers
    • Understanding the Database Trigger - 23:18
    • Statement-Level Triggers - 22:35
    • Row-Level Triggers - 12:04
    • Row Level Trigger Example 1 - 11:08
    • Row Level Trigger Example 2 - 7:24
    • Row Level Trigger Example 3 - 7:35
    • Working with the INSTEAD OF Trigger - 10:53
    • Using Triggers within an Application - 8:47
  • Trigger Maintenance
    • Using the CALL Statement - 9:08
    • Trigger Maintenance Tasks - 12:14
    • Working with Multiple Triggers for a Single Table - 10:46
    • Handling Mutating Table Issues - 22:09
    • Using the Compound Trigger - 5:34
  • Working with System Event Triggers
    • What Is a System Event Trigger? - 5:25
    • Defining Scope - 3:36
    • Identifying Available System Events - 12:12
  • Conclusion
    • Course Recap - 1:31

View Full Curriculum


Access
Lifetime
Content
53.0 hours
Lessons
234

Complete Salesforce Trailhead 2021: From Zero to Hero Bundle: 7 Courses in 1

From Platform Basics to AppExchange — Start Your Awesome Admin Journey with Beginner to Advanced Salesforce Content

By Jimmy Tanzil | in Online Courses

Salesforce trailhead is a learning experience platform that helps you with the skills you need to transform your company, earn credentials that grow your career and connect with a global movement of Trailblazers to continue learning together. This course bundle is for everyone who is new to Salesforce and wants to finish as an SF expert. It is intended as a starting point to equip yourself for a better future. With 7 full-blown courses, you will be equipped with the essential skills for your Salesforce journey.

4.3/5 average rating: ★ ★ ★ ★

  1. Admin Beginner Trail: Learn the basics of Salesforce
  2. Admin Intermediate Trail: Explore building processes, data security, & more
  3. Admin Advanced Trail: Reach all-star admin status by tackling more advanced Salesforce features
  4. Declarative Lookup Rollup Summary: Understand why & when to use DLRS in Salesforce
  5. Developer Beginner Trail: Leverage your existing development skills to build apps fast on the Salesforce Platform
  6. Developer Intermediate Trail: Take your apps to the next level with powerful integration & mobile tools
  7. Developing AppExchange App Trail: Roll up your sleeves and develop, package, & test your first AppExchange app
"Above & Beyond! I really appreciate your efforts for beginners, and I love it. It is Trailhead Plus. I highly recommend this to anyone who wants salesforce skills." – Zack Jaread
Jimmy Tanzil | Salesforce Certified Application Architect, Developer, Admin
4.4/5 Instructor Rating: ★ ★ ★ ★
Jimmy Tanzil has over twenty years of experience in the IT field. His main strengths are focused on Salesforce development and administration, web application development, and mobile app development. He is currently working as a Salesforce Architect, Advanced Administrator, Developer, and Consultant focusing on the non-profit sector.

He has in-depth knowledge of all phases of application development, including analysis, design, coding, testing, and implementation. He also has in-depth experience in systems integration such as integration of multiple platforms across various services including Salesforce, WordPress, WooCommerce, Magento commerce, Facebook, pardot, zapier, conga, MailChimp, PayPal, various payment gateway systems, Canada post integrations, twillio phone/SMS systems, and other platforms.

Alongside his core strengths, he has genuine interests and curiosity in a wide-rage of the IT sector such as networking, server management, cloud services, AI, machine learning, cryptocurrencies and blockchains, printing systems, mailing systems, help desk system, order fulfillment systems/shipping, phone systems (PABX) management, and various other fields in IT.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Basic computer knowledge

Course Outline

  • Admin Beginner Trail
    • Get Started with the Salesforce Platform - 19:42
    • Hands-on Challenge (500 Points) - 6:23
    • Discover Use Cases for the Platform - 6:04
    • Quiz (100 Points) - 2:44
    • Understand the Salesforce Architecture - 12:17
    • Quiz (100 Points) - 2:00
    • Navigate Setup + Quiz (100 Points) - 11:19
    • Power Up with AppExchange + Quiz (100 Points) - 12:26
    • Understand Custom & Standard Objects - 27:23
    • Hands-on Challenge (500 Points) - 14:25
    • Create Object Relationships - Lookup - 17:49
    • Create Object Relationships - Master Detail - 17:51
    • Hands-on Challenge (500 Points) - 4:45
    • Work with Schema Builder - 9:27
    • Hands-on Challenge (500 Points) - 4:46
    • Import Data - Data Import Wizard - 23:08
    • Import Data - Data Loader - 16:12
    • Hands-on Challenge (500 Points) - 7:14
    • Export Data - Data Export Wizard - 8:27
    • Export Data - Data Loader - 5:49
    • Quiz (50 Points) - 2:22
    • Set Up Your Org + Hands-on Challenge (500 Points) - 19:38
    • Create and Customize Lightning Apps + Quiz (100 Points) - 13:30
    • Create and Customize List Views + Hands-on Challenge (500 Points) - 13:08
    • Customize Record Highlights with Compact Layout+Hands-on Challenge (500 Points) - 15:20
    • Customize Record Details with Page Layouts + Quiz (100 Points) - 20:09
    • Create Custom Buttons and Links + Hands-on Challenge (500 Points) - 30:42
    • Empower Your Users with Quick Actions + Quiz (100 Points) - 25:21
    • Get Started with the Salesforce Mobile App + Quiz (100 Points) - 13:25
    • Create Global Quick Actions + Hands-on Challenge (500 Points) - 20:19
    • Create Object-Specific Quick Actions + Hands-on Challenge (500 Points) - 16:19
    • Customize Compact Layouts + Hands-on Challenge (500 Points) - 14:00
    • Customize Navigation - Quiz (100 Points) - 20:04
    • Get Started with User Engagement + Quiz (100 Points) - 10:14
    • Promote Feature Adoption and Discovery + Quiz (100 Points) - 16:59
    • Customize the Help Menu + Quiz (50 Points) - 5:12
    • Design a User Engagement Journey + Quiz (50 Points) - 6:43
    • Preparation – Import Bulk Data for Reports & Dashboards – Step 1 - 25:33
    • Preparation – Import Bulk Data for Reports & Dashboards – Step 2 - 15:04
    • Introduction to Reports and Dashboards in Lightning Experience + Quiz (100 Pts) - 7:32
    • Create Reports with the Report Builder - Part 1 - 13:37
    • Create Reports with the Report Builder – Part 2 + Hands-on Challenge (500 Pts) - 26:02
    • Format Reports + Hands-on Challenge (500 Points) - 32:34
    • Visualize Your Data with the Lightning Dashboard Builder + Hands-on Challenge - 27:32
    • Extend Your Reporting Strategy with AppExchange + Hands-on Challenge (500 Pts) - 22:03
  • Admin Intermediate Trail
    • Introduction - 9:44
    • Data Preparation - Object Customization - 29:48
    • Data Preparation - Loading Sample Data - Part 1 - 20:50
    • Data Preparation - Loading Sample Data - Part 2 - 11:18
    • Data Preparation - Loading Sample Data - Part 3 - 10:16
    • Use Formula Fields - 47:03
    • Implement Roll-Up Summary Fields - 44:47
    • Create Validation Rules - 41:19
    • Overview of Data Security - 15:48
    • Control Access to the Org - 17:36
    • Control Access to Objects - 17:29
    • Control Access to Fields - 17:13
    • Control Access to Records - 15:52
    • Create a Role Hierarchy - 9:13
    • Define Sharing Rules - 18:12
    • Get Started with Picklists - 15:58
    • Manage Your Picklist Values - 19:23
    • Share Values with Global Value Sets - 12:27
    • Create an App - 8:48
    • Add Custom Fields - 10:53
    • Modify the User Experience - 10:42
    • Add Business Logic - 13:31
    • Create Reports and Dashboards - 13:18
    • Choose the Right Automation Tool - 10:06
    • Automate Simple Business Processes with Process Builder - 33:19
    • Guide Users Through Your Business Processes with Flow Builder - 58:28
    • Guide Users Through Your Business Processes with Flow Builder - Challenge - 13:50
    • Combine the Power of Process Builder and Flow Builder Part 1 - 20:35
    • Combine the Power of Process Builder and Flow Builder Part 2 - 51:25
    • Customize How Records Get Approved with Approvals - 20:49
    • Customize How Records Get Approved with Approvals - Challenge - 7:41
    • Get Started with AppExchange - 8:03
    • Navigate AppExchange Like a Superhero - 14:41
    • Install AppExchange Packages (Also Like a Superhero) - 8:19
    • Get Started with External Services - 11:50
    • Define a Schema for an External Service - 8:10
    • Register an External Service - 6:13
    • Use External Services in a Flow - 12:57
    • Salesforce Mobile App Rollout - Combined sections and quizes - 21:58
    • Create the Battle Station App - 6:44
    • Build the Object Model - 13:20
    • Modify the User Experience - 7:37
    • Add Business Logic - 8:33
    • Create Reports and Dashboards - 4:53
    • Make the App Mobile - 3:52
  • Admin Advanced Trail
    • Use Basic Logic in Checkbox Formulas - 7:53
    • Use Numbers, Currency, and Percentages in Formulas - 7:47
    • Use Date, Date/Time, and Time Formulas - 2:08
    • Use Picklists in Formulas - 6:33
    • Use Text Formulas - 19:22
    • Level Up with Advanced Formulas - 17:19
    • Troubleshoot Formula Errors - 10:47
    • Get Started with Event Monitoring - 7:16
    • Query Event Log Files - 6:44
    • Download and Visualize Event Log Files - 6:53
    • Introduction to Salesforce Connect - 9:53
    • Set up Salesforce Connect - 17:55
    • Integrate External Data - 7:00
    • Learn About Regional Settings - 19:20
    • Discover Multiple Currency Settings - 13:42
  • Using DLRS - Declarative Lookup Rollup Summary
    • Getting Started with Declarative Lookup Rollup Summary - 7:03
    • Why and when to use DLRS in Salesforce - 6:07
    • Salesforce DLRS Real Example - Counting Cases on Contacts - 10:35
    • Salesforce DLRS Real Example - Counting Custom Object on Accounts - 8:44
    • Salesforce DLRS Real Example - Opportunities on Accounts - 7:24
    • Salesforce DLRS Real Example - Counting Case Records by Date Time on Contacts - 6:51
    • Salesforce DLRS Real Example - Tasks on Contacts - Date Field - 8:55
    • Salesforce DLRS Real Example - Concatenate Text Fields - 10:02
    • Salesforce DLRS Real Example - Previous Message Sent - Contact - 7:10
  • Developer Beginner Trail
    • Get Started with the Salesforce Platform - 13:19
    • Develop Without Code - 13:38
    • Code with Salesforce Languages - 21:38
    • Extend the Salesforce Platform - 15:27
    • Get Started with Apex - 24:19
    • Get Started with Apex - Challenge - 7:12
    • Use sObjects - 20:17
    • Manipulate Records with DML - 14:52
    • Bulk DML - 9:45
    • Upsert DML - 12:26
    • Database Methods DML - 9:10
    • Related Records DML - 9:53
    • Manipulate Records with DML - Challenge - 11:27
    • Write SOQL Queries Part 1 - 17:31
    • Write SOQL Queries Part 2 - 15:09
    • Write SOQL Queries - Challenge - 10:35
    • Write SOSL Queries - 13:10
    • Write SOSL Queries - Challenge - 11:47
    • Get Started with Apex Triggers 1 - 18:30
    • Get Started with Apex Triggers Part 2 - 19:04
    • Get Started with Apex Triggers - Challenge - 12:14
    • Bulk Apex Triggers - 16:49
    • Bulk Apex Triggers - Challenge - 14:19
    • Get Started with Apex Unit Tests Part 1 - 12:53
    • Get Started with Apex Unit Tests Part 2 - 20:09
    • Get Started with Apex Unit Tests Part 3 - 16:23
    • Get Started with Apex Unit Tests - Challenge - 24:05
    • Test Apex Triggers - 10:19
    • Test Apex Triggers - Challenge - 9:16
    • Create Test Data for Apex Tests Part 1 - 13:37
    • Create Test Data for Apex Tests Part 2 - 12:08
    • Get Started with Visualforce - 8:25
    • Create & Edit Visualforce Pages - 9:22
    • Create & Edit Visualforce Pages - Challenge - 5:36
    • Use Simple Variables and Formulas - 14:03
    • Use Standard Controllers - 18:29
    • User Standard Controllers - Challenge - 4:54
    • Display Records, Fields, and Tables - 17:52
    • Display Records, Fields, and Tables - Challenge - 4:06
    • Input Data Using Forms - 16:26
    • Input Data Using Forms - Challenge - 6:18
    • Use Standard List Controllers - 14:35
    • Use Standard List Controllers - Challenge - 12:21
    • Use Static Resources - 11:29
    • Use Static Resources - Challenge - 5:34
    • Create & Use Custom Controllers - 17:46
    • Create & Use Custom Controllers - Challenge - 12:37
    • Get Started with the Developer Console - 8:44
    • Navigate and Edit Source Code - 9:44
    • Navigate and Edit Source Code - Challenge - 2:50
    • Generate and Analyze Logs - 14:54
    • Inspect Objects at Checkpoints - 5:59
    • Inspect Objects at Checkpoints - Challenge - 4:02
    • Execute SOQL and SOSL Queries - 9:00
    • Get Started with Visual Studio Code - 18:20
    • Choose the Right Search Solution (300 POINTS) - 18:33
    • 10026-CustomizeHowRecordsGetApprovedwith_Approvals - 20:49
  • Developer Intermediate Trail
    • Get to Know the Salesforce Lightning Platform APIs - 6:49
    • Use REST API - 11:26
    • Use SOAP API - 23:32
    • Use Bulk API - 24:28
    • Use Streaming API - 18:09
    • Get Started With User Interface API - 8:35
    • Install the Sample App - Part 1 - 17:31
    • Install the Sample App - Part 2 - 9:53
    • Build UI to Display a Record - 8:46
    • Build UI to Edit a Record - 13:04
    • Build UI to Create and Clone a Record - 5:48
    • Build UI for Dependent Picklists - 13:21
    • Apex Integration Overview - 9:43
    • Apex REST Callouts - 9:13
    • Apex REST Callouts Test Class - 11:42
    • Apex REST Callouts - Challenge - 19:42
    • Apex SOAP Callouts - 9:46
    • Test Web Service Callouts - 5:45
    • Apex SOAP Callouts - Challenge - 15:21
    • Apex Web Services - 11:27
    • Apex Web Services - Test Class & curl - 15:26
    • Apex Web Services - Challenge - 14:46
    • Asynchronous Processing Basics - 7:05
    • Use Future Methods - 13:24
    • Use Future Methods - Challenge - 22:26
    • Use Batch Apex - 13:20
    • Use Batch Apex - Challenge - 19:41
    • Control Processes with Queueable Apex - 7:51
    • Control Processes with Queueable Apex - Challenge - 32:09
    • Schedule Jobs Using the Apex Scheduler - 8:26
    • Schedule Jobs Using the Apex Scheduler - Challenge - 16:43
    • Monitor Asynchronous Apex - 8:38
    • Understand Event-Driven Software Architecture - 13:09
    • Define and Publish Platform Events - 12:23
    • Subscribe to Platform Events - 9:34
    • Subscribe to Platform Events - Challenge - 7:40
    • Understand What Application Lifecycle Management Is - 10:33
    • Learn the Basics of Release Management - 5:44
    • Manage Changes in Increasingly Complex Releases - 6:14
    • Use Package Development for More Flexible Release - 5:30
    • Plan for Changes to Your OrgPlan for Changes to Your Org - 14:10
    • Develop and Test Changes Locally - 4:24
    • Test in the Integration Environment and Deploy Changes - 7:12
    • Plan for Changes to Your Org - 7:25
    • Develop and Test Changes Locally - 26:15
    • Test and Deploy Changes - 11:01
    • Get Started with Platform Cache - 10:24
    • Use Org & Session Cache - 10:10
    • Use Org & Session Cache - Challenge - 13:07
    • Walk Through a Sample Application and Discover Cache Diagnostics - 1:26
    • Get Started with Big Objects - 8:05
    • Define Custom Big Objects - 12:33
    • Query Big Objects - 6:18
    • Aura Components to Lightning Web Components - LWC - 3:31
  • Appexchange Development
    • Understand the AppExchange Development Landscape - 15:21
    • Create and Manage Partner Development Orgs - 11:44
    • Package an AppExchange App - 25:05
    • Challenge - 16:00
    • Test an AppExchange App - 10:46
    • Learn About Licenses - 11:33
    • Manage Your Licenses - 15:35
    • Manage Your Features - 7:04
    • Be There for Your Customers - 12:51

View Full Curriculum


Access
Lifetime
Content
6.0 hours
Lessons
39

Oracle 12C Release 2 Backup & Recovery Using RMAN

Perform Backup & Recovery Activities on Oracle Databases

By Oak Academy | in Online Courses

Recovery Manager (RMAN) is an Oracle Database client that performs backup and recovery tasks on your databases and automates the administration of your backup strategies. It greatly simplifies backing up, restoring, and recovering database files. Through this course, you’ll learn everything for using RMAN to manage backup and recovery activities on Oracle databases. After every concepts lecture, you will have a chance to implement a hands-on practical exercise. You'll also learn the best practices and shortcuts.

4.3/5 average rating: ★ ★ ★ ★

  • Access 39 lectures & 6 hours of content 24/7
  • Learn backup & recovery concepts in Oracle
  • Set up the laboratory environment
  • Create & manage the recovery catalog Use flashback technologies in Oracle
  • Back up the database
  • Report on RMAN operations
  • Manage RMAN backups
  • Use Data Recovery Advisor of Oracle
  • Restore & recover database and database objects
"This is an excellent course that completely de-mystified RMAN for me. I highly recommend this course for anyone wanting to learn how to backup and recover with RMAN properly." – Raphael Debinski
Oak Academy | Long Live Tech Knowledge
4.4/5 Instructor Rating: ★ ★ ★ ★
Oak Academy is a group of tech experts who have been in the sector for years and years. Deeply rooted in the tech world, they know that the tech industry's biggest problem is the "tech skills gap" and their online course are their solution. They specialize in critical areas like cybersecurity, coding, IT, game development, app monetization, and mobile. Thanks to their practical alignment, they are able to constantly translate industry insights into the most in-demand and up-to-date courses.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Any device with basic specifications

Course Outline

  • Introduction
    • 1 - Let's See What We Will Cover In This RMAN Course - 4:54
    • Project Files and Course Documents
  • Downloads
    • 2 - Download Virtualbox - 0:54
    • 3 - Download Linux - 3:39
    • 4 - Download Oracle Software - 1:21
  • Installation
    • 5 - Install Virtual Box - 1:35
    • 6 - Create Virtual Machine - 1:27
    • 7 - Install Guest Operating System - 8:11
    • 8 - Prerequisites - 11:02
    • 9 - Oracle Software Installation - 7:20
    • 10 - Clone Virtual Machine - 5:00
    • 11 - Create Primary Database - 3:00
    • 12 - Create Catalog Database - 2:40
    • 13 - Create Sample Data - 4:33
  • Intro to Backup and Recovery
    • 14 - Introduction to Backup and Recovery - 20:32
  • Starting and Interacting with the RMAN Client
    • 15 - Starting and Interacting with the RMAN Client - 3:58
  • Create Recovery Catalog
    • 16 - Create Recovery Catalog - 16:54
  • Flashback Database and Restore Points
    • 17 - Flashback Database and Restore Points Presentation - 7:25
    • 18 - Flashback Database and Restore Points - 24:52
  • Backup Database
    • 19 - Backup Database Concepts - 19:20
    • 20 - Backup Database - 36:50
    • 21 - Backup Database - Advanced Topics - 32:25
    • Quiz
  • Reporting on RMAN Operations
    • 22 - Reporting on RMAN Operations - 31:55
  • Maintaining RMAN Backups and Repository Records
    • 23 - Maintaining RMAN Backups and Repository Records Presentation - 4:24
    • 24 - Maintaining RMAN Backups and Repository Records - 30:45
  • Managing Recovery Catalog
    • 25 - Managing Recovery Catalog Presentation - 4:09
    • 26 - Managing Recovery Catalog - 16:20
  • Data Repair Concepts
    • 27 - Data Repair Concepts - 7:30
    • 28 - Data Recovery Advisor - 11:08
  • Validating Database Files and Backups
    • 29 - Validating Database Files and Backups - 5:54
  • Performing Complete Database Recovery
    • 30 - Performing Datafile Recovery - 6:00
    • 31 - Performing Tablespace Recovery - 5:59
    • 32 - Performing PDB Recovery - 4:50
    • 33 - Performing Database Recovery - 6:46
  • Performing Point-in-Time Recovery
    • 34 - Database Point In Time Recovery - 15:00
    • 35 - Tablespace Point In Time Recovery - 14:02
  • Performing Block Media Recovery
    • 36 - Performing Block Media Recovery - 6:30
  • What We Have Learned in This RMAN Course?
    • 37 - Let's Wrap Up What We Covered In This RMAN Course - 3:50

View Full Curriculum


Access
Lifetime
Content
6.0 hours
Lessons
109

Learn SAP ABAP: SAP ABAP Programming Language for Beginners

Go from Scratch to Advanced Level with Hands-On Examples on SAP ABAP

By Oak Academy | in Online Courses

This SAP ABAP online course is among the awesome Intellezy courses that teach step by step and follow the methodology of introducing concepts and demos to the students to learn with ease SAP ABAP Programming. SAP ABAP is the most popular enterprise programming language developed by SAP, and with this online course, you will be stepping into the world of SAP ABAP.

3.9/5 average rating: ★ ★ ★ ★ ★

  • Access 109 lectures & 6 hours of content 24/7
  • Learn SAP ABAP programming
  • Enhance your existing SAP ABAP skills
  • Discover GUI customization & navigation
  • Create your first program
  • Create data dictionary objects
  • Process statements for internal tables
"A very well explained course. I liked how information is organized in the course, and I also liked the examples." –Serban Nina
Oak Academy | Long Live Tech Knowledge
4.4/5 Instructor Rating: ★ ★ ★ ★
Oak Academy is a group of tech experts who have been in the sector for years and years. Deeply rooted in the tech world, they know that the tech industry's biggest problem is the "tech skills gap" and their online course are their solution. They specialize in critical areas like cybersecurity, coding, IT, game development, app monetization, and mobile. Thanks to their practical alignment, they are able to constantly translate industry insights into the most in-demand and up-to-date courses.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Basic computer knowledge

Course Outline

  • What We Will Learn?
    • 1 - What We Will Learn? - 4:16
  • SAP Overview
    • 2 - Intro to ABAP For Programming - 1:07
    • 3 - What is ERP? - 2:05
    • 4 - What is SAP? - 1:38
    • 5 - Functional Modules - 2:05
    • 6 - SAP R/3 Architecture - 2:26
    • 7 - Advantages and Disadvantages - 2:09
  • ABAP Development Tools
    • 8 - Download and Setup Java Runtime Environment - 2:07
    • 9 - Download and Setup SAPGUI - 3:19
  • Login to SAP System
    • 10 - Adding a New SAP Application Server - 1:59
    • 11 - Logon to SAP and Logging Off from SAP - 1:53
    • 12 - GUI Customization and Navigation - 5:53
    • 13 - ABAP Editor - 10:11
  • Useful Transaction Codes For Beginners in ABAP
    • 14 - Useful Transaction Codes For Beginners in ABAP - 8:50
  • Creating Your First Program
    • 15 - Create Package - 1:52
    • 16 - My First ABAP Program - 3:35
  • Predefined ABAP Data Types
    • 17 - Predefined ABAP Data Types - 16:08
  • SAP ABAP - Operators
    • 18 - Arithmetic Operators - 7:35
    • 19 - Comparison Operators - 6:49
    • 20 - Character String Operators - 8:36
  • String Processing in ABAP
    • 21 - Introduction - 2:11
    • 22 - Concatenate String Function - 2:53
    • 23 - Condense… No-Gaps String Function - 1:43
    • 24 - SubFields (SubString) String Function - 2:55
    • 25 - Strlen String Function - 1:38
    • 26 - Replace String Function - 1:50
    • 27 - Search String Function - 2:27
    • 28 - Shift String Function - 3:27
    • 29 - Split String Function - 2:11
    • 30 - Translate String Function - 1:48
  • Decisions
    • 31 - IF Statement - 3:16
    • 32 - IF... Else Statement - 3:11
    • 33 - Nested IF Statement - 4:40
    • 34 - Case Control Statement - 3:52
  • Loop Controls
    • 35 - While Loop - 2:28
    • 36 - Do Loop - 1:14
    • 37 - Nested Do Loop - 2:38
    • 38 - Nested While Loop - 2:34
  • Loop Control Statements
    • 39 - Continue - 2:02
    • 40 - Check - 1:56
    • 41 - Exit - 2:19
  • Creating Data Dictionary Objects
    • 42 - Data Dictionary Introduction - 3:45
    • 43 - Creating Domains - 2:26
    • 44 - Creating Data Elements - 3:15
    • 45 - Creating Tables - 6:29
    • 46 - Creating Structures - 2:54
    • 47 - Creating Internal Tables - 2:43
    • 48 - Creating Views - 3:12
    • 49 - Creating Search Help - 3:22
  • Constants & Literals
    • 50 - Constants and Literals - 3:57
  • Modularization in ABAP
    • 51 - Intro to Modularization in ABAP - 1:16
    • 52 - Macros - 2:01
    • 53 - Include Programs - 6:27
    • 54 - Subroutines - 9:14
    • 55 - Function Groups - 2:51
    • 56 - Function Modules - 7:33
  • Selection Screen Design
    • 57 - Selection-Screen Begin Of Block - 3:38
    • 58 - Selection-Screen Begin Of Screen - 4:08
    • 59 - Subscreen - 5:19
    • 60 - Parameters - 5:56
    • 61 - Checkbox - 1:56
    • 62 - Radiobutton - 2:37
    • 63 - Listbox - 3:16
    • 64 - Select-Options - 3:10
    • 65 - Selection Texts - 2:43
  • ABAP Programming Events
    • 66 - Initialization - 2:33
    • 67 - At Selection-Screen - 2:40
    • 68 - Start of Selection - 1:47
    • 69 - End of Selection - 1:12
    • 70 - Top-Of-Page - 1:25
    • 71 - End-Of-Page - 1:24
  • Processing Statements for Internal Tables
    • 72 - Loop Processing - 6:01
    • 73 - Read Table - 3:46
    • 74 - Insert - 3:56
    • 75 - Append - 4:09
    • 76 - Collect - 3:43
    • 77 - Modify - 4:12
    • 78 - Delete - 4:09
    • 79 - Sort - 3:02
    • 80 - Copy - 4:27
  • Open SQL Overview
    • 81 - Select Statement (Single, Up To…Rows, Where, Select…Endselect ) - 7:01
    • 82 - Insert Statement - 3:54
    • 83 - Update Statement - 5:24
    • 84 - Modify Statement - 5:42
    • 85 - Delete - 5:39
    • 86 - For All Entries in Statement - 3:50
  • Classical Report Programming
    • 87 - Classical Report Programming - 10:28
  • Dialog Programming
    • 88 - Overview - 1:51
    • 89 - Create New Dialog Program - 2:07
    • 90 - Create Screen & Layout & Transaction Code - 7:16
    • 91 - Create GUI Status and Title - 6:19
    • 92 - Processing Input/Output Fields - 2:26
    • 93 - Create Menu and Add Transaction - 1:21
  • ALV Grid Control
    • 94 - ALV Grid Display - 8:06
    • 95 - Field Catalog - 7:57
    • 96 - Layout - 4:07
    • 97 - ALV Listing - 3:27
  • Documentation
    • 98 - Create & Change & Display - 2:29
  • Create New Maintenance Table
    • 99 - Create Table & Technical Settings - 3:18
    • 100 - Table Maintenance Generator - 2:16
    • 101 - Maintenance Table Display and Change Screen - 2:19
    • 102 - Transaction Code For Maintenance Table - 2:33
  • Object Oriented Programming
    • 103 - Build Class - 2:55
    • 104 - Create Method - 6:00
    • 105 - Interfaces - 4:53
    • 106 - Attributes - 2:41
    • 107 - Events - 3:07
    • 108 - Use of Components in Program - 7:09
  • What We Have Learned?
    • 109 - What We Have Learned? - 3:02

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
14

SAP Netweaver ABAP Developer Edition Installation

Set Up a Virtual Machine & Get Your Local SAP System Free with SAP Netweaver ABAP Developer Edition via Ubuntu

By Oak Academy | in Online Courses

Whether you're new to SAP or whether you're using SAP with our SAP Netweaver ABAP Developer Edition course, you'll be able to learn how to set up with Virtual Machines in a very short time, quickly get ABAP program, WebDynpro, BW development environments and start working on these systems. After installation, you will also have the ability to create ODATA services with Netweaver GATEWAY technology, which can be used in SAPUI5 and FIORI developments.

4.5/5 average rating: ★ ★ ★ ★

  • Access 14 lectures & 1 hour of content 24/7
  • Learn how to set up SAP Netweaver 7.50 SP02
  • Set up VirtualBox
  • Install Ubuntu Operating System on Virtual Machine & SAP Netweaver ABAP Developer Edition in Ubuntu Operating System
  • Make backup of the Virtual Server with Export Import method and create a new system
  • Create ODATA services, configure SAP Gateway configuration & much more
Oak Academy | Long Live Tech Knowledge
4.4/5 Instructor Rating: ★ ★ ★ ★
Oak Academy is a group of tech experts who have been in the sector for years and years. Deeply rooted in the tech world, they know that the tech industry's biggest problem is the "tech skills gap" and their online course are their solution. They specialize in critical areas like cybersecurity, coding, IT, game development, app monetization, and mobile. Thanks to their practical alignment, they are able to constantly translate industry insights into the most in-demand and up-to-date courses.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Any device with basic specifications

Course Outline

  • Virtual Machine And Ubuntu Operating System Installation
    • 1 - Virtualization And Virtualization Softwares - 4:20
    • 2 - Downloading Virtualbox And Extention Pack - 4:04
    • 3 - Installing Virtualbox And Extension Pack - 3:59
    • 4 - Downloading Ubuntu Operating System - 2:05
    • 5 - Installing Ubuntu Operating System - 12:28
  • SAP Netweaver ABAP Developer Edition Installation
    • 6 - Java Runtime Environment Installation - 2:25
    • 7 - SAP Netweaver ABAP As 7.50 Sp02 Download - 4:25
    • 8 - File Sharing On Virtual Machine And Configuration Settings - 27:05
    • 9 - ABAP Developer Edition 7.50 SP02 Installation - 11:01
    • 10 - SAPGUI Installation - 8:08
  • SAP Server Basic Information
    • 11 - Opening/Closing SAP Services - 6:51
    • 12 - SAP License Renewal - 4:59
    • 13 - User Operations and Access Key - 8:05
    • 14 - Other Necessary Information And Links Required In The Installation Stage

View Full Curriculum



Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.