Want to save your progress?
Create a free account to track your lessons and quizzes across devices.
Register Login
« Back to ClassCompleted: 0%

The Enterprise Standard - Microsoft SQL Server

Page 1 of 1


Microsoft SQL Server (MSSQL)

SQL Server is Microsoft's enterprise relational database. While it now runs on Linux, it is most deeply integrated with the Windows ecosystem.

Transact-SQL (T-SQL)

While all these databases use SQL, Microsoft uses a proprietary extension to standard SQL called T-SQL. It adds powerful features like procedural programming, local variables, and exception handling (TRY...CATCH) directly into the query language.

SSMS (SQL Server Management Studio)

One of the biggest draws of MSSQL is the tooling. SSMS is a comprehensive GUI tool that allows DBAs to configure instances, manage backups, visually design queries, and view live performance metrics without typing a single command. For a DBA, learning SSMS is as important as learning SQL.