Learn about SQL Server Core 2016

0
Certificate

Paid

Language

Level

Intermediate

Access

Free

Last updated on October 10, 2024 2:34 pm

Learn about SQL Server Core 2016, data tools, installation, server configuration and how to use the SQL Server Management Studio (SSMS).

Add your review

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

  • State the applications of SQL Server…
  • Identify Database Objects…
  • Summarize SQL Server Data Tools…
  • List the steps involved in installin…
  • State the applications of SQL Server Management Studio
  • Identify Database Objects
  • Summarize SQL Server Data Tools
  • List the steps involved in installing the Management Studio
  • Discuss the Server Configuration Process
  • Explain Writing and Executing Queries
  • Paraphrase Debugging TSQL Code
  • 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

    ×

      Your Email (required)

      Report this page
      Learn about SQL Server Core 2016
      Learn about SQL Server Core 2016
      LiveTalent.org
      Logo
      Skip to content