This instructor-led, live training in 台灣 (online or onsite) is aimed at advanced-level database administrators who wish to learn how to configure and manage data workload on databases.
By the end of this training, participants will be able to:
Training is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008.
Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008.
Gain knowledge of how to build a simple ETL process based on the SSIS and then design and implement a data cube using SSAS.
The participant will be able to manage OLAP database: create and delete database OLAP Processing a partition changes on-line.
The participant will acquire knowledge of scripting XML / A and MDX.
This course has been created for delegates already acquainted with SQL in Microsoft SQL Server Environment 2008/2012. The course focuses on set-based querying and query tuning, working with indexes and analyzing execution plans.
The training also covers table expressions, ranking functions and how to deal with partitioned tables.
Microsoft SQL Server is a relational database management system (RDBMS) for storing and retrieving data.
In this instructor-led, live training (onsite or remote), participants will learn the essentials of the SQL language needed to query a Microsoft SQL Server database.
By the end of this training, participants will be able to:
Install and configure Microsoft SQL Server
Query a Microsoft SQL Server database using Microsoft's Transact-SQL (T-SQL) language
Understand the essentials of database design
Optimize a database through normalization
Use aggregate functions to generate results similar to those of "pivot-tables"
Access Microsoft SQL Server through Excel
Audience
Data analysts
Business Intelligence professionals
Business managers
Excel experts who wish to expand their analysis skill set
Format of the Course
Interactive lecture and discussion
Lots of exercises and practice
Hands-on implementation in a live-lab environment
Course Customization Options
This training is based on the latest version of Microsoft SQL Server
To request a customized training for this course, please contact us to arrange.
開發人員,分析人員和業務用戶需要快速分析大量數據 ,深入了解數據,檢索其中隱藏的知識,並專業有效地報告各種數據源。本課程將使他們能夠使用SQL Server Business Intelligence執行此操作。為期5天的課程將涵蓋用於BI項目的SQL Server組件和工具。 該課程還將包括SQL Server BI 2016中的新功能。將探索和使用Reporting Services,Analysis Services和Integration Services。 SQL Server中的Business Intelligence組件完全獨立於SQL Server數據庫,因此可以在任何數據源上使用它們。因此,沒有必要知道SQL Server本身。 從課程中獲得4個最佳選擇