Microsoft SQL Server 2016 comes in a variety of editions in order to support a wide range of use cases and requirements. New for 2016 is the ability to download and use the Developer edition for free. This will make the full capabilities of Enterprise available for testing. The other free option is SQL Server Express, a lightweight edition that is licensed for use on small production databases.
- [Voiceover] SQL Server 2016 is the newest version…of the database platform from Microsoft.…You can find out more information about the capabilities…and features by visiting this website here.…If you scroll down, you can see…some of the newest features highlighted in this section,…and even download a free 200-page PDF ebook…that will outline some of the most significant changes…over prior versions.…Now the 2016 release of SQL Server…comes in a variety of editions…that are tailored to the needs and capabilities…required by the database administrator…and the systems that they intend to support.…
You can review the options available…by scrolling back up the top of the page,…and at the top left corner, clicking on the link…called Cloud Platform, then we'll come down to Products,…highlight SQL Server, and finally…click on SQL Server Editions.…This page outlines the differences between…the four available editions of SQL Server 2016,…Enterprise, Standard, and if we scroll down,…we'll see Express and Developer.…New for 2016 is the ability to download and use…
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