The groundwork

Read up on a domain and shore up the fundamentals before you sit a practice exam on it.

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