What is MySQL

What is MySQL What is MySQL? An Introduction To Database Management Systems Back Home Categories Online Courses Mock Interviews Webinars NEW Community Write for Us Categories Artificial Intelligence AI vs Machine Learning vs Deep LearningMachine Learning AlgorithmsArtificial Intelligence TutorialWhat is Deep LearningDeep Learning TutorialInstall TensorFlowDeep Learning with PythonBackpropagationTensorFlow TutorialConvolutional Neural Network TutorialVIEW ALL BI and Visualization What is TableauTableau TutorialTableau Interview QuestionsWhat is InformaticaInformatica Interview QuestionsPower BI TutorialPower BI Interview QuestionsOLTP vs OLAPQlikView TutorialAdvanced Excel Formulas TutorialVIEW ALL Big Data What is HadoopHadoop ArchitectureHadoop TutorialHadoop Interview QuestionsHadoop EcosystemData Science vs Big Data vs Data AnalyticsWhat is Big DataMapReduce TutorialPig TutorialSpark TutorialSpark Interview QuestionsBig Data TutorialHive TutorialVIEW ALL Blockchain Blockchain TutorialWhat is BlockchainHyperledger FabricWhat Is EthereumEthereum TutorialB lockchain ApplicationsSolidity TutorialBlockchain ProgrammingHow Blockchain WorksVIEW ALL Cloud Computing What is AWSAWS TutorialAWS CertificationAzure Interview QuestionsAzure TutorialWhat Is Cloud ComputingWhat Is SalesforceIoT TutorialSalesforce TutorialSalesforce Interview QuestionsVIEW ALL Cyber Security Cloud SecurityWhat is CryptographyNmap TutorialSQL Injection AttacksHow To Install Kali LinuxHow to become an Ethical Hacker?Footprinting in Ethical HackingNetwork Scanning for Ethical HackingARP SpoofingApplication SecurityVIEW ALL Data Science Python Pandas TutorialWhat is Machine LearningMachine Learning TutorialMachine Learning ProjectsMachine Learning Interview QuestionsWhat Is Data ScienceSAS TutorialR TutorialData Science ProjectsHow to become a data scientistData Science Interview QuestionsData Scientist SalaryVIEW ALL Data Warehousing and ETL What is Data WarehouseDimension Table in Data WarehousingData Warehousing Interview QuestionsData warehouse architectureTalend T utorialTalend ETL ToolTalend Interview QuestionsFact Table and its TypesInformatica TransformationsInformatica TutorialVIEW ALL Databases What is MySQLMySQL Data TypesSQL JoinsSQL Data TypesWhat is MongoDBMongoDB Interview QuestionsMySQL TutorialSQL Interview QuestionsSQL CommandsMySQL Interview QuestionsVIEW ALL DevOps What is DevOpsDevOps vs AgileDevOps ToolsDevOps TutorialHow To Become A DevOps EngineerDevOps Interview QuestionsWhat Is DockerDocker TutorialDocker Interview QuestionsWhat Is ChefWhat Is KubernetesKubernetes TutorialVIEW ALL Front End Web Development What is JavaScript â€" All You Need To Know About JavaScriptJavaScript TutorialJavaScript Interview QuestionsJavaScript FrameworksAngular TutorialAngular Interview QuestionsWhat is REST API?React TutorialReact vs AngularjQuery TutorialNode TutorialReact Interview QuestionsVIEW ALL Mobile Development Android TutorialAndroid Interview QuestionsAndroid ArchitectureAndroid SQLite DatabaseProgramming An Intr... MySQL (55 B logs) Become a Certified Professional AWS Global Infrastructure Introduction to SQL What is a Database? Definition, Types and ComponentsWhat is SQL and how to get started with it?SQL Basics â€" One Stop Solution for BeginnersWhat are SQL Operators and how do they work?Understanding SQL Data Types â€" All You Need To Know About SQL Data TypesSQL Tutorial : One Stop Solution to Learn SQLDBMS Tutorial : A Complete Crash Course on DBMSCREATE TABLE in SQL â€" Everything You Need To Know About Creating Tables in SQLWhat is a Schema in SQL and how to create it?What is a Cursor in SQL and how to implement it?Top 10 Reasons Why You Should Learn SQLLearn how to use SQL SELECT with examplesSQL Functions: How to write a Function in SQL?What is SQL Regex and how to implement it?SQL UPDATE : Learn How To Update Values In A TableSQL Union â€" A Comprehensive Guide on the UNION OperatorWhat are Triggers in SQL and how to implement them?INSERT Query SQL â€" All You Need to Know about the INSERT statementHow To Use Alter Table Statement In SQL?What is Normalization in SQL and what are its types?How to perform IF statement in SQL?What are SQL constraints and its different types?Learn How To Use CASE Statement In SQLPrimary Key In SQL : Everything You Need To Know About Primary Key OperationsForeign Key SQL : Everything You Need To Know About Foreign Key OperationsSQL Commands - A Beginner's Guide To SQLHow To Rename a Column Name in SQL?How to retrieve a set of characters using SUBSTRING in SQL?What is the use of SQL GROUP BY statement?How To Use ORDER BY Clause In SQL?How to use Auto Increment in SQL?Everything You Need to Know About LIKE Operator in SQLWhat is an index in SQL?Understanding SQL Joins â€" All You Need To Know About SQL JoinsDifferences Between SQL An Introduction To Database Management Systems Last updated on May 22,2019 10.5K Views Sahiti Kappagantula Bookmark 1 / 6 Blog from Introduction To MySQL Become a Certified Professional Database Management is the most important part when you have humungous data around you. MySQL is one of the most famous Relational Database to store handle your data. In this What is MySQL blog, you will be going through the following topics:What are Data Database?Database Management System Types of DBMSStructured Query Language(SQL)MySQL its featuresMySQL Data TypesWhat are Data Database?Suppose a company needs to store the names of hundreds of employees working in the company in such a way that all the employees can be individually identified. Then, the company collects the data of all those employees. Now, when I say data, I mean that the company collects distinct pieces of information about an object. So, that object could be a real-world entity such as people, or any object such as a mouse, laptop etc.Now, when you have such a large amount of data, you obviously need a place to store it, which is a Database.So, you can consider the database as a big container, wherein you can store all the da ta. But do you think you can use your data without a proper management of the database?Its an obvious No!So, lets know what exactly is Database Management System and its various types.Database Management System Types of DBMSADatabase Management System(DBMS) is a software application that interacts with the user, applications and the database itself to capture and analyze data.The data stored in the database can be modified, retrieved and deleted, and can be of any type like strings, numbers, images etc.Types of DBMSThere are mainly 4 types of DBMS, which are Hierarchical, Relational, Network, and Object-Oriented DBMS.Hierarchical DBMS: As the name suggests, this type of DBMS has a style of predecessor-successor type of relationship. So, it has a structure similar to that of a tree, whereinthe nodes represent records and the branches of the tree represent fields.Relational DBMS (RDBMS):This type of DBMS, uses a structure that allows the users to identify and access datain relationto another piece of data in the database.Network DBMS: This type of DBMS supports many to many relations wherein multiple member records can be linked.Object-oriented DBMS: This type of DBMS uses smallindividualsoftware called objects. Each object contains a piece of data, and the instructions for the actions to be done with the data.Now, that I have told you about DBMS, its time that we understandwhat is SQL?Subscribe to our youtube channel to get new updates..! Structured Query Language (SQL)SQL is the core of a relational database which is used for accessing and managing the database. By using SQL, you can add, update or delete rows of data, retrieve subsets of information,modify databases and perform many actions. The different subsets of SQL are as follows:DDL (Data Definition Language) It allows you to perform various operations on the database such as CREATE, ALTER and DELETE objects.DML (Data Manipulation Language) It allows you to access and manipulate data. It helps you to insert, update, delete and retrieve data from the database.DCL (Data Control Language) It allows you to control access to the database. Example Grant or Revoke access permissions.TCL(Transaction Control Language) It allows you to deal with the transaction of the database. Example Commit, Rollback, Savepoint, Set Transaction.Alright! So, now that you know SQL, its time I introduce to MySQL.What is MySQL its FeaturesMySQL is an open-source relational database management system that works on many platforms. It provides multi-user access to support many storage engines and is backed by Oracle. So,you can buy a commercial license version from Oracle to get premium support services.The features of MySQL are as follows:Fig 1: Features of MySQL What is MySQL?Ease of Management The software very easily gets downloaded and also uses an event scheduler to schedule the tasks automatically.Robust Transactional Support Holds the ACID (Atomicity, Consistency, Isolation, Durability) property, and also allows distributed multi-version support.Comprehensive Application Development MySQL has plugin libraries to embed the database into any application. It also supports stored procedures, triggers, functions, views and many more for application development. You can refer to the RDS Tutorial, to understand Amazons RDBMS.High Performance Provides fast load utilities with distinct memory caches and table index partitioning.Low Total Cost Of Ownership This reduces licensing costs and hardware expenditures.Open Source 24 * 7 Support This RDBMS can be used on any platform and offers 24*7 support for open source and enterprise edition.Secure Data Protection MySQL supports powerful mechanisms to ensure that only authorized users have access to the databases.High Availability MySQL can run high-speed master/slave replication configurations and it offers cluster servers.Scalability Flexibility With MySQL you can run deeply embedded applications and create data warehouses holding a h umongous amount of data.Now, that you guys know what is MySQL, let me tell you various data types supported by MySQL. Interested to learn more about MySQL Learn Now MySQL Data TypesFig 2:MySQL Data Types What is MySQL?Numeric This data type includes integers of various sizes, floating-point(real) of various precisions and formatted numbers.Character-string These data types either have a fixed, or a varying number of characters. This data type also has a variable-length string called CHARACTER LARGE OBJECT(CLOB) which is used to specify columns that have large text values.Bit-string These data types are either of a fixed length or varying length of bits. There is also a variable-length bit string data type called BINARY LARGE OBJECT(BLOB), whichis available to specify columns that have large binary values, such as images.Boolean This data type has TRUE or FALSE values. Since SQL, has NULL values, a three-valued logic is used, which is UNKNOWN.Date Time The DATE data type has: Y EAR, MONTH, and DAY in the form YYYY-MM-DD. Similarly, the TIME data type has the components HOUR, MINUTE, and SECOND in the form HH:MM: SS. These formats can change based on the requirement.Timestamp Interval The TIMESTAMP data type includes a minimum of six positions, for decimal fractions of seconds and an optional WITH TIME ZONE qualifier in addition to the DATE and TIME fields. The INTERVAL data type mentionsa relative value that can be used to increment or decrement an absolute value of a date, time, or timestamp. I hope that you have enjoyed reading this What is MySQL blog. In continuation of this blog, a MySQL Tutorial will be coming up wherein we will be getting started with all the SQL commands, but before that you can refer to this SQL Interview Questions blog, to know the top questions asked in interviews. Stay tuned! Want to get certified in Database Administration? View Batches Now If you wish to learn more about MySQL and get to knowthis open source relational datab ase, then check out ourMySQL DBA Certification Trainingwhichcomes with instructor-led live training and real-life project experience.This training will help you understand MySQL in depth and help you achieve mastery over the subject.Got a question for us? Please mention it in the comments section of What is MySQL? and I will get back to you.Recommended videos for you Introduction to MongoDB Watch Now Build Application With MongoDB Watch NowRecommended blogs for you What is Normalization in SQL and what are its types? Read Article Understanding MongoDB Architecture Read Article MySQL Tutorial A Beginners Guide To Learn MySQL Read Article Differences Between SQL NoSQL Databases MySQL MongoDB Comparison Read Article Top 10 Reasons Why You Should Learn SQL Read Article SSIS Tutorial For Beginners: Why, What and How? Read Article How To Install MySQL on Windows 10? Your One Stop Solution To Install MySQL Read Article MongoDB Interview Questions For Beginners And Professionals In 20 20 Read Article MySQL Workbench Tutorial A Comprehensive Guide To The RDBMS Tool Read Article SQL Views: How to work with Views in SQL? Read Article Learn About Concatenate In SQL With Examples Read Article How To Use ORDER BY Clause In SQL? Read Article MongoDB Vs Cassandra Read Article Top 30 SQL Query Interview Questions You Must Practice In 2019 Read Article What is Database Testing and How to Perform it? Read Article Understanding SQL Joins â€" All You Need To Know About SQL Joins Read Article How To Rename a Column Name in SQL? Read Article SQL Functions: How to write a Function in SQL? Read Article Development and Production of MongoDB Read Article What is SQL and how to get started with it? Read Article Comments 0 Comments Trending Courses in Databases SQL Essentials Training Certification6k Enrolled LearnersWeekend/WeekdaySelf Paced Reviews 5 (2400)