SQL Server 2016 Core, Part 1 of 3: Getting Started

In this course, you’ll get an overview of what SQL Server is all about, and tour some of its more prominent features. We'll start by looking at the product itself, and its various editions, and talk about how Microsoft is constantly shifting features around the various editions. Then we'll explore some of the tools you get in the product, as well as the extensive documentation and sample applications available to help you learn SQL Server's many features. One of the main tools you're likely to use with SQL Server is Management Studio, a nearly all-encompassing set of tools that let you administer and develop code in just about every nook and cranny of the product. Then you'll see how you can work with data tables, views, and queries, where you really can start getting things done with SQL Server. You'll see how to create and edit tables and views, generate scripts, and view data from one or more tables. We'll wrap up with a short discussion about the Business Intelligence features, or BI, in SQL Server.