master services inc

Info 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 ton@gmail.com 444-444-4444 2 Thompson Fred fred@aol.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.