Your shopping cart is empty.

Learn Microsoft SQL Server 7.0 By Jose Ramalho

Rs. 449.00

Author: Jose Ramalho

Features:

  • Language: English
  • Binding: Paperback
  • Publisher: BPB Publications
  • ISBN: 8176561754
  • Edition: 2000
  • Pages: 560
  • Dimension: 24 X 18.5 X 2.5 cm

Description:

  • Create databases, tables, indexes, views, stored procedures, triggers, and database diagrams.
  • Run queries directly in the database with the query analyzer.
  • Duplicate and distribute data through merge and transactional replications.
  • Create data warehouses using the OLAP Manager, and learn about the features of this tool.
  • Transform data using Data Transformation Services.
  • Learn Proper backup and restoration procedures.

 Table Of Contents:

Introduction

Chapter 1 : SQL Server 7.0 Overview

Chapter 2 : Creating a Database

Chapter 3 : Tables

Chapter 4 : Database Diagrams

Chapter 5 : Query Analyzer

Chapter 6 : SQL Basics

Chapter 7 : Indexes

Chapter 8 : Views

Chapter 9 : Stored Procedures

Chapter 10 : Triggers

Chapter 11 : Replication

Chapter 12 : Merge Replication

Chapter 13 : Data Warehousing and OLAP

Chapter 14 : OLAP Manager Practical Example

Chapter 15 : Data Transformation Services

Chapter 16 : DTS Practical Example

Chapter 17 : Tools

Chapter 18 : Backing Up and Restoring