SQL Server Tutorial For Beginners | SQL Server Management Studio Install & Tips 2022
Summary
TLDRIn 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
💻 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.
🔧 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.
📚 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.
Mindmap
Keywords
💡SQL Server
💡SQL Server Management Studio (SSMS)
💡Installation
💡Express Version
💡Database
💡Tables
💡Windows Authentication
💡Server
💡Query
💡Graphical User Interface (GUI)
💡Development Environment
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
Ver Más Videos Relacionados
Part 2 A : Editions, installation and Connectivity to SSMS
Dream Report: Acquiring Data from SQL Server
Power BI Project For Beginners | Sales Insights Data Analysis Project - 3 - Data Analysis Using SQL
Asp.net sql server database connection tutorial
Complete CRUD Operation in Asp.Net C# With SQL Server Step by Step
Dream Report: Acquiring Data using SQL Statements
5.0 / 5 (0 votes)