I corsi di formazione Oracle Local Database (Oracle RDBMS or Oracle) in diretta dimostrano attraverso discussioni e handson i fondamenti di Oracle La formazione Oracle è disponibile come "allenamento dal vivo in loco" o "allenamento dal vivo a distanza" La formazione on-site in loco può essere svolta localmente presso la sede del cliente in Italia o nei centri di formazione aziendale NobleProg in Italia La formazione in remoto dal vivo viene effettuata tramite un desktop remoto interattivo NobleProg Il tuo fornitore di formazione locale.
Machine Translated
Recensioni
esercizi (compiti) da svolgere, esempi tratti dall'esperienza professionale del formatore
Tomasz Niewiadomski
Corso: Oracle 11g - Programming with PL / SQL I - Workshops
Machine Translated
Mostrare come vengono eseguiti meccanismi noti sul lato del database, ad es. Vengono elaborati in memoria
Marcin Czerwiec
Corso: Oracle 11g - Programming with PL / SQL I - Workshops
Machine Translated
La formazione era perfettamente preparata, mi piaceva il modo di correre basato su esempi in tempo reale con una discussione dettagliata dell'impatto delle singole istruzioni sul database.
Joanna Dymarczyk
Corso: Oracle 11g - Programming with PL / SQL I - Workshops
Machine Translated
SQL;)
MAGDALENA KOPCZYŃSKA
Corso: Oracle SQL for beginners
Machine Translated
molto esercizio
Łukasz Dziewiński
Corso: Oracle SQL for beginners
Machine Translated
tempo delle lezioni, flessibilità per quanto riguarda il contenuto della formazione in relazione alle aspettative degli utenti
Karol
Corso: SQL Fundamentals
Machine Translated
Pace, spiegazione dei problemi da una prospettiva completamente diversa. Qualcosa che spiega come tutto funzioni dal lato server
P4 Sp. z o.o.
Corso: SQL Fundamentals
Machine Translated
numero di problemi coperti
P4 Sp. z o.o.
Corso: SQL Fundamentals
Machine Translated
adattamento ai bisogni dei partecipanti, ottima esplorazione dei compiti discussi, risposte esaustive alla domanda posta
Marcin Gołdyn
Corso: SQL Fundamentals
Machine Translated
Lavora su un database fisico.
P4 Sp. z o.o.
Corso: SQL Fundamentals
Machine Translated
adattandosi ai bisogni degli ascoltatori, analizzando i problemi che segnalano
P4 Sp. z o.o.
Corso: SQL Fundamentals
Machine Translated
Esercizi sulle funzioni!
WIktor Paprzycki
Corso: SQL Advanced level for Analysts
Machine Translated
via di traduzione
Małgorzata Mieczkowska
Corso: SQL Advanced level for Analysts
Machine Translated
esercizi
Wiktor Paprzycki
Corso: SQL Advanced level for Analysts
Machine Translated
esempi, apertura del formatore
INTERNATIONAL PAPER POLSKA
Corso: Oracle SQL Language
Machine Translated
flessibilità
dawid bodo
Corso: Oracle SQL Language
Machine Translated
esercizi
Mateusz Wilk
Corso: Oracle SQL for beginners
Machine Translated
Un'esperienza formidabile per i trainer
Crédit Suisse (Poland) Sp. z o.o.
Corso: Oracle 11g - Application Tuning - Workshop
Machine Translated
esercizio.
Marzena Marciniak - Bakoma Sp. z o. o.
Corso: Oracle SQL for beginners
Machine Translated
Esercizi :).
Monika Lewalska - Bakoma Sp. z o. o.
Corso: Oracle SQL for beginners
Machine Translated
Trasferimento di informazioni sostanziale e molto semplice.
Piotr Polański - Bakoma Sp. z o. o.
Corso: Oracle SQL for beginners
Machine Translated
Bella atmosfera, un gran numero di esempi spiegati molto bene. Materiali di formazione per ogni parte. L'allenatore è molto utile nel riparare gli errori durante gli esercizi. Consiglio a tutti coloro che vogliono ottenere e ampliare le loro conoscenze in SQL ...
Sebastian Straczyński - Stowarzyszenie Niżańskie Centrum Rozwoju
Corso: Oracle SQL Intermediate
Machine Translated
modo di condurre e la conoscenza del formatore e il metodo del suo trasferimento.
Grzegorz Cimochowski - Zakłady Produkcyjno-Usługowe "PRAWDA" sp. z o.o.
Corso: Oracle SQL for beginners
Machine Translated
Esercizi :).
Katarzyna Gędziorowska - Bakoma Sp. z o. o.
Corso: Oracle SQL for beginners
Machine Translated
Relazioni allentate, risposta a ogni domanda, sogno di problemi incomprensibili.
Bakoma Sp. z o. o.
Corso: Oracle SQL for beginners
Machine Translated
I have no comments.
Bakoma Sp. z o. o.
Corso: Oracle SQL for beginners
Schema generale del corso Oracle
Nome del corso
Durata
Overview
Nome del corso
Durata
Overview
14 hours
Overview
Questo corso di formazione SQL è rivolto a persone che desiderano acquisire le competenze necessarie per estrarre e analizzare i dati da qualsiasi database e creare report. I membri del corso impareranno:
- come scrivere query SQL
- quali sono i database relazionali e come possiamo usarli
- quali sono le relazioni e come crearle
- la struttura dei dati
- differenze tra i dialetti SQL (Oracle, T-SQL, ANSI)
- abilità pratiche per scrivere le domande
Questo corso SQL riguarda l'ANSI SQL generico. Può essere utilizzato in qualsiasi database, inclusi Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL e altri database relazionali.
- come scrivere query SQL
- quali sono i database relazionali e come possiamo usarli
- quali sono le relazioni e come crearle
- la struttura dei dati
- differenze tra i dialetti SQL (Oracle, T-SQL, ANSI)
- abilità pratiche per scrivere le domande
Questo corso SQL riguarda l'ANSI SQL generico. Può essere utilizzato in qualsiasi database, inclusi Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL e altri database relazionali.
14 hours
Overview
Oracle Database 18c is the next iteration of Oracle Database 12c Release 2, or "the first patch".
This instructor-led, live training (onsite or remote) is aimed at engineers who wish to set up, deploy, migrate to and manage an Oracle 18c Database.
By the end of this training, participants will be able to:
- 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.
Format of the course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
This instructor-led, live training (onsite or remote) is aimed at engineers who wish to set up, deploy, migrate to and manage an Oracle 18c Database.
By the end of this training, participants will be able to:
- 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.
Format of the course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
21 hours
Overview
Lo scopo di questo corso è quello di fornire una chiara comprensione dell'uso di SQL per diversi database (Oracle, SQL Server, MS Access) Comprensione delle funzioni analitiche e del in che modo unire tabelle diverse in un database aiuterà i delegati a spostare l'analisi dei dati operazioni sul lato del database, invece di farlo in MS Excel Questo può anche aiuto nella creazione di qualsiasi sistema IT, che utilizza qualsiasi database relazionale .
14 hours
Overview
Pubblico
Tutti coloro che desiderano migliorare le proprie competenze di base in Oracle SQL e anche sistematizzare le conoscenze già acquisite.
Formato del corso
25% di lezioni frontali, 75% di laboratori
Tutti coloro che desiderano migliorare le proprie competenze di base in Oracle SQL e anche sistematizzare le conoscenze già acquisite.
Formato del corso
25% di lezioni frontali, 75% di laboratori
14 hours
Overview
L'obiettivo del corso è consentire ai partecipanti di acquisire una padronanza di come lavorare con il linguaggio SQL nel database Oracle per l'estrazione dei dati a livello intermedio.
14 hours
Overview
Questo corso di 3 giorni offre un'introduzione a SQL Developer, SQL * Plus e SQL, Structured Query Language utilizzato per accedere a un database relazionale e include le nuove funzionalità dell'ultima versione di ORACLE. I principi appresi possono anche essere applicati a database diversi come Microsoft SQL Server, MySQL, Access, Informix e DB2.
Il corso prende il formato di un workshop, con un mix di lezioni, esempi di lavoro ed esercizi pratici. Sebbene il contenuto possa essere personalizzato, sono necessari almeno 2 giorni per coprire gli elementi principali.
Vengono fornite note complete sul corso insieme a file di database di esempio, file SQL di esempio e strumenti software gratuiti per l'accesso a un database ORACLE.
Il corso prende il formato di un workshop, con un mix di lezioni, esempi di lavoro ed esercizi pratici. Sebbene il contenuto possa essere personalizzato, sono necessari almeno 2 giorni per coprire gli elementi principali.
Vengono fornite note complete sul corso insieme a file di database di esempio, file SQL di esempio e strumenti software gratuiti per l'accesso a un database ORACLE.
35 hours
Overview
Questo corso di 5 giorni dimostra come utilizzare Oracle SQL per lo sviluppo e la gestione del database.
14 hours
Overview
This instructor-led, live training (onsite or remote) is aimed at engineers who wish to migrate from Oracle Forms to Oracle Web Forms.
By the end of this training, participants will be able to:
- Understand the major feature and architectural changes in Oracle Web Forms.
- Migrate to Oracle Web Forms from a previous Forms version.
- Deploy a Oracle Web Application.
- Leverage Oracle Web Forms to enhance user services and experience.
Format of the course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
By the end of this training, participants will be able to:
- Understand the major feature and architectural changes in Oracle Web Forms.
- Migrate to Oracle Web Forms from a previous Forms version.
- Deploy a Oracle Web Application.
- Leverage Oracle Web Forms to enhance user services and experience.
Format of the course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
21 hours
Overview
Questo corso di 3 giorni offre un'introduzione a ORACLE PL / SQL, un ambiente di sviluppo di applicazioni che consente la scrittura di stored procedure, funzioni e trigger utilizzando comandi SQL e PL / SQL.
Il corso prende il formato di un workshop, con un mix di lezioni, esempi di lavoro ed esercizi pratici. Sebbene il contenuto possa essere personalizzato, sono necessari almeno 2 giorni per coprire gli elementi principali.
Vengono fornite note complete sul corso insieme a file di database di esempio, file SQL di esempio e strumenti software gratuiti per l'accesso a un database ORACLE.
Il corso prende il formato di un workshop, con un mix di lezioni, esempi di lavoro ed esercizi pratici. Sebbene il contenuto possa essere personalizzato, sono necessari almeno 2 giorni per coprire gli elementi principali.
Vengono fornite note complete sul corso insieme a file di database di esempio, file SQL di esempio e strumenti software gratuiti per l'accesso a un database ORACLE.
28 hours
Overview
La formazione è destinata non solo agli amministratori di database Oracle sia che stanno appena iniziando a lavorare con i server Oracle sia che stanno già lavorando su tale server e vogliono conoscere i nuovi futuri nella versione 12c. Questa formazione può essere utile anche per i programmatori che, grazie alla comprensione dell'architettura del server e delle sue regole sui meccanismi, saranno in grado di creare applicazioni efficaci lavorando con il database Oracle 12c.
14 hours
Overview
Gli ascoltatori
Questo corso è progettato per le persone che desiderano utilizzare le funzionalità avanzate di SQL in Oracle
Il corso risponde alle domande
- Come creare query avanzate?
- Come creare report avanzati?
Questo corso è progettato per le persone che desiderano utilizzare le funzionalità avanzate di SQL in Oracle
Il corso risponde alle domande
- Come creare query avanzate?
- Come creare report avanzati?
21 hours
Overview
Gli ascoltatori
Questa formazione è indirizzata alle persone che iniziano a lavorare con il linguaggio SQL nel database Oracle
La risposta al corso per domande:
- Come creare una query?
- Quali possibilità hanno SQL ?
- Che cos'è un database relazionale?
- Qual è la struttura e SQL comandi SQL
Questa formazione è indirizzata alle persone che iniziano a lavorare con il linguaggio SQL nel database Oracle
La risposta al corso per domande:
- Come creare una query?
- Quali possibilità hanno SQL ?
- Che cos'è un database relazionale?
- Qual è la struttura e SQL comandi SQL
21 hours
Overview
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
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
28 hours
Overview
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
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
21 hours
Overview
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
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
28 hours
Overview
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
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
35 hours
Overview
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
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
14 hours
Overview
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
How to build a query?
What possibilities have SQL?
What is a relational database?
What is the structure and SQL commands
Prossimi corsi Oracle
2020-07-13 09:30:00
Rome
35 ore
2020-07-27 09:30:00
Milan
35 ore
2020-09-07 09:30:00
Rome
35 ore
2020-09-21 09:30:00
Milan
35 ore
2020-11-02 09:30:00
Rome
35 ore
Other countries
Consulting
Fine settimana Oracle corsi, Sera Oracle training, Oracle centro di addestramento, Oracle con istruttore, Fine settimana Oracle training, Sera Oracle corsi, Oracle coaching, Oracle istruttore, Oracle trainer, Oracle corsi di formazione, Oracle classi, Oracle in loco, Oracle corsi privati, Oracle training individuale
.png "new york stock exchange (nyse)")
.jpg "european molecular biology laboratory (embl)")
.png "european space agency (esa)")
