Data & Analytics

In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS.

In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data.

This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence.

This three-day instructor-led course is designed for database administrators and Windows engineers to familiarize them with the concepts in SQL AlwaysOn and High Availability. The course utilizes SQL 2016, but explains the differences from SQL 2012- SQL 2014.

This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs. This course updates and replaces course 10985C previously published under the same title.

SQL Server Integration Services is the Community Courseware version of 20767CC Implementing a SQL Data Warehouse. This five-day instructor-led course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server. This course is similar to the retired Course 20767-C: Implementing a SQL Data Warehouse but focuses more on building packages, rather than the entire data warehouse design and implementation.

This course is designed to teach software developers how to create AI solutions that leverage Azure Cognitive Services, Azure Cognitive Search, and Microsoft Bot Framework to build computer vision, language analysis, knowledge mining, intelligent search, and conversational AI solutions on Azure.   

This course is designed for candidates looking to demonstrate foundational-level knowledge of machine learning (ML) and artificial intelligence (AI) concepts, and related Microsoft Azure services. You will learn how to use Azure services to create machine learning, computer vision, and natural language processing solutions through hands-on activities. The course is intended for candidates with both technical and non-technical backgrounds. Data science and software engineering experience are not required; however, awareness of cloud basics and client-server applications would be beneficial.

CompTIA Data+ is an early-career data analytics certification for professionals tasked with developing and promoting data-driven business decision-making. CompTIA Data+ gives you the confidence to bring data analysis to life.

As the importance for data analytics grows, more job roles are required to set context and better communicate vital business intelligence. Collecting, analyzing, and reporting on data can drive priorities and lead business decision-making.

In this course you will build core knowledge and skills in managing containers through hands-on experience with Docker, Kubernetes, and the Red Hat® OpenShift® Container Platform and understand one of the key tenets of the DevOps movement: continuous integration and continuous deployment. Containers have become a key technology for the configuration and deployment of applications and microservices. Kubernetes is a container orchestration platform that provides foundational services in Red Hat OpenShift Container Platform, allowing enterprises to manage container deployments and scale their applications using Kubernetes. In addition to gaining an understanding of these tools, you will build core administration skills through the installation, configuration, and management of an OpenShift cluster.

In this course, students will create a basic report by connecting to a database and modifying the report’s presentation.

In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency.