Programele de instruire Oracle Database (Oracle RDBMS sau Oracle), instruite la nivel local, demonstrează prin discuții și practici practice principiile Oracle Instruirea Oracle este disponibilă ca "formare live la fața locului" sau "formare live la distanță" Training-ul live la fața locului poate fi efectuat la fața locului la sediul clientului România sau în centrele de formare corporativa NobleProg din România Instruirea live la distanță este realizată printr-un desktop interactiv, la distanță NobleProg Furnizorul dvs de formare locală.
Machine Translated
Mărturii
exerciții (sarcini) ce urmează a fi efectuate, exemple din experiența profesională a formatorului
Tomasz Niewiadomski
Curs: Oracle 11g - Programming with PL / SQL I - Workshops
Machine Translated
Afișarea mecanismelor cunoscute pe baza bazei de date, de exemplu, acestea sunt prelucrate în memorie
Marcin Czerwiec
Curs: Oracle 11g - Programming with PL / SQL I - Workshops
Machine Translated
Instruirea a fost perfect pregătită, mi-a plăcut modul de funcționare bazat pe exemple în timp real, cu o discuție detaliată a impactului instrucțiunilor individuale asupra bazei de date. Joan
Joanna Dymarczyk
Curs: Oracle 11g - Programming with PL / SQL I - Workshops
Machine Translated
SQL;)
MAGDALENA KOPCZYŃSKA
Curs: Oracle SQL for beginners
Machine Translated
o mulțime de exerciții fizice
Łukasz Dziewiński
Curs: Oracle SQL for beginners
Machine Translated
tempo de clase, flexibilitate în ceea ce privește conținutul formării legate de așteptările utilizatorilor Ka
Karol
Curs: SQL Fundamentals
Machine Translated
Pace, explicarea problemelor dintr-un unghi complet diferit. Ceva care explică cum funcționează totul din partea serverului
P4 Sp. z o.o.
Curs: SQL Fundamentals
Machine Translated
numărul de aspecte acoperite
P4 Sp. z o.o.
Curs: SQL Fundamentals
Machine Translated
adaptarea la nevoile participanților, explorarea foarte bună a sarcinilor discutate, răspunsuri cuprinzătoare la întrebarea pusă Ma
Marcin Gołdyn
Curs: SQL Fundamentals
Machine Translated
Lucrați pe o bază de date fizică.
P4 Sp. z o.o.
Curs: SQL Fundamentals
Machine Translated
adaptarea la nevoile ascultătorilor, analizarea problemelor pe care le prezintă
P4 Sp. z o.o.
Curs: SQL Fundamentals
Machine Translated
Exerciții pe funcții!
WIktor Paprzycki
Curs: SQL Advanced level for Analysts
Machine Translated
mod de traducere
Małgorzata Mieczkowska
Curs: SQL Advanced level for Analysts
Machine Translated
exerciții
Wiktor Paprzycki
Curs: SQL Advanced level for Analysts
Machine Translated
exemple, deschiderea formatorului
INTERNATIONAL PAPER POLSKA
Curs: Oracle SQL Language
Machine Translated
flexibilitate
dawid bodo
Curs: Oracle SQL Language
Machine Translated
exerciții
Mateusz Wilk
Curs: Oracle SQL for beginners
Machine Translated
O experiență uriașă de antrenor
Crédit Suisse (Poland) Sp. z o.o.
Curs: Oracle 11g - Application Tuning - Workshop
Machine Translated
exercițiu.
Marzena Marciniak - Bakoma Sp. z o. o.
Curs: Oracle SQL for beginners
Machine Translated
Exerciții :).
Monika Lewalska - Bakoma Sp. z o. o.
Curs: Oracle SQL for beginners
Machine Translated
Transferul substanțial și foarte ușor de informații.
Piotr Polański - Bakoma Sp. z o. o.
Curs: Oracle SQL for beginners
Machine Translated
O atmosferă plăcută, un număr mare de exemple foarte bine explicate. Materiale de instruire pentru fiecare parte. Antrenorul este foarte util în repararea greșelilor în timpul exercițiilor. Recomand tuturor celor care doresc să-și extindă cunoștințele în SQL ...
Sebastian Straczyński - Stowarzyszenie Niżańskie Centrum Rozwoju
Curs: Oracle SQL Intermediate
Machine Translated
modul de desfășurare și cunoașterea formatorului și metoda transferului acestuia.
Grzegorz Cimochowski - Zakłady Produkcyjno-Usługowe "PRAWDA" sp. z o.o.
Curs: Oracle SQL for beginners
Machine Translated
Exerciții :).
Katarzyna Gędziorowska - Bakoma Sp. z o. o.
Curs: Oracle SQL for beginners
Machine Translated
Relații libere, răspunzând la fiecare întrebare, visează la probleme incomprehensibile.
Bakoma Sp. z o. o.
Curs: Oracle SQL for beginners
Machine Translated
I have no comments.
Bakoma Sp. z o. o.
Curs: Oracle SQL for beginners
Oracle Course Outlines
Numele cursului
Durata
Sinoptic
Numele cursului
Durata
Sinoptic
14 hours
Sinoptic
Acest curs de instruire SQL este destinat persoanelor care doresc să obțină abilitățile necesare pentru a extrage și analiza date din orice bază de date și pentru a crea rapoarte. Membrii cursului vor învăța:
- cum să scrieți interogări SQL
- ce baze de date relaționale sunt și cum le putem folosi
- care sunt relațiile și cum să le creezi
- structura datelor
- diferențele dintre dialectele SQL (Oracle, T-SQL, ANSI)
- abilități practice pentru scrierea de interogări
Acest curs SQL se ocupă de genericul ANSI SQL. Acesta poate fi utilizat în orice bază de date, inclusiv Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL orice alte baze de date relaționale.
- cum să scrieți interogări SQL
- ce baze de date relaționale sunt și cum le putem folosi
- care sunt relațiile și cum să le creezi
- structura datelor
- diferențele dintre dialectele SQL (Oracle, T-SQL, ANSI)
- abilități practice pentru scrierea de interogări
Acest curs SQL se ocupă de genericul ANSI SQL. Acesta poate fi utilizat în orice bază de date, inclusiv Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL orice alte baze de date relaționale.
14 hours
Sinoptic
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
Sinoptic
Scopul acestui curs este de a oferi o înțelegere clară a utilizării SQL pentru diferite baze de date (Oracle, SQL Server, MS Access) Înțelegerea funcțiilor analitice și a modul în care să vă alăturați diferitelor tabele într-o bază de date vă va ajuta pe delegații să mute analiza datelor operațiuni în partea de bază de date, în loc de a face acest lucru în aplicația MS Excel Acest lucru poate, de asemenea ajutați în crearea oricărui sistem IT, care utilizează orice bază de date relațională .
14 hours
Sinoptic
Public
Toți cei care doresc să-și îmbunătățească abilitățile de bază în Oracle SQL și, de asemenea, să sistezeze deja cunoștințele dobândite.
Formatul cursului
25% prelegeri, 75% laboratoare
Toți cei care doresc să-și îmbunătățească abilitățile de bază în Oracle SQL și, de asemenea, să sistezeze deja cunoștințele dobândite.
Formatul cursului
25% prelegeri, 75% laboratoare
14 hours
Sinoptic
Obiectivul cursului este de a permite participanților să dobândească o manieră a modului de lucru cu limba SQL în baza de date Oracle pentru extragerea datelor la nivel intermediar.
14 hours
Sinoptic
Acest curs de 3 zile oferă o introducere în SQL Developer, SQL * Plus și SQL, limba de interogare structurată utilizată pentru a accesa o bază de date relațională și include noile caracteristici ale ultimei versiuni a ORACLE. Principiile învățate pot fi, de asemenea, aplicate la bazele de date atât de diverse precum Microsoft SQL Server, MySQL, Access, Informix și DB2.
Cursul are forma unui atelier, cu o combinație de prelegeri, exemple de lucru și exerciții practice. Deși conținutul poate fi personalizat, sunt necesare cel puțin 2 zile pentru a acoperi elementele de bază.
Notele complete de curs sunt furnizate împreună cu fișiere de baze de date exemplu, exemple de fișiere SQL și instrumente software gratuite pentru a fi utilizate în accesarea unei baze de date ORACLE.
Cursul are forma unui atelier, cu o combinație de prelegeri, exemple de lucru și exerciții practice. Deși conținutul poate fi personalizat, sunt necesare cel puțin 2 zile pentru a acoperi elementele de bază.
Notele complete de curs sunt furnizate împreună cu fișiere de baze de date exemplu, exemple de fișiere SQL și instrumente software gratuite pentru a fi utilizate în accesarea unei baze de date ORACLE.
35 hours
Sinoptic
Acest curs de 5 zile demonstrează cum să utilizați Oracle SQL pentru dezvoltarea de baze de date și gestionarea bazelor de date.
14 hours
Sinoptic
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
Sinoptic
Acest curs de 3 zile oferă o introducere în ORACLE PL / SQL, un mediu de dezvoltare a aplicațiilor care permite scrierea procedurilor, funcțiilor și declanșatorilor stocați folosind comenzi SQL și PL / SQL.
Cursul are forma unui atelier, cu o combinație de prelegeri, exemple de lucru și exerciții practice. Deși conținutul poate fi personalizat, sunt necesare cel puțin 2 zile pentru a acoperi elementele de bază.
Notele complete de curs sunt furnizate împreună cu fișiere de baze de date exemplu, exemple de fișiere SQL și instrumente software gratuite pentru a fi utilizate în accesarea unei baze de date ORACLE.
Cursul are forma unui atelier, cu o combinație de prelegeri, exemple de lucru și exerciții practice. Deși conținutul poate fi personalizat, sunt necesare cel puțin 2 zile pentru a acoperi elementele de bază.
Notele complete de curs sunt furnizate împreună cu fișiere de baze de date exemplu, exemple de fișiere SQL și instrumente software gratuite pentru a fi utilizate în accesarea unei baze de date ORACLE.
28 hours
Sinoptic
Instruirea este destinată nu numai administratorilor bazei de date Oracle atât cei care încep să lucreze cu serverele Oracle , cât și care lucrează deja la un astfel de serviciu și doresc să afle despre noile viitoruri în versiunea 12c. Această pregătire poate fi utilă și pentru programatorii care - datorită înțelegerii arhitecturii serverului și a regulilor mecanismelor sale - vor putea crea aplicații eficiente care lucrează cu baza de date Oracle 12c.
14 hours
Sinoptic
ascultătorii
Acest curs este destinat persoanelor care doresc să utilizeze caracteristicile avansate ale SQL în Oracle
Cursul răspunde la întrebări
- Cum se construiesc interogări avansate?
- Cum puteți crea rapoarte avansate?
Acest curs este destinat persoanelor care doresc să utilizeze caracteristicile avansate ale SQL în Oracle
Cursul răspunde la întrebări
- Cum se construiesc interogări avansate?
- Cum puteți crea rapoarte avansate?
21 hours
Sinoptic
ascultătorii
Această instruire este adresată persoanelor care încep să lucreze cu limba SQL în Oracle date Oracle
Răspunsul cursului pentru întrebări:
- Cum se construiește o interogare?
- Ce posibilități au SQL ?
- Ce este o bază de date relațională?
- Care este structura și comenzile SQL
Această instruire este adresată persoanelor care încep să lucreze cu limba SQL în Oracle date Oracle
Răspunsul cursului pentru întrebări:
- Cum se construiește o interogare?
- Ce posibilități au SQL ?
- Ce este o bază de date relațională?
- Care este structura și comenzile SQL
21 hours
Sinoptic
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
Sinoptic
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
Sinoptic
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
Sinoptic
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
Sinoptic
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
Sinoptic
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
Upcoming Oracle Courses
2020-04-29 09:30:00
Brașov
21 ore
2020-06-16 09:30:00
Iași
21 ore
2020-06-22 09:30:00
Brașov
21 ore
2020-08-12 09:30:00
Brașov
21 ore
2020-10-06 09:30:00
Brașov
21 ore
Other regions
Other countries
Consultanță
Sfarsit de saptamana Oracle Cursuri, Seara Oracle Training, Oracle Camp, Oracle Cu instructor, Sfarsit de saptamana Oracle Training, Seara Oracle Cursuri, Oracle Coaching, Oracle Instructor, Oracle Trainer, Oracle Cursuri, Oracle Clase, Oracle Pe pagina, Oracle curs privat, Oracle one on one training
.jpg "european organization for nuclear research (cern)")
.jpg "american international group (aig)")
.jpg "european southern observatory (eso)")
.png "aeronautical radio, incorporated (arinc)")
