How does MySQL Works?

                              How MySQL Works?

MySQL follows the working of Client-Server Architecture. This model is designed for the end-users called clients to access the resources from a central computer known as a server using network services.

Here, the clients make requests through a graphical user interface (GUI), and the server will give the desired output as soon as the instructions are matched. The process of MySQL environment is the same as the client-server model.

The core of the MySQL database is the MySQL Server. This server is available as a separate program and responsible for handling all the database instructions, statements, or commands. The working of MySQL database with MySQL Server are as follows:

1. MySQL creates a database that allows you to build many tables to store and manipulate data and defining the relationship between each table.
2. Clients make requests through the GUI screen or command prompt by using specific SQL expressions on MySQL.
3. Finally, the server application will respond with the requested expressions and produce the desired result on the client-side.

A client can use any MySQL GUI. But, it is making sure that your GUI should be lighter and user-friendly to make your data management activities faster and easier. Some of the most widely used MySQL GUIs are MySQL Workbench, SequelPro, DBVisualizer, and the Navicat DB Admin Tool. Some GUIs are commercial, while some are free with limited functionality, and some are only compatible with MacOS. Thus, you can choose the GUI according to your needs.

What is MySQL?

     What is MySQL?

MySQL is currently the most popular database management system software used for managing the relational database. It is open-source database software, which is supported by Oracle Company. It is fast, scalable, and easy to use database management system in comparison with Microsoft SQL Server and Oracle Database. It is commonly used in conjunction with PHP scripts for creating powerful and dynamic server-side or web-based enterprise applications.

It is developed, marketed, and supported by MySQL AB, a Swedish company, and written in C programming language and C++ programming language. The official pronunciation of MySQL is not the My Sequel; it is My Ess Que Ell. However, you can pronounce it in your way. Many small and big companies use MySQL. MySQL supports many Operating Systems like Window, Linux, MacOS, etc. with C, C++, and Java languages.

MySQL is a Relational Database Management System(RDBMS) software that provides many things, which are as follows:

• It allows us to implement database operations on tables, rows, columns, and indexes.
• It defines the database relationship in the form of tables (collection of rows and columns), also known as relations.
• It provides the Referential Integrity between rows or columns of various tables.
• It allows us to updates the table indexes automatically.
• It uses many SQL queries and combines useful information from multiple tables for the end-users.

RDBMS

In the above example, we have 3 tables and they are Students, Takes_Course and Courses.

Three tables are connected together using same column and this is relational database.

RDBMS Terminology

Before we proceed to explain the MySQL database system, let us revise a few definitions related to the database.

• Database − A database is a collection of tables, with related data.
• Table − A table is a matrix with data. A table in a database looks like a simple spreadsheet.
• Column − One column (data element) contains data of one and the same kind, for example the column postcode.
• Row − A row (= tuple, entry or record) is a group of related data, for example the data of one subscription.
• Redundancy − Storing data twice, redundantly to make the system faster.
• Primary Key − A primary key is unique. A key value can not occur twice in one table. With a key, you can only find one row.
• Foreign Key − A foreign key is the linking pin between two tables.
• Compound Key − A compound key (composite key) is a key that consists of multiple columns, because one column is not sufficiently unique.
• Index − An index in a database resembles an index at the back of a book.
• Referential Integrity − Referential Integrity makes sure that a foreign key value always points to an existing row.

What is database?

                     What is Database?

Today, we will be learning about what is meant by database?

The things that we have in our house can also represent the database. For example iron rack that we have in our house consists of rows and columns and that is used to store our clothes,utensils…etc.

In the same way, database also consists of rows and columns which can be accessed easily.

A database is an application that stores the organized collection of records. It can be accessed and manage by the user very easily. It allows us to organize data into tables, rows, columns, and indexes to find the relevant information very quickly.

Each database contains distinct API for performing database operations such as creating, managing, accessing, and searching the data it stores. Today, many databases available like MySQL, Sybase, Oracle, MongoDB, PostgreSQL, SQL Server, etc. In this section, we are going to focus on MySQL mainly.

So, in the further stories let us go into topics deeply and gain more knowledge.

Introduction to MySQL

                           Introduction to MySQL

Structured Query Language(MySQL) for beginners

From today, let us start our new topic i.e MySQL. In this blog we will just learn about What is MySQL. It is just going to be short and sweet blog.

MySQL tutorial provides basic and advanced concepts of MySQL. Our MySQL tutorial is designed for beginners and professionals.

MySQL is a relational database management system based on the Structured Query Language, which is the popular language for accessing and managing the records in the database.

MySQL is open-source and free software under the GNU license. It is supported by Oracle Company.

Our MySQL tutorial includes all topics of MySQL database that provides for how to manage database and to manipulate data with the help of various SQL queries.

These queries are: insert records, update records, delete records, select records, create tables, drop tables, etc. There are also given MySQL interview questions to help you better understand the MySQL database.

#SQL(DAY5) How does a person can interact with the database by using SQL?

 How does a person can interact with the database by using SQL?

As, we know if two people want to convey their feelings they use their native language for communicating and if we think a little bit how can a human interact with machine or databse? this can be solved by using commands.

Yes, as discussed above there are few commands that can help us to interact with database.

The SQL commands help in creating and managing the database. There are different types of commands:

We use above sql commands to communicate with the database and in the later stories let us discuss about each every command types seperately.

#SQL(DAY4)Do you know the process of SQL?

 Do you know the process of SQL?

When we are executing the command of SQL on any Relational database management system, then the system automatically finds the best routine to carry out our request, and the SQL engine determines how to interpret that particular command.

Structured Query Language contains the following four components in its process:

1) Query Dispatcher

The function of the dispatcher is to route the query request to either CQE or SQE, depending on the attributes of the query. All queries are processed by the dispatcher. It cannot be bypassed.

2) Optimization Engines

The SQL Server Query Optimizer is a cost-based optimizer. Each possible execution plan has an associated cost in terms of the amount of computing resources used. The Query Optimizer must analyze the possible plans and choose the one with the lowest estimated cost.

3) Classic Query Engine

Classic query engine handles all non-SQL queries but SQL query engine won’t handle logical files. CREATE Creates a new table, a view of a table, or other object in database ALTER Modifies an existing database object, such as a table. DROP Deletes an entire table, a view of a table or other object in the database.

4) SQL Query Engine

At a high level, a query engine is a piece of software that sits on top of a database or server and executes queries against data in that database or server to provide answers for users or applications. More specifically, a SQL query engine interprets SQL commands and language to access data in relational systems.

The architecture of SQL is shown in the following diagram:

#SQL(DAY3)History of SQL

                         #SQL(DAY3)

 History of SQL

Today let us know the history of SQL, how the sql was developed, who developed it and when it was developed all these we will be learning in this blog.

History of SQL

“A Relational Model of Data for Large Shared Data Banks” was a paper which was published by the great computer scientist “E.F. Codd” in 1970.

E.F.Codd

The IBM researchers Raymond Boyce and Donald Chamberlin originally developed the SEQUEL (Structured English Query Language) after learning from the paper given by E.F. Codd.

They both developed the SQL at the San Jose Research laboratory of IBM Corporation in 1970.

At the end of the 1970s, relational software Inc. developed their own first SQL using the concepts of E.F. Codd, Raymond Boyce, and Donald Chamberlin.

This SQL was totally based on RDBMS. Relational Software Inc., which is now known as Oracle Corporation, introduced the Oracle V2 in June 1979, which is the first implementation of SQL language. This Oracle V2 version operates on VAX computers.