
Online or onsite, 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 "online live training" or "onsite live training". Online live training (aka "remote live training") is carried out by way of an interactive, remote desktop. Onsite live Oracle training can be carried out locally on customer premises in Malta or in NobleProg corporate training centers in Malta.
NobleProg -- Your Local Training Provider
Testimonials
Partea de exercitii ne-a ajutat sa aprofundam mai lectiile prezentate.
Dragos - Tudor Constantin, Siemens
Course: SQL Fundamentals
Mi-a placut ca s-a bazat pe partea practica si au fost date toate detaliile si explicatiile necesare .
Alixandru Ionut - Tudor Constantin, Siemens
Course: SQL Fundamentals
Mi-a placut foarte mult ca a fost un curs aplicat cu foarte multe exemple si exercitii. A fost un curs interactiv fara prea multa teorie ceea pentru mine a fost perfect.
Vlad - Tudor Constantin, Siemens
Course: SQL Fundamentals
Disponibilitatea trainerului de a explica si a clarifica toate informatiile prezentate
Tudor Constantin, Siemens
Course: SQL Fundamentals
the practical nature of it
Anca Daescu, Ness
Course: SQL Fundamentals
it was an excelent opportunity to add knowledges and to strenghten the old ones.
Titus - Anca Daescu, Ness
Course: SQL Fundamentals
the training pace, the patience, the structured information, the logical flow of the training, the breaks (just right), checking each time for any questions/concerns. Extremely p[professional.
Mihai - Anca Daescu, Ness
Course: SQL Fundamentals
the fact that he explained step by step how he thought about the method used to write the query
Vasile - Anca Daescu, Ness
Course: SQL Fundamentals
the fact that we did a lot of exercises and Philip as an experienced trainer walked us through the answers
Angela - Anca Daescu, Ness
Course: SQL Fundamentals
The structure of the course was perfect for my training style. For the time that we had here i think that the balance between theoretical work and practical work was perfect.
Matei - Anca Daescu, Ness
Course: SQL Fundamentals
tonality, rhythm, good structure
Mihalache Dana - Anca Daescu, Ness
Course: SQL Fundamentals
the practices and the trainer notes
Hamda AlMahri - Maryam Almutairi , Dubai Courts
Course: ORACLE PL/SQL Fundamentals
Mr. Khobeib was a great lecturer and trainer. As a beginner to PL/SQL, Khobeib explained the basics and was patient with us while going through the training material. He answered all our questions thoroughly and showed a lot of examples when we asked him to. I definitely learned a lot and can start doing tasks with PL/SQL.
Abdulrahman Alsalami - Maryam Almutairi , Dubai Courts
Course: ORACLE PL/SQL Fundamentals
the trainer helpful all the time
Maitha Alselais - Maryam Almutairi , Dubai Courts
Course: ORACLE PL/SQL Fundamentals
The trainer was fantastic in all aspects. He was very interactive and engaging. Most importantly, the topics were taught very clearly and at a perfect pace to complete the course. I really appreciate it and would like to give a huge thank you to the trainer.
Vivek Thomas - Estée Lauder BV
Course: ORACLE PL/SQL Fundamentals
It was quite hands-on, not too much theory.
David Lambaerts - Estée Lauder BV
Course: ORACLE PL/SQL Fundamentals
Luka is an excellent, patient teacher with a sense of humor. His relaxed style made the stressful experience of "be called to the blackboard" more pleasant. Also one student explaining or guiding the other was a very good idea. I will use the motto "KISS methodology" he shared with us in both my SQL exercises , private and professional life since I like to overcomplicate things. Luka also kept the good pace considering how much material was there for him to show and for us to learn.
IWONA KLIMASZEWSKA - GP Strategies Poland sp. z o.o.
Course: ORACLE SQL Fundamentals
Trainers respect and non judgement. Felt very comfortable to ask questions.
GP Strategies Poland sp. z o.o.
Course: ORACLE SQL Fundamentals
The practice questions
GP Strategies Poland sp. z o.o.
Course: ORACLE SQL Fundamentals
I could have trained basics and trainer checked and/or helped if any issues
Przemysław Wadowski - GP Strategies Poland sp. z o.o.
Course: ORACLE SQL Fundamentals
Knowledge provided in a very approachable way, good peace and nice examples.
Anna Rozek - GP Strategies Poland sp. z o.o.
Course: ORACLE SQL Fundamentals
Working on examples, not just theory.
GP Strategies Poland sp. z o.o.
Course: ORACLE SQL Fundamentals
The fact that it wasn't just pure knowledge but there was also hand on training which helped to understand everything a lot more. Those exercises were very useful.
Paweł Biały - GP Strategies Poland sp. z o.o.
Course: ORACLE SQL Fundamentals
trainer's approach, good pace, detailed explanations, hands-on experience
Paweł Baka - GP Strategies Poland sp. z o.o.
Course: ORACLE SQL Fundamentals
Interactive way of teaching (interacting with us), sticking to one sample database and doing all the excercises there
Johanna Fiedler - ING Germany
Course: ORACLE SQL Fundamentals
Writing the queries, I genuinely had fun with it and I feel like I learned from the provided exercises the most.
Karol Kamiński - GP Strategies Poland sp. z o.o.
Course: ORACLE SQL Fundamentals
- a lot of exercises
GP Strategies Poland sp. z o.o.
Course: ORACLE SQL Fundamentals
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
Course: Oracle SQL Language
The exercises and the trainer :)
Eliza Ciobanu - OTP BANK ROMANIA S.A.
Course: Oracle SQL Language
The trainer was very attentive to each student and explained until we understood.
OTP BANK ROMANIA S.A.
Course: Oracle SQL Language
The training was applied, with many exercises, exactly as we wanted.
Lorena Anton - OTP BANK ROMANIA S.A.
Course: Oracle SQL Language
Exercises from the day 2
Amelia Bontu - OTP BANK ROMANIA S.A.
Course: Oracle SQL Language
the trainer was very helpful , the pace of the training was really good and the exercises weren't too hard, also not too easy. whenever I got stuck he helped me out very well and made sure I understood everything.
Jade Stappaerts - KULeuven
Course: Oracle SQL Language
The explanation are very clear and the exercises help understand better
Federal Demographic Council
Course: Oracle SQL for beginners
the exercises
Amna AlAli - Federal Demographic Council
Course: Oracle SQL for beginners
The exercise
Federal Demographic Council
Course: Oracle SQL for beginners
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
good atmosphere during the training
clovis Nebouet
Course: Oracle 11g - SQL language for developers - Workshop
very high competence of the trainer!!
Heino Eilers
Course: Oracle 11g - Programming with PL / SQL I - Workshops
Access to trainers individual support in resolving exercises.
Tomasz Czornak
Course: Oracle SQL Intermediate
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
Rady dotyczące optymalizacji działania kodu
Daria Klamann, Sygnity S.A.
Course: Oracle 12c – Zaawansowane programowanie w PL/SQL
Ilość wiedzy i sposób jej przekazania były naprawdę rewelacyjne.
Daria Klamann, Sygnity S.A.
Course: Oracle 12c – Zaawansowane programowanie w PL/SQL
Wszystko było udowodnione na przykładach
Marcin - Daria Klamann, Sygnity S.A.
Course: Oracle 12c – Zaawansowane programowanie w PL/SQL
Omówienie rzadziej używanych, ale użytecznych funkcjonalności PL/SQL
Daria Klamann, Sygnity S.A.
Course: Oracle 12c – Zaawansowane programowanie w PL/SQL
The training materials.
Mona Dobre - Oana Panceaa, DB Global Technology
Course: SQL Advanced level for Analysts
That the trainer provide alot of materials , files and reference to return to them later once need and for self study .
Abdulrahman E. Al Qahtani, Saudi Azm for Communication and Information Technology Co
Course: SQL Advanced level for Analysts
The trainer was knowledgeable on subject matter and was friendly and helpful.
Sally Roche, Tribal Group
Course: Developing Applications with Oracle Application Express (APEX)
The trainer was engaging in most parts and the quiz (only one) was fun.
Sally Roche, Tribal Group
Course: Developing Applications with Oracle Application Express (APEX)
Hands on learning. Willingness of trainer to assist us with any issues or questions.
Sally Roche, Tribal Group
Course: Developing Applications with Oracle Application Express (APEX)
Oracle Subcategories in Malta
Oracle Course Outlines in Malta
- Understand the concepts of database security.
- Implement authentication and authorization mechanisms to control access to the database.
- Configure and manage user accounts, roles, and privileges effectively.
- Implement robust security measures against various threats and vulnerabilities.
- How to build a query?
- What possibilities have SQL?
- What is a relational database?
- What is the structure and SQL commands
- How to build advanced queries?
- How to create advanced reports?
databases (Oracle, SQL Server, MS Access...). Understanding of analytic functions and the
way how to join different tables in a database will help delegates to move data analysis
operations to the database side, instead of doing this in MS Excel application. This can also
help in creating any IT system, which uses any relational database.
- Configure passwordless authentication.
- Administer user and group accounts.
- Configure network interface.
- Monitor and troubleshoot Oracle Linux.
- Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
- Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
- Perform post-migration steps to test, optimize, update, and maintain a migrated database.
- Learn and understand the concepts of Oracle Fusion Human Capital Management (HCM).
- Implement complete workforce structure management in any organization.
- Understand the core concepts of Oracle Database 21c administration.
- Understand the Oracle 21c architecture.
- Learn how to perform administration tasks on Oracle 21c.
- Understand the Oracle 21c backup and recovery process.
- 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
- Understand the major feature and architectural changes Oracle database.
- Manage and monitor Oracle databases.
- Optimize Oracle database performance.
- Understand the major feature and architectural changes from previous Oracle versions.
- Migrate to Oracle 18c from a previous version.
- Deploy Oracle 18c in cloud or on premise.
- Understand Oracle 18c's new yearly release cycle and plan maintenance around it.
- Understand the major feature and architectural changes in Oracle Web Forms.
- Migrate to Oracle Web Forms from a previous Forms version.
- ***Deploy Oracle Web Forms in cloud or on premise.
- Leverage Oracle Web Forms to enhance user services and experience.
- Build, deploy, and manage cloud applications using Oracle PaaS.
- Configure and use data management tools for easy storage and backup.
- Visualize and evaluate application performance and logs.
- Generate business analytics reports.
- Understand and implement security standards.
- Set up the necessary development environment to start developing database apps with Oracle APEX.
- Understand and explore the Oracle APEX tools to build a fully-featured application.
- Learn how to create applications and pages using Oracle APEX and the Page Designer UI.
- Extend the functionality of complex enterprise apps easily with Oracle APEX.
- Optimize and scale application performance and deployment.
- Control and secure access to application data and components.
Advanced
Form
Lecture, Presentation, Workshop, Problem solving
Purpose of the training
The training is intended for programmers who know the basics of SQL and PL/SQL, but want to learn more advanced mechanisms of the language, and want to create database applications based on stored PL/SQL programs.
Benefits of completing the training
Acquisition of skills in creating database applications embedded in a database.
- 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
- 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
- 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
- Objects, streams and complex data structures
- Advanced solutions based on PL / SQL
- 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
Last Updated: