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