Explore KSACs by Pathway

Explore Knowledge, Skills, Abilities, and Credentials (KSACs) by IT Pathway.

1. Data Storage, Operations, and Administration

Label KSAC Description Bloom's Taxonomy Level Cross-Cutting
a Explain the role of data, information, and databases in organizations (for decision making). ability 4
b Define and appropriately use key terms such as: information, data, database, database management system, metadata, data warehousing and data mining. knowledge 2
c Describe a database management system. knowledge 2
d Identify various types of databases including local vs cloud. knowledge 2
e Describe a database management system (DBMS) and identify specific DBMS platforms and the role they play. knowledge 2
f Discuss and differentiate end-user vs meta data. knowledge 2
g Identify and differentiate structured vs unstructured data. knowledge 2
h Discuss and differentiate OLTP and OLAP databases. knowledge 2
i Demonstrate an understanding of database performance monitoring and tuning. knowledge 2
j Explain the data life cycle in terms of acquisition, migration, retention, expiration and disposition. knowledge 2
k Demonstrate an understanding of backup and recovery procedures and their necessity for disaster recovery and business continuity. knowledge 2
l Apply SQL data manipulation language such as Select (From), Insert, Update, Delete, JOIN (inner, outer, full, left, right), Where, Group By, Order By, etc. ability 4 Software Development
m Demonstrate fundamental programming skills including the use of variables, loops, conditional branching, and program logic. skill 4 Software Development, Cybersecurity
n Describe the implications of data architecture on data processing. knowledge 2 Data Analytics
o Demonstrate an understanding content tagging and its role in data management. knowledge 2
p Demonstrate an understanding of cloud architecture in terms of data storage and access. knowledge 2 All
q Explain version control and the significant role it plays in data management. knowledge 3
r Identify and describe basic file types and demonstrate fundamental file management. skill 2 All
s Ability to install and configure software. ability 3 All


Vendor Certifications - DBMS

  1. Oracle Associate
  2. Microsoft
  3. IBM

Vendor Certifications - Cloud

  1. AWS
  2. Oracle
  3. Microsoft

Vendor Certifications - Tools

  1. Tableau
  2. SAS


  2. DataCamp Certificate