Focus on Training courses

...Database Storage Structures Understanding Storage of Data Database Block contents Exploring the Storage Structure Creating a New Tablespace Overview... Learn about: Network Training, Database training...

...Structure Creating a New Tablespace Overview of Tablespaces Created by Default Managing Tablespaces Viewing Tablespace Information Using Oracle Managed... Learn about: Database training, Network Training...

...12cCreate reports of aggregated dataWrite SELECT statements that include queriesRetrieve row and column data from tablesRun data manipulation statements (DML)... Learn about: Database training...

...demonstrations help you learn how to use these new or enhanced features of Oracle Database 12c. You'll explore using Oracle Enterprise Manager Cloud Control... Learn about: Database training...

...control code flow (loops, control structures).Use PL/SQL packages to group and contain related constructs.Create triggers to solve business challenges... Learn about: Database training...

...This Oracle Database 12c: RAC Administration training will teach you about Oracle RAC database architecture. Expert Oracle University instructors... Learn about: Quality Training, Database training...

...the aggregation functions in SELECT statements to produce meaningful reports Describe the AVG, SUM, MIN, and MAX function How to handle Null Values in a group function?... Learn about: Database training...

...Benefits to You: Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality... Learn about: Database training...

...Functions Creating and Executing and Removing Functions Identifying the Advantages of Using Stored Functions in SQL Statements Using User-Defined Functions... Learn about: Database training, Application Development...

...PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.Benefits to YouEnsure... Learn about: Database training...

...the use of SQL functions, SQL*Plus parameters and the basic table and view handling statements are introduced. The course also provides practical experience... Learn about: Database training...

...Developer Declaring and using variables and constants Assigning and manipulating values Using SQL statements within PL/SQL Implementing conditional execution... Learn about: Database training...

...integration roadmap strategy and lower its total cost of ownership. Oracle JDeveloper 11g Integrated Development Environment With the Oracle JDeveloper...

...SOA simplifies integration with external trading partners and with cloud-based and mobile applications Service-Oriented Architecture Concepts What is...

...Auditing Managing Processes and Priorities Managing System Processes Managing Process Scheduling Priority Managing the Scheduling Class of a Zone Monitoring... Learn about: Network Training...

...Indexes Dropping Indexes Listing Indexes Creating and Using Views Dropping Views Listing Views Session 15: MANAGING SEQUENCES AND SYNONYMS Create a Sequence... Learn about: Database training...

...ALL or SOME Operators Correlated Subqueries In-Line Views The Exists Operator The WITH Clause Multi-Column Subqueries Insert and Update Using a Query Correlated...

...standard aggregate functions and related SELECT statement clausesImplementing extended SQL functionsJoining TablesUsing subqueriesCreating and altering tables and viewsInserting... Learn about: Database training...

...Workflow Converting Content and Publishing Working Online or Offline Development Considerations Assigning Development Tasks and Flow Creating Scripts Efficient...

...an Alternative Actions / Paths Insert an Alternative Path Change the End Frame of an Alternative Path Set the Current Action as the Default Action Delete...