How is data retrieved and manipulated?

Data is retrieved by executing queries on a database using a query language like SQL. The retrieved data can then be manipulated using various programming languages or tools to perform operations like sorting, filtering, aggregating, and transforming the data based on requirements. This manipulation is done to analyze the data, extract insights, and present it in a meaningful way.