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

Name: Hands-On SQL Server,ManagementStudio,SQL Queries,AzureStudio
Rating: 3.9 (797 reviews)

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

Created byLalitha Audikesavan

Last updated 1/2022

English

English [Auto],

What you'll 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

Course content

8 sections • 42 lectures • 2h 2m total length

Trainer Introduction3:35
Who Should Learn SQL Server Course?2:20
Course Requirements2:00
Explore course prerequisites for hands-on SQL Server learning, including a PC with internet, downloading and installing Microsoft SQL Server, and learning to write SQL queries; beginner and intermediate learners welcome.
Course Structure3:10
Why Should you Learn this course?3:51
Course Agenda7:15

What is SQL Server ?1:19
This lecture introduces the concept of a school server, defines Escorial Server as a relational database management system, and explains how front end applications request data from the database.
History of SQL Server1:23
Explore the history of sql server, starting with v1.0, a 16-bit relational database released in 1989, and trace how version 6.0 first supported the nt operating system.
SQL Server Versions1:48
SQL Server Editions4:04
Explore SQL Server Enterprise edition for high end datacenter capabilities with fast performance and internal business intelligence, and compare Standard, Web, Developer, and Express editions for production, development, and learning.
Wrap-Up 12:16
SQL Server Installation2:08
Install sql server 2019 with a step-by-step, screenshot-guided setup, covering hardware and software requirements, express edition options, and hands-on practice creating databases, tables, and queries.
Hardware Requirements for SQL Server Installation3:10
Software Requirements for SQL Server Installation1:54
Detailed Step-by Step Procedure of How to Install SQL Server2:42
Hands-on Practical Lab Session on How to Install SQL server5:19
Wrap-Up 21:20

What is SQL Server Management Studio (SSMS)?1:17
SQL Server Management Studio components2:38
Explore SQL Server Management Studio components: object explorer for objects, template explorer for scripts, solution explorer for projects, visual design tools, and the query editor for writing and debugging.
When to Use SQL Server Management Studio ?2:41
Discover when to use SQL Server Management Studio for complex admin tasks, from configuring databases and security to designing diagrams, managing logins, and viewing query statistics.
How SQL Server Management Studio Looks like ?2:02
Explore how SQL Server Management Studio appears, navigate Object Explorer, view instances and databases, and prepare for hands-on practice creating databases, tables, and writing queries.
Wrap-Up 41:00
This wrap-up session outlines the definition and components of sql server management studio, its graphical user interface and wizards, and how it manages databases and server objects.
What is Azure Data Studio?1:38
How to Install Management Studio & Azure Data Studio ?2:07
Install SQL Server Management Studio and Azure Data Studio by downloading the setup executable from the Microsoft site and running the installer.
Hands-on Practical Lab Session How to Install ManagementStudio & AzureDataStudio2:55
Join a hands-on lab to download and install SQL Server Management Studio and Azure Data Studio from Microsoft, accept the license, and complete installation of tools and drivers (version 18.9.2).
Wrap Up 51:19
How to Create a Database?2:03
Learn to create a database in sql server management studio, then practice adding tables, stored procedures, and functions while respecting the instance limit of 32,767 databases.
How to Create a Table?2:25
Hands-on Practical Lab Sessions on How to Create Database & How to Create Table5:41

How to Write SQL Queries to Insert Data into a Table?1:41
Learn to write an insert into a table in SQL Server Management Studio, using the insert syntax and database name dot schema name dot table name, with values or expressions.
Hands-on Practical Lab Session How to write SQLQueries to Insert Data into Table5:47
How to Write SQL Queries to Fetch Data from a Table?2:59
Hands-on Practical Lab Session How to write SQL Queries to Fetch Data from Table6:19
Wrap Up 61:46
Practice creating a database and tables with SQL Server Management Studio, insert data using the insert command, and fetch results with select queries, reinforced by hands-on labs for beginners.

Requirements

PC or laptop with internet connection
Willingness to Learn Installation of SQL Server and learn how to write SQL Queries
Eagerness to learn how to connect and use SQL Server Management Studio & Azure Data Studio
Prior knowledge of SQL Server is not needed because this is detailed course with Hands-on practical sessions for beginner & intermediate levels

Description

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.

Who this course is for:

Beginners who are willing to learn SQL Server with Hands-on Practical Demo Sessions
Interested in learning how to Install SQL Server
Those wanted to learn how to use SQL Server Management Studio and Azure Data Studio
Those who want to learn how to store data in database and retrieve data from SQL Server
Those who wanted to start career in SQL Server as there is high demand for SQL SERVER DBAs(Database Administrators) & Developers.

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

What you'll learn

Explore related topics

Course content

Introduction6 lectures • 22min

Hands-On Practical SQL Server Installation with Detailed SQL Server11 lectures • 27min

SQL Server Management Tools & New Features & Components4 lectures • 17min

Hands-On Practical Database Creation, Management Studio & Azure Data Studio12 lectures • 28min

Hands-On Practical Lab on SQL Programming & How to Write SQL Queries5 lectures • 19min

Hands-On Practical Lab on How to Connect and Use Azure Data Studio4 lectures • 10min

Quiz - Test Your Understanding0

PRACTICE ASSIGNMENT ACTIVITIES0

Requirements

Description

Who this course is for: