18756 Stone Oak Park Way, Suite200, San Antonio TX 78258 USA
100 Queen St W, Brampton, ON L6X 1A4, Canada
country flagUnited States
share button

55232: Writing Analytical Queries for Business Intelligence Training


What 55232: Writing Analytical Queries for Business Intelligence training is all about?

In this instructor-led training, Microtek Learning teaches students how to write T-SQL queries for database analysis, reporting, and business intelligence. This course presents TSQL within the data analysis context – to be specific, creating purpose using data rather than developing transaction-oriented data-tier applications. The course explains measurement levels and quantitative research methodology and submerges all the explained concepts with the presented TSQL topics. The objective here is to give a continuous, straightforward, and meaningful learning path for data retrieval from relational databases to use in analytical tools including SQL SRS, R, Power BI, and Excel.

3 SATVs applicable


Schedule
  • Delivery Format:
Date: Sep 30, 2020 | 9:00 am - 5:00 pm EST
Location: Online
$1725 USD
  • Delivery Format:
Date: Oct 07, 2020 | 9:00 am - 5:00 pm EST
Location: Online
$1725 USD
  • Delivery Format:
Date: Oct 14, 2020 | 9:00 am - 5:00 pm EST
Location: Online
$1725 USD
  • Delivery Format:
Date: Oct 21, 2020 | 9:00 am - 5:00 pm EST
Location: Online
$1725 USD
  • Delivery Format:
Date: Oct 28, 2020 | 9:00 am - 5:00 pm EST
Location: Online
$1725 USD
What are the course objectives for 55232: Writing Analytical Queries for Business Intelligence training?
  • Identifying dependent and independent measurement and variable levels in analytical work scenarios.
  • Identifying variables of interest in RDBMS tables.
  • Choosing data aggregation level and designing appropriate data set for the intended analysis tool.
  • Producing ready-to-use data sets using TSQL SELECT queries for analytic tools like Power BI, SQL SRS, R, SAS, Excel, SPSS, and others.
  • Creating stored procedures, functions, and views for modularizing data retrieval code.
Who should attend 55232: Writing Analytical Queries for Business Intelligence training?

The course is aimed at IT pros and data scientists seeking to learn how to use database analysis and reporting tools: SQL SRS, Power BI, R, SAS, Excel and more. They also look to learn using TSQL queries to retrieve data sets effectively through SQL server RDBMS to use with other tools.

What are the prerequisites for 55232: Writing Analytical Queries for Business Intelligence training?

Before going to 55232: Writing Analytical Queries for Business Intelligence course, understudies must have:

  • Setting learning of information examination and business knowledge situations. For instance, a comprehension of a business related business knowledge venture or need.
  • Fundamental information of the Windows working framework and its center usefulness, including document framework route.
  • Essential comprehension of the reason for social database administration frameworks, for example, SQL Server.
What is the course outline for 55232: Writing Analytical Queries for Business Intelligence training?
  • 1. Introduction to TSQL for Business Intelligence 
  • a). Two Approaches to SQL Programming 
  • b). TSQL Data Retrieval in an Analytics Environment 
  • c). The Database Engine 
  • d). SQL Server Management Studio and the CarDeal Sample Database 
  • e). Identifying Variables in Tables 
  • f). SQL is a Declarative Language 
  • g). Introduction to the SELECT Query
  • h). Lab : Introduction to TSQL for Business Intelligence
  • 2. Turning Table Columns into Variables for Analysis: SELECT List Expressions, WHERE, and ORDER BY 
  • a). Transforming Columns into Variables for Analysis 
  • b). Column Expressions, Data Types, and Built-in Functions 
  • c). SColumn aliases
  • d). Data type conversions
  • e). Built-in Scalar Functions
  • f). Table Aliases
  • g). The WHERE clause
  • h). ORDER BY 
  • i). Lab : Write quiries using:
  • i). Column and table aliases
  • ii). DISTINCT
  • iii). WHERE
  • iv). ORDER BY
  • v). Built-in functions
  • vi). Explicit and implicit data type conversion
  • 3. Combining Columns from Multiple Tables into a Single Dataset: The JOIN Operators
  • a). Primary Keys, Foreign Keys, and Joins
  • b). Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product
  • c). Understanding Joins, Part 2: The INNER JOIN
  • d). Understanding Joins, Part 3: The OUTER JOINS
  • e). Understanding Joins, Part 4: Joining more than two tables
  • f). Understanding Joins, Part 5: Combining INNER and OUTER JOINs
  • g). Combining JOIN Operations with WHERE and ORDER BY
  • h). Lab : Write SELECT queries using:
  • i). Inner join
  • ii). Left, right, and full join
  • iii). Joins of more than two tables
  • iv). Join operators, in addition to WHERE and ORDER BY
  • 4. Creating an Appropriate Aggregation Level Using GROUP BY
  • a). Identifying required aggregation level and granularity
  • b). Aggregate Functions
  • c). GROUP BY
  • d). HAVING
  • e). Order of operations in SELECT queries
  • f). Lab: Write queries using:
  • i). Aggregate functions
  • ii). Aggregate function with HAVING
  • iii). Aggregate function with GROUP BY and HAVING
  • iv). Aggregate function with GROUP BY, HAVING, WHERE, and ORDER BY
  • 5. Subqueries, Derived Tables and Common Table Expressions
  • a). Non-correlated and correlated subqueries
  • b). Derived tables
  • c). Common table expressions
  • d). Lab : Write queries using:
  • i). Non-correlated subqueries
  • ii). Correlated subqueries
  • iii). Derived tables
  • iv). Common table expressions
  • v). Subqueries, derived tables, and common table expressions in combination with other topics covered in previous modules
  • 6. Encapsulating Data Retrieval Logic
  • a). Views
  • b). Table-valued functions
  • c). Stored procedures
  • d). Creating objects for read-access users
  • e). Creating database accounts for analytical client tools
  • f). Lab : Encapsulating Data Retrieval Logic
  • 7. Getting Your Dataset to the Client
  • a). Connecting to SQL Server and Submitting Queries from Client Tools
  • b). Connecting and running SELECT queries from:
  • c). Excel
  • d). PowerBI
  • e). RStudio
  • f). Exporting datasets to files using
  • g). Results pane from SSMS
  • h). The bcp utility
  • i). The Import/Export Wizard
  • j). Lab : Getting Your Dataset to the Client
3 Days | $ 1725
4
  262 Ratings

1376 Learners