Learnit Training
SQL Basic Course-Oracle
  • Modify, manipulate and adapt SQL data and table structures
  • MS SQL Server, ORACLE, MS Access, PostgreSQL and MySQL databases
  • Very experienced database trainer
  • Small groups
  • Practical training

"SQL base Oracle is a training that I can recommend with peace of mind. The practical applicability is very large! "-rating: 8.6

learnit SQL Basic-Oracle

SQL Basic Course-Oracle

SQL is the language used to communicate with relational databases. For example, SQL can be used to easily obtain the desired data from a large administration system. Because SQL is standardized (ANSI SQL), it can be used with multiple database systems.

In our two-day training SQL Base-Oracle is the BASIS of SQL treated, with the focus on the use of an Oracle database and the USE of SQL Developer. In The training there is room to indicate the aspect of SQL or the tools you want to focus on.

Topics

  • Introduction to SQL, Basic principles: Data types, keys (primary key, foreign key)
  • Retrieving data (SELECT FROM, TOP, DISTINCT)
  • Sort data (ORDER BY)
  • Filter data (WHERE, comparison operators, BETWEEN)
  • Advanced Filtering (AND, OR, IN NOT)
  • Filter using wildcards (LIKE)
  • Calculated fields (concaters)
  • Customizing data with Functions (ROUND, LTRIM, RTRIM, DATE PART)
  • Summarize data (COUNT, SUM, AVG, MAX, MIN)
  • Grouping data (GROUP BY, HAVING)
  • Working with subqueries
  • Combine data from multiple tables with join (INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER join)
  • Advanced Joins (Table aliases
  • Combine Queries (UNION)
  • Add data (INSERT INTO)
  • Modify and delete data (UPDATE, DELETE)
  • Create, modify, and delete tables (CREATE, ALTER, DROP)

Target

This training is intended for users of an Oracle database and participants who will work as an application administrator or user with an Oracle database.

Training materials

You will receive a clear book with exercises and practice files at the start of the training. This can also be used as a reference book after the training. Because the terminology in the software is mostly English, the training material is also.

Prior knowledge

This training requires no prior knowledge and is suitable for novice database users.

Note

For a platform-independent training, we would like to refer you to SQL Base. For a similar training for Microsoft SQL Server, we would like to refer you to Transact-SQL Basic-MS SQL Server

Language

The training is provided by default in Dutch. The trainer controls the English language. English course material can be used. When registering at least 3 participants, the training can also be provided entirely in English.

Investment

Mentioned prices are per person, including course material. Lunch is included in the training on location.

On location Online
Duration 2 days 4 sessions of three hours
Price per day, excl. VAT € 425,- € 340,-
Total, incl. VAT € 1028,50 € 822,80

Certificate

After completing the training, a LEARNIT certificate will be issued as proof of participation.


Online

We also organize this training online. For this we use Webbex or Zoom. Logging in with Skype is also possible. On request this training can also be organized with Microsoft Teams.

The training lasts 4 sessions of 3 hours, spread over 4 weeks.

  • Until one year after the training you can participate for free.
  • Against payment of the catering costs you can also participate in a classroom training.

References

The course SQL Basic - Oracle has been assessed with an average of 8.3.

"SQL Basic Oracle is a training that I can confidently recommend. The practical applicability is very great! - Rating: 8.6

N. Meijer. Rijksdienst voor Ondernemend Nederland - SQL Base - Oracle

"Excellent basic training. Subjects are explained step by step, after which the student will practice on the basis of a number of short assignments. Because the trainer is walking around and watching, you get immediate feedback."

- SQL Basics - Oracle

"You learn the basic commands to query a database and combine tables. This fitted in perfectly with the issues I encounter in daily practice. I was lucky to meet a class that participated in the training with the same goals. Because of this the pace was high and you didn't have to wait for other students. It is a requirement to have some knowledge of application management and to have questioned databases, so you can translate the content directly into daily practice". - Review: 8.8

P. de Best, Municipality of Westland - SQL Base - Oracle

"Great training. Excellent teacher" - Rating: 9.0

Ernst Lesterhuis, Global Knowledge - SQL Base - Oracle

"The content of the course is fine, you get a clear picture of the applicability of the material within your own organisation. Nice exercises and a great teacher who knows how to teach in an inspiring way."

- SQL Basics - Oracle

"Training largely matched the impression I had from the brochure. Excellent trainer who was clear and straightforward; took into account different levels within the group and divided the ratio theory/exercises very well". - Rating: 8.0

T. Koenraadt, AkzoNobel Decorative Paints - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

"This training gives you an even better picture, what you can do with SQL and how you can apply what you have learned. Recommended." - Assessment: 8.1

Jurgen Koopmans, Roba Metals BV - SQL Continued

"It's a good training for filling in the gaps if you have patchy knowledge, due to on the job learning, like I did." - Rating: 8.0

Laszlo Iliasics, Mapscape B.V. - SQL Base

"Very good workout. In two days there is a lot of treatment, but this goes at a pleasant pace. Good alternation of theory and doing exercises yourself. Great trainer, has a lot of knowledge of the material and can convey this clearly and in a pleasant way". - Rating: 9.0

T. Wolfs, NUON - SQL Base

"The combination of short explanations and assignments I have experienced as very pleasant. The trainer has a pleasant way of transferring the knowledge and processes practical experience through the lesson material". - Rating: 8.0

R. Sleeves, ATEA Group - Transact-SQL Basics - MS SQL Server

"I met my expectations." I can read at least one SQL scripts. Creating yourself is also good for simple things. "

Thata van Meerwijk, Albeda College - Open Learning Form SQL

"Theory and practice (doing exercises yourself) in the right distribution. Very good training. Professional trainer. Pace of the training is right." - Review: 8.8

C. Bogaards, T-Mobile - SQL Base

"Very good course for beginners, but also a refresher for the more experienced." - Rating: 8.6

Monique van de Wetering, Greenspans B.V. - Open Learning Form SQL

"The trainer had a lot of experience and thorough substantive knowledge. Excellent training!" - Review: 7.6

J. Green, Kennemerland Police - SQL Base

"A good training to learn the basics of SQL and to apply it directly in practice". - Review: 8.9

Marianne van Oosten, Graphic Lyceum Utrecht - SQL Base

"The training is very instructive, in which you learn the skill to query databases in a short period of time. The good atmosphere of the training stimulates the creativity, which makes learning almost self-evident. The training doesn't cost energy, but provides energy". - Review: 7.8

R. Schoonenberg, Agency EN - SQL Base

"Both for beginner and advanced, this is an instructive training, which is given in an interactive way. This is very pleasant, because you can apply it immediately while doing the exercises that are given during the training. You always have the opportunity to ask questions and the guidance is also good. So all in all a very good experience with the SQL basic training of Learnit Training"! - Rating: 8.0

G. Romkens, CompuGroup Medical (CGM) - SQL Base

"The trainer was very good and the teaching material clear. The pace of the training was good to do and the assignments offered just enough challenge."

- Open Learning Form SQL

"Convenient course to quickly learn SQL." - Rating: 8.0

Eveline Horbach, Sorgente - Open Learning Form SQL

"it's a very good basis, to start working with SQL right away." - Review: 7.8

T. Crane - SQL Base

"With this training you will learn in 2 days what SQL is, how to use it and what the known mistakes are. The trainer is very professional and has a lot of knowledge of the material". - Assessment: 9.6

D. Brothers, Alfa Accountants and Consultants - Transact-SQL Basics - MS SQL Server

"Good training for those who want to have the feeling of understanding sql in 2 days and to be able to work with it with confidence". - Rating: 9.0

T. de Haan, XPO Mijdrecht - Open Learning Form SQL

"An SQL course that can be followed by anyone without any programming experience by means of a piece of theory with subsequent assignments. In small groups allowing personal interaction with the trainer". - Review: 8.8

S. Grootendorst, PSfm B.V. - SQL Base

"You will learn the basics of SQL in a simple way during this training. The exercise fits well with the lesson material." - Rating: 8.6

Wouter Louet, Municipality of Utrecht - Open Learning Form SQL

"All right, a lot of knowledge from the trainer. Good examples. Room for questions." - Rating: 8.0

W.F. de Winter - Administration Microsoft SQL Server 2012 Databases

"Good clear training where the basics of SQL are explained."

- SQL Basis

"It was all explained clearly and enthusiastically. The trainer came across as an expert. We got enough attention, but we were also with a small club. Satisfied expectations. I've achieved my learning goals. It was also a beautiful location (Amsterdam, Muziekgebouw aan 't IJ)". - Rating: 8.0

J. Hensbroek, IDS - SQL Base

"Training largely matched the impression I had from the brochure. Excellent trainer who was clear and straightforward; took into account different levels within the group and divided the ratio theory/exercises very well". - Rating: 8.0

T. Koenraadt, AkzoNobel Decorative Paints - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

"Very well organized training with room for own input." - Assessment: 8.3

Jordy de Groot, Advanced Programs - SQL Continued

"SQL is a language. The training teaches you how to read and understand this language and how to use it to tell a simple story. The location (Amsterdam, Muziekgebouw aan het IJ) was great - top location, with all the necessary facilities, hospitality, a bit of the feeling of home. Learnit Training met my expectations - approachable, good dialogue, no unnecessary waiting time, good information supply, clear". - Assessment: 7.4

K. Gnezda Meijer, Diebold - SQL Base

"Good basic training to get you started with SQL." - Rating: 8.0

Ed Riemens, APG - Open Learning Form SQL

"Good training with an excellent trainer who could give a clear answer to all our questions. Not only theoretical knowledge, but many practical assignments." - Review: 7.6

R. Uters, Efteling - SQL Base

"Thickly satisfied with the content, got a good explanation of the differences between SQLSERVER 2008 and 2012. The trainer was able to empathize with our problems/questions. He knows what he's talking about and he knows how to point out the differences and pros and cons." - Assessment: 8.2

J. Kok, Medical Centre Haaglanden - Administration Microsoft SQL Server 2012 Databases

"It was all explained clearly and enthusiastically. The trainer came across as an expert. We got enough attention, but we were also with a small club. Satisfied expectations. I've achieved my learning goals. It was also a beautiful location (Amsterdam, Muziekgebouw aan 't IJ)". - Rating: 8.0

J. Hensbroek, IDS - SQL Base

"Properly orchestrated, clear explanations, sound teaching material." - Assessment: 8.4

E. van Loon, Amaranth Group - SQL Base

"A good training to learn the basics of SQL. Lots of practical exercises, so you can quickly get to grips with SQL. It was under the guidance of a good trainer who took the time to explain things. Teaches enthusiastically. A social and friendly person. Learnit Training is a professional organization, customer-oriented and has a good and fast service". - Rating: 9.8

C. Verkleij, Central Bureau of Statistics (CBS) - SQL Base

"Great course to start as a layman. You will first get acquainted with the software package after which you will immediately get to work on small assignments. allowing me to create small databases and reports." - Assessment: 7.4

J. Kramer, HC Group - SQL Report Builder

"It's a well-constructed course, which is good to follow even for the absolute beginner. The teacher is passionate, clear and good at answering questions." - Rating: 9.7

N. de Korte, Q-TC Nederland B.V. - SQL Base

"Do you have an affinity with ICT, but no experience with SQL yet, then this course is perfect to learn this". - Review: 8.8

J. Witvoet, S.R.S. B.V. - SQL Base

"Practical training that lays a good foundation for further use/understanding of SQL." - Rating: 9.0

A. Bouman, Denkavit Nederland B.V. - Open Learning Form SQL

"The trainer has a lot of knowledge of the matter. He showed homemade examples, which were very interesting. He was going to fully explain these examples. I learned a lot from this and got motivated." - Assessment: 8.4

Anonymous - Writing queries using Microsoft SQL server 2008 Transact-SQL

"For a good SQL base, this is definitely a training course that is recommended. I also like the way of teaching and practice. What you learn you do immediately to understand it better". - Review: 7.8

M. Amasslam, Quby B.V. - SQL Base

"Had good training with good material. Got the basics of SQL well mastered in two days, it may be advisable to do something to prepare in advance to tackle the topics better and faster. The trainer was open to questions and gave a good explanation". - Review: 7.8

R. Direction Blenke, ProQuro Services - SQL Base

"Good training with which you can do a lot in practice." - Assessment: 8.2

R. Doctor, AM Group - SQL Base

"Got a nice explanation of all the basic principles within SQL and its various dialects. Also highly recommended as a refresher course". - Review: 8.9

Erwin Fox, OFGV - Open Learning Form SQL

"A good training to learn the basics of SQL. Lots of practical exercises, so you can quickly get to grips with SQL. It was under the guidance of a good trainer who took the time to explain things. Teaches enthusiastically. A social and friendly person. Learnit Training is a professional organization, customer-oriented and has a good and fast service". - Rating: 9.8

C. Verkleij, Central Bureau of Statistics (CBS) - SQL Base

"You learn the basic commands to query a database and combine tables. This fitted in perfectly with the issues I encounter in daily practice. I was lucky to meet a class that participated in the training with the same goals. Because of this the pace was high and you didn't have to wait for other students. It is a requirement to have some knowledge of application management and to have questioned databases, so you can translate the content directly into daily practice". - Review: 8.8

P. de Best, Municipality of Westland - SQL Base - Oracle

"I expected basic training that covered writing queries 'from scratch' from A to Z. The training did exactly that. A perfect match." - Rating: 10.0

C. van Lumig. Residence point - SQL Base

"Great course to start as a layman. You will first get acquainted with the software package after which you will immediately get to work on small assignments. allowing me to create small databases and reports." - Assessment: 7.4

J. Kramer, HC Group - SQL Report Builder

"I expected basic training that covered writing queries 'from scratch' from A to Z. The training did exactly that. A perfect match." - Rating: 10.0

C. van Lumig. Residence point - SQL Base