Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Feb 15, 2011
Level: Beginner Presenter: Eli the Computer Guy Length of Class: 30 Minutes Tracks
Web Design Prerequisites
Introduction to Website Administration Purpose of Class
This class teaches new website administrators to be able to understand MySQL Databases for general administration. This class does not delve deep into database architecture and theory, it just teaches what is needed successfully manage a site that uses MySQL to store and retrieve data. Topics Covered
What is a MySQL Database How to Navigate through a MySQL Database using PHPMyAdmin How to export, backup a database How to extract data from a MySQL Database Class Notes
Introduction Databases are used to store data. MySQL databases are most commonly used for websites because MySQL is open source and free. Storing Data MySQL Server software manages databases A Database is generally the largest unit for storing data Tables contain information about specific types of data (vendors, employees, parts list) Columns in Tables store specific information (Frist Name, Last Name, ID Number) Rows store Records in a Table (All of an Employees Record, or All Information about a Part Employee Number Last Name First Name Email Address Phone Number 1 Evans Tom firstname.lastname@example.org 444-444-4444 2 Thompson Fred email@example.com 555-555-5555- Connecting to the Database Database software allows for Users and Permissions like an Operating System does. If the Database Server is on the SAME server as the Web Server then you connect to the database using LOCALHOST, if not you use the address of the Database Server Working with MySQL You can backup the entire database and restore it by exporting to the SQL format. You can export TABLES into Excel spreadsheets to easily extract data such as site members email addresses.