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

"In this training you will learn the basics of SQL in a simple way. The exercise is well connected to the curriculum. "-Rating: 8.6

learnit Open Learning Form SQL

Course Oracle Database: SQL Statement tuning

In this course, we first provide insight into the internal processing of statements by Oracle. The statistics and the execution plan are then stopped. It also looks at the different tuningmogelijkheden. Here you can think of indexes, joins, bulk operations, hints and various storage techniques. During the course, extensive attention is paid to understanding the execution plan: how should that be read, what do the different steps mean and how can the execution plan be influenced. In addition, attention is also paid to the automatic tuning, as Oracle knows from version 10g. In tuning are not only the loose statements of interest, but also the application as a whole. Here too, attention will be paid to the course.

The course uses SQL Developer and the Enterprise Manager, as well as the command-line tool SQL * Plus. The course is platform independent.

The course is suitable for everyone involved in improving the performance of the applications (application builders, System developers and database administrators). This course is suitable for both version 9i, 10g and 11g of the Oracle database. The 11G2 new features are also covered.

Each participant will have its own database to be able to practise extensively with the theory offered. During these exercises, attention is also paid to improving statements.

Each participant receives the book Troubleshooting Oracle Performance by Christian Antognini.

Target

This course is intended for anyone who wants to gain insight into the performance of SQL statements on an Oracle database.

Topics

The course Oracle database: SQL Statement Tuning covers the following topics:

  • Introduction
  • Processing SQL Statements
  • The query optimizer: statistics
  • The query optimizer: execution plan
  • Introduction indexes
  • Use and maintenance of indexes
  • Joins and collations
  • Storage techniques
  • Bind variables and bulk operations
  • Plan stability
  • The query optimizer: administration statistics
  • End-to-end application tracing
  • Automatic statement tuning
  • Tips and Tricks

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

Open registration, per person, including course material and lunch:


Duration

4 days

Price per day (excl. VAT)

€ 490,-

Subtotal

€ 1960,-

VAT 21%

€ 411,60

Total Incl. vat

€ 2371,60

Certificate

After completing the training, a LEARNIT certificate will be issued as proof of participation.


References

De cursus Oracle Database: SQL Statement tuning is beoordeeld met een gemiddelde van 7.9.

"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

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

"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

"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

"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

"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

"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

"Good clear training where the basics of SQL are explained."

- SQL Basis

"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

"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

"Never been to a course/training before and the training with everything around it was actually above my expectations." - Assessment: 8.2

M. Goedhart, Duynie Holding B.V. - 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

"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

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

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

"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

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

K. Sijne, AB Vakwerk - SQL Base

"Fine, short and yet complete basics course."

- SQL Basis

"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

"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

"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

"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

"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

"Good training with which you can do a lot in practice." - Assessment: 8.2

R. Doctor, AM Group - SQL Base

"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

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

- SQL Basis

"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

"Briefly and clearly. Lestempo good and to follow. Practical exercises instead of theoretical assignments. The trainer had attention for everyone. Personal and always asking if the material is still understandable. Expert enough and honest about their own knowledge. Learnit Training is professional and service-oriented". - Review: 7.6

T.M. Mingoen, Cobalt - MS SQL Server 2005 Querying

"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

"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

"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 nice training and organization, very satisfied!" - Rating: 9.0

N. Claessens, UWV - 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

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

- SQL Basis

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

K. Sijne, AB Vakwerk - SQL Base

"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

"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 training with which you can do a lot in practice." - Assessment: 8.2

R. Doctor, AM Group - 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

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

- 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

"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

"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

"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

"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

"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

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

N. Claessens, UWV - SQL Base

"Great training. Excellent teacher" - Rating: 9.0

Ernst Lesterhuis, Global Knowledge - SQL Base - Oracle