SQL Server 2000 Training UK- Applications ProgrammingObjectives |
Please click here for a full list of our latest SQL Server 2005 training courses
Duration
5 Days
What You Will Learn
1. Create database schemas with robust integrity using constraints,
calculated columns, views & triggers.
2. Write efficient queries and build the best indexes to optimise them.
3. To choose the right compilation strategies for your server-side code.
4. Write robust transaction processing code with proper error handling.
5. Build powerful and Client-side apps rapidly and with ADO programming.
6. Use DTS packages to build cubes in Analysis Services data warehouses
Hands On Exercises
The exercises during the course combine to create a database application with a rapidly
designed client front-end, incorporating the following:
1. Robust schema creation using both GUI and TSQL with constraints and triggers.
2. Writing and optimising advanced queries.
3. Implementing a testable indexing strategy.
4. Transactions with proper error handling
5. Write procs & UDFs with server-side cursors.
6. Do RAD with Access 2000 and ADP files…
7. ..or use more power and control with VB/ADO.
8. Write admin tools with DMO and DTS Objects.
9. Create web front-end using FrontPage and XML.
10. Start to use Analysis Services to build cubes.
Course Content
Course content has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus, or if you have a technical query email .
Who Should Attend
Professionals who need to learn to build database applications which can take
advantage of powerful server-side features that Microsoft SQL Server 2000 provides.
Pre Requisite Skills
Programming skills gained in any language. VBA would be a distinct advantage.
Relational Database Overview
SQL Server Evolution
The 2000 Release & it's new features
How is data organised in SQL Server & NT
Creating Databases
Using File groups to Position Objects
Shrinking databases.
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
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
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
The Uses of Views
Using Calculated Columns
Creating views
Indexed Views
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'
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
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
Basic Trigger assumptions and syntax
Uses for triggers
AFTER triggers and INSTEAD OF triggers
Nested Triggers
Changing the order of trigger execution
Disabling Triggers
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
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
What is OLE-DB?
The ActiveX Data Object Model
Connection Management
ADO Resultsets
ADO Commands
DAO and Jet
RDO.
Using Microsoft Access 2000 and Front Page 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
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
Associated Courses
SQL Server 2005 Applications Development
training course
SQL Server 2005
Database Administration Training Course
SQL Server
2005 Comprehensive Upgrade Training Course for existing SQL Server 2000 / Oracle
/ MySQL users
SQL Server
2005 Business Intelligence Training Course: SSAS & SSIS Analysis and Integration
Services Training Course
Advanced
SQL Server Analysis Services Training Course
SQL Server
2005 Business Intelligence Training Course: SSRS Reporting Services Training
Course
SQL Server 2000
Applications Development training
SQL Server 2000 Database Administration
SQL
Server Performance Tuning
SQL
Server OLAP, DTS & Cubes Training
SQL Design and Information
Retrieval
|
|
|