SQL Server 2016 Database Reporting
Access Duration - 365 Days
Accredited By "CPD & iAP"
Guided Learning Hours (04)
Course Material
Number of Modules 11
Mock Exam Included
Final Exam Included
0( 0 REVIEWS )
141 STUDENTS
Accredited By
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
Course Curriculum
| Getting Started | |||
| Online Training User Manual | |||
| E Certificate Download Guide | 00:00:00 | ||
| 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 | ||
No Reviews found for this course.