CompTIA Cloud+

With 94% of enterprises relying on cloud infrastructure and hybrid cloud adoption growing rapidly, technical professionals must be equipped to manage and secure cloud environments across platforms. The CompTIA Cloud+ certification course validates the hands-on skills required to deploy, maintain, and troubleshoot cloud systems in real-world environments. This course covers critical topics including cloud architecture, performance monitoring, automation, and security. It prepares IT professionals for the CompTIA Cloud+ certification exam (CV0-003) and supports career growth in cloud infrastructure roles.

Course Details

Price:

$2,495.00

Days:

Location:

Virtual

Course Overview

Prepare to deploy cloud solutions Deploy a pilot project Test a pilot project deployment Design a secure network for cloud deployment Determine CPU and memory sizing for cloud deployments Determine storage requirements for cloud deployments Plan Identity and Access Management for cloud deployments Analyze workload characteristics to ensure successful migration to the cloud Secure systems to meet access requirements Maintain cloud systems Implement backup, restore, and business continuity measures Analyze cloud systems for required performance Analyze cloud systems for anomalies and growth forecasting Troubleshoot deployment, capacity, automation, and orchestration issues Troubleshoot connectivity issues Troubleshoot security issues

4-5 years total IT experience, including 2-3 years as a systems administrator of cloud engineer

Module 1: Introduction to T-SQL for Business Intelligence

SQL programming approaches: transactional vs analytical
The database engine and SSMS
Introduction to SELECT queries
Using the CarDeal sample database
Lab: Intro to T-SQL for BI

Module 2: SELECT Expressions, WHERE, and ORDER BY

Column expressions, data types, and built-in functions
Column/table aliases and conversions
Using WHERE and ORDER BY clauses
Lab: Write filtering and sorting queries

Module 3: JOIN Operators and Combining Tables

Primary/foreign key relationships
CROSS JOIN, INNER JOIN, OUTER JOIN variations
Multi-table joins and nested joins
Combining JOINs with WHERE and ORDER BY
Lab: Write multi-table SELECT queries

Module 4: Aggregating with GROUP BY

Defining aggregation level and granularity
COUNT, SUM, AVG, and other aggregate functions
GROUP BY and HAVING usage
Lab: Write grouped and aggregated queries

Module 5: Subqueries, Derived Tables, and CTEs

Writing correlated and non-correlated subqueries
Using derived tables in FROM clauses
Structuring logic with common table expressions (CTEs)
Lab: Create reusable query logic

Module 6: Encapsulating Data Retrieval Logic

Creating and using views
Table-valued functions and stored procedures
Creating read-access objects for analytical clients
Lab: Build encapsulated SQL logic

Module 7: Getting Your Dataset to the Client

Connecting SQL Server to Excel, Power BI, and RStudio
Exporting with SSMS, bcp utility, and Import/Export Wizard
Best practices for client-ready data delivery
Lab: Export datasets and connect to BI tools

Class Dates & Times


01/05/2026 - 01/09/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $2,495.00
05/04/2026 - 05/08/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $2,495.00

— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.

Student? Switch to our Career Center Site →