Read and learn
These topic is all about DATABASE!
Creating sites like, youTube which contains a lot of information like username, password, videos and comments. These needs Database.
But, before that let’s discuss first what is DATABASE?
A database is a collection of data that is organized in a manner that facilitates ease of access, as well as efficient management and updating it also made up of tables that store relevant information.
STEPS for creating DATABASE using SQL:
STEP1 : You should download learn how to download XAMPP from Apache and use it to start creating and querying about databases.
For MAC USERS :
*Go to your preferred browser and go to APACHE’S WEBSITE.
*Download and scroll to the MAC section. DO NOT CLICK DOWNLOAD. (if you will, you will mistake!).
- Click MORE DOWNLOADS under the mac section. (This will bring you to source forge).
- Then you can now see a list of file folders, click folder labeled:
-XAMPP Mac OS X
-The current version (7.3.4)
-Xampp-osx-7.3.4-0-installer.dmg - Your download will begin. Save and run the dmg file.
For WINDOWS USERS :
*The same process as the first step in the MAC user. This will take you to another page where it will immediately prompt you to confirm downloading the Windows version of XAMPP.
*Run the .exe file that is downloaded and follow the steps you are prompted with. Be sure to remember where XAMPP Installs to, this is important for using the application.
*Finish installing XAMPP go to the location it has been installed to and find the XAMPP control panel (Titled xampp-control.exe). This file will be located near the bottom of the XAMPP install folder. Right click on this file and select the properties tab. Move to the compatibility tab and check of Run as administrator. This will allow the application to access any file it may need to for full functionality. Once you have done that, the application should be fully functional.
STEP 2 : Setting Up the DATABASE
FOR MAC USERS :
*Find your XAMMP files.
*Once you finish run the download you will have a XAMPP folder in your Mac Applications.
*Click that folder and you will see a application called manager-osx, the logo is a gear in a bubble, open it.
(You will be promoted to enter your Mac’s password, don’t worry it just needs to run the server).
*Once XAMPP screen will pop up, click the middle button titled Manage Servers. At the bottom click Start All, wait for the lights next to the servers to turn green, you are ready for the next step.
For WINDOWS USERS:
*Find your XAMPP files.
*All XAMPP files will be located in the same place as your control panel. If you have given this program administrator access (As suggested in the last step) you shouldn’t be prompted for any further input beyond maybe confirming that this .exe has administrator access depending on how your preferences are set.
*Starting XAMPP.
*Select control panel, (if necessary confirm control administrator access.) it will open a panel with several options.
*The only relevant ones for operating a database are the top two.
- Apache
- MySQL.
*Start those two and you’re ready to proceed to the final step (They should be lit up green as in the image).
Step 3: Connecting to PhpMyAdmin
For MAC and WINDOWS :
*Once you already done running servers, you can start create your DATABASE.
*Connecting to localhost? It is super easy!!!
-open your preferred browser
-type “localhost” in the address bar. Note: (You do not want to type localhost into the google search bar. If you do, you will not allow access to phpMyAdmin). After hitting enter, you are now greeted with the XAMPP welcome page. Congratulations, you successfully installed XAMPP!
*phpMyAdmin
*In the top right corner of the welcome page you will see a button called phpMyAdmin, click it. (This brings you to the phpMyAdmin client). While phpMyAdmin can look overwhelming, it assure you it is easy to navigate.
*One the left side of your phpMyAdmin client, you will see a stack of names, these are your databases.
*Click the “New” button at the top of the stack, this is where you will create your database.
Step 4: Creating Your Database
*Name your table and select the number of columns you want to have. Example, if you enter customer with 3 columns.
*After chosen the table name and number of columns click Go on the right side of your screen.
Initializing Columns for the Table
*Enter the names of your columns, select the type for each, and the max length you want to allow. Click save in the bottom right corner, and your done.
*You have successfully created a database with a table and column that is ready for data to be inserted.
CONGRATULATIONS 🎊