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.
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.
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.
For teams and organisations. For a team or department, this e-learning means everyone works through the same material while studying at a time that suits them. All participants practise with the same examples from the Northwind database.
The following topics are covered during this e-learning course:
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.
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.
The course is also suitable for controllers, BI staff and colleagues in finance, marketing or operations who want to retrieve data from a database themselves instead of always having to ask IT.
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.
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.
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.
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.
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.
“Enjoyable and highly applicable course; you really get something out of it and you can put it into practice straight away. Highly recommended.”
“Good course with a good progression from the basics to somewhat more complex content spread over two training days. I found it a very useful course and it is good that we also have reference material in the form of a course book and access to the website with the material from the book and practical exercises including answers.”
"The trainer was very good and the course material was clear. The pace of the course was manageable and the exercises offered exactly the right amount of challenge."
“A good, practice-oriented programme, recommended for the increasingly popular field of Big Data.”
“It's a good training for filling in the gaps if you have patchy knowledge, due to on the job learning, like I did.”
"This basic course gives a good overview of what SQL is and what you can do with it. Following a logically structured approach, you go from a very simple query to a fairly advanced, in-depth query in two days."
“Useful course for learning SQL quickly.”
“Practically applicable within my own organisation.”
“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.”
“Good set-up, sound structure, recommended.”
“Excellent course if you want to learn SQL thoroughly and in a structured way. With plenty of practical exercises. The content of the course was excellent: clearly organised, good course material including practice assignments, a good balance between theory and practical exercises. The trainer's knowledge is good, as is the way he explains and conveys the material. He places a strong emphasis on building knowledge in a structured and solid way, rather than on quick results. He responded well to questions.”
"The trainer was very good and the course material was clear. The pace of the course was manageable and the exercises offered exactly the right amount of challenge."
“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.”
“This course teaches you the basics of SQL in a straightforward way. The exercises tie in well with the course material.”
“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 Oracle is a course I can recommend with complete confidence. Its practical applicability is very high!”
“Gaining a broad basic knowledge of SQL helps me in practice to create simple queries and to read and adapt more extensive ones. That was exactly what I was looking for. What certainly also makes the difference is that the small scale means everything is tailored to the participants.”
"The course exceeded my expectations, highly recommended. The trainer had a great deal of knowledge."
“Very satisfied with the content, received a good explanation of the differences between SQLSERVER 2008 and 2012. The trainer was well able to relate to our problems/questions. He knows what he is talking about and is good at pointing out the differences and the pros and cons.”
“A 2-day course that met my expectations and enabled me to apply what I had learned successfully in daily practice. By alternating theory and practice, the knowledgeable trainer managed to keep the course lively and to hold the attention of our mixed group right to the end. All this at a good location and with excellent course material for this subject.”
“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.”
“Good, clear SQL basics course. Learned enough methods that I can apply straight away and that lay the foundation to take it further (on my own).”
“it is a very good foundation, so you can get started with SQL straight afterwards.”
“It was a demanding course, covering an enormous amount in two days. It was a thoroughly enjoyable course!”
“I would recommend this course to people who have never worked with SQL before; it is perfectly suited to that.”
“A good, instructive course with a professional trainer who knows a great deal about the subject. This keeps you listening with interest so you don't lose your attention.”
“Very satisfied with the content, received a good explanation of the differences between SQLSERVER 2008 and 2012. The trainer was well able to relate to our problems/questions. He knows what he is talking about and is good at pointing out the differences and the pros and cons.”
“This course gives you a clear overall picture of the basic queries in SQL, without wasting any time. The trainer is driven and to the point, and open to input and feedback. Two days well spent!”
“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.”
“This course teaches you the basics of SQL in a straightforward way. The exercises tie in well with the course material.”
“The course is a good stepping stone for going further with SQL. It will certainly help us carry out work on our Oracle database more effectively.”
“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!”
“After taking this course I had a very good impression of SQL and its possibilities. I immediately started developing ideas about applications in my own working environment and those of others. We do know SQL, but only once the basics are clear do you begin to understand what you can do and how to do it. This course was perfect for that.”
“Everything was arranged perfectly, I learnt a great deal!”
“The SQL Advanced course was very good and applicable in practice. This course is a good addition if you already know a bit more about T-SQL. It teaches you a number of approaches that you would normally do differently. The first day is also good for refreshing your knowledge.”
“Very practical training course. Clear explanations and plenty of relevant exercises.”
“This is an excellent programme for learning the basics of SQL!”
“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.”
“Very easy to follow, especially for people who want to get started with SQL. Suitable for both IT and non-IT people. Definitely recommended!”
“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.”
“Gaining a broad basic knowledge of SQL helps me in practice to create simple queries and to read and adapt more extensive ones. That was exactly what I was looking for. What certainly also makes the difference is that the small scale means everything is tailored to the participants.”
"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."
“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.”
“A good course for learning the basics of SQL and then applying it directly in practice.”
"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."
“Good set-up, sound structure, recommended.”
“Enjoyable basic course, perfect location (Amsterdam, Muziekgebouw aan 't IJ).”
“Excellent SQL Server course with a clear structure.”
“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.”
“You get value for money. And you leave with the knowledge to write your own SQL statements.”