Introduction to sql server
This presentation is the property of its rightful owner.
Sponsored Links
1 / 5

Introduction to sql server PowerPoint PPT Presentation


  • 135 Views
  • Uploaded on
  • Presentation posted in: General

Introduction to sql server. G. Green. Agenda. SQL Server Background SQL Server Architecture Overview Accessing SQL Server. What is sql server?. Database Management System RDBMS XML *OLAP Services Query Full Text Search *BI Integration Analysis Reporting Development Tools

Download Presentation

Introduction to sql server

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Introduction to sql server

Introduction to sql server

G. Green


Agenda

Agenda

  • SQL Server Background

  • SQL Server Architecture Overview

  • Accessing SQL Server


What is sql server

What is sql server?

  • Database Management System

    • RDBMS

    • XML

    • *OLAP

  • Services

    • Query

    • Full Text Search

    • *BI

      • Integration

      • Analysis

      • Reporting

  • Development Tools

    • SQLCMD

    • SQL Server Management Studio (SSMS)

    • *SQL Server Data Tools (SSDT)

    • Visual Studio


Sql server instance architecture

Sql server Instance Architecture

CLIENT

SERVER

Memory Pool

System info

Data pages

Log info

Exec Plan Info

Relational

Engine

User/

Client

Open Data

Services

Client/Server

Net Libraries

Connection info

OLE DB

Storage Engine

OLE DB for

SQLServer

OLE DB for

Oracle

Local SQL Server Database

System Databases

User Databases

msdb

mis4340

master

sales

Remote

SQLServer

Oracle

Server

temp

model

alumni


Accessing sql server

Accessing sql server

  • SQL Server 2012 Express Edition

  • Local copy on your own computer

    • See Class Resources webpage for instructions and copies of tables used in class

  • Server from lab/classroom computers

    • HSB-MIS-SQL database server

    • Log in with your bearID (e.g., gina_green)


  • Login