History of SQL


Hello and welcome to everyone. Today we will learn SQL history.

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/

We previously discussed in 1970, Dr. Codd published a paper about the Relational Data Model and it may have ended there. Donald Chamberlin and Raymond Boyce started working on SQL in the 70s. In 1973 Chamberlin and Boyce started working on SQL and what they called SEQUEL. SEQUEL full form is Structured English Query Language. After that, they have changed it to SQL due to a trademark conflict with a UK aircraft company. A lot of people say either SQL or SEQUEL. This organization of work that they were doing on sequel started making a buzz in the industry. Donald Chamberlin and Raymond Boyce started working on a SQL based relational database management system this company is called Relational Software Inc. Relational Software released its first commercially relational database management system in 1979. Relational Software Inc. company later changed its name to Oracle.
IBM released shortly on the heels 1979 a system called SQL data system or SQL/DS. After that in 1985, IBM released DB2 this is IBM’s brand of the relational database management system. After that Microsoft released their first version of SQL server in 1987.
In 1994 Swedish company called MySQL AB released MySQL for internal use. The original developer is Michael Monty. MySQL named after Monty’s daughter My or me. In 1996 Postgre95 is renamed to PostgreSQL to reflect its support for SQL. On October 22, 1996, began online existence at the website PostgreSQL.org. It’s still widely accepted to use just Postgres. After that MySQL becomes an open source database under GPL. In that, they do public license which is a very popular license and it gives you a lot of freedom. In 2001 MySQL take off and they have over 2 million active installations. In 2005 Oracle acquired InnoDB this is the company behind the storage engine of the backend of MySQL.
2001 to 2006 MySQL grew active installations from 2 million to over 8 million and the company had 320 employees across 25 countries. MySQL is an open source and as a developer, we may look at it’s a free database. In 2008 MySQL getting very popular and Sun Microsystems purchases MySQL. And shortly thereafter Oracle buys Sun Microsystems and they get MySQL. One of the original founders Michael Monty actually left Sun Microsystems and he developed a fork of MySQL called MariaDB (Maira is Michael’s daughters). MariaDB is becoming a very popular database.


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/

ANSI
ANSI stands for American National Standards Institute. ANSI has published a standard series of SQL language. It is widely embraced in theory. If you have able to write ANSI SQL and run it on any database, but there are quirks and gotchas that you will see going between Oracle to Postgres to MySQL.
1986 first SQL standard was formalized by American National Standards Institute.
In 1989 SQL89 came out and this added integrity constraints.
In 1992 SQL92 comes out and this is a major review, in that lot of features that were missing and this was a lot of sterner compliance data.
In 1999 they added regular expressions and that is very confusing. When you get the first starting you used to weigh an expression of searching for things database triggers which is a cool feature.
In 2003 SQL2003 comes out and in that, they added in XML support and columns with auto-generated values this is the cool feature.
In 2006 SQL2006 comes out and more XML support and features specifically for using SQL with XML.
In 2008 SQL2008 comes out and added instead of triggers in that. So we will look at the truncate statement, this is a very treacherous statement. When you use truncate statement on the table, and then empty that table with all data.
In 2011 SQL2011 comes out and in that add a bunch of features for temporal data so that is kind of interesting area to be working with.
In 2016 SQL2016 comes out and this adds in a row pattern matching. You can use regular expressions to match rows and JSON features stuck getting added up into the standard. Some years ago XML was very popular now JSON is very popular. The standard came out and matured and then started evolving with the industry and trends industry such as XML and JSON.


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:- 
https://expertwithsagarjaybhay.com/history-of-sql/

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