Logo

Collection of data items that are interconnected with each other which are organized according to a scheme or a particular structure, stored in the computer hardware and software to perform manipulation for certain uses which defines There is also a database is a collection of information stored in the computer in a systematic way so that can be checked using a computer program to obtain information from these databases Need reasons Database · Database is one important component in the system information, because it is fundamental in providing information. · Database determines the quality of information: accurate, timely and relevant. Information can be said is worth more effective if its benefits compared to cost to get it. · Database reduces duplication of data (data redudancy). • By applying database data relationships can be improved. · Database can reduce waste places outside savings. Database language Data base consisting of Language Data Definition Language (DDL), refers to a collection of commands that can be used to define the object - the object database, such as creating a database table or an index of primary or secondary. Data Manipulation Language (DML is), refers to a collection of commands that can be used to perform data manipulation, such as storing data into a table, then change it and delete it or just display it again. Objective Data Base More fully, the utilization of the database is to fulfill some purpose (objective) as follows a. Speed and convenience (Speed) b. The efficiency of storage space (Space) c. Accuracy (Accuracy) d. Availability (Avaibility) e. Completeness (Completeness) f. Security (Security) g. Togetherness usage (Sharability) SQL (Structured Query Language) SQL is the language used to communicate with the database. According to ANSI (American National Standards Institute), this is a standard language for relational database management systems (RDBMS) SQL statements used to perform several tasks such as update data in a database or displaying data from the database. Almost all SQL database software to implement the language as a major component of its product, one of MySQL. MySQL To make the administration of MySQL database, can use the module that is included is a command-line (commands: mysql and mysqladmin). Can also be downloaded from the MySQL site that is a module of the graphical (GUI): MySQL Administrator and MySQL Query Browser. In addition there is also a free software for administration of web-based MySQL database that is very popular phpMyAdmin. For software for MySQL database administration sold commercially, among others: the MySQL front, Navicat and EMS SQL Manager for MySQL MySQL Basic Commands SQL language has a structure that is easy to understand because the command - the command is basically made from English. So that we can do a command - SQL command into the MySQL database, ie a. Inserting or adding new records to the database. b. Execute database queries c. Taking data from database d. Changing records in the database e. Deleting records in the database SQL commands can be typed in capital letters or small (non case sensitive). When you finish typing the command in MySQL should end with a semicolon as a marker of the end of the MySQL command. SQL commands can be typed in capital letters or small (non case sensitive). When you finish typing the command in MySQL should end with a semicolon as a marker of the end of the MySQL command.