A Study Of MySQL

Introduction When we are going to start developing a new project, a big question mark pops into our minds as to which technology to use. Something that should be taken into consideration is your budget. Choosing fee-free, quality and supportive tools is of great importance. By choosing MySQL as your Database Management System (DBMS) option, in addition to being a free tool created on the basis of an open source license, you are also opting for quality, robustness and security. These are adjectives that a manager must have, as keeping your data or your customers' data securely is the most important. Over the MySQL Code House In addition to the tools, you should also be concerned with planning the project you are developing. Modeling and building a system's database is at the heart of it. The database will impact the entire process: from the beginning of the project creation, the performance of the system during its development and until its maintenance and expansion later on. Therefore, I emphasize again the importance of good modeling and a good manager. That's what I'm going to do throughout this book: introduce project modeling, best practices, all of this in a very practical way, so that, in the end, you'll be able to create a relational database for any application or business systems you want to develop. About MySQL When you type 'MySQL' into Google, the first result shows that it is the most popular open source database in the world. I need to say more? The biggest technology companies' use and many of them contribute to the project. Instead of writing something theoretical or historical to explain what MySQL is and list its strengths, I chose to create a mind map to list its advantages clearly and visually. Database Although database is a technical term, most people these days have direct contact with it. In fact, a large part of the population currently has access to equipment, whose function (primary or secondary) is the storage of information. Who doesn't use a cell phone these days? Since its inception, this type of device has a calendar, in which we can record names and telephone numbers so that, at a second moment, we can access them. A printed telephone directory is also a valid example of this, as it contains all the names, addresses and telephone numbers of companies and residents in your city and, eventually, in the surroundings. All of this refers to the concept of database, that is, a place where it is possible to store information for consultation or use, when necessary. Bank of Dice Code House The bank itself will manage the structure of the records and will be in charge of creating space for new records, altering its content according to the requests of the application that is accessing it. These databases that manage records in an automated way, besides being just a dataset, they are called Relational Database Management Systems (RDBMS), or Relational Database Management Systems (RDMS). There are several reasons for the database model. Relational data is the most used among other existing models. One of them is the ease of altering the structure of tables, such as adding and deleting columns and rows as needed, without compromising their functionality. Introduction to Relational Database Regardless of the application you want to use for storing and manipulating information, all databases are made up of basic elements: fields, columns, rows or tuples and tables. Fields are for entering a given piece of data; columns are records for a particular field; tuples are the rows of records from a set of fields; and tables are the sets of rows, fields, and columns.