database documentation

Tables
Fields
type, size, defaults, nullable
Primary keys
Indexes
Foreign key
Views
Stored procedures
Functions
Extended properties

Click here to know more about database documentation.

database administration

A database administrator (DBA) is responsible for the environmental aspects of databases. The role of a database administrator is to design database. So DBA also can called a database analyst or database designer.

A DBA perform following duties:

• Installation of new software
• Configuration of hardware and software with the system administrator
• Security administration
• Data analysis
• Database design
• Data modeling and optimization
  
• Understanding and implementation of database schemas
• Ability to interpret and write complex Structured Query Language (SQL) queries
• Monitor systems for optimum Performance and capacity constraints
• Establish standards and best practices for SQL
• Interact with and coach developers in SQL scripting

customer database

There can be several types of business information, such as:

* Contact details
* Customer preferences
* Sales history
* Payments
* and many more

Common fields for customer database can be
# first name # last name
# birth year # company
# type of company # position
# address # city
# state # zip
# phone # fax
# e-mail address # shipping address

Click here to know more about to create customer database.

backup database in phpmyadmin Step 4

Just copy the query and past in to text file and save as *.sql file extension.

Click here to know more about backup database.

backup database in phpmyadmin Step 3

Click Export from the top menu, select export type from the left and finally click Go.

Final Step.

backup database in phpmyadmin Step 2

Then Select your database from Database Menu at the left.

Step 3.

backup database in phpmyadmin Step 1

At first write http://localhost/phpmyadmin/.

Step 2.

backup database

You should backup your database at regular intervals and before an upgrade. Here I show step by step process to take backup your database using PHPMyAdmin for SQL database in XAMP.

Click here to know more about it.

create database

CREATE DATABASE: creates new database
ALTER DATABASE: changes database
CREATE TABLE: creates new table
ALTER TABLE: changes table
DROP DATABASE: deletes database
DROP TABLE: deletes table
SELECT: select data from database
UPDATE: updates data in database
DELETE: deletes data from database
INSERT INTO: inserts new data into database

Click here to know more about sql syntax.