History of MySQL


MongoDB with .Net Core: https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/

C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/ 

Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/

MySQL got over 100 million downloads and it’s most popular database in history. MySQL is a Relational Database Management System it’s owned by Oracle, but MySQL is open source under GPL and it’s free to use. Some people say my sequel but officially pronounced My Ess Que Ell and some people calling it my sequel. In 1995 a Swedish company called MySQL. MySQL developed by Michael Monty Widenius, David Axmark and Allan Larsson. MySQL named on Monty’s daughter. MySQL released under a GPL (General Public License) and it just gives to public license in 2000. 2001 it had over 2 million active installations. In 2005 Oracle acquired InnoDB, this is the storage back-end of MySQL. MySQL over 8 million installations in 2006, 320 employees over 25 countries. Sun Microsystems actually bought MySQL in 2008 for 1 billion dollars. MySQL become a choice database for large organization, banks because its reliability, durability and scalability. Oracle went after Sun Microsystem in 2010. Michael Monty actually left Sun Microsystems and he developed a fork of MySQL called is MariaDB. Oracle industry cynical people saw MySQL is a competitor of Oracle and they are going to crush it and stop it, but that has not happened. MySQL does continue and Oracle is seeing a lot of success with the product. MariaDB is 100 percent compatible with MySQL. The code base has been in forked; they are developing it separately from MySQL. Most important features of MySQL are Relational Database Management System and you can write stored procedures.
SQL stands for Structured Query Language and its support the ANSI standards. MySQL written in C and C++, these are very popular programming languages. C and C++ do compile down the native machine code there you can compile on different platforms. That’s why MySQL is port to different operating systems.

MongoDB with .Net Core: https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/

C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/ 

Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/


Features of MySQL
v  MySQL are Relational Database Management Systems.
v  In MySQL you can write stored procedures.
v  Triggers: using triggers you can sort of record that trigger will run before or after that transaction.
v  Cursors are something that you can use to get a large set of data, and so you can scroll through it next record.
v  Views are like a virtual table but actual SQL view. Views store inside the database.
v  Query Caching is a technology where the database is going to remember in memory. When you ask for data again it does not go back to the file system to find the data. Data will store in real memory.
v  Sub selection where you can have nested queries.
v  ACID compliance is concept when you have multiple users on the system, if you going to like series of sequence, a statements in a sequence all those statements should complete.
v  Transaction if you creating an employee table and insert a employee header record then you going to insert like the line and that set of a database transaction.
v  Isolation the results of the transactions are done end to end. Function in isolation when they commit they become available to others.

MongoDB with .Net Core: https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/

C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/ 

Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/

Visit our website:- 

Comments

Post a Comment

Popular posts from this blog

ALTER statement in MySQL

Image
Hello and welcome everyone. In this article, we will learn about the ALTER table statement in MySQL. Let’s go. MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/ C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/ MySQL ALTER command is used to modify the table, view an existing database. When you have completed your database design and after that, you realize some of the information was left out when creating a database. You want to change without losing existing data, and then you can change data using ALTER command. MySQL ALTER command is used to add a column with an existing table, add multiple columns, drop a column, modify a column, rename a column, and rename the table. ALTER command also used to add and drop constraints on the existing table. ...
Read more

Order By Clause in MySQL

Image
Hello and welcome everyone. In this article, we will learn about the Order By Clause in MySQL. Let’s go. MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/ C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/ MySQL Order by clause is used to sort the records or data in ascending or descending order. Order by clause allows us to sort records or data by a single column or multiple columns in ascending or descending order. There are two key using in Order by clause:          ASC: - sorting data or records by ascending order.          DESC: - sorting data or records by descending order. Syntax:          SELECT column_name_1, column_n...
Read more

MySQL Constraint – PRIMARY KEY

Image
C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/ Hello everyone in the previous article we learn about MySQL Constraint – UNIQUE and in this article, we will learn PRIMARY KEY constraint with example. Let’s go. MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/ What is the PRIMARY KEY? MySQL PRIMARY KEY constraint uniquely identifies each row in a table and also it creates a unique index for accessing the table will access faster. The columns of a Primary Key cannot have null values in MySQL and it must contain unique values. A Primary key has only one on a table, if the primary key used with multiple fields, then they are called a Composite Key. Syntax 1 for creating PRIMARY KEY with CREATE table statement.      ...
Read more