TABLE FUNDAMENTALS
A relational database system can contain one or more objects called Tables.
We can store all the database information in these tables.
Tables are identified by their names and consist of Columns and Rows.
-
Columns are a set of data values, they basically define the data in a table,
-
Rows contain the records or data for the columns.
Let’s understand it with a simple example. Below is the structure of EmployeeDetail Table.

Figure5.1. Sample Table EmployeeDetail
The Columns of the Table EmployeeDetail are:
-
EmployeeId,
-
LastName,
-
FirstName,
-
Address,
-
City
These columns will define what all information can be found in our table.
We have five records or five rows in our Table.
Want More SQL Deep Dives
-
Table Typesable Types
-
DDL, DML, TCL & DCL
-
Null & Not Null Values
-
Creating Tables
-
SQL - Constraints
-
SQL - Index
-
SQL Inserting Data
-
SQL Identity Columns
-
Selecting Data
-
Using Distinct
-
SQL in NOT IN
-
Using Top Clause
-
Where Clause
-
Group By
-
Order By
-
Having
-
Exists
-
Offset
-
SQL - Operators
-
Between
-
Update
-
Delete
-
SQL - Aggregate Functions
-
SQL - Introductions to Joins
-
Table Alias
-
SQL - Inner Join
-
SQL - Left Join
-
SQL - Right Join
-
Full Join
-
Self Join
-
SQL Union
-
Pivot
-
Alter Command
-
Limit Clause
-
Truncate
-
Drop
-
Table Backup
-
SQL - Normalization
-
Subquery
-
SQL - Views & Materialized Views
-
Case Statement
-
SQL Transactions
-
SQL - Functions
-
Working with Dates
-
Grantrevoke
-
SQL - Performance Tunning
-
Stored Procedure Basics
-
Stuffunction
-
Keyword
-
SQL - Miscellaneous