Best Oracle Courses

Find the best online Oracle Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings. We also have a separate page listing only the Free Oracle Courses.

Oracle SQL Developer: Mastering its Features + Tips & Tricks

Use Oracle SQL Developer like a Pro: Learn the features & tricks that will help you be the most efficient SQL developer

Created by Carlos from Standout-Dev Academy - Software Development Director & Chief Educator

"]

Students: 70817, Price: $74.99

Students: 70817, Price:  Paid

* List Price temporarily reduced from $74.99 to $19.99

Oracle SQL Developer is currently the most popular tool among database developers and Oracle SQL learners, however, since it makes it so easy to start firing commands and querying a database, many people don't feel the need to investigate its features, and end up using only what is obvious, visible, and enabled by default.

If you are one of them, this course will help you get out of that group and start using Oracle SQL Developer more smartly.

Even if you have some time using the tool and are currently using some of its features, there's most likely something in this course that you don't know and can be helpful to you.

Learn the features that can help you work with your Oracle database better and faster:

  • Install and customize SQL Developer in a way that works and feels best for you.

  • Take full advantage of the most useful features of the tool.

  • Create and share beautiful and interactive reports.

  • Take advantage of features that will make you more effective and efficient at work.

  • Learn a lot of tricks and enjoy being seen as an SQL Developer expert.

All Oracle SQL Developer features are free. Take advantage of them:

This course was created because there appears to be a pattern among Oracle SQL courses and the database community in general: “If you are able to install it and connect to a database, you are good to go".

What's more: Experience shows that even developers who are already working with Oracle databases as part of their job, tend to not look for ways to work faster in SQL Developer, and usually only investigate features they don't currently use when it is strictly necessary for their jobs.

The goal of this course is to fill the gap most SQL courses leave about this great tool so that it can serve as a foundation if you are planning to learn Oracle SQL, and also to help you take advantage of the tool's features if you are already working with Oracle databases as part of your job, so that you can be more efficient and productive, and thus, stand out.

Content and Overview:

The course includes more than 3 hours of content and covers many of the most useful features of SQL Developer.

There is usually one lecture per feature, so, if for any reason you are not interested in any of the included tips, you can simply skip it, and go directly to the one you want to learn about.

The course content will continue to be updated over time, to make sure you always know about the most important features available to you, as new versions of Oracle SQL Developer are released.

Learn these tips and apply them to your work, and you will not only be well prepared to work more smartly and efficiently, but will also enjoy being seen as an experienced and knowledgeable developer by your friends and peers.

Oracle DBA 11g/12c – Database Administration for Junior DBA

Learn to become an Oracle Database Administrator (DBA) in 6 weeks and get a well paid job as a Junior DBA.

Created by Amarnath Reddy - Oracle Architect & Best Selling Instructor | 27000+ Students

"]

Students: 23942, Price: $119.99

Students: 23942, Price:  Paid

Learn to become an Oracle Database Administrator (DBA) in 6 weeks and get a well paid job as a Junior DBA.

'Oracle 11g/12c DBA' course follows a step by step methodology in introducing concepts and Demo's to the students so that they can learn with ease.

If you want to become an Oracle Database Administrator(Oracle DBA), this course is right for you!!!!

Almost in every organization, you will find Database Administrator's (DBA's) to maintain the organization's database. Becoming a good DBA depends on the knowledge you have in the overall architecture of Oracle Database.

In this course, I have covered both Oracle Database 11g and Oracle Database 12c so that you get to know the differences and can work in organizations, who are still in 11g.

Step by Step methodology followed is...

  • Learn the fundamentals of database to set the stage for Oracle Architecture
  • Understand the Process and Memory Architecture (This is important as understanding this will help you solve lot of critical performance issues).
  •  Install Oracle Database 11g & 12c (Manual method and using DBCA)
  • Tablespace management to manage space to store the data.
  • UNDO Tablespace management to manage undo space.
  • REDO Log file management to manage redo space.
  • Manage users and security
  • Networking (Configuring Listeners and TNS entries)
  • Understand various Data dictionary tables/views
  • Diagnose issues using Diagnose data and generate packages for Oracle Support.
  • Backup and Recovery (User Managed)
  • Backup and Recovery (RMAN)
  • Materialized Views
  • Table Partitioning
  • Project Work

Let's start and I will take you step by step to lead your journey into the DBA world!!!

Oracle PL/SQL Fundamentals vol. I & II

A complete introduction to PL/SQL database programming language

Created by Intellezy Trainers - Computer Training Specialists

"]

Students: 23464, Price: $119.99

Students: 23464, Price:  Paid

In this Oracle 11g PL/SQL Bundle you will receive introduction training on PL/SQL database programming language covering syntax, structure and features of the language within the context of database applications and programming. In volume II students will 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).

Oracle SQL Performance Tuning Masterclass 2021

Become an Expert on Oracle SQL Tuning and Solve All The Performance Problems of Your SQL Queries and the Database!

Created by Oracle Master Training • 100,000+ Students Worldwide - Oracle Architect & Best Selling Instructor

"]

Students: 23338, Price: $119.99

Students: 23338, Price:  Paid

Here is the most comprehensive SQL Tuning course that you will not need to take any other courses in anywhere.

This course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge on Oracle SQL Tuning.

The most common problem of working with SQL is, performance problems. Most of the developers don't know how to write well-performing queries. So in time, this problem grows and becomes a problem for both the developer and the company.

This course will teach you how to tune your SQL statements and database step by step for a perfect performance! You will learn how to write fast, reliable, and secure queries. Besides, you will learn the database architecture and will be able to optimize the database workloads.

Once you complete this course, you will recognize the database terms better and will use the most appropriate one for the performance.

Once you complete this course, you will be able to:

  • Find the poorly performing queries

  • Learn Advanced Query Tuning Techniques

  • Understand the Database Architecture to perform Better Tuning Techniques

  • Learn Advanced Indexing Techniques to Maximize Database Performance

  • Learn how to use various Performance Tuning Tools

  • Compare BAD vs GOOD Queries with Hands-on Examples.

  • Gather Statistics for the bad SQLs

  • Interpret the Execution Plans with different methods

  • Choose an appropriate SQL tuning approach

  • Guide the Oracle Optimizer for a better execution

  • Use various tuning techniques like using bind variables, different types of indexes, and much more.

  • Improve the performance of the queries & database

  • Gain Complete Knowledge in Oracle SQL and Performance Tuning!

Briefly, the knowledge of SQL Tuning is a "must" for IT Professionals and this course is the magic pill for that you're seeking for Becoming a Performance Expert!

If you want to step ahead in your career, "SQL & Performance Tuning" should be your next step.

See you in the first lecture!

PL/SQL by Example – Beginner to Advanced PL/SQL

Using PL/SQL learn how to combine the efficiency of SQL & Procedural Language(PL) to build a powerful PL/SQL Application

Created by Amarnath Reddy - Oracle Architect & Best Selling Instructor | 27000+ Students

"]

Students: 20969, Price: $124.99

Students: 20969, Price:  Paid

Learn to become a PL/SQL developer in just four weeks.

This fast, easy and effective course will take you from zero PL/SQL writing skills to being able to write efficient programs to process data.

PL/SQL is the Oracle Procedural Language extension of SQL. A PL/SQL program can have both SQL statements and procedural statements. In the PL/SQL program, the SQL statements are used to access sets of data stored in a database, while the procedural statements are used to process individual piece of data and control the program flow.

In this course participants will learn

  • Describe the features and syntax of PL/SQL
  • Design PL/SQL anonymous blocks that execute efficiently
  • Use the Oracle supplied PL/SQL packages to generate screen output
  • Create and debug Stored Procedures and Functions
  • Design PL/SQL packages to group related constructs
  • Use PL/SQL programming constructs and conditionally control code flow
  • Create overloaded package subprograms for more flexibility
  • Handle runtime errors using Exceptions
  • Writing manageable code using Records
  • Storing and processing data using Collections
  • Processing data using Implicit and Explicit Cursors

Softwares used

  • Oracle Database 11g
  • SQL Developer

Primavera P6 Complete Course of Project Planning 2020

Complete course from program inception to reporting

Created by Prime Project Control - Project Controlling at its Best

"]

Students: 17400, Price: $89.99

Students: 17400, Price:  Paid

Project Management is not complete without a reliable and strong programing tools to develop project plan, logically linking activities, resource loading, project monitoring and reporting.

The strong reliable partner in Planning Software widely used in the world presently is Primavera p6 from oracle. This planning software is widely used across industries from manufacturing, defense, shipping, oil and gas, construction and software development projects.

The course aims to disseminate practical application of Primavera P6 for aspiring project manager, planners, schedulers, project developers and owners. The simplified learning process and methodology adopted by Prime Project Control, takes you on smooth, easy but completely packed  learning experience and ensures that you have acquired most of the practical application of the Primavera P6 software in short course duration.

I wish you to have enjoyable learning experience and pray that you would be successful in your aspirations. Please feel free to write a feedback on the course upon completing.

Best Regards!

Team, Prime Project Control

200+ SQL Interview Questions

Prepare for an SQL Developer Interview with these 200+ Real World SQL Questions and Practical Answers

Created by Amarnath Reddy - Oracle Architect & Best Selling Instructor | 27000+ Students

"]

Students: 12448, Price: $99.99

Students: 12448, Price:  Paid

Are you ready for your SQL Developer Interview?

I have about 15+ years of experience in the Database world and have Interviewed 100’s of SQL Developers in my 15+ years span.

Learning how to answer the SQL interview questions is a powerful skill which can make the difference between getting hired or not.

I have used all my experience to put together this 200+ Real World SQL Questions and Practical Answers. 

I want to help each one of you to succeed in the SQL Job Interview. As part of this, I am providing an opportunity to conduct a Mock Interview to each one of my students.

Become confident and ready to answer the most common SQL interview questions asked during any SQL Developer interview using the points and tips presented in this course.

Nowadays the competition for one job is quite high, many candidates for the same position, so if you want to get hired you cannot afford not being prepared to present yourself as the best fit candidate.

How to answer to the interview questions is one of the area where you can prepare the best, especially when it comes to the most common SQL interview questions because this questions are asked during all job interviews.

By the end of this course, you will know all the great secrets to answer the most common SQL interview questions during any job interview. We will analyse each question and make sure you include in your answer just what is important to present yourself as the best fit candidate.

Are you ready to prepare the best 200+ answers to the most common SQL interview questions?

Take this course and join other 12000+ happy students who learnt to nail any job interview! 

See you inside the course!

Oracle Database Administration for Absolute Beginners

Learn to become an Oracle Database Administrator in a month. It is one of the stable and 'high in demand' IT jobs.

Created by Sam Dhanasekaran - Experienced IT Support and Database Specialist

"]

Students: 7431, Price: $124.99

Students: 7431, Price:  Paid

(Update on 18-Nov-2015 : Added additional lectures to keep this course updated with Oracle 12c Release 2. Also, if you just want to start with some basic theory before doing any hands-on lessons in here, please checkout the Section 'Concepts Illustrated' first.)

'Oracle Database Administration for Absolute Beginners' course explains about the basic concepts of Relational Database Management Systems (RDBMS). It will help you to become an Oracle Database Administrator(Oracle DBA).

Database Administrator is one of the highly sought after jobs in the IT industry. It is also one of the highly stable jobs as DATA is a vital part of every organization and they need that to be in the capable hands of a good DBA team.

This course is absolutely for beginners. This is applicable for those who would want to learn Oracle Database 12c as well as Oracle Database 11g.

This would be ideal for..

  • those who are already in IT and would like to jump into the world of Database Administration.
  • college students who would like to learn about Database concepts so that they can achieve high grades in their RDBMS related curriculum.
  • college students who would like to get into Oracle Database Administration as soon as they finish their college.
  • fresh graduates who are looking for a job in the IT industry.
  • anyone with the determination of getting into IT in order to have a better career.

This course is mainly based on video lectures. However it also has theoretical sections for reference and LAB exercises for hands-on practice.

The course has been structured to start with videos explaining basic database concepts. They provide simplified real world examples.

Then it introduces Oracle Database Architecture. After that, it provides 'hands-on' video lectures about 'How to install Oracle Database 11g in your desktop or Laptop'. (In the bottom, there is also a section about 'How to install Oracle Database 12c' which is the newest version from Oracle as of now, which is Aug 2013).

It then explains about various Oracle Internals such as Storage Structures, Memory Structures, Database Objects etc.

Then it goes into operational aspects such as creating USERS, granting access, creating objects such as tables etc.

After that it explains about Backup/Recovery concepts and Dianostic Data.

Finally, there is a section of extensive video lectures about LAB sessions with examples. You can use those for hands-on practice, using the Database software that you would have installed (as explained in this course) in your PC/Laptop.

I would like to thank you sincerely for reading this and wishing you all the best..!

Sam Dhanasekaran
p.s: This started as YouTube video series. I experimented having my own background music initially. Later I removed the music, based on user feedback. So pardon the background music please :-(

Oracle database utilities – Perform data export / Import

Learn Oracle utilities to move data from one database to another

Created by Arun Kumar - Oracle Certified Expert and Entrepreneur living in India

"]

Students: 3857, Price: $74.99

Students: 3857, Price:  Paid

Master oracle utilities with very simple practice exercise which helps you to move data between two oracle databases. Learn how to use oracle utilities to perform data import export into different databases.

Perform entire database, single table or schema level export and import into another Oracle database

  • Perform table, schema, row level export using traditional Export Import utility
  • Perform table, schema,row level import using traditional Export Import utility
  • Perform CSV file import into Oracle database using SLQ * Loader
  • Perform table, schema, row level export using Oracle Data Pump Export utility
  • Perform table, schema, row level import using Oracle Data Pump Import utility
  • Create Oracle Data Pump directory to perform Export and Import

Oracle Data Pump enables very high speed data movement from one database to another

In general, DBA has to perform data Export and Import in real-time environment in order duplicate table or schema from one database to another. Oracle provides utilities in order to easily move data between two oracle databases.

With over 9 lectures, 6 hands on lab activities and 1.5 hrs of video content, you will learn:

  • How to invoke oracle utilities
  • How to get help for any type of oracle utilities
  • How to import a CSV format file inside Oracle database table
  • How to create SQL * Loader Control File for CSV import
  • How to perform a small table, schema or specific row export using Export Import utility
  • How to perform import of same using Export Import utility
  • How to create Data Pump directory both at OS level and Database level
  • How to perform data Export and Import using high performance Data pump utility

By completing Lab Activities, you will be able to work along with the author and learn Oracle Utilities. You can even download lab activities files and practice on your test machine at home.

Oracle 11g PL/SQL Fundamentals I

An introduction to the PL/SQL database programming language

Created by Intellezy Trainers - Computer Training Specialists

"]

Students: 3389, Price: $89.99

Students: 3389, Price:  Paid

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).

Introduction to Oracle 12c Golden Gate for absolute beginner

Setup your first single table replication using Oracle Golden Gate using the lab setup provided inside the course

Created by Arun Kumar - Oracle Certified Expert and Entrepreneur living in India

"]

Students: 3340, Price: $89.99

Students: 3340, Price:  Paid

Oracle Golden Gate is the best replication technology available in the market. It supports a wide variety of popular database platforms. Oracle Golden Gate being a robust replication technology, makes it A MUST LEARN technology for Database Administrators.

This video course focuses more on practice side of Oracle Golden Gate and is designed specifically for Oracle DBAs.

  • Install and configure Oracle 12c Golden Gate for Oracle database replication
  • Configure unidirectional and bidirectional replication
  • Explain the difference between classic vs integrated capture
  • Improve Golden Gate performance and troubleshoot common issues
  • Configure high availability using Oracle Golden Gate
  • Perform Oracle Golden Gate upgrade
  • Configure Oracle to MYSQL replication
  • Configure MS-SQL Server to Oracle replication
  • Prepare for Oracle Golden Gate interview

This video course is designed for Oracle DBAs who want to lean Oracle Golden Gate for configuring replication or job change but struggles to start learning and prepare a practice environment at home

Oracle 11gR2 RAC – Quick 2-node RAC Deployment Guide

Learn to quickly setup 2-node RAC using VirtualBox, configure shared storage, Install 11gR2 grid and RAC software

Created by Arun Kumar - Oracle Certified Expert and Entrepreneur living in India

"]

Students: 3273, Price: $89.99

Students: 3273, Price:  Paid

Oracle RAC technology is the advance level of database which is designed to provide high availability and scalability. Oracle RAC is installed on multiple servers and it forms the foundation for database cloud.

Build a Strong Foundation in Oracle grid, Clusterware Installation with this Video Course for Beginners.

  • Introduction to clusterware technology
  • Oracle cluster node setup
  • Oracle 11g grid software installation
  • Setup two node RAC
  • Create first Oracle RAC database
  • Oracle RAC and ASM administration

A strong RAC Beginners Course for IT Professionals World Wide!

Oracle RAC allows multiple computers to run Oracle RDBMS software simultaneously while accessing a single database, thus providing clustering. The main aim of Oracle RAC online course is to implement a clustered database to provide performance, scalability and resilience. It’s a clustered version of Oracle Database based on a comprehensive high availability stack

The Oracle 11gR2 Real Application Clusters Administration course describes the Oracle RAC architecture, hands on experience and Oracle Real Application Clusters multi node installations. This course is for people who have prior knowledge on Oracle database administration and covers knowledge on topics like Oracle RAC Cluster, Oracle AMS, Oracle RAC administration, Oracle RAC Installation, Oracle RAC on VirtualBox and many more.

After the completion of Oracle 11gR2 RAC for Beginners Course, you should be able to:

  • Download and install Oracle grid software on Linux
  • Create RAC database on Oracle grid clusterware software
  • Master two node RAC installation
  • Configure Shared storage for two node RAC
  • Setup public and private network
  • Understand ASM instance and ASM disks
  • Perform RAC installation pre-requisites smoothly

Oracle Data Integrator (ODI) 12c Developer Course

Oracle Data Integrator (ODI) 12c Developer Course

Created by Sanjay Singh - Data and Machine Learning Professional

"]

Students: 3072, Price: $99.99

Students: 3072, Price:  Paid

Join the most comprehensive and popular Oracle Data Integrator (ODI) 12c Developer Course on Udemy, because now is the time to get started!

From basic concepts about Data Integration, IntelligenceArchitecture, ODI  Components, Project Development to Migration and Support, this course covers it all you need to know to become a successful ODI Developer

But that's not all! Along with covering all the steps of ODI developer functions, this course also has quizzes and projects, which allow you to practice the things learned throughout the course!

You'll not only learn about the concepts but also practice each of those concepts through Projects.

And if you do get stuck, you benefit from extremely fast and friendly support - both via direct messaging or discussion. You have my word!

With more than two decades of IT experience, I have designed this course for students and professionals who wish to master how to develop and support industry-standard batch integration in Oracle Data Integrator.

This course will be kept up-to-date to ensure you don't miss out on any changes once ODI 12c is required in your project!

Why ODI?

Oracle Data Integrator (ODI) is the integration tool every enterprise need. The key technical capabilities like

  • Extract-Load-Transform (ELT) approach, 

  • Near real-time data integration capability through Change Data Capture(CDC), 

  • Declarative design with fully modifiable Knowledge Modules, 

  • SOA capable through web-services

  • Integration of structured as well as unstructured data

exists only in ODI. It's Oracle's flagship, High-performance bulk data movement and transformation tool. Oracle is investing a lot in this tool.

  • ODI is a built-in batch integration tool for Oracle BI Apps 11g onwards. The current Oracle BI Apps customers will have to replace their existing ETL tools with ODI.

  • The Extract-load-transform(ELT) approach of ODI with a knowledge module based modular approach makes it the most complete and scalable batch integration tool.

If you are looking for a thriving career in data integration and analytics, this is the right time to learn ODI.

Get a very deep understanding of ODI Developer activities

Every new ODI version is coming with added features. The success of ODI implementation and its performance depends on the ODI developer. 

Pay once, benefit a lifetime! This is an evolving course! ODI12c development and later future versions will be covered in this course.  You won’t lose out on anything! Don’t lose any time, gain an edge, and start now!

Oracle SQL Developer for Absolute Beginners

Everything you need to know about Oracle SQL Developer tool

Created by Arun Kumar - Oracle Certified Expert and Entrepreneur living in India

"]

Students: 2950, Price: $94.99

Students: 2950, Price:  Paid

Oracle SQL Developer is a free graphical tool that enhances productivity and simplifies database development tasks. Using SQL Developer, you can browse database objects, run SQL statements, edit and debug PL/SQL statements and run reports, whether provided or created.

Your first step in becoming an Oracle SQL Developer

Developed in Java, SQL Developer runs on Windows, Linux and the Mac OS X. This is a great advantage to the increasing number of developers using alternative platforms. Multiple platform support also means that users can install SQL Developer on the Database Server and connect remotely from their desktops, thus avoiding client server network traffic.

This course provides you with concepts and usages of SQL Developer

  • Download and install SQL developer 18.2 version on windows

  • Connect remote database on cloud and navigate tables inside schema

  • Create table using GUI interface inside SQL Developer

  • Change table definition and modify table constraints

  • Export data from Oracle table to csv fil and much more

You can connect to any target Oracle database schema using standard Oracle database authentication. Once connected, you can perform operations on objects in the database.

200+ PL/SQL Interview Questions

Prepare for an PL/SQL Developer Interview with these 200+ Real World PL/SQL Questions and Practical Answers

Created by Amarnath Reddy - Oracle Architect & Best Selling Instructor | 27000+ Students

"]

Students: 2747, Price: $89.99

Students: 2747, Price:  Paid

Are you ready for your PL/SQL Developer Interview?

I have about 15+ years of experience in the Database world and have Interviewed 100’s of PL/SQL Developers in my 15+ years span.

Learning how to answer the PL/SQL interview questions is a powerful skill which can make the difference between getting hired or not.

I have used all my experience to put together this 200+ Real World PL/SQL Questions and Practical Answers. 

I want to help each one of you to succeed in the PL/SQL Job Interview. As part of this, I am providing an opportunity to conduct a Mock Interview to each one of my students.

Become confident and ready to answer the most common PL/SQL interview questions asked during any PL/SQL Developer interview using the points and tips presented in this course.

Nowadays the competition for one job is quite high, many candidates for the same position, so if you want to get hired you cannot afford not being prepared to present yourself as the best fit candidate.

How to answer to the interview questions is one of the area where you can prepare the best, especially when it comes to the most common PL/SQL interview questions because this questions are asked during all job interviews.

By the end of this course, you will know all the great secrets to answer the most common PL/SQL interview questions during any job interview. We will analyse each question and make sure you include in your answer just what is important to present yourself as the best fit candidate.

Are you ready to prepare the best 200+ answers to the most common PL/SQL interview questions?

Take this course and join other 14000+ happy students who learnt to nail any job interview! 

See you inside the course!

How to become a DBA

Everything you need to know before starting Oracle DBA career

Created by Arun Kumar - Oracle Certified Expert and Entrepreneur living in India

"]

Students: 2741, Price: $94.99

Students: 2741, Price:  Paid

One of the most common questions asked to me still remains same - How can I become an Oracle DBA! After replying to so many emails and helping students over calls, I decided to create this free course on everything you must know in order to become Oracle DBA.

This course is designed to answer all the questions related to Oracle DBA career for freshers who want to become an Oracle dba and for IT professionals who want to switch their career to Oracle DBA.

It all started with digging my old emails and looking for different questions asked by students. Some of the very common questions asked were:

  • I want to become a DBA but I have no experience. How do I become one?

  • What education do I need to become a DBA?

  • What are the courses to be learned to become DBA (data base administrator)?

  • What do I have to learn to become an Oracle DBA?

  • How to search for DBA jobs and apply as a fresher and experienced DBA?

  • I am Confused between oracle DBA or software testing. Please guide!

  • And much more!!

You will know the exact topics, certifications and next steps you must be taking with this one course

No More Google Search For - How to Become a DBA!!

Rather than hunting forums and posting questions on Quora regarding DBA career, this course is enough to take your from the definition of database and average DBA salary to Oracle certifications and learning checklist which you must follow 

Primavera P6: Planning & Scheduling Construction Case Study

Master the Primavera P6 software from Scratch with a Complete Planning & Scheduling Construction case study -Primavera

Created by Construction Project Management Guru (PSP, PMI-SP, PMP) - Promoting Professionalism in Planning and Scheduling.

"]

Students: 2738, Price: $99.99

Students: 2738, Price:  Paid

Primavera P6 is a tool like no other when it comes whenever you think about planning and scheduling. Usually, it is hard to match what you have learned in a course with the REAL LIFE!. Most of the courses out there don't do this - they give you knowledge and you might not know how to use it. This course is different!! It is with a real Construction Case Study from scratch.

No need to do this anymore. The course is created to teach you Primavera P6 with a real life construction case study. Not only that, you will learn the planning and scheduling skills and see how it is applied in Primavera P6. Planning and scheduling is not an easy task, it is one of the most important tasks in the project management. So Is Primavera P6 related with planning and scheduling? Is Primavera P6 related to Project Management? Is Primavera P6 has anything to do with the success of the project?

The answer to all of these questions is YES, YES and YES!!, but how? - Primavera P6 is a tool and you can say it is a smart tool! It is a tool that helps you in the planning and scheduling process of the project. It is an amazing tool when it comes to monitoring and controlling. But, always remember that Primavera P6 is just a tool. To operate this tool you have to know minimum skills for planning and scheduling. So, what does Primavera P6 do? What will you get from such course?

Primavera P6 allows you to organize and manage the project ahead visually. You will breakdown the project into activities and create activity list in the Primavera P6. It allows you to manage the project scope, resources and it is beautiful in illustrating the time claims. Always remember that planning and scheduling is a knowledge area that can be easily represented using an amazing tool such as Primavera P6.

Construction projects are never easy. That's why this course has taken a construction case to carefully study it and make a schedule.

Planning is a vital project phase and it would take an enormous amount of time if it is done manually. Primavera P6 helps you in doing so. You have to understand the main concepts of planning first to plan any project successfully.

The course has taken a construction case example, but you might tailor it to your needs as well. You will get a taste of how planning and scheduling are done in construction projects with a step by step instructions for building a schedule.

A lot of projects if planned correctly will save a lot of time and cost to your organization. Always remember that Primavera P6 is only a tool to apply the planning and scheduling knowledge. This means you have to have a minimum knowledge on planning and scheduling; How to plan for projects.

By the end of the course you will learn that to plan any project successfully you should have a great tool. Primavera P6 is that tool. Primavera P6 helps you in the planning phase of any project. You will also get to know how a construction schedule is created with the minimum data. You will get insights in the construction schedule.

After successful completion of the course, you will be able to create a schedule cost and resource loaded from scratch, monitor the schedule, review a schedule, generate reports, understand planning and scheduling concepts and easily create your own construction schedule.

Planning is a vital project phase and it would take an enormous amount of time if it is done manually. Primavera P6 helps you in doing so. You have to understand the main concepts of planning first to plan any project successfully.

Main Topics: Planning and scheduling using Primavera P6, Construction Schedule, Construction Planning, Construction Scheduling, Construction Plan, Construction time frame, Construction Time Management, Construction Projects, Construction Management, Construction Monitoring, Construction Control, Oracle Primavera, Project Management using Primavera, Primavera P6 Schedule, Planning and Scheduling output, Primavera P6 course, Scheduling with Primavera course, Planning with Primavera course, Oracle Primavera course

Oracle Database: Oracle 12C R2 RAC Administration

Learn Oracle Database, 12C R2 RAC Administration and become a RAC expert with Oracle DBA `s favourite online RAC course

Created by Oak Academy - Web & Mobile Development, IOS, Android, Ethical Hacking, IT

"]

Students: 2571, Price: $94.99

Students: 2571, Price:  Paid

Hello there,

Welcome to "Oracle RAC: Oracle Database 12C R2 RAC Administration" online course.

  • Are you a junior Oracle DBA?

  • Are you DBA who is managing other RDBMS and want to immigrate to Oracle?  or

  • Do you want to become an Oracle DBA at an international company?

If you think so, you are at the right place.

This time I’ve designed for you "Oracle RAC: Oracle Database 12C R2 RAC Administration” straight-forward course for the Oracle Database 12C Release 2 (12.2). In the course, you will have a down-to-earth way explanations with hands-on examples. With my course, you will learn Oracle RAC step-by-step. I made RAC simple and easy with real-life examples.

This course is expertly designed to teach everyone from complete beginners, right through to professionals ( as a refresher). 

In this course you will learn;

  • What is RAC ( Real Application Cluster )

  • Installing Oracle Virtualbox

  • Setting Up Oracle Enterprise Linux

  • Installing Oracle Software

  • Oracle RAC

  • Creating Virtual Machines

  • Installing Oracle RAC Database to VMs

  • Installing Grid Infrastructure, Database Software and Creating Database

  • Administer Database Instances and Cluster Databases

  • Oracle RAC One Node

  • How to Convert RAC Database to RAC One Node

  • Workload Management

  • Monitoring Performance

  • Design and Deployment Techniques

  • Cloning Oracle RAC

  • Managing backup, and restoring cluster database

  • Add and Delete Node From Cluster

Why would you want to take this course?

Our answer is simple: The quality of teaching.

When you enroll, you will feel the OAK Academy`s seasoned developers expertise.

This course will take you from a beginner to a more experienced level.

If you are a DBA or familiar to the Oracle Database / Oracle SQL or if you want to become an Oracle DBA at an international company or

you are a DBA that manage other RDBMS and want to immigrate Oracle or you are already in the field and active RAC user but you just need a refresher, you are also in the right place. You will learn step by step with hands-on examples.

Fresh Content

Oracle RAC is a unique technology that provides high availability and scalability for all application types. It prevents the server from being a single point of failure. But DBAs also should aware of the recent development and it’s no secret how technology is advancing at a rapid rate. New tools are released every day, Oracle updates its system, and it’s crucial to stay on top of the latest knowledge. With this course, you will always have a chance to follow the latest trends.

Video and Audio Production Quality

All our content is created/produced as high-quality video/audio to provide you the best learning experience.

You will be,

· Seeing clearly

· Hearing clearly

· Moving through the course without distractions

You'll also get:

  • Lifetime Access to The Course

  • Fast & Friendly Support in the Q&A section

  • Udemy Certificate of Completion Ready for Download

Dive in now!

We offer full support, answering any questions.

See you in the course!

Oracle 11g Dataguard Administration

Enroll into the course and start learning how to use Oracle Data Guard to achieve highly available Oracle Database!

Created by Arun Kumar - Oracle Certified Expert and Entrepreneur living in India

"]

Students: 2334, Price: $94.99

Students: 2334, Price:  Paid

High availability is becoming very important to every business in the world. Customer demands are increasing day by day and 24/7 availability is what needed. As an Oracle DBA, implementation of high availability features is in high demand.

Master Oracle High Availability Setup using Oracle Data Guard Technology.

  • High availability
  • Types of standby databases
  • Physical standby configuration
  • Troubleshoot data guard
  • Active data guard configuration

Oracle Data Guard is the most powerful skill a DBA can have!

Oracle Data Guard is a technology which helps you protect against planned and unplanned downtime. Master Oracle 11g Data Guard video course teaches you how to implement Oracle Data Guard in real time environment. The course briefly discuss about the need of Oracle Data Guard, Oracle High Availability and how to setup Oracle Data Guard. The course also explores Data Guard architecture, function, different types and more.

Course Content Overview

In over 18 lectures, the course covers implementation of Oracle Data Guard in your existing environment and troubleshoot Data Guard sync related issues. 

Starting with the introduction to Oracle High Availability, this course will provide you foundation for types of Data Guard. With a very good foundation of Data Guard types, you will be able to establish a strong understanding of Oracle Site Failure Technology.

Further, the course will make you master in Physical standby configuration. You will understand production database changes, parameters for production database, cloning production database for standby, enabling data guard services and verifying your data guard setup.

Upon completion of the course, you will be able to even implement Active data guard from physical standby. With working files and scripts, you will be able to setup Data Guard configuration in your PCs.

Learn Oracle PL/SQL – A Comprehensive Training Course

A Comprehensive Oracle PL/SQL Course Taught By Infinite Skills

Created by Infinite Skills - High Quality Training

"]

Students: 2188, Price: $49.99

Students: 2188, Price:  Paid

In this training course by Infinite Skills on Oracle PL/SQL Programming, you will learn how to utilize the procedural language extension for SQL in the Oracle relational database. Lewis Cunningham is one of an elite group of Oracle ACE Directors, and a certified PL/SQL developer. With over 15 years experience modelling, developing and architecting Oracle databases, you are learning from one of the best in the industry.

Starting with the basic outline of what PL/SQL is, you will set the ground work for your knowledge expansion by learning about data types, flow control, errors, and more. You will explore strings, numbers, booleans, and arrays. From there, Lewis jumps into creating programs, using if statements, loops functions, how to handle exceptions, using packages, and even objects. This computer based training tutorial really is an in-depth look at programming with PL/SQL like no other out there!

By the conclusion of this video training tutorial, you will be fully versed in the use of the Oracle PL/SQL for getting the most out of your Oracle databases. Extensive working files are included so you can work alongside the author as he trains you in the use PL/SQL.

OBIEE 12c Developer Course

Business Intelligence, Lifecycle, Architecture, Analysis, Reports, Dashboard, Data Modeling, Admin and RPD Maintenance,

Created by Sanjay Singh - Data and Machine Learning Professional

"]

Students: 1520, Price: $99.99

Students: 1520, Price:  Paid

Join the most comprehensive and popular Oracle Business Intelligence Enterprise Edition (OBIEE) 12c Developer Course on Udemy, because now is the time to get started!

From basic concepts about Business Intelligence, Architecture, Analyses development, Filters,  Selection Steps, GraphsVisualization, Dashboards, Dashboard Links, Prompts, Agents, Add-ons to Data Modelling, Denormalization, Star Schema Modelling, Administration Tool, RPD Download, RPD Upload this course covers it all you need to know to become a successful OBIEE Developer

But that's not all! Along with covering all the steps of OBIEE developer functions, this course has quizzes and projects, which allow you to practice the things learned throughout the course!

You'll not only learn about the concepts but also practice each of those concepts through Projects.

And if you do get stuck, you benefit from extremely fast and friendly support - both via direct messaging or discussion. You have my word!

With more than two decades of IT experience, I have designed this course for students and professionals who wish to master how to develop and support industry-standard business intelligence and data analysis development.

This course will be kept up-to-date to ensure you don't miss out on any changes once OBIEE 12c is required in your project!

Why OBIEE?

Oracle Business Intelligence Enterprise Edition is a leading enterprise Business Intelligence and Analysis software. Oracle is completely focused on keeping its lead and capturing the market by investing a lot in this tool.

  • Oracle has a lot of customers using it's Oracle ERP application. For these customers, OBIEE is the first choice for a Business Intelligence solutions.

  •  Oracle Discoverer is the end of life now. All Oracle Discoverer customers are moving to OBIEE.

  • Oracle is enhancing its packaged business intelligence application (BIAPPS) which is developed on the OBIEE platform.

If you are looking for a thriving career in business intelligence and analytics, this is the right time to learn OBIEE.

Get a very deep understanding of OBIEE Developer activities

Every new OBIEE version is coming with added features. The success of OBIEE implementation and its performance depends on the OBIEE developer. 

Pay once, benefit a lifetime! This is an evolving course! OBIEE12c development and later future versions will be covered in this course.  You won’t lose out on anything! 

Don’t lose any time, gain an edge, and start now!

Oracle 12c Data Guard Administration

Learn to protect your database against planned & unplanned downtimes

Created by Arun Kumar - Oracle Certified Expert and Entrepreneur living in India

"]

Students: 1460, Price: $109.99

Students: 1460, Price:  Paid

Oracle Data Guard is a technology which helps you protect against planned and unplanned downtime. Master Oracle 12c Data Guard video course teaches you how to implement Oracle Data Guard in real time environment. The course briefly discuss about the need of Oracle Data Guard, Oracle High Availability and how to setup Oracle Data Guard. The course also explores Data Guard architecture, function, different types and more.

Enroll into the course and start learning how to use Oracle Data Guard to achieve highly available Oracle Database!

After the completion of the Course, you should be able to:

  • Know the data guard components and different types of standby databases

  • Production server changes for Data Guard

  • Parameter changes for production and standby server

  • Clone production and create physical standby

  • Master how to verify your Data Guard setup

  • Convert Physical Standby into Active Data Guard

  • Managing the Data Guard Configuration

Course Requirements

Basic knowledge of Database AdministrationWindows / Mac / Linux PC, Minimum 16 GB RAM and 100 GB HDD StorageVirtualization software VirtualBox – Create two machines

Learn Oracle 11g – Real Application Clusters

Learn Oracle 11g - Real Application Clusters . A Comprehensive Course From Infinite Skills

Created by Infinite Skills - High Quality Training

"]

Students: 1453, Price: $49.99

Students: 1453, Price:  Paid

This Oracle 11g RAC training course from Infinite Skills explains Oracle's Real Application Clusters (RAC) and provides a detailed look at installing and configuring Oracle's RAC environment. This course is designed for an aspiring Oracle database administrator (DBA) or a currently practicing DBA.


This RAC training course starts out by teaching you the system, Oracle, and host requirements. You then jump right into learning how to install ASM and Grid Infrastructure Software, create disk groups, and tuneing RAC. The course will take you through RAC diagnostics and how to identify potential RAC problems and troubleshoot. He will teach you about the RAC and Cluster utilities, RAC architecture, and how to add and remove nodes.

By the completion of this video based training course, you will have a fundamental understanding of how to install, configure, and maintain Oracle's RAC environment. Working files are included, allowing you to follow along with the author throughout the lessons.

Primavera P6 Professional Training

Primavera P6 Project Management Complete Professional Course For All Levels

Created by Mudessar Afraz - Planning Engineer

"]

Students: 1365, Price: $99.99

Students: 1365, Price:  Paid

Welcome to Primavera P6 Professional online training course. it is focused on practical application of Project Management using Primavera P6.. 

This course is a field oriented course and contains real examples and a full fledge real project for better understanding

This course is so designed that it covers every aspect of implementation. If you are working in large scale firms then you will get a brief concept of how projects are managed there. This Course will make you able to organize projects, control access to projects, organize and control resources and in effectively planning, monitoring and controlling of the project.

Similarly if you are working in a Small Industry or if you are new to Project Management and Primavera, you will get to know all the required core concepts of Project Management along with examples and you will learn their implementation in Primavera P6 from start to end.

By the end of the course you will learn that to plan any project successfully you should have a great tool. Primavera P6 is that tool. Primavera P6 helps you in the planning phase of any project. You will also get to know how a construction schedule is created with the minimum data. You will get insights in the construction schedule

Some Of The Major Topics That We Will Cover In This Course:

· Critical Path Method

· O.B.S And EPS

· Calendar In Primavera

· How to Create Project W.B.S And Activities And How We Can Give Duration To Activities

· How to Give Relationship To Activities

· Type Of Relationships

· How to Schedule The Project

· How to Create And Assign Resources

· How to Create And Assign Baseline

· How to Update The Project

· Resource And Activity Usage Profile

· How to Create Reports

· Global Change

· Material Procurement In Primavera

· How to Generate Financial S Curve In Pirmavera

· Resource Histogram

· Earned Value Management (Very Important)

· Cost Account In Primavera

Master Oracle 11g to 12c Database Upgrade

Learn to perform Oracle database upgrade from 11g to 12c with real-time approach

Created by Arun Kumar - Oracle Certified Expert and Entrepreneur living in India

"]

Students: 1241, Price: $94.99

Students: 1241, Price:  Paid

Master Oracle Database Upgrade course is designed to give knowledge and skills needed to upgrade Oracle databases. As a DBA, its your primary job to upgrade Oracle databases as and when Oracle releases new versions. This course starts with Oracle 11g upgrade and further talks about 11g to 12c upgrade.

The course is mainly designed for working DBAs who are responsible to upgrade databases from 11g to 12c. Right now, as Oracle has released 12c database version, all the companies are moving to 12c Database version. This directly impacts DBAs where they have to showcase skills and upgrade the environment.

Learn Oracle 11g – A Comprehensive Training Course

A Comprehensive Oracle 11g Course Taught By Infinite Skills

Created by Infinite Skills - High Quality Training

"]

Students: 1085, Price: $49.99

Students: 1085, Price:  Paid

This Oracle 11g video based training course from Infinite Skills will teach you the basics of operating an Oracle Database server and environment. You will also discover the basics of how to manage and develop for an Oracle Database, and administer one.

This tutorial is designed for the beginner. This training will teach you the basics of what it means to administer an Oracle Database. Throughout the training, you will be able to better understand the path you can continue on from here, whether that is to become a DBA, developer or administrator of Oracle Databases. You will learn about processes and architectural concepts of a database. This video training also covers topics such as storage, data modelling, basic SQL, database tasks, and how all of these apply specifically to Oracle Databases.

By the completion of this video tutorial, you will have a fundamental understanding of how an Oracle Database server and environment function, as well as how database concepts apply specifically to an Oracle Database. Working files are included to assist you as you work through this computer software training course.

OBIEE 12c Data Modeling Course

Data Modeling, RPD, Physical, BMM, and Presentation layer, Logical Dimensions and Hierarchies, Measures, Analysis

Created by Sanjay Singh - Data and Machine Learning Professional

"]

Students: 1073, Price: $94.99

Students: 1073, Price:  Paid

Join the most comprehensive and popular Oracle Business Intelligence Enterprise Edition (OBIEE) 12c Data Modeling Course on Udemy, because now is the time to get started!

From basic concepts about Data Modelling, Denormalization, Star Schema Modelling, Administration Tool, RPD Download, RPD Upload to building each layer -Physical, Business Model and Mapping (BMM), and Presentation Layer- this course covers it all you need to know to become a successful Data Modeler

But that's not all! Along with covering all the steps of Data Modeling functions, this course has quizzes and projects, which allow you to practice the things learned throughout the course!

You'll not only learn about the concepts but also practice each of those concepts through Projects.

And if you do get stuck, you benefit from extremely fast and friendly support - both via direct messaging or discussion. You have my word!

With more than two decades of IT experience, I have designed this course for students and professionals who wish to master how to develop and support industry-standard OBIEE Data Model.

This course will be kept up-to-date to ensure you don't miss out on any changes once Data Modelling is required in your project!

Why OBIEE?

Oracle Business Intelligence Enterprise Edition is a leading enterprise Business Intelligence and Analysis software. Oracle is completely focused on keeping its lead and capturing the market by investing a lot in this tool.

  • Oracle has a lot of customers using its Oracle ERP application. For these customers, OBIEE is the first choice for Business Intelligence solutions.

  •  Oracle Discoverer is the end of life now. All Oracle Discoverer customers are moving to OBIEE.

  • Oracle is enhancing its packaged business intelligence application (BIAPPS) which is developed on the OBIEE platform.

If you are looking for a thriving career in business intelligence and analytics, this is the right time to learn OBIEE.

Get a very deep understanding of OBIEE Data Modeling activities

Every new OBIEE version is coming with added features. The success of OBIEE implementation and its performance depends on  OBIEE Data Modeler. 

Pay once, benefit a lifetime! This is an evolving course! OBIEE 12c RPD  and later future versions will be covered in this course.  You won’t lose out on anything! 

Don’t lose any time, gain an edge, and start now!

Oracle Data Integrator (ODI) 12c Admin Course

ODI 12c Admin Course-Architecture, Enterprise Installation, Maintenance, and Support

Created by Sanjay Singh - Data and Machine Learning Professional

"]

Students: 1022, Price: $49.99

Students: 1022, Price:  Paid

Join the most comprehensive and popular ODI Admin Course on Udemy, because now is the time to get started!

From Architecture, Installation, Agents, Topology, Security to Project Execution this course covers it all you need to know to become a successful ODI Admin

You'll learn all about Architecture, ODI ComponentsRepositoriesDomainsFusion MiddlewareWebLogic Server, Topology, - and in the end: You'll have a project to ensure all the components are installed and configured properly!

But that's not all! Along with covering all the steps for ODI  Admin functions, this course also has quizzes and projects, which allow you to practice the things learned throughout the course!

And if you do get stuck, you benefit from extremely fast and friendly support - both via direct messaging or discussion. You have my word!

With more than two decades of IT experience I have designed this course for students and professionals who wish to learn (or need support) how to install fully functional Enterprise level Oracle Data Integrator with all its components and support its execution.

This course will be kept up-to-date to ensure you don't miss out on any changes once ODI 12c is required in your project!

Why ODI?

Oracle data integrator is Oracle's flagship, High-performance bulk data movement and transformation tool. Oracle is investing a lot in this tool.

  • ODI is a built-in batch integration tool for Oracle BI Apps 11g onwards. The current Oracle BI Apps customers will have to replace their existing ETL tools with ODI.

  • The ELT approach of ODI with a knowledge module based modular approach makes it the most complete and scalable batch integration tool.

If you are looking for a thriving career in data integration and analytics, this is the right time to learn ODI.

Get a very deep understanding of ODI Admin activities

Every new ODI version is coming with added features. The success of ODI implementation and its performance depends a lot on how  ODI Admin has installed and configured it. 

When installing ODI 12c at the enterprise level, Oracle recommends Enterprise installation with Web logic server, Managed ODI Server, and either Standalone collocated agent or JEE agent as they provide high availability and other benefits of Fusion Middleware. This course covers all that you need to know to successfully install ODI for your project. You will go through instructions in the video as well as a pdf document with each step shown in the video. 

Pay once, benefit a lifetime!
This is an evolving course! Enterprise installation of ODI 12c and later future versions will be covered in this course.  You won’t lose out on anything!
Don’t lose any time, gain an edge, and start now!

This course will also be updated to Oracle Data Integrator (ODI) Enterprise Installation on Linux platform!

Learn SQL For Oracle Databases – Using Toad From Scratch

Learn how to communicate with oracle databases using Toad for Oracle . Learn how to create,read,update and delete data.

Created by Skill Tree - Skill based learning

"]

Students: 925, Price: $109.99

Students: 925, Price:  Paid

What is this course about?

This course teaches how to use SOL to communicate with Oracle database using Toad for Oracle editor.

What Kind of Course material is included?

All the contents are video based there are 38 video lectures that includes :

  • Database Concepts
  • SQL Sub Languages (DDL,DML)
  • Data Types and Constraints(Varchar2,Number,Date,NOT Null,Primary Key)
  • Reading ,Limiting and Sorting Data
  • Table Joins (Extract data from several tables)
  • Aliases
  • Functions (Character,Group).

How Long is this course?

The course is approximately four hours long and is structured in a logical easy to follow functional way .

Why take this course?

Taking this course will give you a well sort after skill that will last many years. Databases are vital and to have the skill to talk to them is invaluable.

Primavera p6 Learn to Create Complete Schedule Through B.O.Q

Create Complete Project Schedule From Bill Of Quantity (B.O.Q) By Using Primavera p6 And Microsoft Excel

Created by Mudessar Afraz - Planning Engineer

"]

Students: 650, Price: $24.99

Students: 650, Price:  Paid

Updated On 28-10-2019

Welcome to Primavera P6 Learn to Create Complete Schedule Through B.O.Q online training course. it is focused on practical application of Project Management using Primavera P6 & M.S Excel 

This course is a field oriented course and contains real examples and a full fledge real project for better understanding

This course is so designed that it covers every aspect of implementation. If you are working in large scale firms then you will get a brief concept of how projects are managed there. This Course will make you able to organize projects, control access to projects, organize and control resources and in effectively planning, monitoring and controlling of the project.

Similarly if you are working in a Small Industry or if you are new to Project Management and Primavera, you will get to know all the required core concepts of Project Management along with examples and you will learn their implementation in Primavera P6 from start to end.

By the end of the course you will learn that to plan any project successfully you should have a great tool. Primavera P6 is that tool. Primavera P6 helps you in the planning phase of any project. You will also get to know how a construction schedule is created with the minimum data. You will get insights in the construction schedule

After successful completion of this course, you will be able to

  • Work On Primavera

  • Work On M.S Excel

  • Create Activity List In Excel

  • Read And Understand B.O.Q

  • Create W.B.S According To B.O.Q Or CSI

  • Create Cost Loading Sheet In Excel

  • Import Cost And Activities From Excel To Primavera

  • Link Complete Activities In Schedule

  • Calculate Manpower Base On Productivity

  • Import And Assign Resources To Activities 

  • Create Shop Drawing Submittal And Approval In Primavera

  • Create Material Submittal And Approval In Primavera

  • Create Shop Drawing Log And Material Tracking Chart In Excel

  • Estimate Daily Manpower In Excel

  • Review Primavera Time Schedule

Hope You Will Enjoy This Course