Learn SQL Reporting Services Beginning Report Training

Last updated 12/2020
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 5.50 GB | Duration: 6h 33m

Beginner's Report Authoring. Create Lists, Reports, Charts, Bubble Maps, Invoices and more. No prior knowledge needed.

What you'll learn
Video Lessons
List Reports, Drill-Down Reports, Invoice Reports, Cross-Tab Reports
Line Charts, Multiple Series Charts, Pie Charts
Bubble Maps, Gauges, Dashboards
Custom Invoices, Logos, Layouts
Formatting
Expressions
Report Wizard
Database Query Designer
Much More!

Requirements
Laptop or Desktop PC for Practice

Description
Building nice looking professional quality reports doesn't have to be difficult or even time consuming. If you have the right tools and some basic knowledge, report authoring can be one of the most rewarding activities. SQL Server Reporting Services is definitely the right tool and this course teach you the basic knowledge. In this training you will learn how to create pixel-perfect reports that retrieve information from SQL Server. You will work with the report designer to combine tables, textboxes, charts, gauges, maps, and images to create list reports, drill-down reports, map bubble reports, dashboard reports, invoice reports, and many more. In this course, veteran consultant, Joey Blue, leads you through lessons where you will work with a fictitious music delivery company and you will be faced with real world scenarios that will force you to create 10 different reports in an iterative manner. All of this report authoring is done on your laptop or desktop pc. There are videos that show you step-by-step how to setup your computer to work through the examples as you watch the videos. The only prerequisite for this course is an Internet Connection and a PC. You don't even need to know SQL. Everything else will be taught in the course through the video lessons. Report Authoring is a great skill for today's economy. Just click the "Take This Course" button above, fill out the information, and we'll see you on the other side.

Overview
Section 1: Module #1: Foundation

Lecture 1 Foundation #1 – Getting Started

Lecture 2 Learning Outline

Lecture 3 Training Slideshow

Lecture 4 Foundation #2 - Installing Tools

Lecture 5 Foundation #2a - Installing SQL Server Developer Edition

Lecture 6 Foundation #2b - Installing SQL Server Management Studio

Lecture 7 Foundation #2c - Installing Visual Studio for SQL Server Reporting Services

Lecture 8 Foundation #3 – Installing the Chinook Database

Lecture 9 Foundation #4 – What's in the Chinook Database?

Lecture 10 Foundation #5: SQL Server Reporting Services Components

Lecture 11 Foundation #6: SQL Server Reporting Services Tools

Lecture 12 Foundation #7: Getting Help with SQL Server Reporting Services

Section 2: Module #2: Working with Visual Studio (formerly: Sql Server Data Tools (SSDT))

Lecture 13 Lesson #1 – Creating a Project in SQL Server Data Tools (SSDT)

Lecture 14 Lesson #2 – Solutions, Project, and Reports Hierarchy

Lecture 15 Lesson #3 – Opening a Project in SQL Server Data Tools (SSDT)

Section 3: Module #3: Creating Reports with the Report Wizard

Lecture 16 Lesson #4 – Report 1 – Customer Email List

Lecture 17 Lesson #5 – Report 1b – Customer Email List Modified

Lecture 18 Lesson #6 – Report 2 – Customer Invoice Total Report

Lecture 19 Lesson #7 – Report 2b – Customer Invoice Total Report Modified

Lecture 20 Lesson #8 – Report 3 – Support by Customer City Report

Lecture 21 Lesson #9 – Report 3b – Support by Customer City with Parameters

Lecture 22 Lesson #10 – Report Architecture

Section 4: Module 4: Creating Reports from Scratch

Lecture 23 Lesson #11 – Report 4 – Sales by City

Lecture 24 Lesson #12 – Report 4b – Sales by City Modifications

Lecture 25 Lesson #13 – Report 4c – Sales by City – Properties Window

Lecture 26 Lesson #14 – Report 4d – Sales by City – Country Parameters

Lecture 27 Lesson #15 – Report 4e – Sales by City – Display Parameters

Lecture 28 Lesson #16 – Report 4f – Sales by City – Merge Cells

Section 5: Module 5 – Charts, Maps, Gauges, and Dashboards

Lecture 29 Lesson #17 – Report 5 – Sales over Time – Line Chart

Lecture 30 Lesson #18 – Report 6 – Sales and Invoice over Time Chart

Lecture 31 Lesson #19 – Report 6b – Sales and Invoice over Time – Secondary Axis

Lecture 32 Lesson #20 – Report 6c – Sales and Invoice over Time – Calculated Field

Lecture 33 Lesson #21 – Report 7 – Sales by Genre

Lecture 34 Lesson #22 – Report 8 – Sales by State

Lecture 35 Lesson #23 – Report 9 – Management Dashboard – Part 1 – Datasource

Lecture 36 Lesson #24 – Report 9 – Management Dashboard – Part 2 – Report

Section 6: Module 6 – The Customer Invoice Report

Lecture 37 Lesson #25 – Report 10 – Customer Invoice - Part 1 – Datasource

Lecture 38 Lesson #26 – Report 10 – Customer Invoice – Part 2 – Invoice Line Items

Lecture 39 Lesson #27 – Report 10 – Customer Invoice – Part 3 – Invoice Header and Bill To

Lecture 40 Lesson #28 – Report 10 – Customer Invoice – Part 4 – Logo and Border Formatting

Lecture 41 Lesson #29 – Report 10 – Customer Invoice – Part 5 – Total, Export to PDF, Image

Lecture 42 Lesson #30 – Report 10b – Customer Invoice Part 6 – Footer, Image, Global Variable

Lecture 43 Lesson #31 – Deploying Report to the Report Server and Report Manager

Section 7: Module 7 – Conclusion

Lecture 44 Lesson #32 – Course Review

Lecture 45 Lesson #33 – Next Steps – Where do you go from here?

Anyone wanting to learn Report Authoring with SQL Server Reporting Services

Buy Premium Account From My Download Links & Get Fastest Speed.