Birmingham - Bristol - Cambridge - Coventry - Edinburgh - Glasgow - Kingston - Leeds - London - Manchester - Slough

SQL training courses and schools
SQL Programming

School: Learning Tree International Ltd.
[All Courses]

High-Performance SQL Server Databases
Course Format: Classroom
You Will Learn How To Design and implement high-performance databases for SQL Server Create indexes that optimise different types of queries Design transactions that maximise concurrency and minimise contention Interpret the data access plans produced by the query optimiser Minimise I/O by designing efficient physical data structures Analyse and cure performance problems using SQL ...
 

SQL Server Integration Services
Course Format: Classroom
You Will Learn How To Migrate and transform data using SQL Server 2005 Integration Services (SSIS) Upgrade DTS packages and perform imports and exports Assemble tasks to perform complex data migrations Enhance package functionality with scripting Extract, Transform and Load (ETL) data Integrate Business Intelligence components Course Benefits In order to improve business intel...
 

SQL Server Analysis Services
Course Format: Classroom
You Will Learn How To Leverage SQL Server Analysis Services to produce Business Intelligence solutions Create and deploy multidimensional data cubes Extend hierarchies and exploit advanced dimension relationships Slice and dice your data with advanced dimension hierarchies Make smarter business decisions with data mining techniques Implement Key Performance Indicators (KPIs) to mon...
 

SQL Programming Language
Course Format: Classroom
You Will Learn How To Write SQL code based on ANSI/ISO standards to build and maintain database structures Update database content with SQL and transaction handling Retrieve data from single or multiple tables Process data with row and aggregate functions Manipulate data with correlated and non-correlated subqueries Apply views to break down problems and enhance security Course...
 

SQL Server® Analysis Services
Course Format: Classroom
You Will Learn How To Leverage SQL Server Analysis Services to produce Business Intelligence solutions Create and deploy multidimensional data cubes Extend hierarchies and exploit advanced dimension relationships Slice and dice your data with advanced dimension hierarchies Make smarter business decisions with data mining techniques Implement Key Performance Indicators (KPIs) to mon...
 

SQL Server® Integration Services
Course Format: Classroom
You Will Learn How To Migrate and transform data using SQL Server 2005 Integration Services (SSIS) Upgrade DTS packages and perform imports and exports Assemble tasks to perform complex data migrations Enhance package functionality with scripting Extract, Transform and Load (ETL) data Integrate Business Intelligence components Course Benefits In order to improve business intel...
 

High-Performance SQL Server® Databases
Course Format: Classroom
You Will Learn How To Design and implement high-performance databases for SQL Server Create indexes that optimise different types of queries Design transactions that maximise concurrency and minimise contention Interpret the data access plans produced by the query optimiser Minimise I/O by designing efficient physical data structures Analyse and cure performance problems using SQL ...
 

SQL Queries for SQL Server®
Course Format: Classroom
You Will Learn How To Develop complex and robust SQL queries for SQL Server 2005 and SQL Server 2000 Query multiple tables with inner joins, outer joins and self joins Transform data with built-in functions Summarise data using aggregation and grouping Execute analytic functions to calculate ranks Build simple and correlated subqueries Course Benefits Microsoft’s Transact...
 

SQL Server Transact-SQL® Programming
Course Format: Classroom
You Will Learn How To Develop database applications for SQL Server databases with Transact-SQL Create modular code using stored procedures Develop reusable code with scalar and table valued functions Handle Transact-SQL runtime errors to create robust software Audit data changes using AFTER triggers Manage concurrency using transactions and locking options Course Benefits Tran...
 

SQL Server® Server-Side Programming with .NET and XML
Course Format: Classroom
You Will Learn How To Develop server-side database programs for SQL Server databases Retrieve XML data with XQuery Build scalable message-based applications with Service Broker Access data using LINQ Create functions and stored procedures in .NET CLR Persist objects in the database with ADO.NET Entity Framework Course Benefits SQL Server 2005 and 2008 offer development feature...
 

Page(s):- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 ... [ Popular Topics ] [ Schools Only ]