- SQL Basics
- SQL Home
- SQL Syntax
- SQL RDBMS
- SQL Databases
- SQL Data Types
- SQL Operators
- SQL Expressions
- SQL Database
- SQL Create Database
- SQL Select Database
- SQL Drop Database
- SQL Table
- SQL Create Table
- SQL Drop Table
- SQL Keywords
- SQL Insert Into
- SQL Select
- SQL Where
- SQL And & Or
- SQL Update
- SQL Delete
- SQL Like
- SQL Select Top
- SQL Group By
- SQL Order By
- SQL Distinct
- SQL In
- SQL Between
- SQL Joins
- SQL Joins
- SQL Inner Join
- SQL Left Join
- SQL Right Join
- SQL Full Join
- SQL Constraints
- SQL Constraints
- SQL Unique
- SQL Not Null
- SQL Primary Key
- SQL Foreign Key
- SQL Check
- SQL Default
- SQL Create Index
- SQL Advance
- SQL Aliases
- SQL Union
- SQL Auto Increment
- SQL Views
- SQL Dates
- SQL Transactions
- SQL Injection
- SQL Test
- SQL Online Test
- Give Online Test
- All Test List
SQL RDBMS
RDBMS (in long, Relational Database Management System), is basis for Structured Query Language, and for all the modern database systems like MySQL, Oracle, MS Access, etc.
SQL Tables
The data in Relational Database Management System (RDBMS) is stored in database objects which is called as tables.
A table is basically a collection of some related data entries in the form of rows and columns.
Here is an example of a table. The name of the table is CUSTOMERS
SQL Fields
A field in SQL is a column of the table. Here are the field listed of the table CUSTOMERS:
- ID
- NAME
- AGE
- ADDRESS
- SALARY
SQL Record
A record in SQL is a row of the table. For instance, there are 7 records present in the table CUSTOMERS. Here is a single row of data or record present in the table CUSTOMERS:
SQL Column
A column in SQL is simply a vertical entity in a table, contains all the information associated with a specific field present inside the table. For instance, a column in the table named CUSTOMERS is ADDRESS, which represents the location and consist of the following:
« Previous Tutorial Next Tutorial »
Like/Share Us on Facebook 😋