Sort by:
Relevance |
Price
Oracle PL/SQL Stored Program Units
PPi Learning Services
Wrapping Packages Cursor Variables Using PL/SQL Records and Tables or Associative Arrays in Packages Bulk Binding and Bulk Collecting Operations Managing Dependencies Native Compilation and Compile Time Warnings The DBMS_SQL Package Native DynamicSQL...
(SQL Course in London)
£995 + VAT
Oracle PL/SQL
PPi Learning Services
Course content Program Blocks Variables and Constants Data Types * UsingSQLStatements within PL/SQL Programs GeneratingSQL... and Labelled Block Structures Scope of Variables PL/SQL Records PL/SQL Tables of Records Handling PL/SQL Tables...
(SQL Course in West Midlands)
£725 + VAT
Introduction to SQL
PPi Learning Services
Course content Introduction to Databases Functions of aDBMS Benefits of aDBMS Relational Database Structure SQLSyntax BasicSQLStatements Joining Tables Aggregate Functions Subquerie...
(SQL Course in London)
£395 + VAT
Data Warehouse Development for SQL Server 2005
Wise Ltd.
Designed to emphasise SQL Server 2005's features specific to business intelligence (BI) and data warehousing (DW... (BIDS) SQL Server Management Studio Building dimension tables Building fact tables Developing dimensions Hierarchies ETL via SQL...
(SQL Course in London)
£1,025 + VAT
SQL Server 2000: Administration
PTR Associates Ltd
Introduction to Microsoft SQL Server Exploring the Components of SQL Server Exploring the Features of Microsoft SQL Server Identifying the Default Databases and System Tables Understanding the SQL Server Architecture Administering SQL Server...
(SQL Course in Berkshire)
£1,475 + VAT
SQL Server 2005 Analysis Services
PTR Associates Ltd
for information technology (IT) professionals and developers who need to implement analysis solutions by using Microsoft SQL Server 2005 Analysis Services. Objectives: Describe how SQL Server Analysis Services can be used to implement analytical solutions...
(SQL Course in Berkshire)
£1,030 + VAT
Querying Microsoft SQL Server 2000 with Transact-SQL
PPi Learning Services
Course contentModule 1: Introduction to Transact-SQLThe following topics are covered in this module: The Transact-SQL Programming Language Types of Transact-SQL Statements Transact-SQL Syntax Elements UsingSQLServer Books Online After completing...
(SQL Course in London)
£695 + VAT
SQL Server: SQL (DML) Fundamentals
Wise Ltd.
This developer-oriented presentation uses mainly examples to elaborate on the following SQL features: Data retrieval - SELECT statement Data aggregation (e.g., AVG, COUNT(*), MAX, MIN, SUM) Joins (INNER & OUTER) Data modification - INSERT, UPDATE, DELETE...
(SQL Course in London)
£675 + VAT
Advanced SQL via DB2 EXPLAIN
Wise Ltd.
This course focuses on tuning advanced SQL via DB2 Explain facilities in terms of the following DB2 UDB features: Isolation levels Locking and concurrency Join optimisation Sequence and identity columns Common Table Expressions Recursive queries...
(SQL Course in London)
£1,025 + VAT
Oracle Advanced PL/SQL Performance Workshop
Wise Ltd.
This lab-oriented PL/SQL presentation focuses on the advanced features of Oracle's PL/SQL and SQL features; additionally... collections Table functions BULK COLLECT Cursor variables Dynamic SQL Packages PL/SQL optimisation Locking & concurrency Performance...
(SQL Course in London)
£1,275 + VAT
DB2 SQL Essentials
Wise Ltd.
This course focuses on the scope and limits of basic SQL operations such as: DB2 SQL interface options (e.g., Command Line Processor, Command Center) Overview of Data Definition Language (DDL): Create/Alter/Drop DB2 objects Data Manipulation...
(SQL Course in London)
£675 + VAT
SQL Server 2005 New Features for Developers
Wise Ltd.
Designed mainly for the IT developer, this presentation discusses, among others, the following SQL Server 2005 new features and enhancements: .NET framework Object oriented language enhancements Transact-SQL (T-SQL) XML Business Intelligence Data...
(SQL Course in London)
£375 + VAT
MS SQL Server 2000 Administration - MCDBA Exam 70-228
Enable Technology Ltd
Getting started with SQL Server 2000 SQL Server introduction SQL Server features SQL Server installation Special installation concerns Database administration Databases and capacity planning SQL Server organization and data storage Database...
(SQL Course in West Midlands)
£995 VAT inc.
Microsoft SQL Server 2005 Solutions MCITP 70-441
We Teach You
Microsoft SQL Server 2005 Solutions MCITP 70-441n This series provides extensive practice for the Microsoft SQL Server 2005 Solutions MCITP 70-441 exam. Questions are presented in the same style and cover the same topics as the actual exam. Students...
£50 + VAT
SQL Server Performance & Tuning
PTR Associates Ltd
administrators with a good understanding of SQL Server Architecture and Query Performance so that applications and their supporting..., monitor and tune a SQL Server application for either a OLTP or data warehousing environment. Everything from Operating System...
(SQL Course in Berkshire)
£1,350 + VAT
Oracle PL/SQL
Enable Technology Ltd
Generating an Error Triggers on Views System Triggers Maintaining Triggers PL/SQL Variables and Datatypes Declaring Variables... into a Variable PL/SQL Syntax and Logic PL/SQL Blocks and Programs Conditional Statements IF/THEN Conditional Statements CASE...
(SQL Course in West Midlands)
£950 VAT inc.
Querying MS SQL Server with Transact-SQL
Enable Technology Ltd
Exploring Transact-SQL An Overview of SQL Server and Transact-SQL Programming in Transact-SQL Querying Data Using the SELECT... Full-text Indexes Programming T-SQL Creating and Managing Views Implementing Stored Procedures, Triggers, and User defined Functions...
(SQL Course in West Midlands)
£675 VAT inc.
SQL Server 2000 Database Design MCSE 70-229
We Teach You
SQL Server 2000 Database Design MCSE 70-229n This series of courses serves as preparation for Microsoft Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition which is one of several electives...
£50 + VAT
SQL Server 2005 Reporting Services
PTR Associates Ltd
(IT) professionals and developers who need to implement reporting solutions by using Microsoft SQL Server 2005 Reporting Services. Objectives: Describe SQL Server Reporting Services and its components. Create a Reporting Services report. Enhance a Reporting...
(SQL Course in Berkshire)
£1,030 + VAT