SQL concept
来源:互联网 发布:属下知罪by枯目剧透 编辑:程序博客网 时间:2024/05/15 08:26
SQL tutorial gives unique learning on Structured Query Language and it helps to make practice on SQL commands which provides immediate results.
- MS SQL Server using T-SQL
- Oracle using PL/SQL
- MS Access version of SQL is called JET SQL
When you are executing an SQL command for any RDBMS, the system determines the best way to carry out your request and SQL engine figures out how to interpret the task.
SQL Archetecture
Common SQL command:
- CREATE Creates a new table, a view of a table, or other object in database
- ALTER Modifies an existing database object, such as a table.
- DROP Deletes an entire table, a view of a table or other object in the database.
- INSERT Creates a record
- UPDATE Modifies records
- DELETE Deletes records
- GRANT Gives a privilege to user
- REVOKE Takes back privileges granted from user
- SELECT Retrieves certain records from one or more tables
RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL and for all modern database systems like MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.
Table elements:
- A field is a column in a table that is designed to maintain specific information about every record in the table.
- A record, also called a row of data, is each individual entry that exists in a table.
- A column is a vertical entity in a table that contains all information associated with a specific field in a table.
- A NULL value in a table is a value in a field that appears to be blank, which means a field with a NULL value is a field with no value.
- Constraints are the rules enforced on data columns on table. These are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in the database.
- The DEFAULT constraint provides a default value to a column when the INSERT INTO statement does not provide a specific value.
- The UNIQUE Constraint prevents two records from having identical values in a particular column.
- A primary key is a field in a table which uniquely identifies each row/record in a database table. Primary keys must contain unique values. A primary key column cannot have NULL values.
- A foreign key is a key used to link two tables together. This is sometimes called a referencing key.The relationship between 2 tables matches the Primary Key in one of the tables with a Foreign Key in the second table.
0 0
- SQL concept
- A new concept: dynamic SQL
- Concept
- PCB concept
- RAID Concept
- TTCAN concept
- CCDF_baisc concept
- ORIENT CONCEPT
- BAPI concept
- LUM Concept
- Linux Concept
- Oracle concept
- Storm Concept
- oracle Concept
- AppDomain Concept
- Entropy concept
- Basic Concept
- Oracle Concept
- Java 实现最优路径查找算法(伪Leetcode路径查找算法)
- JZOJ 4822. 【NOIP2016提高A组集训第1场10.29】完美标号
- 编程常识
- 深入剖析Ehcache开源缓存框架
- Android中自定义控件
- SQL concept
- Git分支的前世今生
- mysql 忘记密码怎么办
- Git的使用
- Python介绍
- java虚拟机
- (2016-10-28)Android-NDK学习笔记(一)生成简单的SO文件
- 《把时间当朋友》摘录
- |洛谷|NOIP2015|堆|P2672 推销员