Discover Classes. Earn Rewards.

Writing Analytical Queries for Business Intelligence

at Hartmann Software Group - Lodo

Course Details
Price:
$1,290 20 seats left
Start Date:

Mon, Oct 28, 9:00am - Oct 30, 5:00pm (3 sessions)

Location:
Lodo
1624 Market St Ste 202
Btwn 16th St Mall & 17th St
Denver, Colorado 80202
(Map)
Share:
Purchase Options
No Booking Fees Book Now Save to WishList

1 person saved this class

Give as a Gift
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 10
Teacher: HSG Instructors

What you'll learn in this business intelligence training:

This three-day instructor led Microsoft SQL Server 2016 Training Course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Specifically, this Microsoft SQL Server 2016 Training Course presents TSQL within the context of data analysis Â?Â? in other words, making meaning from the data rather than transaction-oriented data-tier application development.

The Microsoft SQL Server 2016 Training Course starts with a brief discussion of levels of measurement and quantitative research methodology, and integrates these concepts into each TSQL topic presented. The goal is to provide a consistent, direct, and purposeful learning path for RDBMS data retrieval for use in analytical tools such as SQL Server Reporting Services, PowerBI, R, and Excel.

Audience
This Microsoft SQL Server 2016 Training Course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools.

Course Outline 
  • Module 1: Introduction to TSQL for Business Intelligence
  • Module 2: Turning Table Columns into Variables for Analysis: SELECT List Expressions, WHERE, and ORDER BY
  • Module 3: Combining Columns from Multiple Tables into a Single Dataset: The JOIN Operators
  • Module 4: Creating an Appropriate Aggregation Level Using GROUP BY
  • Module 5: Subqueries, Derived Tables and Common Table Expressions
  • Module 6: Encapsulating Data Retrieval Logic
  • Module 7: Getting Your Dataset to the Client
Note:
HSG courses are taught by the experienced instructors who are proven experts in their field. Our instructors are highly knowledgeable, friendly, reliable and inspiring. They speak and teach industry's best practices and often customize classes to meet individual needs.

Students are encouraged to ask questions and participate in discussions and training-labs.

Still have questions? Ask the community.

Refund Policy
To cancel or reschedule your registrations without penalty or charge, please notify us at [email protected] 14 days or more before the first day of my class.

Map

Google Map

Hartmann Software Group

All classes at this location

Start Dates (1)
Start Date Time Teacher # Sessions Price
9:00am - 5:00pm HSG Instructors 3 $1,290
This course consists of multiple sessions, view schedule for sessions.
Tue, Oct 29 9:00am - 5:00pm HSG Instructors
Wed, Oct 30 9:00am - 5:00pm HSG Instructors

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 12900 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

School: Hartmann Software Group

 

​The solution to most IT related problems lies in a better understanding of the technology.

Founded in June of 2002, the Hartmann Software Group (HSG) is an IT training company specializing in complicated software development languages and technologies ranging from C++ to Weblogic/Oracle Application...

Read more about Hartmann Software Group

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified DEN educator.

Ready to take this class?
BOOK NOW
Taking this class for work? Get exclusive perks & discounts for free.
Loading...