From the course: Learning SQL Server 2017

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

What is SQL Server?

What is SQL Server? - SQL Server Tutorial

From the course: Learning SQL Server 2017

Start my 1-month free trial

What is SQL Server?

“

- [Instructor] Before we get into working with SQL Server, it's probably a good idea to talk about what SQL Server actually is. SQL Server 2017 is a Relational Database Management System or RDBMS. It uses a database engine to handle all of the tasks associated with storing and retrieving data from a database, creating new databases and their components such as tables, and acts as a gatekeeper through the management of users and their access permissions. Because of its nature as a server, it's typically always running on a computer that it's installed on, ready to respond to incoming requests, to perform the required tasks, and then serve the information back out to the user that requested it. In most production environments, SQL Server would be installed on a dedicated machine and users would log in remotely from their own computers to access the databases that they wanted to use. However, SQL Server can also be installed on a local computer. This approach simplifies the connections…

Contents