Learnit Training
Course SQL Basic
  • You learn to easily retrieve all data from the database
  • Suitable for SQL Server, ORACLE, MS Access, PostgreSQL and MySQL databases
  • Modify, manipulate and adapt SQL data and table structures
  • Small group
  • Very experienced teacher

Would you like to easily modify or retrieve data from a database? Then use SQL (Structured Query Language). Also learn how to work with this standardized query language.

Yes, I want to know more

"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

learnit SQL Basic

Course SQL Basic

If you want to easily retrieve data from a relational database, you can use SQL (structured Querylanguage). In addition, you can modify, manipulate, and modify table structures with SQL data. SQL is widespread and is often used in combination with other programming languages such as PHP, ASP and VBA. ANSI SQL is the most popular standardized database language and is now no longer to be thought of when using relational databases. ANSI SQL can be used for querying MS SQL Server, ORACLE, MS Access, PostgreSQL and MySQL databases. Because ANSI SQL is standardized, it can be used with almost all modern relational databases.

In our two-day training SQL Base you will develop knowledge and skills in the FIELD of SQL. Under the guidance of an experienced database trainer, you will actively get to work on creating queries. After this training you have mastered the basics of SQL and can easily create queries to retrieve data.

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 Filters (AND, OR, IN NOT)
  • Filter using wildcards (LIKE)
  • Calculated fields (Concateneren)
  • Customizing data with Functions (ROUND, LTRIM, RTRIM, DATE PART)
  • Summarize data (COUNT, SUM, AVG, MAX, MIN)
  • Grouping data (GROUP BY, HAVING)
  • Working with subqueries (IN)
  • 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)
  • Differences in SQL between database systems

Target

The training is intended for users of relational databases (e.g. Microsoft SQL Server, ORACLE, Microsoft Access, MySQL, Apache OpenOffice Base, IBM DB2, PostgreSQL, SAS and SQLite). The training is suitable for both novice database users and functional administrators and data analysts.

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

No prior knowledge is required for this training.

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 SQL Basic course has been assessed with an average of 8.4.

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

- SQL Basis

"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

"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

"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

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

R. Doctor, AM Group - SQL Base

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

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

"it's a very good basis, to start working with SQL right away." - Review: 7.8

T. Crane - SQL Base

"Without much programming experience, I learned a lot from SQL these two days. If you then look at what query you can make at the end of the second day, you'll actually see the progress you've made during those two days. The trainer paid attention to everyone and he took plenty of time for that". - Rating: 8.0

J. Blow, A.S.R. Insurances - 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

"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

"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

"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

"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

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

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

"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

"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

"Nice and very applicable training, you can really use it and you can put it into practice right away. Highly recommended." - Rating: 8.0

N.J.G. Cairo-Pol, Diabetes Care System WF - 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

"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

"Very easy to follow especially for people who want to start with SQL. Suitable for both IT and non-IT professionals. Highly recommended!" - Assessment: 7.4

M. Thakoer, NN Group N.V. - SQL Base

"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

"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

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

- SQL Basis

"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

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

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

"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

"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

"The training is very instructive, in which you learn the skill to query databases in a short period of time. The good atmosphere of the training stimulates the creativity, which makes learning almost self-evident. The training doesn't cost energy, but provides energy". - Review: 7.8

R. Schoonenberg, Agency EN - SQL Base

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

K. Sijne, AB Vakwerk - 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

"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

"Fine, short and yet complete basics course."

- SQL Basis

"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

"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

"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

"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

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

- SQL Basis

"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

"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

"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

"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

"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

"A training in an informal atmosphere, where personal contact is paramount. In this way, everyone can take in the dust at their own pace and there is enough room to achieve your goals". - Assessment: 8.2

J. Koopmans, Roba Mentals B.V. - 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

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

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