What is SQL Server? In this video, database expert Adam Wilbert introduces Microsoft SQL Server 2016, a relational database management system or RDBMS. Managing SQL Server requires tasks performed by a system administrator and database administrators, and uses the Transact-SQL language to interact with the data it houses.
- [Voiceover] Before we get into working with SQL Server,…it's probably a good idea to talk about what SQL Server…actually is.…SQL Server 2016 is a relational database management system…or RDBMS.…It us a database engine to handle all the tasks associated…with storing and retrieving data from a database.…Creating new databases and accessing their components…such as tables,…and it acts as 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,…ready to respond to incoming requests,…to perform the required tasks,…and then to serve that information back out to the user…that requested it.…
SQL Server can hold many databases under its umbrella…at a time.…To keep the entire system running smoothly,…there will typically be at least one user called…the system administrator that oversees the configuration…and management of the server itself, its hardware,…and the user accounts that are allowed access…into the system.…
This course introduces the most important features of SQL Server 2016, and is designed to act as the student's very first look at how the server operates. Adam Wilbert shows how to install a local copy of SQL Server; demonstrates the working environment, SQL Server Management Studio; and walks students through their first hour creating tables, defining relationships, and writing and running queries with Transact-SQL commands. Everything you need to accomplish to create your first database is covered in just 80 minutes. Start watching to get up and running with this professional-grade database management system.
- What is SQL Server?
- Configuring the server
- Creating a new database and data tables
- Joining tables with keys
- Creating a SELECT statement
- Writing an UPDATE statement
- Adding data with the INSERT statement