17
views
Share the link to this page
Copied

About the Class

What will you learn in this course?

  • Select statements
  • Giving the output field a different name
  • Using Where statements to get the exact records you are looking for
  • Using Order By statements to sort the data
  • Creating Subtotals with the group by statement
  • Introduction to joining tables together

The files mentioned in the video will be in the link that is included in the video.

Author

Tom Fragale - Microsoft Certified Trainer

Tom Fragale - Microsoft Certified Trainer - PCWebinars.com
Tom Fragale is a computer professional with over 30 years of professional experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel., and a Microsoft Certified Specialist in Access, Outlook, and PowerPoint. He has trained over 30,000 business people in on-line...

School

Tom Fragale - Microsoft Certified Trainer's School

Requirements

There are no additional requirements.
One-time Fee
$39
List Price:  $99
You save:  $60
€36.19
List Price:  €91.86
You save:  €55.67
£30.96
List Price:  £78.61
You save:  £47.64
CA$53.08
List Price:  CA$134.76
You save:  CA$81.67
A$60.11
List Price:  A$152.60
You save:  A$92.48
S$52.68
List Price:  S$133.74
You save:  S$81.05
HK$305.12
List Price:  HK$774.54
You save:  HK$469.42
CHF 35.34
List Price:  CHF 89.71
You save:  CHF 54.37
NOK kr423.28
List Price:  NOK kr1,074.48
You save:  NOK kr651.20
DKK kr269.91
List Price:  DKK kr685.16
You save:  DKK kr415.24
NZ$65.45
List Price:  NZ$166.14
You save:  NZ$100.69
د.إ143.21
List Price:  د.إ363.55
You save:  د.إ220.33
৳4,281.10
List Price:  ৳10,867.41
You save:  ৳6,586.31
₹3,252.73
List Price:  ₹8,256.95
You save:  ₹5,004.21
RM184.58
List Price:  RM468.56
You save:  RM283.98
₦55,324.23
List Price:  ₦140,438.43
You save:  ₦85,114.20
₨10,847
List Price:  ₨27,534.70
You save:  ₨16,687.69
฿1,422.74
List Price:  ฿3,611.58
You save:  ฿2,188.83
₺1,260.65
List Price:  ₺3,200.12
You save:  ₺1,939.47
B$194.71
List Price:  B$494.26
You save:  B$299.55
R744.40
List Price:  R1,889.65
You save:  R1,145.24
Лв70.46
List Price:  Лв178.86
You save:  Лв108.40
₩52,732.38
List Price:  ₩133,859.12
You save:  ₩81,126.74
₪143.78
List Price:  ₪364.98
You save:  ₪221.20
₱2,197.44
List Price:  ₱5,578.13
You save:  ₱3,380.69
¥5,906.93
List Price:  ¥14,994.52
You save:  ¥9,087.59
MX$647.23
List Price:  MX$1,642.97
You save:  MX$995.74
QR142.09
List Price:  QR360.70
You save:  QR218.60
P534.71
List Price:  P1,357.34
You save:  P822.63
KSh5,128.50
List Price:  KSh13,018.50
You save:  KSh7,890
E£1,844.70
List Price:  E£4,682.70
You save:  E£2,838
ብር2,215.66
List Price:  ብር5,624.39
You save:  ብር3,408.72
Kz32,612.23
List Price:  Kz82,784.89
You save:  Kz50,172.66
CLP$38,215.32
List Price:  CLP$97,008.12
You save:  CLP$58,792.80
CN¥281.98
List Price:  CN¥715.79
You save:  CN¥433.81
RD$2,309.61
List Price:  RD$5,862.87
You save:  RD$3,553.25
DA5,261.95
List Price:  DA13,357.25
You save:  DA8,095.30
FJ$88.19
List Price:  FJ$223.88
You save:  FJ$135.69
Q304.17
List Price:  Q772.13
You save:  Q467.96
GY$8,160.98
List Price:  GY$20,716.35
You save:  GY$12,555.36
ISK kr5,439.72
List Price:  ISK kr13,808.52
You save:  ISK kr8,368.80
DH395.18
List Price:  DH1,003.16
You save:  DH607.98
L687.77
List Price:  L1,745.88
You save:  L1,058.11
ден2,224.04
List Price:  ден5,645.65
You save:  ден3,421.61
MOP$314.33
List Price:  MOP$797.91
You save:  MOP$483.58
N$738.51
List Price:  N$1,874.70
You save:  N$1,136.18
C$1,435.79
List Price:  C$3,644.70
You save:  C$2,208.91
रु5,201.41
List Price:  रु13,203.60
You save:  रु8,002.18
S/144.64
List Price:  S/367.17
You save:  S/222.52
K149.27
List Price:  K378.93
You save:  K229.65
SAR146.26
List Price:  SAR371.28
You save:  SAR225.02
ZK983.97
List Price:  ZK2,497.78
You save:  ZK1,513.80
L179.97
List Price:  L456.86
You save:  L276.88
Kč916.88
List Price:  Kč2,327.48
You save:  Kč1,410.59
Ft14,325.75
List Price:  Ft36,365.37
You save:  Ft22,039.62
SEK kr417.84
List Price:  SEK kr1,060.69
You save:  SEK kr642.84
ARS$33,452.40
List Price:  ARS$84,917.64
You save:  ARS$51,465.24
Bs269.53
List Price:  Bs684.20
You save:  Bs414.66
COP$151,172.75
List Price:  COP$383,746.22
You save:  COP$232,573.46
₡19,826.59
List Price:  ₡50,329.05
You save:  ₡30,502.45
L962.92
List Price:  L2,444.34
You save:  L1,481.42
₲287,773.01
List Price:  ₲730,500.72
You save:  ₲442,727.71
$U1,475.09
List Price:  $U3,744.46
You save:  $U2,269.37
zł156.30
List Price:  zł396.77
You save:  zł240.46

What's Included

Language: English
Level: Intermediate
Skills: SQL, Query Language, SQL Queries, Programming Language
Age groups: All ages
Duration: 58 minutes
2 Videos
0
Saves
17
Views
This class has not been saved

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.