SQL Day 1: Connecting to SQL Server using SSMS

LO 1: Connecting to SQL Server using SSMS (Sequel Server Management Studio)
LO 2: Know about SQL Server Management Studio
LO 3: Different authentication mode to connect to SQL Server


Connecting to SQL Server using SSMS (Sequel Server Management Studio): 

  •  Install SQL Server (I have installed SQL Server 2008)
  •  To Start SQL, Go to Start and here you should find folder name “Microsoft SQL Server 2008 R2” and now you will see “SQL Sever Management Studio”

  • Click on it and this will open the SSMS window. Once the window is opened, you will see a Connect to SQL pop up. This is information required by the SQL server to connect to the database.

  • SSMS and Sequel Server database are two different things. 
    • A database server typically contains all the data that is all the rows or any data base objects like triggers, store procedure, views etc and connect to that database the client tool we generally used is SSMS (Sequel Server Management Studio).
  • In a typical environment development environment database is centrally installed on one machine and developers can access the database using SSMS that installed on their respective machine.
  • Connect to Server pop up we need to specify followings
    • Server Type: Generally it’s the Database Engine. You can also connect to different services like Analysis Services (SSAS), Reporting Services (SSRS) or Integration Services (SSIS) depending on your need.
    • Server Name: If the environment is like above image then you need to specify the IP address of that machine on which the database is installed. When the database is installed on your local system then you need to specify the IP address of your machine or you can enter (local) in Server name or you can enter only ‘.’ A dot without single quotes.
    • Authentication: While installing the SQL Server if you choose Mixed Mode Authentication then you will see two options. Below is the details:
      • Windows Authentication: If you choose window authentication then you don’t need to provide the username and password because you are already given the credentials when logged into windows.
      • SQL Server Authentication: At the installation time you have specified the username and password. 
    • After providing information click on Connect. Now you should connect to SQL database installed local on that machine.


  • Here you can see all the list of databases, Server Objects, and Security details etc. 
  • To execute a query on the database you need to click on New Query at top left corner as you can see in above image.
  • This will open the query editor where you can write the query and run.
  • Before running the query you need to specify on which database you are going to run the query for that you need to select the database first.



That’s all for today. Thank You.

Comments

Post a Comment

Popular posts from this blog

SQL Day 11: Group By in SQL Server

Image
LO1: Grouping rows using Group By LO2: Filtering Groups LO3: Difference between Where and Having Clause Group By clause is used to group a selected set of rows into a set of summary rows by the values of one or more columns or expression. It is always used in conjunction with one or more aggregate functions. Let’s say we have a table tblEmployee which contains all the salary of employees including the cities. So if we need to find the maximum salary of employee we can use the MAX(Column_Name) aggregate function to find the highest salary of employees. select MAX(salary) from tblemployee In the same way, we can find the minimum salary and total salary of all the employees using different aggregate functions. select MIN(salary) as [Minimum Salary] from tblemployee select SUM(salary) as [Total Salary] from tblemployee Let’s say we have to find out the employee salary as per the different cities, to achieve this we need to use the Group B...
Keep reading

JAVA Script Executor Code to Click on an Element

Click on an Element in Selenium WebDriver Sometimes click() method does not work because two views are loaded at the same time on a page. In this case, we can use the JavascriptExecutor to get the work done. Below is code to click on an element using Javascript Executor. 1 2 3 4 5 6 7 @FindBy(id = Checkbox. financialAssistanceAccountEmailId ) public WebElement financialAssistanceAccountEmail; //Click to element JavascriptExecutor executor = (JavascriptExecutor) driver; executor. executeScript ( "arguments[0].click()" , financialAssistanceAccountEmail);
Keep reading

SQL Day 2: Creating, Altering and Dropping a Database

Image
LO1: Creating, Altering and Dropping a Database Prerequisite:   Connecting to SQL Server using SSMS After connecting to the database through SSMS first we need to create the database on which different queries will run. Let’s start with creating a Database. A SQL Server Database can be Created, Altered or Dropped in two ways: Graphically using SQL Server Management Studio or Using SQL Query Graphically using SQL Server Management Studio: Within the Object Explorer, right-click on Database folder and select the New Database. When clicked on New Database a new dialog box will open. Here you need to provide the database name and when clicking on OK, SQL Server run the query internally and will create the new database for us. When you expand the database folder then you will see the Sample database here Creating Database Using Query: We can also create the database by executing the query in the query editor. For creating a...
Keep reading