|
|
Overview
In this course, students will compose SQL queries to retrieve desired information from a database.
... |
| Course type: |
Full Time delivered as classroom based |
| Guide price: |
£350.00 |
|
|
|
|
Overview
In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process.
... |
| Course type: |
Full Time delivered as classroom based |
| Guide price: |
£350.00 |
|
|
|
|
Overview
This course is aimed at SQL Server database developers, administrators and analysts who need a little bit more than SQL can do alone. SQL Server provides a powerful scripting language, Transact SQL, which enables developers to extend the capabilities of the SQL language. Using Transact SQL (TSQL) powerful scripts, stored procedures, functions and triggers can be produced to enable extr... |
| Course type: |
Full Time delivered as classroom based |
| Guide price: |
£895.00 |
|
|
|
|
Overview
The objective of this course is to provide a comprehensive understanding of the advanced use of structured query language (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL.
The course will provide delegates with the ability to carry out advanced, complex Data Manipulation Statements (DML) to query on, and change the contents of a relational database and extends... |
| Course type: |
Full Time delivered as classroom based |
| Guide price: |
£1250.00 |
|
|
|
|
Overview
The objective of this course is to provide a comprehensive understanding of the advanced use of structured query language (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL.
The course will provide delegates with the ability to carry out advanced, complex Data Manipulation Statements (DML) to query on, and change the contents of a relational database and extends... |
| Course type: |
Full Time delivered as classroom based |
| Guide price: |
£1250.00 |
|
|
|
|
Overview
The objective of this course is to provide a comprehensive understanding of the structured query language (SQL) for Microsoft SQL Server users.
The course will provide delegates with the ability to use the Data Manipulation Statements (SQL) to query on, and change the contents of a relational database, using Microsoft SQL Server utilities.
This training may be available o... |
| Course type: |
Full Time delivered as classroom based |
| Guide price: |
£645.00 |
|
|
|
|
Overview
With the current explosion of data in today's enterprise environment, traditional methods of querying and reporting on information are no longer sufficient. This course provides the knowledge and skills to analyse and discover trends in your data warehouse. You learn to create On-Line Analytical Processing (OLAP) cubes using Business Intelligence tools and leverage the Analysis Service... |
| Course type: |
Full Time delivered as classroom based |
| Guide price: |
£2890.00 |
|
|
|
|
Overview
High-availability database systems offer timely access to business-critical data. Microsoft SQL Server offers powerful features to maintain these vital systems. In this course, you acquire an in-depth knowledge of SQL Server's essential tools-the storage engine, lock manager and query optimiser. Through hands-on exercises, you gain the skills to implement a high-performance SQL Server ... |
| Course type: |
Full Time delivered as classroom based |
| Guide price: |
£3190.00 |
|
|
|
|
Overview
Walking around any end user or technical department, auditors always find developments under way using the Microsoft SQL Server 7 environment. But while we continue to audit central IT systems, this platform infrequently appears as a target of evaluation in audit plans. Even though continuity of service to the organisation within departments could well depend on this product. Here is a... |
| Course type: |
Full Time delivered as classroom based |
| Guide price: |
£645.00 |
|
|
|
|
Overview
Transact-SQL is integral to the power of SQL Server. Transact-SQL features allow developers to create scalable, distributed applications to meet the demanding requirements of modern organisations. This course provides extensive experience creating stored procedures and triggers, and developing T-SQL that utilises SQL Server to the fullest.
This training may be available onsite; ... |
| Course type: |
Full Time delivered as classroom based |
| Guide price: |
£2890.00 |
|
|