SQL Server 2000: Introduction for Beginners (4 day)

Course Overview

Microsoft's SQL Server 2000 offers ease of use and scalability, XML integration, improved data transformation and analysis services. In this hands-on course, you explore many of the SQL Server 2000 capabilities using the graphical tools provided by Microsoft. You gain a solid foundation on which to build specific SQL Server 2000 database development or administration skills.

Audience

Those interested in, or evaluating, SQL Server 2000. Familiarity with relational databases is helpful.

Skills Gained

• Utilise the key components of SQL Server 2000
• Implement a database schema with SQL Server Enterprise Manager
• Retrieve and modify data with SQL tools
• Replicate data between databases
• Query SQL Server from the Web using XML
• Migrate data from diverse sources with DTS

Course Outline

SQL Server 2000 Overview

Overview of database concepts

• Client/Server
• RDBMS
• Entity relationship diagramming

SQL Server components

• Database engine
• SQL Server Agent
• Analysis Services
• Data Transformation Services (DTS)

SQL Server editions

• Personal
• Server
• Enterprise
• Desktop Engine
• Windows CE

Client tools

• Enterprise Manager
• Query Analyzer
• Query Designer
• Wizards

Constructing a Database Schema with Enterprise Manager

Using the Create Database Wizard

• Selecting file name and locations
• Determining file size and growth parameters

Designing tables

• Choosing appropriate datatypes
• Identifying primary keys
• Adding and removing columns
• Applying declarative constraints

Developing Database Applications

Retrieving data

• Creating SQL queries
• Sorting and selecting result sets
• Joining tables
• Aggregating data
• Defining and using full-text indexes

Modifying data

• Adding and deleting rows
• Updating existing rows

Storing query definitions

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

Administering Databases

Setting up security

• Adding SQL Server logins with the Login Wizard
• Authorising access to databases
• Granting and revoking permissions
• 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

Transferring Data

Migrating data with DTS

• Importing data into SQL Server
• Upsizing Access databases
• Exporting data to text or CSV format

Replicating databases

• Replication strategies
• Subscribing to a publishing server
• Empowering mobile users with merge replication
• Resolving conflicts using priorities

Publishing Data on the Web

Web Assistant Wizard

• Building static Web pages using templates
• Triggering a Web page refresh

Streamlining Web development with XML

• Creating a Virtual Directory
• Generating XML from HTTP

Moving Beyond the Database

Analysis services

• Storing multidimensional data
• Browsing cubes in Microsoft Excel

Microsoft SQL Server 2000 Reporting Services

• Authoring and deploying reports
• Viewing reports from a Web site

SQL Server 2000: Introduction for Beginners (4 day) / SQ00-I4