What is a Database Table?

Microsoft SQL Server 2017 for Everyone Manipulating Tables and Data
2 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€64.25
List Price:  €91.79
You save:  €27.53
£55.26
List Price:  £78.95
You save:  £23.68
CA$95.30
List Price:  CA$136.16
You save:  CA$40.85
A$104.44
List Price:  A$149.21
You save:  A$44.76
S$94.20
List Price:  S$134.58
You save:  S$40.38
HK$546.10
List Price:  HK$780.18
You save:  HK$234.07
CHF 63.82
List Price:  CHF 91.18
You save:  CHF 27.35
NOK kr751.73
List Price:  NOK kr1,073.95
You save:  NOK kr322.21
DKK kr480.45
List Price:  DKK kr686.39
You save:  DKK kr205.93
NZ$114.09
List Price:  NZ$162.99
You save:  NZ$48.90
د.إ257.07
List Price:  د.إ367.26
You save:  د.إ110.19
৳8,153.02
List Price:  ৳11,647.67
You save:  ৳3,494.65
₹5,830.20
List Price:  ₹8,329.22
You save:  ₹2,499.01
RM328.07
List Price:  RM468.70
You save:  RM140.62
₦102,885.30
List Price:  ₦146,985.30
You save:  ₦44,100
₨19,393.48
List Price:  ₨27,706.17
You save:  ₨8,312.68
฿2,519.17
List Price:  ฿3,598.96
You save:  ฿1,079.79
₺2,256.71
List Price:  ₺3,224.01
You save:  ₺967.30
B$357.27
List Price:  B$510.40
You save:  B$153.13
R1,282.86
List Price:  R1,832.74
You save:  R549.87
Лв125.91
List Price:  Лв179.88
You save:  Лв53.96
₩94,793.75
List Price:  ₩135,425.45
You save:  ₩40,631.70
₪258.47
List Price:  ₪369.26
You save:  ₪110.78
₱4,048.92
List Price:  ₱5,784.42
You save:  ₱1,735.49
¥10,895.69
List Price:  ¥15,565.94
You save:  ¥4,670.25
MX$1,162.43
List Price:  MX$1,660.69
You save:  MX$498.25
QR253.91
List Price:  QR362.75
You save:  QR108.83
P943.39
List Price:  P1,347.76
You save:  P404.36
KSh9,085.75
List Price:  KSh12,980.20
You save:  KSh3,894.45
E£3,276.75
List Price:  E£4,681.28
You save:  E£1,404.52
ብር3,999.12
List Price:  ብር5,713.27
You save:  ብር1,714.15
Kz59,421.51
List Price:  Kz84,891.51
You save:  Kz25,470
CLP$62,605.89
List Price:  CLP$89,440.82
You save:  CLP$26,834.93
CN¥505.55
List Price:  CN¥722.24
You save:  CN¥216.69
RD$4,078.44
List Price:  RD$5,826.59
You save:  RD$1,748.15
DA9,423.52
List Price:  DA13,462.75
You save:  DA4,039.23
FJ$155.95
List Price:  FJ$222.79
You save:  FJ$66.84
Q540.94
List Price:  Q772.81
You save:  Q231.86
GY$14,566.49
List Price:  GY$20,810.17
You save:  GY$6,243.67
ISK kr9,646.55
List Price:  ISK kr13,781.37
You save:  ISK kr4,134.82
DH693.20
List Price:  DH990.33
You save:  DH297.13
L1,231.95
List Price:  L1,760
You save:  L528.05
ден3,957.99
List Price:  ден5,654.52
You save:  ден1,696.52
MOP$559.54
List Price:  MOP$799.37
You save:  MOP$239.83
N$1,273.79
List Price:  N$1,819.78
You save:  N$545.99
C$2,563.07
List Price:  C$3,661.69
You save:  C$1,098.61
रु9,282.12
List Price:  रु13,260.75
You save:  रु3,978.62
S/260
List Price:  S/371.45
You save:  S/111.44
K270.37
List Price:  K386.26
You save:  K115.89
SAR262.46
List Price:  SAR374.96
You save:  SAR112.50
ZK1,777.13
List Price:  ZK2,538.86
You save:  ZK761.73
L320.28
List Price:  L457.57
You save:  L137.28
Kč1,590.03
List Price:  Kč2,271.57
You save:  Kč681.54
Ft24,904.88
List Price:  Ft35,579.92
You save:  Ft10,675.04
SEK kr750.08
List Price:  SEK kr1,071.59
You save:  SEK kr321.50
ARS$61,703.42
List Price:  ARS$88,151.52
You save:  ARS$26,448.10
Bs481.07
List Price:  Bs687.27
You save:  Bs206.20
COP$266,463.69
List Price:  COP$380,678.73
You save:  COP$114,215.04
₡35,632.87
List Price:  ₡50,906.29
You save:  ₡15,273.41
L1,723.87
List Price:  L2,462.78
You save:  L738.91
₲521,670.94
List Price:  ₲745,276.15
You save:  ₲223,605.20
$U2,715.34
List Price:  $U3,879.22
You save:  $U1,163.88
zł274.22
List Price:  zł391.77
You save:  zł117.54
Already have an account? Log In

Transcript

Now let us discuss briefly what a table is. Now a database consists of one or more tables. A table comprises rows and columns. Essentially, if you will look at an Excel spreadsheet, you'd see that you have rows depicted by numbers and you have columns depicted by letters. So in the cell A one, you would have some amounts of data, and usually you would create some form of tabular structure. Let's say for instance, for the list of students and you have an Excel spreadsheet, you'd have a sheet post students, and then you would have columns first name, last name, date of birth, etc.

And then in each cell underneath the respective columns, you would have the appropriate bit of data to support that value. Together. This record or rule would create a description of an object or a student's. So in the same way that we can visualize data in an Excel spreadsheet it is is the same way that it is represented in an SQL table. So we have rows and we have columns. And rows, create records under meetup have data points.

And each column in the table stores the data point, which can be in the form of text or a number or a date, but many data types that are supported. And all of these combined to tell us details of an object. So that's essentially what a table looks like in a database. And then in the same vein, each row or record should be uniquely identifiable using what we call a primary key. So in the next video, we'll go about creating an table. Remember our database is called school and we will go about creating our first table to store all of our students stick around.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.