From the course: SQL Server 2014 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Understanding the core concepts of SQL Server 2014 - SQL Server Tutorial
From the course: SQL Server 2014 Essential Training
Understanding the core concepts of SQL Server 2014
- The first thing I'd like to talk about is just simply the question, "What is Microsoft SQL Server 2014?" And a lot of people would say, "It is a database," and that is partially correct. It might be more correct to say it is a relational database management system, sometimes abbreviated RDBMS. Microsoft SQL Server can retrieve and manipulate data just like any database can, but it is also a management system, so it does more than just retrieve and manipulate data. It has the capability to secure our data and, in fact, for any one to access data in Microsoft SQL Server, they will need a login with a username and password. So that's part of what the management system does. It doesn't just give access to everyone. It provides authentication and authorization to who can see our data. The management system also processes data, so it can back up and restore data. It also processes data through compiled, stored procedures, which are highly efficient. And the management system gives us…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
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.