 | | Word of the Day |  | | Daily updates on the latest technology terms | August 27, 2019 | | | SQL (Structured Query Language) | | SQL (Structured Query Language) is a standardized programming language for relational databases. SQL databases are made of tables that contain data in rows and columns. Each column in a table corresponds to a category of data -- for example, customer name or address -- while each row contains a data value for the intersecting column. SQL is commonly used to: - Modify database table and index structures.
- Add, update or delete rows of data.
- Add, update or delete columns of data.
- Retrieve subsets of information from the database.
Initially created in the 1970s, SQL is regularly used not only by database administrators, but also by developers writing data integration scripts and data analysts looking to set up and run analytical queries. An official SQL standard was adopted by the American National Standards Institute (ANSI) in 1986 and then by the International Organization for Standardization, known as ISO, in 1987. More than a half-dozen joint updates to the standard have been released by the two standards development bodies since then. SQL standard and proprietary extensions
Both proprietary and open source relational database management systems built around SQL are available for use by organizations. They include Microsoft SQL Server, Oracle Database, IBM DB2, SAP HANA, SAP Adaptive Server, MySQL (now owned by Oracle) and PostgreSQL. Many of the afore-mentioned database products support SQL with proprietary extensions to the standard language for procedural programming and other functions. For example, Microsoft offers a set of extensions called Transact-SQL (T-SQL), while Oracle's extended version of the standard is PL/SQL. As a result, the different variants of SQL offered by vendors aren't fully compatible with one another. Continued... | |  | "The Presto SQL query engine has found a home in many big data applications. It originated at Facebook, got some help along the way from Teradata, and now is the object of the new Presto Software Foundation." - Jack Vaughan | SQL Server vs. MySQL: Learn the differences
MySQL and Microsoft SQL Server relational databases have pros and cons. Brian Posey discusses both sides of the SQL Server vs. MySQL debate. Amazon's PartiQL query language eyes all data sources
Customers with complex data landscapes may benefit from the Amazon-developed PartiQL, a SQL-like query language that can tap multiple types of data stores in a unified manner, but performance and adoption beyond AWS customers will be crucial. SQL Server in Azure database choices and what they offer users
Microsoft offers three options for running SQL Server in Azure cloud systems: SQL Server on an Azure virtual machine, Azure SQL Database and a managed instance version of the latter. Learn about their features to help you decide which SQL Server cloud option works best for your business. SQL Server database design best practices and tips for DBAs
If your SQL Server database design process misses the mark, your organization won't be able to use Microsoft's database management system to its fullest potential. Get advice on SQL Server development and design best practices to help make the most of your database deployments. Google database portfolio to include 3 new additions
Three enhancements, including Cloud SQL for Microsoft SQL Server in alpha, federated queries from BigQuery to Cloud SQL and expansion of Elastic Cloud to Japan and Sydney, have been added to the Google database portfolio. There's ___ SQL Server tool available to help DBAs with almost any performance issue they may face.
a. a
b. an
Answer About This E-Newsletter
The Word of the Day is published by TechTarget, Inc., 275 Grove Street, Newton, Massachusetts, 02466 US.
Click to: Unsubscribe.
You are receiving this email because you are a member of TechTarget. When you access content from this email, your information may be shared with the sponsors or future sponsors of that content and with our Partners, see up-to-date Partners List, as described in our Privacy Policy. For additional information, please contact: webmaster@techtarget.com.
© 2019 TechTarget, Inc. all rights reserved. Designated trademarks, brands, logos, and service marks are the property of their respective owners.
Privacy Policy | Partners List |  | |
Posts
No comments:
Post a Comment