Home   Schulung > EDV > Backoffice > SQL Server

This course deals with the use of nested queries, advanced aggregation, and in particular the use of advanced analytic functions, with emphasis on new efficient analysis capabilities in SQL Server 2012. It also covers additional functionality such as cursors, CTEs, hierarchical queries, stored procedures and functions. End of the course is dedicated to working with SQL Server Analysis Services - a tool for fast and flexible analysis of a large amount of data in real time, as well as its integration with common applications. Upon successful completion of this course, students will be able to: - Use all forms of subqueries - Implement advanced SQL aggregation - Use ranking functions - Make more efficient analyses using the new analytic functions in SQL Server 2012 - Replace cursor-based analyses with new windowing extensions to analytic functions - Implement standard analytic techniques like functions and cursors - Implement advanced analytic techniques like CTEs and hierarchical queries - Create basic OLAP cubes and implement them to their applications - Describe how to get hidden information from data using data mining

Microsoft Advanced Data Analysis in Microsoft SQL Server 2012/2008

Ziel
This course deals with the use of nested queries, advanced aggregation, and in particular the use of advanced analytic functions, with emphasis on new efficient analysis capabilities in SQL Server 2012. It also covers additional functionality such as cursors, CTEs, hierarchical queries, stored procedures and functions. End of the course is dedicated to working with SQL Server Analysis Services - a tool for fast and flexible analysis of a large amount of data in real time, as well as its integration with common applications. Upon successful completion of this course, students will be able to:- Use all forms of subqueries- Implement advanced SQL aggregation- Use ranking functions- Make more efficient analyses using the new analytic functions in SQL Server 2012- Replace cursor-based analyses with new windowing extensions to analytic functions- Implement standard analytic techniques like functions and cursors- Implement advanced analytic techniques like CTEs and hierarchical queries- Create basic OLAP cubes and implement them to their applications- Describe how to get hidden information from data using data mining
Schulungsinhalte
1]Subqueries
Basic subqueries queries in SELECT, WHERE, ORDER BY and HAVING clauses . Nested queries in the FROM clause (inline views) . Multiline subqueries (operators ALL, ANY, IN, EXISTS) . Correlated subqueries

· Advanced Aggregation
Queries with ROLLUP clause . Using the CUBE clause . Using the GROUPING SETS clause . GROUPING () and GROUPING_ID () functions .Using the COMPUTE and COMPUTE BY clauses .

· Analytic Functions
The usage and processing of analytic functions . Ranking functions . The ROW_NUMBER function . RANK and DENSE_RANK functions . The NTILE function . Cumulative and percentage distribution - CUME_DIST and PERCENT_RANK . Inverse Percentile - PERCENTILE_CONT and PERCENTILE_DISC . New features for working with a window of data in SQL Server 2012 . Cumulative and moving aggregate functions (windowing functions) . Cumulative and running totals . Moving averages . LAG and LEAD . FIRST_VALUE and LAST_VALUE

· Other Techniques to Work with SQL queries
Simple control of logic with CASE clause . Common Table Expressions ÔÇô simplifying queries . Hierarchical queries . Cursors . Functions and stored procedures

· Data Analysis Using SQL Server Analysis Services
Introduction to Analysis Services . Creating OLAP cubes . Adjusting the OLAP cubes . Working with OLAP cubes directly in Excel . Analytical dimensions and their hierarchies . Semi-additive analytic functions . Custom modifications of presentation of data in cubes . Introduction to MDX . Introduction to Data Mining . Integration with reporting.
Zielgruppe
The course is designed for analysts and developers who want to familiarize themselves with more advanced analysis capabilities of SQL Server.
Voraussetzungen
Fundamentals of querying SQL Server or any other database.
Ausschlie├člich als Inhouse-Schulung
Dieses Seminar bieten wir ausschlie├člich als Inhouse-Seminar in Ihren R├Ąumlichkeiten oder bei uns in M├╝nster an.
Seminardaten
Schulung-Nraddasqls
Dauer2 Tage
Inhouse-Schulung
Dieses Seminar bieten wir Ihnen als Inhouse-Seminar oder -coaching vor Ort in Ihren R├Ąumlichkeiten an.

Rufen Sie uns bitte an:

+4925198 110 99 0
QRCode zu dieser Schulung

Aktuelle Termine
Mo, 06.06.2016 - Fr, 10.06.2016, Krefeld
Webentwicklung mit HTML, CSS, JavaScript, jQuery und PHP
Mo, 06.06.2016 - Fr, 10.06.2016, M├╝nster
Webentwicklung mit HTML, CSS, JavaScript, jQuery und PHP
Mo, 27.06.2016 - Fr, 01.07.2016, Aachen
Garantierte Durchf├╝hrungMicrosoft WPF - Windows Presentation Foundation (Intensivkurs)
Di, 05.07.2016 - Mi, 06.07.2016, M├╝nster
Social Media - Grundlagen und Strategien
Garantierte Durchf├╝hrung Garantierte Durchf├╝hrung!
Schaufenster
Microsoft WPF - Windows Presentation Foundation


Garantierte Durchf├╝hrung!

Microsoft WPF - Windows Presentation Foundation



Mo, 27.06.2016 - Fr, 01.07.2016
Durchf├╝hrung in Aachen

1.950,00 EUR zzgl. Mwst.



Garantierte Durchf├╝hrung!

Durchgef├╝hrt wird dieses Seminar von einem von Microsoft zertifizierten Referenten, der dar├╝ber hinaus als Autor durch seine zahlreichen Ver├Âffentlichungen von Fachb├╝chern zu Themen in diesem Umfeld bekannt ist.