Learn about SQL Server Core 2016

SQL Server Core 2016 is a free online course that offers a guide to installing and exploring the SQL Server Core. SQL is a critical programming language that has a host of applications when it comes to managing and handling data, especially structured data, and this course covers everything from the SQL Server Management Studio’s Features, Data Tools and how to make use of them in SQL to how to configure the server using the Management Studio.

What You Will Learn In This Free Course

Getting Started

This module describes the SQL Server Core 2016. It discusses an overview of the SQL server and two of its most prominent features. Then you will learn about using the SQl Server Management Studio which is most used tool when working with SQL Server and how you can use it for general development work.

SSMS and Data Tools

This module describes the SSMS and Data Tools. It discusses variety of database objects that the SQL Server supports and what they can do for you. Then you will learn about the SSMS Features and Help in SQL as well as how to connect to other server instances.

Installation

This module describes the step by step process of installing the SQL Server Core 2016. The setup program guides you through all the necessary steps to installing the features that you need as well as the decisions to make which can seem overwhelming particularly if you are new to sql server. It also discusses how to make an upgrade and customize your installation to fit your need

Server Configuration

This module describes the Server Configuration aspect of SQL Server Core. It discusses the SQL Server configuration manager which is the main configuration tool as well as the use of management studio to configure the server and databases. It also discusses the database settings and how it allows you to set properties for both new and existing databases

Using Management Studio

This module describes the SQL Server Management Studio which is an integrated development environment for writing SQL code as well as its top level menu options. It also discusses how to Configure SSMS Windows and customize it your own liking. The module also talks about the Object Explorer and to the rich functionalities buried in the right click pop up menu in pretty much every corner of the tool

Writing and Executing Queries

This module describes Writing and Executing Queries in SQL Server Core. It also discusses how the Query editor makes it super easy and efficient to write codes. It also talk about how the tool generates reusable scripts and SQL’s ability to help you debug transact SQL Code. You will also learn how the execution engine decides whether the query is going to execute more efficiently by using or not using any of the indexes

Course assessment