Enquire Now
Menu

SQL Server 2016 Database Reporting

0( 0 REVIEWS )
137 STUDENTS
Add To Cart
£199 £49 (inc. VAT)
Buy Now
  • 0 Days
  • ACCREDITED BY CPD & iAP
  • 04Guided Learning Hours
  • Course Material
  • 11 Number of Modules
  • Exam Included

Overview

Were you looking for a qualification that could boost your candidature to get into the business intelligence field? Or were you looking to expand your knowledge on database reporting to progress substantially within the industry? If so, this course in Database reporting might just be the one you were looking for, as this course has been developed to thoroughly guide you on creating effective database reports using the data in SQL server 2016.

This course is set to provide you a hands-on experience by teaching you how to create your own wizard report using SQL server 2016. You will be first instructed on how to create your wizard report by incorporating features such as data sources, report queries, headers, footers, built-in fields, query-defined fields, images and report metadata. You will then move onto explore the tabular and Matrix report types to configure them appropriately within your report wizard.

Drill-down and drill-through are two data display types that will provide you access to more granular information and in-depth analysis respectively. This course will walk you through how to incorporate these two report types within your report, along with other data representations such as pie charts, bar charts, gauges, sparklines, indicators and analytical maps to further enhance the data being presented. Additionally, you will also get to explore the structure and functionality of the reporting services web portal to deploy and secure reports on the portal. By the end of this course, you will have a solid knowledge on database reporting to create mind-blowing reports using the data in SQL server 2016.

Why study at Global Edulink?

Global Edulink offers the most convenient path to gain recognised skills and training that will give you the opportunity to put into practice your knowledge and expertise in an IT or corporate environment. You can study at your own pace at Global Edulink and you will be provided with all the necessary material, tutorials, qualified course instructor, narrated e-learning modules and free resources which include Free CV writing pack, free career support and course demo to make your learning experience more enriching and rewarding.

 

  • Access Duration
  • Who is this course aimed at?
  • Entry Requirements
  • Method Of Assessment
  • Certification
  • Career Path  
  • Other benefits

The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course.  The course is self-paced and you can complete it in stages, revisiting the lectures at any time.

This course will interest individuals aspiring to or already in the business intelligence field
  • Learners must be age 16 or over and should have basic understanding of the English Language, numeracy, literacy and ICT.
  • A basic knowledge on SQL server is required to follow up on this course
  • Previous experience with SSRS will be an advantage, although not mandatory.
The course is assessed online with a final, multiple-choice test, which is marked automatically. You will know instantly whether you have passed the course.
Those who pass this test will get a certificate in SQL Server 2016 Database Reporting

This certificate will enhance your qualifications for a number of jobs in the business intelligence field of work. You can also use this certificate to expand your education in the area or to win the various job incentives put forth by your employer. Listed below are some of the jobs this certificate will benefit you in, along with the average UK salary per annum according to https://www.payscale.com/career-path-planner,

  • Business Intelligence (BI) developer – £35,618 per annum
  • BI analyst – £30,483 per annum
  • BI consultant – £43,880 per annum
  • BI Manager – £49,084 per annum
  • High-quality e-learning study materials and mock exams.
  • Tutorials/materials from the industry leading experts.
  • 24/7 Access to the Learning Portal.
  • The benefit of applying for TOTUM extra Discount Card.
  • Recognised Accredited Qualification.
  • Excellent customer service and administrative support

Key Features

Gain an accredited UK qualification

Access to excellent quality study materials

Learners will be eligible for TOTUM Discount Card

Personalized learning experience

One year’s access to the course

Support by phone, live chat, and email

Course Curriculum

Section 1: Installation and setup
1.1. The Course Overview 00:00:00
1.2. Installing and Configuring SQL Server 2016 Developer Edition 00:00:00
1.3. Installing SQL Server Management Studio 00:00:00
1.4. Installing Visual Studio 00:00:00
1.5. Installing SQL Server 2016 Data Tools 00:00:00
1.6. Installing SQL Server Sample Databases 00:00:00
1.7. SQL Server 2016 Reporting Services Configuration Manager 00:00:00
Section 2: Wizarding Your First Report
2.1. Data Sources 00:00:00
2.2. Report Queries 00:00:00
2.3. Tabular Report Types and Their Configuration 00:00:00
2.4. Matrix Report Types and Their configuration 00:00:00
2.5. Deployment Location and Completing the Wizard 00:00:00
Section 3: Formatting a Tabular Report
3.1. Adding a Column after the Wizard 00:00:00
3.2. Formatting Column Headers 00:00:00
3.3. Interactive Sorting 00:00:00
3.4. Adding Calculated Fields and Using Expressions 00:00:00
3.5. Formatting Cells 00:00:00
3.6. Viewing the Report on the Report Server 00:00:00
3.7. Formatting the Report for Printing 00:00:00
Section 4: Adding Headers and Footers
4.1. Adding the Header and Footer 00:00:00
4.2. Using Built-in Fields 00:00:00
4.3. Adding Query-Defined Fields 00:00:00
4.4. Adding Images to the header 00:00:00
4.5. The Importance of Displaying Report Metadata on the Report 00:00:00
Section 5: Creating a Drill-Down Report
5.1. Queries Specialized for Drill- Down Reports 00:00:00
5.2. Creating the Drill- Down Report 00:00:00
5.3. Grouping in SSRS 00:00:00
5.4. Toggling the Display 00:00:00
5.5. Adding Summary Rows 00:00:00
Section 6: Using Parameters in a Report
6.1. Parameter Types 00:00:00
6.2. Available and Default Values 00:00:00
6.3. Filtering by the Parameter Value 00:00:00
6.4. Displaying Parameter Values Within the Report 00:00:00
Section 7: Creating a Drill-Through Report
7.1. Creating a Child Report 00:00:00
7.2. Adding a Parameter to a Query 00:00:00
7.3. Configuring the Drill-Through Reporting Action 00:00:00
7.4. Deploying the Drill-Through Reports to the Report Server 00:00:00
Section 8: Baking Pie and Bar Charts
8.1. Queries Optimized for Pie Charts and Bar Charts 00:00:00
8.2. Creating the Pie Chart Report 00:00:00
8.3. Creating the Bar Chart Report 00:00:00
8.4. Formatting the Legends and Labels 00:00:00
8.5. Placing Two Subreports Onto One Report 00:00:00
Section 9: Gauges, Sparklines, and Indicators
9.1. Queries Optimized for Gauges, Sparklines, and Indicators 00:00:00
9.2. Creating a Report Containing a Gauge 00:00:00
9.3. Creating a Report Containing a Sparkline 00:00:00
9.4. Creating a Report Containing an Indicator 00:00:00
9.5. Creating a Dashboard 00:00:00
Section 10: Analytical Maps
10.1. Queries Optimized for Analytical Maps 00:00:00
10.2. Creating a Point Map 00:00:00
10.3. Creating an Analytical Line Map 00:00:00
10.4. Creating a Bubble Map 00:00:00
10.5. Creating a Polygon Map 00:00:00
Section 11: The Reporting Services Web Portal
11.1. Web Portal Folder Structure 00:00:00
11.2. Deploying Reports to the Portal 00:00:00
11.3. Securing Reports on the Portal 00:00:00
11.4. Web Portal Functionality 00:00:00
Mock Exam
Mock Exam : SQL Server 2016 Database Reporting 00:40:00
Exam
Exam : SQL Server 2016 Database Reporting 00:40:00

Students feedback

N.A

Avarage rating ()
5 Star
4 Star
3 Star
2 Star
1 Star

No Reviews found for this course.

Add To Cart
£199 £49 (inc. VAT)
Buy Now
  • 0 Days
  • ACCREDITED BY CPD & iAP
  • 04Guided Learning Hours
  • Course Material
  • 11 Number of Modules
  • Exam Included
WhatsApp chat