openskills.info
Microsoft SQL Server logoCourse Preview

Microsoft SQL Server

Microsoft SQL Server is a relational database management system. Applications use it to store structured data, run transactions, and control access through a server instance and databases.

itDatabases and data storage

Microsoft SQL Server

Microsoft SQL Server is Microsoft's relational database management system. An application connects to a SQL Server instance or a database and sends Transact-SQL, usually called T-SQL. The Database Engine receives the request, checks access, and reads or changes data.

Think in layers. An instance is the running Database Engine. It can host several databases. A database groups tables, views, stored procedures, users, and other objects for one application or workload. A table stores rows in typed columns. Schemas group database objects and provide a namespace.

Continue the course

This section is part of the paid course.

See pricing to subscribe, or log in if you already have access.

Where this skill leads

Relevant careers

See how this topic contributes to broader role-level skill maps.