Cloud Operations Specialist 1

Competency-Based Apprenticeship
Sponsoring Company:
Apprenti
Industries
O*Net Code
15-1232.00
Rapids Code
2085CB
Req. Hours
0
State
DC
Created
Apr 04, 2021
Updated
Apr 04, 2021

Time-Based Skills

3 skill sets | 0 total skills | 0 total hours
Customer support - 0 req. hrs
Cloud Services Management - 0 req. hrs
Ticket Management and Documentation - 0 req. hrs

Technical Instruction

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