How To Generate Er Diagram Using Sql Server Management Studio?

In this article, we will answer the question of How To Generate Er Diagram Using Sql Server Management Studio.

  1. The SQL Server Management Studio program opens.
  2. Open and expand your Object Explorer panelHow To Generate Er Diagram Using Sql Server Management Studio
  3. Then, select and expand your database.
  4. Then, right-click on “Database Diagrams” under your Database and select “New Database Diagram”.how-to-generate-er-diagram-using-sql-server-management-studio-2
  5. A new window opens. We select the tables to be included in the ER Diagram.
  6. Click Add.how-to-generate-er-diagram-using-sql-server-management-studio-3
    how-to-generate-er-diagram-using-sql-server-management-studio-4
  7. We expect it to be completed.
  8. Close

how-to-generate-er-diagram-using-sql-server-management-studio-5

9. Result

 

 

Share

How To Open Bak File İn Sql Server Management Studio?

How To Open Bak File İn Sql Server Management Studio?

If you have a database already made and you intend to use it in your Microsoft SQL Server Management Studio (SSMS) program, the process is very simple: to use a file with the .bak extension. A file with a .bak extension provides a lot of convenience to the software developers. Look at the extension files you see in the photo below.

First, the Microsoft SQL Server Management Studio program opens.
Click on the “Object Explorer” panel once. You will see the command “Database” on the incoming screen. Right-click on this command.
Click on the “Restore Database” command once again. The “Select Backup Device” window appears on the screen.

how-to-open-bak-file-in-sql-server-management-studio

On the screen: Next to the “Specify the backup media and its location for your operation” command, select Backup Media type: “File” and select the “Look in this file” file and click Add.

how-to-open-bak-file-in-sql-server-management-studio-2

We see the look file that we selected in the Database section and the name of our database is marked. Before you finish the process, click OK in the box below Restore and click OK.

how-to-open-bak-file-in-sql-server-management-studio-3

Share

Sql Server Management Studio Functions

Sql Server Management Studio Functions

The next section is about functions and operators. We will see the most frequently used ones. Let’s do an overview. When we discussed the WHERE clause in the earlier lectures, we’ve already discussed logical operators AND,OR, NOT, and comparison operators listed here – equal, less than, greater than and so on.

Or the next slide we will also discuss the LIKE operator. Mathematical operators – plus, minus, multiplication,division – no surprises here.For the character data types, as we discussed before, the concatenation operator is written as two vertical bars.

Concatenation combines two values into one value. And then some functions. SQL language has many functions. Here we’ll talk about the most frequently used ones. Details on the next slides.

First, the functions for the numeric data types. The ABS function returns absolute value. For the positive numbers, it returns them as they are. For negative numbers, it removes the minus sign, so they become positive.  On this slide we have a SELECT without any form clause. This SELECT does not get rows from a table. It only returns one row, with the literals you provide. Next function is ROUND.

It returns the closest whole number. The number 2.8 is rounded up to 3. The number 2.3 is rounded down, to number 2. The number 2.5 is in the middle, by agreement it is rounded up, to number 3.  Some more functions to get whole numbers. The TRUNC function removes the fractional part. So TRUNC from 2.8 is 2, not 3 as the ROUND would do.

And two more functions – FLOOR and CEILING.

The FLOOR returns the the whole number which is less than a given value. For positive numbers, It’s the same as TRUNC. However, for the negative numbers the results are different. In this example, removing fractional part from -2.8 results in the number -2, but the closest whole number which is less of than -2.8 is -3.

What are the Microsoft SQL database functions?

A similar thing for the CEILING function. It returns a whole number larger then you a given value. For 2.8 it’s 3. And for -2.8 it’s -2. And finally, the TRUNC can do one more thing. If you give it a second argument, it can remove only part of the fractional part, up to the given number of digits. In our example, the the value 2 in the second argument means this “keep two digits after the decimal point, remove anything else”.

So we get 2.84.All right. So we learned some functions for the numeric data types.The next topic is functions for character data type. First let’s talk about LIKE operator. This operator takes a character value, and compares it with the template. In the template, there are two special symbols: percentage, and underscore.

The first one, percentage,means any number of characters, including 0 characters. And the second one, underscore, means any character, but exactly one character.

In our example, the condition is: name like ‘percentage of percentage’. It means that we search for the rows with a name which contains the word “of” surrounded by the blanks.  And the name can have any umber of characters before and after that ” of “.

In our example, we get two rows whose name matches the pattern: “Master of Puppets”, And “A Kind of Magic”. The next function is SUBSTRING. It returns as substring of a string. In the first example, we take the phrase “this is a book”, and get a substring of it, starting at position 11, with 4 characters in length.

So it gets the word “book”. In the second example, we take a substring starting at position 22. Since our string is shorter, we do not find a substring. So the result is an empty string. Notice that we did not get a NULL value in this case, we get an empty value.

The second function is POSITION. It searches for a substring inside a string. And if it finds one, then it returns the starting point – the position of a substring. In our case, the word “book” is found in the phrase “this is a book”, and it is found starting at 11th position.

If the substring is not found, as in our second example here, then the function returns 0. Again, notice that that is not NULL, it’s a zero. And finally, the CHARACTER_LENGTH. This function returns a number of characters in a given string. A few more useful functions. The function TRIM removes some characters on the left and the right of a string.

By default it removes blanks, as in the first example. But you can also provide which characters to remove, as in the second example. By default, it will remove characters both from the beginning and from the end of the string.  You can also remove characters only from the beginning, or only from the end.

To do this, you can write either the LEADING or TRAILING, as shown in the third and fourth example or this slide. And finally, the functions LOWER and UPPER.

They change the given the values either to the lower case, by a LOWER function, or to the upper case by the UPPER function. All right. So we learned some functions for the character data types. Now let’s talk about some functions for date, time and timestamps. First of all, let’s convert a character data type to the date data type.

In our example, 2018-12-31 is a character value. If we want to create a date out of it, we need to provide a format – where the year, month and day are specified in the given string.

We do this by specifying the format: year, then month, then day. In the second example, the date is provided in another layout. We specify another format here, so that’s the TO_DATE function will work correctly. Same for the TIMESTAMP data type. Here we give a format for the date and for the time. For time we have abbreviations for hours, minutes and seconds.

There are also some other formatting options. Here we cover only the most frequently used ones. The next function is TO_CHAR – it’s the other way around, get a date value, and convert it to a character data type. The first argument is the date, and the second argument says how we want the string to look like. In the first example – year, then month, and then the day. The second example is day – month – year.

Notice that in the second example, the first argument is already is the date data type, and the standard literal for the data data type is provided like this: year, then month, then day. Here we take this literal, and convert it to a character data type with a given format. Sometimes you may want to get the current date, current time and current timestamp.

These functions are provided here. And finally, one more function – EXTRACT – returns different parts of the date or time. EXTRACT year from a given date – this function returns a year of that date. Same for a month and a day. The same function is applicable to time and timestamp. There you can also extract hour, minutes and seconds. All right. So we learned some useful functions and the operators for different data types.

Share

Download Sql Server Management Studio 2016 Developer Edition

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.

 

Share