Problem solving in mysql education: Introducing sql programming for beginners of history, the excess until sql communities in Indonesia with mysql

introducing sql programming for beginners of history, the excess until sql communities in Indonesia with MySql | Problem Solving in Mysql Education

Before introducing mysql, the first time i will explain SQL (Structured Query Language)

What do you know about SQL?

According to wikipedia

SQL is a language...

that is used to access data in a relational database. That described herein relational database management system (RDBMS) or for stream processing in a relational data stream management (system RDSMS).

Next to MySQL

MySQL is an implementation of relational database management system (RDBMS) that is distributed for free under the GPL (General Public License).

“MySQL is a derivative of one of the main concepts of SQL”.

History of mySQL

MySQL was created by a Swedish company, MySQL AB, founded by David Axmark, Allan Larsson and Michael “Monty” Widenius. The first version of mySQL appeared on 23 May 1995.

Quoted from mysql.com

“MySQL is named after co-founder Monty Widenius's daughter, My.

The name of the MySQL Dolphin (our logo) is “Sakila,” which was chosen from a huge list of names suggested by users in our “Name the Dolphin” contest. The winning name was submitted by Ambrose Twebaze, an Open Source software developer from Swaziland, Africa. According to Ambrose, the feminine name Sakila has its roots in SiSwati, the local language of Swaziland. Sakila is also the name of a town in Arusha, Tanzania, near Ambrose's country of origin, Uganda.”

Excellence MySQL

Multi-threaded – can be installed on a server that has a multi – CPU.
Working on a variety of platforms.
Powered common programming languages such as C, C++, Java, Perl, PHP, Python, TCL, APLS DLS.
Working on a variety of platforms.
Have many types of column – facilitate system configuration database.
Have a good security system to verify the host.
ODBC support for OS Microsoft Windows.
Support record has a fixed length column.
Integrated with PHP.

MySQL community in Indonesia :

MySQL is one of the primary database used in Indonesia, especially among PHP developers. This is due to native integration between PHP and MySQL as well as the number of hosting which includes both products for license-free and has proved resilient and efficient.

Indonesia MySQL community website that is separate from the PHP community you can visit in click here

Some Product MySQL :

1. MySQL Enterprise Edition

2. MySQL Standard Edition

3. MySQL Classic Edition

4. MySQL Cluster CGE

5. MySQL Embedded (OEM/ISV)

6. MySQL Community Edition

MySQL provides a freely downloadable version (Open Source). Available under the GPL license and is supported by a large and active community of open source developers.

The MySQL Community Edition includes:

Pluggable Storage Engine Architecture

Multiple Storage Engines:

InnoDB, MyISAM, NDB (MySQL Cluster), Memory, Merge, Archive, CSV

and more..

MySQL Replication to improve application performance and scalability

MySQL Partitioning to improve performance and management of large database applications

Stored Procedures to improve developer productivity

Triggers to enforce complex business rules at the database level

Views to ensure sensitive information is not compromised

Performance Schema for user/application level monitoring of resource consumption

Information Schema to provide easy access to metadata