Today we are going to discuss about the database. Of course I have already discussed that I'm going to use the my SQL database if you install the database my SQL database make sure it's a free database you can download the database from the official website of the my SQL. So my SQL either an open source relational database management system its name is a combination of my something like this. Okay, you can also download the my SQL database from official website as you can see the new MySQL 8.0 the curve I am recording this lecture the version of the my SQL database is a point zero. So you know, my SQL document is cold and also Okay, so now how can download click on the download If you are downloading the my SQL so as you can see the semis database, so custom now and we have a lot of options here.
So you can download from here or and you have some other options. I am a web developer. That's why I have some I'm working on PHP, so that's why I need to install the server where I run the my script. So I always use the Sam. Sam is a server so they can see them. If you install them.
It's automatically it will give you three options. Apache Maria DB plus PHP plus pearl. So it will give you the my SQL database course and also the PHP so hit the download button. Download. So I strongly depend upon you which version you are going to. If you are working on PHP seven point x or server two or three, you need to download these versions.
And if you are working on six my version, you can also download older versions, more downloads here and make sure I am the Windows user. That's why I download this version. If you are a Linux user, you can download this if you're a Mac user, you can download these versions. So they depend upon you. If you are using other databases like Oracle like SQL lite, like SQL Server DB two and also Microsoft Access. Yes, you can also download them, but I'm going to use the my SQL database.
So download the XAMPP from the official website of the exam, as you can see this exam, it's officially friends for our official website. Although this is the official website of the exam, you can download this I have already downloaded the set. Okay, once you download the same what you need Wait a second. Okay, once you download the Zen, so what you need just need to open the system. You can see it's giving the Apache High School files Compare some other options. What you just need to start the my SQL if you are working on the PHP you have to start this Apache because Apache the server, if you want to run the PHP script, okay, for now we are working on the database.
So that's why we just need to start this my SQL because my school is a database we have already discussed about and how can you access this just write locals and write PHP. php, my admin, it will give you the second Okay, I have to start the Apache also. Okay, so now we're second so we can easily start so now it's giving you the databases. So these are the databases are I have already created. So what I'm going to create so this is the interface if you are working on Oracle SQL lite or SQL Server, they also have some interfaces where you can run your queries like this or suppose if you want to do is you can right here select a static from users. So in this way you can, right because this is the interface where you can run your charities you can give your command.
Okay, so now I am going to create a database. So because I have three, I have connected with my server. So this is a server. Okay, now hit the database and go to create a database so you can create your database from here for suppose students, okay, or users, or something like this. I'm going to create a database student Oh, school. School is a database name, you can choose your collection here, by default, lesson, Swedish.
Click on that database. As you can see you have successfully created your databases. This is one option. If you have installed the Sam, you can access PHP my admin. So, because PHP myadmin give you some interface or commands to manage your database, but if you have a data grid so you can see the data great, I have to manage my databases. Okay, so I need to discuss about this tool, so don't worry about it.
Now Google Trends, yet trends intermittent As you can see JetBrains developer tools for professionals and teams. So click on this. So, as you can see, this is the JetBrains this competition website of the JetBrains you can download the data great here. So, you can see JetBrains is a platform or they are providing the best IDs and the tools for the programmers and the developers or the teams. So, take a hover on the tools. So you can see this is a data grid click on this.
So as you can see, they are saying many databases want to store data grid is for the database. They are saying Intelligent Query console application schema navigations a lot of candidates they are giving with this tool. Okay, the major database management systems, they are supporting your downloading and installing this tool. We are running on the Maya skill that's why they are also supported. If you're working on Oracle asier, he will do SQL lite h2 and also hyper SQL tree house and other databases. You can also download this tool.
You can also work on the issue my admin was right. I'm not satisfied and I'm not using this one I I am using the decorations for five years so that's why I prefer that you can download this tool from JetBrains his official website of the characters and make sure they are given 30 days to file if you are not receiving this, they also give you a free trial you can also get 30 days free trial. If you are a teacher and you are a student they also give you the one year realizes that is education license I was students with so I have the free license. Okay, so this is the tool, the download button write some information and Subscribe Now Subscribe so they will give you the link or you can download it in this data grid 2018 you can download this tool and install this tool I have I have already downloaded and I have already installed this tool so click on this tool I have already downloaded that's why I have this icon so this is that electorate thousand 17 version.
Okay, I have downloaded installed Okay, so now as you can see, so how can you connect with your databases now I'm seeing that now, as you can see, they're saying manage data sources Control Enter ship as press these buttons are why data source as you will see Right, if I'm saying this, just click on this button, click on the My SQL because we have my SQL if you are running Oracle, just click on Oracle, I'm using the my SQL. Okay, so now click on this plus button my SQL username is root because I have installed the SAM inside my in my local machine. So if you are not specifying database, you don't need to specify this password or with empty destination. It's things to successfully apply Okay, so now appears I'm saying so databases. So semicolon Ctrl Shift execute, you either can see it's showing us the databases I have the upgrade of the school so that's why it's being showing you this because in this way this works.
I will define the idea of the school in my lectures but for now this is a tool to manage work. is so encouraging