00:00:00
hey what's going on everybody it's your
00:00:01
bro hope you're doing well and in this
00:00:03
video I'm going to show you how we can
00:00:04
start writing SQL using the MySQL
00:00:07
workbench so sit back relax and enjoy
00:00:10
the show
00:00:12
all right let's get started everybody
00:00:13
SQL it's an acronym meaning structured
00:00:17
query language SQL is used to create
00:00:20
retrieve update and delete data from a
00:00:23
database suppose we own a business like
00:00:25
the Krusty Krab from SpongeBob if we had
00:00:27
to manually track all of the
00:00:29
transactions by pen and paper well that
00:00:32
would be a lot of extra work if we had a
00:00:34
database we could keep track of these
00:00:36
records electronically and save
00:00:37
ourselves a lot of trouble right there's
00:00:39
two types of databases I'll discuss
00:00:41
relational and non-relational a table in
00:00:45
a relational database it resembles an
00:00:47
Excel spreadsheet there's rows and
00:00:49
columns tables within a relational
00:00:51
database can form well relationships
00:00:53
with one another and that is done by
00:00:55
this concept of keys which I'll explain
00:00:57
in a further topic then there's
00:00:59
non-relational databases that's where
00:01:02
our data is organized in any format but
00:01:05
a table this could include Json files
00:01:07
key value pairs graphed data structures
00:01:10
entities of that nature to utilize data
00:01:13
in a relational database we would use
00:01:15
SQL then with a non-relational database
00:01:18
we would use a different language named
00:01:21
nosql meaning not only SQL but since
00:01:25
this is an SQL series we will be working
00:01:27
with SQL and relational databases not
00:01:30
non-relational databases to write SQL
00:01:33
statements we would need the help of a
00:01:35
special piece of software known as a
00:01:37
database management system people
00:01:39
shorten this to Simply dbms it's a
00:01:43
workspace for us to write SQL statements
00:01:45
and generally just work with our
00:01:47
database it'll make our lives easier
00:01:49
there are different dbms systems you can
00:01:51
use one of which is MySQL Microsoft SQL
00:01:55
Server Oracle and postgres SQL but
00:01:58
there's still many more out there each
00:02:00
of these database Management Systems all
00:02:02
use SQL but there's subtle nuances
00:02:05
between these syntax of each database
00:02:07
management system if you're familiar
00:02:09
with one database management system
00:02:10
transitioning to another will take
00:02:12
little to no effort at all in this
00:02:14
series we will be working with the mySQL
00:02:17
database management system and I'll show
00:02:19
you how to download that for both
00:02:20
Windows and Mac OS
00:02:23
hey everybody in this topic I'm going to
00:02:25
explain how we can download MySQL using
00:02:27
the Windows operating system first of
00:02:30
all head to this website mysql.com then
00:02:33
go to the downloads tab
00:02:36
scroll down look for MySQL Community
00:02:38
downloads we'll click on that
00:02:43
click on MySQL installer for Windows
00:02:48
make sure that we have our Windows
00:02:50
operating system selected
00:02:53
then download the first installer
00:02:58
no thanks just start my download
00:03:03
we will open this download once it's
00:03:05
complete
00:03:09
there are various setup types depending
00:03:11
on what packages you need for this
00:03:14
series all we need is the server and the
00:03:16
workbench we'll select the custom radio
00:03:19
button
00:03:20
click next
00:03:22
we will need the most recent MySQL
00:03:25
server
00:03:28
add that to products to be installed
00:03:32
open applications go to mySQL workbench
00:03:36
we will add the most recent workbench
00:03:40
we can close out of that there is a
00:03:42
shell if you're interested in using that
00:03:44
but I will be sticking with the
00:03:45
workbench in this series once we have
00:03:47
our server and our workbench I will
00:03:49
click next
00:03:51
then execute
00:03:54
looks like there's an error downloading
00:03:56
the workbench I'm going to try again
00:03:58
and it worked this time for some reason
00:04:00
let's click next
00:04:03
execute
00:04:04
give it some time once the installation
00:04:07
status for the server and the workbench
00:04:09
is complete we can click on next
00:04:12
next
00:04:14
I'll keep these default configurations
00:04:18
next
00:04:20
use strong password encryption for
00:04:22
authentication let's click next
00:04:26
here we're going to set the root
00:04:27
password to access the server think of
00:04:30
some password you would like I'm just
00:04:32
going to set mine to be password I'll
00:04:34
keep it simple
00:04:38
yeah of course the password strength is
00:04:40
weak you can add user accounts but
00:04:42
that'll be outside the scope of this
00:04:44
series
00:04:45
click next
00:04:47
you can start the MySQL server at system
00:04:49
startup if you would like I'll keep that
00:04:52
on
00:04:52
click next
00:04:55
then execute
00:04:57
then finish
00:04:59
then next
00:05:02
yeah we might as well start the MySQL
00:05:04
workbench after setup
00:05:07
if this window doesn't pop up you can
00:05:09
easily just search for it just look for
00:05:11
MySQL workbench
00:05:14
now we should have a local instance
00:05:16
we can click on this to access our
00:05:19
server let's pretend that this wasn't
00:05:20
here I'm going to right click delete
00:05:22
connection
00:05:25
if you need to set up a connection hit
00:05:26
this plus button
00:05:28
we'll need a connection name I'll name
00:05:30
this Local Host connection method should
00:05:34
be standard TCP IP
00:05:37
the host name is
00:05:39
127.0.0.1 at Port 3306
00:05:44
then press ok
00:05:47
so now that we have our connection set
00:05:49
up we can click on it type in the
00:05:51
password you set for the server mine was
00:05:53
simply password
00:05:56
you could save the password if you want
00:05:58
I might as well
00:06:00
then okay
00:06:02
and here we are within the MySQL
00:06:04
workbench
00:06:06
all right everybody in this topic I'm
00:06:08
going to explain how we can download
00:06:09
MySQL using the Mac operating system
00:06:13
first head to this URL mysql.com
00:06:17
we will go to the downloads tab
00:06:22
scroll down look for MySQL Community
00:06:25
downloads
00:06:27
we'll need both the server and the
00:06:29
workbench but let's start with the
00:06:30
server click on this file
00:06:34
Mac OS 12 DMG archive click the download
00:06:38
button
00:06:40
click on this link no thanks just start
00:06:42
my download
00:06:48
when this DMG archive is finished
00:06:50
downloading we can double click on it
00:06:53
just give it a second
00:07:00
double click on the DMG archive
00:07:04
allow
00:07:07
click continue
00:07:11
you can read the license agreement I'm
00:07:13
going to pretend I did hit continue
00:07:16
install
00:07:19
type in your computer's password if this
00:07:21
prompt comes up
00:07:29
use strong password encryption hit next
00:07:33
then we'll need a password for our
00:07:34
server type in whatever password you
00:07:37
would like to keep it simple for this
00:07:39
lesson I'm just going to set my password
00:07:40
to be well password
00:07:45
by checking this box MySQL server will
00:07:48
start once the installation is complete
00:07:50
you might as well keep this checked but
00:07:52
for demonstration purposes I'm going to
00:07:54
show you how to start the server
00:07:55
manually
00:08:01
then close
00:08:04
I'll go ahead and move the installer to
00:08:06
the trash bin
00:08:07
we have the server downloaded next we
00:08:09
need to download the workbench
00:08:12
again head to mysql.com
00:08:15
go to downloads
00:08:18
scroll down to mySQL Community downloads
00:08:23
click on MySQL workbench
00:08:27
then hit the blue download button
00:08:32
no thanks just start my download
00:08:39
then we can double click on this DMG
00:08:41
archive when it's finished downloading
00:08:45
so double click
00:08:48
drag and drop the workbench icon into
00:08:51
your applications folder
00:08:54
before we access the workbench let's be
00:08:57
sure that the MySQL server is running
00:09:00
click on the top left Apple logo
00:09:03
go to system preferences at the bottom
00:09:06
left corner look for MySQL
00:09:09
click on it
00:09:11
then start MySQL server if it's not
00:09:14
started already and you can check this
00:09:16
checkbox so that your computer starts up
00:09:18
with it running
00:09:20
all right you may need to type in your
00:09:22
password
00:09:25
the server is now running
00:09:29
to run the workbench we can go to finder
00:09:33
then applications
00:09:35
look for the MySQL workbench icon
00:09:40
double click on it
00:09:43
and here we are within the MySQL
00:09:45
workbench
00:09:46
to access the server you can click on
00:09:49
this local instance connection then type
00:09:51
in the password that you originally set
00:09:53
for the server
00:09:54
but if you're missing this connection
00:09:56
you can hit the plus button
00:09:58
then create a new connection name I'll
00:10:00
name this Local Host
00:10:03
use standard tcpip for the connection
00:10:05
method
00:10:06
hostname should be
00:10:09
127.0.0.1 and Port 3306 then press ok
00:10:13
but I already have my connection set up
00:10:16
click on your connection type in the
00:10:18
password you set for the server
00:10:22
then press OK and here we are within
00:10:25
MySQL workbench
