SQL Server Management Studio 2016 Geliştirici Sürümü’nü indirin
Merhaba ve SQL Server ile ilgili bu girişe hoş geldiniz. Ve sizi bu kurstan geçireceğim. Peki, ne yapacağız. Her şeyden önce, ücretsiz bir SQL Server sürümü bulup indirip yükleyeceğiz. Böylece onunla kendi bilgisayarınızda oynayabilirsiniz. SSMS adında bir program açacağız, bu da Yönetim Hizmetleri. Ve biz bir veritabanı yaratacağız, bir masa yaratacağız, biraz veri ekleyeceğiz ve bu verileri alacağız.
Daha sonra SQL Server.T-SQL, Veri Tabanı Yönetimi veya DBA, SSIS’in tek tek bileşenlerini arayacağız, bu SQL Server Entegrasyon Servisleri, SSAS, Analiz Servisleri ve SSRS, Raporlama Servisleri. Öğrenmenize yardımcı olabilecek bazı kaynaklara göz atmak için. Bak, videolar ve uygulama testleri. Ayrıca resmi Microsoft web sitesine bakacağız. Öyleyse başlayalım.
SQL Server Management Studio 2014 Geliştirici Sürümü İndir
Bir sonraki video, Windows XP, Vista, 7 ve 8 için SQL Server 2012 Express’i yüklüyor ve ayrıca SQL Sever’in tarihi hakkında konuşuyor.
Ancak, farklı bir sürüm yüklemek isteyebilirsiniz.
Windows 10’unuz varsa ve hızlı bir sürüm yüklemek istiyorsanız, SQL Server 2014 Express’i yüklemenizi öneririz. Sadece sonraki iki videodaki talimatları izleyin, ancak “SQL Server 2012 Express” yerine “SQL Server 2014 Express” ifadesini arayın.Sql server management studio 2014 download
Her iki durumda da, lütfen sonraki iki videoyu izleyin.
Daha kapsamlı bir sürüm istiyorsanız, şimdi ücretsiz olan Geliştirici Sürümü’nü yüklemenizi tavsiye ederim (100 ABD Dolarına mal oluyordu).
Eğer Windows 8 veya 10 kullanıyorsanız, SQL Server 2016 veya 2017 Developer sürümünü kurmalısınız.
Windows 7’niz varsa, SQL Server 2014 Developer sürümünü kurmalısınız.
Geliştirici Sürümü’nü yüklemek istiyorsanız, lütfen video 22’ye atlayın; burada SQL Server 2016 Geliştirici Sürümü’nü yükleyeceğim (SQL Server 2017 çok benzer) ve daha sonra 5. derse geri döneceğim.
Now, the first thing we have to do is to download the software for SQL Server and as we are doing Microsoft certification 70-461, Querying Microsoft SQL Server 2012, it makes sense to download the 2012 version. So, while I’d love to give you a specific URL,it keeps changing.So, the best thing I can suggest you do is to open up a web browser and go to Google and type in SQL Server Express 2012 sp2.
This gives you the latest version, Service Pack 2 of SQL Server 2012. Now, you can see that the first hit here is for microsoft.com. It’s important that you download it from a Microsoft website. So, when I click on that, you’ll see that even though this is described as a server, you don’t actually need a server to download it on.
Look at the number of operating systems that you can download this in,all the way down to Windows Vista Service Pack 2 and all the way up to Windows 8.1. There are rumours that it won’t work on Windows 10 but as the full version has not been released yet as of the time of recording, I don’t know. So, let’s click Download and this gives us a dialogue box with about eight to 10 different items and we don’t need them all.
You can then ignore most of them. The only ones that you need are the ones saying SQL Express WT, that means With Tools and if you’ve got a 64-bit version of Windows you need the x64, if you’ve got a 32-bit version of Windows, you need the x86. Not sure which version of Windows you’ve got? Then open up Windows Explorer, right and click on Computer or My Computer, go to Properties and here you see 64-bit Operating system.
If you’ve got a modern computer,it’s likely to be 64 bit.If you’ve got more than four gigabytes of RAM,it’s almost certain to be 64 bit.So, find the file that you need,you can see here it’s 1.1 gigabytes and click Next.It then says it’s going to download it. If it doesn’t and I’ve tried this on multiple computers and it doesn’t download it, there’s a Click Next which takes us back to the previous dialogue box with an addition. A direct download link.
So, let’s find the WT version.64 bit and we go Click Here and it starts downloading.So, while it’s downloading,let’s just discuss the other versions that are available. First of all, the 2012 version’s not the first version of SQL Server there’s been. Without going too far back, we have an SQL Server 2000. And then five years later, 2005, and then 2008 and then every even numbered year. So, there was a release in 2012,2010 and in 2012,2014 and there’s a beta coming out in 2016.
And the name of this product, SQL Server,SQL Server, SQL Server,followed by the year each time except for one. The version that was released in 2012, no doubt for marketing purposes, they called it SQL Server 2008 Release Two or 2008R2. No idea why they did that, still confuses people today.So, we’ve got a few minutes while it downloads, so let me talk to you about the other versions of SQL Server that there are.
This web page shows that there are four,Enterprise, Standard, Business Intelligence and Express, Enterprise being the very top, very expensive. Business Intelligence is then the next version. Don’t know why it’s listed as fourth here,it’s actually the second version. It has most of the tools that Enterprise has. Standard is a lower version, it excludes some of the more high-end stuff that you need for multiple calls, multiple machines and then Express is the free version.
This, however, is missing one version and it’s a very important version. It’s called the Developer version. This gives you most of the tools that the Enterprise version gives you with just one caveat. It cannot be used for real life situations, it cannot be installed on a production server. It’s licenced for demonstration use or development learning, testing, that sort of thing. Basically it’s ideal for you. And if you find a good source,it’s not that expensive.
You can see it gives you the Business Intelligence tools,so if you are going down the SQL Server route,if you want to do exams 462, 463 and 466, 467, then my advice to you is to get the Developer edition. It’s fairly cheap, it gives you everything you need. But for now, for 461, all we need to do is look at TSQL and for that the Express version is fine. Now, make sure you instal Service Pack 2. If you just type in SQL Server 2012 Express, you may just get the Standard version without Service Pack 2 and that might not instal on your machine.
Obviously Microsoft have done some tweaking. Now, as you can see we’ve got a few minutes to go before it actually downloads, so why don’t you download it for yourself, so remember, go to Google and type in SQL Server Express 2012 sp2.
İndirin ve bir sonraki videoda görüşürüz.