Create and manage a wide variety of reports using Structured Query Language (SQL) Server Reporting Services. Upon successful completion of this course you will be able to use SQL to create parameter reports using filters, cascading parameters, and stored procedures.
SQL is not a programming language but is a database management language for relational databases. Graduates of this course will be able to create and manage a wide variety of reports using SQL Server Reporting Services. You will also be able to use SQL to generate summary reports using aggregate functions and apply groups by summary, multi-table, cross-tab, simple graphs and charts, conditional formatting, calculated fields, and running totals.
At the successful completion of this course you will also be able to draft reports using ALL and multiple items, manually, or by using the SQL Wizard. Using the skills obtained in this course you will be able to import from MS Access and use SQL Server Reporting Services as an effective server-based reporting platform.
It is recommended that you complete CCTB111 SQL Introduction prior to enrolling in this course.