Advanced SQL for SQL Server Course
Download PDF course outline
Course DescriptionThis course is aimed at SQL Server database developers, administrators and analysts who need to take the basics of SQL Server SQL Data Manipulation Language (DML) statements to the next level. The aim of the course is to show the more advanced use of SELECT, UPDATE and DELETE statements providing delegates with the necessary knowledge and hands on experience to construct complex queries to satisfy complex information extraction requirements. The course focuses on real world business needs and shows how to make the extensive SQL Server library of functions work together to manipulate and extract data values. It also explores the many different ways of retrieving information from multiple tables from simple multi-table SELECT statements through to complex correlated sub-queries as well as introducing the many ways of analysing and processing data through methods such as grouping of data and implementing computed columns. The course will do more than just teach each topic as an isolated subject; it will show delegates how to integrate all these query methods and more to help satisfy their business information extraction needs.
|
£645 2 day course Scheduled Dates: 03 January 2012 06 February 2012 05 March 2012 02 April 2012 28 May 2012 25 June 2012 Location: PTR's Training Centre Wokingham, Berkshire. |
Course pre-requisites:
Delegates should have SQL Server SQL language experience to the level of the PTR SQL for SQL Server course.
It is aimed at data analysts and developers and focuses on providing “real world” applications of the SQL language. It will also be helpful to performance analysts who need to understand more about the SQL statements being executed behind the scenes, before moving on to query analysis and tuning skills.
During the course delegates will be introduced to a wide range of built in functions provided by SQL Server, which when carefully implemented together can facilitate a variety of tasks from extracting substrings, calculating complex arithmetic functions, generating date extractions through to the more advanced data analysis tasks such as ranking and pivoting data. There are many things that can be done in a single SELECT statement that are often implemented through less efficient programming code when you know how to make the hundreds of available functions work together.
Delegates will also be introduced to the many different types of joins, sub queries and data relationships that can be formed between records in relational databases and will work with advanced methods to enable complex and sophisticated data extractions through a combination of inner and outer joins and derived or temporary tables.
Grouping data is particularly important today as more businesses try to apply more intelligence to their marketing drawing on the patterns and performance hidden in their data. This course will cover simple grouping of data through group by clauses, through to the newer features introduced in SQL Server 2005/2008 such as grouping sets, ranking, tiling and pivot functions.
In addition to carrying out querying of data the course will draw on the advanced querying techniques to show how complex updates and deletes can be carried out such as making changes in one table based on conditions involving data in other tables.
For further details see the full course outline for this course
Synopsis
The Advanced SQL for SQL Server course is aimed at people who are reasonably comfortable with the basics of SQL queries and pulling relatively simple data sets out of SQL Server databases, but need to move on to carry out more complex data extractions, analysis or updates and deletes.It is aimed at data analysts and developers and focuses on providing “real world” applications of the SQL language. It will also be helpful to performance analysts who need to understand more about the SQL statements being executed behind the scenes, before moving on to query analysis and tuning skills.
During the course delegates will be introduced to a wide range of built in functions provided by SQL Server, which when carefully implemented together can facilitate a variety of tasks from extracting substrings, calculating complex arithmetic functions, generating date extractions through to the more advanced data analysis tasks such as ranking and pivoting data. There are many things that can be done in a single SELECT statement that are often implemented through less efficient programming code when you know how to make the hundreds of available functions work together.
Delegates will also be introduced to the many different types of joins, sub queries and data relationships that can be formed between records in relational databases and will work with advanced methods to enable complex and sophisticated data extractions through a combination of inner and outer joins and derived or temporary tables.
Grouping data is particularly important today as more businesses try to apply more intelligence to their marketing drawing on the patterns and performance hidden in their data. This course will cover simple grouping of data through group by clauses, through to the newer features introduced in SQL Server 2005/2008 such as grouping sets, ranking, tiling and pivot functions.
In addition to carrying out querying of data the course will draw on the advanced querying techniques to show how complex updates and deletes can be carried out such as making changes in one table based on conditions involving data in other tables.
For further details see the full course outline for this course
View full course outline and contents
Course Classification:
Technical Training Course
This is an instructor led training course taught in a classroom based environment.
Scheduled course dates
03 January 2012 to 04 January 2012
06 February 2012 to 07 February 2012
05 March 2012 to 06 March 2012
02 April 2012 to 03 April 2012
28 May 2012 to 29 May 2012
25 June 2012 to 26 June 2012
View full schedule of Generic courses
View full schedule of SQL Server 2008 courses
Print / Download PDF Version of full course schedule
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite SQL Server 2008 Training and bespoke SQL Server 2008 courses