Statements (115)
| Predicate | Object |
|---|---|
| gptkbp:instance_of |
gptkb:C_programming_language
|
| gptkbp:data_type |
gptkb:date
gptkb:original_score gptkb:text gptkb:Logic gptkb:Blob Decimal Float Json Char Varchar Xml Nchar Nvarchar Time Stamp |
| gptkbp:designed_for |
managing and querying relational databases
Managing and querying relational databases |
| gptkbp:developed_by |
gptkb:IBM
|
| gptkbp:famous_for |
Set-based operations
Declarative syntax ACID properties |
| gptkbp:first_appearance |
gptkb:1974
|
| gptkbp:has |
functions
data types operators open-source implementations commercial implementations |
| gptkbp:has_function |
gptkb:PL/_SQL
Mathematical Functions T-SQL ANSI SQL Aggregate Functions String Functions Control Flow Functions Date Functions My SQL SQL |
| https://www.w3.org/2000/01/rdf-schema#label |
SQL
|
| gptkbp:includes |
DELETE statement
INSERT statement SELECT statement UPDATE statement ALTER statement CREATE statement DROP statement |
| gptkbp:is |
declarative
case-insensitive used for data analysis used in data warehousing widely used in data science used in ETL processes often used in Io T applications often used in cloud applications often used in mobile applications often used in web applications a critical skill for data analysts a critical skill for data scientists a critical skill for database administrators a critical skill for software developers compatible with various programming languages essential for data engineers important for backend developers often used in e-commerce applications often used in enterprise applications often used in financial applications often used in gaming applications often used in healthcare applications often used in social media applications set-oriented used in business intelligence |
| gptkbp:is_standardized_by |
gptkb:ANSI
|
| gptkbp:language |
DELETE
INSERT UPDATE SELECT |
| gptkbp:popular_implementations |
gptkb:My_SQL
gptkb:Postgre_SQL gptkb:Oracle_Database gptkb:Microsoft_SQL_Server |
| gptkbp:related_to |
Data Mining
Data Warehousing Relational Algebra No SQL |
| gptkbp:supports |
gptkb:Views
data manipulation Data Definition Language (DDL) Indexes Stored Procedures Subqueries indexes joins subqueries Triggers data definition Joins views Data Manipulation Language (DML) stored procedures transaction control Data Control Language (DCL) data control triggers Transaction Control Language (TCL) |
| gptkbp:used_by |
gptkb:My_SQL
gptkb:Postgre_SQL gptkb:Oracle_Database gptkb:SQLite gptkb:Microsoft_SQL_Server |
| gptkbp:used_in |
gptkb:Business_Intelligence
Data Analysis Web Development database management systems |
| gptkbp:bfsParent |
gptkb:Data
gptkb:Data_Science gptkb:Web |
| gptkbp:bfsLayer |
3
|