All Analytics & BI Courses
Filter by Topic
Filter by Vendor
PL-300: Microsoft Power BI Data Analyst
Course Description: This course will discuss the various methods and …
Advanced Architecting on AWS
Course Description Learn how to build complex solutions that incorporate …
What you'll learn
Apply the AWS Well-Architected Framework
Manage multiple AWS accounts for your organization
Connect an on-premises datacenter to the AWS Cloud
Discuss billing implications of connecting multi-region VPCs
Move large data from an on-premises datacenter to AWS
Design large data stores for the AWS Cloud
Understand different architectural designs for scaling a large website
Protect your infrastructure from distributed denial of service (DDOS) attacks
Secure your data on AWS with encryption
Design protection of data at rest and data in transit
Enhance the performance of your solutions
Select the most appropriate AWS deployment mechanism
Enterprise Scala with Spark
Course Description Learn about Scala and enterprise integration in a …
What you'll learn
Essential Scala programming, leveraging your existing OO development experience
How to write essential Spark programs and perform exploratory data analysis in Scala and the Spark shell
Work with Spark Core
Work with NoSQL
How to write programs for Spark Streaming in Scala
Apache Spark for Data Scientists
Course Description Learn Spark skills from a data science perspective …
What you'll learn
The essentials of Spark architecture and applications
How to execute Spark Programs
How to create and manipulate both RDDs (Resilient Distributed Datasets) and UDFs (Unified Data Frames)
How to integrate machine learning into Spark applications
How to use Spark Streaming
Developing with Spark for Big Data (TTSK7505)
Course Description Learn advanced Big Data and Spark skills to …
What you'll learn
The essentials of Spark architecture and applications
How to execute Spark Programs
How to create and manipulate both RDDs (Resilient Distributed Datasets) and UDFs (Unified Data Frames)
How to persist and restore data frames
Essential NOSQL access
How to integrate machine learning into Spark applications
How to use Spark Streaming and Kafka to create streaming applications
Hadoop Developer Foundations
Course Description New – Learn about the Hadoop ecosystem and …
What you'll learn
Introduction to Hadoop
HDFS
YARN
Data Ingestion
HBase
Oozie
Working with Hive
Hive advanced
Hive in Cloudera/Hortonworks Distribution (or tools of choice)
Working with Spark
Spark Basics
Spark Shell
RDDs
Spark Dataframes and Datasets
Spark SQL
Spark API programming
Spark and Hadoop
Machine Learning (ML/MLlib)
GraphX
Spark Streaming
Introduction to Hadoop Administration (TTDS6503)
Course Description Learn how to install, maintain, monitor, troubleshoot, optimize, …
What you'll learn
Understand the benefits of distributed computing
Understand the Hadoop architecture (including HDFS and MapReduce)
Define administrator participation in Big Data projects
Plan, implement, and maintain Hadoop clusters
Deploy and maintain additional Big Data tools (Pig, Hive, Flume, etc.)
Plan, deploy and maintain HBase on a Hadoop cluster
Monitor and maintain hundreds of servers
Pinpoint performance bottlenecks and fix them
55232-A: Writing Analytical Queries for Business Intelligence
Course Description: This three-day instructor led course is about writing …
What you'll learn
Identify independent and dependent variables and measurement levels in their own analytical work scenarios.
Identify variables of interest in relational database tables.
Choose a data aggregation level and data set design appropriate for the intended analysis and tool.
Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others.
Create stored procedures, views, and functions to modularize data retrieval code.
Describe the purpose of analytical queries
Describe the function of TSQL data retrieval in an analytics/business intelligence environment
Describe the primary functions of the database engine
Discuss TSQL as a declarative language
Identify variables of interest in database tables
Write basic SELECT queries
Implement column expressions in SELECT queries
Implement column and table aliases
Describe data types and Implement data type conversions
Implement built-in functions
Use WHERE and ORDER BY clauses in SELECT queries
Discuss and describe the conceptual flow of JOIN operations
Implement INNER and OUTER JOIN operations on two or more tables
Describe the order of operations of SELECT clauses
Combine JOIN operations with WHERE and ORDER BY
Describe the row granularity of result sets
Discuss and implement aggregate functions to achieve required row granularity
Use GROUP BY to calculate aggregate values for groups
Use HAVING to filter records in the result set by aggregate value
Combine GROUP BY and HAVING with WHERE and ORDER BY
Describe and discuss the rationale of creating intermediate results sets within SELECT queries
Implement non-correlated and correlated subqueries
Implement derived tables
Implement Common Table Expressions
Create intermediate to advanced TSQL queries to retrieve result sets for analysis
Identify scenarios in which views, table-valued functions, and stored procedures simply data retrieval
Compare and contrast views, table-valued functions, and stored procedures
Create views, table-valued functions, and stored procedures
Describe the security requirement for creating database objects
Implement views, table-valued functions, and stored procedures for users with read-only access to source data
Describe the properties of database connection strings
Run queries from, and return results to, Excel, PowerBI, and RStudio
Export query results to external text files using the SSMS results pane, the bcp utility, and the Import/Export Wizard
- 1
- 2