Our Courses

Hands-On SQL Server,ManagementStudio,SQL Queries,AzureStudio

  • Category
    IT & Software
  • View
    16115
  • Review
    • 0
  • Created At
    1 month ago
Hands-On SQL Server,ManagementStudio,SQL Queries,AzureStudio

Detailed Course with Hands-On Practical Lab Sessions on SQL Server Installation,

Writing SQL Queries, Database Creation, Installation of SQL Server Management Studio & Azure Data Studio,

How to Connect and Use SQL Server Management Studio & Azure Data Studio.

Students will learn the following topics in this detailed hands-on course.

What is SQL Server ?

History of SQL Server

SQL Server Versions

SQL Server Editions

SQL Server Installation 

Hardware Requirements for SQL Server Installation

Software Requirements for SQL Server Installation

Detailed Step-by Step Procedure of Installation

Hands-on Practical Lab Session on How to Install SQL server

New Features of SQL Server

SQL Server Components

SQL Server Management Tools

What is SQL Server Management Studio (SSMS)?

SQL Server Management Studio components

When to Use SQL Server Management Studio ?

How SQL Server Management Studio Looks like ?

What is Azure Data Studio?

How to Install Management Studio & Azure Data Studio ?

Hands-on Practical Lab Session on How to Install Management Studio

Hands-on Practical Lab Session on How to Install Azure Data Studio

How to Create a Database?

How to Create a Table?

Hands-on Practical Lab Session on How to Create a  Database & How to Create a Table

How to Write SQL Queries to Insert Data into a Table?

Hands-on Practical Lab Session on How to write SQL Queries to Insert Data into a table

How to Write SQL Queries to Fetch Data from a Table?

Hands-on Practical Lab Session on How to write SQL Queries to Fetch Data from a table

When to Use Azure Data Studio?

How Azure Data Studio Looks like ?

Hands-on Practical Lab Session on How to Connect and Use Azure Data Studio