SQL E-learning Course
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.
NRTO quality mark
- 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
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.
Practical information
- Education level
- Suitable for all levels
- Preparation time
- None
- Included
- Course materials
- Certificate
- At the end of the course you will receive a certificate of attendance
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.
This course for your team?
Plan your own group on a date that suits you, at your office, at our premises or online. We tailor the content to your day-to-day work, and training a whole group is cheaper than individual bookings.
- Your date and location
- Tailored content
- Multiple groups or an academy are also possible
- More than 25 years' experience
What others say about this course
“Very pleasant course and organisation, highly satisfied!”
“A good course for learning the basic principles of SQL. Plenty of practical exercises, so you get to grips with SQL quickly. It was led by a good trainer who took the time to explain things. Teaches with enthusiasm. A sociable and friendly person. Learnit Training is a professional organisation, customer-focused and with good, fast service.”
“Effective training course from an experienced trainer with more than enough knowledge. The trainer was able to switch quickly between people and also focused on those who needed it without forgetting the others.”
“A good course for learning the basic principles of SQL. Plenty of practical exercises, so you get to grips with SQL quickly. It was led by a good trainer who took the time to explain things. Teaches with enthusiasm. A sociable and friendly person. Learnit Training is a professional organisation, customer-focused and with good, fast service.”
“Briefly summarised and clear. Good pace of teaching and easy to follow. Practice-oriented exercises rather than theoretical assignments. The trainer had attention for everyone. Personal and constantly asking whether the material was still understandable. Sufficiently knowledgeable and honest about their own knowledge. Learnit Training is professional and service-oriented.”
“The trainer is extremely knowledgeable and manages to present the often dry material in an entertaining way as well. Keep it exactly like this! Everything was arranged pleasantly and quickly by Learnit Training!”
“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.”
“I had never been on a course or training before, and the course and everything around it actually exceeded my expectations.”
“Excellent course, easy to follow. The content met my expectations. The knowledge was conveyed in a very pleasant way.”
“Practical training course that lays a good foundation for further use and understanding of SQL.”
“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.”
“Very easy to follow, especially for people who want to get started with SQL. Suitable for both IT and non-IT people. Definitely recommended!”
“It was a demanding course, covering an enormous amount in two days. It was a thoroughly enjoyable course!”
“A good basic course to get you started with SQL”
“A useful and practical course for anyone who wants to master the SQL fundamentals.”
“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.”
“Effective training course from an experienced trainer with more than enough knowledge. The trainer was able to switch quickly between people and also focused on those who needed it without forgetting the others.”
“Got refreshed with my sql skils”
“Very good course. Excellent trainer”
“Received a good explanation of all the basic principles within SQL and its various dialects. Highly recommended as a refresher course too!”
“Thanks to all the practice and the pleasant teaching style, this course is extremely well suited to picking up basic SQL knowledge quickly.”
“You learn the basic commands for querying a database and combining tables. This tied in perfectly with the issues I come across in my daily work. I was lucky to be in a class where everyone took part with the same goals. As a result the pace was high and you didn't have to wait for other participants. It is a requirement to have some knowledge of application management and database querying, so that you can translate the content straight into daily practice.”
“I expected a basic course that covered writing queries from scratch from A to Z. The course did exactly that. A perfect match.”
“Learnit gave good thought to how the SQL Basics course on site should be set up. This was for a small group with different backgrounds and levels of basic knowledge. This was no problem at all for the course or the trainer. The structure is pleasant and the course moves along nicely. There is room to go into more depth, and a big advantage is that you do a lot yourself and discuss it afterwards.”
“Very pleasant course and organisation, highly satisfied!”
“The SQL course was very informative. The course was presented in an enjoyable way by a trainer with a great deal of knowledge. All the basic SQL functions were covered step by step, so I can certainly take this further within my company.”
“Very good course for learning how to build basic queries. Clear book with good examples and a good structure. The trainer is highly knowledgeable. His way of explaining things held our attention. Clarifying explanations.”
“Clear explanation of SQL with plenty of usable examples and good exercises. It was all very manageable and after following this basic course I have gained more than enough knowledge to run all the queries we need on our database. And that has produced a lot of useful information. In short: an excellent course!”
“Clear explanations and good exercises gave a good picture of what SQL can do.”
“Enjoyable and highly applicable course; you really get something out of it and you can put it into practice straight away. Highly recommended.”
“Excellent course with plenty of depth added to the basic material by a professional trainer.”
"Recommended! An enjoyable, informal way to broaden your knowledge."
"Colleagues were impressed by how much I already knew after a 2-day course."
"The course exceeded my expectations, highly recommended. The trainer had a great deal of knowledge."
"A fine course if you are really getting to know this subject matter. There is clear and well-structured course material with plenty of exercises to learn SQL."
“A good course that you can put to plenty of use in practice.”
“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.”
“SQL Basics was an excellent course and immediately applicable in practice. The trainer is friendly, patient and open. He certainly knows his subject and enjoys being challenged by his participants.”
“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.”
"E. van Herwijnen - "Positive impression. Good location, course, exercise material and applicability in practice." - Rating: 7.2"
“The course is interactive. Within two days you have a clear picture of the possibilities of SQL”
“It ties in very well as a stepping stone towards understanding and using SQL. In my work we will be dealing with SQL more often. In my role as functional administrator I needed more insight into SQL. And this worked out well with the professional training course from Learnit Training. This is already my second Learnit course. Given the very wide range of courses on offer, I do not think it will be the last.”
"Learnit is a professional organisation with a personal approach. The SQL course was well matched to our starting level, and the trainer guided us through the material skilfully and with great enjoyment. Excellent!"
“Very practical training course. Clear explanations and plenty of relevant exercises.”
“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.”
“This basic course met my expectations. The trainer was knowledgeable and relaxed, with plenty of individual attention where needed.”
“The course is very instructive; in a short space of time you learn the skill of querying databases. The good atmosphere during the course stimulates creativity, which makes learning almost effortless. The course does not cost energy, it actually gives you energy!”
“A course that brings you up to a level within two days from which you can then get to work in practice yourself. The content of the course matched my expectations very well. I now have a good grasp of the basics of the SQL language.”
“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.”
"A good, clear course in which the basics of SQL are explained."