Menu
« Back to All Apprenticeships
Cloud Operations Specialist 1
Published
Competency-Based Apprenticeship
Industries
O*Net Code
15-1232.00
Rapids Code
2085CB
Req. Hours
0
State
DC
Created
Jul 16, 2021
Updated
Jul 16, 2021
Time-Based Skills
3 skill sets | 0 total skills
Customer support
Cloud Services Management
Ticket Management and Documentation
Technical Instruction
CompTIA Network+ - 90 req. hrs
Network Architecture
Network Operations
Network Security
Troubleshooting
Industry Standards, Practices and Network Theory
CompTIA Linux + - 90 req. hrs
System Architecture
Linux installation and packet management
GNU and UNIX Commands
Devices, Linux Filesystems, Filesystem Hierarchy Standard
Shells, Scripting and Data Management
User interfaces and Desktops
Administrative Tasks
Essential System Services
Networking Fundamentals
Security
Database Administration Fundamentals - 30 req. hrs
Understand Core Database Concepts
Create Database Objects
Manipulate Data
Understand Data Storage
Administer a Database
Implement transactions
Querying Microsoft SQL Server - 50 req. hrs
Describe the basic architecture and concepts of SQL Server
Understand the similarities and differences between Transact-SQL and other computer languages
Write SELECT queries
Query multiple tables
Sort and filter data
Describe the use of data types in SQL Server
Modify data using Transact-SQL
Use built-in functions
Group and aggregate data
Use subqueries
Use table expressions
Use set operators
Use window ranking, offset and aggregate functions
Implement pivoting and grouping sets
Execute stored procedures
Program with T-SQL
Implement error handling
Implement transactions
Administering SQL Databases - 50 req. hrs
Describe core database administration tasks and tools.
Install and configure SQL Server 2014
Configure SQL Server databases and storage
Plan and implement a backup strategy
Restore databases from backups
Import and export data. Monitor SQL Server
Trace SQL Server activity
Manage SQL Server security
Audit data access and encrypt data
Perform ongoing database maintenance
Automate SQL Server maintenance with SQL Server Agent Jobs
Configure Database Mail, alerts and notifications
Implementing a Data Warehouse with SQL Server - 50 req. hrs
Describe data warehouse concepts and architecture considerations.
Select an appropriate hardware platform for a data warehouse.
Design and implement a data warehouse.
Implement Data Flow in an SQL Server Integration Services (SSIS) Package.
Implement Control Flow in an SSIS Package.
Debug and Troubleshoot SSIS packages.
Implement an extract, transform, load (ETL) solution that supports incremental data extraction.
Implement an ETL solution that supports incremental data loading.
Implement data cleansing by using Microsoft Data Quality Services.
Implement Master Data Services to enforce data integrity.
Extend SSIS with custom scripts and components.
Deploy and Configure SSIS packages.
Describe how BI solutions can consume data from the data warehouse
