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

Detailed Course with Hands-On Practical Lab Sessions-SQL Server,Writing SQL Queries,Management Studio& Azure Data Studio

3.67 (659 reviews)

Udemy

platform

English

language

Other

What you will learn

Detailed Step-by Step Procedure of SQL Server Installation

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

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

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

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

Practical Assignment Activities are included for students to practice lab activities

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

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

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

Hands-on Practical Lab Session on How to Connect and Use SQL Server Management Studio

New Features of SQL Server

Why take this course?

1) 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.

2) Practical Course includes practical assignment activities for students to practice lab activities.

3) 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
Practical assignment activities for students to practice lab activities.

Screenshots

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

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

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

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

Reviews

Olivia

October 3, 2023

This course was very helpful. I enjoyed the lectures especially the practical sessions. it detailed and explained well

Julian

October 2, 2023

Podría ser mejor porque el curso es sólo teórico. Lo de Azure me hubiera encantado trabajarlo con las bases de datos creadas en el curso. Pero faltó mucha profundidad. Lo quería hacer porque vale la pena. Y obvio, lo terminé completo.

Viraj

August 17, 2023

- Instructor keeps spamming my email every day to complete her courses and enroll in new ones; I have reported this practice as abuse to Udemy. - Lot of background noise in the recordings - No downloadable resources like slide decks, summary, source code links - Low quality content in slide decks

Javier

August 11, 2023

No tiene suficientes ejemplos, para la parte visual del cliente de sql server no viene la forma de crear la primer conexión ni como configurar dicha parte.

Gade

January 31, 2023

I had learnt about the SQl server, versions,editions and what are the hardware requirements and software requirements for SQL installation and connection and database creation and many things about tools and features of SQL server

Naveed

January 9, 2023

PROS: Many theoretical concepts are covered using presentation slides. Instructor has explained how to install SSMS and Azure studio. CONS: The title says that it is a hands on course but only 2 lab sessions added. Quality of the content does not matches up to the expectations.

Darshak

January 3, 2023

Contents were too naive for familiar person. Besides, presentation slides were too simple rather dull, could be better. I was expecting much more from this course than what I gained.

Suraj

November 6, 2022

The course was awesome. I learn it from the basics. But I think the audio quality is a little bit irritating between the Instructor's voice. But overall the course was great for beginners. Must recommend.

Andres

September 24, 2022

It's a good course to learn the basic about SQL, would be better if have more videos with practice exercises

Aamad

August 13, 2022

good way of delivering basic knowledge of Azure and SQL Server. I have understood all basics of SQL and Azure.

Fahim

August 3, 2022

Too much focused on theoretical topics and reading. Would have been more effective if more practical usage were shown.

Mile

June 24, 2022

I would give you five stars if there were no annoying background sounds and if there was not a small error in fetching data from the database with LIKE operator, wrong SQL statment was executed.

Nkonmon-Possible

May 19, 2022

Thank you, Lalitha. A concise introductory course into SQL Server. The presentation could be improved upon and the lecture environment could be better. The background noises from passing vehicles and people were at times distracting.

David

March 17, 2022

Todo curso enseña cosas nuevas como es el caso de este curso, buen aprendisaje en mi caso. Comento seria muy interesnate que fura mas practico. Gracias por el curso

Aswinkumar

February 13, 2022

This is a very good course mam. Very clear explanations. For begineers, is a good platform to start their learning in sql server and sql management.

Charts

Price

Rating

Enrollment distribution

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