Focus on Training courses

...for a Standalone ServerCreate a container databaseCreate an Oracle DatabaseInstall Oracle Database 12c softwareMonitor the DatabaseManage Database PerformanceImplement... Learn about: Database training, Network Training...

...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... Learn about: Network Training, Database training...

...multiple queries into a single query Control the order of rows returned Data Manipulation Statements Describe each DML statement Insert rows into a table... Learn about: Database training...

...DATABASE Change PDB state Managing Tablespaces, Common and Local Users, Privileges and Roles Create permanent tablespaces in the root and PDBs Manage common... Learn about: Database training...

...and Remove Stored Procedures Implement Procedures Parameters and Parameters Modes View Procedure Information Stored Functions and Debugging Subprograms Create... Learn about: Database training...

...Upgrades Planning and Preparing for Upgrade Performing Out of Place Release Install or Upgrade Post Upgrade Tasks Application Continuity What is... Learn about: Quality Training, Database training...

...implicit and explicit data type conversion Describe the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions Nesting multiple functions Apply the... Learn about: Database training...

...Data Dictionary Views Querying the Data Dictionary Views Creating Sequences, Synonyms, Indexes Overview of sequences Overview of synonyms Overview of indexes... Learn about: Database training...

...you will be able to: Create, use, and debug stored procedures and functionsDesign and use PL/SQL packages to group and contain related constructsCreate... Learn about: Database training, Application Development...

...PL/SQL Flow of Execution Conditional processing Using IF and CASE Statements Handle Nulls to Avoid Common Mistakes Build Boolean Conditions with Logical... Learn about: Database training...

...programs from SQL*Plus or SQL Developer Declaring and using variables and constants Assigning and manipulating values Using SQL statements within PL/SQL... 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...

...You'll use a Service-Oriented Architecture (SOA) implementation approach. Learn To: Create a SOA Composite application using JDeveloper.Initiate SOA composite...

...in Oracle SOA Suite 12cExplain the context of using each core service component, and business challenges they addressDescribe the make-up of a SOA composite...

...The Oracle Solaris 11 Advanced System Administration course provides an intensive hands-on experience, working with complex and integrated administration concepts... Learn about: Network Training...

...The delegates will practise: Creating SQL statements to query database tablesUsing standard aggregate functions and related SELECT statement clausesJoining... Learn about: Database training...

...extension Using the GROUPING and GROUPING_ID functions Session 4: MANAGE LARGE DATA SETS Multi-table Inserts Conditional and Unconditional Inserts Merging...

...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...

...Glossary Terms Create a Glossary Assign a Glossary to a Document Select a Glossary Definition Link Update Glossary Link Edit/Delete a Glossary Understand Know...