SQL Server 2008 R2: Performing Advanced Query Techniques
IT professionals who have jobs in which database administration is their main area of responsibility, or who work in environments in which databases are central to their job roles. These job roles include:
- IT generalists who work in environments in which SQL Server 2008 R2 is part of an overall solution
- IT professionals who manage systems that run SQL Server 2008 R2
- IT professionals who work with third-party applications that are built on SQL Server 2008 R2
- Developers who build applications that use SQL Server 2008 R2
The prerequisites for the exam are that candidates should have one to two years of experience using Microsoft SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server.
Transact-SQL offers advanced query techniques, such as built-in aggregate, scalar, and ranking functions, and common table expressions to manipulate the result set for a query. To manipulate the result sets and generate rollup information, such as totals, the CUBE, GROUPING SETS, and ROLLUP operators can be used with the GROUP BY statement. UNION, INTERSECT, and EXCEPT can be used to gather specific results in a query. Transact-SQL also provides features that manage international concerns with regards to stored data, such as the collation and sort order. This course demonstrates how to perform advanced query techniques to manipulate data. It also identifies how to work with the COLLATE clause to manage international considerations when working with data. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.
Advanced Query Techniques
- recognize how to use built-in functions to perform operations on data
- recognize how to manipulate the result sets of queries
- recognize how to control execution plans
- recognize how to store data in multiple languages within a database
- use advanced queries