From the course: Learning Microsoft SQL Server 2019
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
What is SQL Server? - SQL Server Tutorial
From the course: Learning Microsoft SQL Server 2019
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 2019 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 access a gatekeeper through the management of users and access permissions. Because of its nature as a server, it's typically always running on the computer that it's installed on, listening for incoming requests and commands. When it receive communication, the server performs the required tasks and then serves data, or information, back to the user that requested it. In most production environments, SQL Server will be installed on a dedicated machine and users would log in remotely with their own computers to access the databases that they wanted to use. This is similar to accessing any other computer on your…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.