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

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

learnit SQL Basic

Course Oracle Database: SQL Foundations part II

Do you want to be fully able to write SQL statements independently and build reports with SQL * Plus? Then follow our two day training Oracle database: SQL foundations PART II. In the training we go deeper into the possibilities of SQL. This is where things like timestamps and regular expressions are discussed. The training is a logical sequel to Oracle database: SQL Foundations part I.

Topics

  • Timestamps
  • Reports
  • Additional data definition
  • Special queries
  • Regular expressions.

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.

Prior knowledge

We recommend that you first exercise Oracle Database: SQL Foundations part I Before you get started with this follow-up training.

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 2 days 4 sessions of three hours
Price per day, excl. VAT € 475,- € 390,-
Total, incl. VAT € 1149,50 € 943,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

De cursus Oracle Database: SQL Fundamenten deel II is beoordeeld met een gemiddelde van 7.9.

"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

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

K. Sijne, AB Vakwerk - SQL Base

"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

"The training has given me enough tools to get started with SQL. You gain the experience in practice, but this training gives you enough solid ground underfoot". - Rating: 9.0

B. Angel Heart, Achmea IM&IT - 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

"Highly recommended! Nice informal way to broaden your knowledge."

- Open Learning Form SQL

"Useful in my organization where I work." - Assessment: 6.6

Louis Kamphuis, Beaphar B.V. - Open Learning Form SQL

"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

"The trainer conveyed his knowledge well and clearly. The combination of theory and practice was very pleasant!" - Review: 8.8

P. Biermans, 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

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

S. Greens, Zuidzorg - SQL Base

"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

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

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

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

Ed Riemens, APG - Open Learning Form SQL

"Great training if you want to learn SQL in a solid and structured way. With a lot of practical exercises. The content of the training was fine: clearly laid out, good teaching material including practice assignments, good alternation between theory and practical practice. The knowledge of the trainer is good, as is the way of explaining and conveying it. He puts a good emphasis on structured and solid knowledge building, rather than quick results. Got the questions right." - Rating: 9.0

P. Soemers - SQL Base

"Thanks to the amount of practice and the pleasant way of teaching, this training is extremely suitable for quickly acquiring basic knowledge of SQL". - Review: 8.8

R.C.C.F. Baijens, Kluwer - 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

"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

"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

"Very good training that can be applied in practice."

- SQL Basis

"For me, as a maintenance engineer with above-average MS Access interest, this trainer was reasonable to follow. The content was clear, with practical exercises. Well-balanced." - Rating: 9.0

J.W.M. Pompe, AkzoNobel - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

"Very nice training and organization, very satisfied!" - Rating: 9.0

N. Claessens, UWV - SQL Base

"The trainer conveyed his knowledge well and clearly. The combination of theory and practice was very pleasant!" - Review: 8.8

P. Biermans, CompuGroup Medical (CGM) - 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

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

Jordy de Groot, Advanced Programs - SQL Continued

"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

"For me, as a maintenance engineer with above-average MS Access interest, this trainer was reasonable to follow. The content was clear, with practical exercises. Well-balanced." - Rating: 9.0

J.W.M. Pompe, AkzoNobel - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

"Nice and interesting workout. Clear explanations, examples and assignments. Also nice that the assignments are set as a colleague would set them to you, so you have to think for yourself how you are going to do it. Many functions learned in a short time." - Review: 7.6

Helene Hallebeek, Transavia - Open Learning Form SQL

"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

"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

"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

"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 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 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

"Valuable training with highly skilled trainers, in a pleasant location." - Rating: 8.6

J.J.M. Sanders, Province of Limburg - Oracle Database 10g: SQL foundations part I

"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

"A good basic course in which my knowledge has improved 100%. Good subject matter, quiet pace and excellent assignments. Highly recommended as a basic SQL course." - Assessment: 8.2

R. Wolters, DSV Venlo - 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

"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

"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 course to bet the basics of SQL!" - Rating: 8.0

Paul Bakker, Randstad Nederland B.V. Headquarters - 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

"Thorough basic training that will get you off to a really good start in discovering SQL." - Rating: 9.0

Maria Sijtsma, Care group Treant - 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

"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

"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

"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)

"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

"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

"My first introduction to SQL in this SQL basic training. Good, clear explanation of the fabric. Many exercises to immediately put the material into practice and an enthusiastic trainer make this training a must for anyone who wants to know more about SQL."

- SQL Basis