Oracle

Conditions & Arrays

Overview/Description:

Java is a widely-used development language with powerful features. Explore basic decision constructs, arrays, and how to loop through arrays.

Course Number:

it_jljsee_03_enus

Connectivity & Space Management

Overview/Description:

Optimizing how data is stored in Oracle Database 12c conserves space and improves system performance. Explore tablespaces and data files, and learn how to manage the space used by data blocks and segments.

Course Number:

it_oddbre_04_enus

Java Certified Foundations Associate: Java Methods

Overview/Description:

Java is an object-oriented programming language that that uses classes to store data and provide methods to access and manipulate this data. In this course, you will learn how to create and use methods to manipulate the data inside a class.

First, you will learn about Java methods, accessor methods, and mutator methods and how they are used in Java classes. Next, you will learn about describe overloading in Java and when to use it should be used. Next, you will learn about interfaces and how they are used to specify the behavior that a Class must implement. Finally, you will learn about the static keyword and how it can be applied to a method in a Class.

This course is one of a collection of courses that prepares learners for Oracle’s 1Z0-811: Java Certified Foundations Associate certification.

Course Number:

it_sdjcfa_17_enus

Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)

Overview/Description:

Explore the introductory concepts of working with Oracle Database 12c, including relational database management concepts and terminologies and Oracle Live SQL.

Course Number:

it_dfosfd_01_enus

Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views 

Overview/Description:

Explore the basics of data dictionary views. Discover how to create views on tables. Synonyms, sequences, and indexes, and how to create them is also covered.

Course Number:

it_dfosfd_07_enus

Job Scheduling

Overview/Description:

Keep your database performing efficiently by increasing your knowledge of Oracle Database 12c performance tuning, including how to use the Oracle Scheduler to create and schedule jobs.

Course Number:

it_oddbre_14_enus

Auditing Features & Configuration

Overview/Description:

Monitoring database access is part of the process involved in securing an Oracle Database 12c system. Discover how to detect and resolve lock conflicts, and how to enable and manage auditing of database activity.

Course Number:

it_oddbre_07_enus

Deployment & Application Enhancement

Overview/Description:

Java is one of the most widely used development languages in the world. Discover how to deploy a Java application and how to enhance an application.

Course Number:

it_jljsee_13_enus

Working with Inheritance

Overview/Description:

Java is an extremely popular development language. Explore inheritance in Java classes, including superclasses, subclasses and abstract classes.

Course Number:

it_jljsee_10_enus

Introduction to Java

Overview/Description:

Java is one of the most widely-used development languages in the world today. Discover the key features of Java and object-oriented programming, defining classes, identifying class components, and using a main method.

Course Number:

it_jljsee_01_enus

Oracle Database 12c R2 SQL: Conversion Functions & Conditional Expressions

Overview/Description:

Frequently when retrieving data stored in an Oracle database, the data needs to be converted, manipulated, or aggregated. Discover Oracle conversion functions and conditional expressions.

Course Number:

it_dfosfd_04_enus

SQL Tuning

Overview/Description:

Proper monitoring and tuning of databases significantly improves system performance. Learn how to use SQL tuning, optimizer statistics, and the range of SQL advisors included in Oracle Database 12c.

Course Number:

it_oddbre_12_enus

Oracle Database 12c R2 SQL: Reporting Aggregated Data Using Group Functions   

Overview/Description:

Discover how to obtain summary information, such as averages, for groups of rows in SQL. Explore how to group rows in a table into smaller sets and how to specify search criteria for groups of rows.

Course Number:

it_dfosfd_13_enus

Undo Feature Overview

Overview/Description:

An Oracle Database 12c administrator will, at some point in time, need to roll back changes made to the database. Learn how this is done using the Undo feature in Oracle Database 12c.

Course Number:

it_oddbre_05_enus

Oracle Database 12c R2 SQL: Using Basic SELECT statements

Overview/Description:

Explore how to retrieve data using SQL SELECT statements including arithmetic expressions, NULL values, column aliases, and literal strings. You will also learn how to deal with duplicate rows.

Course Number:

it_dfosfd_03_enus

Connecting to & Configuring a Database Instance

Overview/Description:

One key aspect of administering Oracle Database 12c includes managing client connections to database servers. Discover how to manage Oracle Net Services and server configurations.

Course Number:

it_oddbre_03_enus

Importing & Exporting Data

Overview/Description:

An Oracle database administrator is responsible for ensuring data is secure and available. Explore working with Oracle data, including data migration, the Oracle Data Pump, SQL*Loader files, and external tables.

Course Number:

it_oddbre_09_enus

Java Certified Foundations Associate: Math & Random Classes

Overview/Description:

Mathematical operations are used to perform calculations of numeric data types and being able to generate random numbers is an important aspect of Computer Science. Java provides full functionality for mathematical operations and random number generation. In this course, you’ll learn to use the Java Math and Random number generator classes.

First, you’ll explore the various methods provided by the Java Math and the Java Random class. Next, you’ll learn about and review demonstrations of the use of the java.util.Random, the Java Math.random, and the Java ThreadLocalRandom classes.

This course is one of a collection of courses that prepares learners for Oracle’s 1Z0-811: Java Certified Foundations Associate certification.

Course Number:

it_sdjcfa_10_enus

Java Certified Foundations Associate: Java Arrays & ArrayLists

Overview/Description:

In Java, sometimes you have to iterate through and process a list of data. In this course, you will learn how Arrays and Arraylist are designed to handle looping through lists of data.

First, you will learn about Arrays and the ArrayList class. Next you will learn about the Iterator class and how it can be used to processes list of data. Finally, you will learn about special classes used to store and retrieve lists of data such as the LinkedList class, the HashMap class, and the HashSet class.

This course is one of a collection of courses that prepares learners for Oracle’s 1Z0-811: Java Certified Foundations Associate certification.

Course Number:

it_sdjcfa_14_enus

Java Certified Foundations Associate: Basic Elements

Overview/Description:

The Java programming language is a simple and powerful language to learn. In this course, you will learn Java programming basic and the Java programming style guide.
First, you will learn the basic elements of Java including keywords, comments, variables, identifiers, and data types. Next, you will learn the conventions that should be followed when writing Java programs regarding formatting, naming conventions, programming practices, and using Javadoc.
Next, you will use the “this” keyword in a Java application to help understand scope. Finally, you will learn about using Java packages including the java.lang package. This course is one of a collection of courses that prepares learners for Oracle’s 1Z0-811: Java Certified Foundations Associate certification.

Course Number:

it_sdjcfa_07_enus

Working with Interfaces

Overview/Description:

Java is one of the most widely used development languages in the world today. Discover how to use interfaces including the List interface and how to use Lambda expressions.

Course Number:

it_jljsee_11_enus

User Security Features & Configuration

Overview/Description:

Securing an Oracle Database 12c system involves controlling who can access the database and what they can do. Learn how to manage privileges, and use roles, profiles, quotas, and password security to make your databases secure.

Course Number:

it_oddbre_06_enus

Oracle Database 12c R2 SQL: Using Subqueries to Solve Queries 

Overview/Description:

Subqueries are very useful when you need to select rows from a table with a condition that depends on the data in the table itself. Explore the types, syntax, and guidelines for using subqueries in Oracle.

Course Number:

it_dfosfd_14_enus

Java Certified Foundations Associate: Data Types

Overview/Description:

Java provides different data types that can be used to store and work with different types of data. In this course, you’ll learn about these data types and how to perform actions on them.

First, you’ll learn about the various Java data types and their properties. Next, you’ll examine how to declare and initialize variables in Java and purpose of the final keyword. You’ll then move on to explore data type casting and the concepts of widening and narrowing casting. Finally, you’ll learn about the Java String data type and how it relates to the Java StringBuilder class.

This course is one of a collection of courses that prepares learners for Oracle’s 1Z0-811: Java Certified Foundations Associate certification.

Course Number:

it_sdjcfa_16_enus

Encapsulation & Overloaded Constructors

Overview/Description:

Java allows programmers to create objects that can interact with other objects to solve a problem. Discover how to apply access control levels to classes and methods, implement encapsulation of fields, and how to overload constructors.

Course Number:

it_jljsee_07_enus

Oracle Database Instance Overview

Overview/Description:

To work with Oracle database instances, you must understand the new multitenant architecture in Oracle Database 12c. Explore the memory, process, and storage architectures and how they work together.

Course Number:

it_oddbre_01_enus

Classes & Objects

Overview/Description:

Java, an object-oriented programming language, is one of the most widely used development languages in the world today. Discover how to work with classes and objects including array objects.

Course Number:

it_jljsee_04_enus

Resource Management

Overview/Description:

Ensure efficient database performance by taking advantage of tuning tools available in Oracle Database 12c. Discover how to manage resources to optimize performance, including working with Resource Manager and monitoring statistics.

Course Number:

it_oddbre_13_enus

Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output   

Overview/Description:

Database tables may hold a large number of rows, which are often not sorted in any specific order. Discover how to selectively return only a subset of table rows, sorted and customized.

Course Number:

it_dfosfd_12_enus

Database Maintenance

Overview/Description:

Oracle Database 12c includes many features that simplify routine database maintenance and performance tuning. Learn how to configure and use the automated database monitoring and maintenance features available in Oracle Database 12c.

Course Number:

it_oddbre_10_enus

Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language

Overview/Description:

Once an Oracle 12c relational database has been created with objects, the data in these objects needs to be managed. Discover how to insert, update, delete, and truncate rows.

Course Number:

it_dfosfd_02_enus

Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries

Overview/Description:

Discover how to use the DEFAULT keyword in INSERT and UPDATE statements. Multitable INSERT statements, the MERGE statement, performing flashback operations, and tracking changes are also covered.

Course Number:

it_dfosfd_17_enus

Backing Up & Recovering Data

Overview/Description:

A key responsibility of an Oracle database administrator is protecting databases from failure. Learn how to back up and recover databases, how to migrate and load data, and how to work with external tables in Oracle Database 12c.

Course Number:

it_oddbre_08_enus

Working with Exceptions

Overview/Description:

Java is one of the most widely used development languages in the world today. Explore exception handling including catching and throwing exceptions, and best practices for exception handling.

Course Number:

it_jljsee_12_enus

Oracle Database 12c R2 SQL: SQL*Plus

Overview/Description:

SQL*Plus is an interactive and batch query tool that is installed with every Oracle server and client installation. This course will teach you the features and functionality of SQL*Plus.

Course Number:

it_dfosfd_10_enus

Java Certified Foundations Associate: Java Strings

Overview/Description:

Strings are one of the most highly used data types in the Java programming language and working with strings efficiently is important for displaying and manipulating textual data. In this course, you’ll learn to work with the String class and about the benefits of using the StringBuffer and StringBuilder classes with the stack and heap memory.

You’ll explore how to manipulate textual data using String variables and work with the String class methods. Next, you’ll learn to use the more memory friendly StringBuffer and StringBuilder classes. Finally, you’ll examine how to use escaping characters and String formatting specifiers.

This course is one of a collection of courses that prepares learners for Oracle’s 1Z0-811: Java Certified Foundations Associate certification.

Course Number:

it_sdjcfa_09_enus

Oracle Database 12c R2 SQL: Data Definition Language (DDL)

Overview/Description:

Explore how to create a table and work with the various constraints associated with a table in Oracle Database 12c.

Course Number:

it_dfosfd_09_enus

Working with Variables

Overview/Description:

Java is an immensely popular development language whose capabilities range from small and nimble to large and powerful applications. Discover the uses of variables and variable syntax, and how to work with mathematical operators.

Course Number:

it_jljsee_02_enus

Performance Tuning

Overview/Description:

Performance tuning is an important aspect of Oracle Database 12c administration. Learn how to monitor and tune both database and memory performance in Oracle Database 12c.

Course Number:

it_oddbre_11_enus

Oracle Database 12c R2 SQL: Controlling User Access

Overview/Description:

Discover how to control database access to specific objects and add new users with different levels of access privileges.

Course Number:

it_dfosfd_16_enus

Oracle Database 12c R2 SQL: Creating Other Schema Objects

Overview/Description:

Explore the basics of creating and using sequences and views in Oracle Database 12c SQL.

Course Number:

it_dfosfd_15_enus

Oracle Database 12c R2 SQL: Restricting & Sorting Data

Overview/Description:

Database tables hold a large number of rows, which are often not sorted in any specific order. Learn how to selectively return only a subset of rows, sorted and customized.

Course Number:

it_dfosfd_11_enus

Operators & Conditionals

Overview/Description:

Java is an immensely popular object-oriented development language. Discover relational and conditional operators, how to configure complex if/else constructs, and use switch statements.

Course Number:

it_jljsee_08_enus

Java Certified Foundations Associate: Java Debugging & Exceptions

Overview/Description:

Sometimes the unexpected happens in your Java code and you will need to figure out what broke and how to fix it. In this course, you will learn how to handle exceptions and how to debug your Java code.

First, you will learn how to debug your code using the Java JDB tool as well as using IntelliJ. Next, you will learn the best practice for debugging Java code and some common syntax and logic errors that you may encounter and methods for fixing these errors. Finally, you will learn how to handle exceptions in your code using the try catch block statements.

This course is one of a collection of courses that prepares learners for Oracle’s 1Z0-811: Java Certified Foundations Associate certification.

Course Number:

it_sdjcfa_13_enus

Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables

Overview/Description:

Explore how to join tables together to view information across multiple tables and examine the more advanced features of the SELECT statements.

Course Number:

it_dfosfd_05_enus

Data Manipulation

Overview/Description:

Java is one of the most widely used development languages in the world today. Discover the NetBeans debugger, args array and the ArrayList class, and ArrayList classes.

Course Number:

it_jljsee_09_enus

Java Certified Foundations Associate: Decision Statements

Overview/Description:

One of the main components of modern programming languages is the ability to make decisions using the data provided to them. Java provides decision statements that can be used to make decisions and being able to make decisions is a fundamental part of the Java programming language.

In this course, you’ll learn about various types of Java decision statements. You’ll examine how to use the if-then-else and switch statements. Then, you’ll move on to learn about String comparisons, the comparison operator, the equals() method, and compareTo. You’ll also learn about the strengths and weaknesses of each comparison operator and the best time to use each.

This course is one of a collection of courses that prepares learners for Oracle’s 1Z0-811: Java Certified Foundations Associate certification.

Course Number:

it_sdjcfa_11_enus

Classes Data Types & Regular Expressions

Overview/Description:

Java allows programmers to create objects that can interact with other objects to solve a problem. Explore how to work with data in a Java program with classes such as String and StringBuilder.

Course Number:

it_jljsee_05_enus

Java Certified Foundations Associate: Object-oriented Programming

Overview/Description:

Object-oriented programming(OOP) is a programming method based on the concepts of ‘objects’ that contain properties and methods. Objects can inherit their structure from other classes and interfaces, which allows for code reuse. In this course, you’ll learn about the features of object-oriented programming.
First, you’ll learn about the basics of object-oriented programming and how it relates to Java, including the concepts of Java objects, classes, and interfaces. Next, you’ll examine OOP concepts such as inheritance, polymorphism, abstract classes, encapsulation, and inner classes.
This course is one of a collection of courses that prepares learners for Oracle’s 1Z0-811: Java Certified Foundations Associate certification.

Course Number:

it_sdjcfa_04_enus

Java Certified Foundations Associate: Coding Best Practices

Overview/Description:

Writing code that is easy to understand and maintain is crucial to the software development life cycle. Since Java is an object-oriented programming language, the code is already organized and grouped based on objects with properties and methods that are associated with each object. However, as a developer you still need to be cognizant of how you write your code.

In this course, you’ll learn how to distinguish between clean and messy code and the benefits writing clean code. You’ll also learn best practices for adding comments to your code and how to fix messy code. Finally, you’ll explore tools that can be used when writing and cleaning code.

This course is one of a collection of courses that prepares learners for Oracle’s 1Z0-811: Java Certified Foundations Associate certification.

Course Number:

it_sdjcfa_03_enus

Java Certified Foundations Associate: Java Concepts & Features

Overview/Description:

Java is a powerful object-oriented programming language that allows you to write code once and deploy it on multiple operating systems. In this course, you’ll learn about the Java programming language and related concepts, as well as how to work with the Java Development Kit and the Java Runtime Environment.

First, you’ll learn about the Java Virtual Machine and object-oriented programming concepts. Next, you’ll explore Java features, such as platform independence, security and robustness, architecture neutrality, portability, and performance. Finally, you’ll learn about Java distributed applications, multi-threading, dynamic loading, and real-world applications.

This course is one of a collection of courses that prepares learners for Oracle’s 1Z0-811: Java Certified Foundations Associate certification.

Course Number:

it_sdjcfa_01_enus

Oracle Database 12c R2 SQL: Managing Schema Objects    

Overview/Description:

Explore how to work with constraints and alter existing objects in Oracle Database 12c. Working with external tables and naming an index at time of creating a PRIMARY KEY constraint is also covered.

Course Number:

it_dfosfd_08_enus

Java Certified Foundations Associate: Development Basics

Overview/Description:

Java is a powerful object-oriented programming language that encapsulates data and code in classes using properties and methods. Java uses objects that can interact with other objects. In this course, you’ll learn about the components of a basic Java program such as classes, attributes, methods, and access modifiers.

First, you’ll examine the basics of Java development and the components of a basic program. Next, you’ll learn about Java features, such as constructors, classes, attributes, and methods. Finally, you’ll explore Java access modifiers and how to compile and run Java programs.

This course is one of a collection of courses that prepares learners for Oracle’s 1Z0-811: Java Certified Foundations Associate certification.

Course Number:

it_sdjcfa_06_enus

Java Certified Foundations Associate: Java Operators

Overview/Description:

Being able to perform mathematical, conditional, and relational operations is a key feature of the Java programming language. In this course, you’ll learn about the available mathematical, conditional, relational, bitwise, and unary operations.

First, you’ll explore the arithmetic and assignment operators available in Java and how to use them. Then, you’ll move on to learn about Java unary, equality, and relational operators. Next, you’ll examine Java conditional and bitwise operators. Finally, you’ll learn about the precedence of Java mathematical, conditional, relational, unary, and parentheses operators.

This course is one of a collection of courses that prepares learners for Oracle’s 1Z0-811: Java Certified Foundations Associate certification.

Course Number:

it_sdjcfa_08_enus

Java Certified Foundations Associate: Design Patterns

Overview/Description:

While developing software, being able to use repeatable solutions to commonly occurring problems greatly reduces development time. In this course, you will learn how design patterns can be used to provide repeatable solutions to the common design problems.

First, you will learn the importance of design patterns and discuss the types of design patterns such as Behavioral, Creational and Structural. Next, you will write code to demonstrate how to implement the Iterator, Singleton and Adapter design patterns. Finally, you will learn some advanced features of software development, including design anti-patterns, software refactoring techniques, API pattern principles, and API patterns.

This course is one of a collection of courses that prepares learners for Oracle’s 1Z0-811: Java Certified Foundations Associate certification.

Course Number:

it_sdjcfa_05_enus

Java Certified Foundations Associate: Looping Statements

Overview/Description:

One of the main tasks of computer applications if to process lists of data. Java lists of data can be processed using looping statements. In this course, you will learn the various methods for performing looping in Java programming language. First, you will learn about the various types of looping statements available in Java such as enhanced for loops, for loops, while loops, and do-while loops. Next, you will learn about the best practices to follow when performing looping. Finally, you will learn about the break and continue statement. Finally, you’ll learn how to apply all of these looping methods. This course is one of a collection of courses that prepares learners for Oracle’s 1Z0-811: Java Certified Foundations Associate certification.

Course Number:

it_sdjcfa_12_enus

Java Certified Foundations Associate: Classes & Constructors

Overview/Description:

Java is a powerful object-oriented programming language that encapsulates data and code in classes using properties and methods. Java uses objects that can interact with other objects. In this course, you’ll learn about the components of a basic Java program such as classes, attributes, methods, and variables.

First, you’ll learn about the concepts of Java access modifiers and Java class members. Next, you’ll examine the differences between a class, instance, and local variables and how they relate to Java. Next, you’ll learn about the concept of overloading and how it applies to the constructor and methods. Finally, you’ll explore how to create and instantiate a class with and without constructor parameters and modify the object fields.

This course is one of a collection of courses that prepares learners for Oracle’s 1Z0-811: Java Certified Foundations Associate certification.

Course Number:

it_sdjcfa_15_enus

Oracle Database 12c R2 SQL: Using the Set Operators  

Overview/Description:

Discover how to write SQL queries by using set operators.

Course Number:

it_dfosfd_06_enus

Managing a Database Instance

Overview/Description:

Discover how to get started with Oracle Database 12c, configure initialization parameters, start up a database instance, work with log files, and use the various database views.

Course Number:

it_oddbre_02_enus

Methods & Conditionals

Overview/Description:

Java, an object-oriented programming language, is one of the most widely used development languages in the world today. Discover how to work with methods, including method overloading.

Course Number:

it_jljsee_06_enus

Java Certified Foundations Associate: Development Environment

Overview/Description:

Java provides the right tools and features to allow you to be productive from the very start. In this Couse, you will learn about the features of the Java Development Kit and the Java Runtime Environment.

First, you will learn about the Java Development Toolkit and the Java Runtime Environment. Next, you will learn about the features of the JDK such as the Java Compiler, the Java Interpreter, the Java Disassembler, the Java Debugger, the Java Head File Generator, the Java Documentation and the Java Archive. Finally, you will learn how to install the JDK, FRE, and the IntelliJ for Java Developers.

This course is one of a collection of courses that prepares learners for Oracle’s 1Z0-811: Java Certified Foundations Associate certification.

Course Number:

it_sdjcfa_02_enus