The main purpose of the course is to give students a good understanding of data analysis with Power BI.
Students are expected to take two courses during this data Analytics training. The course are:
The course includes SQL Development, creating visualizations, the Power BI Service, and the Power BI Mobile App.
Acceptance into The Bright Technology Training is competitive and all students seeking admission must meet all applicable requirements. In order to be considered for admission, all applicants must:
After finishing this course, students have the confidence to use Transact-SQL commands to interact with relational databases. Students will be able to:
Learn the Components of T-SQL
Understand Sets and Predicate Logic
Master the Logical Order of Operations in SELECT statements
Lab: Introduction to Transact-SQL Querying
Write Simple SELECT Statements and CASE Expressions
Eliminate Duplicates With DISTINCT
Practice Using Column and Table Aliases
Lab: Writing Basic SELECT Statements
Understand Joins
Query with Inner Joins, Outer Joins, Cross Joins and Self Joins
Lab: Querying Multiple Tables
Learn How to Sort Data
Filter Data with Predicates
Work With Unknown Values
Lab: Sorting and Filtering Data
Learn About SQL Server 2016 Data Types
Work With Character Data and Date and Time Data
Lab: Working with SQL Server 2016 Data Types
Insert Data
Modify and Delete Data
Lab: Using DML to Modify Data
Write Queries with Built-In Functions
Practice Conversion Functions and Logical Functions
Practice Using Functions to Work with NULL
Lab: Using Built-In Functions
Use Aggregate Functions and the GROUP BY Clause
Filter Groups with HAVING
Lab: Grouping and Aggregating Data
Write Self-Contained and Correlated Subqueries
Execute the EXISTS Predicate with Subqueries
Lab: Using Subqueries
Navigate Views and Inline Table-Valued Functions
Manipulate Derived Tables and Common Table Expressions
Lab: Using Table Expressions
Complete Queries with the UNION Operator
Use EXCEPT, INTERSECT and APPLY
Lab: Using Set Operators
Create Windows with OVER
Explore Window Functions
Lab: Using Windows Ranking, Offset, and Aggregate Functions
Write Queries with PIVOT and UNPIVOT
Work with Grouping Sets
Lab: Pivoting and Grouping Sets
After completing this course, students will be able to:
3985 Steve Reynolds Blvd Phase 11 Building Q, Norcross GA 30093