From the course: Microsoft SQL Server 2016: Query Data

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

A history of SQL and T-SQL

A history of SQL and T-SQL - SQL Server Tutorial

From the course: Microsoft SQL Server 2016: Query Data

Start my 1-month free trial

A history of SQL and T-SQL

“

- [Instructor] In this lesson we'll take a look at a brief history of SQL and Transact SQL. Now a history of SQL is not truly necessary to effectively use it, but it is important to understand the underlying concepts. And as a result, a brief history can help us with that. In 1970 Dr. E.F Codd published a paper called A Relational Model of Data for Large Shared Data Banks and that has become the standard model for relational database management systems. Shortly thereafter, IBM developed the Structured Query Language, originally called SEQUEL and now shortened to SQL but still pronounced SEQUEL. SQL has been accepted as the standard RDBMS language. It became an ANSI standard in 1986. And of course, it has been updated over the years. With the current standard being SQL 2011. T-SQL is the dialect that Microsoft has implemented for its Microsoft SQL Server product. It implements the ANSI standard SQL but it also adds extensions to the language. Now extensions are typically added to…

Contents