SQL
(Created page with "SQL ('''Structured Query Language''') is a computer language used to communicate with databases. It lets you access and manipulate databases * SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987 ==== What Can SQL do? ==== * SQL can execute queries against a database * SQL can retrieve data from a database * SQL can insert records in a database * SQL can update record...")
 
(Replacing message template with parser tag)
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<message>Write the content here to display this box</message>
SQL ('''Structured Query Language''') is a computer language used to communicate with databases. It lets you access and manipulate databases
SQL ('''Structured Query Language''') is a computer language used to communicate with databases. It lets you access and manipulate databases


Line 18: Line 19:
'''Learn more:''' https://www.w3schools.com/sql/default.asp  
'''Learn more:''' https://www.w3schools.com/sql/default.asp  


'''See also''':
'''See also''':  
 
# [[Documentation:Understanding OCL with reference to SQL|Understanding OCL with reference to SQL]],
# [[Documentation:How your classes are stored in the SQL database when using MDriven|How your classes are stored in the SQL database when using MDriven]],
# [[Documentation:Part 5 Searching in databases|Part 5 Searching in databases]]

Latest revision as of 07:55, 17 June 2024

SQL (Structured Query Language) is a computer language used to communicate with databases. It lets you access and manipulate databases

  • SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987

What Can SQL do?

  • SQL can execute queries against a database
  • SQL can retrieve data from a database
  • SQL can insert records in a database
  • SQL can update records in a database
  • SQL can delete records from a database
  • SQL can create new databases
  • SQL can create new tables in a database
  • SQL can create stored procedures in a database
  • SQL can create views in a database
  • SQL can set permissions on tables, procedures, and views

Learn more: https://www.w3schools.com/sql/default.asp

See also:

  1. Understanding OCL with reference to SQL,
  2. How your classes are stored in the SQL database when using MDriven,
  3. Part 5 Searching in databases
This page was edited 95 days ago on 06/17/2024. What links here