Northern Ireland based Beckinridge specialises in Technology, IT, Sales and Management training for the ICT, Corporate, SME and Government Sectors.

  Public Courses
General Training

  On-Site Courses
Tailored Training

  ILM Qualifications
Level 4 & 5 Awards

  Beck-Bites
Articles & Reviews

  Team Building
Activities & Events

  Why Choose Us?
Our Clients
Our Services
Quality and Expertise
Financial Support
Course Tailoring
Our Support Team
Talk To Us

Join Mailing List

 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

© Beckinridge Ltd.

Privacy Policy | Quality Policy

Site by redrhino

Beckinridge specialises in Technology, IT, Sales and Management training for the ICT, Corporate, SME and Government Sectors in Northern Ireland.
Privacy Policy | Capability, Improvement, Through Training & Development