Oracle Database Developer Learning Subscription With Exam Vouchers
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.
Developers, Implementers and Systems Administrators
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.
- 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.
Introducing Oracle Application Express
Creating a database application
Using and creating interactive reports
Creating classic, wizard and mobile reports
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
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
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
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
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
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
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
Hasonló tanfolyamok listája:
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 organisation who need Java training but are at various stages of their development.
A tanfolyam során a hallgatók elsajátíthatják az Oracle adatbázisok telepítésével, üzemeltetésével és hangolásával kapcsolatos feladatokat.
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.