COURSE SEARCH
 
   HOME > COURSES > MICROSOFT SQL SERVER 2000; INTRODUCTION TO DATABASES AND PROGRAMMING MEMBERS LOGIN 
UNLIMITED ACCESS TO OVER 575 ONLINE TRAINING COURSES FOR ONE ANNUAL PAYMENT OF ONLY $149 USD
BUY NOW
  HOME     COURSE LIBRARY     QUESTIONS & ANSWERS     CONTACT US
There are many excellent online courses. This has been hugely beneficial in my day to day work.
- Louise Nolan


Microsoft SQL Server 2000; Introduction to Databases and Programming




Course Aims
This course introduces readers to the major topics of databases and programming using Microsoft SQL Server 2000. The reader will learn about system databases, tables, data definition, creating tables, retrieving data, modifying data, indices, data integrity, views, triggers, stored procedures, programmability, distributed data and distributed transactions. Throughout the course there are practical exercises, complete with solutions, to practice what you are learning in the course.
Assumed Knowledge
As this courses is an introduction to databases and programming using Microsoft SQL Server 2000, no previous knowledge of databases or programming is assumed.
Course Audience
This course should be useful both to people that are new to SQL Server and to those who have experience with an earlier version.

This course can be found in the following categories:
Courses > Databases > SQL Server Database
Courses > Microsoft > SQL Server
Courses > Programming > Database Programming
Courses > Programming > Microsoft SQL Server

Table of Contents
MS SQL Server 2000 - Introduction
  		• What is MS SQL Server?
  		• SQL Enterprise Manager
  		• SQL Server Executive
  		• Data Modelling
  		• Types of Relationships
  		• Data Modelling Components
  		• Entity Integrity
     
    System Databases and Tables
  		• Objectives
  		• Database
  		• Database Objects
  		• Transaction Logs
  		• Database Devices
  		• System Databases
  		• System Tables
  		• User Databases
     
    Data Definition
  		• Objectives
  		• Database Devices
  		• Creating a Database Device
  		• Re-sizing a Database Device
  		• Creating and Modifying Databases
  		• Altering the size of a Database
  		• Decreasing the size of a Database
  		• Transaction Log
  		• Data Types
  		• User-defined Data Types
  		• Declarative Referential Integrity
  		• Constraints
  		• Creating Tables
  		• Identity Property
     
    MS SQL Server Lab 1 - Creating Tables
  		• Create the AUTHOR Table
  		• Create the BOOK Table
  		• Create the STUDIES Table
  		• Insert records in the AUTHOR Table
  		• Insert records in the BOOK Table
  		• Insert records in the STUDIES Table
  		• Solutions
     
    Retrieving Data
  		• Objectives
  		• Data Access
  		• Search based on conditions
  		• Range based retrieval
  		• List based retrieval
  		• Character string based retrieval
  		• Retrieval based on unknown values
  		• Handling duplicates
  		• Sorting the output
     
    Retrieving Data - Advanced Topics
  		• Objectives
  		• Group Functions
  		• Aggregate Functions
  		• Avg() Function
  		• Count() Function
  		• Count(*) Function
  		• Max() Function
  		• Min() Function
  		• Sum() Function
  		• Group By and Having Clauses
  		• Compute and Compute By
  		• Data Correlation
  		• Join
  		• Unrestricted Join
  		• Natural Joins
  		• Equi Join
  		• Self Join
  		• Outer Join
  		• Sub Queries
  		• In and Exists
  		• Restrictions on Sub Query
  		• Correlated Sub Queries
  		• Select Into
  		• Union Operator
     
    MS SQL Server Lab 2 - Retrieving Data
  		• Problems
  		• Solutions
     
    Modifying Data
  		• Objectives
  		• Updating Data in Tables
  		• Adding Rows to a Table
  		• Inserting Partial Data
  		• Inserting Rows through the Select Statement
  		• Updating Tables
  		• Update based on Data from other Tables
  		• Deleting rows
  		• Deleting data using other tables
     
    Indices
  		• Objectives
  		• Introduction to Index
  		• When to Index
  		• Rules to remember while Indexing
  		• Types of Indexes
  		• Clustered Index
  		• Non-clustered Index
  		• Unique Index
  		• Composite Index
  		• Optimiser Hints
  		• Fill Factor
  		• Sorted_data and Sorted_data_reorg
  		• DBCC Showcontig Command
     
    Data Integrity
  		• Objectives
  		• What is Integrity
  		• Types of Data Integrity
  		• Enhanced Integrity
  		• Declarative Referential Integrity
  		• Entity Integrity
  		• Domain Integrity
  		• Referential Integrity
  		• Rule
  		• Defaults
  		• Binding defaults and rules
  		• Unbinding and dropping defaults and rules
  		• Constraints
  		• Creating constraints
  		• Implementing constraints
  		• Types of constraints
  		• Primary Key Constraint
  		• Unique Constraint
  		• Foreign Key Constraint
  		• Default Constraint
  		• Check Constraint
    Views
  		• Objectives
  		• Views
  		• How to create a view
  		• Data Modification through views
  		• Restrictions
     
    MS SQL Server Lab 3 - Views
  		• Problems
  		• Solutions
     
    Triggers and Stored Procedures
  		• Objectives
  		• Enforcing Data Integrity through Triggers
  		• Stored Procedures
  		• Advantages of Stored Procedures
  		• How to create a Stored Procedure
  		• Rules to remember
  		• Using Parameters
  		• Recompile
  		• System Stored Procedures
  		• Auto Execution of a Stored Procedure
  		• Stored Procedure - Example
  		• Stored Procedure - Solution
     
    Programmability Page
  		• Objectives
  		• Overview
  		• Batches and Scripts
  		• Rules for batch creation
  		• Transaction Management
  		• Recovering Data
  		• User defined Transactions
  		• Rollback and Save Transaction
  		• Control of Flow Language
  		• Cursors
  		• How to create and use cursors
  		• When and when not to use cursors
     
    Distributed Data
  		• Specific Objective
  		• Need For Distributed Data
  		• Two-Phase Commit
  		• Prepare
  		• Commit
  		• Remote Stored Procedure
  		• Implementing Remote Stored Procedures
  		• Open Data Services
  		• Bulk Copy Program
  		• Integrity Issues
  		• Replication
  		• Tight Consistency
  		• Loose Consistency
  		• Goals of Replication
  		• Server roles in Replication
  		• Publication Server or Publisher
  		• Distribution Server or Distributor
  		• Subscription Server or Subscriber
  		• Models of Replication
  		• Central Publisher
  		• Central Publisher using remote distributor
  		• Central Subscriber
  		• Multiple Publishers of one table
     
    Distributed Transactions In Transact -SQL
  		• Specific Objectives
  		• Transact-SQL Overview
  		• Basics Of Transact-SQL
  		• Structure of Transact-SQL
  		• Distributed Transactions Architecture
  		• Resource Managers
  		• Transaction Manager
  		• Two-phase commit (2PC)
  		• Required Transact-SQL Statements
  		• Starting Distributed Transactions
  		• Remote Stored Procedure Architecture
  		• Remote Stored Procedure Protocol Optimisations
  		• Functions
  		• Rowset functions
  		• The Rowset functions - Usage
  		• Function Determinism
     
    Distributed Transactions
  		• Specific Objectives
  		• Distributed Transactions
  		• Prepare phase
  		• Commit phase
  		• Distributed Queries
  		• Distributed Queries and Distributed Transactions
  		• BEGIN DISTRIBUTED TRANSACTION
  		• Permissions
  		• COMMIT TRANSACTION
  		• Commit a nested transaction
  		• ROLLBACK TRANSACTION
  		• Cursor Locking
  		• Acquiring Locks
  		• ROLLBACK WORK
  		• SAVE TRANSACTION
  		• savepoint_name
  		• @savepoint_variable
  		• SET REMOTE_PROC_TRANSACTIONS
     
    Lab Exercise For Transact -SQL
  		• Problems
  		• Solutions
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Monday 21st May 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft