In this section it will be discussing about the following topics: we’ll briefly discuss what a database is. Is how to install Microsoft SQL Server specifically the developer version what the SQL Server Management Studio or SSMS environment looks like. We’ll see how to use some of important shortcuts.
In a SSMS, how to create a data is using SSMS shortcuts functionality as well as writing SQL Also discuss how to create a sample database that is used in this course. Which came from a CIA or a Central Intelligence Agency. We will see how to use drag and drop functionality in SSMS, how to select a table without even writing a query, how to change it database context in a multi database environment. We’ll see how to create as well as why we need comments in SQL.
What is a database?
This article we’ll discuss what a database is. A database is an organized collection of data that is used for the purposes of modeling some type of organization or organization on process.What we can understand from this is as long as there is an organized collection of data that we use to model some sort of an organization or a company different entities in that organization and different relationships we can be able to assume there is a database.
And a software package that we can use to manage these organized set of data or database is called a DBMS means or database management system. Relational databases such as SQL Server, MySQL, PostgreSQL and Oracle they use SQL as a language in order to be able to create different objects such as tables, views and stored procedures as well as to extract some data insert data. In this course we’ll be using SQL Serve as a data management system and we’ll discuss different aspects of this SQL language in the coming sections and movies.
What is the difference between different Editions of SQL Server?
In the previous article we’ve discussed different editions of course so we also decided to use a developer edition as it’s free and it also comes with all features of Enterprise Edition. In this article we’ll see how to download and install a developer version of SQL Server.
To do this go to your favorite web browser and type SQL Server Developer Edition latest installer. Once you’re in this page go ahead and download a developer edition save or run it. We have three basic options for this dialog box. A basic, custom and downloaded media. Let’s go with customer since we don’t need everything you can’t accept the default location where your extract file will get expanded.
Click install. This is going to take some time. Once it’s finished downloading it will extract the files to install. go to “Installation” this will be installing a sequence of standalone version. And add feature next. The installer will check if there is any installation rules are violated, you might see some warning like. The firewall is not disabled. It’s normal ok, so you can ignore these warning message click next.
We will be installing a new SQL Server and go ahead and select perform news SQL Server 2017 installation and click next. It is going to ask you to add a product key. A developer edition is free. Just simply select a free developer edition. Click next. You have to accept the license terms. Next, it’s going to ask you to select features to installed. Simply select a database engine and click next. You will have an option to pick a default instance which is Or you can give it your name. It is common to use a default instance in the next dialog.
It’s going to ask you to do a server configuration in a normal production environment. You’re going to have to create a series accounting and use those services accounts you but for us. You can accept the default values and click next. You can pick your authentication mode. You can leave it to a default. Windows authentication select select a mixed mode authentication.
Which is nothing but SQL Server authentication plus a Windows authentication for us to see how how the SQL authentication works let us select that one and give it a strong password that you will not forget. Specify a SQL Server administrator in a normal production environment. You’ll specify a services account here but for us add your account by clicking this button so that you will have a full admin privilege in that SQL Server that you are installing.
Next, you’ll see a summary of the configuration you made previously. If you see everything is good. Click to install. This is going to take some time. We’ll come back once this is done. After completing a sequence of developer edition installation the next thing to do is Tinas still see SQL Server Management Studio which is an IDE to write any SQL statement. As well as we can be able to use the GUI. Open your favorite browser and type SQL Server Management Studio installer Go to the first Microsoft Web site.
Then if you scroll down, you will see a tool section. Download SQL Server Management Studio SSMS. Click on that, wait for the installer to finish downloading install finished downloading click run then click install, follow the on screen dialog box and finish installing sql server management studio and I’ll be back once this is done.