• United Kingdom
  • England
  • +44 (0)208 089 0990
  • england@nobleprog.co.uk
  • Enquire

Choose Sales Area

Home
  • Training Courses
    • Special Offers
    • Course Catalogue
    • Training FAQ
    • Funding Options
    • New OMG Certifications
    • Terms and Conditions
    • Remote Courses (Instructor-led)
    • Bootcamps
  • Bootcamps
    • Data Science
    • Cyber Security
  • Career
    • Franchise
    • Freelance Trainer / Consultant
    • Full-time Employment
  • About Us
    • About Us
    • Privacy Statement
    • Clients
    • Testimonials
    • e-Certificate
    • Jobs and Career
  • Contact Us

Enquiry Form

  1. Database Training
  2. Oracle Training Courses

Oracle Training Courses

Oracle Training

Local, instructor-led live Oracle Database (Oracle RDBMS or Oracle) training courses demonstrate through discussion and hands-on practice the fundamentals of Oracle. Oracle training is available as "onsite live training" or "remote live training". Onsite live training can be carried out locally on customer premises in the UK or in NobleProg corporate training centers in the UK. Remote live training is carried out by way of an interactive, remote desktop. NobleProg -- Your Local Training Provider

Client Testimonials

★★★★★
★★★★★

Great teacher with in depth knowledge and real life, relevant examples. Engaging and always ensures a section is understood before moving on to next.  

Sade Okiji

Course: SQL Programming

Good  

Zan Sue - Net Media Planet

Course: SQL Programming

The course content was adapted well to suit my current knowledge and capabilities. Specific topics I requested were covered well.  

Steven Sirman - Corus Group

Course: SQL Programming

The trainer is a great trainer and has very professional tone. I would definitely like to attend a SQL Advanced course in the near future which is hosted by the same trainer.  

Mitul. P. Parmar - Cancer Research UK

Course: SQL Programming

Having a 1-1 training course was very effective, it meant I was less intimidated as I could stop the trainer to ask questions where I may otherwise have been reluctant to ask. The trainer was very good at explaining everything that I needed to know and took the time to make sure going back where needed to re explain when I got stuck.The training was very clear and concise and tailored very well to my own individual needs.The training has covered all the points it needed too. — Robert Craft  

m>Zurich Employment Services Limited

Course: SQL Programming

This course was truly fantastic, spot-on! It covers the basics but also details of SQL language. I will definitely recommended this course to my colleagues. There simply isn't another course out there that would give you so much in such a short period of time, great value for money. A must for any beginner or intermediate SQL user!  

Piotr Olczak Planing Officer - Brunel University

Course: SQL Programming

I really can't praise this course and the trainers highly enough! They were both extremely well qualified and made the subject interesting. The pace of the course was excellent and I've come away feeling very satisfied with the skills I've learned.  

Susan Elder - Merrill Lynch

Course: SQL Programming

The trainer was extremely knowledgeable and ensured that I properly understand at every steps. I am very happy with the course. 

Takuya Yorita - Mizuho Corporate Bank Ltd

Course: SQL Fundamentals

Having a 1-1 training course was very effective, it meant I was less intimidated as I could stop the trainer to ask questions where I may otherwise have been reluctant to ask. 

Robert Craft - Zurich Employment Services Limited

Course: SQL Programming

I really can't praise this course and the trainers highly enough! They were both extreemly well qualified and made the subject interesting. The pace of the course was excellent and I've come away feeling very satisfied with the skills I've learned. 

Susan Elder - Merrill Lynch

Course: SQL Programming

Great teacher with in depth knowledge and real life, relevant examples. Engaging and always ensures a section is understood before moving on to next. 

Sade Okiji

Course: SQL Programming

Good

Zan Sue - Net Media Planet

Course: SQL Programming

The course content was adapted well to suit my current knowledge and capabilities. Specific topics I requested were covered well. 

Steven Sirman - Corus Group

Course: SQL Programming

The trainer is a great trainer and has very professional tone. I would definitely like to attend a SQL Advanced course in the near future which is hosted by the same trainer. 

Mitul. P. Parmar - Cancer Research UK

Course: SQL Programming

The format was really good, the exercises were not too difficult and helped us to fully understand the tool.

Juan Salvador Rios Hoyos- Oracle

Course: Oracle Application Express Introduction

The trainer was enthusiastic & would answer whatever we needed.

Erica May - Big Fish Games, Inc

Course: SQL Fundamentals

The course I loved that it was just Andrew (the trainer) & my team. It was very personalized. Thanks for flying cross-country for us!

Bronwyn Bailey - PEGCC

Course: SQL Fundamentals

Trainer was great--nothing to improve. The way that Andrew (the trainer) customized to first day of training to the level of our group.

Josh Cox - PEGCC

Course: SQL Fundamentals

What did you like the most about the training?: Catering :D and informal athmosphere in class. Teacher was really helpful when I had questions. Andrei Falileev - Citibank International Limited

Course: Oracle SQL for beginners

What did you like the most about the training?: Focused on important stuff, helpfull with exersises. Kamil Jarosz - Citibank International Limited

Course: Oracle SQL for beginners

What did you like the most about the training?: It was really practical, I found it really usefule. The trainer use our feedback and provide a really good personalize training. Diego Moreno Galan - Credit Suisse (Poland) Sp. z o.o.

Course: ORACLE SQL Fundamentals

Training exceeded my expectations. Trainer provided additional topics / excercises since we have finished the programme ahead of time.

Artur Czeczil - Credit Suisse (Poland) Sp. z o.o.

Course: ORACLE SQL Fundamentals

What did you like the most about the training?: Phil catered for all our needs and even though we had a manual to work through he did not stick to it but was willing to explain our questions about how things can be used in our work and had a lot of patience explaining stuff to us. Lorett Bredenkamp - Save the Children

Course: Oracle SQL Intermediate - Data Extraction

What did you like the most about the training?: Everything was completely understandable. Joanna Staniszewska - Citibank International Limited

Course: Oracle SQL for beginners

What did you like the most about the training?: The trainer, he was knowledgeable, engaging, and easy to learn from. he encouraged a lot of hands on learning. Shawn McAndrew - Halifax Regional Municipality

Course: SQL Fundamentals

What did you like the most about the training?: That it was well organized. Topic was divided into parts and for every part there were exercises, I wasn't lost at all. Monika Klimczak - LUXOFT POLAND SP z. o. o.

Course: SQL Fundamentals

very high competence of the trainer!!

Heino Eilers

Course: Oracle 11g - Programming with PL / SQL I - Workshops

Trainer provided some topic and support it with plenty of exercises. We had a chance to apply knowledge by doing them on our own.

UBS Business Solutions Poland Sp. z o.o.

Course: Oracle SQL Intermediate

Access to trainers individual support in resolving exercises.

Tomasz Czornak

Course: Oracle SQL Intermediate

good atmosphere during the training

clovis Nebouet

Course: Oracle 11g - SQL language for developers - Workshop

The trainer, he was knowledgeable, engaging, and easy to learn from. he encouraged a lot of hands on learning

Shawn McAndrew

Course: SQL Fundamentals

I like fact, that after each section we had excercises. It helps to remember discused topic.

Adam Bińczycki

Course: Oracle 11g - SQL language for developers - Workshop

I learned a LOOOOOT

Kamil Szmid

Course: SQL Fundamentals

SQL ;)

MAGDALENA KOPCZYŃSKA

Course: Oracle SQL dla początkujących

All

Cardiff Council - Flying Start

Course: Oracle SQL for Beginners - Data Extraction

A lot of practical examples.

Paweł Miązek

Course: Oracle 11g - Język SQL dla programistów - warsztaty

Translated by Google Translated

Duzo praktycznych przykladów.

practical

Andrzej Kozak

Course: Oracle SQL dla początkujących

Translated by Google Translated

zajecia praktyczne

Knowledge of the trainer ok. After improving the improvement, I would choose the trainer again.

Michał Komarnicki

Course: ORACLE SQL Fundamentals

Translated by Google Translated

Wiedza szkolącego ok. Po poprawie tego co do udoskonalenia wybrałbym szkolącego jeszcze raz.

sql works even if I do not know why

Dominik Gardo

Course: SQL Fundamentals

Translated by Google Translated

sql działa nawet jak nie wiem dlaczego

Number of exercises

Honorata Kaniecka

Course: Oracle 12c – wprowadzenie do języka SQL

Translated by Google Translated

Ilość ćwiczeń

A wide knowledge of the trainer and commitment, the ability to be interested in the topic.

Michał Komarnicki

Course: Oracle 11g - Programowanie w PL/SQL - wprowadzenie

Translated by Google Translated

Szeroka wiedza trenera i zaangażowanie, umiejętność zaciekawienia tematem.

individual approach of the trainer to people participating in the training

Wojciech Gądzikiewicz

Course: SQL Fundamentals

Translated by Google Translated

indywidualne podejście trenera do osób uczestniczących w szkoleniu

exercises (tasks) to be carried out, examples from the professional experience of the trainer

Tomasz Niewiadomski

Course: Oracle 11g - Programowanie w PL/SQL I - warsztaty

Translated by Google Translated

ćwiczenia (zadania) do wykonania, przykłady z doświadczenia zawodowego Trenera

Showing how well-known mechanisms are performed on the database side, e.g. they are processed in memory

Marcin Czerwiec

Course: Oracle 11g - Programowanie w PL/SQL I - warsztaty

Translated by Google Translated

Pokazanie jak dokładnie poznawane mechanizmy są wykonywane po stronie bazy danych, np. są przetwarzane w pamięci

The training was perfectly prepared, I liked the way of running based on real-time examples with a detailed discussion of the impact of individual instructions on the database.

Joanna Dymarczyk

Course: Oracle 11g - Programowanie w PL/SQL I - warsztaty

Translated by Google Translated

Szkolenie było przygotowane perfekcyjnie, najbardziej podobał mi się sposób prowadzenia oparty przykładach pisanych w czasie rzeczywistym z dokładnym omówieniem jaki wpływ na bazę danych mają poszczególne instrukcje.

a lot of exercise

Łukasz Dziewiński

Course: Oracle SQL dla początkujących

Translated by Google Translated

duża ilość ćwiczeń

knowledge he gave us and the way he did it

Ewa Koncewicz

Course: Szkolenie dla rekruterów IT - programowanie i bazy danych

Translated by Google Translated

wiedza jaka nam przekazal i sposob w jaki to zrobil

Exhaustive answers from the lecturer

Team Connect Sp. z o.o.

Course: Szkolenie dla rekruterów IT - programowanie i bazy danych

Translated by Google Translated

Wyczerpujące odpowiedzi prowadzącego

A concrete and detailed approach to issues. Translation on specific examples.

Piotr Małek

Course: Szkolenie dla rekruterów IT - programowanie i bazy danych

Translated by Google Translated

Konkretne i szczegółowe podejście do zagadnień. Tłumaczenie na konkretnych przykładach.

Substantive knowledge, answers to questions that go beyond the training program, transferring knowledge in an understandable, transparent way.

Angelika

Course: Szkolenie dla rekruterów IT - programowanie i bazy danych

Translated by Google Translated

Merytoryczna wiedza, odpowiedzi na pytania wykraczające poza program szkolenia, przekazywanie wiedzy w sposób zrozumiały, przejrzysty.

Knowledge and professionalism of the trainer The trainer adjusted the training material to the needs of the participant

Dagmara Bruffaerts

Course: Oracle 11g - Analiza danych - warsztaty

Translated by Google Translated

Wiedza oraz profesjonalnosc trenera Trener dostosowal material szkolenia do potrzeb uczestnika

tempo of classes, flexibility as to the content of the training related to the expectations of users

Karol

Course: SQL Fundamentals

Translated by Google Translated

tempo zajęć, elastyczność co do treści szkolenia związana z oczekiwaniami użytkowników

Pace, explanation of issues from a completely different angle. Something that explains how everything works from the server side

P4 Sp. z o.o.

Course: SQL Fundamentals

Translated by Google Translated

Tempo, wyjaśnienie zagadnień z zupełnie innej strony. Coś co bardzo wyjaśnia jak wszystko działa od strony serwera

number of issues covered

P4 Sp. z o.o.

Course: SQL Fundamentals

Translated by Google Translated

ilość poruszonych zagadnień

adaptation to the needs of the participants, very good exploration of the discussed tasks, comprehensive answers to the asked question

Marcin Gołdyn

Course: SQL Fundamentals

Translated by Google Translated

dostosowanie do potrzeb uczestników, bardzo dobre zgłębienie omawianych zadań, wyczerpujące odpowiedzi na każe zadane pytanie

Work on a physical database.

P4 Sp. z o.o.

Course: SQL Fundamentals

Translated by Google Translated

Praca na fizycznej bazie danych.

adapting to the needs of the listeners, analyzing the problems they report

P4 Sp. z o.o.

Course: SQL Fundamentals

Translated by Google Translated

dostosowywanie się do potrzeb słuchaczy, analizowanie problemów przez nich zgłaszanych

Exercises on functions!

WIktor Paprzycki

Course: SQL Advanced level for Analysts

Translated by Google Translated

Ćwiczenia na funkcjach!

way of translation

Małgorzata Mieczkowska

Course: SQL Advanced level for Analysts

Translated by Google Translated

sposób tłumaczenia

exercises

Wiktor Paprzycki

Course: SQL Advanced level for Analysts

Translated by Google Translated

Ćwiczenia

examples, openness of the trainer

INTERNATIONAL PAPER POLSKA

Course: Język SQL w bazie danych Oracle

Translated by Google Translated

przyklady, otwartosc trenera

flexibility

dawid bodo

Course: Język SQL w bazie danych Oracle

Translated by Google Translated

elastyczność

exercises

Mateusz Wilk

Course: Oracle SQL dla początkujących

Translated by Google Translated

ćwiczenia

matching the trainer with topics that we wanted to develop a bit

Miasto Poznań - Wydział Organizacyjny

Course: Build applications with Oracle Application Express (APEX)

Translated by Google Translated

dopasowanie trenera pod tematy które chcieliśmy nieco rozwinąć

practical training, flexibility of the trainer, that is, he passed knowledge in a field that interested listeners

Miasto Poznań - Wydział Organizacyjny

Course: Build applications with Oracle Application Express (APEX)

Translated by Google Translated

ćwieczenia praktyczne, elastyczność trenera tzn. przekazywał wiedzę z zakresu, który interesował słuchaczy

A huge trainer experience

Crédit Suisse (Poland) Sp. z o.o.

Course: Oracle 11g - Strojenie Aplikacji - warsztaty

Translated by Google Translated

Ogromne doświadczenie trenera.

I got to know a lot of new SQL language functions about which I had no idea yet

ING Bank Śląski S.A.

Course: Oracle 12c – zaawansowany SQL

Translated by Google Translated

poznałem dużo nowych funkcji jezyka SQL o których nie miałem do tej pory pojęcia

Dynamic adjustment of the training content to the participants' needs

Justyna Waksmańska - Meller - ING Bank Śląski S.A.

Course: Oracle 12c – zaawansowany SQL

Translated by Google Translated

Dynamiczne dopasowanie treści szkolenia do potrzeb uczestników

matching to the group and their needs

ING Bank Śląski S.A.

Course: Oracle 12c – zaawansowany SQL

Translated by Google Translated

dopasowanie do grupy i ich potrzeb

exercise.

Marzena Marciniak - Bakoma Sp. z o. o.

Course: Oracle SQL dla początkujących

Translated by Google Translated

ćwiczenia

Exercises :).

Monika Lewalska - Bakoma Sp. z o. o.

Course: Oracle SQL dla początkujących

Translated by Google Translated

Ćwiczenia :)

Substantive and very easy transfer of information.

Piotr Polański - Bakoma Sp. z o. o.

Course: Oracle SQL dla początkujących

Translated by Google Translated

Merytoryczne i bardzo przystępnie przekazywanie informacji

Nice atmosphere, a large number of examples very well explained. Training materials for every part. The coach is very helpful in repairing mistakes during the exercises. I recommend everyone who wants to get and broaden their knowledge in SQL ...

Sebastian Straczyński - Stowarzyszenie Niżańskie Centrum Rozwoju

Course: Oracle SQL - poziom średniozaawansowany

Translated by Google Translated

Miła atmosfera, duża liczba przykładów bardzo dobrze wytłumaczonych. Materiały szkoleniowe do każdej części. Trener bardzo pomocny w naprawie popełnianych błędów podczas ćwiczeń. Polecam wszystkim osobą chcącym zdobyć i poszerzyć swoja wiedzę w SQL.

way of conducting and the knowledge of the trainer and the method of its transfer.

Grzegorz Cimochowski - Zakłady Produkcyjno-Usługowe "PRAWDA" sp. z o.o.

Course: Oracle SQL dla początkujących

Translated by Google Translated

sposób prowadzenia oraz wiedza trenera i sposób jej przekazywania

Exercises :).

Katarzyna Gędziorowska - Bakoma Sp. z o. o.

Course: Oracle SQL dla początkujących

Translated by Google Translated

Ćwiczenia :)

Loose relationships, answering every question, dreaming of incomprehensible issues.

Bakoma Sp. z o. o.

Course: Oracle SQL dla początkujących

Translated by Google Translated

Luźne relacje, udzielanie odpowiedzi na każde pytanie, wyśnienie zagadnień niezrozumiałych

I have no comments.

Bakoma Sp. z o. o.

Course: Oracle SQL dla początkujących

Translated by Google Translated

nie mam uwag
Previous Next

Subcategories

Berkeley DB Berkeley DB Training

Course Outlines

CodeNameDurationOverview
sqlfunSQL Fundamentals14 hours

This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:

  • how to write SQL queries
  • what relational databases are and how we can use them
  • what are relations and how to create them
  • the structure of data
  • differences between SQL dialects (Oracle, T-SQL, ANSI)
  • practical skills for writing queries

This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases.
oplsqlfunORACLE PL/SQL Fundamentals21 hours

This 3 day course gives an introduction to ORACLE PL/SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/SQL commands.

The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements.

Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.
osqlfunORACLE SQL Fundamentals21 hours

This 3 day course gives an introduction to SQL Developer, SQL*Plus and to SQL, the Structured Query Language used to access a Relational Database and includes the new features of the latest version of ORACLE. The principles learnt may also be applied to databases as diverse as Microsoft SQL Server, MySQL, Access, Informix and DB2.

The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements.

Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.
oracleperftunOracle Database 11g: Performance Tuning28 hours

Oracle is a multi-model database management system.
378Oracle Service Bus 11g - Design and Integration21 hours

This course is targeted to SOA architects and developers. It consists of theory classes and hands-on sessions on each of the topics to cover all essential features of Oracle Service Bus 11g.

This course will be delivered by industry experts with vast knowledge of Oracle SOA Suite, Web services, ESB, XML, SOA and related topics for example Java/J2EE.
3134Oracle Application Express Introduction21 hours

Audience

Course aimed at developers

Format of the course

35% lectures, 65% labs
osqlintOracle SQL Intermediate14 hours

Audience

All who want to improve their basic skills in Oracle SQL and also systematize already gained knowledge.

Format of the course

25% lectures, 75% labs
osqlideOracle SQL Intermediate - Data Extraction14 hours

The objective of the course is to enable participants to gain a mastery of how to work with the SQL language in Oracle database for data extraction at intermediate level.
osqldevdmOracle SQL for development and database management35 hours

This 5-day course demonstrates how to use Oracle SQL for database development and database management.
berkeleydbBerkeley DB for Developers21 hours

Berkeley DB (BDB) is a software library intended to provide a high-performance embedded database for key/value data. Berkeley DB is written in C with API bindings for C++, C#, Java, Perl, PHP, Python, Ruby, Smalltalk, Tcl, and many other programming languages. Berkeley DB is not a relational database.

This course will introduce the architecture and capabilities of Berkeley DB and walk participants through the development of their own sample application using Berkeley DB.

Audience

  • Application developers
  • Software engineers
  • Technical consultants

Format of the course

  • Part lecture, part discussion, hands-on development and implementation, tests to gauge understanding
osqlbgnOracle SQL for beginners21 hours

Listeners

This training is addressed for people starting to work with the SQL language in Oracle database

The course answer for questions:

  • How to build a query?
  • What possibilities have SQL?
  • What is a relational database?
  • What is the structure and SQL commands
osqlbgndeOracle SQL for Beginners - Data Extraction14 hours

Audience

This training is addressed for people starting to work with the SQL language in Oracle database

The course answer for questions:

  • How to build a query?
  • What possibilities have SQL?
  • What is a relational database?
  • What is the structure and SQL commands

This course DOES NOT COVER inserting, modifying or removing rows, it coveres only data extraction.
osqladvOracle SQL Advanced14 hours

Listeners

This course is designed for people who want to use the advanced features of SQL in Oracle

The course answers the questions

  • How to build advanced queries?
  • How to create advanced reports?
3057Oracle SQL Language14 hours

The course answers questions

How to build a query?

What possibilities have SQL?

What is a relational database?

What is the structure and SQL commands
3308Oracle 11g - SQL language for administrators - workshops21 hours

For who

The workshop is intended for beginners, starting to work with the Oracle database, future administrators and users of systems based on this database need able to use the SQL language for the extraction and modification of the information contained in the systems.

Exams and Certificates

The training plan coincides with the material required to pass the exam: 1Z0-051 Oracle Database 11g: SQL Fundamentals I, the first step to getting most certifications Oracle's Database

Purpose of training

The workshop aims to introduce participants to work with the Oracle database, making them familiar with the SQL language to the extent required for the efficient operation of the system and to take in the future obligations of database applications and Oracle databases.

The content of the training

  • The organization of the working environment
  • Introduction to relational databases
  • Extraction of the data using the SELECT statement
  • Modifying data using INSERT, UPDATE, DELETE
  • Overview of schema objects

Remarks

The workshops are based on 11g XE software
3319Data Analysis with Oracle 11g - workshop35 hours

For who

Workshops are dedicated to end users, data analysts and software testers. Workshop participants do not need to be computer scientists, but employees who need efficiently and effectively use the Oracle database, processing and analyzing information contained in it

Exams and Certificates

The training plan includes, among others material required to pass the exam: 1Z0-051 Oracle Database 11g: SQL Fundamentals I, the first step to getting most certifications Oracle's Database

Purpose of training

The training is designed to familiarize participants with the Oracle database, the basic tools and techniques of data collection. Particular emphasis in this training is the acquisition of substantially correct and reliable data.

The content of the training

  • The organization of the working environment
  • Introduction to the relational model of data storage
  • Techniques for the collection, analysis and synthesis of information stored in the database
  • Modify the information stored in the database

Note

The workshops are based on the software version 11g XE
3331Oracle 11g - Advanced data analysis - workshops35 hours

For who

These workshops are a continuation and complement the training of Oracle 11g data-analysis - a workshop dedicated to end users, data analysts and software testers for execution of professional duties which require more advanced techniques for working with the database. As in the case of the training of Oracle 11g data-analysis - workshops, participants do not need to be computer scientists, but the people who need efficient, and above all efficiently use the Oracle database, processing and analyzing stored in the large amounts of data

Purpose of training

The workshop aims to broaden the knowledge of participants about programming using PL / SQL and issues related to the optimization commands. Particular emphasis in this training is the performance of the data collection to ensure a smooth operation for very large amounts of data. In addition, workshops supplement an understanding of the elements necessary to any advanced user of Oracle in their daily work, such as copying and downloading large amounts of information, data modeling, modification of an existing data model and reverse engineering techniques using Oracle tools.

The content of the training

  • Moving and loading
  • Procedural language PL / SQL allows you to expand the analytical capabilities of a SELECT statement
  • Improving the performance of SQL queries
  • Data modeling and acquisition and modification of the existing data model based on Oracle SQL Modeler

Notes

The workshops are based on the software version 11g XE
3358Oracle 11g - SQL language for developers - Workshop35 hours

For who

Workshops are dedicated as a first step for developers and designers of applications based on Oracle databases. Participants do not need to have any prior knowledge of the Oracle database, or other relational database systems, even though such knowledge may be useful.

Exams and Certificates

The plan covers the training material required to pass the exam 1Z0-047 Oracle Database SQL Expert and obtain the title of Oracle Database SQL Certified Expert

Purpose of training

The workshop aims to familiarize participants with the Oracle database techniques to build database structures and data manipulation. Particular emphasis is placed on the participant to see across the board, which offers opportunities to design and build applications Relational Database Management System, Oracle Database, and to be able to independently work with her.

The content of the training

  • Introduction to database technology and the organization of the work environment
  • Acquisition and modification of data
  • Construction of the repository application
  • Safety and concurrency runtime

Notes

The workshops are based on the software version 11g XE
3410Oracle 11g - Programming with PL / SQL I - Workshops28 hours

For who

Workshops are dedicated to developers, end users and administrators, who until now have had no contact with the language PL / SQL, and the need to exploit its huge potential in working with a database, automate processes, and in building applications

Exams and Certificates

The plan covers the training material required to pass the exam 1Z0-144 Oracle Database 11g Program with PL / SQL and obtain the title of Oracle PL / SQL Developer Certified Associate

Purpose of training

The workshop aims to familiarize participants with the programming language PL / SQL, its capabilities and limitations. This workshop will include a full understanding of the mechanisms involved in the programming language PL / SQL needed to implement the logic of the free applications, automation of data processing and database management.

The content of the training

  • Introduction to PL / SQL architecture solutions based on this language, the organization of the working environment
  • Create scripts and stored program units that operate on data

Notes

The workshops are based on the software version 11g XE
3419Oracle 11g - Programming with PL / SQL II21 hours

For who

This training is in addition to, and continuation of the 'Oracle 11g - Programming in PL / SQL and - workshops ", but can also be designed for practitioners, developers, PL / SQL who already have experience with the language, and who want to systematize their knowledge and learn advanced mechanisms and solutions developed in this language.

The content of the training

  • Objects, streams and complex data structures
  • Advanced solutions based on PL / SQL

Exams and Certificates

The plan covers the training material required to pass the exam 1Z0-146 Oracle Advanced PL / SQL and obtain the title of Oracle Advanced PL / SQL Developer Certified Professional

Purpose of training

The training is designed to familiarize participants with the advanced aspects of programming in an Oracle database. The emphasis is on flexibility and performance solutions based on PL / SQL.

Notes

The workshops are based on the software version 11g XE
3457Oracle 11g - Application Tuning - Workshop28 hours

For who

The workshop is intended for advanced programmers and Oracle users who seek knowledge and information on the efficient development of information systems in an Oracle database, and the tuning and testing of performance issues in existing applications. This course builds on knowledge often unavailable or incorrectly presented in the technical documentation, and collected during many years of practice leading them instructors. These workshops may be the end of the training path for developers, or a single step for people with extensive experience designing and programming in Oracle

Purpose of training

The workshop aims to provide mechanisms that occur in an Oracle database when performing SQL statements. Allows participants to avoid errors during software development, and explore, diagnose, and resolve performance problems in existing applications.

Particular emphasis is placed on the workshops, where we show the methodology and the practical aspects of the application and tuning SQL statements.

The content of the training

  • Mechanics perform SQL commands
  • Managing the process cost optimization
  • Methods of data storage and indexing
  • Monitoring database performance and processes based on dictionaries and track system applications
  • Analysis of cases of the most common problems that cause performance

Notes

The workshops are based on the software version 11g XE

Upcoming Courses

CourseCourse DateCourse Price [Remote / Classroom]
Oracle Application Express Introduction - PortsmouthMon, 2018-08-06 09:30N/A / £3750
Data Analysis with Oracle 11g - workshop - Edinburgh Training and Conference VenueMon, 2018-08-06 09:30£5500 / £6500
Oracle SQL Language - St Helier, Jersey, Channel IslesTue, 2018-08-07 09:30£2200 / £3150
Oracle 11g - Programming with PL / SQL I - Workshops - SouthamptonMon, 2018-08-13 09:30£4400 / £5400

Other regions

AberdeenBathBelfast CityBirminghamBradfordBrightonBristolCambridgeCardiffCoventryEdinburghExeterGlasgowIsle of ManJersey, CILeedsLeicesterLiverpoolLondonManchesterNewcastleOxfordPlymouthPortsmouthReadingSheffieldSouthamptonSwanseaSwindonYork

Other countries

These courses are also available in other countries ››

Consulting

Oracle Consulting
Weekend Oracle courses, Evening Oracle training, Oracle boot camp, Oracle instructor-led, Weekend Oracle training, Evening Oracle courses, Oracle coaching, Oracle instructor, Oracle trainer, Oracle training courses, Oracle classes, Oracle on-site, Oracle private courses, Oracle one on one training

Course Discounts

Course Venue Course Date Course Price [Remote / Classroom]
OCUP2 UML 2.5 Certification - Advanced Exam Preparation St Helier, Jersey, Channel Isles Mon, 2018-07-23 09:30 £1980 / £2930
Introduction to R Glasgow Wed, 2018-08-01 09:30 £3861 / £4911
Subversion for Users Newcastle Fri, 2018-08-03 09:30 £1089 / £1289
OCUP2 UML 2.5 Certification - Intermediate Exam Preparation St Helier, Jersey, Channel Isles Tue, 2018-08-07 09:30 £2340 / £3290
jQuery Swansea- Princess House Wed, 2018-08-15 09:30 £1980 / £2280
AWS: A Hands-on Introduction to Cloud Computing Edinburgh Training and Conference Venue Tue, 2018-09-11 09:30 £1287 / £1487
Test Automation with Selenium St Helier, Jersey, Channel Isles Tue, 2018-09-18 09:30 £2970 / £4395

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

volkswagen 50 toyota 50 samsung electronics co. 50 phillips 50 lovefilm 50 intel 50 ikea 50 ibm business consulting services 50 hp 50 ebay 50 cisco 50 boeing company 50 apple inc. 50 abu dhabi company for onshore oil operations (adco) abu dhabi tourism & culture authority adetel sie aeronautical radio, incorporated (arinc) agb nielsen agora aip publishing alberta health services alfa wassermann allegro allianz allsaints amaya software american international group (aig) american medical association (ama) american title amey amway arimr asseco poland atos origin atradius autodesk autosan avid technology avinor aviva canada aviva commercial union avon products, inc axel springer se bank of montreal (bmo) bank zachodni wbk basildon district council bharat electronics limited big fish games blackrock inc bombardier transportation

Course Catalogue

  • Artificial Intelligence (161)
    • Computer Vision (6)
      • Machine Vision (4)
    • Evolving Objects ()
    • Jenetics (1)
    • Machine Learning (80)
      • Apache Spark MLlib (2)
      • Apache SystemML (1)
      • Deep Learning (41)
        • Apache SINGA (1)
        • Caffe (1)
        • Deeplearning4j (3)
        • TensorFlow (11)
      • Pattern Recognition (2)
      • PredictionIO (1)
    • Mahout (1)
    • Neural Networks (30)
    • NLP (14)
    • NLTK (1)
    • Predictive Analytics (12)
    • Recommendation Systems (1)
  • Augmented Reality (AR) (9)
  • Big Data (87)
    • Apache Spark (10)
    • Data Mining (29)
      • Pentaho (1)
      • SPARQL (1)
    • Hadoop (32)
      • Hive (1)
    • Impala (1)
  • Bio (9)
  • Blockchain (35)
  • BPM (37)
    • BPMN (24)
    • BPMS (11)
      • Activiti (2)
    • jBPM (5)
    • ProcessMaker (1)
  • Business Rules (19)
    • DMN (2)
    • Drools (8)
    • JBoss Rules (8)
    • Nools (2)
  • Cloud Computing (33)
    • AWS (3)
    • Cloud Based Integration (1)
    • Cloud Foundry (5)
    • OpenStack (8)
  • Collaboration (6)
    • Rocket.Chat (1)
  • Computer (104)
    • OptaPlanner (1)
    • Samba (2)
  • Computer Graphics (27)
  • Configuration Management (9)
    • Ansible (3)
    • Chef (1)
    • Puppet (2)
    • SaltStack (2)
  • Content Management System (CMS) (30)
    • Drupal (21)
    • Magento (4)
    • Plone (1)
    • SharePoint (3)
  • Cyber Security (77)
    • Corporate Compliance (9)
    • Hands on Security (14)
    • Identity Management (1)
    • Information Security Risk (5)
    • Secure Code (38)
    • Security Management (11)
  • Data Analysis (38)
    • Business Intelligence (16)
    • Data Visualization (18)
    • Spatial Analysis (4)
  • Database (102)
    • Access (8)
    • Cassandra (3)
    • CouchDB (2)
    • eXist-db (2)
    • MariaDB (5)
    • Microsoft SQL Server (11)
    • MongoDB (6)
    • MySQL (15)
    • NoSQL (15)
    • Oracle (21)
    • Percona (1)
    • PL/SQL (3)
    • PostgreSQL (3)
    • Redis (1)
    • SequoiaDB (2)
    • SQL (42)
  • DevOps (18)
  • Directory Services (3)
    • LDAP (2)
  • Embedded Systems (26)
  • Enterprise Architecture (26)
    • DoDAF (2)
    • EDA (1)
    • MagicDraw (2)
    • MBSE (7)
    • MODAF (5)
    • SoaML (2)
  • Finance (32)
    • Financial Markets (3)
    • Fixed Income (1)
    • Investment (2)
    • Management Accounting (2)
  • Graph Computing (4)
    • Semantic Web (2)
      • RDF (1)
    • Semantic Wiki (1)
  • Industrial Automation (2)
  • Insurtech (1)
  • Internet of Things (IoT) (20)
    • Apache Quarks (1)
  • Linux (47)
    • Debian (1)
    • Embedded Linux (5)
    • LPI (4)
    • Raspberry Pi (3)
    • Ubuntu (3)
  • Management (123)
    • Agile (38)
    • Brand Management (4)
    • Business Analysis (28)
      • Requirements Engineering (2)
    • Corporate Governance (5)
    • Executive Overview (1)
    • Human Resources (12)
    • Lean (5)
    • Professional Development (9)
    • Project Management (24)
      • KanBan (7)
    • Scrum (20)
    • Strategic Management (11)
  • Marketing (16)
    • Mailman 3 (1)
    • Social Media (4)
      • Facebook (1)
  • Microsoft Office (41)
    • Excel (21)
    • PowerPoint (8)
    • VBA (11)
    • Word (3)
  • Mobile Development (22)
    • Android (14)
    • iOS (11)
    • Progressive Web Apps (PWA) (1)
  • Networking (26)
    • Cisco (8)
    • Network Security (2)
    • Wireshark (5)
  • OMG (35)
    • CMMN (2)
    • FUML (1)
    • OCEB (5)
    • OCRES (2)
    • OCSMP (2)
    • OCUP2 (3)
    • SysML (5)
    • UAF (1)
    • UML (17)
  • Programming (358)
    • C Language (6)
    • C# (13)
    • C++ (10)
    • Haskell (3)
    • Java (63)
      • Java EE (9)
      • Spring (8)
    • JavaScript (60)
      • Ajax (3)
      • Angular (20)
      • jQuery (6)
      • Kraken JS (1)
      • Node.js (9)
      • React (4)
    • Julia (1)
    • Lua (6)
    • MATLAB (16)
    • Microsoft .NET (33)
      • Visual Studio (6)
    • MQL4 (1)
    • Perl (3)
    • PHP (31)
      • Symfony (3)
      • Yii Framework 2.0 (1)
    • Python (34)
      • Web2py (1)
    • Ruby (6)
    • Software Engineering (4)
    • Swift (5)
    • WCF (1)
  • RPA (10)
  • Soft Skills (44)
    • Communication (1)
    • Leadership (3)
    • Presentation Skills (7)
  • Software Design (20)
    • Design Patterns (11)
    • Domain Driven Design (1)
  • Software Testing (81)
    • TestNG (2)
  • Statistics (71)
    • Forecasting (2)
    • R Language (34)
  • Systems Architecture (7)
  • Technical Architecture (1)
  • Version Control Systems (13)
    • GIT (6)
    • Mercurial (3)
    • Subversion (SVN) (4)
  • Video Streaming (4)
  • Web Development (65)
    • Bootstrap (2)
    • CSS (7)
    • HTML (5)
    • MEAN Stack (3)
    • OWASP (1)
    • Sass (1)
    • Web Design (6)
    • WebAssembly (1)
  • Web Server (11)
    • Nginx (2)
  • GlassFish (2)
  • JBoss (9)
  • Tomcat (3)
  • WFOE (1)
  • Docker (19)
    • Docker Swarm ()
  • Kubernetes (9)
  • LXC (1)
  • Jenkins (6)
  • Corona (1)
  • Ionic (3)
  • Xamarin (1)
  • Sensor Fusion (1)
  • InDesign (4)
  • Scribus (1)
  • Apache Camel (1)
  • Apache Kafka (4)
  • Microservices (14)
    • Apigee Edge (1)
  • RabbitMQ (2)
  • SOA (23)
    • SOA Governance (3)
  • Web Services (7)
  • XML (7)
  • XQuery (3)
  • Neo4j (1)
  • Adobe (18)
  • Inkscape (2)
  • JMeter (5)
  • Apache Solr (4)
  • Elasticsearch (6)
  • Selenium (17)
  • MediaWiki (5)
  • Wikipedia (4)

NobleProg® Limited 2004 - 2018 All Rights Reserved
(nobleprog@nobleprog.co.uk, +44 (0)208 089 0990)

The UK is operated by NobleProg (UK) Ltd, but a Franchise can be bought in some regions. If you are interested in opening a franchise in your country, please visit https://training-franchise.com for more information.

NobleProg® is a registered trade mark of NobleProg Limited and/or its affiliates.

Europe United Kingdom Österreich Austria (English) Schweiz Switzerland (English) Deutschland Germany (English) Czech Republic Denmark Estonia Finland Greece Magyarország Hungary (English) Ireland Luxembourg Latvia España Spain (English) Italia Italy (English) Liechtenstein Lithuania Nederland Netherlands (English) Norway Portugal România Romania (English) Sverige Sweden (English) Turkey Malta Europe Belgique Belgium (English) France France (English) Polska Poland (English)
Africa / Middle East Bahrain Jordan Kuwait United Arab Emirates Qatar Saudi Arabia South Africa Israel
South America Brasil Brazil (English) Argentina Argentina (English) Chile Chile (English) Ecuador Ecuador (English) Colombia Colombia (English) Peru Peru (English) Paraguay Paraguay (English) Uruguay Uruguay (English) Venezuela Venezuela (English)
North America Canada USA Costa Rica Costa Rica (English) Guatemala Guatemala (English) México Mexico (English) Panama Panama (English) Puerto Rico Puerto Rico (English)
Asia Pacific 中国 China (English) 台灣 Taiwan (English) Australia Japan Macao Malaysia Hong Kong New Zealand Philippines Singapore Thailand Vietnam India
Other sites Human Resources Training Materials NobleProg Franchise

Privacy & Cookies

Staff login