Learnit Training
Course SQL Training E-learning
  • Learn SQL to obtain data from a relational database.
  • Use SQL to run reports and write SQL queries to retrieve data from tables.
  • After following the SQL-online course, you will build applications and write SQL queries.
  • Learn everything about SQL in 16 hours through videos, lectures, quizzes and exercises.
  • The e-learning course SQL will be accessible for one year after activation.

This SQL training is intended for students who have no previous experience with writing SQL queries. SQL is mainly used for building applications and querying/generating business reports. Almost all knowledge and commands in this course apply to all major databases. In the special cases where there are differences between the databases, this will be pointed out.

Yes, I want to know more

"Followed the Report Builder training. Enthusiastic instructor, who was able to share his professional knowledge with us in a pleasant manner. During the day we could use good exercises, with excellent lesson structure. Learned a lot, optimal result with useful presentation as reference work." - Rating: 8.8

learnit SQL Report Builder

Course SQL Training E-learning

Use SQL to retrieve data from a relational database

In this e-learning course SQL, you will learn how to easily retrieve data from a relational database using the query language SQL (Structured Query Language). SQL was developed in the 1970s and there have been many SQL versions since then. In the 1980s, SQL was standardised. Of course, several renovations of the program followed and will follow. SQL allows you to modify, manipulate data and change table structures. SQL is widespread and its use is often in combination with other programming languages, such as PHP, ASP and VBA. In this online course, you will learn the basic variant of SQL and we will explain the possible differences with for example Oracle SQL or another relational database.

SQL uses so-called queries for communication with the DBMS (Data Base Management System). A query is an ASCII character string and a command that is sent to the DBMS. The DBMS will interpret and execute the command and possibly send data back to the program. SQL is not imperative but declarative and is a fourth generation language.

The content of the SQL e-learning course

The content of the English online course consists of various videos, lectures, quizzes and exercises. It takes about 16 hours to go through everything. If you want to look back at certain subjects afterwards, you can. After activating your training, you will have access to all content for another year. It is possible to go through this e-learning at your own pace. You will learn to understand how relational databases work, how to use SQL to execute reports and how to write SQL queries to retrieve data from multiple tables.

Topics of the SQL online course

Introduction to relational databases
  • History of SQL
  • Relational database
  • Tables
  • Popular databases
  • SQL statements
Simple SELECT
  • Introduction to Northwind database
  • Select columns and rows
  • Sorting of records
  • The "Where" clause
  • Boolean operators
Advanced SELECT
  • Performing calculations
  • Selecting records
  • Built-in data manipulation functions
Subqueries, Joins and Unions
  • Subqueries
  • Joins
  • Outer joins
Conditional processing with CASE
  • Use of Case

Results of the online SQL course

After completing the online SQL course, you will know the history of SQL, how to write SQL queries, create table rows and columns, perform calculations, select records, know the built-in data manipulation functions and be able to run reports. All the knowledge you have gained and the tasks you have performed apply to all major databases.

Prior knowledge

No specific prior knowledge required.

Note

This is an e-learning course in the English language. The self-paced courses are our affordable alternative for students seeking the flexibility to learn at their own pace. The content is delivered online using videos, quizzes and exercises. The courses are written by expert instructors.

Investment

E-learning, per person:


Price (excl. VAT)

€ 100,-

VAT 21%

€ 21,-

Total incl. VAT

€ 121,-

References

The course SQL Training E-learning has been assessed with an average of 8.4.

"Followed the Report Builder training. Enthusiastic instructor, who was able to share his professional knowledge with us in a pleasant manner. During the day we could use good exercises, with excellent lesson structure. Learned a lot, optimal result with useful presentation as reference work." - Rating: 8.8

M. Sanders. GGD Brabant-Zuidoost - SQL Report Builder

"After doing this training, I got a very good impression of SQL and its possibilities. I immediately developed ideas about applications in my own work environment and that of others. We know SQL, but only after the basics are clear do you learn to understand what you can and how to do it. This training was perfect for that." - Rating: 8.2

A. Ruijter, Tommy Hilfiger Europe B.V. - SQL Basics

"Theory and practice (doing exercises yourself) in the right proportion. Very good training. Professional trainer. Pace of the training is right." - Rating: 8.8

C. Bogaards, T-Mobile - SQL Basics

"A training that brings you to the next level in two days, which you can then put to use in practice. The content of the training matched my expectations very well. I have now mastered the basics of the SQL language." - Rating: 8.2

P. Willems, Zorgon B.V. - SQL Basics

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

N. Claessens, UWV - SQL Basics

"This training gives you an even better idea, what you can do with SQL and how you can apply what you have learned. Highly recommended." - Rating: 8.1

Jurgen Koopmans, Roba Metals BV - SQL Follow-up

"Good training if you have no knowledge of SQL. You can immediately get to work with what you have learned." - Rating: 9.0

F. van Nuland, Sevagram - SQL Basics

"The training exceeded my expectations, highly recommended. The trainer was very knowledgeable."

- SQL Report Builder

"The trainer is extremely knowledgeable and knows how to present the often dry material in an entertaining way. Let's keep it that way! Everything was arranged pleasantly and quickly by Learnit Training!" - Rating: 8.2

H. Kalsbeek, Synovate - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

"Clear explanation of SQL with many useful examples and good exercises. It was all very easy to do and after following this basic training, I have more than enough knowledge to carry out all the necessary queries on our database. And that has provided a lot of useful information. In short: excellent training! - Rating: 8.8

V. Young, Kyocera Document Solutions Netherlands B.V. - SQL Basics

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

"Without much experience in programming, I learned a lot about SQL during these two days. If you then look at the query you can make at the end of the second day, you can really see the progress you have made during those two days. The trainer paid attention to everyone and he took his time. - Rating: 8.0

J. Blaas, A.S.R. Insurance - SQL Basics

"With this training you will learn in 2 days what SQL is, how to use it and what are the well-known mistakes made. The trainer is very professional and has a lot of knowledge of the subject matter." - Rating: 9.6

D. Gebroers, Alfa Accountants and Advisors - Transact-SQL Basis - MS SQL Server

"The training is interactive. Within two days you have a clear picture of the possibilities of SQL". - Rating: 9.2

C. de Wolff, De Nederlandsche Bank - Open Learning SQL

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

M. Bessem, Amsterdam Amstelland Police Force - SQL Basics

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

- SQL Basics

"The trainer is extremely knowledgeable and knows how to present the often dry material in an entertaining way. Let's keep it that way! Everything was arranged pleasantly and quickly by Learnit Training!" - Rating: 8.2

H. Kalsbeek, Synovate - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

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

Tejasvi Sabale, Mapscape B.V. - SQL Basics

"Training largely corresponded to the impression I had from the brochure. Excellent trainer who was clear; took into account different levels within the group and distributed the theory/exercise ratio very well." - Rating: 8.0

T. Koenraadt, AkzoNobel Decorative Paints - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

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

Erwin Vos, OFGV - Open Learning SQL

"Connects very well with the step up to being able to view and use SQL. For my work, we are going to have to deal more with SQL. For this, I needed more insight into SQL from the position of functional administrator. And this has succeeded well with the professional training of Learnit Training. This is already my second Learnit training. Given the very wide range of training courses, I think it will not have been the last." - Rating: 9.0

H. van den Driesche, Evides - SQL Basics

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

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

"This is a good training to learn the basics of SQL. It is helpful for understanding if you already know something about databases/files. In a number of programming languages SQL knowledge is already indispensable." - Rating: 9.8

P. Anuels, Praclox - SQL Basics

"My main learning objective was to be able to read and understand queries/scripts better. By writing scripts myself and getting to know a number of SQL possibilities, this learning objective was certainly achieved. By practising some scripts yourself, you already get some insight and a principle. You have to do something with it and practise at work or at home. Then you will definitely get the hang of it." - Rating: 7.6

Han Bennink, AFAS Software B.V. - Open Learning SQL

"If you have an affinity with ICT but no experience with SQL, then this course is perfect for learning this." - Rating: 8.8

J. Witvoet, S.R.S. B.V. - SQL Basics

"Well-orchestrated, clear explanations, sound teaching materials." - Rating: 8.4

E. van Loon, Amarant Group - SQL Basics

"If the preparations are good and tailored to the customer's organisation (type/type), this can be an excellent course for most essential SQL statements." - Rating: 6.7

John van Enst, Municipality of Groningen - SQL Follow-up

"The trainer is extremely knowledgeable and knows how to present the often dry material in an entertaining way. Let's keep it that way! Everything was arranged pleasantly and quickly by Learnit Training!" - Rating: 8.2

H. Kalsbeek, Synovate - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

"Very good course for beginners, but definitely also a refresher for the slightly more experienced." - Rating: 8.6

Monique van de Wetering, Greenspans B.V. - Open Learning SQL

"Good training if you have no knowledge of SQL. You can immediately get to work with what you have learned." - Rating: 9.0

F. van Nuland, Sevagram - SQL Basics

"This training has a clear structure and build-up. In addition to the theory, there is plenty of room to practice and present practical situations to the trainer. Calm, qualified and clear trainer. Knew what he was talking about and how the training was structured. All in all a good way to make a start with SQL." - Rating: 8.6

R. Kemmenaar, Triage-IT - SQL Basics

"Short and clear. Learning pace good and easy to follow. Practical exercises instead of theoretical assignments. The trainer paid attention to everyone. Personal and always asking if the material is still understandable. Expert enough and honest about own knowledge. Learnit Training is professional and service minded." - Rating: 7.6

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

"Good training which you can use a lot in practice." - Rating: 8.2

R. Arts, AM Group - SQL Basics

"A 2-day training that met my expectations and enabled me to successfully apply what I had learned in daily practice. The skilful trainer knew, by alternating theory and practice, to keep the training lively and to captivate our mixed group until the end. This in a good location with for this training excellent course material." - Rating: 8.4

Charles Slierendrecht, Municipality of Maastricht - Open Learning SQL

"Good training for those who want to understand sql in 2 days and be able to work with it with confidence." - Rating: 9.0

T. de Haan, XPO Mijdrecht - Open Learning SQL

"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. This was no problem at all for the training and the trainer. The structure is pleasant and the training runs smoothly. There is room for deepening and a big advantage is that you do a lot yourself and discuss afterwards." - Rating: 8.0

Timo van Limbeek, University of Twente - SQL Basics

"I was expecting a basic training that would cover the writing of queries from scratch. The training did exactly that. A perfect match." - Rating: 10.0

C. van Lumig. Woonpunt - SQL Basis

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

N. Claessens, UWV - SQL Basics

"The course lives up to the content and teaches you the basic SQL skills in a short time." - Rating: 7.6

Arnaud Milder, Radboud University Medical Centre - Open Learning SQL

"The trainer is extremely knowledgeable and knows how to present the often dry material in an entertaining way. Let's keep it that way! Everything was arranged pleasantly and quickly by Learnit Training!" - Rating: 8.2

H. Kalsbeek, Synovate - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

"The trainer was very good and the teaching materials clear. The pace of the training was manageable and the assignments offered just enough challenge."

- Open Learning SQL

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

Gerard Teurlinx, Mapscape B.V. - SQL Basics

"Good training if you have no knowledge of SQL. You can immediately get to work with what you have learned." - Rating: 9.0

F. van Nuland, Sevagram - SQL Basics

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

M. Goedhart, Duynie Holding B.V. - SQL Basics

"This is an instructive training for both beginners and advanced students, which is given in an interactive way. This is very pleasant, because you can immediately apply it while making 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 Basics

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

"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 professionals who know what they are talking about." - Rating: 9.2

D. Szalobryt, Syncreon Netherlands N.V. - SQL Basics

"This training gives you an even better idea, what you can do with SQL and how you can apply what you have learned. Highly recommended." - Rating: 8.1

Jurgen Koopmans, Roba Metals BV - SQL Follow-up

"The training SQL provides insight into the creation of queries from databases. During the lessons, you learn how a query is constructed. During the lessons, first the theory is discussed and then a practical assignment is carried out. This is very fun and instructive." - Rating: 9.0

G.J. Leferink, Elementis Delden - SQL Basics

"Challenging, especially as it was possible to tailor the course to the level of the trainees on the spot." - Rating: 7.4

M. Veerkamp, Magna Carta - SQL Basics