Switch to the Dutch version/Switch to the English version
  1. Home
  2. All courses
  3. IT & Software
  4. SQL
  5. SQL Training E-learning

In this SQL e-learning course you will learn to retrieve data from relational databases, write queries, use joins and create reports. You work at your own pace with videos, quizzes and exercises.

  • Practical SQL skills for any database
  • A year of access at your own pace
  • Videos, quizzes and exercises in a single learning path
  • Directly applicable to any common database
  • From history to advanced queries
  1. Home
  2. All courses
  3. IT & Software
  4. SQL
  5. SQL Training E-learning

In this SQL e-learning course you will learn, at your own pace, to retrieve data from relational databases. You will write queries, pull data from multiple tables and perform calculations. A year's access to videos, exercises and quizzes.

Description

In this SQL e-learning course you get to work with Structured Query Language, the query language you use to retrieve and edit data from a relational database. You work with queries to select and manipulate data and to adjust table structures.

The course is in English and consists of videos, lectures, quizzes and exercises. Working through all the content takes approximately 16 hours. You set your own pace and have access to the material for a year after activation, so you can revisit topics at a later date.

You learn the basic variant of SQL, which is applicable to all common relational databases. Differences with variants such as Oracle SQL are covered, so you can apply the knowledge you gain broadly.

Topics

The following topics are covered during this e-learning course:

  • Introduction to relational databases and the history of SQL
  • Working with tables, rows and columns
  • SQL statements and popular databases
  • Simple SELECT: selecting columns and rows, sorting, the WHERE clause and Boolean operators
  • Advanced SELECT: performing calculations and selecting records
  • Built-in functions for data manipulation
  • Subqueries, joins and outer joins
  • Unions to combine results
  • Conditional processing with CASE
  • Running reports and retrieving data from several tables

Result

After this e-learning course you will know how relational databases work and you will be able to write SQL queries independently to retrieve data from a database. You select and sort records, filter with the WHERE clause and apply Boolean operators. You also perform calculations, use built-in functions for data manipulation and retrieve data from multiple tables with subqueries, joins and unions. In addition, you work with conditional processing via CASE. You can apply the knowledge you gain to all common relational databases.

Target audience

This e-learning course is intended for anyone who works, or wants to work, with relational databases and retrieve data using SQL. Think of data analysts, reporting specialists, developers, testers, functional administrators and students who want to master SQL. No prior knowledge of SQL is required. Basic computer skills and a logical way of thinking are enough to work through the material smoothly.

Teaching method

You take this course entirely online as e-learning. You work through videos, short lectures, quizzes and practical exercises at your own pace. The complete programme takes approximately 16 hours, but you decide when and for how long you study.

After activation you have access to all content for a year. This means you can revisit topics at a later moment at your leisure. The course is in English and you learn by doing: you write queries yourself and apply the material to realistic examples from the Northwind database.

Prior knowledge

No specific prior knowledge is required for this e-learning course. Basic experience working with a computer is enough. The course is in English, so a reasonable command of English is useful in order to follow the videos and exercises properly.

Comments

This e-learning course is in English. After activation you have access to all content for a year and set your own pace. Allow roughly 16 hours of videos, lectures, quizzes and exercises.

In-company

Would you like to organise this training for a whole group or several groups? This can be cost-effective. For example, we can tailor the content entirely to your organisation, and training a whole group is also cheaper.

Are you looking at large numbers of participants or a complete academy? That involves a great deal. Consider planning and communication, for example, or identifying and agreeing the objectives and content of the training. Or differences in level, feedback mechanisms and safeguarding. Fortunately, Learnit has extensive experience in this field (more than 25 years) and we are happy to help you through this process.

Request a quote

Training formats

E-Learning

Fully online

225,-

excl. VAT

  • Wherever you want
  • Whenever you want
  • At your own pace
View now

In-company

Bespoke training

On request

 

  • 100% for your group
  • Bespoke training
  • At your place or ours
Request a quote

Workshop

Up to 4 hours for groups

On request

 

  • Suitable for events
  • Interactive and inspiring
  • Large groups too
Request a quote

Private training

At our place or yours

On request

 

  • 100% just for you
  • Achieve a lot in little time
  • Whenever you want
Request a quote

The best training for you

At Learnit you will always find a course that takes you further. From (technical) IT skills to communication or personal leadership. You can also choose the training format that suits you best: a classroom course, a tailor-made course at your own office, an online course or an e-learning. We have the right course and the right format for everyone. Because learning in the way that suits you best delivers the best results.

Participants attending a classroom training course at Learnit

Why choose training at Learnit?

  • Always and everywhere personal

    Personal attention and a pleasant atmosphere. Whether you take a course with us, at your office or on your own PC, we make sure you feel at home enough to push your boundaries.

  • Just do it!

    New opportunities arise when you get moving. Stay sharp. Keep taking new steps. We encourage you to take the plunge and really go for it.

  • Growing through knowledge and inspiration

    Discover something new. Build on your strengths. And choose your own path. We help you grow with training courses and learning formats that genuinely suit you.

  • Skills for the future

    We always think in terms of possibilities and win-win. And every day we work on new solutions for tomorrow. By offering training courses that leave you well prepared for the future.

  • Working together on quality

    We don't make empty promises. What we do offer is quality, knowledge and experience. A broad range of courses, made possible by our inspired staff and trainers.

  • Understanding and being understood

    We listen to what matters to you. To what you need. Because that is where our solution, our tailored approach, begins. Understanding each other properly and communicating clearly: that is what we believe in.

Find out more about Learnit
Trainer and participants working together during a Learnit course

Moving forward together

Taking a training course at Learnit means learning together. Together with your experienced trainer, together with your course group or together with your colleagues. And whether you take the training at home, at your office or at one of our training locations, we are always available to help you. To share our knowledge with you in a way that is genuinely useful to you. Getting further together through personal attention and understanding each other well; that is what we believe in.

Apply it directly in your work

Learning theory from a book that you can then hardly use in your work? Not at Learnit! Whichever training you take with us, you can put it to use at your workplace straight away. Because of the unique learning objectives you set together with the trainer at the start of the training. Because of the alternation between theory and (interactive) practical assignments. And by bringing the challenges you face in your daily work along to the training.

Participants apply what they have learnt straight away in the workplace

Training formats

E-Learning

Fully online

225,-

excl. VAT

  • Wherever you want
  • Whenever you want
  • At your own pace
View now

In-company

Bespoke training

On request

 

  • 100% for your group
  • Bespoke training
  • At your place or ours
Request a quote

Workshop

Up to 4 hours for groups

On request

 

  • Suitable for events
  • Interactive and inspiring
  • Large groups too
Request a quote

Private training

At our place or yours

On request

 

  • 100% just for you
  • Achieve a lot in little time
  • Whenever you want
Request a quote

Reviews

What others say about this course

  • “The course lives up to its content and teaches you the basic SQL skills in a short space of time.”

    Arnaud Milder, Radboud University Medical Centre - SQL Open Learning
    Rating 7.6

  • “If you have no experience with sql and would like to learn the basics, this course is a good start! Now I know a bit about what sql involves.”

    J. Ho, Gemeente Rotterdam- SQL Basics
    Rating 7.4

  • “Enjoyable course that will be very useful if you want to get started with SQL.”

    R. de Munck, Gemeente Amersfoort - SQL Basics
    Rating 8.4

  • “I was very satisfied with the set-up and delivery of this course. A good balance was struck between participants working at different paces. The explanations were clear, with a good balance between doing exercises together and getting to work on exercises yourself.”

    J. Esseling, Zorgon B.V.- SQL Basics
    Rating 8.4

  • “For me, this course was on the one hand a good repetition of the SQL Basics course I also attended, and on the other hand it covered additional topics I did not yet know. Thanks to the content of the course I now have, as the trainer nicely put it, a number of new tools in my toolbox that I can use if I need them in my work.”

    S. de Zeeuw - CBS Academy- SQL Advanced
    Rating 10.0

  • “The SQL course provides insight into creating queries from databases. During the lessons you learn how a query is constructed. Each lesson starts with the theory, which you then put into practice with a hands-on assignment. This is both enjoyable and instructive.”

    G.J. Leferink, Elementis Delden - SQL Basics
    Rating 9.0

  • “A very good course for beginners, but certainly also a refresher for those with a little more experience.”

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

  • “Very good training course. A lot is covered in two days, but still at a comfortable pace. Good alternation between theory and doing exercises yourself. Excellent trainer, has a great deal of knowledge of the subject and is able to convey this clearly and in a pleasant way.”

    T. Wolfs, NUON - SQL Basics
    Rating 9.0

  • “Excellent course in which the complete basics are explained; the trainer can also discuss matters that fall outside the scope of the course.”

    A. Reuijl, Grant Thornton- SQL Basics
    Rating 8.0

  • "This course contains a welcome refresher of the basic SQL knowledge, but is also a good follow-up with many useful techniques. The pace is comfortable. I was able to take away a great deal that I can apply in my work."

    - SQL Advanced

  • “Recommended for people with little SQL knowledge – the basics well covered in 2 days!”

    W. de Rijke, Delta Energy B.V. – SQL Basics
    Rating 8.4

  • “SQL Basics is an enjoyable course that I can recommend. Knowledgeable trainer, good lunch, learned a lot in 2 days! Now to apply it in practice...”

    Hetty Mattaar, Het Waterschapshuis (Informatiehuis Water) - SQL Open Learning Format
    Rating 7.9

  • “Excellent course. You really come away with the basics! The trainer was very enthusiastic and delivered the course in an enjoyable way.”

    H. Wennink, Provincie Overijssel - SQL Basics
    Rating 8.0

  • “Interesting course with an excellent trainer who interacts with the participant and is also open to questions and comments.”

    L. Rams - Open Learning Format SQL
    Rating 10.0

  • “Interesting and practical course. The trainer responded quickly to the feedback given, which made it feel even more like a tailor-made course!”

    Marjolein Smits, Advanced Programs - SQL Advanced
    Rating 7.5

  • “A good balance between listening and practising. After this course you have a solid basis to get started on your own.”

    Peter Berkhout, Klantexpertise UWV - Querying Microsoft SQL Server (MOC20461)
    Rating 8.0

  • “I would recommend this course to people who have never worked with SQL before; it is perfectly suited to that.”

    Ron Derks, Office Depot Europe BV - Open Learning SQL
    Rating 7.5

  • “Well organised, clear explanations, sound course material.”

    E. van Loon, Amarant Groep - SQL Basics
    Rating 8.4

  • “An SQL course that anyone without any programming experience can follow, through a piece of theory followed by exercises. In small groups, which allows for personal interaction with the trainer.”

    S. Grootendorst, PSfm B.V.- SQL Basics
    Rating 8.8

  • "A good basic course. Topics are explained step by step, after which participants practise for themselves with a number of short exercises. Because the trainer walks around and looks on, you get immediate feedback."

    - SQL Basics - Oracle

  • “Enjoyable basic course, perfect location (Amsterdam, Muziekgebouw aan 't IJ).”

    S. Buster, De Nederlandsche Bank- SQL Basics
    Rating 7.4

  • "The course exceeded my expectations, highly recommended. The trainer had a great deal of knowledge."

    - SQL Report Builder

  • “Everything was arranged perfectly, I learnt a great deal!”

    M. Lemmens - Open Learning SQL
    Rating 8.2

  • “Clear explanations and good exercises gave a good picture of what SQL can do.”

    M. Bessem, Regiopolitie Amsterdam Amstelland - SQL Basics
    Rating 8.0

  • “Theory and practice (doing the exercises yourself) in the right balance. Very good course. Professional trainer. The pace of the course is just right.”

    C. Bogaards, T-Mobile- SQL Basics
    Rating 8.8

  • “The trainer has a great deal of knowledge of the subject matter. He showed examples he had made himself, which were very interesting. He explained these examples in full. I learnt a lot from this and felt motivated.”

    Anonymous - Writing queries using Microsoft SQL Server 2008 Transact-SQL
    Rating 8.4

  • “It's a good training for filling in the gaps if you have patchy knowledge, due to on the job learning, like I did.”

    Laszlo Iliasics, Mapscape B.V. - SQL Basics
    Rating 8.0

  • “This course gives you an even better picture of what you can do with SQL and how to apply what you have learned. Recommended.”

    Jurgen Koopmans, Roba Metals BV- SQL Intermediate
    Rating 8.1

  • “My first introduction to SQL in this SQL Basics course. Good, clear explanation of the material. Plenty of exercises to put the material into practice straight away, and an enthusiastic trainer make this course a recommendation for anyone who wants to know more about SQL.”

    - SQL Basics

  • “An excellent course to start with as a complete beginner. You first get to know the software package and then get straight to work on small assignments. As a result, I am now able to create small databases and reports.”

    J. Kramer, HC Groep - SQL Report Builder
    Rating 7.4

  • “The trainer sets a good pace for beginners, keeps your attention and is extremely clear in the way he communicates. As a result you remember everything better and stay motivated!”

    I. Sang-Ajang - T-mobile Netherlands B.V.- SQL Open Learning Format
    Rating 9.8

  • “A good course with good materials. I got a solid grasp of the SQL basics in two days. I would recommend doing some preparation beforehand so you pick up the topics better and faster. The trainer was open to questions and explained things well.”

    R. Richtering Blenke, ProQuro Services - SQL Basics
    Rating 7.8

  • “Good course to bet the basics of SQL!”

    Paul Bakker, Randstad Nederland B.V. Head Office – SQL Basics
    Rating 8.0

  • “You get value for money. And you leave with the knowledge to write your own SQL statements.”

    D. Knijnsberg, Gemeente Purmerend - SQL Basics
    Rating 10.0

  • “Good balance between presentation and doing exercises yourself. Good variation in the difficulty of the exercises, there were a few nice challenging ones among them. The trainer had a great deal of knowledge and explained clearly how to tackle a problem in a structured way.”

    S. Rodewijk, NUON - Oracle Database: SQL Fundamentals Part I
    Rating 8.8

  • “I expected a basic course that covered writing queries from scratch from A to Z. The course did exactly that. A perfect match.”

    C. van Lumig, Woonpunt - SQL Basics
    Rating 10.0

  • “Good, clear training course, really for building reports for beginners.”

    D. Hoekstra, NLO- SQL Report Builder
    Rating 9.0

  • “The content was good. We had requested a course to learn the new functions / changes in SQL Server 2012. So we largely determined the content ourselves. The trainer picked this up well and clearly explained per topic what had changed / was new and how to deal with it, and gave examples for each topic.”

    M. van Leeuwen- Administering Microsoft SQL Server 2012 Databases
    Rating 7.4

  • “This course teaches you in 2 days what SQL is, how you can use it and what the well-known mistakes are. The trainer is highly professional and has a great deal of knowledge of the subject.”

    D. Gebroers, Alfa Accountants en Adviseurs - Transact-SQL Basics - MS SQL Server
    Rating 9.6

  • “A good overview of what SQL can do.”

    A. Heijmans, Gemeente Rotterdam - SQL Basics
    Rating 8.2

  • “A course with a good pace. Pleasant alternation between plenary treatment of the material and doing individual exercises. Excellent value for money if you want to start working with SQL in practice.”

    B. Willemse. Capter- SQL Basics
    Rating 8.4

  • "It was all explained clearly and enthusiastically. The trainer came across as an expert. We received plenty of attention, but then again we were a small group. It met expectations. I achieved my learning objectives. The location was lovely too (Amsterdam, Muziekgebouw aan 't IJ)."

    J. Hensbroek, IDS- SQL Basics
    Rating 8.0

  • “SQL is a language. The course teaches you how to read and understand this language and how to tell a simple story with it. The location (Amsterdam, Muziekgebouw aan het IJ) was great – excellent venue, with all the necessary facilities, hospitality, a bit of a homely feel. Learnit Training met my expectations – approachable, good dialogue, no unnecessary waiting, good information, clear.”

    K. Gnezda Meijer, Diebold- SQL Basics
    Rating 7.4

  • “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.”

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

  • “Good trainer, plenty of course material. I achieved my initial objectives.”

    H. Vranac-Arapovic, Gemeente Breda - SQL Basics
    Rating 8.4

  • "Recommended! An enjoyable, informal way to broaden your knowledge."

    - SQL Open Learning

  • “Very practical training course. Clear explanations and plenty of relevant exercises.”

    Jan Rensen, Shell Pensioenbureau Nederland B.V. - Open Learning SQL
    Rating 8.7

  • “Very good, the trainer had a lot of knowledge. Good examples. Room for questions.”

    W.F. de Winter - Administering Microsoft SQL Server 2012 Databases
    Rating 8.0

  • “An enjoyable course in which you learn a great deal about SQL and which is easy to follow if you are a beginner.”

    S. Sivananthan - Erasmus MC - SQL Open Learning
    Rating 8.2

  • “Without much programming experience, I learned a great deal about SQL in these two days. When you look at the sort of query you can write by the end of the second day, you really see the progress you have made over those two days. The trainer had time for everyone and took plenty of it.”

    J. Blaas, A.S.R. Verzekeringen- SQL Basics
    Rating 8.0

Learnit reviews

Others also viewed

SQL Report Builder

  SQL Report Builder

you will learn to work with Microsoft SQL Report Builder and create clear reports from large databases yourself.

View the course

SQL Advanced

  SQL Advanced
On this two-day follow-up SQL course, you will delve into Microsoft SQL Server and Transact-SQL. You will work with joins, subqueries, window functions, data modifications and transactions, and you will learn to apply programmable objects and logical tests.
View the course

SQL Basics

  SQL Basics

On the SQL Basics course, you will learn to work with databases and SQL queries under the guidance of an experienced trainer. You will practise with SELECT, WHERE, GROUP BY, JOINs and functions, so that afterwards you can independently query and edit data in a relational database.

View the course
View all courses

Frequently asked questions

The SQL e-learning takes approximately 16 hours to complete in full. After activation you have access to all content for a year, so you can learn at your own pace and revisit topics later. The course consists of videos, lectures, quizzes and exercises, and is in English. You decide when and where you study.

You do not need any specific prior knowledge to start the SQL e-learning course. The course begins with the basics: you learn what a relational database is, how tables work and how to write your first SQL query. An affinity with data and logical thinking helps, but programming experience is not required. Anyone who wants to learn how to retrieve data from a database can start straight away.

The online SQL course is in English. You work through videos, lectures, quizzes and exercises in English. The content is suitable for anyone with basic English reading skills and follows international SQL standards. As a result, the knowledge you gain can be applied directly to all the major relational databases, regardless of the language you work in later on.

The SQL e-learning covers five main modules: an introduction to relational databases, Simple SELECT, Advanced SELECT, Subqueries, Joins and Unions, and conditional processing with CASE. You learn to write queries, sort and filter records, perform calculations, use built-in functions for data manipulation and combine data from several tables. The knowledge you gain is applicable to all major relational databases.

The online SQL course is suitable for anyone who wants to learn how to query and edit data in a relational database. Think of data analysts, developers, testers, reporting specialists and students. If you work with PHP, ASP or VBA and need SQL knowledge, this e-learning is also a good fit. No specific prior education is required.

Yes, after successfully completing the SQL e-learning course you receive a certificate of participation. This shows that you have worked through the course and gained knowledge of relational databases, writing SQL queries, joins, subqueries and data manipulation. The knowledge you gain applies to all major databases, which makes your certificate widely usable in the workplace.

This e-learning course suits you if you want to learn SQL at your own pace, without fixed course days. You get around 16 hours of structured content: videos, lectures, quizzes and exercises, with a year of access. That is an advantage over separate YouTube tutorials, because the learning path builds up from relational databases and simple SELECT queries to subqueries, joins, unions and CASE statements. Choose a classroom SQL course if you prefer direct interaction with a trainer and fellow participants, or if your employer wants a fixed programme with guidance. Choose this e-learning course if you are looking for flexibility, if English-language material is no problem and if you want to be able to revisit the material whenever you need to write a specific query in practice. The knowledge you gain is applicable to all common relational databases.

The course covers standard ANSI SQL syntax, which works on virtually all relational databases. You learn SELECT statements, WHERE clauses, boolean operators, sorting, calculations, built-in functions, subqueries, joins, outer joins, unions and conditional processing with CASE. These concepts are identical in Oracle, MySQL, PostgreSQL, SQL Server and other systems. During the course you practise with the Northwind database, a well-known practice database. Differences between SQL variants (such as dialect-specific functions in Oracle SQL) are explained along the way. In practical terms this means: after the course you can write reports and retrieve data from multiple tables, regardless of which database system your employer uses. The knowledge you gain is directly transferable to any relational database on the market.

SQL is not a classic programming language but a declarative query language (4GL) with which you tell the DBMS which data you want, not how the system should retrieve it. Languages such as Python, PHP, ASP and VBA are imperative: in those you write step by step what the computer must do. In practice they are often combined. A PHP website, for example, sends an SQL query to the database and processes the result. You do not need any knowledge of Python or PHP for this e-learning course. You learn SQL as a standalone language for retrieving and manipulating data and running reports. If you later want to integrate SQL into an application, another language will come into play. The SQL knowledge remains exactly the same.

SQL and tools such as Excel or Power BI play different roles in the data chain. SQL is a query language with which you communicate directly with a relational database through queries. You retrieve data from one or more tables, filter with WHERE clauses, combine tables with joins and perform calculations at the source. Excel and Power BI usually work with data that has already been retrieved, and focus on analysis, visualisation and reporting. In practice they complement each other: with SQL you determine which data you get, in Excel or Power BI you determine how you present it. In this e-learning course you learn the SELECT side: choosing columns, sorting, filtering, subqueries, joins, outer joins and conditional logic with CASE. That knowledge works on virtually any relational database.

Yes, this e-learning course provides a workable foundation for both directions. You learn to write SELECT statements, use joins and subqueries, perform calculations and apply conditional logic with CASE. These are skills you need on a daily basis in an analyst or developer role. The course covers standard SQL syntax, which works in virtually every relational database. For a data analyst role this is generally enough to get started with reports and ad-hoc queries. If you want to become a junior developer, SQL is an indispensable component, but you will also need a programming language such as Python, PHP or C#. This course does not cover database design, performance tuning or stored procedures at an advanced level. For that depth you can choose a follow-up course later on.

The difference lies in the structure and the practice environment. Free platforms such as W3Schools and freeCodeCamp give you separate explanations and examples, but you decide the order and the pace yourself. This e-learning course builds up across five modules, from the history of relational databases to conditional processing with CASE, and uses the Northwind database as a common thread. You get videos, lectures, quizzes and exercises that take around 16 hours. You have access for a year, so you can revisit topics as you encounter them in practice. Practical difference: with free resources you often miss feedback on your own queries and a logical build-up towards joins, subqueries and unions. Choose this e-learning course if you want to learn in a structured way and be able to demonstrate your progress.