Management Sales Technology training courses, Dublin Belfast Cork Ireland, Beckinridge
Management Sales Technology training courses, Dublin Belfast Cork Ireland, Beckinridge

Microsoft SQL Server 2000 Foundation

Course Code - CT-304 Duration - 5 Days

This course has been written to cover all the main aspects of building applications using Microsoft's latest database technology. The key focus is on server database design and implementation using Microsoft SQL Server 2000 but it also covers some client development, focusing on three Microsoft technologies: Access 2000's new ADP format, Visual Basic using ADO and ASP with XML.

 

The general objective of the course is to design a server-side database, implement all the tables and indexes, implement server-side validation through rules and triggers and build stored procedures to put complex parts of the application server-side. Then three different client platforms are used to build front-ends to the application: Using Access 2000, Visual Basic and FrontPage.

Who Should Attend

Developers using Microsoft SQL Server 2000

Prerequisites

Delegates should have experience in using SQL. This can be obtained by attendance on the Beckinridge course 'Programming with SQL' ('MC-104'). Previous experience in a structured programming language is also required.

Course Content

Microsoft SQL Server 2000 Overview & History

  • Relational Database Overview
  • SQL Server Evolution
  • The 2000 Release & it's new features

Data Storage & Management

  • How is data organised in SQL Server & NT
  • Creating Databases
  • Using File groups to Position Objects
  • Shrinking databases

Designing Tables with Integrity

  • Designing Tables through the Database Diagram
  • Creating Tables through Enterprise Manager and the basic CREATE TABLE syntax
  • SQL Server Data types
  • Calculated columns and user-defined data types
  • Table enforced constraints and Rules
  • The IDENTITY property
  • Setting up Referential Integrity

Transact SQL

  • Querying Microsoft SQL Server 7.0 Tables
  • Basic Transact SQL queries
  • Transact SQL built-in Functions
  • Advanced Querying tricks and techniques
  • Querying linked servers and other remote data sources
  • Full-Text Searching

Indexes

  • The query optimiser
  • Index types in SQL Server 2000
  • Creating Indexes
  • Using composite indexes
  • for index covering
  • Analysing index use and optimising SQL Server 2000 indexes
  • Using optimiser hints effectively

Making Best Use of Views

  • The Uses of Views
  • Using Calculated Columns
  • Creating views
  • Indexed Views

Transaction Programming in SQL Server

  • How data is changed in SQL Server 2000
  • Inserting, copying, changing & removing records
  • Transaction processing commands
  • Distributed Transactions
  • Locking Issues, transaction isolation levels and locking 'hints'

Programming with Transact SQL

  • The Query Analyzer as a developer's environment
  • Transact SQL Batch and script rules
  • Using Variables and control of flow statements
  • Using Global Variables
  • Using the EXEC() function
  • Error Handling
  • Using Cursors

Writing Stored Procedures & User-Defined Functions

  • SQL Server 2000 Query caching & related issues
  • Uses for Stored Procedures & User-Defined functions
  • A useful UDF
  • Compilation problems and methods
  • Stored procedures parameters
  • Returning values and updating parameters
  • Temporary procedures and AutoStart Procedures

Implementing Triggers

  • Basic Trigger assumptions and syntax
  • Uses for triggers
  • AFTER triggers and INSTEAD OF triggers
  • Nested Triggers
  • Changing the order of trigger execution
  • Disabling Triggers

Using DTS & Writing Server-Based Applications

  • DTS Overview
  • Building DTS packages with ActiveScript
  • The DTSObjects library and how to manipulate it
  • SQL Server's own library
  • DMO (Distributed Management Objects)
  • Using DMO

Fast Client-Server Development using Microsoft Access 2000

  • Rapid Application development with Microsoft Access 2000
  • Access Project Concepts
  • Upsizing from Jet to Microsoft SQL Server
  • Converting DAO to ADO
  • Building scalable solutions with MSDE

VBA Programming using ActiveX Data Objects & Other Methods

  • What is OLE-DB?
  • The ActiveX Data Object Model
  • Connection Management
  • ADO Resultsets
  • ADO Commands
  • DAO and Jet
  • RDO
  • Web-Based SQL Server Front Ends
  • Using Microsoft Access 2000 and FrontPage to build data-driven web pages
  • Building data-driven web pages using Active Server Pages
  • XML overview
  • Driving web-pages with SQL Server data using XML

Data Warehousing with Microsoft SQL Server's Analysis Services

  • Introduction to Data Warehousing and Analysis Services
  • Designing a Database for OLAP
  • Using Data Transformation Services to Populate the Warehouse
  • Using Analysis Manager to create Cubes
  • Browsing Cubes and the PivotTable Service
  • Programming Analysis Services
  • An introduction to MDX and DSO - Maintaining Data Warehouses

« Back to last page

Why Choose Us?

ILM Qualifications

Beck-Bites

Team Building

Public Schedule


© web design by redrhino

Privacy Policy