English French German Italian Portuguese Russian Spanish

logo_old

  • Database Training

    databaseInterSource offers live instructor-led courses on all important database programming technologies, including Crystal Reports, Microsoft Access, MySQL, Oracle, SQL, SQL Server, SSAS, SSIS, SSRS and Xcelsius.

    These live classes are offered both on client sites, at our Geneva training center, and via a Web interface.

  • About Database

    A database is a collection of data stored and maintained for one or more uses. Most modern databases are managed by a Database Management System (DBMS), a set of computer programs that controls the creation, maintenance, and the use of the database with computer as a platform or of an organization and its end users. It allows organizations to place control of organization-wide database development in the hands of database administrators (DBAs) and other specialists.

    The proper integration of databases can dramatically increase the functionality of all types of applications, whether or not Web-enabled.


    Read More
  • Course Details Database

    Classes are offered at client sites, at our Geneva training center, and via a live web conference. For detailed course outlines and scheduled classes, please see below.

    To book training, navigate to the course you need, then:

    • For scheduled online classes, register from the choices indicated.
    • If you need an alternative dates, time or location, or if you want a live classroom course, click on “request an offer for this course,” to complete the form.

    InterSource clients are active globally. Live web courses run during Eastern Standard Time (New York) business hours and are priced in US dollars.

    We also run live web conference classes during European business hours, which can be invoiced in local currencies. To discuss your requirements please contact us on +41 (22) 958 0114.

Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012 Express and SQL 2012

 PDF PrintEmail

Course duration

  • 2 Days

Course Outline

This Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012 Express and SQL 2012 instructor-led training provides students with the necessary knowledge to develop reports using Microsoft Report Builder 3.0. The training environment includes SQL 2008R2, SQL Express 2012 and SQL 2012 Standard and Enterprise so that the students can utilize Report Builder 3.0 and generate reports from multiple sources to investigate the different features of each release.

The course is intended for Power Users, Developers and IT Professionals that will be involved with the design, development and maintenance of reports created with Report Builder 3.0

  • Utilize Report Builder 3.0 Wizards
  • Create an embedded data source
  • Create an embedded data set
  • Create shared data sources and data sets
  • Use report parameters
  • Use report expressions
  • Create report gauges
  • Create report graphs
  • Use images in reports
  • Use report lists
  • Use report tables
  • Use the matrix
  • Create maps in reports
  • Create sub reports
  • Use report parts
  • Create interactive reports
  • Use keyboard shortcuts
  • A basic understanding of relational databases.
  1. Course Overview
    1. Introduction
    2. Course Materials
    3. Facilities
    4. Prerequisites
    5. What We'll Be Discussing
    6. Lab 1: The training environment
      1. Become familiar with the class setup
  2. Introduction to Report Builder 3.0
    1. Plan your reports
    2. The Interface
    3. Variances between SQL versions
    4. How to use Report Builder 3.0 with SQL Express 2012
    5. Data Sources
    6. Data Sets
    7. Lab 1: Introduction to Report Builder 3.0
      1. Explore Report Builder 3.0
      2. Create embedded Data source and sets
      3. Create shared Data Source and Sets
  3. Report Builder 3.0 Wizards
    1. Explore the Report Builder 3.0 Wizards
    2. Create reports with the Wizards
    3. Lab 1: Report Builder 3.0 Wizards
      1. Use the Wizards to create reports
  4. Report Builder 3.0 Basic Reports
    1. Report Lists
    2. Report Tables
    3. Report Matrix
    4. The Data Region
    5. Report Parameters
    6. Report Expressions
    7. Formatting Reports
    8. Lab 1: Report Builder 3.0 Basic Reports
      1. Create a report using a List
      2. Create a report using a Table
      3. Create a report using a Matrix
      4. Create a report using multiple Data Regions
      5. Use Report Parameters
      6. Use Report Expressions
      7. Format the report
      8. Save Report Parts for reuse
  5. Report Builder 3.0 Graphics
    1. Report Charts
    2. Report Images
    3. Report Gauges
    4. Report Maps
    5. Lab 1: Report Builder 3.0 Graphics
      1. Create a report with Charts
      2. Create a report with Images
      3. Create a report with Gauges
      4. Create a report with Maps
  6. Intermediate Reports
    1. Time Intelligence
    2. Sub Reports
    3. Interacting with Actionable Reports
    4. Reuse Report Parts
    5. Lab 1: Intermediate Reports
      1. Create Sub Reports
      2. Create a report that allows interaction
      3. Reuse Report Parts
      4. Use Time Intelligence
  7. Report Builder 3.0 Tips and Tricks
    1. Over 100 step-by-step examples for report situations
    2. Lab 1: Report Builder 3.0 Tips and Tricks
      1. Over 100 step-by-step examples for report situations

InterSource Geneva, a premier Information Technology training firm, offers over 400 different courses on server, database and programming technologies, as well as end-user classes for the most popular office, graphics and design applications. We serve clients in Switzerland (Geneva, Lausanne, Bern, Basel, Zurich) and throughout Europe (France, Germany, Austria, Finland, Sweden, England, Netherlands, Spain, etc.).


InterSource offers custom, private courses at client sites, standard public courses in our Geneva classroom, and online training via live Web conference. Training is offered in English and many other languages (Francais, Deutsch, Espanol, Italiano.)


For an overall view of our offerings, please visit us at www.intersource.ch.