SQL Server 2000 For Developers Part 1

SQL Server 2000 For Developers Part 1

3 Sessions –
9 Hours of Interactive Training

LearnKey's SQL Server 2000 for Developers Part 1 provides an essential understanding of the development and support concepts surrounding this powerful software. Experts Mary Chipman and Andy Baron show you the essentials of SQL Server 2000 including installation and configuration, relational database design, and how to work with data to get results. At the conclusion of this course, you’ll have a solid foundation for establishing and maintaining efficient databases.

Prerequisites: Experience with any database product or some developer or programming experience.

Benefits

Increase your earning potential with technical mastery and proficiency.

Enhance employment opportunities with in-demand technical knowledge.

LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.

Also Available:
· Study Guide

About The Author

Mary Chipman and Andy Baron are Senior Consultants with MCW Technologies, and both are Microsoft MVPs for 5 years running. Specializing in database application development and writing about SQL Server, Visual Basic, the .NET framework, and related technologies, they are co-authors of the Microsoft Access Developer's Guide to SQL Server, published by Sams, and Mary co-authored SQL Server 7.0 in Record Time, published by Sybex. Their combination of experience brings a unique programming and management view to the concepts of SQL development.

Session 1

Section A: Introduction
· Course Introduction

Section B: SQL Server Edition & Graphic Tools
· SQL 2000 Editions
· Pricing & Licensing
· SQL Tools Overview
· Enterprise Manager
· Select Wizard

Section C: Enterprise Manager
· Databases
· Data Transformation Services
· Management Options
· Replication & Security
· Support Services
· Books Online

Section D: Installing SQL Server
· Multiple Instance
· Named Instances
· Installing Requirements
· Backward Compatibility
· SQL Setup

Section E: Configuring SQL Server
· General Properties
· Memory
· Processor
· Security
· Connections
· Server Settings
· Database Settings
· Replication
· Active Directory
· Setting Server Options

Section F: Relational Database Design
· Overview & Terms
· Data Normalization
· First Normal Form
· Second Normal Form
· Third Normal Form

Section G: Understanding Relationships
· Diagram
· One-to-Many
· Many-to-Many
· One-to-One
· Data Integrity

Session 2

Section A: Creating a Database
· Pages
· Extents, Files & Filegroups
· Creating Database
· Configuring Database Properties
· Data Files
· Create Database
· Simple
· Full & Bulk-logged

Section B: Creating Tables & Selecting Data Types
· Creating Tables
· Character-based Data Types
· Numeric Data Types & Whole Numbers
· Numeric Data Types & Fractional Numbers
· Date Data Types
· Binary data Types
· Identifier Data Types
· The Timestamp Data Types
· The sql_variant Data Type

Section C: Refining Table Definitions
· Computed Columns
· Creating Constraints
· Default & Check Constraint
· Forcing Key Constraint
· Database Diagram
· Cascade Relationship
· Database Diagram View
· Creating Indexes

Section D: Retrieving Data with Select Queries
· Understanding Transact-SQL
· The Shark Database
· Query Analyzer
· The SELECT Statement
· The WHERE Clause
· The LIKE Operator
· The BETWEEN Operator
· Testing the Null
· Multiple Conditions with AND, OR & NOT
· Order of Precedence
· Using the IN Operator

Session 3

Section A: Sorting & Grouping Data
· Sort Possibilities
· Aggregate Grouping
· GROUP BY
· HAVING
· TOP

Section B: Joining Tables
· Cartesian Product
· Using JOIN
· Multiple JOINS
· Create View
· OUTER JOIN
· LEFT JOIN
· RIGHT JOIN
· View Builder Options
· Self JOINS

Section C: Inserting Data
· Insert a Row
· Multivalue Inserts
· SELECT INTO
· Using a Temp Table
· BLUK INSERT

Section D: Using & Deleting Data
· Update Row
· Update from Table
· Delete Rows