CQL Basics — Furkan Sönmez

furkan.sonmez.me

Sign in

© 2026 Furkan Sönmez

Terms Privacy Cookies Refunds

CQL Basics — Furkan Sönmez

← Course details

Welcome

Welcome to the SAP CAP CourseFree

1. Getting Started

What is SAP CAP & Why It ExistsFree
Development Environment SetupFree
Your First CAP ProjectFree

2. Domain Modeling

CDS Modeling Fundamentals
Associations & Compositions
Aspects, Reuse & Common Patterns
Initial Data & Database Setup

3. Services & Custom Logic

Defining Services & Projections
ApplicationService & the Handler Chain
The req Object & Handler Patterns
Implementing Business Logic
Defining Actions & Functions
Implementing Actions in TypeScript
CQL Basics
Writing Data & Fixing the N+1
Defining & Emitting Events
Event Subscribers & Transactions

4. Fiori Elements UI & Localization

Fiori Elements Fundamentals
Core UI Annotations
Value Helps & Status Indicators
Facets & Sub-Entity Annotations
Draft Handling
Extending Fiori Elements
Test Data & the Sessions Object Page
Flexible Column Layout
i18n: UI Labels & Enum Values
i18n: Server Messages & Adding a Language

5. Security, Authorization & the Approuter

Authentication & Authorization Concepts
Row-Level Security with where Clauses
Programmatic Authorization & Testing
XSUAA on BTP
The Application Router

6. SAP HANA Cloud

From SQLite to HANA Cloud
HANA-Specific Features

7. BTP Connectivity & External Services

The BTP Destination Service
Cloud Connector & Connectivity Service
Consuming External Services
Linking Local & Remote Data
Caching & Resilience

8. Messaging & Eventing

CAP Messaging & Event Mesh Concepts
Event Mesh: Production Configuration
Cross-App Messaging on Real Event Mesh
Personal Data & GDPR
Change Tracking

9. Media & Enterprise Features

Media & Attachments
Attachments Plugin & Cloud Storage
Temporal Data
Soft Deletes

10. Testing & Debugging

Test Setup & First Tests
Testing Mutations & Authorization
RegistrationService Tests & Patterns
REST Client & .http Files
Debugging & cds repl

11. Deployment to BTP

Understanding the MTA
Building the Deployment Artifact
Deploying to Cloud Foundry
SAP Build Work Zone Integration
Migrating to IAS + AMS
Cloud Logging & Monitoring in Production
CI/CD Basics
Course Recap & Architecture Review

Appendix

Appendix 1 — CDS Annotations Cheat Sheet
Appendix 2 — Good & Bad Practices

Lessons

This lesson is locked

It's part of the paid SAP CAP course. Get full access to unlock all 61 lessons plus bonuses.

View course details Already enrolled? Sign in