Oracle Autonomous Transaction Processing for Developers
Oracle Autonomous Transaction Processing gives developers the ability to create a fully automated, self-driving Oracle database in the cloud. This course will help you create a new database and get your application connected in just over an hour.
What you'll learn
Every application needs a database to store its data. But setting up and managing a new database has traditionally been a slow and time-consuming process. With Oracle Autonomous Transaction Processing, you can set up a fully managed Oracle database hosted in the cloud in a matter of minutes. In this course, Oracle Autonomous Transaction Processing for Developers, you will learn everything you need to know to start creating applications with Autonomous Transaction Processing. First, you will learn how to create an Autonomous Transaction Processing database in the Oracle Cloud. Next, you will discover how to connect to Autonomous Transaction from various programming languages. Finally, you will explore how to manage your Autonomous Transaction Processing instance. When you are finished with this course, you will have the skills and knowledge to start writing applications against Autonomous Transaction Processing and take advantage of its most important features.
Table of contents
- What Is Autonomous Transaction Processing 2m
- Why Use Autonomous Transaction Processing 3m
- An Overview of the Oracle Cloud 5m
- Creating an Autonomous Transaction Processing Database 3m
- Connecting with SQL Developer 4m
- Creating Application Users 2m
- Creating Database Objects 2m
- Running SQL Against Autonomous Transaction Processing 2m
- What Languages Can Connect to Autonomous Transaction Processing 2m
- Downloading the Client Credentials File 3m
- Connecting a Java Application to Autonomous Transaction Processing 5m
- Installing the Oracle Instant Client 6m
- Connecting a Python Application to Autonomous Transaction Processing 3m
- Importing Large Data Files Using the DBMS_CLOUD Package 8m
- What You Have Learned 1m
- Managing Autonomous Transaction Processing Using the Web Portal 3m
- Backing up and Restoring an Autonomous Transaction Processing Database 2m
- Restoring Data Using Oracle Flashback Technology 4m
- Performance Monitoring and Tuning with Autonomous Transaction Processing 2m
- APIs, SDKs, and the Oracle Cloud Command Line Interface (CLI) 1m
- Installing the Oracle Cloud CLI 6m
- Running Commands Using the Oracle Cloud CLI 2m
- Uploading a File Using the Oracle CLI 4m
- Course Wrap Up 1m
About the author
David Berry is a software engineer with over 15 years of application development experience. He started developing software in Java 1.0 using an Oracle 7 backend. Making the switch to Microsoft .NET when it was released, he has worked with every version of .NET since. He has also worked with every version of Oracle since Oracle 7 and ever version of SQL Server since SQL Server 7. His experience spans a broad range of industries including semiconductors, financial services, insurance an gove... more