MySQL Crash-Couse
Tutorial 1- MySQL With Python And Data Science-
MySQL Installation Steps
Krish Naik
Krishnak has created a playlist on his Youtube channel to discuss about how you
can connect to various databases with the help of Python programming
language. The pattern will be something like this if you if you have seen my
mongodb Uh playlist so the pattern was that I'll try to show you how to do the
installation in your local machine. Then how do you connect to that with a
Python Db connector apart from that. I 'll say that we had used Pi. Installation
for the whole tool itself will probably take two minutes.. Installation will be the
most used databases right now and many companies use it. You know it is
amazing. because I will be getting more options now. Here you are getting an
option where it says that you can also log in using your oracle web account,
because I 'll just say no thanks. Just start my download. The most important
thing that we require is MySQL documentation sample and example connector
slash Python okay so these things we require but you can see the installation is
happening very quickly. I 'll also show you that how you can actually create your
own user and password with respect to this. Over here then you have my SqL
notifier. My sequel for visual studio 1. 2. 9..
THis will be the service that will be running in your services itself. You can also
change the name if you want this will be your windows service name that
basically means in order to run the MySQL in your local machine. The service will
be. running continuously in the back backend. in the cloud not in the server. So
here. I 'm also creating one additional user like Krish and apart from that. I will
also write one two two three four five.. THis is the my sequel workbench. The
main aim is basically to execute with the help of a Python code. THe library that
we 'll be requiring is something called as MySQL Connector Python, which will
try to install it in my next video in front of you. Then I 'll try to show you how
you can create a database, how you. can create tables. create your databases do
all the kind of operations do whatever you want. Please do subscribe the
channel if you 're not already subscribed. I 'll see you in the next video have a
great day thank you all bye bye. I'll see you again in a video please do subscribe
to the channel for a particular video. I'm not sure if you're going to be able to
watch the latest video from the channel..
Refer this link -
https://www.youtube.com/watch?v=us1XyayQ6fU&list=PLZoTAELRMXVNMRWlV
f0bDDSxNEn38u9Cl&ab_channel=KrishNaik
, MySQL Crash-Couse
Tutorial 2-Create and Drop Database and Table-
Complete MySQL Tutorial-
Krish Naik
Krishnak is a data analyst data scientist. Krishnak explains how to learn from
scratch from Scratch. He explains how the syllabus of mySQL is designed to
teach data scientists.. He says we 'll try to understand every day what all things
we are basically going to cover, but let's start without wasting any time.. WE are
going to learn about how to create databases how to insert into table and finally
how to drop table again. The syllabus is there the entire syllabus again. This is a
surprise for you. I 've created it in a wordpad in an amazing way so let's go
ahead without wasting any time and start working on database statements.
There is something like this kind of red points why it is basically coming is that
because see if I want to execute this. I can just select this and probably execute
by using this. statement. The result grid is the result grid where you will be able
to see the output. THe second one is that what is the console output that you
are basically getting Are you getting any kind of error? This has it been
successfully executed..
There are two ways of executing this press control enter and you 'll be able to
see over here now This has also got executed fine. You can see three tables over
here. That is called a city country and country language. Okay. Here is what we
have actually done now What I 'm going to do. This was the basic things that we
have done now. Use a create statement for creating the database itself. It is a
very very simple. It 's not very difficult as a query statement. So I 'm writing
create database my database name. like drop databases create table insert into
table and drop table so let 's go ahead and here you can see that it has been
successfully created. Using so I 'm going to write customer underscore info Okay
so this is my table name now Once I create a table. name just just imagine any
kind of data set inside you suppose if you have a CSV. file inside a. CSV file what
you 'll have will be your column name, So here I have to first of all specify
column name because inside that column name all the remaining thing will be
data. inside this what all data I can have is a unique id and this unique ids must
keep on incrementing..
In order to insert values all you have to basically do is that use another insert
statement which looks something like this So I 'm going to say insert into Oops
my mechanical keyboard customer underscore info okay so insert into customer
info. This is my table name and then I can use all my features name or all my
column names last underscore name.. The session will be going till 20 minutes
30 minutes. In the next video. You know I will try to try and find out if you're
feeling any problem with respect to the queries obviously go and Google it but
Tutorial 1- MySQL With Python And Data Science-
MySQL Installation Steps
Krish Naik
Krishnak has created a playlist on his Youtube channel to discuss about how you
can connect to various databases with the help of Python programming
language. The pattern will be something like this if you if you have seen my
mongodb Uh playlist so the pattern was that I'll try to show you how to do the
installation in your local machine. Then how do you connect to that with a
Python Db connector apart from that. I 'll say that we had used Pi. Installation
for the whole tool itself will probably take two minutes.. Installation will be the
most used databases right now and many companies use it. You know it is
amazing. because I will be getting more options now. Here you are getting an
option where it says that you can also log in using your oracle web account,
because I 'll just say no thanks. Just start my download. The most important
thing that we require is MySQL documentation sample and example connector
slash Python okay so these things we require but you can see the installation is
happening very quickly. I 'll also show you that how you can actually create your
own user and password with respect to this. Over here then you have my SqL
notifier. My sequel for visual studio 1. 2. 9..
THis will be the service that will be running in your services itself. You can also
change the name if you want this will be your windows service name that
basically means in order to run the MySQL in your local machine. The service will
be. running continuously in the back backend. in the cloud not in the server. So
here. I 'm also creating one additional user like Krish and apart from that. I will
also write one two two three four five.. THis is the my sequel workbench. The
main aim is basically to execute with the help of a Python code. THe library that
we 'll be requiring is something called as MySQL Connector Python, which will
try to install it in my next video in front of you. Then I 'll try to show you how
you can create a database, how you. can create tables. create your databases do
all the kind of operations do whatever you want. Please do subscribe the
channel if you 're not already subscribed. I 'll see you in the next video have a
great day thank you all bye bye. I'll see you again in a video please do subscribe
to the channel for a particular video. I'm not sure if you're going to be able to
watch the latest video from the channel..
Refer this link -
https://www.youtube.com/watch?v=us1XyayQ6fU&list=PLZoTAELRMXVNMRWlV
f0bDDSxNEn38u9Cl&ab_channel=KrishNaik
, MySQL Crash-Couse
Tutorial 2-Create and Drop Database and Table-
Complete MySQL Tutorial-
Krish Naik
Krishnak is a data analyst data scientist. Krishnak explains how to learn from
scratch from Scratch. He explains how the syllabus of mySQL is designed to
teach data scientists.. He says we 'll try to understand every day what all things
we are basically going to cover, but let's start without wasting any time.. WE are
going to learn about how to create databases how to insert into table and finally
how to drop table again. The syllabus is there the entire syllabus again. This is a
surprise for you. I 've created it in a wordpad in an amazing way so let's go
ahead without wasting any time and start working on database statements.
There is something like this kind of red points why it is basically coming is that
because see if I want to execute this. I can just select this and probably execute
by using this. statement. The result grid is the result grid where you will be able
to see the output. THe second one is that what is the console output that you
are basically getting Are you getting any kind of error? This has it been
successfully executed..
There are two ways of executing this press control enter and you 'll be able to
see over here now This has also got executed fine. You can see three tables over
here. That is called a city country and country language. Okay. Here is what we
have actually done now What I 'm going to do. This was the basic things that we
have done now. Use a create statement for creating the database itself. It is a
very very simple. It 's not very difficult as a query statement. So I 'm writing
create database my database name. like drop databases create table insert into
table and drop table so let 's go ahead and here you can see that it has been
successfully created. Using so I 'm going to write customer underscore info Okay
so this is my table name now Once I create a table. name just just imagine any
kind of data set inside you suppose if you have a CSV. file inside a. CSV file what
you 'll have will be your column name, So here I have to first of all specify
column name because inside that column name all the remaining thing will be
data. inside this what all data I can have is a unique id and this unique ids must
keep on incrementing..
In order to insert values all you have to basically do is that use another insert
statement which looks something like this So I 'm going to say insert into Oops
my mechanical keyboard customer underscore info okay so insert into customer
info. This is my table name and then I can use all my features name or all my
column names last underscore name.. The session will be going till 20 minutes
30 minutes. In the next video. You know I will try to try and find out if you're
feeling any problem with respect to the queries obviously go and Google it but
