[go: up one dir, main page]
Scribd
Upload
70 views33 pages

CH 2 - Install and Overview of Microsoft SQL Server

This document provides an overview of installing Microsoft SQL Server and using SQL Server Management Studio (SSMS) 2014 Express Edition. It covers the installation requirements, logging into SSMS, and creating a first database. The content is aimed at students in a computing program, specifically those learning about database systems.

Uploaded by

A Garaad Osman
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
70 views33 pages

CH 2 - Install and Overview of Microsoft SQL Server

This document provides an overview of installing Microsoft SQL Server and using SQL Server Management Studio (SSMS) 2014 Express Edition. It covers the installation requirements, logging into SSMS, and creating a first database. The content is aimed at students in a computing program, specifically those learning about database systems.

Uploaded by

A Garaad Osman
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 33

DATABASE SYSTEMS II

Chapter 2

Install and Overview of Microsoft SQL Server

Amoud University
Faculty of Computing and ICT
Senior BBIT

Lecturer : Samakaab Basha


Objectives

 Installing Microsoft SQL Server.


 Overview of SSMS 2014 Express Edition.
 Login into SSMS 2014
 Overview of SQL Server Management Studio
 Create First Database
Installing Microsoft SQL Server

Microsoft SQL Server is an application used to create computer databases


for the Microsoft Windows family of server operating systems. Microsoft
SQL Server provides an environment used to generate databases that can
be accessed from workstations, the Internet, or other media such as a
personal digital assistant (PDA).

To follow our lessons, you must have access to a computer in which


Microsoft SQL Server 2012 is installed. To start, you must have a computer
that runs an appropriate operating system. If you are just learning, you can
use a computer that runs Microsoft Windows XP Professional, Microsoft
Windows Vista, Microsoft Windows 7, Microsoft Windows Server 2003,
Microsoft Windows Server 2008, or Microsoft Windows Server 2012 or
Microsoft Windows Server 2014.
Installation Done
Login into SSMS
Overview of SQL Server Management Studio

 SQL Server Management Studio (SSMS) is a software application first


launched with Microsoft SQL Server 2005 that is used for configuring,
managing, and administering all components within Microsoft SQL
Server.
Create First Database
 Creating a database inside of SQL Enterprise has its
advantages. After launching Microsoft's SQL Server
Management Studio Enterprise application, simply
right-clicking on the Databases folder of the Object
Explorer gives you the option to create a New
Database. After selecting the New Database... option,
name your database "MyDatabase" and press "OK
END

You might also like