Oracle Student Subscription

Java

Oracle: Java SE 8 Programmer

Self Study Student_Oracle_1
Java: Online Self-Study Student Subscription Package $750
Java: Online Instructor Led Training Package (3 months) $1499

Training Package includes:

  • Digital learning
  • Student eKit materials
  • Hands-on activity guides and quizzes
  • Cloud Environments
  • Industry recognized certification exams or assessments

Description

Java is one of the world’s most popular programming languages, and it is among the highest in demand by employers. Java runs on over 7 billion devices worldwide, and it is used to build the back-end for modern enterprise-web applications. It powers company websites, such as LinkedIn.com, Netflix.com and Amazon.com. Java is also excellent for developing enterprise applications in virtually any industry, including but not limited to financial services, healthcare and manufacturing. This Java SE 8 training enables those with little or no programming experience to learn object-oriented programming using the Java language. It provides a solid foundation to build upon throughout your software development career.

Prerequisites

Basic Computer Skill or equivalent.

Learning Objectives

This Oracle Java course offers you an introduction to writing Java code that uses variables, arrays, conditional and loop constructs. Students will learn the object oriented concepts to manipulate and format data.

Topics

  • Getting Started with Java, Programs, and Classes
  • Objects, Data, and Methods
  • Encapsulation and Conditionals
  • Dates, Arrays, Loops, and Inheritance
  • Interfaces and Exceptions
  • Application Deployment and Maintenance

Oracle 1Z0-808 Exam: Java SE 8 Programmer I

Exam Number: 1Z0-808
Associated Certifications: Oracle Certified Associate, Java SE 8 Programmer , Oracle Certified Java Programmer,
Exam Product Version: Java SE
Exam Price: US$ 245 More on exam pricing
Duration: 150
Number of Questions: 80
Passing Score: 65% View passing score policy
Validated Against: This exam has been written for the Java SE 8 release.
Exam Format: Multiple Choice

Exam Topics

Java Basics 
  • Define the scope of variables
  • Define the structure of a Java class
  • Create executable Java applications with a main method; run a Java program from the command line; produce console output
  • Import other Java packages to make them accessible in your code
  • Compare and contrast the features and components of Java such as: platform independence, object orientation, encapsulation, etc.
Working With Java Data Types 
  • Declare and initialize variables (including casting of primitive data types)
  • Differentiate between object reference variables and primitive variables
  • Know how to read or write to object fields
  • Explain an Object’s Lifecycle (creation, “dereference by reassignment” and garbage collection)
  • Develop code that uses wrapper classes such as Boolean, Double, and Integer
Using Operators and Decision Constructs 
  • Use Java operators; use parentheses to override operator precedence
  • Test equality between Strings and other objects using == and equals ()
  • Create if and if/else and ternary constructs
  • Use a switch statement
Creating and Using Arrays 
  • Declare, instantiate, initialize and use a one-dimensional array
  • Declare, instantiate, initialize and use multi-dimensional arrays
Using Loop Constructs 
  • Create and use while loops
  • Create and use for loops including the enhanced for loop
  • Create and use do/while loops
  • Compare loop constructs
  • Use break and continue
Working with Methods and Encapsulation 
  • Create methods with arguments and return values; including overloaded methods
  • Apply the static keyword to methods and fields
  • Create and overload constructors; differentiate between default and user defined constructors
  • Apply access modifiers
  • Apply encapsulation principles to a class
  • Determine the effect upon object references and primitive values when they are passed  into methods that change the values
Working with Inheritance 
  • Describe inheritance and its benefits
  • Develop code that makes use of polymorphism; develop code that overrides methods;  differentiate between the type of a reference and the type of an object
  • Determine when casting is necessary
  • Use super and this to access objects and constructors
  • Use abstract classes and interfaces
Handling Exceptions 
  • Differentiate among checked exceptions, unchecked exceptions, and Errors
  • Create a try-catch block and determine how exceptions alter normal program flow
  • Describe the advantages of Exception handling
  • Create and invoke a method that throws an exception
  • Recognize common exception classes (such as NullPointerException, ArithmeticException, ArrayIndexOutOfBoundsException, ClassCastException)
Working with Selected classes from the Java API 
  • Manipulate data using the StringBuilder class and its methods
  • Create and manipulate Strings
  • Create and manipulate calendar data using classes from java.time.LocalDateTime,  java.time.LocalDate, java.time.LocalTime, java.time.format.DateTimeFormatter, java.time.Period
  • Declare and use an ArrayList of a given type
  • Write a simple Lambda expression that consumes a Lambda Predicate expression

Reference: Oracle Exam

SQL

Oracle: SQL OCA

Self Study Student_Oracle_1
Online Self-Study Student Subscription Package SQL: $750
Virtual Instructor Led Training Package (3 months) $1499

Training Package includes:

  • Digital learning
  • Student eKit materials
  • Hands-on activity guides and quizzes
  • Cloud Environments
  • Industry recognized certification exams or assessments

Description

Learn the concepts of relational databases and the powerful SQL programming language. Discover essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables and create database objects. Learn the SQL Language and how to retrieve data with the SELECT Statement and to Add, Remove, Change & Manage Data with DML & DDL Statements. Further enhance your skills as an Application developer by learning how to manage the database objects, data dictionary views and multicolumn subqueries and to write more efficient queries using the functions that support timezone and regular expressions.

Prerequisites

Basic Database Design or programming skills or equivalent.

Learning Objectives

This Oracle SQL course offers you an introduction to Oracle Database 12c database technology.

Topics

You will learn the concepts of relational databases and the powerful SQL programming language. The course will include the following topics:

  • Getting Started
  • The SELECT Statement
  • SQL Functions
  • Using Joins, Subqueries and Set Operators
  • Adding, Removing, and Changing Data
  • Managing Database Objects
  • Advanced Subqueries
  • User Security
  • Advanced DML
  • Working in Time Zones

PL/SQL

Oracle: PL/SQL

Self Study Student_Oracle_1
Online Self-Study Student Subscription Package PL/SQL: $750
Virtual Instructor Led Training Package (3 months) $1499

Training Package includes:

  • Digital learning
  • Student eKit materials
  • Hands-on activity guides and quizzes
  • Cloud Environments
  • Industry recognized certification exams or assessments

Description

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation’s procedural extension for SQL and the Oracle relational database. At run-time, both PL/SQL and SQL run within the same server process, bringing optimal efficiency. PL/SQL automatically inherits the robustness, security, and portability of the Oracle Database. As organizations seek to do more with their data, they need more professionals who can enable the correct and efficient implementation of the business functions and the persistence and retrieval of their effects and learning PL/SQL will provide you with these skills.

Prerequisites

Basic Database Design or programming skills or equivalent.

Learning Objectives

Learn PL/SQL programming language basics, including the basic programming block structure. Learn conditional statements, looping constructs, and additional functionality to extend the use of SQL.

Topics

Introduction to PL/SQL
Programming with PL/SQL
Working with PL/SQL Program Units
Using Packages and Triggers
Managing Your PL/SQL Code

Node.js

Oracle: Node.js

Self Study Student_Oracle_1
Node.js: Online Self-Study Student Subscription Package $750
Virtual Instructor Led Training Package (3 months) $1499

Training Package includes:

  • Digital learning
  • Student eKit materials
  • Hands-on activity guides and quizzes
  • Cloud Environments
  • Industry recognized certification exams or assessments

Description

Node.js is popular with developers for creating data-intensive real-time applications that run across distributed devices. Its popularity is also growing with organizations that are seeking to optimize high-traffic websites. Learn a set of programming skills that organizations are finding more valuable.

Prerequisites

Basic Database Design or programming skills or equivalent.

Learning Objectives

Learn to code using JavaScript and the Node.js framework.
Develop, integrate and deploy Node RESTful applications using Oracle Cloud services.

Topics

Node Application Development Lifecycle
JavaScript Kickoff
Node JS Servers
JavaScript Front-End Simplification
JavaScript Pro
JavaScript Applications

DBA

Oracle:Database Administrator

Self Study Student_Oracle_1
DBA: Online Self-Study Student Subscription Package $750
Virtual Instructor Led Training Package (3 months) $1499

Training Package includes:

  • Digital learning
  • Student eKit materials
  • Hands-on activity guides and quizzes
  • Cloud Environments
  • Industry recognized certification exams or assessments

Description

Oracle Database 12c introduces a new multitenant architecture that makes it easy to deploy and manage database clouds and enables customers to take full advantage of the resource sharing, management flexibility and cost savings that cloud computing offers. Discover how to navigate in a Cloud environment with this Oracle Database Administration Student Learning Subscription offering.

Prerequisites

Basic Database Design or programming skills or equivalent.

Learning Objectives

Learn basic Oracle Database administrative tasks in the Cloud.
Discover how to manage the Oracle Database using Oracle Cloud services.

Topics

Getting Started
Management Tools
Instance Management
Configuring the Network
User Security
Database Storage
Managing Space & Undo Data
Data Concurrency
Implementing Oracle Database Auditing
Introduction to Backup and Recovery
Backup & Recovery: Configuration
Performing Database Backups
Performing Database Recovery
Moving Data
Database Maintenance
Introduction to Performance Management
Managing Performance: SQL Tuning
Using Database Resource Manager
Using Oracle Scheduler to Automate Tasks


The Cloud Edition Student Learning Subscriptions allow students to access a Cloud environment while working through their lessons and activities. Each of the new Student Learning Subscriptions includes all of the elements that students need to successfully complete their studies and get certified, including:

  • Digital learning (visually engaging self-paced training from Oracle experts)
  • Student eKit materials (easy reference and classroom reinforcement material)
  • Hands-on activity guides and quizzes (to reinforce learning)
  • Cloud Environments (to practice and master skills)
  • Industry recognized certification exams or assessments (guidance on how to become certified)

For more information, call 714-505-3475