- 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 tools…to automate several tasks so we can create tasks…

Resume Transcript Auto-Scroll

Author

Released

6/12/2015

Learn everything you need to know to start building databases with SQL Server. Martin Guidry reviews the major features of SQL Server 2014 and shows developers how to architect efficient, high-performance solutions for organizations of any scale. Watch and learn how to install and configure SQL Server, create databases and tables, automate common tasks like backups, and use the SQL query language to retrieve and manipulate data.