fbpx

Oracle Database Developer Learning Subscription With Exam Vouchers

Course code:
MFORADBALS
Course length:
88 lessons, at your preferred time
Course price:
320 813 Huf + VAT
Short description:

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.

Prerequisites:

English knowledge

Who do we recommend?

Developer, Implementer, Systems Administrator

Training language:
English
Specification:

 The Oracle Learning Subscription Includes:

  • Access to content 24/7 for one year
  • Oracle expert instruction
  • Hands-on lab exercises
  • Instructor Q&A

With an Oracle Learning subscription you will have access to learning paths, skill checks, and the ability to view topics at a modular level to quickly find and view the information you need.

Learning Paths:

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

 

 

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.

 
 Find more information about the learning pathes and the included courses HERE

 

Oracle SQL tanfolyamok

 

Course Topics: 

  1. Introducing Oracle Application Express
  2. Creating a database application
  3. Using and creating interactive reports
  4. Creating classic, wizard and mobile reports
  5. Creating forms
  6. Working with pages and regions
  7. Adding items and buttons
  8. Understanding session state
  9. Including page processing
  10. Validating and debugging your application
  11. Adding shared components that aid navigation
  12. Working with themes, templates and files
  13. Implementing security
  14. Managing application navigation
  15. Extending your application
  16. Creating and editing charts
  17. Adding calendars and trees
  18. Using dynamic actions and plug-ins
  19. Utilizing Application Express printing
  20. Managing application feedback
  21. Using collections
  22. Generating and using table APIs
  23. Extending your application: dynamic actions
  24. Extending your application: plug-ins
  25. Creating and using RESTful web services
  26. Using themes and template
  27. Making your application accessible
  28. Incorporating interactivity in your application
  29. Building tab drop down as dynamic/static list
  30. Securing your application
  31. Deploying and maintaining your application
  32. Optimizing your APEX application
  33. Data mining concepts
  34. Understanding the Data Mining process
  35. Using classification models
  36. Using regression models
  37. Performing market basket analysis
  38. Deploying Data Mining results
  39. Exploring the Oracle Database architecture
  40. Introduction to SQL tuning
  41. Introduction to the optimizer
  42. Application tracing
  43. Declaring PL/SQL variables
  44. Writing anonymous PL/SQL blocks
  45. Using SQL statements within a PL/SQL block
  46. Writing control structures
  47. Working with composite data types
  48. Handling exceptions
  49. Using explicit cursors
  50. Creating stored procedures and functions
  51. Validating XML with a Document Type Definitions (DTDs)
  52. Modularizing XML with namespaces
  53. Validating XML documents
  54. Navigating XML documents by using XPath
  55. Transforming XML by using XSL transformations
  56. Working with XQuery
  57. Preparing for Oracle Database Appliance installation
  58. Readying Oracle Database Appliance for deployment
  59. Virtualized platform deployments
  60. And more…
 

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
Related exams:

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:

  •  Oracle Database SQL | 1Z0-071
  • Oracle Database 11g: Program with PL/SQL | 1Z0-144
  • Oracle Database: Advanced PL/SQL | 1Z0-148
  • Oracle Application Express 18: Developing Web Applications | 1Z0-750
Back


List of similar or related courses:

Java is the #1 programming language for developing applications across conventional and cloud environments. It provides the basis for enterprise applications on a wide range of devices and platforms. Java offers developers a continually advancing language and platform to create the next generation of rich, scalable, and secure enterprise applications. Through this self-paced, online training solution, the Java Programming Learning Subscription offers the complete, up-to-date Java SE and Java EE training you need. This is an ideal solution to make available to multiple people throughout your organization who need Java training but are at various stages of their development.

Training content included within the Oracle Business Intelligence (BI) Learning Subscription will teach you how to apply the integrated array of query, reporting, analysis, alerting, mobile analytics, data integration, data management, and desktop integration using the BI foundation and associated tools.

The Oracle Database 12c R2: New Features for 12c R1 Administrators course is designed for existing 12c Release 1 DBAs. In addition to covering the New Features of R2, this course also introduces students to the Oracle Database Cloud Service.

The Oracle Database 12c: Administration Workshop will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance.

This Oracle Database 12c: Fundamentals for Developers and System Administrators training helps you perform basic Oracle Database 12c administration tasks. Learn how to keep the database operational.In this course, you will be introduced to Oracle Database Cloud Service.


Testimonials