Data Jungler

In articles of creating database with schema, I have suggested to design the schema before establishing tables in the database. Frankly speaking, you may still be confused about the design of the schema. As a result, I am going to talk more about the logical design and tables structure in the relational database. Firstly, I do highlight the relational databases could be far away from that of NoSQL and non-relational databases so do not mix up each of them. In order to make this tutorial more readable, the list of terms are explained and list out below: Database: All tables and raw data stored and consolidated in Table (Entity): Arrange and store data in with table structure (e.g. Member Table, Product Table) Column (Attribute): the column of the table (e.g. member_id, member_name, gender in Member Table) Row (Record): the row of the table (e.g. 1, horace,  M) Some of you should have heard about "Normalization". Actually, the process of normalization is quite simila...

As mentioned in previous articles, MySQL is the programming language to manage and control the data in relational database. Nowadays, there is graphical query builder or popular web framework like Django so that you no longer need to code with SQL statement. Nonetheless, I still recommend to understand the principle of relational database and SQL especially who have less knowledge of database system design. There are several relational databases including MySQL, SQLite, PostgreSQL. In this tutorial, we will take an advantage of MySQL to administrate our own database. Imagine that you are the shop owner and start up a business, however,  resources are lacked to hire a technical to help you to construct the database structure. What could you do? Ask help? No, just do it by yourself~! Before building the operational database, we better to know the data flow in the process under this scenario. If you have never heard relational database model, you are recommended to understand more...

As the name suggests, database is the bases where the series of data used for modeling some organization and its process are collected and stored into. Actually, there are operational databases and analytical databases in database management. Operational databases This type of databases is designed for collecting, modifying and maintaining the data in routines. As a result,. the data is dynamic and kept to be latest information. The simplest example is that the inventory database that keep updating and show the latest figures of inventory. Analytical databases It is designed for storing, querying, analyzing the data. This static data in a certain period of time is allowed to analyzed for performance review, decision making and forecasting the trend. The data is supposed to be hardly modified. The transaction databases is used for marketing analysis in some firms. As we know, the databases are built in different variety of model that it is also called database model. Tow databa...

SQL, Structured Query Language, is the programming language to manage the data in relational database system (RDBMS). MySQL is also widely used in RDBMS and plays an significant role in LAMP, the software bundle which consists of four open-source software: Linux, Apache, MySQL, PHP. To beginners, SQL & MySQL is relatively monotonous and easier to grasp than other programming language. As a result, developers usually do not pay much attention to it unless some error occurs in the software.  Introduction Data Definition Language (DDL) A family of syntax for defining data structures, e.g. database schema CREATE: To make a new database, table, index or view ALTER: To modify the objects in database DROP: To remove an existing database, table, index, or view Data Manipulation Language (DML) A family of syntax elements to perform read-only queries of data SELECT: To query the record INSERT: To insert a new record UPDATE: To update the record DELETE: To remove the recor...