The groundwork
Read up on a domain and shore up the fundamentals before you sit a practice exam on it.
All certificationsA+ Core 1A+ Core 2AWS Certified AI PractitionerAWS Certified Machine Learning Engineer – AssociateCCNACCNP EnterpriseCCSPCISACISMCISSPCRISCCloud+CompTIA DataAI+CompTIA ITF+CompTIA SecAI+CySA+DataSys+DataXGitHub CopilotHealth InsuranceIAPP AIGPISACA CDPSELife InsuranceLinux+Network+PMI PMPPenTest+Project+Property and CasualtySIESSCPSecurity+Series 6Series 63Series 65Series 66Series 7Server+
Primary Keys and Foreign Keys: Establishing Database Relationships
DataSys+·Database Fundamentals
Read guide
DML Operations: INSERT, SELECT, UPDATE, and DELETE
DataSys+·Database Fundamentals
Read guide
Set-Based Logic and SQL Operations: UNION, INTERSECT, and DIFFERENCE
DataSys+·Database Fundamentals
Read guide
Transaction Control Language: Ensuring Data Consistency with ACID Principles
DataSys+·Database Fundamentals
Read guide
Programmatic SQL: Triggers, Stored Procedures, and Functions
DataSys+·Database Fundamentals
Read guide
SQL Joins: Combining Data from Multiple Tables
DataSys+·Database Fundamentals
Read guide
Views and Materialized Views: Simplifying Complex Queries
DataSys+·Database Fundamentals
Read guide
Aggregating Data with GROUP BY and Aggregation Functions
DataSys+·Database Fundamentals
Read guide
ANSI SQL Standards and Platform-Specific SQL Variations
DataSys+·Database Fundamentals
Read guide
NULL Values in SQL: Understanding Absence of Data
DataSys+·Database Fundamentals
Read guide
Server-Side vs. Client-Side Database Automation Scripts
DataSys+·Database Fundamentals
Read guide
ETL vs. ELT: Choosing the Right Data Transformation Approach
DataSys+·Database Fundamentals
Read guide
Database Automation Scripting Languages: Linux and Windows Environments
DataSys+·Database Fundamentals
Read guide
Core Database Operational Tasks and Automation Benefits
DataSys+·Database Fundamentals
Read guide
Server-Side Database Scripting Languages and Capabilities
DataSys+·Database Fundamentals
Read guide
Client-Side Database Scripting with General-Purpose Programming Languages
DataSys+·Database Fundamentals
Read guide
Identifying and Engaging Database Stakeholders During Requirements Gathering
DataSys+·Database Deployment
Read guide
Defining Database Objectives Through Use Cases and Functional Categories
DataSys+·Database Deployment
Read guide
Storage Technology Selection: SSDs, HDDs, and RAID Configurations
DataSys+·Database Deployment
Read guide
Vertical and Horizontal Scaling Strategies for Growing Databases
DataSys+·Database Deployment
Read guide
Data Retrieval, Processing, and Analysis Use Cases in Database Design
DataSys+·Database Deployment
Read guide
Data Classification and Security in Database Design
DataSys+·Database Deployment
Read guide
Infrastructure Location and Cloud Deployment Models for Databases
DataSys+·Database Deployment
Read guide
Normalization: Eliminating Data Duplication Through Normal Forms
DataSys+·Database Deployment
Read guide