Oracle Database Developer Learning Subscription

  • Tuition USD $2,995
  • Reviews star_rate star_rate star_rate star_rate star_half 839 Ratings
  • Course Code OR-DB-LS
  • Duration 0 hours
  • Available Formats Subscription

Oracle Database Developer Learning Subscription Learn SQL, Application Express, and Other Core Database Developer Tools Used to Build Successful Applications Through Oracle University training, learn how to create transformative applications by developing foundational knowledge of Oracle’s key development tools. In this learning subscription, you will have access to training modules with course content that shows you how to effectively leverage Oracle’s integrated set of tools for application to build sophisticated applications. Learn how to rapidly adopt these new technologies through lessons and hands-on practice building database developer applications. The Oracle Database Developer Learning Subscription gives you access to courses that cover the following key topic areas:

  • SQL
  • PL/SQL
  • Application Express (APEX)

Skills Gained

  • Log in to an Oracle Application Express workspace
  • Create and run database applications using desktop and mobile interfaces
  • Create reports and forms in an application
  • Create pages and regions in an application
  • Create page and application items and buttons
  • Create page processes and validations
  • Implement security
  • Manage application navigation
  • Extend an application
  • Create themes and templates
  • Create shared components such as tabs, lists, and breadcrumbs
  • Add dynamic actions
  • Import and use plug-ins
  • Create and use calendars and trees
  • Utilize Application Express Printing methods
  • Manage Application feedback
  • Create and use RESTful Web Services
  • Generate Form based on Methods on Tables utility
  • Make your application accessible
  • Customize themes and templates
  • Incorporate interactivity in your application
  • Build tabs based on a static list
  • Extend your applications using collections, dynamic applications, and plugins
  • Learn how to secure your application
  • Deploy and maintain your applications
  • Explain basic data mining concepts and describe the benefits of predictive analysis
  • Understand primary data mining tasks, and describe the key steps of a data mining process
  • Use the Oracle Data Miner to build, evaluate, and apply multiple data mining models
  • Use Oracle Data Mining's predictions and insights to address many kinds of business problems, including: Predict individual behavior, Predict values, Find co-occurring events
  • Learn how to deploy data mining results for real-time access by end-users
  • Trace an application through its different levels of the application architecture
  • Understand how the Query Optimizer makes decisions about how to access data
  • Define how optimizer statistics affect the performance of SQL
  • List the possible methods of accessing data, including different join methods
  • Identify poorly performing SQL
  • Modify a SQL statement to perform at its best
  • Design PL/SQL anonymous block that execute efficiently
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
  • Handle exceptions in the program units
  • Create and execute simple stored procedures and functions
  • Write PL/SQL code to interface with the database
  • Describe the features and syntax of PL/SQL
  • Learn the basics of XML and create well-formed and valid XML documents
  • Learn about XML namespaces
  • Create document type definitions (DTDs) to validate XML documents
  • Create XML schema documents (XSDs) to validate XML documents
  • Learn to use the XPath language, XPath expressions, and XPath functions to find and select nodes in XML documents
  • Discover the support for XML offered in various Oracle products such as Oracle JDeveloper and Oracle XML DB
  • Use JDeveloper to view, create, and edit XML and other XML-related documents
  • Use JDeveloper to test XPath expressions and to create and execute XQuery files
  • Use Extensible Stylesheet Language (XSL) Transformations (XSLT) to transform one XML document into another XML document

Who Can Benefit

  • Database developer
  • XML developer
  • SQL developer
  • PL/SQL developer
  • Application Express (APEX) developer

Course Details

Course Outline

  • Introducing Oracle Application Express
  • Creating a database application
  • Using and creating interactive reports
  • Creating classic, wizard and mobile reports
  • Creating forms
  • Working with pages and regions
  • Adding items and buttons
  • Understanding session state
  • Including page processing
  • Validating and debugging your application
  • Adding shared components that aid navigation
  • Working with themes, templates and files
  • Implementing security
  • Managing application navigation
  • Extending your application
  • Creating and editing charts
  • Adding calendars and trees
  • Using dynamic actions and plug-ins
  • Utilizing Application Express printing
  • Managing application feedback
  • Using collections
  • Generating and using table APIs
  • Extending your application: dynamic actions
  • Extending your application: plug-ins
  • Creating and using RESTful web services
  • Using themes and template
  • Making your application accessible
  • Incorporating interactivity in your application
  • Building tab drop down as dynamic/static list
  • Securing your application
  • Deploying and maintaining your application
  • Optimizing your APEX application
  • Data mining concepts
  • Understanding the Data Mining process
  • Using classification models
  • Using regression models
  • Performing market basket analysis
  • Deploying Data Mining results
  • Exploring the Oracle Database architecture
  • Introduction to SQL tuning
  • Introduction to the optimizer
  • Application tracing
  • Declaring PL/SQL variables
  • Writing anonymous PL/SQL blocks
  • Using SQL statements within a PL/SQL block
  • Writing control structures
  • Working with composite data types
  • Handling exceptions
  • Using explicit cursors
  • Creating stored procedures and functions
  • Validating XML with a Document Type Definitions (DTDs)
  • Modularizing XML with namespaces
  • Validating XML documents
  • Navigating XML documents by using XPath
  • Transforming XML by using XSL transformations
  • Working with XQuery
  • Preparing for Oracle Database Appliance installation
  • Readying Oracle Database Appliance for deployment
  • Virtualized platform deployments

How do I enroll?

A comprehensive listing of ExitCertified courses can be found here. You can register directly for the required course/location when you select "register". If you have any questions or prefer to speak with an ExitCertified education consultant directly, please submit your query here. A representative will contact you shortly.

How do I pay for a class?

You can pay at the time of registration using credit card (Mastercard/Visa/American Express) cheque or PO.

What if I have training credits?

ExitCertified honors all savings programs from the partners we work with. ExitCertified also offers training credits across multiple partners through our FLEX Account.

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Course was thoroughly prepared and covered all the necessary applications and services. It was evident that the instructor had in-depth knowledge on Big Data (Data Analytics) as well as other AWS services.

The course was overall very good, I would recommend breaking some topics into their own respective courses such as cloudformation as 1 lecture does not do it justice.

Very well organized training material. The instruction was knowledgeable and ready to help or answer questions.

I felt as if I was able to learn and retain a lot within just 3 days of training

Great instructor and good class material. Labs were helpful and put together very well.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward