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

"You will learn the basic commands to query a database and combine tables. This was a great answer to the issues I encounter in daily practice. I was fortunate to find a class that took part in the training with the same goals. As a result, the tempo 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 databases, so that you can also translate the content directly into daily practice. "-Rating: 8.8

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.

"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

"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

"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

"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

"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

"Without much programming experience, I learned a lot from SQL these two days. If you then look at what query you can make at the end of the second day, you'll actually see the progress you've made during those two days. The trainer paid attention to everyone and he took plenty of time for that". - Rating: 8.0

J. Blow, A.S.R. Insurances - SQL Base

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

J. Green, Kennemerland Police - SQL Base

"The training was given at a good pace, and the students were able to come along well. It was not a large group, so there was enough room for the individual. The material was in a logical order, so that by continuing in the training you kept repeating the basics well, so that it stays up to date."

- SQL Basis

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

T. Crane - SQL Base

"SQL Basic is a nice training, which I can recommend. Skilled teacher, good lunch, learned a lot in 2 days! Now apply it in practice..." - Review: 7.9

Hetty Mattaar, The Water Board House (Information House Water) - Open Learning Form SQL

"I was very pleased with the design and execution of this course. A good balance was sought in the difference in tempo of the students. It was clearly explained with a good balance between making exercises together when doing them yourself". - Assessment: 8.4

J. Esseling, Zorgon 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

"A 2-day training that met my expectations and enabled me to successfully apply what I learned in daily practice. By alternating theory and practice, the knowledgeable trainer was able to keep the training lively and captivate our mixed company until the end. This in a good location with excellent course material for this training". - Assessment: 8.4

Charles Slierendrecht, Municipality of Maastricht - 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

"The SQL Basic course at Learnit is highly recommended. Personal attention, care of the teaching material and training are in one word great. I have been able to learn a lot in 2 days. It offers a great foundation to further grow into a professional super user if you want to go to a higher level". - Review: 8.7

Tim Engelhart, Central Management Achmea - Open Learning Form SQL

"I'd recommend this traning to people who've never worked with SQL, it's fine for this." - Assessment: 7.5

Ron Derks, Office Depot Europe BV - Open Learning Form SQL

"Training at a good pace. Pleasant alternation between plenary treatment of the substance and making individual exercises. Good price/quality ratio if you want to work with sql in practice". - Assessment: 8.4

B. Willemse. Capter - 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 course lives up to the content and teaches you the basic skills for SQL in a short period of time." - Review: 7.6

Arnaud Milder, Radboud University Medical Center - Open Learning Form SQL

"Good starting point for mastering SQL." - Review: 7.7

Gerard Teurlinx, Mapscape B.V. - SQL Base

"Basic hands-on training. So you go straight to work with what you've learned. Some foreknowledge is useful" - Review: 7.7

Daniëlle van Dijk, TimeTell B.V. - SQL Base

"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

"A training that will bring you up to a level within two days, with which you will then be able to work in practice yourself. The content of the training fitted in very well with my expectations. I've now mastered the basics of the SQL language." - Assessment: 8.2

P. Willems, Zorgon B.V. - SQL Base

"Good course to bet the basics of SQL!" - Rating: 8.0

Paul Bakker, Randstad Nederland B.V. Headquarters - SQL Base

"This training has a clear structure and structure. In addition to theory, there is plenty of room to practice and present practical situations to the trainer. Quiet, qualified and clear trainer. Knew what he was talking about and how the training works. All in all, a good way to get started with SQL." - Rating: 8.6

R. Kemmenaar, Triage-IT - SQL Base

"Practical course in which a user/information analyst quickly learns how to unlock (relational) databases using the basic principles of SQL". - Assessment: 8.1

Arthur Wagenaar - Open Learning Form SQL

"Definitely recommended if you work with SQL. Techniques not previously known to me I learned during this training." - Rating: 10.0

A. Puijn, DSV Venlo - SQL Base

"You get value for money. And goes away with the knowledge to write your own SQL statements." - Rating: 10.0

D. Knijnsberg, Municipality of Purmerend - SQL Base

"Good training. Very clear and applicable. You learn all the facets of SQL." - Rating: 8.6

K. Sijne, AB Vakwerk - SQL Base

"Good training to take the first step towards SQL connoisseur." - Review: 7.7

Geert Jansen, Van Mossel Leasing - Open Learning Form SQL

"The training was given at a good pace, and the students were able to come along well. It was not a large group, so there was enough room for the individual. The material was in a logical order, so that by continuing in the training you kept repeating the basics well, so that it stays up to date."

- SQL Basis

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

Jordy de Groot, Advanced Programs - SQL Continued

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

Ed Riemens, APG - Open Learning Form SQL

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

Ed Riemens, APG - Open Learning Form SQL

"Good clear training, really for building reports for beginners." - Rating: 9.0

D. Hoekstra, NLO - SQL Report Builder

"This is a good training to learn the basics of SQL. It is useful for understanding if you already know something about databases/files. SQL knowledge is already indispensable in a number of programming languages". - Rating: 9.8

P. Anuels, Praclox - SQL Base

"A 2-day training that met my expectations and enabled me to successfully apply what I learned in daily practice. By alternating theory and practice, the knowledgeable trainer was able to keep the training lively and captivate our mixed company until the end. This in a good location with excellent course material for this training". - Assessment: 8.4

Charles Slierendrecht, Municipality of Maastricht - Open Learning Form SQL

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

Ed Riemens, APG - Open Learning Form SQL

"A 2-day training that met my expectations and enabled me to successfully apply what I learned in daily practice. By alternating theory and practice, the knowledgeable trainer was able to keep the training lively and captivate our mixed company until the end. This in a good location with excellent course material for this training". - Assessment: 8.4

Charles Slierendrecht, Municipality of Maastricht - Open Learning Form SQL

"After doing this training I got a very good impression of SQL and the possibilities. I immediately developed ideas about applications in my own working environment and those of others. We are familiar with SQL, but only after the basics are clear you will learn to understand what you can do and how to do it. This training was perfect for that." - Assessment: 8.2

A. Ruijter, Tommy Hilfiger Europe B.V. - SQL Base

"Learnit is a professional organization with a personal approach. The SQL course was well attuned to the entry level and the instructor skilfully and with great pleasure guided us through the material. Class!" - Review: 8.7

Shanna Wielinga, UWV Customer expertise - Querying Microsoft SQL Server (MOC20461)

"Got refreshed with my sql skils" - Rating: 6.0

Tejasvi Sabale, Mapscape B.V. - SQL Base

"The training is interactive... Within two days you will have a clear picture of the possibilities of SQL". - Assessment: 9.2

C. de Wolff, The Dutch Central Bank - Open Learning Form SQL

"Super instructive, step-by-step built and easy to understand for people who don't know about it yet."

- SQL Basis

"The training is ideal for people who have never been in contact with SQL before. The possibilities of SQL are well and clearly explained. This is a good basic training. If you already apply SQL regularly, I recommend advanced training." - Rating: 8.6

R. Arentsen, I-Real - 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

"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

"The SQL Basic course at Learnit is highly recommended. Personal attention, care of the teaching material and training are in one word great. I have been able to learn a lot in 2 days. It offers a great foundation to further grow into a professional super user if you want to go to a higher level". - Review: 8.7

Tim Engelhart, Central Management Achmea - Open Learning Form SQL

"Challenging, especially since it was possible to tune in to the level of the students on the spot." - Assessment: 7.4

M. Spring Camp, Magna Carta - SQL Base