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 | OpenSkills.info
Course pathWalk it in order
Look it upDip in anytime
Go furtherLeaves this page
Intro
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.
Sources
- https://learn.microsoft.com/en-us/sql/sql-server/what-is-sql-server?view=sql-server-ver17
Supports
- SQL Server as an RDBMS and T-SQL communication
- deployment options
- related components
- https://learn.microsoft.com/en-us/sql/database-engine/sql-database-engine?view=sql-server-ver17
Supports
- Database Engine purpose
- ACID transactions and tradeoffs
- role responsibilities
- tools
- features
- platform distinctions
- https://learn.microsoft.com/en-us/sql/relational-databases/databases/databases?view=sql-server-ver17
Supports
- Database objects
- instances
- schemas
- logins
- database users
- and role-based permissions
- https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/back-up-and-restore-of-sql-server-databases?view=sql-server-ver17
Supports
- Backup and restore concepts
- recovery strategies
- security considerations
- https://learn.microsoft.com/en-us/sql/relational-databases/security/securing-sql-server?view=sql-server-ver17
Supports
- Security planning across platform
- authentication
- objects
- and applications
- https://learn.microsoft.com/en-us/sql/relational-databases/performance/monitor-and-tune-for-performance?view=sql-server-ver17
Supports
- Performance-monitoring study path
- https://github.com/mgramin/awesome-db-tools
Supports
- DBeaver and usql as curated ecosystem entries