Getting started with SQL Server, Back to basic

Abstract

I have been working with Oracle for last two years, it’s sometimes found myself struggling with SQL server syntax and other functionalities. So I decided to brush up all my skills and blog about them so that anyone can access the learning. I hope you enjoy all the blogs as I  do writing them.

Introduction

SQL server is a Relational database management system developed by Microsoft which primary function is to store relational information and retrieving those data from the software application.

Connecting to SQL Server Management Studio

In order to start working with SQL server, we need to either install the full SQL server or install SQL server management studio in order to work with SQL server database.

Open SSMS and connect to the desired database you want to connect as shown below:

1

While connecting to SSMS you will get a popup window to enter your configuration as shown in figure 1:

  • Server Type
  • Server Name
  • Authentication

Server Type

Server type specifies the Database engine.

Server Name

Server Name specifies the database name or IpAddress eg. (local),127.0.0

Authentication

Authentication specifies the mode of Authentication Windows or SQL server Authentication. The organization uses both Windows Authentication and SQL server authentication.
Basically, in an organization, they may have more than one SQL server but talking in terms of one application it has one SQL server installed in Windows server and all the developers connect to that SQL server using client application SSMS(SQL SERVER MANAGMENT STUDIO) to query the database.
2
 SSMS doesn’t have the whole power as compared to SQL Server, so it’s just a client tool normally when I used to use SSMS I thought it looks like an SQL server only but when I went deep down I figured out it’s just a client I cannot work on all the features which SQL server is capable of doing.
Once we are connected the DB server we need to select the DB to which we want to query.  In order to execute our query we need to select the database and click on the new query as shown below:
3

Happy Learning

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.