Logo
    Search

    Oracle University Podcast

    Oracle University Podcast delivers convenient, foundational training on popular Oracle technologies such as Oracle Cloud Infrastructure, Java, Autonomous Database, and more to help you jump-start or advance your career in the cloud.
    enOracle Universtity58 Episodes

    Episodes (58)

    An Overview of ERP Business Processes

    An Overview of ERP Business Processes
    Inside every successful corporation is a well-oiled financial team working to do what is in the best interest of the company. From the CFO to the finance intern, having a system of modern best practices and a comprehensive suite of financial solutions, properly utilized, is more important than ever before.
     
    Join hosts Lois Houston and Nikita Abraham, along with Sr. Principal ERP Learning Strategist David Barnacle, as they introduce you to the Oracle Cloud Enterprise Resource Planning suite and the key business processes within it.
     
    Oracle University Learning Community: https://education.oracle.com/ou-community
     
    Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, Parvathy Narayan, and the OU Studio Team for helping us create this episode.
     
    ---------------------------------------------------------
     
    Episode Transcript:

    00:00

    Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let’s get started.

    00:26

    Lois: Hello and welcome to the Oracle University Podcast. I’m Lois Houston, Director of Innovation Programs with Oracle University, and with me is Nikita Abraham, Principal Technical Editor.

    Nikita: Hi everyone! A few weeks ago, we concluded our spotlight on HCM business processes. And today, we’re going to move on to ERP business processes. ERP, as you may already know, is Enterprise Resource Planning. And to take us through this, we have David “Barney” Barnacle, our Sr. Principal ERP Learning Strategist. For over 20 years, Barney has successfully trained customers in the rapid configuration and effective use of Oracle Applications. Welcome Barney! We’re so glad to have you here today.

    01:10

    Barney: Thank you! Happy to be here.

    Lois: In previous episodes this season, we’ve spoken about the business process training that Oracle has. But from an ERP point of view, can you briefly tell us what it is and why we have it?

    Barney: Sure, Lois. Inside every successful corporation is a well-oiled financial team working to do what is in the best interest of the company. From the CFO to the financial trainee, everybody within an agile, innovative enterprise will be using modern best practice processes within a complete and fully integrated suite of SaaS applications.

    That’s why we have Oracle Business Process Training for Oracle Fusion Cloud: ERP. It’s a powerful training solution that gives users and companies a solid understanding of how Oracle ERP solutions work together to ensure effective and efficient transaction processing.

    02:06

    Nikita: Now that we know why we have this training, let’s get down to it. Barney, what is ERP?

    Barney: Enterprise Resource Planning or for short as it’s known, ERP, is a system or a collection of systems that companies use to manage day-to-day business activities efficiently. The ERP system brings together different dimensions of businesses from financials, procurement, risk and compliance, to enterprise performance management, and Oracle Fusion ERP analytics.

    ERP systems tie together several business processes and seamlessly allow data to flow between them. By collecting an organization’s shared transactional data from multiple sources, ERP systems eliminate data duplication and provide data integrity with a single source of truth.

    03:00

    Barney: Today, ERP systems are critical for managing thousands of businesses of all sizes and across all industries. For these companies, ERP is as indispensable as the electricity that keeps the lights on.

    Remember, simply, ERP is the vehicle for integrating people, processes, and technologies across a modern enterprise.

    03:27

    Lois: Barney, in the world of various ERP systems, how is the Oracle Cloud ERP application suite unique? And how is it structured?

    Barney: Thanks, Lois. Oracle Cloud ERP is a cloud-based SaaS (Software as a Service) application, or group of applications, that provides end-to-end business solutions. These solutions, in turn, enable businesses to significantly cut down costs, improve their process efficiencies, and enhance collaboration.

    Oracle Cloud ERP is classified into six different product families. We have Financial Management, Procurement, Project Management, Risk and Compliance, Enterprise Performance Management (EPM), and finally Enterprise Resource Planning Analytics.

    04:14

    Lois: So as I understand it, we have Oracle Cloud ERP, a modern cloud-based software application, and then have Oracle Financials, Procurement, EPM, and so on within the Oracle Cloud ERP suite, right?

    Barney: Correct. That’s right, Lois.

    Nikita: That’s quite an interesting mix of product families. Can you tell us about each of these products, Barney?

    04:35

    Barney: Sure can. Let’s start with Financials.

    Oracle Cloud Financials is a global financial platform that connects and automates your financial management processes, including payables, receivables, fixed assets, expenses, GL, and reporting, for a clear view into your total financial health.

    04:56

    Barney: Next is Oracle Cloud Procurement, an integrated source-to-settle suite that automates business processes, enables strategic sourcing, improves supplier relationship management, and simplifies buying.

    Then we have Project Management.

    Oracle Project Management helps you plan and track your projects, assign the right talent, balance capacity against demand, and scale resources up or down quickly as needs change.

    05:27

    Barney: Then there’s Risk and Compliance.

    Oracle Cloud Risk and Compliance Management is a security and audit solution. It controls user access to your Oracle Cloud ERP financial data, monitors users’ activity, and makes it easy to meet compliance regulations through automation.

    05:45

    Nikita: Interesting. And these pillars are connected to one another?

    Barney: Yes, Niki. One of the biggest advantages of choosing the Oracle Cloud ERP solution is its ability to integrate all the product offerings that come under it.

    Now, getting back to the product pillars in the ERP suite, we have Enterprise Performance Management.

    With this, you can model and plan across Finance, HR, Supply Chain, and Sales. You can streamline the financial close process and drive better decisions.

    06:18

    Barney: And closing out the list, we have ERP Analytics.

    Oracle Fusion ERP Analytics is a prebuilt cloud-native solution for Oracle Cloud ERP. It helps financial and procurement professionals uncover underlying drivers of profitability, improve the use of working capital, and control business expenditures. Oracle’s unique application capabilities enable organizations to unify financial analytics across different departments.

    So those are the six product families that make up the Oracle Cloud ERP.

    06:56

    Lois: I think that’s what all organizations want, right? A comprehensive solution to help them meet their business needs. But how do organizations that have legacy ERP systems and processes move to the Oracle Cloud ERP systems? Do they need to completely switch over? And what happens to the existing processes they’ve been following?

    Barney: Yes Lois, they can co-exist. But you can implement just one cloud product, such as expenses or revenue management, to enhance the existing or current business processes. You can then have several step-by-step projects to move different business processes to the cloud – until you are 100% cloud.

    07:37

    Nikita: So, within the ERP suite, we’d like to learn more about Oracle Cloud Financials. Can you tell us about the types of organizations that would benefit from using Oracle Cloud Financials?

    Barney: Sure, Niki. So like I was saying before, Oracle Cloud Financials gives you a complete view of the overall financial health of your organization by connecting data and process automation in payables, receivables, fixed assets, expenses, GL, and reporting. It also helps organizations respond quickly to an everchanging environment and deliver decisive insights as needed. It is a comprehensive global solution designed for organizations of every size and industry.

    08:20

    Lois: Barney, a typical organization will have various transactions and processes that have a direct impact on their financial balance, right? Everything from financial accounting, transaction processing, payment delivery, and cash reconciliation, to employee expense processing, and even asset management. How does Oracle Cloud Financials process all these activities or functions?

    08:41

    Barney: Good question, Lois. Oracle Cloud Financials has several modules to help businesses handle all the processes you’ve just mentioned. Let’s say procuring items, creating invoices, and making payments to suppliers are the typical day-to-day activities of a manufacturing organization. In Oracle Cloud Financials, the process of invoice to payment is handled by Oracle Payables and Payment tasks, which provide streamlined and user-friendly interfaces for Payables professionals to efficiently manage the Supplier Invoice to Payment process.

    09:18

    Barney: Let me give you another example. Every organization will have employees submitting their expenses for approval and payout. These expense-related activities are handled by Oracle Expenses. Oracle Expenses gives your organization the tools it needs to effectively manage the travel and expenses process. You can simply start the whole process by uploading a copy of your expense receipt using the expenses mobile app.

    09:46

    Lois: So, it looks like every financial end-to-end process in an organization is represented in Oracle Financials.

    Barney: Yes. Let’s take Oracle Receivables. It provides streamlined and user-friendly interfaces for Receivables professionals to efficiently manage the credit-to-cash process. You can use it to proactively manage the entire cycle of billing customers and processing customer payments. 

    10:11

    Barney: When you deal with cash that needs to be received from customers in a very large organization, it’s important that you understand these customers well and build a good relationship with them. And to do this, many organizations hire specialists called collection agents. Oracle Advanced Collections is designed for these collection agents. For anyone who doesn’t know, collection agents are basically those responsible for working with late or nonpaying customers to resolve payment issues and remove non-payments.

    10:43

    Nikita: That can be quite problematic, right? I’m sure any delays in payment from customers would cause cash flow problems for a company.

    Barney: Exactly. And so Advanced Collections is the critical final step in the credit/billing-to-collections business process, where the aim is to reduce delinquent customers, encourage prompt customer payment, and minimize the company Days Sales Outstanding. For those who don’t know, Days Sales Outstanding is the average number of days it takes a company to receive payments for a sale.

    11:19

    Did you know that Oracle University offers free courses on Oracle Cloud Infrastructure? You’ll find training on everything from cloud computing, database, and security to artificial intelligence and machine learning, all of which is available free to subscribers. So, get going! Pick a course of your choice, get certified, join the Oracle University Learning Community, and network with your peers. If you’re already an Oracle MyLearn user, go to MyLearn to begin your journey. If you have not yet accessed Oracle MyLearn, visit mylearn.oracle.com and create an account to get started. 

    11:58

    Nikita: Welcome back. We were just going through the various modules within Oracle Financials. So far, we’ve covered Payables and Payments, Expenses, Receivables, and Advanced Collections. What other modules are there, Barney?

    Barney: We have Oracle Assets, which is a complete asset management solution.

    Nikita: So assets like property… equipment…

    Barney: Exactly. Yes, and Oracle Assets helps you maintain your assets accurately. It supports the end-to-end asset life cycle from asset acquisition to retirement, i.e. from capture to retire. Also, if you do not directly acquire or buy the assets outright, we have a product called Lease Accounting, which covers all the accounting entries for leased assets.

    12:45

    Nikita: Ok. And what else?

    Barney: We also have Oracle Cash Management, tax engines, subledger accounting, intercompany engines, and general ledger.

    Nikita: Can you quickly run us through these modules?

    Barney: Sure. Oracle Cash Management is a comprehensive business solution that helps you optimize enterprise-wide liquidity and control cash. Tax engine is used to calculate transactional taxes based on business, products, places, and country rules. For example, when to use sales tax as opposed to when to use value added tax or VAT.

    13:19

    Barney: Oracle Subledger Accounting is a powerful, rules-based accounting solution that provides consistent accounting treatment for financial transactions created across Oracle Cloud applications. The intercompany engine is used to automatically balance journals that are between different organizations. For example, a central management fee charged annually between the organization’s headquarters and each of its subsidiaries. In the cloud, with intercompany, you can have up to three balancing segments. However, the primary balancing segment is still used to identify the company or fund holder.

    13:59

    Barney: Then we have Oracle General Ledger.

    Oracle General Ledger is the central repository of accounting information. It provides highly automated financial processing, effective management control, and real-time visibility into financial results.

    14:16

    Lois: Before you continue, Barney, can you tell us what a general ledger system does? How is it different from subledger accounting?

    Barney: Sure, Lois. The main purpose of a general ledger system is to record the financial activities of a whole company and produce financial and management reports to help people inside and outside the organization make decisions.

    14:38

    Barney: Subledger journals can provide the detail and a fully auditable path back to the source transaction that created the accounting entry.

    This single source of subledger accounting detailed data is often summarized into account balances when transferred across to general ledger. It is these summarized GL account balances that will drive real-time financial reporting using the various cloud reporting tools.

    15:04

    Lois: Ok. So, you’ve told us about the modules within the Oracle Cloud Financials suite that capture different types of transactions. For Oracle Fusion Cloud users, what’s the quickest way to uncover business insights and deliver financial improvements to their enterprise?

    Barney: To identify underlying drivers of profitability, improve the use of working capital, and control business expenditures, we have Oracle Fusion Cloud ERP Analytics. This is an analytics-based, state-of-the-art, technology-driven tool that provides you with the organization’s financial status at any given point. Financial Reporting and Analytics helps you speed up your decision-making process with graphical insights, configurable analytics dashboards, and event-based delivery of information so you can take targeted actions.

    15:56

    Lois: That’s interesting. Thanks for that, Barney. That was a lot for me to take in, but it’s very insightful.

    Nikita: Yes, it was. Getting back to some of the processes you mentioned, like the Expense Report process or the Supplier Invoice to Payment process, can you give us an overall picture of how these processes are fulfilled within the Oracle Cloud Financials function?

    16:17

    Barney: Absolutely. At Oracle, we can map these different processes to the Oracle Financials Business Process Model. This model refers to the end-to-end business processes enabled by Oracle applications to record financial data and derive reports for efficient and successful business performance.

    There are key business processes in this model.

    16:42

    Nikita: I know you’re going to be joining us in upcoming episodes to talk about each of these business processes, but can you briefly tell us about them?

    Barney: Sure, Niki.

    Let’s start with the process that records cash inflow into an enterprise. Invoice to Cash refers to the cycle of events captured in the system, starting with recording customer invoices for goods and services provided, processing customer receipts based on the terms of payment, and reconciling receipts with bank statements and customer account balances with the Account Receivables ledger balances.

    17:15

    Barney: Then, we have the major processes that cause an outflow of cash from the enterprise. Procure to Pay involves recording the journey of transactions, from requisitioning and procuring goods and services from the supplier to receiving them at their destination and the ultimate entering of supplier invoices and payments.

    Asset to Retirement empowers organizations to manage the entire financial cycle of assets, including acquisition, capitalization, depreciation, and the ultimate retirement.

    17:46

    Barney: Accounting Transformation is the process of converting transactions or activities from subledgers to journal entries to meet corporate needs and statutory or legal reporting.

    And finally, Budget to Report covers the entire process of creating budgets, capturing actuals, and conducting budget reporting and variance analysis.

    18:08

    Lois: Each of these business processes has users with various job roles working on the application, right? They’ll be taking action… providing input… So how does Oracle Cloud Financials define these job roles in the application?

    Barney: Well, in small or medium-sized companies, the financial functions may be the responsibility of a single accountant. But in large organizations, there is going to be a financial team, where the job roles are specialized, often focused on a particular business task or function.

    18:43

    Barney: The responsibility for these roles are often grouped into three main categories.

    We have the Specialist or Clerk, who is responsible for a specific group of tasks. For example, creating payments or reconciling bank statements. Then we have the Supervisor, who is responsible for managing the specialist executing the specific business tasks. And finally, we have the Managers or Manager, who is responsible for managing the team to meet company objectives.

    19:15

    Barney: When we’re talking about the business processes I mentioned earlier, each of them are performed by different job roles. For example, for the Invoice to Cash business process, we have the Billing Specialist and Billing Managers, Collection Agents, and Cash Manager. For Procure to Pay, we have the Accounts Payable Specialist and Supervisor. Asset to Retirement, there’s the Asset Accountant and Asset Accounting Manager. The Accounting Transformation business process is usually managed by any role assigned SLA privileges. And finally, for Budget to Reporting, we have the General Accountant and General Accounting Manager.

    19:55

    Nikita: Thank you so much, Barney, for giving us this thorough introduction to Oracle ERP, and particularly Oracle Financials Cloud.

    Barney: Thanks, Niki. It was a pleasure to be here.

    20:05

    Lois: We’re looking forward to having you back on the podcast next week to talk about the first of the five main Financials business processes, the Invoice to Cash process flow. And to learn more about these business processes and get certified, visit mylearn.oracle.com. Until next time, this is Lois Houston…

    Nikita: And Nikita Abraham, signing off!

    20:27

    That’s all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We’d also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

    AI for Everyone

    AI for Everyone
    Want to get on the AI train? Then this is the episode for you! Join Lois Houston and Nikita Abraham, along with Rohit Rahi, Vice President, CSS OU Cloud Delivery, as they explore Oracle University’s new OCI AI Foundations course. They talk about what the course covers, who it’s for, and the associated certification.
     
    Oracle MyLearn: mylearn.oracle.com/
    Oracle University Learning Community: education.oracle.com/ou-community
     
    Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, and the OU Studio Team for helping us create this episode.
    Oracle University Podcast
    enOctober 17, 2023

    Applied Learning for Oracle Cloud Applications

    Applied Learning for Oracle Cloud Applications
    Wouldn’t it be great if you could practice your Oracle Cloud Apps implementation in a safe, controlled lab environment? Well, now you can!
     
    Join Lois Houston and Nikita Abraham, along with Bill Lawson, as they discuss the new Applied Learning for Fusion Cloud Applications Implementation projects, which provide practical use cases and business scenarios that you can work through to apply the concepts you’ve learned and expand your skills.
     
    Oracle University Learning Community: https://education.oracle.com/ou-community
     
    Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, Sujatha Kalahasthi Raju, and the OU Studio Team for helping us create this episode.
     
    --------------------------------------------------------
     
    Episode Transcript:
     

    00:00

    Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let’s get started.

    00:26

    Nikita: Hello and welcome to the Oracle University Podcast. I’m Nikita Abraham, Principal Technical Editor with Oracle University, and with me is Lois Houston, Director of Innovation Programs.

    Lois: Hello everyone! In our last episode, we spoke about HCM business processes and learned about the Talent Life Cycle. Today, we’re going to take a look at some related training that’s just launched in our Cloud Learning Subscriptions. This new training was developed based on requests from our customers and partners. You asked, and we listened.

    00:58

    Nikita: We’re joined by Senior Director of Cloud Applications Product Management, Bill Lawson, who you’ve heard from before, and he will be telling us all about this exciting new program.

    Lois: Bill, we’re so happy you’re back with us today. So, as I mentioned, this new program was a direct result of customer and partner feedback. Can you tell us a little bit more about how that happened and what this new training is all about?

    01:20

    Bill: I’m happy to be back as well, Lois. And very excited to share details about the Applied Learning for Fusion Cloud Application Implementation projects that are now available.

    And you’re correct. This was in direct response to requests we received from our customers and partners. As you’re aware, we hold quarterly feedback sessions with some of our strategic partners and customers, and one thing we heard was the need to have some practical applications of concepts learned in our implementation courses.

    01:46

    Bill: So, we got our subject matter experts on the task and challenged them with creating some real-world scenarios that students can work through in our hands-on lab practice environments. In these scenarios, students will work their way through examples of some of the decisions and configurations that they and customers might need to go through in an implementation of Oracle Cloud Applications.

    It’s a great way to expand your skills and apply the concepts you’ve learned in implementation classes in a safe, controlled lab environment. Then, you can take that back to your workplace and apply that knowledge in your own implementation projects.

    02:19

    Nikita: Wow, that’s really cool, Bill. And how exciting that we’re taking feedback directly from our customers and developing the training that they are asking for.

     

    Bill: Yes, Niki, it is. And we’re planning to continue that listening program in our Oracle University Learning Community. We’ve launched an Idea Incubator and we’re looking forward to hearing from our members about their content ideas and suggestions. Who knows what new types of courses will come out of that?

     

    02:43

     

    Lois: It’s another great reason to join the Community for sure.

     

    Bill: Indeed, it is.

     

    Nikita: Ok, Bill, back to the Applied Learning for Fusion Cloud Application Implementations program. Who is this training best suited for?

     

    Bill: Well, Niki, it’s really aimed at those people who are going to be actively involved in an Oracle Cloud Apps implementation. So, your solution consultants, implementers, administrators, project teams, etc. etc.

     

    03:07

     

    Nikita: And can you give us an example of what one of these projects looks like?

     

    Bill: I sure can, Niki. 

     

    One of the new Applied Learning Implementation projects is centered around Fusion Enterprise Structures & General Ledger in the ERP space.

     

    In the project scenario, we follow a fictional company, which is a startup that has decided to implement Oracle Fusion Cloud Financials to streamline their business processes while taking advantage of the latest functionality Oracle Cloud Applications has to offer.

     

    The case study outlines the business requirements of the company and then provides a challenge to the learner. The student must determine how these requirements would be met within the application, complete the setup and configuration, and validate that they’ve done it correctly.

    03:48

     

    Lois: That’s really neat. So essentially, it’s mimicking a business scenario that you may come upon in a conference room pilot during an implementation and would have to configure using Fusion Applications.

     

    Bill: Right, Lois. Providing a practical business scenario based on the customers’ requirements for the student to configure a solution in a safe practice environment. The student will be prepared to tackle the scenario based on the foundation of knowledge they’ve gained when they completed the implementation learning path training in the learning subscription or during their previous implementation experience.

     

    04:22

     

    Have an idea for a new course or learning opportunity? We’d love to hear it! Visit the Oracle University Learning Community and share your thoughts with us. Your suggestion could find a place in future development projects. If you’re already an Oracle MyLearn user, go to MyLearn to join the community. You will need to log in first. If you’ve not yet accessed Oracle MyLearn, visit mylearn.oracle.com and create an account to get started. 

     

    04:51


    Nikita: Welcome back. Ok, Bill, so the students do this setup. How do they know it was done correctly? What if they get stumped and don’t know what to do?

     

    Bill: If they’re completely stumped, then it’s probably a good indication that they need to revisit the training and check that they understand the core concepts.

    But once they’ve completed the challenge, there will be a solution video in which our SME will walk through one of the possible solutions. Bear in mind, there may be more than one solution that is possible. We will show one possibility, but learners may opt for a different route when they approach the challenge. And that’s ok. We want people to be able to explore the options and learn while they’re doing so.

     

    05:28


    Lois: And all of this is done within MyLearn and the lab environments provided to our learning subscribers, right?

     

    Bill: That’s correct, Lois. This content is available to our MyLearn subscribers. The projects are included as part of the Cloud Applications Implementation training. So, if you go to mylearn.oracle.com and search by the phrase “Applied Learning,” you will find all the applicable learning. You can also search by “Implementer” to see the Implementation training that is available. Applied learning projects will be part of this implementation training. The content is available on a paid subscription basis only, but very well worth the investment if you’re in the middle of an Oracle Cloud Apps implementation. If you already have a subscription, you can dive right in and give one of our projects a try.


    06:12

     

    Nikita: Bill, where are these Applied Learning scenarios found? Is it only for General Ledger?

     

    Bill: No, Niki, it’s not. We’ve got Applied Learning projects available for 10 of our most popular product areas, such as General Ledger, Payables, Receivables, Project Management, Accounting Hub, Global Human Resources, Talent Management, Recruiting, Inventory, and Procurement.

     

    Lois: So, we’re covering all the bases here – ERP, SCM, HCM…

     

    Bill: Exactly.

     

    06:42

    Lois: Is there anything else we should know about the Applied Learning program?


    Bill: Well funny you should ask, Lois, because one of the unique things we’re doing with this new program is we’re offering the opportunity to engage with other people who are completing the project via a discussion in the Oracle University Learning Community.

     

    Lois: You knew that was a loaded question, right?

     

    Bill: Haha, I sure did. You’re the champion of our Community.

     

    So, in the Community, people can ask questions, share their solutions, and more. It’s a great way to expand the learning experience and see how other people approached those same scenarios based on their knowledge and experience.

     

    07:13

    Nikita: And if people have ideas for other Applied Learning scenarios, what should they do?

     

    Bill: They can always suggest those in the Idea Incubator in the Community, Niki.

     

    Lois: Yep. The Community has a lot of great things to offer. If you’re not a member, you should join today by accessing it via mylearn.oracle.com.

     

    07:29

    Nikita: Thank you so much, Bill, for coming back to talk to us about the Applied Learning program. I really think it’s such a great new resource for our learners.

    Bill: I’m always happy to be here with you ladies. Thank you for having me.

    Lois: Thanks Bill.

    Ok, next week we’ve got another great topic lined up. If you followed along with some of the announcements at Oracle Cloud World, you’ll know that we launched a new certification and training path centered around Artificial Intelligence.

    Next week, we’ll be talking with Rohit Rahi to learn more about this free training that is available, in an episode we’re calling AI for Everyone. You won’t want to miss that.

    08:03

    Nikita: And if you want to learn more about these Applied Learning projects, visit mylearn.oracle.com.

    Lois: Right, Niki. So that’s all for today. Until next time, this is Lois Houston…

    Nikita: And Nikita Abraham, signing off!

    08:15

    That’s all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We’d also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

    The Talent Life Cycle

    The Talent Life Cycle
    In this episode, hosts Lois Houston and Nikita Abraham talk about the Talent Life Cycle with Cloud Delivery Lead Nigel Wiltshire. They discuss how organizations can nurture their employees' skills, help them set goals that align with business objectives, support their desired progression, and promote a happy work-life balance.
     
    Oracle MyLearn: mylearn.oracle.com
    Oracle University Learning Community: education.oracle.com/ou-community
     
    Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, and the OU Studio Team for helping us create this episode.
     
    --------------------------------------------------------
     
    Episode Transcript:

    00:00

    Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let’s get started.

    00:26

    Lois: Hey there! Welcome to the Oracle University Podcast. I’m Lois Houston, Director of Product Innovation and Go to Market Programs with Oracle University, and with me is Nikita Abraham, Principal Technical Editor.

    Niki: Hi everyone! Last week, we spoke about the Reward Life Cycle, which is the fourth life cycle in the overall HCM Business Process, with our Cloud Delivery Lead Nigel Wiltshire. Nigel is back with us today to talk about the last life cycle, Talent.

    00:55

    Lois: We’re wrapping up this discussion on HCM life cycles today so if you’ve just joined us, be sure to check out the prior episodes this season as you’ll want to get the full picture of the entire HCM business process flow. Hi Nigel! Thanks for agreeing to pop in one last time (this season that is!) to take us through these HCM business process life cycles.

    01:16

    Nigel: Thank you for having me again.

    Lois: So, let’s get right down to business here. What is the Talent Life Cycle?

    Nigel: The Talent Life Cycle contains all the processes that serve to manage and promote an employee’s career growth.

    Niki: And what are the processes that make up this life cycle?

    01:30

    Nigel: Well, Niki, there are four business processes that make up the Talent Life Cycle: Goal Setting to Performance, Talent Review to Succession, Career Planning to Development, and Employee Insight to Work Life Balance.

    The Goal Setting to Performance process covers the two main aspects of Talent Management:  Performance Goals and Performance Reviews.

    01:50

    Nigel: The second process, Talent Review to Succession, allows for managers to review the overall performance and potential of each of their employees. This is to ascertain how the employees are progressing through their career and whether there are any steps that need to be taken to address any challenges that the employee may be having with their performance and/or potential. And on the flip side of that, whether there are any actions or recommendations for career progression for their higher performing employees.

    02:15

    Nigel: Now the Career Planning to Development process centers around the career progression and opportunities for the employee, and there are a couple of main activities that support this venture.  The first is the Career Plan or Path, which is where the employee seeks out the roles that they are interested in pursuing, whether that is in the same field of work, a sideways move, or something completely different. To support this, the employee would create a Development Plan, with goals to support their desired progression. These goals can be designed to support their existing role, to help them pursue another role, or could simply be something personal, such as learning a new language, which is not necessarily related to their employment.

    02:53

    Nigel: The fourth and final process is Employee Insights to Work Life Balance. Happy employees are productive employees, in the same way that a happy workplace is one that employees are happy to get out of bed for in the morning. To promote this, organizations can invoke activities that support a happy work life balance. These activities could be Wellness Programs, Fun Competitions, Volunteering Projects, and Recognition Awards.

    03:16

    Lois: Circling back to the first of those processes, what relationship do performance goals have with performance reviews?

    Nigel: Although goals and performance reviews can be seen and operated independently, they are intrinsically linked. If you think about what an employee’s performance review is designed to address, which is to evaluate the employee over a set period (usually a year), we have to consider what it is we are evaluating. In most organizations, this comes in the form of two elements: the employee’s competencies and their goals. So, for each of the goals that are assigned to the employee, we have to consider whether they have achieved them to the satisfaction of the organization.

    03:53

    Niki: Now, where do these goals originate from?

    Nigel: They are often assigned to the employee through their management hierarchy, which ensures that the goals that the employee has to complete are in line with and support business objectives. Having said that, a lot of organizations allow employees to add their own goals, and as I mentioned previously, these goals could support their current role, a role they wish to pursue in the future, or indeed personal goals for their own growth. It’s a combination of these that are subsequently evaluated alongside their competencies.

    04:22

    Lois: Ok, then. Nigel, you mentioned that another aspect of the employee’s evaluation is their competencies. Can you please tell us a little bit more about these?  How are they different from the employee’s goals?

    Nigel: Absolutely. While a goal is there to support the growth of the business, employee competencies are designed to ensure the employee themselves are up to scratch, in terms of their job. So it will test for such things as their qualifications (e.g. Do they have an up-to-date qualification and/or license to do the job they do – such as a heavy goods vehicle licence for hauliers or maybe a level of language, whether it’s spoken or written to support a translator role). However, that is only one side of the story. Competencies are also designed to ensure that the employee adheres to company standards, such as Communication Skills, Ability to Adapt, and Follows Company Values.  Yes, you could say that these can also be a requirement for certain jobs (e.g. Communication Skills for instructors), but it is also something that would be needed to interact with other members within the organization at various levels, such as a basic level to interact with other employees, but a more advanced level when interacting with the Board of Directors.

    05:29

    Niki: Nigel, earlier you mentioned that performance reviews are conducted over a set period, and you said that it’s an annual process. Are there any other times when an employee could be evaluated?

    Nigel: Of course. The annual or focal review is the one that most people recognize. However there are many types of reviews as well as many periods that a review could cover. For instance, some organizations have a half yearly review as well as the annual review, usually referred to as an interim review. 

    05:57

    Nigel: Other review types may come in the form of PIPs or Personal Improvement Plans for poorly performing employees; Check Ins, used mostly for new employees within their first few months, but also for field operations where the employee and managers do not tend to see each other from one month to the next; and then we have Ad Hoc. These, as the name implies, happen as required, for whatever reason, and do not tend to have a specific time frame. They not used often though as most organizations like the review to be more structured.

    Now, the results from all of these are often taken forward to the main review, and serve as a guide to how the employee has fared over the year. The main advantage of interim reviews is that any development needs are identified early and can be addressed straight away.

    06:39

    Working towards an Oracle Certification this year? Grab all the help you can get! Attend a cert prep live event in the Oracle University Learning Community. And once you’re certified, don’t forget to visit our exclusive forum for Oracle-certified users.

    If you are already an Oracle MyLearn user, go to MyLearn to join the community. You will need to log in first. If you have not yet accessed Oracle MyLearn, visit mylearn.oracle.com and create an account to get started. 

    07:14

    Niki: Welcome back! Nigel, what steps do organizations take to ensure they maintain operational integrity when they know key personnel are planning to leave, especially due to retirement?

    Nigel: Succession Planning is the practice where organizations develop employees to a point where they can move or be promoted to a position that is suddenly left vacant. This is especially critical for those positions that would leave the organization vulnerable and/or less able to operate adequately.

    07:42

    Nigel: Typically, each employee identified as a potential replacement will be given a ranking based on several factors, such as their Performance Score, their Potential, and Expected Readiness Time Frame.

    And a combination of these, as well as other factors, will rank the employee in terms of who is most suitable to take over, down to who is least likely to succeed the current incumbent.

    Of course, things change over time and these succession lists have to be constantly managed and altered accordingly. For instance, maybe one of the employees identified as a potential successor doesn’t want to be considered or maybe one or two of them leave the organization, and as employees gain more experience, they move up or down the list relative to other potential successors.

    08:23

    Lois: I understand that employee suitability for a job or position can be based on how the managers within the organization perceive the employee’s performance and potential. But that can be subjective, right? An organization could be in hot water if they rely on this approach alone. So, how does a system like Oracle Fusion Cloud help to show objectively, which Jobs and Positions an employee is suitable for, and how does it identify gaps in employee knowledge or experience?

    08:52

    Nigel: Wow, that’s such a meaty question, Lois. OK, so many systems these days have functionality that allow employers to record what attributes are required by any potential employee, to fulfil a job or position successfully.

    These attributes include Competencies, Qualifications, Languages, Licences, and many more, and what they do is create Model Profiles, which are the list of attributes needed for the job or position.

    At the same time, organizations are able to record which attributes the employee already has, and these are called Person Profiles.

    09:25

    Nigel: By comparing one against the other, it is easy to identify whether an employee (or potential candidate if used with Recruiting) is suitable for a job and which attributes are missing that the employee does not have.

    Now the upshot of this is that not only can the employer slot the right person into the right job, but it can be used to identify what gaps the employee needs to plug, should they wish to pursue an alternative job type, or move up the chain of command.

    09:48

    Niki: Well, I think we’ve come to the end of our focus on HCM business process life cycles. Thank you so much, Nigel, for taking the time to be our guide through this journey.

    Nigel: Thanks for having me. I’ve had a great time with you two.

    10:00

    Lois: If you missed any of our earlier episodes this season, you should go back and check them out to get a broad view of these business processes. We’ve had one episode on Oracle’s business process training in general and we also had Nigel with us these last few weeks, taking us through each HCM business process life cycle. So it’s a great time for a refresher! We’ll be taking a break from our business process training next week to look at some training that’s just launched in our Cloud Learning Subscriptions. But more on that soon. Until then, this is Lois Houston…

    Niki: And Nikita Abraham, signing off!

    10:37

    That’s all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We’d also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

    The Reward Life Cycle

    The Reward Life Cycle
    In this episode, hosts Lois Houston and Nikita Abraham talk to Cloud Delivery Lead Nigel Wiltshire about the Reward Life Cycle, which centers around the compensation that is given to an employee, and how it is paid and processed.
     
    Compensation, in this case, is not restricted to the salary that is paid to an employee but includes bonuses, stocks, medical insurance, and other benefits.
     
    Oracle University Learning Community: https://education.oracle.com/ou-community
     
    Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, and the OU Studio Team for helping us create this episode.
     
    --------------------------------------------------------
     
    Episode Transcript:

    00:00

    Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let’s get started.

    00:26

    Lois: Hi there! Welcome to the Oracle University Podcast. I’m Lois Houston, Director of Product Innovation and Go to Market Programs with Oracle University, and with me is Nikita Abraham, Principal Technical Editor.

    Nikita: Hi everyone. Last week, we discussed the Employee Life Cycle, the key players involved, and the tasks that come under it.

    00:47

    Lois: Right, Niki. And if you missed any of the earlier episodes in this season, you’ll want to catch up so you can get a full picture of the HCM business processes. Today, we’re going to discuss the next HCM business process life cycle, the Reward Life Cycle, with our Cloud Delivery Lead Nigel Wiltshire. Hi Nigel, welcome back. Are you tired of talking to us yet?

    01:09

    Nigel: Hi Lois. Hi Niki. Haha! No, I’m never tired of discussing this topic.

    Nikita: So Nigel, let me start by asking the question of the day, what is the Reward Life Cycle?

    Nigel: Niki, if I was asked to describe the Reward Life Cycle in as few words as possible, it would be something along the lines of “The Employee’s Total Worth.”

    01:26

    Lois: OK. That’s definitely a few words. What do you mean by that?

    Nigel: This life cycle centres on the compensation that is given to employees and how that compensation is processed and paid. Now, when I say compensation, I’m not just talking about the salary that is given to them for the job they do. This also includes other compensation such as bonuses, stock, and other incentives. 

    01:47

    Nigel: It also encompasses any benefits that are afforded to the employee, which are often funded by the employer, such as Medical Insurance, Dental Insurance, Vacation, Income Protection, and many more. Like I was saying, these benefits are often paid for by the employer and are generally referred to as “Benefits in Kind,” which, depending on country-specific legislation, are often taxable. Some benefits come with various levels of cover that the employee can opt into, such as to cover their spouse or family. These additional options often come with a requirement for the employee to contribute.

    This is why I referred to it as “The Employee’s Total Worth.” As an example, let’s say an employee’s base salary is US$60,000 per year. On top of this, they also receive bonuses that equate to US$20,000 per year, and have a benefits package paid for by the employer that is worth US$8000 per year. In essence, the employee’s worth comes out at a whopping US$88,000 each and every year.

    02:44

    Nikita: OK, so bringing the conversation back to HR business processes, Nigel, how many processes make up the Reward Life Cycle?

    Nigel: There are four: Benefits to Payroll, Time Collection to Payroll, Reward Planning to Targeted Compensation, and Payroll to Payment.

    Lois: So, can you tell us a little more about each of these?

    03:05

    Nigel: Sure, Lois.

    The “Benefits to Payroll” process allows organizations to configure and manage benefit programs. As I was saying earlier, these could include Medical and Dental Insurance, Life and Income Insurance, Savings Schemes, and even the ability to purchase additional vacation time, over the core entitlement. A lot of these are country specific, but in general, they are options that an organization provides, and depending on the level of cover either bear the total cost, or require the employee to contribute to the costs. In the case where the employee needs to make contributions, these deductions are processed by payroll.

    The second process, “Time Collection to Payroll.” This is the mechanism used to report the time that an employee has spent on various work-related activities. This could be regular time, overtime, time spent on specific projects, and even time spent for an absence from work, all of which could affect the amount of pay an employee receives. This again has to be passed to payroll for processing and payment or adjustment. Some organizations don’t operate this way as their employees get a regular salary regardless of what they do during their working day, and sometimes this will depend on the legislation.  Some employees may need to submit a time card in order to be paid, others may not and will just get paid their periodic pay regardless of how they spend their time.

    04:22

    Nigel: Now I want to talk a little about “Reward Planning to Targeted Compensation.” If everyone got paid the same, regardless of the job they did or length of service and so on, life would be very simple for the people who have to work out how much to pay an employee. Alas, this is never going to be the case, and rightly so. That’s why there has to be mechanisms in place to establish what a job and or/person is worth, which can be influenced by numerous factors.

    04:46

    Nikita: And what sort of factors are we talking about, Nigel?

    Nigel: A technical job would typically pay more than a non-technical job, managerial jobs would typically attract a higher salary than an individual contributor job, and so on. But it is very rarely as cut and dried as that because you could also take years of service and experience into account. This process takes into consideration that compensation is not just about Base Salary. It could encompass incentives, such as Bonus and Commission, which are awarded to individuals for various reasons, such the job they do or where they work, or even how the company is performing.

    05:19

    Nigel: And the final process is “Payroll to Payment.” Essentially, this is the bit where we actually process all the compensation contributors, such as Salary, Benefits, Absences, and Time Cards, and work out the employee’s periodic net pay, which we subsequently send to their bank as a direct deposit or issue a cheque. Now, that all sounds nice and simple, but actually, when using a payroll system, such as the one we have in the Oracle Cloud, there are a lot of configurations that have to occur for that process to do its thing and get the right amount to the right person. We’re talking about Bank Accounts, Elements, Payroll Definitions, Payment Methods, Costing Structures, Balance Definitions, and many more. Then, of course, somebody has to push the button to start the process, cross their fingers that everything is configured as it should be, and breathe a sigh of relief when everything slots into place and every employee gets paid as expected.

    06:16

    The Oracle University Learning Community is a great place for you to collaborate and learn with experts, peers, and practitioners. Grow your skills, inspire innovation, and celebrate your successes. The more you participate, the more recognition you can earn. All of your activities, from liking a post to answering questions and sharing with others, will help you earn badges and ranks, and be recognised within the community.

    If you are already an Oracle MyLearn user, go to MyLearn to join the community. You will need to log in first. If you have not yet accessed Oracle MyLearn, visit mylearn.oracle.com and create an account to get started.

    06:55

    Nikita: Welcome back. Nigel, since you brought up Base Salary, let’s talk about it a little more. How do employers determine how much someone gets paid?

    Nigel: Interesting question, Niki. There are many factors that influence the amount of salary that employees are paid. For some organisations, such as those tied to government and public service, salaries are typically laid down through official channels and there is very little to no scope for salary negotiations, and this is because the money is coming from public funds, such as taxes. So there has to be a strict structure for compensation levels and amounts. Having said that, there are some jobs within the government sector that do advertise salary ranges, so there is little wriggle room for negotiations based on the applicant’s experience and knowledge. 

    07:40

    Nigel: For a lot of privately-owned organisations, it tends to be more fluid and salary negotiations are more common. This is why you will often see jobs advertised with the phrase “Salary Negotiable” rather than the actual salary, or you will see the salary range on offer being displayed. Of course, the employer has an idea about the salary they would like to offer based on the job being advertised, and the applicant will already have an idea about what amount they would like, based on previous jobs, or research they have conducted. It’s just a matter of how well the applicant can convince the company about how much they are worth. Of course, if the employee ends up asking for a ridiculous amount, the company will just walk away, so it would not be in the interest of the applicant to go into the conversation with an unrealistic expectation.

    08:23

    Lois: Nigel, I know some private organizations have a more structured approach to salary levels for each job. How do they set this up?

    Nigel: You’re absolutely right, Lois. Some organizations use an evaluation system that allows them to score jobs and positions based on a series of criteria, such as Know How, Accountability, and Problem Solving. The overall score is then used to help set a salary, or salary range for the job.

    For instance, you would expect a managerial job to have a higher score for criteria such as Accountability than those jobs performed by employees within their team. However, it is not always so clear-cut. Let’s say, for instance, that you have an individual contributor level job that is very technical. The scores for Know How and Problem Solving could be way higher than the manager job, so the overall score could end up being higher than the manager job, therefore attracting a higher salary.

    09:14

    Lois: Interesting. Speaking of salary, let's move on to the processing of payrolls. We know that different countries have different rules when it comes to the processing of many payroll items, like taxes, social security, and the absence adjustments. How do systems like Oracle Fusion Cloud deal with this, especially for global organizations?

    Nigel: This is achieved in just three words - Legislative Data Groups. And before you ask, let me expand on that.

    Lois: Yes, please!

    09:41

    Nigel: As you quite rightly pointed out, different countries (or legislations) calculate and process certain things differently. And the one that stands out the most is taxes. For example, in the US, there are different layers of taxation for salaries, the main ones being Federal and State. Compare that to somewhere like the UK, which only taxes salaries at one level, and we don’t have different rules for the various counties within the UK. 

    In addition to that, the amount the employee is taxed is usually tied to the level of income, so the more you are paid, the higher the tax rate. And, of course, these bandings are not the same across legislations.

    10:16

    Nigel: Now due to how complex the rules for these levies tend to be, and how frequently the rules can change, Oracle takes care of the configurations for you, through the quarterly product releases, and provides a way of accessing the right rules for the right legislation. We call them Legislative Data Groups.

    Having pre-set legislative rules makes it easy for organizations to configure many payroll items within the Oracle Cloud. By simply associating the appropriate Legislative Data Group with the relevant parts of the business, the system will automatically know how to process such things as taxes and social security for any employee who is employed in each part of the business.

    10:54

    Nikita: Sticking with Payroll for a bit, I know that in some organizations, employees are paid for the work they complete, including overtime, only after they have reported that information. What mechanisms do organizations typically have to allow employees to submit this information?

    Nigel: Funnily enough, although ultimately the payments are processed and paid through the payroll mechanisms, this question actually relates to time and labor.

    Some organizations will use time cards for the purpose of reporting time. This relates to the “Time Collection to Payroll” part of the HR business process. These days, with most systems, the onus is on the employee to report time, which then goes to their manager for approval, and ultimately ends up with Payroll for processing.

    11:36

    Lois: So, will employees have to remember to go into the system and complete or submit a time card each week?

    Nigel: It depends. For some organizations, yes the employee would need to do that, but for others, the system can be configured to retrieve the information from an external source, such as a card reader, a biometric scanner, or even a kiosk at the reception (or canteen) where employees can clock in and clock out using buttons, having first been identified using facial recognition. We are in the 21st century after all and technology has come a long way in the last few decades.

    12:06

    Nikita: Well, I think we’ve covered everything under the Reward Life Cycle. Thank you for joining us today, Nigel. We’re learning so much from you.

    Nigel: Happy to be here with you guys.

    Lois: Don’t forget to catch up on this season’s previous episodes, including an overview of the entire business process training program offered by Oracle University and the prior HCM life cycles Nigel has shared with us. For more information about the HCM business processes, you can also visit mylearn.oracle.com. Next week, we’ll cover the final HCM life cycle - Talent. Until then, this is Lois Houston…

    Nikita: And Nikita Abraham, signing off!

    12:45

    That’s all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We’d also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

    The Employee Life Cycle

    The Employee Life Cycle
    During an employee’s tenure in an organization, they may experience different situations or have varying demands—they may get promoted, apply for leave, or get transferred to another team, for instance. Clearly, hiring employees is just the tip of the iceberg. Managing them requires a lot more work.
     
    In this episode, hosts Lois Houston and Nikita Abraham, along with Cloud Delivery Lead Nigel Wiltshire, take a closer look at the Employee Life Cycle, which pertains to how employee information, separation, and absence are dealt with.
     
    Oracle University Learning Community: https://education.oracle.com/ou-community
     
    Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, and the OU Studio Team for helping us create this episode.
     
    --------------------------------------------------------
     
    Episode Transcript:

    00:00

    Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let’s get started.

    00:26

    Lois: Welcome to the Oracle University Podcast. I’m Lois Houston, Director of Product Innovation and Go to Market Programs with Oracle University, and with me is Nikita Abraham, Principal Technical Editor.

    Nikita: Hi everyone! Last week, we spoke about the Applicant Life Cycle, which is the first in the overall HCM business process life cycle, with our Cloud Delivery Lead Nigel Wiltshire. Nigel joins us once again today to talk about the second life cycle, the Employee.

    00:54

    Lois: Right. And since we’re walking through HCM business processes, you might want to go back and listen to the last few episodes so you can get an idea of the big picture and the life cycles we’ve already discussed. Nigel, we’re so glad you’re back with us again this week. Thanks for agreeing to be our guide through this series. You know, I’ve never really thought about there being a “life cycle” for an employee. I’m an employee, but I just never really considered myself as part of a cycle. Can you tell us a little bit about how that’s defined?

    01:23

    Nigel: Hi, and thank you once again for inviting me to participate. To put it very simply, the Employee Life Cycle continues from where the Applicant Life Cycle ends, and encompasses all the tasks that are performed against the employee from start to finish.

    Nikita: Now when you say, “start to finish,” what exactly do you mean by that?

    Nigel: Well, the very last act performed in relation to an applicant is for Recruiting to pass the baton over to Human Resources, so that HR can officially create an employee record, and take care of all the needs and tasks associated with an employee. This will typically range from transferring or accepting all the relevant data from their applicant record, expanding that to include their Work Relationship, and managing their career changes.

    02:04

    Nikita: Sorry to interrupt, Nigel, but what is a “Work Relationship”?

    Nigel: For each employee, we need to create and maintain a relationship with the business. This serves a couple of purposes. 

    Firstly, it establishes which legal entity they belong to. A legal entity is the governing body that takes care of all the legislative rules and laws that affect the employee, and from the HR perspective, it is going to control such things as employment laws, working time directives, absence entitlements, and taxation, to list just a few.

    Secondly, we need to provide the employee with an assignment. This will indicate what their remit is within the organization and will record such details as their Job, Department, Location, Work Hours, Grade, Salary, and much more.

    Many smaller organizations will operate in a single legal entity, so managing this is not a huge piece of the puzzle, but for larger organizations, especially those that operate globally, this is a major aspect of the company setup.

    03:00

    Lois: I hadn’t really considered all of that before. Thanks for going through that, Nigel. So, now we have the employee on board. What processes does the Employee Life Cycle encompass?

    Nigel: Unlike the Applicant Life Cycle that we spoke about last week, which has only one process under it, there are three main processes in the Employee Life Cycle: Hire to Retire, Absence to Productivity, and Employee Separation to Workforce Analysis.

    03:26

    Nigel: Hire to Retire is the process that encompasses an employee’s whole career in an organization, from when they are hired to when they decide to leave. Of course, within that time frame there are many changes that occur, such as promotions, transfers, and general assignment changes, like a change in work hours, salary, line manager, terminations, to name just a few. A major aspect of this is the need to manage and maintain the organization structure so that reporting lines can be established, and for many larger organizations, this is a regular occurrence and therefore a major job for someone.

    04:00

    Nikita: OK, so that’s Hire to Retire. What’s Absence to Productivity?

    Nigel: Absence to Productivity is the process where employees take time away from work, which would mostly be due to vacation or personal time off, but would also incorporate other types of absence such as sickness, maternity, paternity, and jury service, again to name just a few. This process provides the framework and mechanism to record such absences and to monitor entitlements. It also goes as far as analysing the impact on the business and its operational effectiveness. Of course, we can’t always predict when somebody is going to be absent from work, but we can monitor trends and plan for an eventuality. Another aspect of this process comes from the “human” angle. For anybody that has been absent for a while due to illness, injury, or stress, there is a duty of care to help them return to work. This may involve finding the employee a different role within the organization, or simply to gradually introduce the employee back to work, maybe on a part time basis for a couple of weeks.

    04:59

    Nigel: The third and final process in the Employee Life Cycle is Employee Separation to Workforce Analysis. Now, although employee terminations are very much part of the “Hire to Retire” process, there is a much more robust and complex process that is usually put into place. So, you shouldn’t really think of it as simply the employee leaving and being replaced.

    Lois: What do you mean by that, Nigel?

    05:20

    Nigel: Lois, the manner in which the employee leaves is quite important. For instance, many organizations issue their employees with equipment, such as laptops and mobile phones, especially with a lot of employees working from home. So, we need a process that makes it quite clear as to how and when that will be returned.

    Lois: They could also have security badges and keys that need to be returned.

    Nigel: Exactly. And to deal with this, many organizations adopt an off-boarding process, which on the face of it is almost the reverse of the onboarding process the employee may well have been through.

    05:49

    Nikita: OK, that makes sense. And what happens after the employee leaves?

    Nigel: What happens? We are left with a gap in the workforce, and this vacancy may need to be filled. So, we would initiate a recruitment campaign and the Applicant Life Cycle would be triggered. Now, before a decision is made, many organizations go through a period of analysis to establish whether the employee does in fact need to be replaced. In some cases, it would be a “no brainer” based on the job the employee was performing, but in others it may be that a simple reorganization would fill the gap and negate the need to hire a new employee. So, like I said, it’s not often a simple case of employee leaves, employee gets replaced.

    06:31

    Have an idea for a new course or learning opportunity? We’d love to hear it! Visit the Oracle University Learning Community and share your thoughts with us. Your suggestion could find a place in future development projects.

    If you are already an Oracle MyLearn user, go to MyLearn to join the community. You will need to log in first. If you have not yet accessed Oracle MyLearn, visit mylearn.oracle.com and create an account to get started. 

    07:00

    Nikita: Welcome back. Nigel, you’d mentioned that the hiring of an employee in included in the “Hire to Retire” process. But why would hiring an employee be part of this life cycle? Surely, that’s part of the Applicant Life Cycle, right?

    Nigel: Yeah, I can see how that could be confusing. It really boils down to an organization’s processes. A lot of larger organizations will have a dedicated recruitment team who will most likely use an applicant tracking system to manage their recruitment campaigns. And as I was saying earlier, the final act would be to hand over the successful application to the HR team, who will take it from there. In that regard, the “onboarding” of the employee, which could be seen as part of the Applicant Life Cycle, is often set and monitored by the HR team. What we also have to consider is that smaller organizations may not have the luxury of having a recruitment team, nor have the resources at their disposal, such as an applicant tracking system. Therefore, the whole process of recruiting is swallowed up within the HR team’s process. However, the fundamentals will be the same: recruit, onboard employee, manage employment, terminate, etc. 

    08:04

    Lois: Let’s move on to some more specifics about an employee record. For instance, some organizations recognize and measure employee seniority. Why do employers do this and how does it affect the employee?

    Nigel: Great question, Lois. Measuring seniority is a way for the employer to keep track of how long an employee has been in a given situation. This mostly involves measuring the number of years and months from when the employee is hired. The reason why they do this can be varied, but a couple of examples of this would be things like bonuses and vacation, i.e., the amount that you are entitled to could depend on how long you have been with the organization. Some organizations also like to track when the employee started so that they can recognize loyalty and provide the employee with a thank you gift at certain increments such as 5, 10, 25 years.

    08:50

    Nikita: So, other than measuring seniority from the employee’s start date, are there any other times an organization would start counting?

    Nigel: Absolutely. Some organizations like to know how long somebody has been in a particular role.  For example, an employee may have been at the company for 25 years (so that would be one continuous seniority period), and within that time they may have moved jobs two or three times, therefore, additional periods of seniority would be measured for each role performed.

    09:17

    Nigel: In addition to that, some organizations recognize previous service as part of the employee’s seniority. For example, let’s say the employee has recently joined the organization. You would think that their seniority would be quite low, but they also served 10 years with the organization previously, which is also being taken into account. Now the impact could be that their entitlements, bonuses, and so on are set at the level of a 10-year employee, instead of an employee who has literally just joined the organization.

    09:44

    Lois: So, bridging their service to include previous employment there. That makes sense. OK, I’d like to explore one of the other processes you mentioned a little further – Employee Separation to Workforce Analysis. In particular, the Workforce Analysis part. Can you tell us what this is and why it’s so important?

    Nigel: For an organization to be effective, we need to protect its operational capabilities. This can come in many forms, including equipment maintenance, fire and emergency procedures, and also staffing levels. No point having equipment if there’s nobody to operate it, right?

    10:19

    Nigel: So, workforce analysis is a process that will allow the organization to establish the optimal numbers to run each part of the business effectively and efficiently. It also goes some way to work out how the organization should be structured so that they can deploy employees for optimal productivity.

    The reason why this process is associated with Employee Separation, is to allow for the analysis of “why” people are leaving. Of course, there will be a certain amount of attrition based on reasons like retirement and redundancies, which, in the main, can be predicted, but what about the ad hoc leavers? It’s a good idea to identify why they are leaving as it may highlight certain flaws in the organization, its processes, or even its management structure, which can be addressed and hopefully, plugged. A lot of organizations achieve this by conducting exit interviews as part of the employee’s off-boarding process.

    11:08

    Nigel: This process can also be closely linked to the Absence processes so that we can monitor why people are absent. Now, I’m not talking about absences due to entitlement, such as vacation, or absences that can’t be predicted, such as jury service or bereavement. I’m mostly referring to absences due to sickness. Again, it’s not always possible to predict these, but it’s possible to spot trends, and cater to these accordingly. For instance, most people tend to catch a cold and flu during the winter months. Therefore, if this is the case with your organization, steps can be taken to ensure the company remains operational, which may involve being prepared to hire temporary staff. It is also possible to see from the data, how the virus is spreading across the organization and to put measures in place, such as the provision of hand sanitizer.

    11:52

    Nikita: On the face of it, it sounds like there are a ton of tasks that need to be performed just to keep an employee’s record up to date. Surely this is not all done by one person.

    Nigel: I guess that would depend on the size of the organization and the complexity of the processes they adopt, but generally, there are three main roles that play their part in the Employee Life Cycle.

    First and foremost, we have the HR Specialist. This person is an expert who has the skills, knowledge, and experience to maintain employee records and ensure that all necessary processes are launched, monitored, and run as smoothly as possible. They are the intermediary between the employee and the business, and ensure everybody is happy.

    12:29

    Lois: So they’re a generalist who does everything?

    Nigel: There are some processes that require a little more specialized knowledge and skills, so it is not uncommon to have specific HR Specialists looking after specific parts of the employee record. A classic example of this is the Payroll Administrator whose knowledge of payroll is very specialized.

    12:48

    Nigel: Then there’s the employee’s Line Manager. Over the last couple of decades, line managers have increasingly become more involved with the management and maintenance of employee records. Of course, they would not have the knowledge and years of experience that an HR Specialist would have, but would perform simple tasks such as approving an employee vacation request or interviewing potential employees. Over the years, as more and more people become savvy with technology, we have seen this role become more and more involved, to the point where some of the HR tasks are now the responsibility of the line manager, such as initiating promotions, transfers, terminations, salary changes, and many more. This frees up a lot of the HR Specialist’s time to concentrate on more specialized tasks.

    13:31

    Nigel: And last but certainly not least, the Employee themselves take some responsibility. At the end of the day, HR mostly centers around employee data. Therefore, very much like the line manager role, the employee increasingly is required to take responsibility for that data. Therefore, it is not uncommon these days for employees to enter and update certain data, such as change of address, addition of emergency contacts, absence requests and withdrawals, and many more tasks, which, again, frees up the HR Specialist’s time for more complex tasks.

    14:00

    Lois: Like I inferred at the beginning, there’s certainly a lot more to this life cycle than it appears on the surface. We just show up to do our work, but there’s a lot happening behind the scenes to track and manage our employment. We’re not even aware of this sometimes.

    Nigel: Exactly, Lois.

    14:16

    Nikita: Thank you, Nigel, for your insights into the Employee Life Cycle. To learn more about HCM business processes, visit mylearn.oracle.com.

    Lois: Yes, and you should definitely consider catching up on the previous episodes of this season so you’ll get the full picture of the business processes for HCM. And don’t forget to join us again next week, where we will be introducing the Reward Life Cycle. So much good stuff. Until then, this is Lois Houston…

    Nikita: And Nikita Abraham, signing off!

    14:45

    That’s all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We’d also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

    The Applicant Life Cycle

    The Applicant Life Cycle
    How your employees are hired and onboarded into the organization can determine how well you are able to attract—and more importantly—retain top talent.
     
    Listen to Lois Houston and Nikita Abraham, along with Cloud Delivery Lead Nigel Wiltshire, as they deep dive into the first life cycle, the Applicant Life Cycle, within Oracle HCM business processes. They discuss how you can leverage the life cycle to optimize your recruitment and onboarding initiatives.
     
    Oracle University Learning Community: https://education.oracle.com/ou-community
     
    Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, and the OU Studio Team for helping us create this episode.
     
    --------------------------------------------------------
     
    Episode Transcript:

    00:00

    Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let’s get started.

    00:26

    Nikita: Hello and welcome to the Oracle University Podcast. I’m Nikita Abraham, Principal Technical Editor with Oracle University, and with me is Lois Houston, Director of Product Innovation and Go to Market Programs.

    Lois: Hi there! In our last episode, we were introduced to Human Capital Management business processes by our HCM guru and Cloud Delivery Lead Nigel Wiltshire. That was a great overall introduction and you should give it a listen if you’re new to HCM. Nigel’s back with us today to talk about the first of the HCM business process life cycles – the Applicant Life Cycle.

    01:01

    Nikita: Hi Nigel, thanks for joining us today. So first of all, what is the Applicant Life Cycle?

    Nigel: Hi Niki, Hi Lois. It’s great to be back. Thank you for having me. The Applicant Life Cycle is the initial part of the HCM business processes. In a nutshell, it’s all about identifying vacancies within an organization and taking appropriate steps to fill those vacancies. 

    Lois: That sounds simple enough! So, how many processes make up this life cycle?

    01:27

    Nigel: Unlike the three other life cycles that we will be discussing in upcoming episodes, there is just one business process in the Applicant Life Cycle. But within this process, there are many activities.

    Lois: So one process, but lots going on. OK.

    Nigel: Right. The business process is called “Recruit to Onboard” and covers the whole process from when the vacancy is identified to the onboarding of the successful candidate to the business.

    Nikita: And what are the activities within this process, Nigel?

    01:52

    Nigel: Within Recruit to Onboard, there are six main activities.

    The first is called “Determine Workforce Need.”

    Lois: So identifying the need to recruit new employees…

    Nigel: That’s right, and this can be as a result of existing employee terminations, or it could stem from a workforce planning exercise, which resulted in the need for additional staff based on company growth and change of operations.

    Next we have “Drive Candidate Engagement.” This activity is where the whole recruitment campaign really starts. It includes the creation of the Job Requisition, where we add all the necessary details to attract the candidate and encourage them to apply to the position. Of course, you want to also attract the best candidates, and so creating an engaging Career Page on your company’s website is paramount,  making it easy to search for and apply for the relevant job.

    02:38

    Nigel: The third activity is called “Manage Sourcing” and this is all about making the job requisitions visible to candidates, through various medium. I already alluded to one of them as the organization’s own career web pages, something we call the Career Site. Again, configuring that to be vibrant and easy to navigate is key to the success of that medium. Then we have Job Boards, where you can post your vacancy on external job boards for potential candidates to see. This takes all the work of creating a user interface away from the organization, but on the flip side, you have no influence on how the posting looks. 

    03:12

    Lois: That would be places like LinkedIn and Indeed, right?

    Nigel: That’s exactly right, Lois.

    There are also Recruitment Agencies, whose job is to take your requisition and search for suitable candidates on your behalf. This is often quicker, as they will have potential employees on their books already that they would refer. Finally, there is the concept called “Social Sourcing.” For this, you would create a campaign that can include a specific audience, which would help you source candidates for the job.

    03:38

    Nikita: I’m not really sure I get you, Nigel. Could you give us an example of this, please?

    Nigel: Sure, Niki. Let’s say that you have an opening in Sales. If you create a campaign and include all of the sales team as the audience, they will use their own networks to seek out and refer candidates. This option works extremely well if you have a recruitment bonus scheme, where the referrer gets cold hard cash for recommending an applicant, who subsequently gets taken onboard.

    Nikita: OK, yeah, I get it now.

    04:04

    Nigel: The next activity in the Recruit to Onboard process is “Intelligent Screening.” Recruiters are usually very experienced and very often able to skim read a resume to ascertain whether an applicant is suitable for the position they applied for. However, this is not infallible and is, therefore, only one method of screening candidates.

    Before the recruiter takes a look at the resume, it’s possible in most applicant tracking systems to set pre-screening questions.

    04:29

    Lois: And these questions are all regarding that particular job role?

    Nigel: Some of the questions would be tied to suitability for the job and would be assessing categories such as their abilities, certifications, and experiences. Other questions would be knock-out or disqualification questions, which concentrate more on the applicant’s suitability to work, and would include questions around such topics as age, criminal records, and visas.

    Those candidates that pass the pre-screening questions and subsequent recruiter review would typically go on to be reviewed by the Hiring Manager with a combination of resume review and telephone/face-to-face interview.

    05:06

    Nigel: Next, we have “Select Candidate and Generate Offer.” So, between the Hiring Manager and Recruiter, each candidate would be pushed through the hiring process, where they would be screened, interviewed, checked for background, and so on. There will, of course, be many candidates that do not pass certain phases of the process and are rejected, in the same way that there will be some candidates who have second thoughts and withdraw their application. However, what the recruiting team is aiming for is to get to the point where they can make an offer to the most suitable candidate and once accepted, the final part of the process kicks in.

    This final process being “Onboard New Hires.” What we are aiming to achieve here is a smooth transition from applicant to employee. As a rule, there are tasks that need to be performed by many stakeholders to get the new employee up and running. These fall into three main time frames: pre-boarding tasks, day of hire tasks, and post-boarding tasks.

    06:03

    Working towards an Oracle Certification this year? Grab all the help you can get. Attend a cert prep live event in the Oracle University Learning Community. And once you’re certified, don’t forget to visit our exclusive forum for Oracle-certified learners.

    If you are already an Oracle MyLearn user, go to MyLearn to join the community. You will need to log in first. If you have not yet accessed Oracle MyLearn, visit
    mylearn.oracle.com and create an account to get started. 

    06:34

    Nikita: Welcome back. Nigel, you were telling us about the three categories of tasks – pre-boarding, day of hire, and post boarding. Can you tell us a bit more about each of them?

    Nigel: Sure, Niki. “Pre-boarding tasks,” as the name implies, are those that can be, or need to be performed before the employee’s first day. These are performed by many different people and can range from a request for more information from the employee, such as Bank Account details, to sending the employee a link to view the company’s policies and procedures (although this could be something that the employee does on their first day). It could also be a request to IT so that they can provision user accounts and email addresses, or to Facilities to make sure that the employee has a desk and chair to sit at when they get here, or to the Security team to create an identification badge and/or an access card.

    07:24

    Nigel: Now, the “Day of Hire tasks” are those that are typically performed by the Employee and Line Manager. For example, the employee may have to collect their ID card from security. They may need to attend orientation training and meet the rest of the team. The manager would be overseeing all of that, and guiding and mentoring the employee through their first, usually nervous, day.

    “‘Post-Boarding tasks” are simply those that guide the employee through their first weeks, until they get comfortable. This may be topped off with an informal meeting between the employee and their line manager, just as a check-in to make sure they are both doing what they need to do in order to onboard the employee.

    07:59

    Lois: I think I have an idea, but Nigel, can you tell me why the “Recruit to Onboard” process and all its associated activities are so important?

    Nigel: Well, I guess it’s like anything in life. If you don’t have a solid plan of action, then all you can hope for is that everything works out smoothly. But by adopting this kind of process, you are giving yourself every possible opportunity to execute your goal, which is to fill the vacancy, with almost military precision. You already know what it is you need, so why would you not look for the most efficient way to achieve it?

    08:29

    Nigel: In addition, the nature of recruiting often means you have hundreds of candidates applying for a job, and they are not all going to do that at the same time. As a consequence, you may not be able to run them through the hiring process at roughly the same time and speed. Therefore, you end up with some candidates that are at the Review phase, some at Interview, some at Background Checks, and maybe a couple at the Offer phase. This, as you can imagine, makes it very difficult to track who’s who and what’s what. Therefore, if you don’t have a defined strategy, you end up losing track of what’s been done and what needs to happen, resulting in a massive headache and you looking like you don’t know what you are doing.

    09:04

    Lois: The two main job roles here are the Hiring Manager and Recruiter, right? So, typically, how is the workload split between the two of them?

    Nigel: Of course, this varies from company to company, but in general, the rule is that the Hiring Manager kicks off the whole process by registering that there is a need to fill a vacancy. The Recruiter, who actually performs most of the day-to-day management of the recruiting campaign, ensures that the opening is posted to the appropriate medium, and then manages the candidates through the hiring process.

    09:34

    Nigel: Now along the way, although probably 90% of the work is done by the Recruiter, the Hiring Manager does get involved when needed. This is often in the form of Approvals and Interviews, and as a general figure head in case any decision needs to be made.

    What you have to understand is that the Hiring Manager is usually the Line Manager for the role being advertised.

    09:53

    Lois: So, they’ll know the job to be filled and who they’re looking for in terms of experience and abilities.

    Nigel: Yes, exactly Lois. The Recruiter, who is not usually directly related to the department with the vacancy, may not know the job, but will have the skills and experience to find the right candidates and, typically, has multiple vacancies to fill from many parts of the business.

    So, in essence, it’s a symbiotic relationship between the Recruiter and the Hiring Manager, and together they strive to fill the vacancy as quickly as possible, with the best candidate that applies.

    10:23

    Lois: And then, that wraps up this process, I guess?

    Nigel: Yes, from here the employee is onboarded and becomes part of the Employee Life Cycle.

    Lois: And we’re going to talk about that next week, right?

    Nigel: Indeed. I’m looking forward to it.

    Nikita: Thank you so much, Nigel. This has been most informative.

    Nigel: Thanks for having me.

    10:40

    Lois: That brings us to the end of this episode. We hope you can take away some useful snippets of information. To learn more about HCM business processes, visit mylearn.oracle.com. And tune in again next week when we’ll be talking about the second of the HCM life cycles – The Employee Life Cycle. Until then, this is Lois Houston…

    Nikita: And Nikita Abraham, signing off!

    11:03

    That’s all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We’d also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

    An Overview of HCM Business Processes

    An Overview of HCM Business Processes
    Human Resources Management is an important function in every organization. Without it, companies would not be able to effectively recruit and retain employees or maintain a healthy, accepting workplace.
     
    In this episode, Lois Houston and Nikita Abraham, together with Cloud Delivery Lead Nigel Wiltshire, explore how employee management has evolved over time, the key functions within a Human Resources department, and the major players involved. They also look at the end-to-end business processes that are enabled by the Oracle HCM Cloud suite.
     
    Oracle University Learning Community: https://education.oracle.com/ou-community
     
    Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, and the OU Studio Team for helping us create this episode.
     
    --------------------------------------------------------
     
    Episode Transcript:

    00:00

    Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let’s get started.

    00:26

    Lois: Welcome to the Oracle University Podcast. I’m Lois Houston, Director of Product Innovation and Go to Market Programs with Oracle University, and with me is Nikita Abraham, Principal Technical Editor.

    Nikita: Hi everyone! Last week, we were joined by Bill Lawson, who gave us a wonderful overview of Oracle’s business process training. And today, we have another special guest, Nigel Wiltshire, who is one of our Senior Principal Instructors and Cloud Delivery Leads. We’re so lucky that Nigel has agreed to join us for a few episodes this season to tell us all about HCM business processes.

    Lois: Hey Nigel, we’re so happy to have you join us.

    01:02

    Nigel: Hi Lois. Hi Niki.

    Lois: I believe that today we’re going to discuss HCM as a concept and the typical processes that form the framework for a robust Human Resources operation. Let’s begin with the basics. For those that are not familiar with the acronym, what does HCM stand for?

    01:19

    Nigel: That’s probably going to be the easiest question to answer, Lois. HCM is “Human Capital Management.” The management of employees has been through many iterations and labels over the years. And back in the 1960s, 70s, and early 80s, the term “Personnel” was generally in use. Come the mid to late 1980s, this changed to the term “Human Resources,” which (rightly or wrongly) is interchangeably referred to as “Human Capital Management.”

    01:47

    Nikita: But why did the name change, Nigel?

    Nigel: In the days of “Personnel,” there wasn’t really any emphasis on managing and nurturing employees. It mostly centred around the simple task of recording the data necessary for the organization to operate. The thought process and the general concept of employee management has gradually changed for the better over the decades, and now goes beyond just a simple record keeping exercise.

    The “Personnel” regime tended to be reactionary, with actions only being taken when the situation necessitated it, whereas “Human Capital Management” focuses on proactive management, and by analyzing data, it’s possible to anticipate the need for action and even revise processes. 

    02:27

    Nigel: Although the word “Personnel” describes a workforce quite adequately, accepting the “Human” and the “Resources” banners shows an acknowledgment of the humanity and value of a group of employees.

    Lois: OK. So you said the terms “Human Resources” and “Human Capital Management” are used interchangeably. Are there any differences at all to distinguish between the two?

    02:49

    Nigel: Human Resources Management primarily focuses on core administrative HR functions such as maintaining employee records and administering processes such as compensation, benefits, and recruiting. Human Capital Management is a broader term that includes the same Human Resources Management functions, as well as strategic functions such as analytics, planning, and performance management.

    Despite this distinction, most of us are a tad lazy and just lump everything under the same term. Some use Human Resources, some use Human Capital Management, some alternate between the two.

    03:23

    Nikita: Nigel, why do organizations need to manage their Human Capital?

    Nigel: Human Resources Management is a very important function in every organization. Without it, companies would not be able to effectively recruit and retain employees, improve, and enhance the organization, and they wouldn’t be able to maintain a healthy, accepting workplace culture and environment. Human Resources Management is so important to organizations that many call this function the heart and soul of the business.

    03:51

    Nigel: With a major shift from just focusing on the organization’s needs, to the needs and welfare of the employee, you end up with a happier and more productive employee. Many people are motivated by monetary awards, so a fair compensation package is paramount to the recruitment and retention of these employees. Others, whilst unlikely to work for free, are focused more on their contribution to the business and are interested in career development and progression. Therefore, a robust performance management and clear career path should be developed. 

    Whether an employee approaches their career from a monetary or a job satisfaction point of view, it’s all about “worth,” and an employee whose worth is satisfied is a happy employee and, therefore, more productive. So, organizations should be able to recognize that people are motivated by different things and have systems and processes in place to facilitate this, essentially bringing the best out of each employee.

    04:46

    Lois: That’s really interesting, Nigel. So, what are the key functions within a Human Resources department?

    Nigel: Human Resources is a broad subject and as such covers many functional areas.

    First and foremost is Talent Management. This is the recruitment aspect of the business. Efficient processes here ensure that vacancies are filled as efficiently as possible, by the best applicant identified for the job.

    The next is Benefits. For those employees that are motivated by cold hard cash, a robust benefits package ensures that employee retention is maintained at a high level, and that rates of attrition are minimized. This could be in the form of medical and/or dental insurance, Savings and Pension schemes, and even simple pleasures of life such as discount vouchers, a subsidized canteen, company-sponsored activities, Pizza Fridays, and last but definitely not least… free coffee on tap.

    05:39

    Nigel: Next, we have Absence Management, Time and Labor, and Payroll. These provide an efficient way to document the work performed by employees, and as a result the employee is paid what they are owed in a timely manner. It also encompasses the recording of time such as Vacation, Sickness, Maternity, Jury Service… to name just a few. Some of this time may result in the need to adjust the payments made to an employee, which is why it is included in this grouping.

    We also have Compensation and Rewards. I guess this is the more serious side of the money. Every employee wants to be paid what they are worth, for the job they do and contributions they make. The most basic way to compensate an employee, of course, is their regular salary. However, there are many other rewards and incentives that an organization can offer, such as bonuses, premium pay for working overtime or on a public holiday. Some rewards are based on the job that somebody does, such as Commission, which is a reward typically offered to employees in a Sales role, as an incentive to close deals.

    06:43

    The Oracle University Learning Community is a great place for you to collaborate and learn with experts, peers, and practitioners. Grow your skills, inspire innovation, and celebrate your successes. The more you participate, the more recognition you can earn. All of your activities, from liking a post to answering questions and sharing with others, will help you earn badges and ranks and be recognized within the community.

    If you are already an Oracle MyLearn user, go to MyLearn to join the community. You will need to log in first. If you have not yet accessed Oracle MyLearn, visit mylearn.oracle.com and create an account to get started.

    07:24

    Nikita: Welcome back. Nigel, you were telling us about all the functional areas within Human Resources…

    Nigel: As I was saying earlier, some employees are more motivated by job satisfaction and career progression, and the next two areas of HR speak more to them. 

    The first is Performance Management. This is where the organization manages the employee’s goals and performance reviews. A healthy and achievable set of goals focuses the employee into doing what they need to do to “get the job done” and to be evaluated on that work.

    And the second is Learning and Development. In order to progress in their current job, future career aspirations, and also personally, an organization needs to have a mechanism for employees to develop and grow, and to be nurtured in order to not only bring the best out of them, but also to ensure interest in being employed by the business is retained.

    08:13

    Lois: Yep, we all want that…

    Nigel: Exactly.

    And finally, we have Human Resources Planning. In order for larger organizations to thrive, a robust resourcing plan is required. This is generally split into two parts. The first of which is to make sure that each part of the business is resourced according to the workloads. For example, in the retail, manufacturing, and care hospitality industries, workloads are based on “shifts,” so it is incumbent on the management team to ensure that each shift is staffed adequately, by planning ahead as well as reacting to the odd curve ball when an employee cannot work due to unpredictable circumstances, like sickness.

    08:52

    The second part of this function lies with the prediction of possible staff movement and ensures that each part of the business can maintain operational. In some parts of the organization, it may not be imperative for you to be proactive, but in others, this will be the case. We can address this in many ways. The main ones include fostering relationships with employees, which will encourage them to not seek employment elsewhere, and to create Succession Plans or Talent Pools, which will ensure that other employees are nurtured and developed to such an extent that they are able to step up and progress to a vacant position if the need arises. 

    09:27

    Nikita: Wow, you’re right, Nigel. There are actually quite a lot of functional areas within HR. I’m guessing all this is not performed by the same person, right? So, who are the key players here?

    Nigel: You are most definitely right there, Niki. This would be way too much for one person. However, that does depend on several factors, such as the size of the organization, the complexity of the processes developed, and the knowledge and experience of the people performing the duties.

    For example, in a small business, the number of employees to manage would be minimal and the processes put into place might also be minimal, which might be down to the fact that some processes and record keeping is outsourced to reduce the HR department’s wage bill. It could also be that the person employed to run the HR department is deliberately selected because they have experience with a wide range of functions.

    10:16

    Nigel: That said, it is more typical, especially for larger organizations, to have lots of employees working in the HR department, and the work they do is based on their area of expertise. For instance, managing Payrolls is a very specialist subject and as such it’s not unusual to see that as a separate “sub department” within HR.

    Of course, not all the work has to be undertaken from within the HR department itself. For the last 25 to 30 years, there’s been a shift towards Self Service. This means that some of the onus to enter and maintain data is placed firmly with the employee themselves. For instance, if an employee moves house or changes their phone number, it’s up to them to update that information in the system. If they wish to take a vacation, again it is up to them to enter and submit the request for consideration.

    11:04

    Nikita: Ya, that’s what we do…

    Nigel: Yeah right. And there’s the employee’s Line Manager whose job, from an HR point of view, is to ensure that the employee is keeping the relevant information up-to-date, and to respond to requests made by the employee, such as the previously mentioned vacation requests. In some organizations, it’s even the responsibility of the employee’s Line Manager to initiate data changes for things like Promotions, Salary Increases, Bonus Awards, and some general Assignment changes, such as working hours.

    So, we talked about the HR Specialists, the employees, and their line managers. The last group to play their part is the senior managers and directors. Some of them will be involved in overseeing the day-to-day operations within the HR function, such as the HR Manager, Payroll Manager, Compensation Manager, etc, whilst the most senior will have their influence centred around the more strategic side of the house...  the planning, the budgeting, the head counts, etc. and often form the buffer between the HR department and the Executive team.

    12:04

    Lois: So Nigel, let’s get down to the nuts and bolts of the HCM business processes. You spoke about all the functional areas that make up HCM, but is there a way to group these functional areas and the processes they encompass?

    Nigel: Absolutely, Lois. Within HCM, there are four main life cycles… Applicant, Employee, Rewards, and Talent. We’re going to be talking about each of these in a lot more detail in our upcoming episodes, but to whet your appetite, let me give you a brief synopsis of those life cycles, the processes they include, and how they interact with each other.

    12:38

    Nigel: So let us start with the Applicant Life Cycle. As you can imagine, this is the start of the whole HCM process. We need to identify vacancies within the organization, and subsequently seek out suitable applicants to fill those gaps. There’s a single process within the Applicant Life Cycle that we call “Recruit to Onboard,” which essentially is the whole recruitment campaign, right up to passing them over to HR so they can be converted from an applicant to an employee.

    At that point, the Employee Life Cycle kicks in. Each employee needs to be managed throughout their time with the organization, which may include Promotions, Transfers, basic assignment changes such as Line Manager Change, or Grade, to name just a couple. We call this the “Hire to Retire” processes.

    13:23

    However, it doesn’t stop there. The processes also include the need to manage absences and the subsequent return to work, which we call “Absence Planning to Productivity” and even the employee’s termination with the business should they wish to move on, called “Employee Separation to Workforce Analysis.”

    This leads us directly to the Rewards Life Cycle.

    13:42

    Lois: And everybody loves rewards!

    Nigel: Haha! There are four business processes included with this one. The first of which is “Benefits to Payroll,” which takes you through the mechanics of setting up benefit programs, which pass through to payroll, so that appropriate deductions can be made for the employee contributions.

    Then they have “Time Collection to Payroll.” This is where the employee records their worked time through various mediums such as Time Cards, Card Readers, Biometric Scanners, Web Clocks, and so on, which again are passed to payroll for processing and payment.

    We can’t forget the “Payroll to Payment” process, as this is the main one that works out the net pay that each employee should receive. Now, as we have already alluded to, the information for this comes from many sources, including Benefits, Compensation, and of course Payroll directly.

    14:30

    Nigel: The final process in this life cycle is “Reward Planning to Targeted Compensation.” I just mentioned that the information for payroll processing can come from many different sources, right? One of those is Compensation, but there is a whole set of activities that constitutes Compensation. We have to consider the employee’s base salary, we have to consider whether there are any ad hoc rewards that an employee can receive, and we also need to consider if there is a mechanism for managers to use a spreadsheet to award such compensation as Merit Increases and Bonuses, including the need to set budgets and awards based on models; for example, a percentage increase based on the employee’s performance review score.

    The final life cycle is Talent. This encompasses all aspects of developing and assessing employees and includes processes for “Goal Setting to Performance,” “Talent Review to Succession,” “Career Planning to Development,” and “Employee Insight to Work Life Balance.”

    15:26

    Nikita: Thank you, Nigel, for taking the time to give us these insights into the world of Human Capital Management. We’re really looking forward to you taking us through all the different HCM life cycles. To learn more about HCM business processes, visit mylearn.oracle.com.

    Lois: So, next week, you’ll be back with us to dive into the Applicant Life Cycle, which is the first HCM life cycle. Until then, this is Lois Houston…

    Nikita: And Nikita Abraham, signing off!

    15:52

    That’s all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We’d also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

    Getting Started with Business Process Training

    Getting Started with Business Process Training
    In today’s competitive landscape, a comprehensive understanding of business processes is critical to successfully deploying and using Oracle Cloud Applications. Having solid foundational knowledge of business processes can help you understand “how things are done” and apply your learning to the right processes, in the right way, at the right time.
     
    Join Lois Houston and Nikita Abraham, along with Bill Lawson, as they talk about how Oracle’s business process training can help everyone involved in an implementation project, from project teams and technical teams to end users.
     
    Oracle University Learning Community: https://education.oracle.com/ou-community
     
    Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, and the OU Studio Team for helping us create this episode.
     
    --------------------------------------------------------
     
    Episode Transcript:
     

    00:00

    Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let’s get started.

    00:26

    Lois: Hello and welcome to the Oracle University Podcast. I’m Lois Houston, Director of Product Innovation and Go to Market Programs with Oracle University, and with me is Nikita Abraham, Principal Technical Editor.

    Nikita: Hi everyone! We’re starting the third season of the Oracle University Podcast today, and this time around, our focus is going to be on Cloud Apps Business Processes. And we’re very excited about this episode, which will be an overview of the Business Process training and certification offered by Oracle University. We’ll discuss this training at length, learn how it can help you prepare for projects, and find out how everyone involved in an implementation—from project teams to technical teams and end users —can benefit from taking this training.

    01:12

    Lois: And we’re so excited to welcome Bill Lawson back to the podcast today. If you’ve been following our podcast, you already know Bill from last season. Bill is the Senior Director of Cloud Applications Product Management at Oracle University. His team is in charge of developing new content for Oracle Cloud Applications. So, all the amazing training that helps you successfully implement and operate our cloud apps is created by his team. Thanks so much, Bill, for being with us today. We’re really excited to talk with you.

    01:41

    Bill: I’m happy to be here to kick off this new season, Lois and Niki.

    Nikita: So, to start Bill, can you tell us a little about the Cloud Apps Business Process training in general? 

    Bill: Think of our Business Process training as Oracle’s official collection of courses designed to provide you with a foundational understanding of how end-to-end business process flows are defined. These are based off Oracle Modern Best Practices. So, we have a series of courses that enable learners to have a common foundational reference when implementing Oracle Cloud Applications.

    Ultimately, the goal of our Oracle Business Process training is to ensure that everybody in the organization, across all the various roles, are all on the same page when, you know, they are discovering and learning more about Oracle Cloud. 

    02:22

    Lois: We already have extensive Cloud Apps training, right? So, why did we decide to create this particular training? What’s different about these courses, Bill?

    Bill: While we do have a very comprehensive modern digital Oracle Cloud Applications training existing today, we felt there was an opportunity to educate our customers on foundational business processes, which are required knowledge to have even before anyone starts their application implementation journey. 

    To meet this important need, we developed Business Process training, which, once again, is defined by Oracle Modern Best Practices and driven by Oracle Fusion Cloud Applications. This training will help students by providing them with the skills that are required to maximize the use and impact of those applications in their business.

    03:03

    Bill: And also providing a common framework for teams to use and to refer to throughout their cloud implementation projects, aligning from the start to accelerate and improve project planning and improving decision-making throughout the cloud implementation cycle.

    The training also defines end-to-end business process flows and illustrates how organizations and business users across all job roles can best manage day-to-day business activities and tasks, in a format within MyLearn and Cloud Learning Subscriptions that's engaging, easy to digest, and easy to learn.
    In fact, knowledge of basic business processes will enable students to understand “how things are done” and then apply those right processes, in the right way, at the right time.

    03:44

    Nikita: And what areas are covered, Bill? 

    Bill: We have training on Oracle Human Capital Management or HCM, Enterprise Resource Planning (ERP), Customer Experience (CX) Sales, Supply Chain Management, which is SCM, and Procurement. 

    In HCM, we show examples of the full suite of HR processes that encompasses all stages of an employee's experience—from the time they apply for a job, to when they’re onboarded, ultimately to the last day they’re at the company.  

    In our ERP training, learners use how to process, record, and report on finances reports. ERP training is really focused within the financial management area within ERP.  

    Our Sales training teaches how to make the organization sales cycle more effective by gathering all the customer information in one place, increasing productivity, empowering sales reps to sell more, and obtaining accurate information for boosting revenue.

    04:36

    Bill: Under Supply Chain Management, we have a comprehensive Cloud Applications suite that includes many products such as Inventory Management, Order Management, Manufacturing, and many more. In our business process training, as an example, we cover the processes of forecasting anticipated demand of products and services and planning the supply of materials and components, production, distribution, marketing, and sales in order to meet that demand.

    And finally, in Procurement, students will learn the business processes encompassing every stage of the procurement life cycle–from the initial stage of onboarding suppliers, to identifying sourcing opportunities and initiating sourcing events, to authoring contracts, to ultimately receiving the product or service and closing out the financials.   

    05:23

    Lois: Wow, that’s a lot, Bill! So, let’s just say I’m getting started in my career with Cloud Applications. Would you recommend that I take this training or would I need to be more experienced to take it? 

    Bill: Anyone can take this training, Lois. We have learning paths from the beginner to the advanced level within our Cloud Learning Subscriptions today. The business process courses in particular are for any experience level, from the recent college grad to the seasoned professional who just wants to learn more about Oracle Cloud Applications.

    05:52

    Lois: OK, so let’s talk a little more about who this training is best for. Can you expand a little bit on who would benefit the most from the courses?

    Bill: The training is for anyone who wants to build a strong foundational knowledge of Oracle Cloud  
    Business Processes in order to successfully plan, implement, test, and use Oracle Cloud Applications. You can be a Business Process Owner, a Functional User, an Implementation Project Team Member, an Implementer, a User Acceptance Testing Team Member, or even a University Student. We feel that this knowledge is foundational for success in the cloud.

    06:26

    Bill: So, for example, a partner implementation team will benefit by gaining an understanding of the modern business process flows supported by Oracle Cloud Applications to gain a solid understanding in order to configure based on the flow. Or say, customer project teams who work with implementation teams and will benefit from defining common approaches and business rules for their organization at the onset of their application implementation to help avoid any delays in the project. In short, having the same fundamental knowledge throughout this training helps ensure everyone is on the same page when discovering, planning, configuring, and executing these business processes in the cloud. 

    07:09

    Want to learn about modern best practices for cloud applications? 

    Oracle University is offering (for a limited time) free Business Process training and certification in the areas of Human Capital Management, Financials, Customer Experience, Supply Chain Management, and Procurement. 

    Oracle Cloud training and certifications empower you to explore limitless possibilities in the cloud landscape. Gain the knowledge and skills needed to design, deploy, secure, and operate modern cloud infrastructure and applications with confidence.

    Go to education.oracle.com for more details.

    What are you waiting for? Get certified today!

    07:49

    Nikita: Welcome back! Bill, could you give us some examples of what I’ll learn if I take this Business Process training?

    Bill: Great question, Niki. Project teams, both business process owners and those involved in executing specific steps in the process, will gain a high-level understanding of how their teams’ processes and related tasks will change, and continue to evolve, when moving to the cloud.

    But it doesn’t end there. Project teams will also learn the basics around how organizations manage day-to-day business activities and tasks in such areas as I mentioned earlier… Finance, Human Capital Management, Sales, Supply Chain, and Procurement. They will learn about how Oracle Cloud Applications leverage emerging technologies, such as AI and machine learning, blockchain, and business intelligence, which help drive mission-critical organizational business processes. 

    08:39

    Bill: So, for example, let’s take the use case of a recruitment team lead. This training will provide an overview of the best practice steps in an applicant screening process that are enabled in Oracle HCM and how it relates to onboarding and other employee lifecycle processes. 

    This way, users can consider how their team’s current screening process steps and related tasks will be impacted as they move to the cloud, as well as how that process can evolve over time when enabled by new technologies. In addition, this training will show how to use machine learning to help screen and prioritize candidate résumés.  

    And with this base understanding, the recruitment team lead can contribute to improving the screening process when using Oracle HCM Recruiting and better the overall collaboration and project planning with their system integrator and other HR project teams.

    09:29

    Lois: So, you said we have a full suite of Business Process training courses. What’s the value in taking training outside of my area of responsibility?

    Bill: That’s such a great question, Lois. You’ll see, often in implementation projects, decision-making can be siloed. Business process owners consider the needs of their own team, especially as detailed requirements are documented and considered for each process. As leaders, they want to ensure their teams’ needs are thoroughly considered to ensure they can accomplish all that is expected of them.
    When planning a cloud implementation project, teams need not only consider how their own processes will change but also how the decisions they make in planning, configuring, and implementing Oracle Cloud Applications to suit their own needs will impact other teams and their processes.

    10:17

    Bill: That’s why getting the end-to-end view is so important, we believe. We created this training to ensure that business process owners across the organization, as well as the implementation teams supporting their projects, understand not only their own area of responsibility but are also considerate of the changes, the subsequent impact, on other teams as well. We really want to encourage collaboration from the beginning of the project to improve decision-making at all phases by developing this early-stage awareness and understanding.

    10:47

    Nikita: I’ve heard this training is a little different from the video-based training that we have for most of our other Cloud Apps courses. So, what’s different about it, Bill?

    Bill: Yeah, you’re right, Niki. So, this training combines a variety of elements, not just videos. We still do have some videos within our business process training. But it also includes rich text articles, descriptive imagery, concepts explained by experts, product demonstrations, and knowledge checks, to bring users the best possible learning experience.

    11:16

    Nikita: And along with this training, we also offer certifications, right? 

    Bill: Yeah, you’re absolutely right, Niki. For Business Process training, we have five associate-level exams included—one for each of the areas I mentioned. One for HCM, one for ERP Financials, Sales, Procurement, and Supply Chain Management. So, earning a Business Process Foundation Associate certification provides the candidate with an industry credential which recognizes a foundational understanding of the business process flows enabled by Oracle Cloud Applications. Our content prepares the candidate to earn that certification.

    11:50

    Lois: Well, this has been very enlightening, Bill. Thank you so much for joining us today and telling us all about the Business Process training and certifications that are available.

    Bill: Yeah, you’re welcome, Lois. And thanks for having me, Niki.

    Nikita: To get started on Oracle Business Process training, head over to mylearn.oracle.com. 

    Lois: Well, that’s all the time we have for today. Join us next week as we set off on our journey through the HCM business processes with Senior Principal Instructor Nigel Wiltshire. Until next week, this is Lois Houston…

    Nikita: And Nikita Abraham, signing off.

    12:22

    That’s all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We’d also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

    Oracle Data Lakehouse

    Oracle Data Lakehouse
    With each passing day, more and more data sources are sending greater volumes of data across the globe. For any organization, this combination of structured and unstructured data continues to be a challenge. Data lakehouses link, correlate, and analyze these varied outputs into a single manageable system.
     
    In the final episode of the season, hosts Lois Houston and Nikita Abraham, along with Greg Genovese, discuss Oracle Data Lakehouse, the premier solution for leveraging data to make better, more profitable business decisions.
     
     
    Oracle University Learning Community: https://education.oracle.com/ou-community
     
     
     
    Special thanks to Arijit Ghosh, David Wright, Ranbir Singh, and the OU Studio Team for helping us create this episode.
     
    --------------------------------------------------------
     
    Episode Transcript:
     

    00;00;00;00 - 00;00;39;03

    Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let's get started!

    Hello and welcome to the Oracle University Podcast. I'm Nikita Abraham, Principal Technical Editor with Oracle University, and with me is Lois Houston, Director of Product Innovation and Go to Market Programs.

     

    00;00;39;06 - 00;01;17;11

    Hi there! Last week, we spoke about managing Oracle Database with REST APIs and also looked at ADB built-in tools. Today's episode is the last one of the season, and we're going to be joined by Oracle Database Specialist Greg Genovese, who will talk with us about Oracle Data Lakehouse.

    Hi, Greg. I've heard about data lakes and data warehouses, but what’s a lakehouse?

    Traditionally, when deciding how to best increase their data productivity and liquidity, companies often find themselves having to make a choice between leveraging a data lake or a data warehouse, each of them having their own benefits and drawbacks.

     

    00;01;17;13 - 00;01;43;20

    Now, companies no longer need to make that choice. Instead, they can look to a broader strategy that offers highly accurate machine learning capabilities, the flexibility of using open-source services, and the superior data and analytics capabilities of the best-in-class Oracle Database and Data Warehouse. These capabilities are integrated with common identity, data integration, orchestration, and catalog into a unified architecture - the Oracle Lakehouse.

     

    00;01;43;24 - 00;02;12;26

    What are the benefits of Oracle Lakehouse?

    Oracle Lakehouse facilitates ease of data reuse and recombination, maximizing insights from your data and generating several other benefits, including pure cost savings, as well as improving the agility of your current data warehouse by easily extending with new metrics, details, or attributes, which help you better understand your customers, your processes, or your risks, all while using your existing applications.

     

    00;02;13;01 - 00;02;33;09

    Is this only for companies that are already using Oracle Cloud Infrastructure?

    For those of you companies who haven't yet adopted Oracle Cloud Infrastructure, but instead have existing data lakes on AWS or Azure, if you still want to make that data available to the Oracle Autonomous Database, you can reach out to these data lakes using Oracle SQL.

     

    00;02;33;10 - 00;02;57;17

    Here at OCI, we feel your experience would not be a productive one if you weren't allowed to use your choice of tools and applications, such as Analytics Cloud, Tableau, Looker, Notebook, REST, Python, and more.

    Can you tell us more about how Oracle Data Lakehouse works?

    It combines current data warehouse and data lake components with capabilities to also include external or third-party data.

     

    00;02;57;20 - 00;03;29;04

    This effectively eliminates data silos or having to manually move data between data warehouses and data lakes if you leverage both currently. The five key elements of the Oracle Lakehouse are the data warehouse, the data lake for raw data normally used for loading and staging data, managed open-source services to support Spark, Hadoop, and Redis, data integration, moving data depending on use case, and data catalog, which maintains a complete view of the available data for discovery and governance.

     

    00;03;29;07 - 00;03;49;29

    With these elements, you can write the data once with any engine and analyze or even build machine learning modules from any of your current data.

    How did the idea for data lakehouse come about? What was the need for it?

    Using all data to innovate, this is the challenge, to include all of your data and use it to drive better, more profitable business decisions.

     

    00;03;50;02 - 00;04;14;07

    Some data is easy to access, but accessing all of your data and then correlating that data in a way that helps make decisions and drive better outcomes isn't easy. So, the opportunity we've identified here is harnessing the power of all that data and creating a competitive advantage from it.

    But how do we do that? How do we run and maintain what we've got today efficiently, quickly, and securely?

     

    00;04;14;08 - 00;04;42;02

    We have functions that move data from sources to outcomes. The process is taking the source, going through integrations, and connecting the different data. Once we've done this, traditionally, we looked at persistence, processing the data and storing it somewhere to pass along for analysis. This has connected and curated the data for outcomes. The Oracle Lakehouse is a solution leveraging multiple tools and products to get the desired outcomes from this process.

     

    00;04;42;04 - 00;05;05;17

    You can use existing data warehouses to start, and the data warehouse, especially the Converged Autonomous Database, allows for storing all types of data. This is for the relational structured data to store in an Oracle autonomous database or warehouse. The Autonomous Data Warehouse is self-managed with better performance and efficiencies to help focus on the analysis and the outcomes of the data.

     

    00;05;05;20 - 00;05;23;12

    The unstructured or raw data can be persisted in any data type in its current format within object storage. This can be within an existing data lake, for example. Object storage is an efficient manner to land data where it's needed.

     

    00;05;23;15 - 00;05;52;12

    Are you attending Oracle CloudWorld 2023? Learn from experts, network with peers, and find out about the latest innovations when Oracle CloudWorld returns to Las Vegas from September 18 through 21. CloudWorld is the best place to learn about Oracle solutions from the people who build and use them. In addition to your attendance at CloudWorld, your ticket gives you access to Oracle MyLearn and all of the cloud learning subscription content, as well as three free certification exam credits.

     

    00;05;52;18 - 00;06;28;13

    This is valid from the week you register through 60 days after the conference. So, what are you waiting for? Register today. Learn more about Oracle CloudWorld at www.oracle.com/cloudworld.

    Welcome back. Okay, so Greg, you spoke about the start of data lakehouse. Tell us about data integration and analysis.

    Lakehouse provides for an all encompassing orchestration of integration and is allowing your choice of tools to keep your source of truth and compliance for your data.

     

    00;06;28;16 - 00;07;03;00

    Whether you decide to deploy Oracle GoldenGate, the premiere data integration tool, Oracle Data Integration, helping you move data within the lake, or even an open-source or third-party tool, Lakehouse is by design flexible and meant to fit your specific needs. Oracle Analytics Cloud is used to perform predictive analytics, and other third-party tools can read into the data from the database APIs or using SQL. Oracle AI Service has machine learning models that will continue to work with the transactional systems and bring in other data types as well.

     

    00;07;03;03 - 00;07;35;14

    OCI Data Science can harness all of the data for better business outcomes and fills in the tools for integration and analysis for the Oracle Data Lakehouse. Within the Autonomous Data Warehouse, we have transactional and dimensional query capabilities, but in our Lakehouse story, we're also very lucky to have products like MySQL HeatWave, the blazing fast in-memory query accelerator, which increases MySQL performance by orders of magnitude for analytics and mixed workloads, all without any changes to your existing applications.

     

    00;07;35;16 - 00;08;00;20

    Really, no other cloud provider is going to give you that much choice in the data warehouse bucket and managed open-source components.

    So, from what I understand, Lakehouse has options for all types of data, but what about understanding and managing the metadata of data sources?

    The OCI Data Catalog captures whether you're building a schema, building a query from ADW, or building a table that you want to query from a Spark job.

     

    00;08;00;23 - 00;08;26;13

    And all that data definition goes into the OCI data catalog. So, wherever this data goes, you'll be able to access it. The data catalog is the source of truth for object store metadata and can regularly harvest the information from the data sources. It also manages the business glossary, providing consistent terms and tags for your data. Discovery of data is a powerful search feature to discover new data sets entirely.

     

    00;08;26;15 - 00;08;50;08

    Even with all these capabilities, there are still more being added or enhanced over time. For example, now with OCI Data Flow, you have a serverless Spark service. You can build a Spark job that makes sense from some unstructured data and include it as a part of the Oracle Lakehouse. Enterprises are moving to data flow because you can write, decode, and execute code, and focus on the application, because the challenging part of where this is running is handled through the service components of the Oracle Lakehouse.

     

    00;08;50;11 - 00;09;13;06

    I think what we all want, Greg, is faster insights on our data, right?

    As you put everything together into this architecture. The key thing is that you want to be able to write data once and then combine it with other previously written data, move it around, combine it here and there, and analyze.

     

    00;09;13;09 - 00;09;36;26

    So, we have a way to store both structured and unstructured data. You have the object store for unstructured data and write your structured data to a relational database, perhaps MySQL or Oracle database, and you can then leverage the Oracle Data Catalog to have a single way to understand and tag your data. Oracle Data Lakehouse is an open and collaborative approach.

     

    00;09;36;28 - 00;10;04;22

    It stores all data in an order that's easy to understand and analyze through a variety of services, as well as AI tools. OCI can accelerate your solution development for your most common Data Lakehouse workloads. You can easily get started from where you are today, and often without writing any new code whatsoever. Within each path, we can work with you at Oracle to highlight the investments we've made that will help accelerate your own Lakehouse transformation.

     

    00;10;04;24 - 00;10;39;11

    The Oracle Data Lakehouse is the premier solution for transforming data into better, more profitable business decisions. Remember, it's not just your architecture that's powerful. With Oracle Lakehouse, you can help combine the architecture, data sets, services, and tools across your entire technical landscape into something more valuable than just the sum of its parts.

    Thank you so much, Greg, for sharing your expertise with us.

    To learn more about Oracle Data Lakehouse, please visit mylearn.oracle.com and take a look at our Oracle Cloud Data Management Foundations Workshop.

     

    00;10;39;18 - 00;11;04;14

    That brings us to the end of this season. Thank you for being with us on this journey. We're very excited about our upcoming season, which will be dedicated to Cloud Applications Business Process training. Until next time, this is Lois Houston and Nikita Abraham signing off.

    That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes.

     

    00;11;04;16 - 00;13;38;07

    We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

    Managing Oracle Database with REST APIs and ADB Built-in Tools

    Managing Oracle Database with REST APIs and ADB Built-in Tools
    In this episode, Lois Houston and Nikita Abraham are joined by Cloud Engineer Nick Commisso to talk about managing Oracle Database with REST APIs.
     
    They also look at Autonomous Database built-in tools, which are pre-assembled, pre-configured, and pre-deployed, delivering a consistent user experience.
     
     
    Oracle University Learning Community: https://education.oracle.com/ou-community
     
     
     
    Special thanks to Arijit Ghosh, David Wright, Deepak Modi, and the OU Studio Team for helping us create this episode.
     
    --------------------------------------------------------
     
    Episode Transcript:
     

    00;00;00;00 - 00;00;39;06

    Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let's get started!

    Hello and welcome to the Oracle University Podcast. I'm Lois Houston, Director of Product Innovation and Go to Market Programs with Oracle University. And with me is Nikita Abraham, Principal Technical Editor.

     

    00;00;39;12 - 00;01;04;12

    Hello again! Last week, we discussed Oracle Cloud Infrastructure’s Maximum Availability Architecture. And in today's episode, we'll talk about managing Oracle Database with REST APIs and also look at Autonomous Database built-in tools with our Cloud Engineer Nick Commisso.

    Hi Nick, thanks for being back on the podcast. What is Oracle REST Data Services? What do you use it for?

     

    00;01;04;14 - 00;01;31;07

    Oracle is not just a relational database anymore. And the REST APIs can be deployed with Oracle REST Data Services or ORDS to handle all of these data format models. And you can use ORDS for application development and accessing the data and can be used as a powerful tool for automating management, lifecycle, provisioning, and data-dictionary-type use.

     

    00;01;31;09 - 00;02;02;02

    Oracle Cloud offers full REST APIs for DBAs and developers who would prefer to interact with Oracle Autonomous Database Cloud services programmatically over REST rather than log in to the cloud console and click through screens. This provides a mechanism for developing customized deployment and management scripts that can be saved and reused for deployments, setting gold standards, and storing entire application infrastructure stacks as version-controlled code.

     

    00;02;02;08 - 00;02;35;15

    I think before we move on, it's important to clarify. For anyone who doesn't already know, what is REST? How do Oracle Cloud Infrastructure APIs use REST and HTTPS?

    REST is combined with HTTPS, but is not a protocol. REST is an acronym for Representational Stateless Transfer. The Oracle Cloud Infrastructure APIs are typical REST APIs that use HTTPS requests and responses and support HTTPS and SSL protocol TLS 1.2, the most secure industry standards.

     

    00;02;35;15 - 00;03;18;17

    Calls to the Oracle Cloud Infrastructure using REST APIs can be written in popular scripting languages such as Node.js, Python, Ruby, Perl, Java, C#, Bash, or Curl. The way you interact with your data are the API calls via HTTP - GET to access your data and stored procedures. PUT to update your data. POST to insert your data and execute PL/SQL. And DELETE to remove your data.

    When making an HTTP request with Oracle REST Data Services, how does the process flow from the request to accessing data in the database?

     

    00;03;18;17 - 00;03;46;21

    A person, process, or computer gets ready to make an HTTP request. You need to tell the request where the thing or data is, and the request will get into the web tier where ORDS is running. ORDS then translates the REST request to a SQL statement and accesses the table to get the information requested.

     

    00;03;46;24 - 00;04;13;11

    The result normally comes back as a JSON, but can also return an HTML, binary, and CSV. With all of these requests, a collection of connections to the database or connection pool is used and all of the data might not return, depending on the device asking. The results set up links to get more data, but each each time, this links to get another request through the connection pool.

     

    00;04;13;13 - 00;04;41;06

    The default size of the connection pool are 10 and it depends how fast is the database code that's tied to the APIs. But 10 probably isn't enough. Because of the results and connection pooling, it shouldn't be long-running code when using APIs.

    What is the architecture of Oracle REST Data Services? Can you tell us about the integration with components like Java servlets, Tomcat, WebLogic, and Apache?

     

    00;04;41;08 - 00;05;13;24

    Also, how does ORDS enable authentication and access to data in the Oracle database through REST calls?

    ORDS runs in a Java servlet. Or it can be run within Tomcat or WebLogic for E-Business or Fusion. The request comes into the web server and ORDS handles the request. ORDS is included in your Oracle database license. This is a simplified view of your architecture, but there's normally a load balancer in front of the Apache server to handle the requests coming in.

     

    00;05;13;27 - 00;05;50;09

    The REST service is already hooked up into the database. Authentication with the web server and the hooks are there to be accessing the data. The code and the data is already in the database in the APEX apps. And the REST calls allow for you to access the data. It harnesses the Oracle database. In order to manage your database with automation, along with minimal human interaction, you need to use ORDS and the REST APIs that are enabled for database management to provision, control, and monitor the Oracle database.

     

    00;05;50;11 - 00;06;20;22

    You need an Oracle database for ORDS to work. ORDS can run anywhere that Oracle can run and is easily plugged into the Oracle Database Management pipeline.

    What are some key features and functionalities offered by the Oracle Database REST APIs?

    There are over 600 REST endpoints provided to manage and monitor your Oracle database. These are supported starting from 11gR2 up to the current version of the database.

     

    00;06;20;25 - 00;06;51;14

    The REST APIs have general information, data dictionary, monitoring, performance, and lifecycle management.

    Can you give us some examples of specific details that are accessible through the REST APIs?

    For performance, there's Top SQL, ASH, and AWR reports. For monitoring, you can look at sessions, locks, waits, and alert logs. Lifecycle will allow you to manage multitenant for provisioning PDBs.

     

    00;06;51;16 - 00;07;16;08

    And let's not forget about the data dictionary tables where you can report on objects and database operations.

    And how do you get started with ORDS?

    To get started using ORDS, you need to install ORDS. You run the installer and there are configuration files that are also created that can be adjusted later. You need the information about connection to the database where you want ORDS installed.

     

    00;07;16;10 - 00;07;47;08

    What goes into the database is the schema, ORDS_METADATA, and a user, ORDS_PUBLIC_USER.

    Are you attending Oracle CloudWorld 2023? Learn from experts, network with peers, and find out about the latest innovations when Oracle CloudWorld returns to Las Vegas from September 18 through 21. CloudWorld is the best place to learn about Oracle solutions from the people who build and use them.

     

    00;07;47;08 - 00;08;15;02

    In addition to your attendance at CloudWorld, your ticket gives you access to Oracle MyLearn and all of the cloud learning subscription content as well as three free certification exam credits. This is valid from the week you register through 60 days after the conference. So, what are you waiting for? Register today. Learn more about Oracle CloudWorld at www.oracle.com/cloudworld.

     

    00;08;15;04 - 00;08;48;14

    Welcome back. Let's move on to Oracle's data toolset. Nick, what are the key tools offered by Oracle for data analysis and integration?

    Oracle Data Integrator or ODI is an enterprise class data integration tool with extract, load, and transform, or ELT architecture. Enterprise Data Quality or EDQ is a sophisticated, powerful tool for profiling, cleaning, and preparing your data.

     

    00;08;48;17 - 00;09;24;14

    Analytic views built into Oracle database provides a common framework for defining universally accessible semantic models. Oracle Analytics Cloud, or OAC, is the perfect complement, providing beautiful and insightful analysis of this data.

    So, how do these tools come together? 

    For our traditional market, this is a comprehensive and compelling suite of tools. Enterprise class tools for an enterprise class market. With autonomous database, we deliver an integrated platform.

     

    00;09;24;17 - 00;09;47;24

    It's not a single tool with the customer left to buy the other tools that we need, nor is it a solution delivered in kit form with the customer left to cobble it all together. It's pre-assembled, preconfigured, and pre-deployed. There is a consistent user experience with built-in best practices. It's like having an expert in a box there to guide you.

     

    00;09;47;26 - 00;10;12;15

    Components are defined in the common database layer so that they can be shared by all users in all tools.

    And the metadata?

    And all of this metadata is brought together in the catalog. So, it's not just the tools that are integrated, it's the data too, a business model spanning data sources that can be federated when appropriate and defined in a common data catalog, which eliminates silos.

     

    00;10;12;17 - 00;10;49;24

    The result is renewed confidence in data lineage and impact analysis. In other words, we have collaboration by design. This built-in collaboration between specialists eliminates silos. For example, hierarchies recognized automatically in the data preparation phase are defined in the database itself, are immediately accessible to the data analysts for aggregation purposes. Additional semantic modeling by the analysts, perhaps defining sophisticated calculations, such as percentage change since last year, and again, defined in the database itself, can be accessed by the data scientist.

     

    00;10;49;27 - 00;11;15;19

    This provides a great headstart in developing predictive models that, in turn, can be used by the CRM developer who might want to augment a customer view with the most suitable campaign to discuss during the next meeting. So, autonomous database comes with a sophisticated suite of tools pre-installed.

     

    00;11;15;20 - 00;11;40;10

    So, it's basically an open platform with open standards.

    If you want to speak SQL, speak SQL, so do we. We speak Python too, if that's your preference. Whether your data is in a CSV file or a JSON format, it's going to be comfortably at home in autonomous database. Using the language of your choice, analyze your data using whatever tool you're most comfortable with.

     

    00;11;40;17 - 00;12;00;18

    The whole idea is that there should be nothing new to learn.

    Thanks, Nick, for joining us today. To learn more about ADB built-in tools, head over to mylearn.oracle.com and get started on our free Oracle Cloud Data Management Foundations Workshop. Next week will be our last episode of the season where we’ll look at Oracle Data Lakehouse.

     

    00;12;00;21 - 00;14;47;18

    Until then, this is Nikita Abraham and Lois Houston signing off.

    That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

    Maximum Availability Architecture

    Maximum Availability Architecture
    Join Lois Houston and Nikita Abraham, along with Alex Bouchereau, as they talk about Oracle Maximum Availability Architecture, which provides architecture, configuration, and lifecycle best practices for Oracle Databases.
     
    Oracle University Learning Community: https://education.oracle.com/ou-community
     
    Special thanks to Arijit Ghosh, David Wright, Ranbir Singh, and the OU Studio Team for helping us create this episode.
     
    --------------------------------------------------------
     
    Episode Transcript:
     

    00;00;00;00 - 00;00;39;11

    Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we'll bring you foundational training on the most popular Oracle technologies. Let's get started.

    Hello and welcome to the Oracle University Podcast. I'm Nikita Abraham, Principal Technical Editor with Oracle University, and I'm joined by Lois Houston, Director of Product Innovation and Go to Market Programs.

     

    00;00;39;18 - 00;01;12;09

    Hi, everyone. Last week, we discussed Oracle's Maximum Security Architecture, and today, we're moving on to Oracle Cloud Infrastructure's Maximum Availability Architecture. To take us through this, we're once again joined by Oracle Database Specialist Alex Bouchereau.

    Welcome, Alex. We're so happy you're becoming a regular on our podcast. So, to start, what is OCI Maximum Availability Architecture?

    Now, before we actually jump into the specifics, it's important to understand the problem we're trying to address.

     

    00;01;12;11 - 00;01;38;01

    And that is database downtime and data protection. We don't want any data loss and the impact of both of these types of occurrences can be significant. Now, $350K on average of costs of downtime per hour, 87 hours average amount of downtime per year is pretty significant. So, it's a very, very common occurrence. It's $10 million for a single outage, depending on how critical the application is.

     

    00;01;38;03 - 00;02;02;28

    And 91% of companies have experienced unplanned data center outages, which means this occurs fairly often.

    So, what can we do about this? How do we address the problem of data loss?

    It's important to understand a different terminology first. So, we'll start with high availability. High availability provides redundant components to go ahead and ensure your service is uninterrupted in case of a type of hardware failure.

     

    00;02;03;01 - 00;02;24;24

    So, if one server goes down, the other servers will be up. Ideally, you'll have a cluster to go ahead and provide that level of redundancy. And then we talk about scalability. Depending upon the workload, you want to ensure that you still have your performance. So, as your application becomes more popular and more end users go ahead and join it, the workload increases.

     

    00;02;24;26 - 00;02;42;28

    So, you want to ensure that the performance is not impacted at all. So, if we want to go ahead and minimize the time of our planned maintenance, which happens more often and a lot more often than unplanned outages, we need to do so in a rolling fashion. And that's where rolling upgrades, rolling patches, and all these types of features come into play.

     

    00;02;42;29 - 00;03;10;20

    Okay, so just to recap, the key terms you spoke about were high availability, which is if one server goes down, others will be up, scalability, which is even if the workload increases, performance isn’t impacted, and rolling updates, which is managing planned updates seamlessly with no downtime.

    Great. What's next?

    Disaster recovery. So, we move from high availability to disaster recovery, protecting us from a complete site outage.

     

    00;03;10;27 - 00;03;35;02

    So, if the site goes down entirely, we want to have a redundant site to be able to failover to. That's where disaster recovery comes into play. And then how do we measure downtime and data loss? So, we do so with Recovery Point Objectives, or RPOs, measuring data loss and Recovery Time Objectives, or RTOs, measuring our downtime.

     

    00;03;35;05 - 00;04;00;22

    Alex, when you say measure downtime, how do we actually do that?

    Well, we use a technique called chaos engineering. Essentially, it's an art form at the end of the day because it's constantly evolving and changing over time. We're proactively breaking things in the system and we're testing how our failover, how our resiliency, and how our switchovers, and how everything goes ahead and works under the covers with all our different features.

     

    00;04;00;23 - 00;04;21;28

    A lot of components can suffer an outage, right?

    We have networks and servers, storage, and all these different components can fail. But also human error. Someone can delete a table. You could delete a bunch of rows. So, they can make a mistake on the system as well. That occurs very often. Data corruption and then, of course, power failures.

     

    00;04;22;00 - 00;04;45;03

    Godzilla could attack and take out the entire data center.

    Godzilla! Ha!

    And you want to be able to go ahead and have a disaster recovery in place. And then there's all kinds of maintenance activities that happen with application updates. You might want to reorganize the data without changing the application and the small, little optimizations. And these can all happen in isolation and or in combination with each other.

     

    00;04;45;05 - 00;05;19;03

    And so chaos engineers take all this into consideration and build out the use cases to go ahead and test the system.

    Do we have some best practices in place for this, then?

    Oracle Maximum Availability Architecture, MAA, is Oracle's best practice blueprint based on proven Oracle high availability technologies, end-to-end validation, expert recommendations, and customer experiences. The key goal of MAA is to achieve optimal high availability, data protection, and disaster recovery for Oracle customers at the lowest cost and complexity.

     

    00;05;19;05 - 00;05;54;07

    MAA consists of reference architectures for various buckets of HA service-level agreements, configuration practices, and HA lifecycle operational best practices, and are applicable for non-engineered systems, engineered systems, non-cloud, and cloud deployments. Availability of data and applications is an important element of every IT strategy. At Oracle, we've used our decades of enterprise experience to develop an all-encompassing framework that we can all call Oracle MAA, for Maximum Availability Architecture.

     

    00;05;54;07 - 00;06;20;21

    And how was Oracle's Maximum Availability Architecture developed?

    Oracle MAA starts with customer insights and expert recommendations. These have been collected from our huge pool of customers and community of database architects, software engineers, and database strategists. Over the years, this has helped the Oracle MAA development team gain a deep and complete understanding of various kinds of events that can affect availability.

     

    00;06;20;24 - 00;06;48;11

    Through this, they have developed an array of availability reference architectures. These reference architectures acknowledge not all data or applications require the same protection and that there are real tradeoffs in terms of cost and effort that should be considered. Whatever your availability goals may be for a database or related applications, Oracle has the product functionality and guidance to ensure you can make the right decision with full knowledge of the tradeoffs in terms of downtime, data loss, and costs.

     

    00;06;48;11 - 00;07;04;01

    These reference architectures use a wide array of our HA features, configurations, and operational practices.

     

    00;07;04;03 - 00;07;29;04

    Want to get the inside scoop on Oracle University? Head on over to the all-new Oracle University Learning Community. Attend exclusive events. Read up on the latest news. Get firsthand access to new products and stay up-to-date with upcoming certification opportunities. If you're already an Oracle MyLearn user, go to mylearn.oracle.com to join the community. You will need to log in first. If you've not yet accessed Oracle MyLearn, visit mylearn.oracle.com and create an account to get started.

     

    00;07;29;04 - 00;07;57;19

    Join the community today.

    Welcome back. Alex, you were telling us about how Oracle MAA or Maximum Availability Architecture has reference architectures that use a series of high availability features and configurations. But, how do these help our customers?

    They help our end customers achieve primarily four goals.

     

    00;07;57;22 - 00;08;29;29

    Number one, data protection, reducing data loss through flashback and absolute data protection through zero data loss recovery appliance. Number two, active replication, which allows customers to connect their applications to replicated sites in an active-active HA solution through Active Data Guard and GoldenGate. Number three, scale out, which allows customers the ability to scale compute nodes linearly through RAC, ASM, and Sharding.

     

    00;08;30;01 - 00;08;58;19

    Four, continuous availability. This allows transparent failovers of services across sites distributed locally or remote, through AC and GDS. These features and solutions allow customers to mitigate not only planned events, such as software upgrades, data schema changes, and patching, but also unplanned events, such as hardware failures and software crashes due to bugs. Finally, customers have various deployment choices on which we can deploy these HA solutions.

     

    00;08;58;22 - 00;09;25;02

    The insights, recommendations, reference architectures, features, configurations, best practices, and deployment choices combine to form a holistic blueprint, which allows customers to successfully achieve their high availability goals.

    What are the different technologies that come into play here?

    Well, we'll start with RAC. So, RAC is a clustering technology spread through different nodes across the different servers, so you don't have a single point of failure.

     

    00;09;25;05 - 00;09;46;13

    From a scalability standpoint and performance standpoint, you get a lot of benefit associated with that. You constantly add a new node whenever you want to without experiencing any downtime. So, you have that flexibility at this point. And if any type of outage occurs, all the committed transactions are going to be protected and we'll go ahead and we'll move that session over to a new service.

     

    00;09;46;15 - 00;10;07;27

    So, from that point, we want to go ahead and also protect our in-flight transactions.

    So, when it comes to in-flight transactions, how are we going to protect those in addition to the RAC nodes?

    Well, we can go ahead and do so with another piece of technology that's built into RAC, and that's the Transparent Application Continuity feature. So, this feature is going to expand the capabilities of RAC.

     

    00;10;08;03 - 00;10;28;18

    It's a feature of RAC to go ahead and protect our in-flight transactions so our application doesn't experience those transactions failing and coming back up to the layer, or even up to the end users. We want to capture those. We want to replay them. So that's what application continuity does. It allows us to go in and do that.

     

    00;10;28;21 - 00;10;51;03

    It supports a whole bunch of different technologies, from Java, .NET, PHP. You don't have to make any changes to the application. All you have to do is use the correct driver and have the connection string appropriately configured and everything else is happening in the database.

    What about for disaster recovery?

    Active Data Guard is the Oracle solution for disaster recovery.

     

    00;10;51;05 - 00;11;29;08

    It eliminates a single point of failure by providing one or more synchronized physical replicas of the production database. It uses Oracle Aware Replication to efficiently use network bandwidth and provide unique levels of data protection. It provides data availability with fast, manual, or automatic failover to standby should a primary fail and fast switch over to a standby for the purpose of minimizing planned downtime as well. An Active Data Guard standby is open, read only, while it is being synchronized, providing advanced features for data protection, availability, and protection offload.

     

    00;11;29;08 - 00;11;50;23

    We have different database services, right? We have our Oracle Database Cloud servers, we have Exadata Cloud servers, and we have Autonomous Database. Do they all have varying technologies built into them?

    All of them are Database Aware architecture at the end of the day. And the Oracle Database Cloud Service, you have the choice of single instance, or you can go ahead and choose between RAC as well.

     

    00;11;50;25 - 00;12;23;25

    You can use quick migration via Zero Downtime Migration, or ZDM for short. We have automated backups built in, and you can set up cross-regional or cross availability to do any DR with Active Data Guard through our control play. And we build on that with Exadata Cloud Service by going ahead and changing the foundation to Exadata, with all the rich benefits of performance, scalability, and optimizations for the Oracle Database, and all the different HA and DR technologies that run within it, to the cloud.

     

    00;12;23;27 - 00;12;50;22

    Very easy to go ahead and move from Exadata on-premise to Exadata Cloud Service. And you have choices. You can do the public cloud, or you can do Cloud@Customer or ExaCC, as we call it, to go ahead and run Exadata within your own data center--Exadata Cloud Service and your own data center. And building on top of that, we have Autonomous, which also builds on top of that Exadata infrastructure.

     

    00;12;50;25 - 00;13;19;12

    And we have two flavors of that. We have shared and we have dedicated, depending upon your requirements.

    And is all of this managed by Oracle?

    Now, at this point, everything's managed by Oracle and things like Data Guard can be configured. We call it Autonomous Data Guard in the Autonomous Database. With a simple two clicks, you can set up cross-regional or cross availability domain VR. And then everything is built, of course, from a high-available multitenant RAC infrastructure.

     

    00;13;19;15 - 00;13;48;02

    So, it's using all other technologies and optimizations that we've been talking about.

    Thanks, Alex, for listing out the different offerings we have. I think we can wind up for today. Any final thoughts?

    So high availability, disaster recovery, absolute requirements. Everybody should have it. Everybody should think of it ahead of time. We have different blueprints, different tiers of our MAA architecture that map different RTO and RPO requirements depending upon your needs.

     

    00;13;48;04 - 00;14;12;01

    And those may change over time. And finally, the business continuity we can provide with MAA is for both planned maintenance and unplanned outage events. So, it's for both. And that's a critical part to this as well.

    Thank you, Alex, for spending this time with us.

    That's it for this episode. Next week, we'll talk about managing Oracle Database with REST APIs, and ADB built-in tools.

     

    00;14;12;04 - 00;16;57;28

    Until then, this is Nikita Abraham and Lois Houston signing off.

    That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

    Maximum Security Architecture

    Maximum Security Architecture
    Because of how valuable your data is, protecting it against theft and unauthorized use is perhaps your biggest challenge. Databases need more security than the bare minimum.
     
    In this episode, Lois Houston and Nikita Abraham, along with Greg Genovese, talk about how Oracle’s data-driven security features work together to create a maximum security architecture.
     
    Oracle University Learning Community: https://education.oracle.com/ou-community
     
    Special thanks to Arijit Ghosh, David Wright, Ranbir Singh, and the OU Studio Team for helping us create this episode.
     
    ---------------------------------------------------------
     
    Episode Transcript:
     

    00;00;00;00 - 00;00;38;18

    Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we'll bring you foundational training on the most popular Oracle technologies. Let's get started.

    Hello and welcome to the Oracle University Podcast. I'm Lois Houston, Director of Product Innovation and Go to Market Programs with Oracle University, and with me is Nikita Abraham, Principal Technical Editor.

     

    00;00;38;20 - 00;01;01;20

    Hello again! In today's episode, we're going to talk with Oracle Database Specialist Greg Genovese about Oracle's Maximum Security Architecture.

    Hi, Greg. Thanks for joining us today. We have so much sensitive information in our databases so I get why a data thief would try to attack and steal data. But how do they actually do it?

    Databases don't just operate in a vacuum.

     

    00;01;01;23 - 00;01;26;01

    A database is accessed often through a firewall by users and applications. Speaking of those firewalls, if an attacker has managed to penetrate into the internal network, they may choose to go after data traveling over that network. This type of attack is much less likely to be detected than attempts to access the database directly. Another popular attack is against the underlying data files, database backups, or database exports.

     

    00;01;26;04 - 00;01;49;19

    Here again, if the attacker is successful, they may be able to steal the entire database without even having to try to log in.

    Oh my goodness! That sounds terrible.

    If none of those options work, perhaps the database has an unpatched vulnerability. In many cases, there are automated attack toolkits that help exploit these vulnerabilities.

     

    00;01;49;21 - 00;02;18;29

    And let's not forget those non-production copies of the database.

    What's a non-production copy of a database?

    In many systems, the test and development instances are effectively just clones of production and are hardly ever monitored as closely as production databases. In most cases, there are copies of database for test, development, stage, and user acceptance testing or UAT. Databases persist data into a storage medium and run on servers with operating systems and peripherals.

     

    00;02;19;02 - 00;02;49;16

    All of these are managed by administrators. And administrators are a hacker's favorite point of attack. If they can compromise an admin account, they are in with elevated privileges and in most cases zero controls over what they can do. If the attackers can't compromise an admin account, they can often compromise an end user account. Lower privileges, but often still with access to the data or able to be used as a stepping stone to get that access.

     

    00;02;49;19 - 00;03;20;20

    Also, applications make an attractive target too. They are frequently more exposed than a database or database server and often even available from outside of the corporate firewall.

    That's a lot, Greg. There are just so many points of attack. So then how do I keep my database safe?

    Securing an Oracle Database is much like securing any other system. You are protecting your data, which could be intellectual property, financial data, personal data about your customers or your staff, or most likely a combination of all three of these things.

     

    00;03;20;22 - 00;03;44;06

    Because data is valuable, you need to guard against its theft and misuse. This data is used for business purposes and that means users and applications connect to the database and you need to safeguard that data with security controls that restrict access to the data according to your corporate policy. To do this, you'll need to do three things: assess, detect, and prevent.

     

    00;03;44;06 - 00;04;17;01

    Assess, detect, prevent. Okay. But how do you assess and what are you actually assessing?

    Assess the system to determine its current state and develop a remediation plan. Is the system configured properly? Are patches applied regularly? How are user privileges managed? And are you enforcing these privileges? What types and how much sensitive data is the system holding? Your existing investment in the Oracle Database gives you the features and utilities you need to assess your database and identify areas for improvement and risk reduction.

     

    00;04;17;01 - 00;04;53;21

    And how do you detect and prevent?

    Detect attempts to access data outside of policy and identify anomalies in data access. Almost all database activity is repetitive, so anomalies are frequently a leading-edge indicator of attempted data theft. Prevent access to the data that doesn't go through the database control mechanisms, sniffing traffic over the network, reading the underlying data storage layer, or misuse of database exports and backups. Block inappropriate access to data through control mechanisms that consider the context of the access, not just the identity of the account accessing the data.

     

    00;04;53;21 - 00;05;10;23

    Oracle provides industry-leading capabilities for each of these security control objectives. Our team can help you identify the right technical enforcement for virtually any control objective.

     

    00;05;10;25 - 00;05;40;14

    Have you been wanting to earn an Oracle certification? Well, there's never been a better time than the present. Now through August 31st, you can choose from over 20 different Oracle certifications and take up to four exams for free, including foundation, associate, and professional level Oracle Cloud Infrastructure certifications. You can also learn and get certified on Oracle Cloud Applications Business Processes for Human Capital Management, Financials, Customer Experience, Supply Chain, and Procurement.

     

    00;05;40;17 - 00;06;07;09

    And did I mention this was all free? Oracle Cloud training and certifications empower you to explore limitless possibilities in the cloud landscape. Gain the knowledge and skills needed to design, deploy, secure, and operate modern cloud infrastructure and applications with confidence. You can go to education.oracle.com for more details. What are you waiting for? Get certified today.

     

    00;06;07;12 - 00;06;34;19

    Welcome back! Greg, I'm sure every database has a basic level of security, right?

    There are some things we expect to always be done. What we call the baseline security posture. Establishing the baseline security posture involves several types of different controls. We'll assess the system state, prevent unauthorized activity, and detect activity that is relevant to our security controls. Our first control is assessing the database configuration.

     

    00;06;34;22 - 00;06;59;08

    We want to ensure that we haven't made configuration decisions that introduce unnecessary risk into the environment. We'll also check to make sure that the database is current on all security patches.

    And how do we check this?

    For this, we have two tools available to us: Database Security Assessment tool or DBSAT and Data Safe. DBSAT is a free utility available for download via My Oracle Support.

     

    00;06;59;08 - 00;07;23;28

    Data Safe is a cloud service that is included at no additional cost with Oracle Cloud Database Services. Data Safe is also available for on-prem databases, but there is an additional cost for those. Users and applications connect to the database. We want to ensure that if they are connecting with username and password, we're practicing good password discipline. We also want to consider the use of strong authentication.

     

    00;07;24;00 - 00;07;50;10

    Your Oracle database supports Kerberos, TKI certificate, and multi-factor authentication. We'll want to make sure that those users are really able to connect to the database, identifying dormant accounts and checking to be sure we haven't granted privileges that don't make sense in our environment. Here again, DBSAT and Data Safe help by pointing out the use of such things like select any table privileges or grants of the DBA roles.

     

    00;07;50;12 - 00;08;15;06

    We should also check that database accounts are actually using the privileges we grant.

    Is there any way to monitor the privileges we grant?

    Privilege analysis monitors privilege usage, and can report on privileges that an account has which are not being used. We can then remove those unnecessary privileges, reducing the attack surface presented by those users. Note that privilege analysis is only available for Oracle Enterprise Edition Database.

     

    00;08;15;09 - 00;08;47;03

    It is not present in Oracle Standard Edition. Users are inserting and updating data and also retrieving data. That data is traveling over the network, and in most cases, we want you to encrypt the data to reduce the chances that an attacker can simply sniff the network to steal data.

    And are there different types of encryption?

    The Oracle database supports two different types of network encryption, native network encryption, which is certificate lists and usually requiring zero change to the applications to implement. And industry standard certificate-based TLS.

     

    00;08;47;05 - 00;09;12;12

    Depending on how many users connect to our database and how many databases we have, we may want to implement centralized authentication. Your Oracle database supports two types of centralized user management. One feature, Enterprise User Security, is available on all currently-supported database versions and allows the Oracle database to consult an Oracle LDAP directory for users and role membership.

     

    00;09;12;14 - 00;09;46;13

    The other feature, centrally managed users, was new in Oracle 18c and allows the Oracle database to connect to Microsoft Active Directory for users and role membership.

    Is there a way for us to know what users are doing?

    For this, we use database auditing. The Oracle database offers a comprehensive auditing capability, and you will usually want to audit database connections, especially failed logins, as well as data control language, including creation of users and privilege grants, and data definition language like creation of stored procedures, database links, and more.

     

    00;09;46;16 - 00;10;16;06

    All of these are fairly rare in most databases, so this level of auditing presents minimal performance impact. Finally, we want to make sure that we know what sensitive data resides in the database. Is the baseline security posture appropriate for the level of risk presented by the data? Or should we do more to protect our data? Here we return to DBSAT or Data Safe, which allow us to scan the database for sensitive data reporting on what types of data are found and how much of it there is.

     

    00;10;16;06 - 00;10;41;24

    All of the controls we've talked about so far are baseline. These are things we think any database should do and everything we've discussed so far can be done without additional costs, products, or options.

    But what if I want more than normal baseline security? Maybe my database contains personal information, financial information, intellectual property, or something else that requires more than just basic security.

     

    00;10;41;25 - 00;11;08;13

    Since that data is eventually being persisted on disk, in backups, and in exports, we'll want to protect it from attack there. Here is where transparent data encryption comes into play. If we encrypt data, that means there is an encryption key that we need to protect and distribute securely. For this, we can use Oracle Key Vault. Remember, those administrators with privileges and access to special data? We’ll want to protect against them as well.

     

    00;11;08;15 - 00;11;40;17

    And for this, we'll use Database Vault.

    Could you tell us more about Database Vault?

    Database Vault lets us separate the duties of database administration from access to the data within the database. Database Vault also protects against a compromised application server, locking down application accounts so they can only access data from within the normal context of the application. When data is accessed from outside of the application, we may want to provide additional protection for high value data columns like credit card numbers or taxpayer IDs.

     

    00;11;40;19 - 00;12;07;01

    For this, we can use data redaction to hide sensitive data on the fly as it leaves the database. And for those non-production clones, the database we talked about, we’ll simply remove sensitive data from them, replacing it with realistic looking "safe data" that does not present a security risk, but still allows application development and testing to continue. We can either use Data Safe or Enterprise Manager’s data masking and subsetting pack.

     

    00;12;07;03 - 00;12;30;02

    We seem to have done a lot to protect the database, but is there a way to detect attempts to break in and steal data?

    For that, we’ll configure auditing within the database and feed audit events to a centralized audit vault for analysis, reporting, and even alert generation. We'll also use database firewall to examine incoming connections and SQL statements for anomalies and violation of policy.

     

    00;12;30;04 - 00;13;00;15

    And if we choose to, we can go one step further and actually block out policy activity with the firewall. And of course, events from the database firewall flow into the audit vault server for analysis, reporting and again, alert generation. We've talked about assessing security, detecting inappropriate activity, and preventing unauthorized access to data. But there is a fourth type of database security control that is unique to databases called database-driven security.

     

    00;13;00;17 - 00;13;27;15

    These controls are used to provide fine-grained access control at the data row or column levels. Oracle database provides a variety of data-driven security features, including Real Application Security and Label Security. All these controls, working together, create the maximum security architecture or MSA. Not every database requires the full MSA, but many databases require something much more than just standard baseline security protocols.

     

    00;13;27;17 - 00;13;52;13

    Thanks, Greg, for joining us today. To learn more about Oracle's Maximum Security Architecture, visit mylearn.oracle.com and head over to the Oracle Cloud Data Management Foundations Workshop.

    That brings us to the end of this episode. Join us next week for a discussion on Oracle Cloud Infrastructure's Maximum Availability Architecture. Until then, this is Lois Houston and Nikita Abraham signing off.

     

    00;13;52;15 - 00;16;33;21

    That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

    MySQL Document Store

    MySQL Document Store
    In this episode, Lois Houston and Nikita Abraham are joined by MySQL Developer Advocate Scott Stroz to talk about MySQL Document Store, a NoSQL solution built on top of MySQL.
     
     
    Oracle University Learning Community: https://education.oracle.com/ou-community
     
     
     
     
     
    Special thanks to Arijit Ghosh, David Wright, and the OU Studio Team for helping us create this episode.
     
    ---------------------------------------------------------
     
    Episode Transcript:
     

    00;00;00;00 - 00;00;38;19

    Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let's get started!

    Hello and welcome to the Oracle University Podcast. I'm Lois Houston, Director of Product Innovation and Go to Market Programs with Oracle University. And with me is Nikita Abraham, Principal Technical Editor.

     

    00;00;38;22 - 00;00;59;15

    Hi, everyone! For the last two weeks, we've been talking about MySQL and NoSQL. And in today's special episode, we're going to dive a little deeper and focus on MySQL Document Store with MySQL Developer Advocate Scott Stroz. Hi, Scott! Thanks for being here today. Why don't you tell us a little more about yourself?

    Hi, Niki. Hi, Lois.

     

    00;00;59;19 - 00;01;16;10

    I'm happy to be here with you guys. Like you said, I'm a developer advocate for MySQL. I've been a software developer for over 20 years. In that time frame, MySQL is the only thing in my development stack that hasn't changed. I used MySQL in my first job as a web developer, and I still use it today.

     

    00;01;16;12 - 00;01;41;26

    And for those who may not know, the best way to describe what a developer advocate does is our job is to make developers better at their job.

    Scott, we discussed NoSQL last week, but for anyone who missed that episode, can you give us a high-level explanation of what NoSQL means?

    Before I can explain NoSQL, we should probably go over what we mean by a relational database.

     

    00;01;41;27 - 00;02;06;10

    In a relational database, data is stored in tables. Each table consists of multiple columns, and each column holds a specific data type - a string, a number, a date, etc. In many cases, the data in one table relates to data in another table. This is where the relational part comes from and data is stored in rows or records. In a relational database, data is often very structured.

     

    00;02;06;12 - 00;02;31;29

    SQL or structured query language is used to retrieve, update, add, or delete rows from the database, and NoSQL database at its most basic level is a storage mechanism that does not use the table structure I just mentioned. Data is often stored as JSON documents, as a blob of text. Our audience may find it interesting that NoSQL does not necessarily mean there is no SQL used at all.

     

    00;02;32;01 - 00;02;58;25

    In some cases, NoSQL actually stands for not only SQL.

    Interesting. So, what are JSON documents?

    JSON is an acronym for JavaScript Object Notation and it is a textual representation of a data structure. JSON objects are wrapped in curly braces and consist of key-value pairs. The values can be simple, such as strings or numbers, or they can also be other JSON objects or arrays.

     

    00;02;58;28 - 00;03;21;09

    JSON arrays are wrapped in brackets and consist of comma-separated values that can be simple values again, such as numbers or strings. But they can also be other JSON objects or other arrays. This means that data in JSON objects can be nested with many levels. The best thing about JSON is that it's ubiquitous and can be used in almost any programing language.

     

    00;03;21;11 - 00;03;41;21

    I say almost every because I've not used every programing language. So, I'm covering myself just in case there's one out there that doesn't have JSON support.

    That's pretty good. Okay.

    It's easy to pick up on how to read it as well. When I first started using JSON, it was like trying to read The Matrix. But now I can read JSON just as easy as I can read a book.

     

    00;03;41;22 - 00;04;03;08

    Why would a developer choose to use a NoSQL solution? Can you give us a few examples of that?

    That is a great question, Niki. When starting out a new project, when a data structure doesn't exist, it may make sense to use a NoSQL solution. In other words, if the schema changes frequently, it may make sense not to have a schema.

     

    00;04;03;10 - 00;04;22;25

    Then, once the scheme is matured, the data can be parsed out into a relational database model. I come from the school of thought that all data should be in tables and columns with the proper relationships defined and be very structured. But here's the thing that took me a while to accept. Not all data is structured and not all data needs to be related to other data.

     

    00;04;23;00 - 00;04;49;12

    Things like application configuration or user preferences most likely don't need to be stored in a relational database and may work best being stored as JSON. One of the biggest uses of storing JSON is ingesting data from third-party sources. Many applications use external APIs to retrieve data. In those cases, we have no control over the schema that's used for that data.

     

    00;04;49;15 - 00;05;08;28

    In trying to account for changes in the schema that will inevitably come is going to be a difficult task. So, storing that data in JSON makes a lot more sense.

    That makes sense. And then you can handle the JSON as you need to. Okay, let's get to our main topic of discussion for today. What is MySQL Document Store?

     

    00;05;09;00 - 00;05;35;09

    MySQL Document Store is a NoSQL implementation built on top of MySQL. JSON documents are stored in a MySQL database table using the InnoDB storage engine. CRUD operations - create, retrieve, update, and delete - are abstracted from the developer through an easy-to-use API. Application developers, whether it's web applications, mobile applications, or native operating system applications, communicate with MySQL Document Store over the X-protocol, which uses port 33060 instead of the standard port 3306.

     

    00;05;35;11 - 00;06;00;10

    The nomenclature of NoSQL databases differs from relational databases, right? Can you explain some of the basic terms that are used?

    Developers who come from a relational database background may initially be confused by some of the terms used to describe the structure where the documents are stored.

     

    00;06;00;12 - 00;06;23;04

    I know I was. We use three main terms to describe the structure of MySQL document store – schema, collection, and document. In relational database parlance, a schema would be akin to a database. A collection would be the same as a table, and a document, the actual JSON that we're storing, would be like a row in that table.

     

    00;06;23;07 - 00;06;56;07

    So, what happens under the covers when using MySQL Document Store?

    So, any time we use the document store API, the commands are turned into SQL commands that are then executed on the database server. When developers use the MySQL Document Store API to create a new schema, behind the scenes, MySQL creates a new database, which should be the same as running a SQL query to create a new database. When a new collection is created, MySQL creates a new table in the database using a create table query, and it adds three columns to that table.

     

    00;06;56;09 - 00;07;24;09

    The first is _id. This column serves as the primary key when a document is saved to the database, and the key named _id is not provided. MySQL autogenerates the id, saves it to this column, and then also injects it into the JSON document. The next column is doc. This column stores the JSON documents using the JSON data type. And then the last column is _json_schema.

     

    00;07;24;12 - 00;07;57;09

    And it's used to validate the schema of documents that are added to the collection. CRUD operations follow the same process. For instance, when we make a call to the API to retrieve documents, on the backend, that command is converted into a SELECT statement using native JSON functions to return the document. If developers want to see what commands are executed when using MySQL Document Store, they can enable the general log setting and then view the log after executing API commands.

     

    00;07;57;12 - 00;08;25;29

    Are you attending Oracle CloudWorld 2023? Learn from experts, network with peers, and find out about the latest innovations when Oracle CloudWorld returns to Las Vegas from September 18 through 21. CloudWorld is the best place to learn about Oracle solutions from the people who build and use them. In addition to your attendance at CloudWorld, your ticket gives you access to Oracle MyLearn and all of the cloud learning subscription content as well as three free certification exam credits.

     

    00;08;26;03 - 00;08;53;11

    This is valid from the week you register through 60 days after the conference. So, what are you waiting for? Register today! Learn more about Oracle CloudWorld at www.oracle.com/cloudworld.

    Welcome back! Scott, just before the break, you mentioned something about schema validation. Isn't being schema-less one of the advantages of using a NoSQL solution?

     

    00;08;53;15 - 00;09;16;22

    Being schema-less is one of the features of NoSQL databases that developers like more than others. There may be times when we must ensure that documents added to a collection match a certain syntax or schema. For example, we may want to ensure that documents always have a specific key or that a particular key, if it exists, is numeric or some other data type.

     

    00;09;16;24 - 00;09;38;20

    When the collection is created, we can define those rules using a JSON object with a specific syntax. On the backend, MySQL will create a check constraint using that JSON and any time a document is saved to a collection, it's validated to ensure it matches the rules or schema we define. If the document does not adhere to that schema, MySQL will throw an error.

     

    00;09;38;22 - 00;10;00;13

    What do developers need to do to start using MySQL Document Store. 

    In terms of configuring MySQL? They don't need to do anything. The X-plugin, which is what's used for communication between the server and the client, has been installed by default since version 8.0.1. So, if they're using a newer version of MySQL 8, they already have access to Document Store.

     

    00;10;00;15 - 00;10;24;28

    You may need to make some changes to the network infrastructure to allow traffic over port 33060, but for a network administrator, that should be easy to accomplish. MySQL Document Store is also available on all editions. It's available in Enterprise Edition and the Community Edition as well. And I should note that Oracle Cloud Infrastructure is currently the only cloud provider supporting MySQL Document Store for their MySQL cloud implementations.

     

    00;10;25;00 - 00;10;48;27

    Scott, what programing languages are supported for use with MySQL Document Store?

    There are quite a few languages that are supported. We have connectors or SDKs, as some people call them, or Java, which also works with other Java-based languages, such as Groovy and Kotlin. We also have connectors for C++, Python, PHP, .Net, Node.js and MySQL Shell.

     

    00;10;49;00 - 00;11;14;18

    Our listeners have probably heard of most of these with the exception of MySQL Shell. What is that?

    MySQL Shell is a command line interface that allows us to connect to and manage MySQL database instances. We can use it to create document store schemas and collections easily, but it can do so much more. We can manage to configure MySQL instances, including creating and configuring server replication and clustering.

     

    00;11;14;20 - 00;11;39;15

    It even offers a sandbox feature where we can quickly spin up MySQL instances for testing, replication, and clustering configuration without the need to stand up full MySQL server instances. There are three modes in MySQL Shell. By default, MySQL Shell starts in JavaScript mode where the commands we use follow JavaScript syntax. There is a Python mode where the commands we use follow Python syntax.

     

    00;11;39;17 - 00;12;05;17

    And finally, there is SQL mode where we can run standard SQL queries. SQL mode functions very much like the older MySQL command line client.

    And what are the advantages of using MySQL Document Store?

    I think the best feature of MySQL Document Store is that because the documents are stored in a database table using the JSON data type, we can use native SQL to run complex queries for reports and analytics.

     

    00;12;05;19 - 00;12;27;13

    MySQL has quite a few native functions for working with JSON, which can help extract data from a document store easier than in other solutions. Another big advantage is that MySQL Document Store is fully ACID compliant because the JSON documents are stored using the InnoDB storage engine.

    What does it mean for a database to be ACID compliant?

     

    00;12;27;15 - 00;12;55;27

    In databases, data is updated, added, deleted, etc. in transactions or steps. Sometimes, these transactions are a single query. Other times they may be multiple queries run in succession. Thezacronym ACID, which stands for atomicity, consistency, isolation, and durability, ensures that these transactions are processed in a reliable manner. Atomicity guarantees that each transaction is treated as a single unit.

     

    00;12;55;29 - 00;13;30;24

    If one part of the transaction fails, the entire transaction fails. Consistency ensures that every part of the transaction follows all database constraints. If the data in every part of the transaction violates these constraints, the entire transaction fails. Isolation means that transactions are run in isolation so that they do not interfere with each other. And finally, durability means that once a transaction is committed, meaning all parts of the transaction is succeeded, that the data is written to the database. Database is considered ACID compliant when it adheres to all of this.

     

    00;13;30;26 - 00;13;55;16

    Before we let you go, if people want more information about MySQL Document Store, where can they find it?

    I think the best place to get more information is from the documentation on the MySQL site at dev.mysql.com/doc. There are also quite a few posts about MySQL Document Store on the MySQL blog at blogs.oracle.com/mysql.

     

    00;13;55;19 - 00;14;15;06

    Wonderful! Thank you so much, Scott, for taking the time to be with us today.

    Oh, thanks for having me.

    Well, folks, that brings us to the end of this episode. We hope you've learned something new and that you'll join us next week for a discussion on Oracle Cloud Infrastructure's maximum security architecture. Until then, this is Lois Houston and Nikita Abraham signing off.

     

    00;14;15;09 - 00;16;57;25

    That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

     

    Oracle NoSQL Database Cloud Service

    Oracle NoSQL Database Cloud Service
    High availability, data model flexibility, elastic scalability… If these words have piqued your interest, then this is the episode for you!
     
    Join Lois Houston and Nikita Abraham, along with Autumn Black, as they discuss how Oracle NoSQL Database Cloud Service is designed for today’s most demanding applications, ensuring fast and predictable single-digit millisecond response times at scale, even as throughput requirements change.
     
    Oracle University Learning Community: https://education.oracle.com/ou-community
     
    Special thanks to Arijit Ghosh, David Wright, Ranbir Singh, and the OU Studio Team for helping us create this episode.
     
    -------------------------------------------------------
     
    Episode Transcript:

    00;00;00;00 - 00;00;38;28

    Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let's get started.

    Hello and welcome to the Oracle University Podcast. I'm Nikita Abraham, Principal Technical Editor with Oracle University, and with me is Lois Houston, Director of Product Innovation and Go to Market Programs.

     

    00;00;39;01 - 00;01;04;26

    Hi there! Many of today's modern applications face a lot of different challenges. These could be anything from managing data models that are continuously evolving to providing UIs that are highly responsive.

    Yeah, and that's because in today's environment, no one wants to go to an interface where they have to wait for minutes or even seconds, really.

    Exactly. So innovations have to happen rapidly and they have to keep up with the demands of the customer base.

     

    00;01;05;01 - 00;01;27;25

    Since we discussed the MySQL database in our last episode, we thought it would only make sense to talk about NoSQL next. And we're very happy to have Oracle Database Specialist Autumn Black joining us again. Hi Autumn. What can you tell us about Oracle NoSQL Database Cloud Service?

    The Oracle NoSQL Database Cloud Service really offers a lot of great properties.

     

    00;01;27;28 - 00;01;53;28

    It's serverless, always on, and fully managed by Oracle. Developers can focus on application development without having to worry about managing servers, storage expansion, cluster deployment, software installation, or even backups. It's fully elastic. You just provision the throughput and storage capacity your application requires. Resources are automatically allocated and they scale accordingly to meet the dynamic workload requirements that you have.

     

    00;01;54;01 - 00;02;18;16

    The service provides predictable low latency for all types of application workload, whether it's at the peak workload or at a very low level of the workload. The latency is always at sub 10 milliseconds. Flexible data model supports document, columnar, and key value formats to capture any of the kinds of data you may have. These data models can interoperate with each other using a single application interface.

     

    00;02;18;18 - 00;02;49;04

    It offers developer-friendly APIs, and it's integrated with popular application development tools. It comes with enterprise-grade security. It's cost-effective. Lastly, and most importantly, it makes hybrid cloud or multi-cloud deployment with Oracle NoSQL Database extremely easy. This enables enterprises to expand their business operations, open up new business potential and opportunities.

    Autumn, you said Oracle NoSQL Database Cloud Service is fully managed by Oracle.

     

    00;02;49;06 - 00;03;09;17

    What does that exactly mean? What are the things that Oracle really handles?

    Oracle's responsible for the back-end software and hardware. The developer gets to focus on the application and who can use that application. Today's modern developers are not interested in what's going on behind the scenes. They want to be sure that they can get what they want when they want it.

     

    00;03;09;20 - 00;03;36;03

    Could you tell us about some use cases where we’d see Oracle NoSQL Database Cloud Service being used?

    We see it in mobile applications. We see it in the Internet of Things. We see it in a 360-degree customer view that's extremely prevalent in banking applications. We see it in the user profile management catalog data, such as what you would see maybe on Amazon, content management, online advertising, and big-time real data, social media.

     

    00;03;36;05 - 00;03;59;20

    And we also see it being used in the area of gaming.

    We've heard that Oracle NoSQL Database Cloud Service is extremely developer-friendly. How exactly is it developer-friendly?

    You can deploy your application to the data store in a matter of minutes. We have SDKs available in all the popular languages. We have Java, Python, Node.js, Go. We also have Spring.

     

    00;03;59;22 - 00;04;24;24

    We have open standards for our APIs, and we use the SQL language. Many, many folks already know and understand the SQL language and they can easily adapt to our APIs. We basically allow for simple and complex data types. We have our developer tools in Eclipse, IntelliJ, and Visual Studios. And for those who want to play with the service a little bit, you have full access to the service through the UI console.

     

    00;04;24;27 - 00;04;48;05

    Does Oracle NoSQL Database Cloud Service support different data models?

    You get to select that depending upon what you need.

    There's fixed schema, right?

    Sometimes referred to as a columnar store, sometimes referred to as just straight schema.

    And a JSON document?

    Sometimes it's referred to as just documents, and sometimes it's referred to as a JSON document. Other times, it gets referred to as schema lists.

     

    00;04;48;08 - 00;05;07;17

    We can store both of these within the same table, and we also have the ability to store a key value, which in some sense is really nothing more than a very simplified JSON document where you sort of have a primary key known as your key. Then you have your value and then oftentimes this value is really nothing more than a JSON document.

     

    00;05;07;20 - 00;05;32;10

    We have complete interoperability between either of these different types of data models.

    And what's the pricing like?

    Our pricing model is fairly straightforward. You basically pay for what you provision and different workflows can provision different amounts. The provision occurs on a per-table level that we have. We call it a read unit or write unit and storage. And each of those different parameters can be adjusted differently for each of the tables that you have.

     

    00;05;32;12 - 00;05;44;08

    So, it's a very, very simple model, very straightforward. And the cost for each one of those is extremely inexpensive.

     

    00;05;44;10 - 00;06;14;09

    Have you been wanting to earn an Oracle certification? Well, there's never been a better time than the present. Now through August 31st, you can choose from over 20 different Oracle certifications and take up to four exams for free, including foundation, associate, and professional-level Oracle Cloud Infrastructure certifications. You can also learn and get certified on Oracle Cloud Applications Business Processes for Human Capital Management, Financials, Customer Experience, Supply Chain, and Procurement.

     

    00;06;14;13 - 00;06;40;25

    And did I mention this was all free? Oracle Cloud training and certifications empower you to explore limitless possibilities in the cloud landscape. Gain the knowledge and skills needed to design, deploy, secure, and operate modern cloud infrastructure and applications with confidence. You can go to education.oracle.com for more details. What are you waiting for? Get certified today.

     

    00;06;40;27 - 00;07;03;24

    Welcome back. Now that we've covered all of that, let's get down to business. What is Oracle NoSQL Database Cloud Service? How does it help one’s business?

    Well, really, it's a client server architecture. On the client side, an application interacts with NoSQL drivers, or sometimes more commonly referred to as our SDK. So, you develop the application.

     

    00;07;03;25 - 00;07;31;08

    And then at compile time, you include the SDK in that. Drivers are available for Java, Python, Node.js, Go, Spring, and C-Sharp. So then the application runs and it does database operations like insert, update, query, delete against the NoSQL tables that are stored on the server side. So from the developer’s point of view, that's all they need to know. It's extremely simple. NoSQL tables can be created in seconds.

     

    00;07;31;10 - 00;08;01;08

    Developers can start right away to develop and deploy their applications. Businesses can focus on rapid innovations to better serve their customer’s needs and expectations.

    So what you're saying is developers and IT don't need to manage any computing, infrastructure, or software updates.

    The NoSQL service comes with the high availability built in. So, all of the underlying compute services and software maintenance, all of that is fully managed by Oracle, which is hosting the NoSQL tables.

     

    00;08;01;11 - 00;08;24;10

    Database administrators will work on the authentication, the roles, the privileges, and the other types of access that are used to access the tables.

    Autumn, earlier on, we spoke about how easy it is to use Oracle NoSQL Database Cloud Service to develop your application. Can you talk about how NoSQL drivers connect to tables and perform database operations?

    So, each table has a couple of different key components.

     

    00;08;24;12 - 00;08;49;16

    The first one is the data component. So, it consists of a table definition or flexible data model, supports columnar key value or document models. We support many different data types, including integer, string, binary, long double, array, JSON, record, and a few others. Each column can be defined by a particular data type.

    So that could be integers, strings, and JSON columns, right?

     

    00;08;49;16 - 00;09;06;21

    Then we have a primary key which is identified. The primary key sort of doubles as the shard key and the shard key can be either a sort of complete copy of the primary key, or you can have a multicolumn key where some of those columns is your primary key and then other columns in that are your shard key.

     

    00;09;06;24 - 00;09;30;25

    The other component of a table is the capacity that is provisioned.

    What's an example of this?

    We have three units. We have write units, read units, and we have storage. Storage is expressed in gigabytes and this is the maximum amount of storage that is allocated for this particular table. Reads and writes are expressed in units. Each of those units represents a one kilobyte read or write for every second.

     

    00;09;30;27 - 00;09;52;17

    So, if you have an application where you wanted to do multiple reads a second, then you would allocate multiple read units for that particular table. And these can be dynamically adjusted.

    What are the different ways in which you can experience Oracle NoSQL Database Cloud Service?

    The first is accessing the cloud service to the service UI, probably more commonly referred to as the UI console.

     

    00;09;52;19 - 00;10;20;12

    The UI console provides basic capability. You can create and delete tables and then you can execute very simple, straightforward SQL statements against your table. If you want a richer experience, where you have an application that's developed. And then through all of our SDKs, you'll have the full experience and you'll be able to do the complete set of SQL statements that we offer. And then finally, we have what we call the NoSQL Cloud Simulator, essentially a single process version of our cloud.

     

    00;10;20;15 - 00;10;40;06

    It's very easy to use. Many of our customers use that for test and development, and the beauty with using that for testing development is there's no cost to you. There's no cost from the cloud service. You can develop your application, you can test it, and once you're ready to deploy it in the cloud, you might be able to do part of it through the UI or you could do it through your application.

     

    00;10;40;06 - 00;11;07;14

    Autumn, what makes Oracle NoSQL Database Cloud Service different?

    Well, there's a seamless multimodel. You have key value, fixed schema, you have schema-less, all at the same data store. The seamless SQL interoperates amongst any of these different kinds of data models. You have tunable ACID, you have shard local full ACID, you have parent tables for easy multiobject ACID. You can carefully balance the trade-offs of ACID and scale.

     

    00;11;07;16 - 00;11;29;16

    There is a fully managed cloud service. The throughput is provisioned, there is no lock-in. You have the ability to run as a fully managed service or you can take the NoSQL Database, run it anywhere. And if you want to run it in a hybrid environment, you can do that as well.

    Are there some additional resources that Oracle has, you know, where people can go to get more information?

     

    00;11;29;18 - 00;11;56;04

    I know we have the Developers Blog and blogs.oracle.com, but is there anything else?

    We have the Cloud Customer Connect, the developer community that we have for NoSQL. This gets monitored. We really have developers around the globe on the team so really this does get 24/7 coverage and we try to be very responsive to any types of questions that get posted on the forum and then we supply answers for all those questions.

     

    00;11;56;06 - 00;12;18;19

    Thank you so much, Autumn, for joining us through these last two episodes. We've learned so much from you.

    Learn more about the service by visiting mylearn.oracle.com and taking a look at our Oracle Cloud Data Management Foundations Workshop. You can also take skill checks to test your understanding of this topic.

    That brings us to the end of this episode.

     

    00;12;18;19 - 00;12;41;26

    In our next episode, we'll be joined by a very special guest who will talk about MySQL Document Store, a NoSQL solution that's built on top of MySQL. More on that next week. Until then, this is Lois Houston and Nikita Abraham signing off.

    That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes.

     

    00;12;41;29 - 00;15;14;24

    We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

    MySQL Database Service and HeatWave

    MySQL Database Service and HeatWave
    In this episode, Lois Houston and Nikita Abraham are joined by Autumn Black to discuss MySQL Database, a fully-managed database service powered by the integrated HeatWave in-memory query accelerator.
     
    Oracle University Learning Community: https://education.oracle.com/ou-community
     
    Special thanks to Arijit Ghosh, David Wright, Deepak Modi, Ranbir Singh, and the OU Studio Team for helping us create this episode.
     
    ---------------------------------------------------------
     
    Episode Transcript:

    00;00;00;00 - 00;00;39;08

    Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we'll bring you foundational training on the most popular Oracle technologies. Let's get started.

    Hello and welcome to the Oracle University Podcast. You're listening to our second season Oracle Database Made Easy. I'm Lois Houston, Director of Product Innovation and Go to Market Programs with Oracle University.

     

    00;00;39;10 - 00;01;08;03

    And with me is Nikita Abraham, Principal Technical Editor.

    Hi, everyone. In our last episode, we had a really fascinating conversation about Oracle Machine Learning with Cloud Engineer Nick Commisso. Do remember to catch that episode if you missed it. Today, we have with us Autumn Black, who's an Oracle Database Specialist. Autumn is going to take us through MySQL, the free version and the Enterprise Edition, and MySQL Data Service.

     

    00;01;08;05 - 00;01;39;16

    We're also going to ask her about HeatWave. So let's get started. Hi, Autumn. So tell me, why is MySQL such a popular choice for developers?

    MySQL is the number one open-source database and the second most popular database overall after the Oracle Database. According to a Stack Overflow survey, MySQL has been for a long time and remains the number one choice for developers, primarily because of its ease of use, reliability, and performance.

     

    00;01;39;17 - 00;02;08;22

    And it's also big with companies?

    MySQL is used by the world's most innovative companies. This includes Twitter, Facebook, Netflix, and Uber. It is also used by students and small companies.

    There are different versions of MySQL, right? What are the main differences between them when it comes to security, data recovery, and support?

    MySQL comes in two flavors: free version or paid version.

     

    00;02;08;24 - 00;02;45;05

    MySQL Community, the free version, contains the basic components for handling data storage. Just download it, install it, and you're ready to go. But remember, free has costs. That stored data is not exactly secure and data recovery is not easy and sometimes impossible. And there is no such thing as free MySQL Community support. This is why MySQL Enterprise Edition was created, to provide all of those missing important pieces: high availability, security, and Oracle support from the people who build MySQL.

     

    00;02;45;10 - 00;03;09;24

    You said MySQL is open source and can be easily downloaded and run. Does it run on-premises or in the cloud?

    MySQL runs on a local computer, company's data center, or in the cloud.

    Autumn, can we talk more about MySQL in the cloud?

    Today, MySQL can be found in Amazon RDS and Aurora, Google Cloud SQL, and Microsoft Azure Database for MySQL.

     

    00;03;09;27 - 00;03;35;23

    They all offer a cloud-managed version of MySQL Community Edition with all of its limitations. These MySQL cloud services are expensive and it's not easy to move data away from their cloud. And most important of all, they do not include the MySQL Enterprise Edition advanced features and tools. And they are not supported by the Oracle MySQL experts.

     

    00;03;35;25 - 00;04;07;03

    So why is MySQL Database Service in Oracle Cloud Infrastructure better than other MySQL cloud offerings? How does it help data admins and developers?

    MySQL Database Service in Oracle Cloud Infrastructure is the only MySQL database service built on MySQL Enterprise Edition and 100% built, managed, and supported by the MySQL team. Let's focus on the three major categories that make MySQL Database Service better than the other MySQL cloud offerings: ease of use, security, and enterprise readiness.

     

    00;04;07;03 - 00;04;44;24

    MySQL DBAs tend to be overloaded with mundane database administration tasks. They're responsible for many databases, their performance, security, availability, and more. It is difficult for them to focus on innovation and on addressing the demands of lines of business. MySQL is fully managed on OCI. MySQL Database Service automates all those time-consuming tasks so they can improve productivity and focus on higher value tasks.

     

    00;04;44;26 - 00;05;07;13

    Developers can quickly get all the latest features directly from the MySQL team to deliver new modern apps. They don't get that on other clouds that rely on outdated or forked versions of MySQL. Developers can use the MySQL Document Store to mix and match SQL and NoSQL content in the same database as well as the same application.

     

    00;05;07;19 - 00;05;30;26

    Yes. And we're going to talk about MySQL Document Store in a lot more detail in two weeks, so don't forget to tune in to that episode. Coming back to this, you spoke about how MySQL Database Service or MDS on OCI is easy to use. What about its security?

    MDS security first means it is built on Gen 2 cloud infrastructure.

     

    00;05;30;28 - 00;05;57;13

    Data is encrypted for privacy. Data is on OCI block volume.

    So what does this Gen 2 cloud infrastructure offer? Is it more secure?

    Oracle Cloud is secure by design and architected very differently from the Gen 1 clouds of our competitors. Gen 2 provides maximum isolation and protection. That means Oracle cannot see customer data and users cannot access our cloud control computer.

     

    00;05;57;15 - 00;06;27;09

    Gen 2 architecture allows us to offer superior performance on our compute objects. Finally, Oracle Cloud is open. Customers can run Oracle software, third-party options, open source, whatever you choose without modifications, trade-offs, or lock-ins.

    Just to dive a little deeper into this, what kind of security features does MySQL Database Service offer to protect data?

    Data security has become a top priority for all organizations.

     

    00;06;27;12 - 00;06;55;17

    MySQL Database Service can help you protect your data against external attacks, as well as internal malicious users with a range of advanced security features. Those advanced security features can also help you meet industry and regulatory compliance requirements, including GDPR, PCI, and HIPPA. When a security vulnerability is discovered, you'll get the fix directly from the MySQL team, from the team that actually develops MySQL.

     

    00;06;55;19 - 00;07;22;16

    I want to talk about MySQL Enterprise Edition that you brought up earlier. Can you tell us a little more about it?

    MySQL Database Service is the only public cloud service built on MySQL Enterprise Edition, which includes 24/7 support from the team that actually builds MySQL, at no additional cost. All of the other cloud vendors are using the Community Edition of MySQL, so they lack the Enterprise Edition features and tools.

     

    00;07;22;22 - 00;07;53;24

    What are some of the default features that are available in MySQL Database Service?

    MySQL Enterprise scalability, also known as the thread pool plugin, data-at-rest encryption, native backup, and OCI built-in native monitoring. You can also install MySQL Enterprise Monitor to monitor MySQL Database Service remotely. MySQL works well with your existing Oracle investments like Oracle Data Integrator, Oracle Analytics Cloud, Oracle GoldenGate, and more.

     

    00;07;53;27 - 00;08;17;20

    MySQL Database Service customers can easily use Docker and Kubernetes for DevOps operations.

    So how much of this is managed by the MySQL team and how much is the responsibility of the user?

    MySQL Database Service is a fully managed database service. A MySQL Database Service user is responsible for logical schema modeling, query design and optimization, define data access and retention policies.

     

    00;08;17;22 - 00;08;44;26

    The MySQL team is responsible for providing automation for operating system installation, database and OS patching, including security patches, backup, and recovery. The system backs up the data for you, but in an emergency, you can restore it to a new instance with a click. Monitoring and log handling. Security with advanced options available in MySQL Enterprise Edition.

     

    00;08;44;28 - 00;09;01;18

    And of course, maintaining the data center for you. To use MDS, users must have OCI tenancy, a compartment, belong to a group with required policies.

     

    00;09;01;21 - 00;09;28;28

    Did you know that Oracle University offers free courses on Oracle Cloud Infrastructure? You'll find training on everything from cloud computing, database, and security to artificial intelligence and machine learning, all of which is available free to subscribers. So get going. Pick a course of your choice, get certified, join the Oracle University Learning Community, and network with your peers. If you're already an Oracle MyLearn user, go to MyLearn to begin your journey.

     

    00;09;29;03 - 00;09;40;24

    If you have not yet accessed Oracle MyLearn, visit mylearn.oracle.com and create an account to get started.

     

    00;09;40;27 - 00;10;05;20

    Welcome back! Autumn, tell us about the system architecture of MySQL Database Service.

    A database system is a logical container for the MySQL instance. It provides an interface enabling management of tasks, such as provisioning, backup and restore, monitoring, and so on. It also provides a read and write endpoint, enabling you to connect to the MySQL instance using the standard protocols.

     

    00;10;05;28 - 00;10;31;27

    And what components does a MySQL Database Service DB system consist of?

    A computer instance, an Oracle Linux operating system, the latest version of MySQL server Enterprise Edition, a virtual network interface card, VNIC, that attaches the DB system to a subnet of the virtual cloud network, network-attached higher performance block storage.

    Is there a way to monitor how the MySQL Database Service is performing?

     

    00;10;31;29 - 00;10;59;29

    You can monitor the health, capacity, and performance of your Oracle Cloud Infrastructure MySQL Database Service resources by using metrics, alarms, and notifications. The MySQL Database Service metrics enable you to measure useful quantitative data about your MySQL databases such as current connection information, statement activity, and latency, host CPU, memory, and disk I/O utilization, and so on.

     

    00;11;00;03 - 00;11;23;15

    You can use metrics data to diagnose and troubleshoot problems with MySQL databases.

    What should I keep in mind about managing the SQL database?

    Stopped MySQL Database Service system stops billing for OCPUs, but you also cannot connect to the DB system. During MDS automatic update, the operating system is upgraded along with patching of the MySQL server.

     

    00;11;23;17 - 00;11;49;15

    Metrics are used to measure useful data about MySQL Database Service system. Turning on automatic backups is an update to MDS to enable automatic backups. MDS backups can be removed by using the details pages and OCI and clicking Delete.

    Thanks for that detailed explanation on MySQL, Autumn. Can you also touch upon MySQL HeatWave? Why would you use it over traditional methods of running analytics on MySQL data?

     

    00;11;49;18 - 00;12;18;01

    Many organizations choose MySQL to store their valuable enterprise data. MySQL is optimized for Online Transaction Processing, OLTP, but it is not designed for Online Analytic Processing, OLAP. As a result, organizations that need to efficiently run analytics on data stored in MySQL database move their data to another database to run analytic applications such as Amazon Redshift.

     

    00;12;18;04 - 00;12;41;22

    MySQL HeatWave is designed to enable customers to run analytics on data that is stored in MySQL database without moving data to another database.

    What are the key features and components of HeatWave?

    HeatWave is built on an innovative in-memory analytics engine that is architected for scalability and performance, and is optimized for Oracle Cloud Infrastructure, OCI.

     

    00;12;41;24 - 00;13;05;29

    It is enabled when you add a HeatWave cluster to a MySQL database system. A HeatWave cluster comprises a MySQL DB system node and two or more HeatWave nodes. The MySQL DB system node includes a plugin that is responsible for cluster management, loading data into the HeatWave cluster, query scheduling, and returning query results to the MySQL database system.

     

    00;13;06;02 - 00;13;29;15

    The HeatWave nodes store data and memory and processed analytics queries. Each HeatWave node contains an instance of the HeatWave. The number of HeatWave nodes required depends on the size of your data and the amount of compression that is achieved when loading the data into the HeatWave cluster. Various aspects of HeatWave use machine-learning-driven automation that helps to reduce database administrative costs.

     

    00;13;29;18 - 00;13;52;11

    Thanks, Autumn, for joining us today. We're looking forward to having you again next week to talk to us about Oracle NoSQL Database Cloud Service. To learn more about MySQL Data Service, head over to mylearn.oracle.com and look for the Oracle Cloud Data Management Foundations Workshop. Until next time, this is Nikita Abraham and Lois Houston signing off.

     

    00;13;52;14 - 00;16;33;05

    That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

    Oracle Machine Learning

    Oracle Machine Learning
    There is so much data available today. But it only makes a difference when you transform that data into actionable intelligence.
     
    In this episode, hosts Lois Houston and Nikita Abraham, along with Nick Commisso, discuss how you can harness the capabilities of Oracle Machine Learning to solve key business problems and accelerate the deployment of machine learning–based solutions.
     
    Oracle University Learning Community: https://education.oracle.com/ou-community
     
    Special thanks to Arijit Ghosh, David Wright, Ranbir Singh, and the OU Studio Team for helping us create this episode.
     
    -------------------------------------------------------
     
    Episode Transcript:
     

    00;00;00;00 - 00;00;39;06

    Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we'll bring you foundational training on the most popular Oracle technologies. Let's get started.

    Hello and welcome to the Oracle University Podcast. I'm Nikita Abraham, Principal Technical Editor with Oracle University, and with me is Lois Houston, Director of Product Innovation and Go to Market Programs.

     

    00;00;39;08 - 00;01;07;15

    Hi there. For the last two weeks, we've been off the Oracle Database train, but today we're back on it, focusing on Oracle Machine Learning with our Cloud Engineer Nick Commisso. Hi Nick. Before we get into Oracle Machine Learning, I think we should start with the basics. What is machine learning?

    Machine learning is focused on enabling data science teams to add ML-based intelligence to both their applications and their dashboards.

     

    00;01;07;17 - 00;01;37;07

    With machine learning, we can automate the entire data analysis process workflow, from collaborating in order to obtain data from many sources to creating and analyzing the data, and showing the results and reports. We can perform predictions and easily visualize the data to provide a deeper and faster and more comprehensive insight to enable effective business decisions.

    I think we can safely say that machine learning is the future of analytics in every industry, right?

     

    00;01;37;09 - 00;02;11;26

    So where does Oracle Machine Learning come in?

    Oracle Machine Learning provides a reliable, AI-driven environment that truly encapsulates the power of machine learning. Enhanced performance and scalability is achieved in part by eliminating data movement for database data and providing algorithms that have been redesigned specifically for scalability and performance. Next is simpler solution architecture and management, where we want to avoid requiring separately maintained analytic engines or tools for data and model governance.

     

    00;02;11;26 - 00;02;38;10

    In-database machine learning also offers flexible architectures for deployment tests, in-production spanning the cloud, on-premises, and hybrid environments. And because of its SQL and REST interfaces, it's easy to integrate with the broader Oracle stack. Now the third is that OML empowers a broader range of users with machine learning. It's readily available in the database from multiple interfaces, including third-party package support.

     

    00;02;38;13 - 00;03;06;19

    So do you have to be an expert to use machine learning?

    To make even non-experts productive with machine learning, OML supports AutoML from a Python API, and a no code user interface. And there's also other built-in automation features like automatic data preparation, integrated text mining, and partition models. And these make machine learning even more accessible to a broader range of users.

     

    00;03;06;22 - 00;03;33;04

    What can you tell us about the pricing structure?

    Machine learning capabilities are included in the core product at no additional cost with Autonomous Database, and the OML components of ADB are pre-provisioned and ready to use. And an on-premises database is included with the database license. So overall, the takeaway is that OML helps reduce costs and complexity while increasing productivity and access.

     

    00;03;33;06 - 00;04;01;06

    What are the areas or fields in which OML is useful?

    Modern businesses and modern problems require solution best delivered by Oracle Machine Learning. Medical science has been leveraging machine learning successfully to perform quick and accurate diagnosis or creating curative solutions using vast quantities of data. Physical robots use a combination of machine learning solutions to sense their environment and respond appropriately.

     

    00;04;01;08 - 00;04;37;07

    Computational biology makes use of machine learning to analyze biological data, such as genetic sequences or organic samples, and make predictions. Analysis with financial or security data can identify clients with high risk profiles or cybersecurity surveillance to pinpoint warning signs of fraud. The recent growth in the popularity of machine learning has been aided by the fact that we now have improved machine learning algorithms, which are supported by the advent and frequent innovation in technology related to data capture, networking and computing power.

     

    00;04;37;11 - 00;05;02;24

    So you basically don't need to write complex software for every change in the data.

    And the machine learning model evolves as the historical data evolves. We have more advanced sensors and I/O devices which support machine learning models with accurate and real-time data. Customers of various services are now looking for more customization options, which can be efficiently supported with machine learning solutions.

     

    00;05;02;26 - 00;05;24;16

    The historical challenges of manually trawling through data to extract actionable knowledge is no longer a problem now because machine learning algorithms supported by powerful modern computers are designed for that particular purpose.

     

    00;05;24;19 - 00;05;52;18

    Are you attending Oracle CloudWorld 2023? Learn from experts, network with peers, and find out about the latest innovations when Oracle CloudWorld returns to Las Vegas from September 18 through 21. CloudWorld is the best place to learn about Oracle solutions from the people who build and use them. In addition to your attendance at CloudWorld, your ticket gives you access to Oracle MyLearn and all of the cloud learning subscription content, as well as three free certification exam credits.

     

    00;05;52;23 - 00;06;09;20

    This is valid from the week you register through 60 days after the conference. So what are you waiting for? Register today. Learn more about Oracle CloudWorld at www.oracle.com/cloudworld.

     

    00;06;09;22 - 00;06;39;21

    Welcome back! Nick, I was hoping you could share some use cases where machine learning can really be leveraged.

    Banks and other businesses in the financial industry use machine learning technology for two key purposes: to identify important insights and data and to prevent fraud. The insights can identify investment opportunities to help investors know when to trade, and machine learning can also identify clients with high risk profiles or use cyber surveillance to pinpoint warning signs of fraud.

     

    00;06;39;23 - 00;07;10;23

    Machine learning is a fast growing trend in the healthcare industry. The technology can help medical experts analyze data to identify trends or red flags that may lead to improved diagnostics and treatment. Finding new energy sources, analyzing minerals in the ground, predicting refinery sensor failure, streamlining oil distribution to make it more efficient and cost effective. The number of machine learning use cases for this industry is fast and still expanding.

     

    00;07;10;25 - 00;07;46;27

    Analyzing data to identify patterns and trends is key to the transportation industry, which relies on making routes more efficient and predicting potential problems to increase profitability. The data analysis and modeling aspects of machine learning are important tools to delivery companies, public transportation, and other transportation organizations.

    Shopping websites also use machine learning, right?

    Websites recommending items you might like based on previous purchases are used with machine learning to analyze your buying history and promote other items you might be interested in.

     

    00;07;46;29 - 00;08;14;17

    The ability to capture that data and analyze it and use it to personalize a shopping experience or implement a marketing campaign is the future of retail. Government agencies, such as public safety and utilities, have a particular need for machine learning because they have multiple sources of data that can be mined for insights. Analyzing sensor data, for example, identifies ways to increase efficiency and save money.

     

    00;08;14;20 - 00;08;42;12

    Machine learning can also help detect fraud and minimize theft. Retail industries can use machine learning to recognize customer spending patterns for targeted marketing or optimize supply chain logistics by recognizing outliers or anomalies in the data. All that a data science needs to do is identify the problem domains, such as transportation, find the data, and let Oracle Machine Learning take care of the rest.

     

    00;08;42;14 - 00;09;08;18

    GPS navigation services make use of historical data to predict travel time based on the current traffic levels. Video surveillance systems uses facial recognition systems to identify situations which require attention from emergency services. Social media uses machine learning to study the patterns of user interactions to suggest connections, item of interests, targeted ads, and so on.

    And we can use it to find spam, I'm sure.

     

    00;09;08;20 - 00;09;33;27

    Machine learning helps email services recognize spam or malicious emails by recognizing the common patterns among offending examples. And the well-known and almost essential Internet searches use machine learning to refine results based on the search patterns of the individual users.

    Nick, now that you've given us a really good idea about all of the places machine learning can be used, let's talk about the features of Oracle Machine Learning.

     

    00;09;34;00 - 00;10;09;12

    Oracle Machine Learning provides access to a wide array of features in addition to the collaborative notebooks, which include templates, user administration tools, and schedulers. In-database algorithms allow you to implement machine learning solutions on your data residing in Oracle databases without having to move your data anywhere else. OML provides support for SQL, PL/SQL, R, Python languages, and Markdown, which you should be familiar with if you've worked with databases before, making implementing machine learning solutions lot easier.

     

    00;10;09;15 - 00;10;38;04

    OML also provides support for the deployment of enterprise machine learning methodologies within the Autonomous Data Warehouse.

    What are the different parts of Oracle Machine Learning?

    The components that make up Oracle Machine Learning are the machine learning user administrative application, which is a web-based user interface for managing your Oracle Machine Learning user, as well as mapping your machine learning to the Autonomous Data Warehouse database users.

     

    00;10;38;07 - 00;11;03;22

    Now you can also access machine learning user interface for the administrator. The OML application is a web-based application for your data scientists to help create workspaces and projects, as well as notebooks.

    Earlier in our conversation, you spoke about these powerful machine learning algorithms. Can you tell us more about that, please?

    The OML tagline is move the algorithms, not the data.

     

    00;11;03;25 - 00;11;34;26

    To realize this, we’ve placed powerful machine learning algorithms in the database kernel software operating below the user security layer. Other tools simply can't do that. OML eliminates data movement for database data and simplifies the solution architecture as there's no need to manage and test workflows involving third-party engines. OML extends the database to enable users to augment applications and dashboards with machine learning based intelligence quickly and easily.

     

    00;11;34;28 - 00;12;05;14

    It delivers over 30 in-database algorithms accessible through multiple language interfaces, and it's important to note that the broader Oracle ecosystem for data analytics and machine learning also include tools like Oracle Analytics Server and Analytics Cloud, OCI, Data Science, AI services, and others. And OML is included with Oracle Autonomous Database instances and Oracle Database licenses. So you already have free access to it to start using it.

     

    00;12;05;18 - 00;12;33;25

    And what are the benefits of using OML, Nick?

    Whether minimizing or eliminating data movement, support from multiple personas or multiple languages and both code and no code interfaces. These and other benefits resonate with customers needing powerful and integrated machine learning to meet their scalability and performance needs, while simplifying their solution and deployment architecture.

    What are the various OML components?

     

    00;12;33;29 - 00;13;19;07

    Build ML models and score data with no data movement with the OML4SQL API. Leverage the database as a high-performance compute engine from Python with in-database ML with OML4Py API. Leverage the database as a high-performance compute engine from R with in-database ML with OML4R API. OML Notebooks is a collaborative notebook user interface supporting SQL, PL/SQL, Python, R, and Markdown. OML AutoML UI is a no-code automated modeling interface. And OML Services is a RESTful model management and deployment.

     

    00;13;19;09 - 00;13;44;19

    With Oracle Data Miner, there's a SQL Developer extension with a drag-and-drop interface for creating ML methodologies.

    Let's talk about the life cycle of a machine learning project.

    The life cycle of a machine learning project is divided into six phases. The first phase of the machine learning process is to define business objectives. The initial phase of the project focuses on understanding the project objectives and requirements.

     

    00;13;44;22 - 00;14;10;28

    In this phase, you're going to specify the objectives, determine the machine learning goals, define success criteria, and produce a project plan. The data understanding phase involves data collection and exploration, which includes loading the data and analyzing the data for your business problem. In this phase, you will access and collect the data, explore data, and understand data quality.

    Alright, then.

     

    00;14;10;28 - 00;14;40;22

    So what's next?

    The preparation phase involves finalizing the data and covers all of the tasks involved in making the data in a format that you can use to build the model. In this phase, you will clean, join, and select the data, transform data, and engineer new features. In the modeling phase, you'll select and apply various modeling techniques and tune the algorithm parameters called hyperparameters to your desired values.

     

    00;14;40;24 - 00;15;07;20

    In this phase, you're going to explore different algorithms and build, evaluate, and tune models. At the evaluation phase, it's time to evaluate how well the model satisfies the originally stated business goal. In this phase, you'll review the business objectives, assess results against success criteria, and determine the next steps. Deployment is the use of machine learning with a targeted environment.

     

    00;15;07;22 - 00;15;42;04

    In the deployment phase, one can derive data-driven insights and actionable insights. In this phase, you will plan enterprise deployment, integrate models with application for business needs, monitor, refresh, retire, and archive models, and you'll report on model effectiveness.

    Thank you so much, Nick, for sharing your expertise with us. This was great.

    To learn more about Oracle Machine Learning, please visit mylearn.oracle.com and take a look at our Using Oracle Machine Learning with Autonomous Database course.

     

    00;15;42;06 - 00;16;07;19

    Once you're done with it, you can take the associated specialist certification exam with confidence.

    That brings us to the end of this episode. Next week, we'll talk about MySQL and why it's everywhere. Until then, this is Nikita Abraham and Lois Houston signing off.

    That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes.

     

    00;16;07;22 - 00;18;40;10

    We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

    Evaluate Your Organization's Security with OCI

    Evaluate Your Organization's Security with OCI
    Join Lois Houston and Nikita Abraham, along with special guests Nancy Kramer and Betina Tagle from Oracle’s corporate security organization, as they discuss the steps you can take to evaluate your organization’s security, privacy, and compliance requirements using Oracle Cloud Infrastructure. They also talk about the resources that are available to help you do so.
     
    Oracle University Learning Community: https://education.oracle.com/ou-community
    Subscribe to Security Updates: https://www.oracle.com/security-alerts/
    Oracle Trust Center: https://www.oracle.com/trust/
     
    Special thanks to Arijit Ghosh, David Wright, and the OU Studio Team for helping us create this episode.
     
    --------------------------------------------------------
     
    Episode Transcript: 

    00;00;00;00 - 00;00;38;16

    Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let's get started.

    Hello and welcome to the Oracle University Podcast. I'm Nikita Abraham, Principal Technical Editor with Oracle University, and with me is Lois Houston, Director of Product Innovation and Go to Market Programs.

     

    00;00;38;20 - 00;01;01;13

    Hi there. In today's special episode, we're going to talk about all the steps you can take to evaluate your organization's security, privacy, and compliance requirements using Oracle Cloud Infrastructure. We'll also explore some of the resources that are available to help you do so.

    And to tell us all about it, we're joined by two guests from Oracle's corporate security organization.

     

    00;01;01;16 - 00;01;32;25

    Nancy Kramer is a Senior Director in Global Information Security. She has 20 years of experience in risk management, security, privacy, and compliance audits involving complex business processes and IT systems. She also provides thought leadership, including engagement with industry organizations. Dr. Betina Tagle is also with Global Information Security. She has over 20 years of experience with cybersecurity and compliance in both the private and public sector.

     

    00;01;32;27 - 00;01;52;26

    Thank you so much, Nancy and Betina, for being with us today.

    Yes, this is such an important topic to learn more about. I'm really interested in what you have to share with us.

    Thank you so much for having us. We are delighted to help our customers learn more about how to securely reap the benefits of cloud.

    Thanks for this opportunity, Niki and Lois.

     

    00;01;52;28 - 00;02;25;26

    As organizations adopt cloud services, they're seeking guidance on evaluating cloud service providers. Our goal is to offer helpful insights on the approach.

    Let's start with setting some context. What kind of challenges do organizations face in their cloud adoption journey?

    Organizations continue to migrate business-critical applications and workloads to the cloud. The benefits are compelling. Leveraging the cloud lets organizations focus on their core mission and minimize capital expenditure.

     

    00;02;25;29 - 00;03;08;09

    With cloud services, organizations still own their data while leveraging the expertise, economy of scale, technical flexibility, and scalability offered by their cloud providers. When organizations are considering their cloud strategy, they need to consider their security, privacy, and compliance objectives from internal and external sources, compiling their requirements for the cloud service providers. For example, external requirements may include applicable laws and regulations based on the organization's location, their customer location, industry, or the type of data they process.

     

    00;03;08;12 - 00;03;50;02

    Organizations would benefit from a thorough analysis of the regulatory environment by their legal team. Internal requirements may be defined by the organization's Board of Directors, CEO, CISO, and other executives, as well as internal policies and contractual commitments to their customers. Oracle Cloud Infrastructure, or OCI, provides services, features, and documentation resources to support these customer obligations.

    Oracle University and OCI also offer helpful courses to guide customers through securing their cloud tendencies using various OCI features and services.

     

    00;03;50;03 - 00;04;22;19

    I want to come back to those courses later, but first, who does what in the cloud? Which operational technology management tasks are handled by the cloud provider and which are the customer’s responsibility?

    I think it will help if I start by defining the categories of Oracle offerings and summarizing who does what per category. This will clarify the notion of the shared management model that is predominant in the cloud as well as the relative scope of available security assurance validations.

     

    00;04;22;22 - 00;04;57;08

    OCI services can be used to build and operate computing environments, which include data analysis, storage, system integrations, enterprise workloads, and cloud native or containerized applications. Oracle manages the hosted tools, but the customer is responsible for how they build, configure, and use these tools, and for the data processed in their tenancies. Some examples of OCI services are compute and autonomous database.

     

    00;04;57;10 - 00;05;30;11

    Exactly right, Betina. In contrast, cloud applications are hosted using a Software as a Service or SaaS model in which the cloud provider, such as Oracle, manages the cloud applications and the underlying infrastructure. Customers are responsible for how they configure and use these SaaS applications and for the data processed in their cloud tendencies. Examples of these services include Enterprise Resource Planning, ERP, and Human Capital Management, or HCM.

     

    00;05;30;13 - 00;05;59;11

    Customers are also responsible for securing any third-party integration associated with these SaaS offerings, as well as any custom code extension scripts that they add to the applications. Let me highlight the differences a bit more in relation to the traditional on-premises model where companies such as Oracle provide hardware and software that customers install, deploy, and manage in their own computing environments.

     

    00;05;59;13 - 00;06;25;23

    The customer is wholly responsible for the management of the entire technology environment in which those products are deployed and operated, as well as the data they process.

    That makes sense.

    Right, Lois. And Oracle strongly recommends that customers protect the computing environment they manage by installing security updates delivered through the Critical Patch Update, CPU, and Security Alert programs without delay.

     

    00;06;25;26 - 00;06;59;08

    Customers can view and even subscribe to notifications about these security updates at oracle.com/security-alerts.

    Just to summarize, cloud providers are responsible for the security of the cloud, and customers are responsible for security in the cloud. They still decide on what data to process, where, and how. No matter what type of cloud service, OCI or SaaS, customers should still do the following.

     

    00;06;59;08 - 00;07;34;01

    Implement settings for authentication and authorization per their security and privacy requirements for accounts and passwords. Manage access for user accounts, including auditing which user accounts have access to what data. Monitor the available logs and reports, and respond to security events as well as determine what data to process and manage that data per their organization's security and privacy objectives.

    And you're going to be joining us in the Oracle University Learning Community soon for a special live event to talk about all of this in more detail, right?

     

    00;07;34;02 - 00;07;57;13

    Yes, we are. We are so excited to talk to everyone in the community. We're going to look at this topic in-depth in the special live event that is scheduled for June 29th. We will walk you through a tour of relevant resources on oracle.com so you can make sure to plan ahead and attend.

    And you'll need to be a member of the community if you want to attend.

     

    00;07;57;14 - 00;08;17;13

    So be sure you join and register for the event today. If you're not already a member of the community, you can sign up by visiting mylearn.oracle.com. You'll find all the live events, including the one Nancy and Betina will be hosting, on the community home page.

    So Betina, how can people see a preview of those oracle.com resources?

     

    00;08;17;14 - 00;08;52;08

    Oracle offers a wealth of security and cloud compliance information on the Oracle Trust Center found at oracle.com/trust. The site includes Oracle Corporate security practices, the cloud compliance site of third-party independent attestations to various global and regional compliance frameworks, and the Oracle Security blog.

    You can view the independent third-party certifications for OCI in the Trust Center by clicking the Attestations link under the Cloud Compliance heading.

     

    00;08;52;10 - 00;09;22;06

    Please note that each attestation is scoped to a particular set of cloud services and data center regions. Clicking on a compliance framework name retrieves a general description and the link to the entity providing the compliance framework. Some examples of global compliance frameworks include ISO 27001, SOC 2, Cloud Security Alliance Star, and Payment Card Industry Data Security Standards or PCI DSS.

     

    00;09;22;08 - 00;09;45;23

    This site also includes geography-specific standards, such as US FedRAMP, UK CyberEssentials, European Union Cloud Code of Conduct for Privacy, and IRAP for Australia. Obviously, this information is subject to change and is updated frequently.

     

    00;09;45;25 - 00;10;11;16

    Want to learn more about modern best practices for cloud applications? Oracle University offers business processes training for Human Capital Management, Financials, Customer Experience, Supply Chain, and Procurement. From now through August 31st, you can take the training for any of these areas and get certified for free as well. Oracle Cloud training and certifications empower you to explore limitless possibilities in the cloud landscape.

     

    00;10;11;17 - 00;10;29;10

    Gain the knowledge and skills needed to design, deploy, secure, and operate modern cloud infrastructure and applications with confidence. Go to education.oracle.com for more details. What are you waiting for? Get certified today.

     

    00;10;29;12 - 00;11;04;29

    Welcome back. Let's say there's a customer who wants to view OCI compliance attestations. I know they can always contact Sales to get these audit reports, but are there any self-service options?

    Yes. OCI customers can download OCI attestations of compliance to various compliance frameworks, including global information security standards, via the OCI Console and the Compliance Documents screen. There are multiple types of compliance documents available depending on the compliance framework or standard.

     

    00;11;05;02 - 00;11;50;21

    These include audit reports, attestations of compliance, and certificates of compliance. While logged in to the OCI Console for your tenancy, open the navigation menu. Click Identity and Security from the left menu that appears and then click Compliance on the screen that appears. The Compliance Documents page displays all available documents. You can filter, sort, and download the compliance documents of interest from this page via the command line interface and using the OCI API. Instructions for accessing compliance documents are also in the OCI product documentation at docs.oracle.com.

     

    00;11;50;21 - 00;12;20;04

    Thanks, Betina. That's great to know. Nancy, what else does Oracle offer to help our customers secure their cloud workloads running on OCI?

    I can offer two additional recommendations. The first is to take advantage of the in-depth OCI courses available through Oracle University. The OCI learning subscription includes introductory as well as expert-level courses.

     

    00;12;20;06 - 00;12;59;02

    To get started, there's an OCI Foundations learning path that describes the types of services OCI offers, has some basic recommendations for configuring your tenancy so that you meet your organization's security and privacy and compliance objectives. There are some key terminology you'll be introduced to in that learning path, as well as recommendations for architecture that provide resilience and business continuity. For example, OCI regions typically have multiple availability domains which each, in turn, have multiple fault domains.

     

    00;12;59;05 - 00;13;31;01

    OCI designed these availability and fault domains to have redundant systems so that a disruption of service in one availability domain does not result in a disruption to all availability domains in that region. These kinds of architectural and system design choices will help organizations avoid disruption of their operations when using systems running in OCI.

    A more advanced Oracle University offering is the Cybersecurity and Oracle Cloud learning path.

     

    00;13;31;03 - 00;13;58;21

    This group of courses explains the various OCI services that can be used to implement information security controls for identity management, networks, managing encryption keys, network firewalls, vulnerability scanning, compartment management practices, and so much more.

    And all of our OCI training in MyLearn is available free to anyone. So, there are really no barriers to learning if you're interested in diving in.

     

    00;13;58;23 - 00;14;36;09

    Those are some great course recommendations, Nancy and Bettina. So, Nancy, you said you had two recommendations. What's the other one?

    My second suggestion is for customers to evaluate the suitability of OCI cloud services by downloading and reading the detailed information about security practices from oracle.com. Oracle published Consensus Assessment Initiative Questionnaires, also called CAIQ or “CAKE” for various cloud services, including for OCI. CAIQs are industry-standard questionnaires from the Cloud Security Alliance.

     

    00;14;36;12 - 00;15;11;14

    That is a global organization which defined a set of controls companies can use to evaluate all types of cloud services to essential security controls in a fair and consistent manner. Each CAIQ answers several hundred questions, encompassing important information security control domains such as audit and assurance, application security, business continuity, change management, data center physical controls, human resources, identity and access management, incident management, and finally, threat and vulnerability management.

     

    00;15;11;14 - 00;15;38;22

    These publicly-available CAIQs encompass a broad set of information security policies and practices that are most relevant for cloud services. You can download the OCI CAIQ from oracle.com/trust by drilling down on the Security Practices for Cloud section. We will also add it in the show notes so that it's easily accessible.

     

    00;15;38;25 - 00;16;07;16

    Thank you, Betina and Nancy. This has been a very informative conversation. I had no idea about all the details that went into corporate security. I can't wait for the live tour of these oracle.com public resources in the Oracle University Learning Community on June 29th.

    We're very much looking forward to that event as well.

    Thank you so much for giving us a chance to share guidance about how organizations can evaluate the security, compliance, and privacy of cloud service providers.

     

    00;16;07;18 - 00;16;31;02

    We look forward to being back here again.

    We’d love that. Thanks again! In our next episode, we’ll look at Oracle Machine Learning with Cloud Engineer Nick Commisso. Until then, this is Nikita Abraham and Lois Houston signing off.

    That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes.

     

    00;16;31;04 - 00;19;04;01

    We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

    Free OCI and Cloud Applications Certifications

    Free OCI and Cloud Applications Certifications
    In this special episode of the podcast, hosts Lois Houston and Nikita Abraham are joined by Rohit Rahi and Bill Lawson to talk about the free OCI training and certification being offered by Oracle University for a limited time.
     
    Find out how you can choose from over 25 different Oracle Cloud Infrastructure and Oracle Cloud Applications Business Process certifications and gain the knowledge and skills needed to boost your career.
     
    Oracle University Learning Community: https://education.oracle.com/ou-community
     
    Special thanks to Arijit Ghosh, David Wright, and the OU Studio Team for helping us create this episode.
     
    ---------------------------------------------------------
     
    Episode Transcript:
     

    00;00;00;00 - 00;00;39;02

    Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let's get started.

    Hello and welcome to the Oracle University Podcast. I'm Lois Houston, Director of Product Innovation and Go to Market Programs with Oracle University, and with me is Nikita Abraham, Principal Technical Editor.

     

    00;00;39;05 - 00;01;06;02

    Hey there! We're very excited about today's episode, which will be all about the free training and certification being offered for a limited time by Oracle University.

    And we're so excited to welcome two of our OU product development leaders to talk with us about the free training and certificate that's available. Rohit Rahi and Bill Lawson are joining us today. If you've been listening to the podcast, you already know Rohit because he was our special guest last season.

     

    00;01;06;04 - 00;01;29;22

    Rohit is Vice President, OCI Global Delivery, and has extensive experience in the cloud space. Bill is the Senior Director of Cloud Applications Product Management. His team looks after the new content development for Oracle Cloud Applications. All the great training that helps you successfully implement and use our cloud apps—his team creates it. Thank you so much, Bill and Rohit, for being with us today.

     

    00;01;29;24 - 00;01;59;14

    We're really excited to talk with you both.

    So, to start, Rohit, can you tell us a little about the free certification promotion in general?

    So, we have had free OCI training for a while now and have just launched a free certification exam promotion worldwide beginning June 1st and continuing through August 31st. Each participant in the promotion will get free access to OCI and Cloud Applications Business Process training.

     

    00;01;59;16 - 00;02;25;00

    They will also get two free exam attempts that they can apply towards any exam in the promotion.

    And what's the benefit of getting this training and certification from Oracle?

    This free promotion will help you acquire in-demand critical skills in Oracle Cloud computing, database, security, AI/ML, and application business processes to boost your career and deepen your core expertise. All of this while eliminating the cost barrier for getting certified.

     

    00;02;25;01 - 00;02;53;16

    When we're talking about gaining access to training, is it strictly training content or are there any other resources that will be made available?

    Well, we have packed a lot into this promotion. You will get access to Oracle MyLearn, where you can book your exams and access a library of learning and exam preparation materials. MyLearn is our one-stop platform where you get access to the content, training content, skill checks, exam prep material, all of it.

     

    00;02;53;22 - 00;03;24;05

    You will also have access to brand-new hands-on performance exams for select OCI and Cloud Applications certifications that will really help showcase your hands-on knowledge in real-life scenarios.

    And then there's the Race to Certification challenge, where you can complete race criteria and win prizes during your certification journey. You can also access Oracle University Learning Community for collaboration and idea sharing to help you better prepare for your free certification exam.

     

    00;03;24;07 - 00;03;50;01

    Wow. There really is a lot to offer. Now, who is this training for? Can an absolute beginner take this training or do you need to be more experienced to take it. Also, are there any prerequisites to participate in the promotion?

    Anyone can take this training. We have learning paths from the beginner to advanced levels. You can start with the free foundations classes and certifications for OCI and Data Management.

     

    00;03;50;08 - 00;04;22;12

    If you already have some knowledge, familiarity, and experience with OCI, you might want to look at the learning paths and certifications for architects, cloud developers, DevOps engineers, security engineers, cloud operations, machine learning engineers, data analysts, and database admins. There is really a lot to choose from. 21 tech exams in total.

    And if you're interested in learning more about Oracle Cloud Applications, you could take advantage of the free business process training and certifications for HCM, Financials, Sales, Procurement, and Supply Chain.

     

    00;04;22;19 - 00;04;45;23

    These provide a great opportunity to learn more about business processes as defined by Oracle's modern best practices and how our cloud applications modernize these processes to make running businesses even better. These classes and certifications are for any experience level from the recent college grad to the seasoned professional who wants to learn more about Oracle Cloud Applications.

     

    00;04;46;00 - 00;05;03;15

    That's awesome. Let's say I want to get started and enroll for this promotion. How would I go about doing that?

    Well. Well, you could start by going to education.oracle.com. All the information you need to know is on this page, including the details about the free training, which exams are included, and the Race to Certification challenge.

     

    00;05;03;18 - 00;05;28;15

    Yeah, that's right, Bill. This is a really exciting challenge we are running as part of the promotion in which you can earn prizes as you complete your learning. Like you said, all the information is on education.oracle.com and we are really happy to offer this opportunity for you to not only learn and certify for free, but also win additional prizes along the way.

     

    00;05;28;17 - 00;05;52;09

    Wow, that's really cool. Prizes—an added bonus!

    I thought Oracle Cloud Infrastructure was already free, Rohit. So what's really new here?

    You're absolutely right, Niki. The training for OCI is free and has been free for a while now. What is new in this promotion is the opportunity to get certified for free.

     

    00;05;52;11 - 00;06;14;06

    Want to get the inside scoop on Oracle University? Head on over to the all-new Oracle University Learning Community. Attend exclusive events. Read up on the latest news. Get firsthand access to new products and stay up-to-date with upcoming certification opportunities. If you're already an Oracle MyLearn user, go to MyLearn to join the community. You will need to log in first.

     

    00;06;14;08 - 00;06;26;21

    If you've not yet accessed Oracle My Learn, visit mylearn.oracle.com and create an account to get started. Join the community today.

     

    00;06;26;24 - 00;06;52;29

    Welcome back. Bill, I want to ask you about Oracle Cloud Apps Business Process training. For anyone who doesn't already know, what are these business processes and what sort of training do we offer on this?

    As I mentioned earlier, MyLearn has business process training related to HCM, ERP Financials, Procurement, Supply Chain Management, and Sales. For example, for HCM, there are processes such as Recruit to Onboard, which is in the Applicant life cycle.

     

    00;06;53;01 - 00;07;22;15

    Think about it. You as an employee, you have maybe once been contacted by a company through recruiting activities. Companies require processes to reach out to and identify potential candidates and set up interviews. You receive a job offer, you accept it. And on day one, you begin your onboarding process into the new company as a new hire. In a modern business, this is driven by technology and managed by various job roles within an organization, including you as the applicant, to move through the process quickly and efficiently on your career journey with the new company.

     

    00;07;22;17 - 00;07;43;20

    Other business processes for HCM include Hire to Retire, Payroll to Payment. You know we all like to get compensated for the hard work we do, right? And Career Planning to Development. For Financials processes such as Invoice to Cash, Procure to Pay, and Budget to Report. Within Sales, we have processes that we cover Lead to Opportunity, Opportunity to Quote, Quota to Order, and Order to Close, only to mention a few.

     

    00;07;43;25 - 00;08;09;26

    The Business Process training focuses on how these processes are managed within Oracle Cloud Applications, how data and control flows between the processes, the various job roles responsible for the activities and tasks for these processes, and the inputs and outcomes for each of them. Our content is rich text based, has captivating imagery, concepts explained by experts, product demonstrations, and quizzes to reinforce what you have learned.

     

    00;08;10;01 - 00;08;35;00

    Who would benefit most from this training, Bill?

    This training and certifications are for anyone who wants to build strong foundational knowledge of Oracle Cloud Business Processes to use, implement, and test Oracle Cloud Applications. You can be a business process owner, a functional user, an implementation project team member, an implementer, or on the user acceptance testing teams within your company or even university students.

     

    00;08;35;05 - 00;09;03;12

    It's so great that we have this free training for OCI and Cloud Apps. So, Rohit, what certifications are available for OCI?

    There are the two always free certifications, Foundations Associate certifications, one for OCI and one for Database Management. So, these are always free. And then we have 19 other certifications. For these, you would use the two free exam attempts that are included in the promotion.

     

    00;09;03;12 - 00;09;26;08

    You can find a list of all the exams on education.oracle.com.

    And Bill, what certifications are included for the business process training?

    For the business process training, there are five associate-level exams included for HCM, Financials, Sales, Procurement, and Supply Chain Management.

    This free promotion sounds like a great opportunity to learn some new things and get certified.

     

    00;09;26;11 - 00;09;44;00

    Bill, how many free exams can I take as part of the promotion? Can I choose any certification exam to take for free?

    The promotion includes two exam credits. Once you register through the promo page, these will be added to your MyLearn account. You can take any of the 26 exams that are part of the promotion.

     

    00;09;44;02 - 00;10;03;22

    You do have to register on education.oracle.com to get these exam credits though.

    And of course, you can always take the two OCI foundations exam which are free anytime and you don't have to pay for these exams.

    Yes, you're right. Good point, Rohit. And what happens if I don't pass the exam?

    You can retake any exam.

     

    00;10;03;25 - 00;10;22;26

    You can use the two credits on any of the exams included in the promotion. You can take two different exams or use both on one exam if you need to take a retake.

    And if I need more attempts or want to take more exams?

    You can buy additional exam credits through MyLearn for any exam, including the ones not part of this promotion.

     

    00;10;22;27 - 00;10;44;15

    So, let's think positive here. I've taken the exam and passed. Will I receive a digital badge or certification? How can I share this accomplishment with others?

    Absolutely, Niki, you can. You will have access to a digital badge when you pass the exam. These are available to you on MyLearn and you can share on social media, etc.

    Where can I go if I have more questions about this?

     

    00;10;44;17 - 00;11;03;13

    The best place to go is education.oracle.com. You'll find all the answers, including an FAQ section there.

    I want to know more about the contest you spoke about earlier. What do I have to do to win prizes and what kind of prizes are there?

    The contest combines the challenge of learning new skills and the opportunity to win prizes.

     

    00;11;03;16 - 00;11;25;00

    There are three sectors like there are in a racetrack, and as you complete each sector, you'll win prizes.

    Right, and at the end of the first sector, you will earn a free exam attempt and a special badge in the Oracle University Learning Community. When you complete the second sector, you earn a second free exam attempt and another badge in the community.

     

    00;11;25;00 - 00;11;47;03

    And when you complete the third and the final sector, you get yet another free exam attempt, if you're counting, that's three in total, and another community badge. But you will also get some additional prizes for this top tier, such as you will get access to our premium OCI labs for three months.

    Hmm, that's a pretty sweet deal if you ask me.

     

    00;11;47;03 - 00;12;06;23

    Free certifications and training, and you can win prizes on top of that!

    You're so right, Bill. Well, gentlemen, this has been very enlightening. There are lots of opportunities to learn new things and get certified as well. Thank you so much for joining us today and sharing about the free training and certifications that are available.

    Yeah, we're really excited to share this with our listeners.

     

    00;12;06;24 - 00;12;27;05

    Yeah. Thank you both for having us.

    Yes, it's been great to be back on the podcast with you both. Thank you.

    Don't forget this is only for a limited time from June 1st to August 31st. So, if you're wanting to take advantage, visit education.oracle.com, that's education.oracle.com, today and register for the promotion.

     

    00;12;27;05 - 00;12;49;07

    Well, that's all the time we have for today. Thank you so much for joining us. Until next week, this is Nikita Abraham and Lois Houston signing off.

    That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We'd also love it if you would take a moment to rate and review us on your podcast app.

     

    00;12;49;10 - 00;15;17;10

    See you again on the next episode of the Oracle University Podcast.

    Oracle Database Cloud Service

    Oracle Database Cloud Service
    In this episode, hosts Lois Houston and Nikita Abraham are joined once again by Alex Bouchereau to discuss how you can use Oracle Database Cloud Service to deploy Oracle Databases in the cloud. They also talk through the fundamentals of Oracle Cloud Infrastructure database system instances, including bare metal and virtual machine shapes and their storage architecture.
     
    Oracle University Learning Community: https://education.oracle.com/ou-community
     
    Special thanks to Arijit Ghosh, David Wright, Deepak Modi, Ranbir Singh, and the OU Studio Team for helping us create this episode.
     
    --------------------------------------------------------
     
    Episode Transcript:
     

    http://traffic.libsyn.com/oracleuniversitypodcast/Oracle_University_Podcast_S02_EP04.mp3

     

     

    00;00;00;00 - 00;00;38;21

    Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let's get started.

    Hello and welcome to the Oracle University Podcast. I'm Lois Houston, Director of Product Innovation and Go to Market Programs with Oracle University, and with me is Nikita Abraham, Principal Technical Editor.

     

    00;00;38;22 - 00;01;07;29

    Hi, everyone. In our last episode, we discussed Oracle Exadata Cloud Service with our Oracle Database Specialist Alex Bouchereau. If you missed that episode, please remember to go back and give it a listen. We're so excited to have Alex with us again and today she's going to talk about the fundamentals of OCI database system instances on Oracle Cloud Infrastructure. We'll also ask her about the DB system for bare metal and virtual machine shapes.

     

    00;01;08;02 - 00;01;40;22

    Hi, Alex. Can you tell us about the Oracle Database Cloud Service?

    Oracle Database Cloud Service provides you the ability to deploy Oracle databases to the cloud. You can deploy Enterprise Edition or Standard Edition 2 and any database version from 11.2 and later. You have the option to deploy using virtual machine or bare metal shapes. Database Cloud Service VM and BM metal DB systems are deployed in Oracle Cloud Infrastructure regions around the world.

     

    00;01;40;24 - 00;02;12;01

    With Database Cloud Service, you manage the database instance, including provisioning, patching, backup, and disaster recovery using OCI cloud automation tools, such as the OCI console, CLI, and API. There is also an SDK that supports a number of different languages. Using VM shapes, you can deploy real application clusters and scale your storage requirements.

    Walk us through the various Oracle database editions. You know, from Standard Edition 2 to Enterprise Edition Extreme Performance.

     

    00;02;12;03 - 00;02;37;15

    What are the key differences in terms of features, add-ons, and licensing options?

    Beginning with Standard Edition 2, features included with the service are Multitenant Pluggable Database and Tablespace Encryption. Moving to Enterprise Edition, you add additional database features, such as data guard and the EM packs of data masking and subsetting, tuning, and diagnostics.

     

    00;02;37;17 - 00;03;14;06

    With Enterprise Edition High Performance, in addition to the base Enterprise Edition, you add Management and Lifecycle Management packs as well as Advanced Security and Database Vault and Label Security. And finally, Enterprise Edition Extreme Performance has all the previously discussed features, plus Active Data Guard, Oracle RAC, and Database In-Memory. Note that all packages include Oracle Database Transparent Data Encryption, TDE. You have an option to bring your own license, BYOL, which means you could use your organization's existing Oracle Database software licenses.

     

    00;03;14;12 - 00;03;44;27

    What's the difference between bare metal instances and virtual machines in the context of Oracle Cloud Infrastructure?

    OCI is the only public cloud that supports BM and VMs during the same set of APIs, hardware, firmware, software stack, and networking infrastructure. Bare metal instances are single tenant and you have full control over the resources provisioned within the service. Virtual machines follow a multitenant model and share servers that are not overprovisioned.

     

    00;03;45;00 - 00;04;11;00

    So how is the customer billed for these services?

    For databases using bare metal and virtual machine infrastructure, Oracle Cloud Infrastructure uses per second billing. This means that OCPU and storage usage is billed by the second with a minimum usage period of one minute for virtual machine DB systems and one hour for bare metal DB systems.

     

    00;04;11;00 - 00;04;39;29

    For bare metal servers, there is an infrastructure charge along with the billing for OCPUs.

    Alex, can DBCS be customized? I mean, are there different kinds of DBCS offerings to fulfill the various needs of our customers?

    The maximum number of OCPUs, RAM, and storage for your database depends on the shape you choose. There are two types of DB systems on virtual machines. Single node or one-node virtual machine DB system consists of one virtual machine.

     

    00;04;40;02 - 00;05;13;27

    Two-node virtual machine DB systems consist of two virtual machines of separate servers. Virtual machine DB systems use Oracle Cloud Infrastructure block storage. Bare metal systems used NVMe local storage and are therefore not scalable. Storage scaling is available for all VM shapes. Online OCPU scaling is available for bare metal systems or for two-node RAC VMs.

    Alex, help us understand what Database Cloud Service on bare metal is.

     

    00;05;13;29 - 00;05;43;07

    How does it differ from other Oracle Database Service offerings?

    Database Cloud Service on bare metal is a database service offering that enables customers to deploy and manage full-featured Oracle databases on bare metal servers. Bare metal offers proven and predictable performance with local NVMe storage on dedicated servers that provide high IOPS with extremely low latency. Bare metal DB systems consist of a single bare metal server running Oracle Linux with locally attached NVMe storage.

     

    00;05;43;07 - 00;06;11;25

    If the node fails, you can simply launch another system and restore the databases from current backups. Bare metal DB system provide dedicated resources that are ideal for databases that are performance intensive.

    And how do you start a bare metal instance?

    When you launch a bare metal DB system, you select the single Oracle Database edition that applies to all the databases on that DB system.

     

    00;06;11;28 - 00;06;49;08

    The selected edition cannot be changed. Each DB system can have multiple database homes, which can be different versions. Each database home can have multiple databases, which are, of course, the same version as the database home.

    Are you attending Oracle CloudWorld 2023? Learn from experts, network with peers, and find out about the latest innovations when Oracle CloudWorld returns to Las Vegas from September 18 through 21. CloudWorld is the best place to learn about Oracle solutions from the people who build and use them.

     

    00;06;49;12 - 00;07;17;22

    In addition to your attendance at CloudWorld, your ticket gives you access to Oracle MyLearn and all of the cloud learning subscription content as well as three free certification exam credits. This is valid from the week you register through 60 days after the conference. So what are you waiting for? Register today. Learn more about Oracle CloudWorld at www.oracle.com/cloudworld.

     

    00;07;17;24 - 00;07;46;08

    Welcome back. Alex, can you explain how Automatic Storage Management interfaces with disks in OCI?

    ASM directly interfaces with the disks. When you provision a bare metal system, you will indicate the data storage percentage assigned to data storage, which is user data and database files. Your choice is 40% or 80%. The remaining percentage is assigned to RECO storage consisting of database redo logs, archive logs, and recovery manager backups.

     

    00;07;46;08 - 00;08;20;14

    Storage is continuously monitored for any faults. Any disk that fails will be taken offline. Whenever the shapes list a maximum amount of usable space and data in RECO, these reservations for rebalancing are already taken into account. The root user has complete control over the storage subsystem so customization and tuning are possible. But the service already optimally configures these by default according to best practices.

     

    00;08;20;18 - 00;08;58;20

    So what are the key benefits of running databases on virtual machines?

    Database Service on VMs is a Database Service offering that enables customers to build, scale, and manage full-featured Oracle databases on virtual machines. The key benefits of running databases on VMs are cost-effectiveness, ease of getting started, durable and scalable storage, and the ability to run real application clusters, RAC, to improve availability. Database Cloud Service on VMs is built on the same high performance, highly available cloud infrastructure used by all Oracle Cloud Infrastructure services.

     

    00;08;58;22 - 00;09;23;21

    RAC databases will run on a single availability domain (AD) while ensuring each node is on a separate physical RAC, ensuring high availability. When you launch a virtual machine DB system, you select the Oracle Database edition and version that applies to the database on that DB system. The selected edition cannot be changed. Depending on your selected Oracle database edition and version, your DB system can support multiple pluggable databases, PDBs.

     

    00;09;23;28 - 00;09;59;17

    Are there various kinds of compute shapes available with DBCS?

    Virtual machine database systems offer compute shapes with 1 to 24 cores to support customers with small to large database processing requirements. A virtual machine DB system database uses Oracle Cloud Infrastructure block storage instead of local storage. You specify a storage size when you launch the DB system, and you can scale up the storage as needed at any time.

     

    00;09;59;17 - 00;10;27;26

    On-demand up and down scaling of database OCPUs use without interrupting database operations on two-node Oracle Real Application Cluster deployments allows customers to meet application needs while minimizing costs. To change to the number of CPU cores on an existing virtual machine DB system, you will change the shape of that DB system.

    Can you tell us about the node virtual machine DB systems in OCI?

     

    00;10;27;28 - 00;11;01;22

    For one-node virtual machine DB systems, Oracle Cloud Infrastructure provides a fast provisioning option that allows you to create a DB system using Logical Volume Manager, LVM, as your storage management software. Fast provisioning for an Oracle Database with Logical Volume Manager increases developer productivity.

    Can we also choose to use Automatic Storage with DBCS?

    You have a choice to select ASM storage management. You will select Oracle Grid Infrastructure when you provision your DB system to use Oracle Automatic Storage Management.

     

    00;11;01;25 - 00;11;32;03

    This is required for RAC deployments. Virtual machine DB system deployments with ASM support 11.2 database versions and above, whereas virtual machine DB system deployments with LVM support 12.2 database versions and above. When you provision your virtual machine DB system, you will identify the amount of available storage. This is the amount of block storage and gigabyte to allocate to the virtual machine DB system.

     

    00;11;32;05 - 00;11;56;05

    Available storage can be scaled up or down as needed after provisioning your DB system. You will also indicate total storage, the total block storage and gigabyte used by the virtual machine DB system. The amount of available storage you select determines this value. Oracle charges for the total storage used.

    What our customers really want to know is how their data is kept secure?

     

    00;11;56;11 - 00;12;26;29

    Lay it out for us. Alex.

    Identity Management, network controls, and encryption are all built into Database Cloud Service virtual machine and bare metal DB system to provide end-to-end security. Oracle Data Safe is an integrated security service available at no additional cost. With it, you could do a few things. Identify configuration drift through overall security assessments. This helps you identify gaps and then fix the issues. Flag risks users or behavior, and see if they're all well controlled.

     

    00;12;27;02 - 00;12;54;14

    Audit user activity. Track risky actions. Raise alerts and streamline compliance checks. Discover sensitive data. Know where it is and how much you have. Mask sensitive data. Three out of four DB instances are copies for dev test. This lets you remove that risk. To help meet security compliance standards, you can optionally enable FIPS, STIG, and SELinux options.

     

    00;12;54;20 - 00;13;15;04

    Thank you, Alex, for guiding us through all of this. To learn more about Oracle Database Cloud Service, please visit mylearn.oracle.com and take a look at our free Oracle Cloud Data Management Foundations Workshop. You'll also find quizzes that you can take to test your understanding of these concepts.

    That brings us to the end of this episode.

     

    00;13;15;06 - 00;13;39;11

    We're very excited about our episode next week in which we'll be talking with Rohit Rahi, Vice President of OCI Global Delivery, and Bill Lawson, Senior Director of Cloud Applications Product Management for Oracle University. We'll be talking about the free Oracle Cloud Infrastructure and Cloud Apps training and certifications that are available for a limited time. So you really won't want to miss that episode!

     

    00;13;39;13 - 00;16;23;28

    Until next time, this is Lois Houston and Nikita Abraham signing off.

    That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.