Download and Install SQL Server Express 2017

5 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.33
List Price:  €91.90
You save:  €27.57
£55.09
List Price:  £78.70
You save:  £23.61
CA$95.29
List Price:  CA$136.14
You save:  CA$40.84
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.62
List Price:  CHF 90.89
You save:  CHF 27.27
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,195.22
List Price:  ৳11,707.96
You save:  ৳3,512.74
₹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,536.99
List Price:  ฿3,624.43
You save:  ฿1,087.43
₺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,265.02
List Price:  R1,807.25
You save:  R542.23
Лв125.89
List Price:  Лв179.86
You save:  Лв53.96
₩94,793.75
List Price:  ₩135,425.45
You save:  ₩40,631.70
₪259.28
List Price:  ₪370.41
You save:  ₪111.13
₱4,039.50
List Price:  ₱5,770.97
You save:  ₱1,731.46
¥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
P948.27
List Price:  P1,354.73
You save:  P406.46
KSh9,168.69
List Price:  KSh13,098.69
You save:  KSh3,930
E£3,283.23
List Price:  E£4,690.53
You save:  E£1,407.30
ብር4,009.02
List Price:  ብር5,727.42
You save:  ብር1,718.40
Kz59,310.71
List Price:  Kz84,733.22
You save:  Kz25,422.51
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,404.82
List Price:  DA13,436.03
You save:  DA4,031.21
FJ$155.95
List Price:  FJ$222.79
You save:  FJ$66.84
Q543.74
List Price:  Q776.81
You save:  Q233.06
GY$14,641.89
List Price:  GY$20,917.88
You save:  GY$6,275.99
ISK kr9,678.91
List Price:  ISK kr13,827.61
You save:  ISK kr4,148.70
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$562.43
List Price:  MOP$803.51
You save:  MOP$241.07
N$1,273.79
List Price:  N$1,819.78
You save:  N$545.99
C$2,572.13
List Price:  C$3,674.63
You save:  C$1,102.50
रु9,330.17
List Price:  रु13,329.38
You save:  रु3,999.21
S/260
List Price:  S/371.45
You save:  S/111.44
K271.59
List Price:  K388.01
You save:  K116.41
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,925.85
List Price:  Ft35,609.88
You save:  Ft10,684.03
SEK kr750.08
List Price:  SEK kr1,071.59
You save:  SEK kr321.50
ARS$62,063.63
List Price:  ARS$88,666.13
You save:  ARS$26,602.50
Bs483.56
List Price:  Bs690.83
You save:  Bs207.27
COP$266,463.69
List Price:  COP$380,678.73
You save:  COP$114,215.04
₡35,817.30
List Price:  ₡51,169.76
You save:  ₡15,352.46
L1,723.87
List Price:  L2,462.78
You save:  L738.91
₲524,369.02
List Price:  ₲749,130.70
You save:  ₲224,761.68
$U2,697.33
List Price:  $U3,853.49
You save:  $U1,156.16
zł274.39
List Price:  zł392.01
You save:  zł117.61
Already have an account? Log In

Transcript

Welcome to the first video in this course introduction to SQL Server 2017. And today we'll be looking at downloading and installing this bit of software. Now, a database is pretty much a logical collection of related data. And that's it in a nutshell, if you have prior experience with databases, it probably came with Microsoft Access, or my SQL. And you just want to extend your knowledge beyond that. And even if you have no prior knowledge of databases, this is an excellent course to get you up to speed with what databases are capable of what preparation needs to go in place, and how you can go about starting your journey towards becoming a database administrator or just manipulating data in databases all together.

As I said before, we'll be exploring all of these concepts using Microsoft SQL Server 2017. And I already have it up on my screen the page for download, so I'm have included the URL, as outlined here in the class notes. And this would get you to downloading the Microsoft SQL Server 2017 experts database engine. And the short description is that it's a powerful and reliable database management system that allows you to build lightweight websites and desktop applications. So this is pretty good, pretty decent. It's a decent starting place.

If you don't have that high spec high end machine, you just have a regular machine, you just want to get started, this is an excellent option. There are other additions that you would probably see in your research, but if you follow this link, it will cut through all of that noise and all the other editions and we can get started with Express. So you can go ahead and click that download and initially initiate that download procedure. And then another bit of software that we're interested in is the SQL Server Management Studio. Now the Management Studio will be your gateway into actually interacting with the database interrogating the data, and writing what we call queries in a language called SQL. We'll get into all of those things in due time.

But for now, you can follow this URL. Once again, it's in the class notes. And we can just click this download button to initialize this download, which may take a while it's a pretty big file. So as soon as that download is done, we'll reconvene and then we'll walk through that installation process. Hey guys, welcome back. Now that our downloads are finished, we'll start by installing our SQL Express engine.

So we just click on that installation file, click Run, and then we will be greeted with this installation screen. We can click basic custom would allow you to select certain features. At this stage. We don't need to be doing that we can just go with basic we can go ahead and agree to the terms and conditions You can read it through if you wish. If you have other ideas, then you may want to change this directory. Otherwise, you might as well use as a default.

And you can see here that I've six gigabytes, we only really need 300 megabytes. So I'm just going to go ahead and click Install. And this may take a while. So we will reconvene once this is finished. Okay, so at the end of that installation procedure, you'll see that you were, you know, successful in doing this installation, and then they give you some information, they give you a connection string. So if you wanted to develop an application on top of this database, then you would probably want to pay attention to this part.

Well, that's not really necessary right now and they just give you the paths for the log files and other essential bits of the application. Another essential part of this installation process, as mentioned before, is the install the SQL Management Server studio. Then this Express Edition installation, they will actually give you an option to say install ssms. And this will really just bring up your browser to navigate to, well, I figured this page so the link to this page is already included in the class notes and hear from here you can get a direct download to the Management Studio. So if you didn't do it before, you may just follow this link and get that file. I already have it downloaded here, so I'll just initiate this installation.

All of this will launch the installer and they really just give you one button to click which is installed Of course you can change this location if you have other ideas for the path. Otherwise, you may leave it as the as the default and just click Install. So this may also take a while so we will reconvene at the end of this process. Okay, So our installation is finished and all we have to do is restarts to continue so we can just do that quickly. And we In the next video we'll start looking at how we start piecing everything together what a database is, and why learning this skill is so important. Stay tuned.

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.