Hello ! Good Day !
Today iam going to talk about database and explain on how it will help you adept it . Before anything else , let us know what is a "Database". A database is an organized collection of structured information, or data, typically stored electronically in a computer system . Some examples are if you we're going to create a social media account like Facebook Account which contains videos , usernames , passwords , comments and a lot of information , you would use database .
I will also explain on how you can use SQL for creating and querying databse . First , we will going to install the app XAMPP . Here are the steps on how to install :
For windows users , it is more easier to install and you just have to follow the steps because XAMPP has an installer in their website for windows system . When you are in the Apache's website you just have to select the XAMPP for windows .
It will prompt you to confirm downloading the windows version of XAMPP and simply run the .exe file that is downloaded if it take you to another page . For using the application it is important to remember where XAMPP install . To allow the application to access any file , go to the location of the XAMPP when you finish installing and find the XAMPP control panel double click and select run as administrator .
For the second step , you need to set up your XAMPP file . The XAMPP file and the control panl can be found in the same place . If you are having this program administrator access , there's no icon confirming that the .exe has administrator but it depend on your preference. To be able to proceed to the last step , confirm the administrator access after selecting the control panel and there will be another panel that will open and select only the two relevant for operating a database labelled as Apache and MySQL .
The third step will be the step connecting to the PhpMyAdmin .
You can now create a database connecting to the local host if your server is officially running . In the address bar type local host after opening your preffered browser . After clicking the enter the XAMPP welcome page will be greeting you stating Congratulations you successfully installed XAMPP . I assure you that it would be easy to navigate , if you will look to the top right corner of the welscome page you can see a button called PhpMyAdmin and that will bring you to the PhpMyAdmin client . You will see a stack of names on the left side of your phpMyAdmin client and that would be your database . You will create your database if you if you will click the "New" button at the top of the stack .
A primary key is a field in the table that uniquely identifies the table records.
The primary key’s main features:
– It must contain a unique value for each row.
– It cannot contain NULL values.
For example, our table contains a record for each name in a phone book. The unique ID number would be a good choice for a primary key in the table, as there is always the chance for more than one person .The tables are limited to ONE primary key each and the primary key’s value must be different for each row.
If you are done with creating database , understanding SQL or Structured Query Language is more easier to do .