SQL has three main components: the Data Manipulation Language
What are some of the components of SQL Server?
- SQL Server Database Engine. The core service for storing and processing data. …
- Analysis Services (SSAS) …
- Reporting Services (SSRS) …
- Integration Services (SSIS) …
- Integration Services (SSIS) …
- SQL Server Management Studio. …
- SQL Server Configuration Manager. …
- SQL Server Profiler.
What are the components of a database engine?
The database engine has two major components: the storage engine and the query processor. The storage engine writes data to and retrieves data from stable media (e.g., disks). The query processor accepts, parses, and executes SQL commands.
