SQL queries (for data source queries and data transformations)
Infrastructure as code (IaC) for repeatable deployments (for example, AWS Cloud Development Kit [AWS CDK], AWS CloudFormation)
Data structures and algorithms (for example, graph data structures and tree data structures)
Storage platforms and their characteristics
Storage services and configurations for specific performance demands
Data storage formats (for example, .csv, .txt, Parquet)
How to align data storage with data migration requirements
How to determine the appropriate storage solution for specific access patterns
How to manage locks to prevent access to data (for example, Amazon Redshift, Amazon RDS)
How to create a data catalog
Data classification based on requirements
Components of metadata and data catalogs
Appropriate storage solutions to address hot and cold data requirements
How to optimize the cost of storage based on the data lifecycle