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

"Nice explanation of all the basic principles within SQL and its various dialects. Also as a refresher course very advisable! "-Rating: 8.9

learnit Open Learning Form SQL

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
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 organiseren deze training ook online. Hiervoor maken we gebruik van Webbex of Zoom. Inloggen met Skype is ook mogelijk. Op verzoek kan deze training ook met Microsoft Teams worden georganiseerd.

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.

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

- SQL Basis

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

Geert Jansen, Van Mossel Leasing - Open Learning Form SQL

"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

"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

"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

"The SQL training provides insight into creating queries from databases. During the lessons you will learn how to build a query. During the lessons the theory is first discussed and then carried out with a practical assignment. This is very fun and educational." - Rating: 9.0

G.J. Leferink, Elementis Delden - SQL Base

"The SQL training provides insight into creating queries from databases. During the lessons you will learn how to build a query. During the lessons the theory is first discussed and then carried out with a practical assignment. This is very fun and educational." - Rating: 9.0

G.J. Leferink, Elementis Delden - SQL Base

"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

"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

"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

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

- SQL Basis

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

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

"SQL Basis was an excellent training and directly applicable in practice. The trainer is friendly and patient and open. He certainly has knowledge and enjoys being challenged by his students." - Assessment: 8.4

M. Sybesma, GGZ River Dunes, - Transact-SQL Basics - MS SQL Server

"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

"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

"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

"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

"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

"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

"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

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

S. Greens, Zuidzorg - 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

"Clear explanation of SQL with lots of useful examples and good exercises. It was all good to do and after attending this basic training I gained more than enough knowledge to perform all necessary queries on our database. And that yielded a lot of useful information. In short: Excellent training! - Review: 8.8

V. Young, Kyocera Document Solutions Nederland B.V. - SQL Base

"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

"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

"Great training. You really get the basics! The trainer was very enthusiastic and gave the training in a fun way". - Rating: 8.0

H. Wennink, Province of Overijssel - SQL Base

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

- SQL Basis

"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

"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

"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

"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

"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

"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

"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

"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

"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

"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

"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

"Great training. You really get the basics! The trainer was very enthusiastic and gave the training in a fun way". - Rating: 8.0

H. Wennink, Province of Overijssel - SQL Base

"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

"SQL Basis was an excellent training and directly applicable in practice. The trainer is friendly and patient and open. He certainly has knowledge and enjoys being challenged by his students." - Assessment: 8.4

M. Sybesma, GGZ River Dunes, - Transact-SQL Basics - MS SQL Server

"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

"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

"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

"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

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

Eveline Horbach, Sorgente - Open Learning Form SQL

"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