Ch 1 'Installing and configuring SQL Server 2005

1
Ch 1 .Installing and configuring SQL Server 2005
2
What is a Record?

• A single row of data

3
What is a Table?

• Multiple rows of data or
• A collection of records

4
What is a database?

• Collection of tables

5
Relational Database

• A database allow relationship between its tables

6
What is MS SQL Server

• Relational database
• management system / Tools
• View, Query parts of data using SQL (Structured
  Query Language)
• Add/delete data
• Back up data
• Import / Export data / Replication
• Monitor data
• Automate/scheduling

7
Install SQL Server Software

• Copy installation file from network drive
  X\INSTALLER\SQL 2005
• Double click on file

8
Install SQL Server Software

• Check I accept the licensing term and
  conditions
• Click next

9
Install SQL Server Software

• Click next

10
Install SQL Server Software

• Click next

11
Install SQL Server Software

• Click next

12
Install SQL Server Software

• Type in your name and Click next

13
Install SQL Server Software

• Check the following services and click next

14
Install SQL Server Software

• Choose Default Instance and click next

15
Install SQL Server Software

• Click next

16
Install SQL Server Software

• Select User the built-in System Account, select
  all services, and click next

17
Install SQL Server Software

• Select Windows Authentication Mode, and click
  next

18
Install SQL Server Software

• Click next

19
Install SQL Server Software

• Click next

20
Install SQL Server Software

• Click Install

21
Install SQL Server Software

• Click Next

22
Install SQL Server Software

• Congraduations! We are done! Click Finish to
  finish setup.

23
Verify SQL Server Installation

• To verify installation, Click start-gtMicrosoft
  SQL Server 2005-gtConfiguration Tools-gtSQL
  Server Configuration Manager

24
Verify SQL Server Installation

• If your Server is listed and Running,
  Installation is successful.

25
DreamSpark

• Due to time constraints, we will not be able to
  go through all exercises in the book. Therefore,
  it is recommanded for you to have a copy of SQL
  2005 at home and practice on your own time. If
  you need a free copy of it, see below.
• For educational/learning purposes, Microsoft is
  offering free copies of MS SQL 2005 to selected
  institution
• To download a free copy, please go to
  https//downloads.channel8.msdn.com/Products/SQL_S
  erver_Dev.aspx
• Sign in/ Create an account, and install a copy on
  your home computer.

26
DreamSpark

• Click sign In

27
DreamSpark

• Click Continue

28
DreamSpark

• Fill out your information and each steps until
  its complete.

29
DreamSpark

• At the end of the registration, you will receive
  a confirmation email. Confirm your email by
  click on the link.
• Go back to DreamSpark website, sign in, and click
  on verify.

30
DreamSpark

• Select UCR and continue

31
DreamSpark

• Enter your NetID and password to login and
  download your free copy of software.