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

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

"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

- SQL Basics - Oracle

Ernst Lesterhuis, Global Knowledge - SQL Base - 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."

"Clear explanations and good commands gave a good picture of the possibilities of SQL." - Rating: 8.0

M. Bessem, Amsterdam Amstelland Regional Police Force - 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

"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 training when you have no knowledge of SQL. You can get right to work with what you've learned." - Rating: 9.0

F. van Nuland, Sevagram - SQL Base

"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

"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

"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

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

Tejasvi Sabale, Mapscape B.V. - SQL Base

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

D. Hoekstra, NLO - SQL Report Builder

"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

"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

"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

"Good balance between listening and practicing. After this course you'll have a good basis to get started." - Rating: 8.0

Peter Berkhout, UWV customer expertise - Querying Microsoft SQL Server (MOC20461)

"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

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

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

"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

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

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

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

J. Green, Kennemerland Police - 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

"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

"This training is a fine refresher for the SQL basics, but also a fine sequel with many useful techniques. The pace is nice. I've been able to bring a lot I can apply in my work."

- SQL Continued

"I'm positive. I don't feel like I'm getting lost in other people's queries. For my job it is not a requirement to make queries, but it is a requirement to make a small adjustment every now and then to generate output". - Assessment: 7.4

J. van de Putte, CIBG - SQL Base

"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

"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

"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

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

E. van Loon, Amaranth Group - 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

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

Geert Jansen, Van Mossel Leasing - Open Learning Form SQL

"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

"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

"Effective training from an experienced trainer with ample knowledge. The trainer was able to switch quickly between people and also focused on the people who needed it without forgetting the others". - Rating: 8.0

J. Heijmink, Norbert Dentressangle - SQL Base

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

H. Vranac-Arapovic, Municipality of Breda - SQL Base

"Learnit has thought along well with the interpretation of the SQL Basic training on location. This was for a small group with different backgrounds and basic knowledge. For the training and the trainer this was no problem at all. The buildup is pleasant and the training continues. There is room for deepening and a big advantage is that you do a lot yourself and discuss it afterwards". - Rating: 8.0

Timo van Limbeek, University of Twente - 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

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

Gerard Teurlinx, Mapscape B.V. - 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

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

Geert Jansen, Van Mossel Leasing - Open Learning Form SQL

"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

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

"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

"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

About Learnit

45137 cursisten in de afgelopen 10 jaar