Learnit Training
Course Oracle Database: SQL Foundations part I
  • Small groups
  • Covid-19 safe
  • Experienced teacher
  • Possible online
  • Practical training

Are you looking for a training in which you learn to write SQL statements independently, which can be executed with SQL Developer? Then this training fits in with your learning goals. Suitable for database administrators, application developers or other automators who are going to work with (Oracle) SQL.

Yes, I want to know more

"Good relationship between presentation and self-assignments. Good variation in the level of difficulty of the assignments, there were some nice challenging. The trainer had a lot of knowledge and explained how you can address a problem in a structured way. "-Rating: 8.8

learnit Oracle Database: SQL Foundations part I

Course Oracle Database: SQL Foundations part I

SQL is the question language that enables communication with a relational database. Communication with an Oracle database is done using Oracles implementation of the language SQL, namely SQL Developer. In our four-day training Oracle database: SQL Foundations part I Use this interaction tool to communicate with an Oracle database.

First we give an introduction in Oracle and the different tools. Then we will go into SQL and Oracle SQL in particular, paying extra attention to the structured writing of SQL statements. After the training, you will be able to write SQL statements, which can be executed with SQL Developer, completely independently.

Topics

  • Introduction to Relational databases
  • Introduction to Oracle
  • Introduction to SQL Developer
  • Data definition
  • Select statement
  • Group
  • Data manipulation
  • Editing characters
  • Features
  • Joins, Outer joins, ANSI joins
  • Subselections, nested and correlated subselections
  • Using SET Operators
  • SQL * Plus

Target

This training is intended for database administrators, application developers, or other specialists that will work with (Oracle) SQL.

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. The material is modular; Each chapter starts with a theoretical part, which is passed on by each participant in his own temo. It uses hands-on examples. Because you are actively engaged in the theory, it beklijft better. Ambiguities or questions are personally explained by the trainer. In addition to speaking the assignments, the trainer can give additions and answer specific questions, for example from your work situation. To guarantee personal attention, we accompany up to eight participants per group.

Note

Version-dependent features are specifically identified, making this training suitable for different versions of Oracle.

Lesvorm

This training is offered on the basis of our Open learning form-teaching method. This means that under the active supervision of our trainer, you are working independently to make your own substance. You can achieve your learning goals at your own pace without being bothered by a faster or slower pace of your fellow students. The trainer will ensure that you stay on track and achieve your learning goals. This form of learning offers space for customised work. You will have the opportunity to create examples from your own practice and IT environment that will make you more specific. more...

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 4 days 8 sessions of three hours
Price per day, excl. VAT € 475,- € 390,-
Total, incl. VAT € 2299,- € 1887,60

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.

Groningen Tuesday 28 July 2020, 10:00-17:00

  • 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 Oracle Database course: SQL Fundamentals part I has been evaluated with an average of 7.9.

"The training is a good stepping stone to continue in SQL. The training will certainly contribute to the more effective performance of work on our Oracle database". - Rating: 7.0

R. Speelmans, Enexis - Oracle Database: SQL Fundamentals part I

"Good relationship between presentation and doing assignments yourself. Good variation in the level of difficulty of the assignments, there were some nice challenging ones. The trainer had a lot of knowledge and explained well how to tackle a problem in a structured way". - Review: 8.8

S. Rodewijk, NUON - Oracle Database: SQL Fundamentals part I

"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

"Practically applicable in my own work organization." - Assessment: 8.4

S. Greens, Zuidzorg - SQL Base

"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

"Great course where the full basics are explained, trainer can also discuss issues that are not within the scope of the course". - Rating: 8.0

A. Reuijl, Grant Thornton - SQL Base

"My main learning goal was to be able to read and understand queries/scripts better. By writing your own scripts and getting acquainted with a number of possibilities of SQL, this learning objective was certainly achieved. By practicing some scripts yourself, you get some insight and a principle. You have to do something with them yourself and practise at work or at home. Then the dexterity will certainly come". - Review: 7.6

Han Bennink, AFAS Software B.V. - Open Learning Form SQL

"Good training. Good to follow. The content met my expectations. The transfer of knowledge took place in a very pleasant manner." - Rating: 9.0

Ton van der Velden, Rijkswaterstaat (RWS) - SQL Base

"Training is given on a topic-by-item basis. The number of exercises is discussed, after which you go to work yourself and speak it through. The method appealed to me because of its clarity."

- Open Learning Form SQL

"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

"Excellent training with a lot of information realized by experienced and professional teachers. I wish it lasted longer, so I could learn even more that I did. I recommend it without any hesitation. Learnit Training is a professional company, they are doing what they promise. Their teachers are profesionals who know what they are talking about." - Assessment: 9.2

D. Szalobryt, Syncreon Netherlands N.V. - SQL Base

"Nice training that's gonna help you a lot if you want to work with SQL." - Assessment: 8.4

R. de Munck, Municipality of Amersfoort - SQL Base

"This training is ideal for people who are going to work with SQL databases. A lot is explained, tempo is never too low. All kinds of queries are dealt with, as well as the cross use of types. Recommended!" - Assessment: 8.2

J. the Great, Kemira - 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

"The trainer is extremely knowledgeable and knows how to maintain the often dry substance. Leave it that way, then! Everything was pleasant and quickly arranged by Learnit Training!" - Assessment: 8.2

H. Kalsbeek, Synovate - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

"Good training. Good to follow. The content met my expectations. The transfer of knowledge took place in a very pleasant manner." - Rating: 9.0

Ton van der Velden, Rijkswaterstaat (RWS) - SQL Base

"The contents met my expectations. Gaining basic knowledge of SQL. The trainer had a lot of knowledge and also gave a lot of good tips". - Assessment: 8.4

W. Cook, Rolec - Oracle Database 10g: SQL foundations part I

"Great training for beginners who already have a little bit of experience with SQL, the type of SQL you use yourself is reasonably taken into account (indicate this to the organization in advance, then you may receive a different textbook). In the training, it really stays with the basics." - Assessment: 7.3

Kelly de Kuyper, Pluriplus / Pluripharm - SQL Base

"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

"This basic training met my expectations. The teacher was knowledgeable and relaxed, with sufficient individual attention if necessary". - Assessment: 8.2

A. Arkeraats, ANWB - Transact-SQL Basics - MS SQL Server

"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

"E. van Herijnen - "Positive impression. Good location, training, exercise material and applicability in practice." - Rating: 7.2"

- SQL Basis

"The SQL course was very instructive. The course was brought in a fun way by a trainer who has a lot of knowledge. All the basic functions of SQL have been offered step by step so that I can certainly continue with them within my company". - Rating: 8.6

Nicky Tulip, ENOT bv - Open Learning Form SQL

"Good trainer, enough training material. I've achieved my initial goals." - Assessment: 8.4

H. Vranac-Arapovic, Municipality of Breda - 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

"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

"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

"Very practical training where you learn to work directly with SQL. No long, dry sessions, but just get started immediately after a short introduction. That combined with a trainer who knows what he's talking about, makes it possible to type out the first queries in no time". - Assessment: 8.1

Erik Mol, Scania Production Zwolle B.V. - Open Learning Form SQL

"Training is very practice-oriented. Clear explanations and many relevant exercises." - Review: 8.7

Jan Rensen, Shell Pensioenbureau Nederland B.V. - 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

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

E. van Loon, Amaranth Group - SQL Base

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

E. van Loon, Amaranth Group - SQL Base

"This trainer is a very knowledgeable person who communicates the material of the training to the participants in a calm, well-considered and thorough way.

- SQL Basis

"It was a tough workout, where a lot was treated in two days. It was a great training!" - Review: 7.8

P. Janssen, Ministry of Defence - SQL Base

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

Tejasvi Sabale, Mapscape B.V. - SQL Base

"Recommended for people with little SQL-knowledge, in 2 days the base is fine!" - Assessment: 8.4

W. de Rijke, Delta Energy B.V. - SQL Base

"By gaining basic knowledge of SQL across the board, it helps me in practice to create simple queries and to be able to read and modify more extensive queries. That's exactly what I was looking for. What certainly makes a difference is that the small scale is tailored to the participants". - Assessment: 8.4

J. Citizens, Municipality of Haarlemmermeer - SQL Base

"If the preparations are good and tailored to the organization (type/type) of the client, this can be an excellent course for most essential SQL statements". - Review: 6.7

John van Enst, Municipality of Groningen - SQL Continued

"At Learnit, they continue to learn from their own lessons. What a top course!"

- SQL Basis

"Excellent training for basic queries. A clear book with good examples and good structure, the trainer is very skilled. Kept the attention by his way of explaining. Clarifying explanation." - Assessment: 8.2

Anonymous - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

"Content was good. We had requested a training to learn the new features / approaches in SQL server 2012. So we had largely determined the content ourselves. The trainer had handled this well and had clearly explained for each part what has changed / new and how to deal with it and gave examples for each part". - Assessment: 7.4

Mr. van Leeuwen - Administration Microsoft SQL Server 2012 Databases

"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

"Connect very well to the step to being able to see and use SQL. For my work, we're going to have more to do with SQL. For this I needed more insight into SQL from the function of functional administrator. And this has worked out well with the professional training of Learnit Training. This is already my second Learnit training. Given the very wide range of training, I think it will not have been the last". - Rating: 9.0

H. van den Driesche, Evides - SQL Base

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

- SQL Basis

"Great course where the full basics are explained, trainer can also discuss issues that are not within the scope of the course". - Rating: 8.0

A. Reuijl, Grant Thornton - SQL Base

"This basic training gives a good overview of what SQL is and what you can do with it. Using a logical structure, you can move from a very simple query to a very sophisticated in-depth query in two days."

- SQL Basis

"The training exceeded my expectations, highly recommended. The trainer had a lot of knowledge."

- SQL Report Builder

"Practically applicable in my own work organization." - Assessment: 8.4

S. Greens, Zuidzorg - SQL Base

"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

"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