SQL Server Tutorial For Beginners | SQL Server Management Studio Install & Tips 2022

Summary

In this instructional YouTube video, Teddy guides viewers through the process of installing SQL Server 2019 and SQL Server Management Studio (SSMS). He emphasizes the use of the Express edition for most users and provides practical tips for navigating SSMS efficiently. Teddy also offers a basic overview of SQL Server, explaining it as a database typically run on servers but also installable on desktops. He simplifies the concept of databases as interconnected Excel spreadsheets, highlighting the importance of tables and keys. The tutorial concludes with a demonstration of creating a test database and table, and executing a basic SQL query, all aimed at empowering beginners to grasp SQL fundamentals.

Takeaways

• 😀 The video is a tutorial on installing SQL Server 2019 and SQL Server Management Studio (SSMS).
• 🔍 The presenter advises downloading SQL Server 2019 from the official Microsoft downloads page, opting for the Express edition which is suitable for most production environments.
• 💻 The presenter suggests choosing the 'basic' version of SQL Server for simplicity and to avoid unnecessary installations.
• 📚 SQL Server is described as a database typically run on a server, but it can also be installed on a desktop computer.
• 🛠️ SSMS is introduced as a graphical tool that simplifies server communication, reducing the need for command-line operations.
• 🔑 The presenter emphasizes that SSMS allows for both GUI operations and command-line style SQL input within a graphical interface.
• ⏬ The installation of SSMS is shown to be straightforward, with the software handling much of the setup automatically.
• 🌐 The video highlights that while the local server instance runs on the user's computer, in a professional setting, servers are often remote.
• 🔑 The presenter explains the use of Windows Authentication for connecting to the local SQL Server instance, eliminating the need for a password.
• 📈 The video provides a practical demonstration of creating a new database and table within SSMS, illustrating the process step-by-step.
• 📝 An analogy is used to explain databases and tables as Excel spreadsheets that can be interconnected, simplifying the concept for beginners.

Q & A

What is the main topic of the YouTube video by Teddy?

The main topic of the video is teaching viewers how to install SQL Server 2019 and SQL Server Management Studio (SSMS), along with providing quick tips for getting started and using SSMS effectively.

Why does Teddy recommend downloading the Express version of SQL Server?

Teddy recommends the Express version of SQL Server because it is typically what users will be using in a production environment, and it is suitable for developers or analysts unless specified otherwise by an employer.

What does Teddy suggest as the best starting point for SQL Server Management Studio?

Teddy suggests that the best starting point for SSMS is the 'Databases' tab, as most of the work will be concentrated there.

How does Teddy describe SQL Server in relation to a regular computer?

Teddy describes SQL Server as a database that can be run on a server, which isn't much different from a regular computer. The main difference is that servers are meant to be communicated with over networks, but as every computer is now connected to a network, the difference is negligible.

Why is SQL Server Management Studio (SSMS) considered a valuable tool according to Teddy?

SSMS is considered valuable because it provides a graphical user interface for interacting with servers, which simplifies tasks that would otherwise require typing out commands in a command-line interface.

What is the significance of the 'Databases' tab in SSMS according to the video?

The 'Databases' tab in SSMS is significant because it is where users will spend most of their time working with databases and tables, which are the core components of SQL Server.

What is the analogy Teddy uses to explain databases?

Teddy uses the analogy of Excel spreadsheets that can be tied together through keys to explain what databases are.

What is the command Teddy uses daily at work within SSMS?

The command Teddy uses daily at work within SSMS is 'SELECT TOP 1000 ROWS', which he finds very useful for quickly viewing data within a table.

What advice does Teddy give regarding the execution of SQL queries in SSMS?

Teddy advises to always be aware of the database on which SQL queries are being executed to avoid accidentally executing against the master or model databases.

What is Teddy's tip for remembering what a database is?

Teddy's tip for remembering what a database is, is to think of it as a bucket that holds tables, which are like Excel spreadsheets.

Outlines

00:00

💻 Installing SQL Server 2019 and SSMS

The speaker, Teddy, introduces the video's purpose: to guide viewers through the installation of SQL Server 2019 and SQL Server Management Studio (SSMS). He explains the process of downloading SQL Server, suggesting the Express version for most users, and emphasizes the Basic version as sufficient for most needs. Teddy provides tips to help viewers quickly become proficient with SSMS, focusing on the most commonly used features to avoid confusion. He also discusses the difference between a server and a regular computer, explaining that SQL Server is typically run on a server but can also be installed on a desktop for learning purposes. The speaker concludes by highlighting the benefits of SSMS over command-line interfaces for database management.

05:01

🔧 Setting Up SQL Server Management Studio

Teddy continues by discussing the setup process for SQL Server Management Studio (SSMS), noting its ease of use compared to other database systems like PostgreSQL. He explains that SSMS acts as a graphical interface to connect with the SQL Server running in the background on the computer. The speaker clarifies misconceptions about the location of servers in a professional setting, emphasizing that they are often remote and not located on the user's computer. Teddy then demonstrates how to launch SSMS and connect to the local server using Windows authentication, bypassing the need for a password. He guides viewers through creating a test database and navigating the SSMS interface, highlighting the 'Databases' tab as the primary area of focus for most tasks.

10:02

📚 Understanding Databases and Tables in SQL

In the final paragraph, Teddy provides a conceptual understanding of databases and tables in SQL. He uses the analogy of an Excel spreadsheet to explain databases, suggesting that a database is like a collection of interconnected spreadsheets. The speaker emphasizes the importance of tables within a database and demonstrates how to create a new table in SSMS. Teddy also explains the three main parts of SSMS: the graphical layout of databases and tables, the SQL query writing area, and the results display. He advises viewers to avoid executing SQL commands on system databases like 'master' or 'model' unless they are database administrators, and assures viewers that the knowledge shared is sufficient for most SQL professional needs, including developers and analysts.

Keywords

💡SQL Server

SQL Server is a relational database management system developed by Microsoft. It's used for storing, managing, and retrieving data in a structured format. In the video, the presenter discusses how to install SQL Server 2019, emphasizing its use in production environments and its importance for developers and analysts.

💡SQL Server Management Studio (SSMS)

SSMS is a graphical management tool for managing and administering SQL Server databases. It provides a user-friendly interface for executing SQL queries, managing databases, and automating administrative tasks. The video focuses on installing SSMS and how it simplifies database management compared to command-line interfaces.

💡Installation

Installation refers to the process of setting up a software application on a computer system. The video script includes detailed steps for downloading and installing SQL Server 2019 and SSMS, highlighting the ease of installation and the importance of choosing the right version for one's needs.

💡Express Version

The Express version of SQL Server is a free, lightweight edition designed for learning and development. It's mentioned in the script as the recommended version for beginners and small-scale production environments, contrasting with the Developer version which is also available.

💡Database

A database is an organized collection of structured data. The video uses the analogy of Excel spreadsheets to explain databases, emphasizing how they can hold multiple tables and be interconnected through keys. The script also demonstrates creating a new database within SSMS.

💡Tables

Tables are the primary component of a relational database, used to store data in a structured format. The video script describes how tables within a database are analogous to Excel spreadsheets, with columns and rows representing data fields and records, respectively.

💡Windows Authentication

Windows Authentication is a security method that allows users to log in to SQL Server using their Windows account credentials. The video script explains that this method eliminates the need for a separate password, streamlining the login process for local databases.

💡Server

In the context of the video, a server refers to a computer system that provides resources or services to other computers over a network. The script clarifies the difference between a regular computer and a server, noting that servers are designed for network communication and can host software like SQL Server.

💡Query

A query is a request for data from a database, typically expressed in SQL (Structured Query Language). The video script demonstrates how to use SSMS to write and execute queries, such as 'SELECT TOP 1000 ROWS', to retrieve data from a table.

💡Graphical User Interface (GUI)

A GUI is a user interface that allows users to interact with a system through graphical icons and visual indicators, as opposed to text-based interfaces. The video highlights SSMS as a GUI tool that simplifies database management by providing a visual interface for executing SQL commands.

💡Development Environment

The development environment refers to the tools, software, and settings used by developers to create applications. The video script guides viewers through setting up a development environment for SQL Server, including installing necessary software and understanding its components.

Highlights

Introduction to the video and the tutorial on installing SQL Server 2019 and SQL Server Management Studio (SSMS).

Downloading SQL Server 2019 from the official Microsoft website and choosing the Express edition for most users.

Recommendation to use the Basic version of SQL Server for simplicity and lack of unnecessary installations.

Explanation of what SQL Server is and its typical use on servers, despite being installable on desktops.

Introduction to SQL Server Management Studio (SSMS) as a GUI for interacting with SQL Server databases.

Advantages of SSMS over command line for database management, including ease of use and graphical tools.

Installation process of SQL Server 2019 and the subsequent steps to install SSMS.

The automatic setup by SSMS and its ease of use compared to other database systems like PostgreSQL.

Understanding the difference between a local and a remote server in the context of SQL Server.

Launching SSMS and connecting to the local SQL Server instance using Windows Authentication.

Navigating the SSMS interface and focusing on the 'Databases' tab for most database-related tasks.

Creating a new database within SSMS and the importance of refreshing to view new objects.

Analogy of databases to Excel spreadsheets that can be interconnected through keys.

Demonstration of creating a table within a database and the need to refresh to see new tables.

Using the 'Select Top 1000 Rows' command as a common daily task in SSMS.

Highlighting the three important parts of SSMS: database and table layout, SQL query writing, and results display.

Advice on executing SQL scripts and the importance of not executing on system databases like 'master' or 'model'.

Conclusion of the tutorial and a call to action for viewers to subscribe for more content.

Transcripts

what's up guys this is teddy welcome to

my youtube channel this video i'm gonna

be teaching you guys how to install sql

server 2019 and how to install sql

server management studio so after i get

done with both of those downloads and

show you how to install it i'm also

going to be giving you quick tips so

that you can kind of just get up and

running and be able to actually use sql

server management studio without getting

so confused and show you a lot of the

tips and tricks that i use on a daily

basis so that you're not burning

yourself out wasting your time learning

a bunch of features that you don't even

really need all the things you know at

the end of the at the end of this video

are going to be like i said 90 of what

you're going to be using as a uh

developer or any type of analyst too so

first first thing

what i did is i just typed in sql server

download 2019 it's fairly easy to find

there's this up here i don't know why

their people are putting ads on top of a

sql server download but

go to sql server downloads and then go

to express

many people i've seen use the developer

version but the express version is

probably what you're going to be using

in a production environment and if

you're a developer or some type of

analyst

you probably just want to use the

express version unless your employer or

somebody else tells you to use or has a

different version for you to use so next

thing is you want to go to basic

you could sift through here and maybe

try and find some like a custom version

that you want but um i found that the

basic version works just fine and

it's there's very rarely are they ever

going to install any type of junk onto

your computer so i would say just go for

the basic version

so while this is installing i kind of

just like to go through and give just a

basic overview of like what is sql

server well sql server is a database and

it's called sql server because most of

the time sql server is going to be run

on an actual server

so a a server really isn't that much

different from a regular computer and

you can actually install server software

on your desktop there's no the only real

difference between a regular server and

a desktop computer is very negligible

and it really has to do with the fact

that servers are meant to be

communicated with over networks and as

uh time has progressed every computer is

connected to a network so there's not

really like i said there's not much

difference but they call it sql server

for that reasons for that reason

what is

sql server management studio and why are

we also learning sql server management

studio with a server course well

back in the day

you had to communicate with servers

through command line uh kind of like

matrix hacker looking letters and these

days we have very powerful guise that

will or guis or just graphical software

that we can use to communicate with

servers that can do a lot of the tedious

work

of typing out these commands and they

can do them in

graphical user interfaces that make it

just a lot more pleasing and more

human-like as opposed to the command

line now if you want to you could go and

become a command line master but

the great thing about sql server

management studio is it's very versatile

and you can even do a lot of the command

line type uh

you know you could type in sql straight

into in almost like a command line

fashion but you're doing it in a gui and

you can save scripts and you can click

and it can give you

very powerful graphical tools to also go

through all of your data as well so even

though we have the capabilities with

just using a gui sql server management

studio is going to make our lives a lot

easier and speaking of the devil we've

just installed sql server 2019 and

don't copy down any of this right here

just going to install smss

or ssms i'm sorry and go down to here to

download ssms and

go ahead and download uh smss is

actually like three gigs in size so it's

it's a huge it's a monster of a program

and

it could take us here

take us

just a little bit give us five seconds

three seconds just to run out the clock

and download this thing so

here we go gonna go ahead and click it

open

and if you don't see this it's i've got

dual screens just click yes it's gonna

ask it's going to ask for permission to

download the app then i'm going to bring

this over here

and we're going to go ahead and install

it

now the great thing about sql server

management studio 2 and when you in

install all these things is that it's

going to do a lot of the setting up for

you so

if you've ever installed other databases

like postgres postgres can give you

uh a lot of trouble with how the

graphical or the gui and how the actual

server connect to each other

the sm many times people get confused

about how they interface the smss

actually is uh not really connected with

the server the server is running on the

back of your computer in the background

of your computer and

uh these graphical tools like sm or a

sql server management studio are meant

to connect to

server centers in distant remote places

or places that you don't actually live

for testing purposes our physical server

is going to live within our desktop

computer but just realize that once you

get a job the server that you're going

to work on is probably not even going to

be in your building or it's not

definitely not going to be in your

computer

and that's also a kind of another thing

and another important point too is that

um this is like a lab but when you

actually start working just realize or

ask your boss you know where is the

server because that's actually something

that i did when i first started my job i

thought the server was going to be like

i had to put the server on my computer

but that really wasn't the case

and

kind of made me look stupid but whatever

we live when we learn so go in here

and type in sql sql server management

studio and we're just going to go ahead

and boot that up

and it should be we can just go ahead

let's try and con just click connect now

you don't have to do that but i'm going

to make sure that the

server instance is actually running

and we're gonna go ahead and exit out of

that

so

we

when you are connecting to a foreign

server you're actually gonna have a

password but we're not gonna have a

password because we have this thing

called windows authentication so many

times people are like well what password

do i put in you're not going to need one

when it the local database is actually

installed on your computer

so we're just going to go in here

and we are congratulations guys you have

installed sql server management studio

but i'm not going to stop there like i

said i'm going to give you

a really good

uh

place to start and i'm going to tell you

where like 99 of your time is going to

be concentrated so you're not you know

out here you know searching through

files and doing all these crazy things

99

of what you're going to be doing is

going to be

under this tab right here

so if you ever just get lost just be

like okay i'm just going to go back to

the databases tab and

go back just go back here so

next thing is let's just go ahead and

create just like a quick little test

database so i can show you guys what a

database actually even looks like so go

in here

click new database and just

click testdb

don't even mess with any of that stuff

down there and don't mess with the owner

because you don't need to worry about

that just type just type in testdb

hold on

um you could actually create testdb what

happened there was i actually have

installed like i had to uninstall sql

server so it's it's showing that there's

another instance there but you could

type in test

or you could just type in bb test like

this

and we're just kind of doing this for

example sake two so you could just type

in db test

and then

that's going to actually create a db

test for you so

within

this within the 90

90 is going to be spent like within here

or whichever database that you're going

to be working on so when you guys start

working you're going to go in here and

you're going to see probably 20

databases right now there's only one

database because it's just a local

computer but when you start working

you're going to have like 20 databases

in here

and when you fold this down

you're going to have these things called

tables so within the database test

you're going to have

tables

i'm going to

this

explanation of what a database is blew

my mind so i used to run with a data

scientist

or i had a i had a really big if you

know me i was a really big runner and i

used to run with a data scientist and

one day he said something to me really

profound

he said that databases are excel

spreadsheets that can be tied together

through keys and

if any if you don't even remember any

bit of this course remember that because

that is going to help you a lot when

you're trying to visualize you know what

exactly is a database a database is

really just an excel spreadsheet on

steroids it's an ex a database can hold

uh

like hundreds of tables and it's meant

for all of these tables to be logically

be able to be connected together and

manipulated through sql queries so if

you ever just get freaked out be like oh

i just can't understand like what a

database is or what these table things

are just remember that

tables are excel spreadsheets

and these tables are stored within

buckets of these databases if this thing

kind of looks like a bucket i think it

looks like a bucket and that's how i

remember it tables are our databases are

just buckets of tables and

that's going to be the important part so

let's go ahead let's right click on the

tables and let's just create a table

really quick and i'll even go kind of

just show you this excel spreadsheet

analogy and why i think it's you know

such a good analogy

so we'll go test

you can name it whatever you want to you

can just call it

i don't know dog

and we're going to call it table tip and

then we're going to call this one table

test

and

you will notice that nothing actually

happens you'll say well we created our

table

why isn't showing up because you have to

hit this you have to refresh it you have

to hit this little button right here

so

go here

and you will see it's created our actual

table so within

our database we have tables and within

our tables

you can see if you right click it and

you go to select top 1000 rows this i do

this i use this command every single day

literally every single day at work i'm

using this command

so make sure to take take note of this

command select top 1000 rows

and

we've got our table so just like an

excel spreadsheet if you looked at an

excel spreadsheet you would have

um i don't know you'd have like a name

then you'd have a price like if we had

an excel spreadsheet of products you'd

have a name then you would have a price

then you would have

uh like maybe like the location of the

product or which warehouse it was in and

then you would have just columns of data

and it looks just exactly like an excel

spreadsheet and up here this is another

important part this is the query that's

actually being run so

this is all of our

in three

really important parts just to get like

conceptually of like where to look in

sql server management studio we have

three important parts this is where all

of our databases and our table tables

are going to be graphically laid out

this is where we're going to be actually

writing our uh sql queries

and then this down here is where all of

our results from our sql queries are

going to be displayed you see when i

right click that and i went select top

1000 rows it showed

uh it created that sql for us and then

displayed it down at the bottom and

in a nutshell that's

to get started in sql server management

studio that's probably all you're going

to need now other things that you're

going to want to know is that this is

how you execute the sql

you can go up here to save your scripts

like if you have a script that you're

using all the time you can save them in

particular folders

and you always need to be cognizant and

aware that

don't

execute

sql on master model or

msdb temp db always make sure that

you're executing sql on

the actual data database that you plan

to otherwise you could accidentally

execute against the master you could

execute against the model

and

don't even worry about any of this stuff

down here because you're never until you

become like a db if you become a dba

admin you might use this stuff down here

but

for people who

are trying to get developer

analyst jobs or just become some type of

sql professional unless you're like a

serious dba

and you if you're trying to become a dba

there's courses on that will teach you

how to do that but for just being able

to get you know up and running with sql

that's all you're gonna need and not uh

all you're going to need but that's

going to be enough so that you could

actually be able to google stuff and

figure out stuff intuitively on your own

which is kind of like the whole reason

of this course that i'm going to uh take

you guys on

anyway that's gonna be my video for

today i hope that you guys enjoyed this

i hope that it was very helpful provided

a lot of value for you if you did make

sure to stick around for the rest of my

videos make sure to drop a sub join my

discord if you guys uh enjoyed it just

or above all just hit that subscribe

button anyway hope that you guys have a

good one see you later