Vi ste ovdje
Overview/Description
ETL, extract, transform, and load, is the main process in data warehousing solutions. It facilitates the transfer of the data from a source to a destination, which may also evolve transforming the data during the process. This course discusses the ETL process and how it can be implemented and demonstrates how to create simple SSIS packages that use the Data Flow Task in SQL Server Data tools, SSDT. During the demonstration, how to use connection managers to specify the source and destinations for the data is also covered, as well as how to use other tasks to transform the...
Overview/Description
SQL Server Integration Services (SSIS) is an extensible platform for creating data integration and workflow solutions. SSIS is extensible because developers have the ability to create custom components if the integrated components do not suit their needs. In this course we cover how to develop and install custom components and implement script tasks. Also discussed are the different types of Slowly Changing Dimensions (SCD), and how to manage data that slowly changes over time. This course is one of a series in the SkillSoft learning path that covers the objectives for...
Overview/Description
This course discusses what a data warehouse database is and how it is used to create reports and aggregate data, the types of schemas and tables that are created within it. This course also covers how to create dimension and fact tables, and how to improve performance of a data warehouse database using indexes, partitions, data compression, and columnstore indexes. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-463:Implementing a Data Warehouse with Microsoft SQL Server 2012. This exam is...
Overview/Description
For anyone that is creating a data warehouse data quality should be one of the top priorities. In order to trust the results of data analysis high quality data is essential. Data Quality Services (DQS) is a feature of SQL Server 2012 that can help you find duplicate data entries and identify invalid data values while automatically correcting them. Master Data Services (MDS) is another feature of SQL Server 2012 that enables you to enforce data validation and rules to ensure consistency in your data. This course discusses strategies for using both of these technologies...
Overview/Description
SSIS in SQL Server 2012 allows for dynamic packages and to enable values within the package to be manually set depending on your requirements at execution time. SQL Server 2012 allows for the use of parameters, variables, and expressions to create dynamic packages. In SQL Server 2012 you can also perform data mining and text mining to find patterns and rules within the data being analysed. This course discusses and shows how to use parameters, variables, expressions, and event handlers to create dynamic SSIS packages. It also discusses and shows how to use the Data...
Overview/Description
To create complex ETL solutions you can use control flow and data flow. Control flow consists of three elements: containers, tasks, and precedence constraints, which can be used to provide structure, functionality, and order of operations in the control flow. By using the control flow Data Flow Task, data flow can be implemented into the SSIS package to specify the source of the data, how the data should be transformed, and then the data destination. This course discusses and show how to design and implement the control flow elements. It also explains the different types...
Overview/Description
SQL Server Integration Services (SSIS) is a component of SQL Server 2012, that for used for data extraction, transformation, and loading (ETL). SSIS can be installed during the SQL Server 2012 installation or as a separate component later on. Before installing SSIS there are a number of installation considerations that must be addressed first. This includes upgrading from previous versions of SQL, the use of Windows 32-bit or 64-bit and various security requirements. These topics are discussed in the course, along with topics on packaging, deploying and executing SSIS...
Overview/Description
SQL Server Integrations Services and SQL Server Data Tools both offer tools and techniques to troubleshoot, optimize, and audit SSIS solutions. This course discusses how to debug and troubleshoot packages at the design and production level using techniques such as data viewers, data taps, and reports. It also discussion using reports, as well as execution trees and backpressure to view performance information and how to implement auditing at different levels. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL...
Overview/Description
Enterprises use databases to store their most critical data. To protect and ensure the data's availability, database administrators need to establish a solid backup and restoration plan. Such plans are used to protect data in the event of a disaster by allowing complete sets of duplicate data to be restored in a timely fashion. There are multiple types of backups that can be taken to ensure data can be recovered, including to the point of failure or a point-in-time recovery. This course demonstrates how to perform backup and recovery operations.This course is one of a...
Overview/Description
SQL Server 2012 provides several key features that improve the availability of servers and databases so that downtime for users is minimized. These solutions include AlwaysOn Failover Clustering, AlwaysOn Availability Groups, database mirroring, and Replication. These reliability features help administrators maintain multiple sets of data that help ensure that critical systems remain accessible, and can be fully recovered in the event of a disaster. This course addresses how to configure SQL Server 2012's AlwaysOn features, database mirroring, and replication to ensure...
- 1 od 4
- ››
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
