database encryption

The sensitivity of the data determine the need of encryption. Few things to consider to implementing encryption:

• Will the data stored in the database need to be encrypted
  
• or just the user passwords
• Will you need to encrypt the data only in the local instance of the database
  
• or do you need to also encrypt the data in transit

Click here to more about database encryption.

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.

access database

Access database is a relational database management system from Microsoft It is a member of the Microsoft Office suite of applications.

Click Here to know more about access database from it's home page.