Layout Table~~~~3402~3402~~

3 Sessions - 9 Hours of Interactive Training~
LearnKey's SQL Server 2000 for Developers Part 1 training course 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 training 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. .~~~3402~3403~~

Course Outline Table~~~~3402~3404~~

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~~~3402~3405~~

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
~~~3402~3406~~

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~~~3402~3407~~

Ordering~~~~3402~3408~~

SQL Server 2000 For Developers Part 1 Training Course by LearnKey~Per Seat Licencing Available

Call 01223 894 136 for quotes for MULTIPLE USERS and Training Centre/Bootcamp & Education Solutions!~~PER USER%3A CD Course|410588|PER USER%3A ONLINE Course|!78799|LIBRARY LICENCE%3A CD Course|410585|~3402~3409~sql server 2000~