T1 - Designs SQL Applications

Schema design with indexing strategies, data loading, stored procedures, triggers, and ORM concepts.

T1.1 - Designs a SQL Schema

Study Quiz

T1.2 - Designs Advanced Schemas

Study Quiz

T1.3 - Loads Data

Study Quiz

T1.4 - Writes Business Logic

Study Quiz

T1.5 - Develops Object/Relational Applications

Study Quiz

T1.6 - Deploys SQL Applications

Study Quiz

T2 - Uses SQL

Query processing, query plan interpretation, application integration, IRIS-specific features, and transactions.

T2.1 - Manages Query Processing

Study Quiz

T2.2 - Interprets Query Plans

Study Quiz

T2.3 - Uses SQL in Applications

Study Quiz

T2.4 - Uses IRIS-specific Capabilities

Study Quiz

T2.5 - Uses Transactions Effectively

Study Quiz

T3 - Manages Operations

SQL process monitoring, statistics management, security administration, and performance analysis tools.

T3.1 - Manages SQL Operations

Study Quiz

T3.2 - Manages SQL Security

Study Quiz

T3.3 - Uses PTools for Performance Analysis

Study Quiz

InterSystems IRIS SQL Specialist

Exam Topics