Vi ste ovdje
Overview/Description
This course explores the various components that make up an SSIS package. This includes elements of package control flow, such as containers used to provide the structure in packages, the actual tasks that provide the package functionality, and precedence constraints that define the interconnection between tasks to create the control flow. For package data flow, the elements covered are the sources used to extract the data, transformations used to manipulate the data, and destinations responsible for loading the data. Paths are then used to connect the components to form...
Overview/Description
This course discusses features and tasks performed by administrators when working with SQL Server 2008 Reporting Services (SSRS) reports and content. After reports have been created and formatted, it is time to make them available to the users that need them. This involves the process of deploying reports and the associated data. This course describes the various methods and processes involved in the deployment and execution of reports. It covers the publishing of reports using the Report Manager web interface and BIDS Report Designer tool. Also discussed is the use and...
Overview/Description
This course discusses the deployment and execution of SQL Server Integration Services (SSIS) packages. Once packages have been created, they must be deployed to a production server. This course gives an overview of the package deployment options available, the preparations of packages for deployment using package configurations, and the creation of a deployment utility. It also covers the methods used to install packages once deployed to the server, including the use of the Package Installation Wizard. The course also discusses the methods for running packages from within...
Overview/Description
SQL Server 2008 Analysis Services gives you the opportunity to take the vast amount of information in your databases and analyze it so that you can use the information to improve your overall business. This course will introduce you to SQL Server 2008 Analysis Services and look at the benefits your business can gain from it. It will also introduce the different types of analysis services solutions that can be implemented and how analysis services is installed on SQL Server 2008. This course will also cover the logical and physical architecture of Multi-dimensional...
Overview/Description
Microsoft SQL Server 2008 offers a combination of powerful Business Intelligence services to help clients develop and manage sophisticated business intelligence solutions. With the Database Engine at its core, SQL Server 2008 offers integration, reporting, and analysis tools to access and process the data necessary to create business solutions. This course gives an overview of the importance of business intelligence in today's competitive market and introduces the capabilities provided by SQL Server 2008 Integration Services, Reporting Services, and Analysis Services. It...
Overview/Description
SQL Server 2008 Reporting Services provides powerful and flexible solutions for enterprise reporting needs. This course introduces the reporting services functionality, tools, installation, and enhancements provided by SQL Server 2008. It outlines the fundamental tasks involved in authoring a basic report and explores the features available to customize and enhance report functionality. This includes understanding the Report Definition Language used with reports, the types of report objects and items that can be added to reports, defining and manipulating data sources and...
Overview/Description
Administration and maintenance of Microsoft SQL Server 2008 Reporting Services and its components is key in providing customers and clients access to the Business Intelligence information they need. This course outlines the tools used and tasks involved in managing and maintaining access to Reporting Services and corresponding data. It covers the authentication subsystem and role-based authorization model used by Reporting Services, as well as the configuration of system-level and item-level role-based security. SQL Server 2008 also provides the ability to deploy and...
Overview/Description
SQL Server 2008 Analysis Services provides a powerful solution for analyzing extremely large amounts of data in a relational database. This course looks at Analysis Services from a management perspective. It outlines the considerations involved with deploying SSAS projects. This includes project deployments using various methods and synchronization. The course also covers analysis services security solutions related to securing an instance and securing user access. A discussion about disaster recovery, including high-availability solutions and backup solutions is also...
Overview/Description
This course discusses managing SQL Server Integration Services (SSIS) packages. Once packages have been created, they must be deployed to a production server and then managed by administrator and users. This course gives an overview of the logging feature and how to use it to enable logging on packages, the event handling process in Integration Services, and the debugging options used. The course also describes best practices for securing packages during development, deployment, and operation using roles, package protection levels, and digital certificates. This course is...
Overview/Description
SQL Server 2008 Analysis Services takes relational data and provides a robust way to analyze it in a meaningful way through MDX queries and data mining. This course will introduce the fundamentals of querying multi-dimensional data. It will introduce the MDX language which used to query multi-dimensional data. This includes a discussion on how to create a basic MDX query, how to establish a cube context, how to build subcubes and named sets, and how data can be modified with MDX. The course also provides a review of Key Performance Indicators (KPI), Actions, Perspectives...
Koraci do učenja
Prijavite se, a ako nemate korisničko ime, registrirajte se.
Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.
Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.
Trebate pomoć?
- Česta pitanja - FAQ
- telefon: +385 1 6558 440
- email: support@cognita.hr
- Kontakt forma
