MySQL

  In this blog, we will be going through different types of SQL statements. So let’s get started.   Types of SQL Commands.   SQL (Structured Query Language) is the database language that is used to interact with the database. As all the languages have some specific set of ground rules so does SQL. Today we will be going through the basic types of SQL statements. SQL statements are broadly classified into 5 categories. 1.       Data Definition Language (DDL) 2.       Data Manipulation Language (DML) 3.       Data Control Language (DCL) 4.       Transaction Control Language (TCL) 5.       Data Query Language (DQL)     Data Definition Language (DDL)                Data Definition Language (DDL) is used to create and modify the structure of database ...

In this blog , we will be going through the MySQL various server edition. Basically we have 2 different server editions 1.      MySQL Community Server 2.      MySQL Enterprise Server What is the difference between the two server edition ? Difference between the community edition and the enterprise edition is added support and tools.  The server itself remains the same but with enterprise edition you will be getting more frequent update and it is a stable quick bug support.  MySQL Enterprise edition was created by MySQL AB as a commercial product to be available for purchase as a subscription. MySQL Enterprise Server is most reliable, secure and up-to-date version of MySQL servers. It provides monitoring and automated Advisors to help you eliminate potential security issues, vulnerabilities, improve replication, optimize performance, and more. With MySQL Enterprise Server Subscription you receive Technical and Consulatative support. That's it ...

Hello Fellas, Today we will dive into Database Systems . Database is an important factor in multiple small or large scale software. Let’s discuss one of the major database systems.                                           MySQL is an open-source relational database management system (RDBMS). Its name is a combination of " My ", the name of co-founder Michael Widenius's daughter, and "SQL", the abbreviation for Structured Query Language. But Why MySQL? 1. First and foremost it is free to download and use as it is an Open Source software. 2. MySQL is a Relational Database Management System (RDBMS).          Now, what is RDBMS? We will have a separate series explaining the details of DBMS and RDMS. But for an overview,              RDBMS is a collection of data in the form of rows and columns (Just li...