Hands-on: SQL

SQL Server 7 Overview

Three days hands-on course

Language: English

This course is only available on request!!

Get your information from an independent source

DESCRIPTION
Throughout this course, extensive hands-on exercises provide you with practical experience developing and administering SQL Server systems, including:

Creating and dropping databases

Adding declarative constraints to table definitions

Importing data from Access and ASCII text files

Retrieving data using Query Designer

Establishing security permissions

Performing backups and recovering from disasters

Replicating data with merge replication

Generating HTML files when data changes

Developing a database maintenance plan

Building a cube and dimensions with the OLAP Manager

Defining alerts and notifications

Analysing multidimensional data in a pivot table

Implementing natural language queries

WHAT YOU WILL LEARN
Work with the key components of SQL Server 7
Implement a database schema and access data with the SQL Server Enterprise Manager
Migrate data to and from SQL Server
Administer a database with wizards
Replicate data between two databases on SQL Server
Perform multidimensional data analysis using the online analytical processing (OLAP) server
Publish data on the Web
Build natural language query interfaces with Microsoft English Query

OUTLINES

How to write, compile and execute Java programs

OVERVIEW OF DATABASE CONCEPTS

Client/Server
RDBMS
Entity relationship diagramming

SQL SERVER COMPONENTS

Database engine
SQL Agent
SQL Mail
OLAP server
Replication
Data Transformation Services (DTS)

SQL SERVER EDITIONS

Desktop
Server
Enterprise
Embedded

CLIENT TOOLS

Enterprise Manager
Query Analyser
Query Designer
Wizards

Constructing a Database

ESTABLISHING THE FRAMEWORK

Defining database files
Running the Database Wizard

DESIGNING TABLES

Choosing appropriate data types
Identifying primary keys
Adding and removing columns
Applying declarative constraints

Developing Database Applications

RETRIEVING DATA

Defining queries using Query Designer
Sorting and selecting result sets
Joining tables
Aggregating data

MODIFYING DATA

Adding and deleting rows
Updating existing rows

STORING QUERY DEFINITIONS

Creating views with the Query Designer
Selecting data from a view
Building a stored procedure with wizards
Invoking stored procedures

Administering Databases

CONFIGURING SQL SERVER

User connections
Dynamic memory
Query timeout

SETTING UP SECURITY

Adding SQL Server users
Authorising access to databases
Granting and revoking permissions
Taking advantage of the Login Wizard
Assigning administrator roles

MAINTAINING THE DATABASE

Backing up and recovering databases
Database Maintenance Plan Wizard

AUTOMATING ADMINISTRATION PROCEDURES

Scheduling jobs
Responding to events using alerts
Defining operators
Reporting job success or failure with SQL Mail or net send notifications

Transferring Data

MIGRATING DATA

Importing and exporting data with DTS
Loading a table from Access

REPLICATING DATA

Replication strategies
Subscribing from a publishing server
Empowering mobile users with merge replication
Exploiting heterogeneous replication capabilities Publishing Data on the Web

WEB ASSISTANT WIZARD

Building static Web pages
Formatting HTML using templates

AUTOMATING WEB PAGE CREATION

Triggering a Web page refresh
Rebuilding Web pages on a predetermined schedule Extending SQL Server

IMPLEMENTING A DATA WAREHOUSE USING DSS

Data warehouses vs. data marts
Storing multidimensional data in the OLAP (Online Analytical Processing) server
Creating cubes using the Cube Wizard

MICROSOFT ENGLISH QUERY

Adding natural language support to applications
Defining semantic objects: domains, entities and relationships

FDDI Institute
De Regenboog 11 - 2800 Mechelen - Europe
Tel 32 15 24 50 58 - Fax 32 15 25 10 50