• No results found

SQL Server Introduction to SQL Server SQL Server 2005 basic tools. SQL Server Configuration Manager. SQL Server services management

N/A
N/A
Protected

Academic year: 2021

Share "SQL Server Introduction to SQL Server SQL Server 2005 basic tools. SQL Server Configuration Manager. SQL Server services management"

Copied!
11
0
0

Loading.... (view fulltext now)

Full text

(1)

Introduction to SQL Server 2005 - 1 Riccardo Dutto, Paolo Garza Politecnico di Torino

SQL Server 2005

Introduction to SQL Server 2005

Database and data mining group, Politecnico di Torino

SQL Server 2005 basic tools

• SQL Server Configuration Manager

– SQL Server services management

• Start, Stop, Restart, ecc..

– Network protocol configuration

• SQL Server Management Studio

– OLAP and OLTP server management

– Database creation and management

– SQL query execution

– Query execution plan analysis

(2)

Introduction to SQL Server 2005 - 3 Riccardo Dutto, Paolo Garza Politecnico di Torino

• SQL Server Business Intelligence

Development Studio

– Integration Services Project

• ETL processing

– Analysis Services Project

• OLAP analysis

• Data mining

– Report Server Project

• Report creation

SQL Server 2005 basic tools

Introduction to SQL Server 2005 - 4

Database and data mining group, Politecnico di Torino

Riccardo Dutto, Paolo Garza

SQL Server data warehousing

Operational data

sources

– Relational DBs

– Excel spreadsheets

– …

Data warehouse

– Staging Area

– Cubes

Report

SQL Server 2005

Analisys services

Integration services

Report Server

(3)

Introduction to SQL Server 2005 - 6 Riccardo Dutto, Paolo Garza Politecnico di Torino

SQL Server

Configuration Manager

Database and data mining group, Politecnico di Torino

• SQL Server 2005 user interface for

managing services

– Start, Stop, ..

• Network protocol configuration

SQL Server Configuration Manager

(4)

Introduction to SQL Server 2005 - 8 Riccardo Dutto, Paolo Garza Politecnico di Torino

Introduction to SQL Server 2005 - 9

Database and data mining group, Politecnico di Torino

Riccardo Dutto, Paolo Garza

SQL Server

Management Studio

(5)

Introduction to SQL Server 2005 - 10 Riccardo Dutto, Paolo Garza Politecnico di Torino

Connecting to SQL Server

• Run SQL Server Management Studio

• Select the service or database engine to

connect to

– Database engine

• Relational database (OLTP)

– Analysis services

• OLAP server

Database and data mining group, Politecnico di Torino

• Scegliere il servizio al quale ci si vuole

connettere

(6)

Introduction to SQL Server 2005 - 12 Riccardo Dutto, Paolo Garza Politecnico di Torino

Connecting to SQL Server (2)

• Write the name of the server to connect to

• Authenticate by means of one of the

following methods

– Windows user authentication

– Username/password authentication

• Managed by an internal SQL Server module

Introduction to SQL Server 2005 - 13

Database and data mining group, Politecnico di Torino

Riccardo Dutto, Paolo Garza

(7)

Introduction to SQL Server 2005 - 14 Riccardo Dutto, Paolo Garza Politecnico di Torino

Database and data mining group, Politecnico di Torino

Creating a new database

• From “Databases” choose

– “New Database”

• Choose a name for the new database

• Optional

– Change the settings for the data file and the

log file

• Autogrowth, …

– Change the general database options

• Auto create statistics, …

(8)

Introduction to SQL Server 2005 - 16 Riccardo Dutto, Paolo Garza Politecnico di Torino

Introduction to SQL Server 2005 - 17

Database and data mining group, Politecnico di Torino

Riccardo Dutto, Paolo Garza

(9)

Introduction to SQL Server 2005 - 18 Riccardo Dutto, Paolo Garza Politecnico di Torino

Creating a new database (2)

• After creating the new database you can

– Set the authorizations for the system users

– Create Tables

– Create Views

– Create Trigger

– …

Database and data mining group, Politecnico di Torino

Creating tables

• You can create new tables using

– The grafic wizard (similar to Access)

• Choose the name of the fields

• Set the type of the fields

• Set possible constraints (“allow nulls”)

• Define the primary key

• Define possible foreign keys

– A SQL script

• Allows batch processing

(10)

Introduction to SQL Server 2005 - 20 Riccardo Dutto, Paolo Garza Politecnico di Torino

Introduction to SQL Server 2005 - 21

Database and data mining group, Politecnico di Torino

Riccardo Dutto, Paolo Garza

Executing SQL statements

• Choose the database

• Use the “New Query” command

• Edit the SQL statement

• Parse the statement for errors

• Execute the SQL statement

(11)

Introduction to SQL Server 2005 - 22 Riccardo Dutto, Paolo Garza Politecnico di Torino

Esecuzione di comandi SQL (2)

Executing the SQL

statement Parse the statement for

errors

Query execution plan

References

Related documents

This module explains how to plan for and install SQL Server 2005, how to manage a SQL Server 2005 installation, and how to use the SQL Server 2005 administrative

It includes the core database features of the SQL Server product line, and is easily upgradeable to SQL Server 2005 Standard Edition or SQL Server 2005 Enterprise Edition. SQL

Install Quest SQL Optimizer for SQL Server Upgrade Quest SQL Optimizer for SQL Server Uninstall Quest SQL Optimizer for SQL Server Register Quest SQL Optimizer for SQL Server..

• SQL Server Reporting Services • SQL Server Data Warehousing • SQL Server Database Backups • SQL Server Performance • SQL Server Replication • Entity Framework •

The configuration of Microsoft SQL Server takes a little time, for this application we used ‘Microsoft SQL Server Management Studio Express’ with SQL Server Configuration Manager

SQL Server Configuration Configuration parameters SQL Server Configuration Parameters mssqlconfig.scp SQL Server Objects Database configuration SQL Server Database

To launch the Configuration Manager, click Windows Start  (All) Programs  Microsoft SQL Server 2005  Configuration Tools  SQL Server Configuration Manager.. The Configuration

This module explains how to plan for and install SQL Server 2005, how to manage a SQL Server 2005 installation, and how to use the SQL Server 2005 administrative