In this course you will learn to create reports independently from large databases using Microsoft SQL Report Builder and Reporting Services.
Quickly producing clear reports from large databases: that is where you want to get to. Microsoft SQL Report Builder gives you a fast, intuitive design environment with which you turn complex data into clear reports.
SQL Report Builder is a stand-alone component of Microsoft SQL Server (SSRS) and offers you a wide range of visualisations, such as data bars, maps and sparklines. Microsoft has also made a report parts gallery available, so that you can reuse existing parts as building blocks for new reports.
During this course you work at your own pace on practical assignments, with guidance from an experienced trainer. Are you already running into specific issues in your work? Feel free to bring them along to the course. That way you work directly on situations you recognise.
At the end of the course you will be able to independently design, format and export complex reports from large databases.
For teams and organisations. If you want a department to build reports in Report Builder in the same way, we also run this course in-company. In consultation with you, we work with examples from your own practice.
After this training course you can independently design and format reports in SQL Report Builder. You know how to retrieve and group data, calculate totals and add charts. You can also export reports in various formats and build complex reports that meet your organisation's information needs.
This course is suitable for users who want to create reports themselves with Microsoft SQL Report Builder and Reporting Services. Think of data analysts, report builders, BI specialists and functional administrators who work with SQL Server databases.
The course is also suitable for controllers, financial administration and information management staff, and anyone who regularly needs to extract management information or periodic overviews from a SQL Server database.
You work in a small group on practical assignments at your own pace, with personal guidance from an experienced trainer. You receive a workbook with exercises and exercise files, which you can also use as a reference work after the course. As the software is in English, the course material is in English too.
Basic knowledge of SQL and databases is recommended. Experience with Microsoft SQL Server is a plus, but not a requirement.
The course is given in Dutch as standard. The trainer speaks English. English-language course materials can be used. If at least 3 participants register, the course can also be given entirely in English.
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.
“Attended the Report Builder course. Enthusiastic trainer who shared his expertise with us in a pleasant way. During the course day we were able to use good practice material, with a well-structured set-up. Learned a lot, excellent value with a useful presentation as reference material.”
“Good, clear training course, really for building reports for beginners.”
“The course material is clear and of a good standard. The exercises are clear with sufficient and progressive depth, and the trainer is calm and competent.”
"The course exceeded my expectations, highly recommended. The trainer had a great deal of knowledge."
“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.”
“Clear explanations and good exercises gave a good picture of what SQL can do.”
“Well organised, clear explanations, sound course material.”
"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."
“Excellent course in which the complete basics are explained; the trainer can also discuss matters that fall outside the scope of the course.”
“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.”
“Good course in which the basics are dealt with hands-on. So you get to work with what you have learned straight away. Some prior knowledge is useful though”
“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.”
“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!”
“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.”
“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.”
“A solid basic course that gives you a very good start in discovering SQL.”
“Excellent course. You really come away with the basics! The trainer was very enthusiastic and delivered the course in an enjoyable way.”
“A good basics course in which my knowledge improved by 100%. Good material, a steady pace and excellent exercises. Recommended as an SQL basics course.”
“Good course to bet the basics of SQL!”
“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.”
“A good course that you can put to plenty of use in practice.”
“Practical course in which a user/information analyst quickly learns how to unlock (relational) databases using the basic principles of SQL.”
“A good, practice-oriented programme, recommended for the increasingly popular field of Big Data.”
“A very practical course in which you learn to work with SQL straight away. No long, dry sessions, but simply getting started right after a short introduction. Combine that with a trainer who knows what he is talking about and you are typing out your first queries in no time.”
“Very practical training course. Clear explanations and plenty of relevant exercises.”
“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.”
“The content met my expectations. Gaining basic SQL knowledge. The trainer was very knowledgeable and also gave plenty of good tips.”
"At Learnit they keep learning from their own lessons. What a great course!"
“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.”
“A clear training course with plenty of useful tips.”
“If you would like to learn the basics of SQL, this course really comes recommended.”
“Good set-up, sound structure, recommended.”
“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.”
“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.”
“Thanks to all the practice and the pleasant teaching style, this course is extremely well suited to picking up basic SQL knowledge quickly.”
“Good course with clear explanations at a calm pace. Also manageable without prior knowledge.”
"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!"
“An enjoyable course in which you learn a great deal about SQL and which is easy to follow if you are a beginner.”
“The course has given me enough tools to get started with SQL. You gain the experience in practice, but this course gives you enough firm ground under your feet.”
“The SQL training course was a welcome one. Thanks to this course I can move on with a better understanding of ORACLE SQL. The two course days we enjoyed were really very instructive.”
“This is an excellent programme for learning the basics of SQL!”
“A good, practice-oriented programme, recommended for the increasingly popular field of Big Data.”
“Interesting and practical course. The trainer responded quickly to the feedback given, which made it feel even more like a tailor-made course!”
“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!”
“Enjoyable and highly applicable course; you really get something out of it and you can put it into practice straight away. Highly recommended.”
“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.”
“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!”
“The course has given me enough tools to get started with SQL. You gain the experience in practice, but this course gives you enough firm ground under your feet.”
“Well-structured course. Good course material and reference work. The trainer has a sound knowledge of SQL and conveys it well.”
You learn to design and format reports independently with Microsoft SQL Report Builder. Topics covered include: retrieving data, designing and formatting reports, adding groups, calculating totals and running totals, integrating charts and exporting reports. You finish with a complex exercise in which you bring everything together.
The course is intended for data analysts, report builders, BI staff and functional administrators who work with Microsoft SQL Server and want to create their own reports with Report Builder or Reporting Services (SSRS).
Basic knowledge of SQL and databases is recommended, as you will work with queries and datasets during the course. Experience with Microsoft SQL Server is useful, but not a strict requirement.
Yes, on completion you will receive a Learnit certificate of participation. This certificate confirms that you have attended the SQL Report Builder course.
Yes, we even recommend it. If you have already encountered specific reporting issues in your work, you can bring them along. That way you work directly on situations you recognise and apply what you have learnt straight away.
The course material is in English, because the software and terminology of Report Builder and Reporting Services are also in English. The course itself is given in Dutch.
Reporting Services (SSRS) is the broader platform within Microsoft SQL Server with which you publish and manage reports. Report Builder is the standalone design tool with which you build those reports visually. In the training course you get to know and use both.
Report Builder offers a wide choice of visualisations: tables, matrices, charts, data bars, sparklines, indicators and maps. In addition, you can use Microsoft's report parts gallery to reuse existing building blocks for new reports.
Yes, reports can be exported to various formats, including Excel, PDF, Word and CSV. During the course we cover how to do this and what to watch out for when formatting for different export formats.
SQL Report Builder is aimed at structured, pixel-perfect reporting (so-called paginated reports) from SQL Server databases. Power BI focuses more on interactive dashboards and data exploration. Both tools have their own strengths and are often used side by side within a single organisation.
Yes, this course is also available in-company. We can tailor the content to the databases and reporting issues within your organisation. Get in touch for a bespoke quotation.
You can find the current price at the top right of this course page, along with the schedule, location and delivery format. For in-company or bespoke courses we are happy to provide a quotation on request.