Oracle Database Developer Learning Subscription

Course Fees: $5413.00 excl. GST
Printed Manual: $0.00 excl. GST
Course Duration: 365 days
Course Manual

Sorry, no course dates found

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.

The Oracle Database Developer Learning Subscription gives you access to courses that cover the following key topic areas:

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

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.

Learn more about the topics included in this learning subscription below.

Topic 1: Oracle Database SQL

You will learn the concepts of relational databases and the powerful SQL programming language. Lessons provide you with essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.

Enhance your application development skills by learning how to manage the database objects, data dictionary views, and multicolumn subqueries. Learn how to write more efficient queries using functions

supporting the time zone and regular expressions. You’ll learn how to:

  • Grant and revoke privileges and roles
  • Manage schema objects and data dictionary views
  • Write efficient and complex subqueries
  • Use the in-built functions supporting the usage of regular expressions and time zone

Topic 2: PL/SQL

This learning path teaches you how to develop stored procedures, functions, packages and database triggers. Explore managing PL/SQL program units and dependencies, as well as usage of some of the Oracle-supplied packages. Discover how to:

  • Conditionally control code flow (loops, control structures)
  • Use PL/SQL packages to group and contain related constructs
  • Generate triggers to solve business challenges
  • Create anonymous PL/SQL blocks, as well as stored procedures and functions
  • Use some of the Oracle supplied PL/SQL packages to generate screen output and file output
  • Create anonymous PL/SQL blocks, functions and procedures
  • Declare PL/SQL variables
  • Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications
  • Debug functions and procedures using the SQL Developer Debugger
  • Use Dynamic SQL and understand design considerations when coding using PL/SQL
  • Understand and influence the PL/SQL compiler and manage dependencies
  • Manage PL/SQL subprograms, triggers, declaring identifiers, and trapping exceptions

Topic 3: Oracle Application Express (APEX)

Through subscription training courses, prepare yourself to use a simple-to-manage, highly scalable tool with rapid browser-based development and self-service provisioning. Share data and create web applications using only a web browser, even with limited programming experience. You will also learn how to create forms, work with pages, add items and buttons, implement security, manage application navigation, create and edit charts, and add calendars and trees.

Access 8 Oracle Database Developer Courses and 80+ Hours of Course Content

This comprehensive learning subscription includes video lessons that dive into expert topics, skills assessments that let you track your progress, hands-on labs to apply your learning within realistic simulations, and certification exams that prove you can execute database developer related tasks.

Learn just-in-time to complete specific tasks through topic-based modules and use course content as quick reference material, as needed. Course content is added to the subscription throughout the year to provide you with ongoing value and ensure you’re up-to-date with the latest Oracle Database releases.

Get Oracle Database Certified to Prove You Possess in Demand Skills

The Oracle Database developer training courses prepare you for a number of developer certifications you can access from within your subscription. Earn an industry-recognized credential you can share with your current or future employers. Join thousands of Oracle certified developers who benefit from being certified. Learn more about the benefits of Oracle Certification.

Become an Oracle Database Developer with Development Tools Training

Oracle developers who are responsible for creating and maintaining database components will gain the necessary skills to either convert existing applications or develop new applications that will run in a database environment.

Oracle Database developers learn how to execute these and other tasks by investing in this subscription:

  • Implementing the data model required by the application
  • Creating schema objects and implementing rules for data integrity
  • Choosing a programming environment for a new development project
  • Writing server-side PL/SQL or Java subprograms and client-side procedural code that use SQL statements
  • Creating the application interface with the chosen development tool
  • Establishing a Globalization Support environment for developing globalized applications
  • Instantiating applications in different databases for development, testing, education, and deployment in a production environment
  • This Learning Subscription provides you with training to begin, and advance, your career as an Oracle Database developer. Dive into the topics covered, skills learned, and more below. Preview this learning subscription to find out more about what’s included.

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

 

Certification Exams Included with this Subscription

Gain professional recognition for your expertise with an Oracle Certification. This learning subscription provides you with one attempt to take the following Oracle Certification exams, at no additional charge, during the subscription period. Pass the Oracle Developer exams and earn the corresponding Oracle Certification:

Skills Learned

  • 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
  • And more…