Switch to the Dutch version/Switch to the English version
  1. Home
  2. All courses
  3. IT & Software
  4. SQL
  5. SQL Report Builder

In this course you will learn to create reports independently from large databases using Microsoft SQL Report Builder and Reporting Services.

  • Practical exercises with immediate application
  • Working at your own pace
  • Personal guidance from an experienced trainer
  • Bring your own work-related questions
  • Learnit certificate of participation

In-company

Recommended number of days: None
Group: up to a maximum of 8 people
Location: In-company, throughout the Netherlands
Language: Dutch or English
Investment: on request
Are there any other wishes or requirements? We can tailor the course to your needs.
Request a quote
  1. Home
  2. All courses
  3. IT & Software
  4. SQL
  5. SQL Report Builder

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.

Description

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.

Topics

  • Introduction Report Builder / Reporting Services
  • Getting the Data
  • Designing the Report
  • Formatting the Report
  • Adding Groups
  • Calculating Totals
  • Calculating Running Totals
  • Adding Graphs
  • Exporting the Data
  • Complex Exercise

Result

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.

Target audience

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.

Teaching method

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.

Prior knowledge

Basic knowledge of SQL and databases is recommended. Experience with Microsoft SQL Server is a plus, but not a requirement.

Language

The training is given in Dutch as standard. The trainer has a good command of English. English-language course material can be used. With a minimum enrolment of 3 participants, the training can also be given entirely in English.

Training formats

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

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

SQL Report Builder course reviews - Average score 8.3 out of 4 reviews

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

    Anonymous - SQL Report Builder
    Rating 8.2

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

    M. Sanders, GGD Brabant-Zuidoost - SQL Report Builder
    Rating 8.8

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

    - SQL Report Builder

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

    D. Hoekstra, NLO- SQL Report Builder
    Rating 9.0

  • "Extremely instructive, built up step by step and easy to understand for people with no prior knowledge of this."

    - SQL Basics

  • “Very enjoyable course. The trainer knows a great deal about this subject, but also has a lot of general knowledge, which makes it possible to give clear examples from practice. Every question is answered with genuine interest by the trainer.”

    A. de Bruijne - xxllnc - SQL Open Learning Format

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

    L. Maassen - CBS Academy- SQL Basics
    Rating 7.6

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

    V. Jong, Kyocera Document Solutions Nederland B.V.- SQL Basics
    Rating 8.8

  • "Fine, short yet complete basic course."

    - SQL Basics

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

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

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

    - SQL Report Builder

  • "Colleagues were impressed by how much I already knew after a 2-day course."

    - SQL Basics

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

  • “The SQL Basics course at Learnit comes highly recommended. Personal attention, the quality of the course material and the training itself are, in a word, excellent. I was able to learn a great deal in 2 days. It provides a great foundation for growing into a professional super user if you want to move up to a higher level.”

    Tim Engelhart, Centraal Beheer Achmea - Open Learning SQL
    Rating 8.7

  • “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 course for taking the first step towards becoming an SQL expert.”

    Geert Jansen, Van Mossel Leasing - SQL Open Learning
    Rating 7.7

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

    P. de Best, Gemeente Westland - SQL Basics - Oracle
    Rating 8.8

  • "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."

    - SQL Open Learning

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

  • “This training course is ideal for people who are going to work with SQL databases. A lot is explained and the pace is never too slow. All kinds of queries are covered, as well as the combined use of different types. Highly recommended!”

    J. de Groot, Kemira - SQL Basics
    Rating 8.2

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

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

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

    C. Kessenich - Optimizers - SQL Advanced
    Rating 8.2

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

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

  • “It met my expectations. At the very least I can now read an SQL script. Creating simple ones myself also goes well.”

    Thata van Meerwijk, Albeda College - SQL Open Learning Format

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

  • “Very easy to follow, especially for people who want to get started with SQL. Suitable for both IT and non-IT people. Definitely recommended!”

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

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

  • “If you have an affinity with IT but no experience with SQL yet, this course is perfect for learning it.”

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

  • "E. van Herwijnen - "Positive impression. Good location, course, exercise material and applicability in practice." - Rating: 7.2"

    - SQL Basics

  • “I have no experience at all with SQL. But the course was explained at a steady pace, so you could master the material. I would recommend it for beginners.”

    Y. Karaca, Gemeente Amstelveen - Open Learning SQL
    Rating 9.2

  • “A useful and practical course for anyone who wants to master the SQL fundamentals.”

    Daniel van der Krans, Mobilee Management & Advies- SQL Open Learning
    Rating 9.0

  • “This basic course met my expectations. The trainer was knowledgeable and relaxed, with plenty of individual attention where needed.”

    A. Arkeraats, ANWB - Transact-SQL Basics - MS SQL Server
    Rating 8.2

  • “SQL Basics Oracle is a course I can recommend with complete confidence. Its practical applicability is very high!”

    N. Meijer. Rijksdienst voor Ondernemend Nederland - SQL Basics - Oracle
    Rating 8.6

  • “A solid basic course that gives you a very good start in discovering SQL.”

    Maria Sijtsma, Zorggroep Treant - Open Learning format SQL
    Rating 9.0

  • "At Learnit they keep learning from their own lessons. What a great course!"

    - SQL Basics

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

  • “This is a good course for learning the basics of SQL. It does help your understanding if you already know something about databases/files. In a number of programming languages, knowledge of SQL is already indispensable.”

    P. Anuels, Praclox - SQL Basics
    Rating 9.8

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

    Anonymous- Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
    Rating 8.2

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

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

    D. Hoekstra, NLO- SQL Report Builder
    Rating 9.0

  • “A good course if you have no knowledge of SQL yet. You can put what you have learned to use straight away.”

    F. van Nuland, Sevagram- SQL Basics
    Rating 9.0

  • “Practical training course that lays a good foundation for further use and understanding of SQL.”

    A. Bouman, Denkavit Nederland B.V. - Open Learning format SQL
    Rating 9.0

  • “The trainer had a great deal of experience and sound subject knowledge. Excellent course!”

    J. Groen, Politie Kennemerland - SQL Basics
    Rating 7.6

  • “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 the possibilities of SQL, I have certainly achieved this objective. Simply practising with a few scripts yourself already gives you some insight and a foundation. You do have to put it into practice and keep practising at work or at home. Then the knack will certainly follow.”

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

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

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

  • “This course teaches you the basics of SQL in a straightforward way. The exercises tie in well with the course material.”

    Wouter Louet, Gemeente Utrecht - SQL Open Learning Format
    Rating 8.6

Learnit reviews

Others also viewed

SQL Training E-learning

  SQL Training E-learning
In this SQL e-learning course you learn to work with relational databases at your own pace. You write queries to retrieve data from one or more tables, carry out calculations and use functions for data manipulation. You have access to the content for one year.
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

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.