Business Intelligence and Analytics Training Bundle

SQL Server 2012 is a robust database system that provides a number of database objects used to store and view data. In order to configure a SQL Server 2012 database to meet business requirements, administrators and developers must fully understand how to design, create, and configure these database objects. These objects include tables for storing data in the database, views to allow access to the data within specific tables, and indexes to optimize the performance of the database for data retrieval. This course identifies each of these database objects and demonstrates the steps required to create them using Transact-SQL statements. This course is one of a series in the SkillSoft learning path that covers the objectives for the exam 70-461: Microsoft SQL Server 2012: Querying. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

SQL Server 2012 includes the SQL Server Management Studio which allows access to SQL Server databases and enables you to access database data. This data can be retrieved and modified through the use of Transact-SQL within the Query Edit window of the Management Studio tool. Using Transact-SQL you can select data from a database’s tables and filter the results to include only the data that you require. Transact-SQL statements also allow you to update, change, and remove data from tables. This course identifies the basic Transact-SQL statements that can be used to retrieve and modify data within SQL Server databases,which includes the DML statements SELECT, INSERT, UPDATE, DELETE, and MERGE. This course also demonstrates how to use joins in queries in combine data from multiple tables and how to use subqueries. This course is one of a series in the SkillSoft learning path that covers the objectives for the exam 70-461: Microsoft SQL Server 2012: Querying. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

Microsoft SQL Server 2012 Transact-SQL offers advanced query techniques, such as built-in aggregate, analytic, scalar, and ranking functions, as well as common table expressions, or CTEs and derived tables to manipulate the result set for a query. To manipulate the result sets and generate summarization information, such as totals, the CUBE, GROUPING SETS, and ROLLUP operators can be used with the GROUP BY statement. The UNION, INTERSECT, and EXCEPT operators can be used to combined the result set of multiple queries. SQL Server 2012 also offers the use of CTEs and derived tables to obtain a result set, temporarily store it, and then pass it to a query to return another result set based on that information. This course demonstrates how to perform advanced query techniques to manipulate data using the SQL Server 2012 built-in functions, operators, and table expressions. This course is one of a series in the SkillSoft learning path that covers the objectives for the exam 70-461: Microsoft SQL Server 2012: Querying. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

In SQL Server 2012 you can use Transact-SQL statements to access data in the databases. Transact-SQL statements can be grouped together in a number of ways to create more complex queries when one Transact-SQL statement will not retrieve the desired results. You can group Transact-SQL statements by creating programming objects within a database. These programming objects can include user-defined functions and DML triggers. When creating programming objects Transact-SQL provides control-of-flow keywords to ensure transaction are completed in a specific sequence and transaction are completed accordingly without errors. This course demonstrates how to use the control-of-flow language keywords, transaction modes, and how to create user-defined functions, including table-valued functions and DML triggers. This course is one of a series in the SkillSoft learning path that covers the objectives for the exam 70-461: Microsoft SQL Server 2012: Querying. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

SQL Server 2012 allows programming objects to be created to group multiple statements together. These objects work with data in the databases. One type of programming object is the stored procedure. Stored procedures can help reduce network traffic between clients and servers by enabling more than one statement to be set to the server at a time. They do this by executing statements as batches. They also provide greater security. Within stored procedures and other programming objects such as functions and triggers, error handling can be implemented to enable errors to be caught and corrected or returned to the user. Cursors and synonyms can also be used in SQL Server 2012. During user interactions with the database resource SQL Server implements certain mechanisms to ensure the integrity of the database, which includes concurrency control and locking. This course demonstrates how to create stored procedures, cursors, and synonyms, as well as how to implement error handling. It also discusses how to view and read execution plans, create plan guides and how concurrency control is handled in SQL Server 2012. This course is one of a series in the SkillSoft learning path that covers the objectives for the exam 70-461: Microsoft SQL Server 2012: Querying. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

XML has been integrated into SQL Server 2012 so that XML data can be stored within databases using the xml data type. SQL Server 2012 also allows for relational data already stored in a database to be changed to XML, and for data to be loaded as XML using various methods. You can query this data using the XQuery language within the XML data type methods. SQL Server 2012 also provides support for using FOR XML to extract relational data from a database in XML format and the use of OPENXML to generate relational views from XML. This course demonstrates how to use the xml data type, XML schema collations, and how to load XML data and how to create XML indexes. It also explores how to retrieve data using FOR XML, process XML data using OPENXML, and how to query data using the XQuery language. This course is one of a series in the SkillSoft learning path that covers the objectives for the exam 70-461: Microsoft SQL Server 2012: Querying. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

SQL Server 2012 is a comprehensive database platform, consisting of components and management tools such as SQL Server Management Studio, the SQL Server Database Engine, Integration Services, Analyzes Services, and Reporting Services. These tools allow administrators and developers to build and maintain software solutions, and perform required functions in a server environment. This course identifies SQL Server 2012 components and management tools, and outlines the requirements for installing SQL Server 2012, including the hardware, software, and security requirements. The steps required to complete a fresh installation of a SQL Server 2012 and how to upgrade a SQL Server instance are also explored. The course also addresses how to move database from an instance of SQL Server to SQL Server 2012 for a migration detach and attach methods and the Copy Database wizard. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

SQL Server 2012's core component is its Database Engine instance, which provides storage, processing, and security for enterprise data through its controlled access and rapid transaction processing. SQL Server 2012 also provides additional features and components to manage and view data, these include Analysis Services and Reporting Services.SQL Server 2012 provides tools to manage the features and components which includes Server Management Studio’s graphical user tool which allows administrators and developers to create and configure instances and databases on an enterprise level, SQL Server Configuration Manager for managing SQL Server services and protocols, and Reporting Services Configuration Manager to configure Reporting Services. This course demonstrates how to add additional features and components to an installation of SQL Server 2012, how to configure and manage an instance, and how to configure Reporting Services. This course also discusses the database architecture and how to create and configure a database. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

Database maintenance is an ongoing task for SQL Server 2012 administrators. This requires the integrity of the database to be checked, the database size to be kept to a minimum by ensuring the files are the correct sizes, and maintenance tasks to be run regularly. SQL Server 2012 Transact-SQL provides DBCC, which is a command that provides statements to maintain the database and database files. An administrator can also create jobs using SQL Server Agent to automate administrative tasks in the SQL Server Database Engine and throughout the enterprise by having the jobs run on multiple SQL Server servers throughout the enterprise using a master server. SQL Server 2012 provides the Database Mail feature which allows e-mails to be sent from SQL Server to users through applications. These e-mails can be anything from alerts to query results and files from any network resource using SMTP. This course demonstrates how to confirm the integrity of a database and manage the size of the database files. It also demonstrates how to configure Database Mail and SQL Server Agent jobs for a single server and for multiple servers. This course also discusses the database architecture and how to create and configure a database. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

Microsoft SQL Server 2012 provides enhanced security features to ensure that each instance is secure. Using SQL Server 2012 security features, administrators can guarantee that access to a SQL Server instance is granted only to specified users, using either Windows Authentication or Mixed Mode Authentication by creating logins and then mapping the logins to the databases within the instance. Administrators also have the ability to encrypt a SQL Server instance using transparent data encryption (TDE) and to encrypt the data within a database using encryption certificates and asymmetric and symmetric keys. SQL Server 2012 also provides an auditing feature to audit the instance using server-level and database-level events, which can then be reviewed in log files. Policy-based management is another feature which provides administrators the means to specify policies throughout the SQL Server instance that objects need to adhere too to keep the database security and running efficiently. This course demonstrates how to create SQL Server logins, database users, schemas, roles, and how to grant permissions. It also addresses how to use encryption to protect a database and database data, as well as how to use the SQL Server Auditing feature and Policy-Based Management. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

SQL Server 2012 provides various features and utilities to manage data stored in the databases within a SQL Server instance. This includes support for storing large unstructured data, such as files and documents within or outside the database. The ability to store large data is supported through the FILESTREAM database feature. This enables large unstructured data to be store outside the database on the file system by providing integration between the file system and SQL Server. FileTables is another database feature that allows large data to be store within tables, but accessed from the file system. SQL Server also provides data compression at the row and page level to compress data that is stored within a database which can help reduce its size. Bulk exporting and importing of data is another feature supported by SQL Server 2012 to allow data to be moved from outside sources into SQL Server or out of SQL Server to outside source or other SQL Server databases. This course provides an overview of the FILESTREAM and FileTable features, including how to enable and use them within a SQL Server 2012 database. It also covers data compression and how to use the bcp utility, BULK INSERT, and OPENROWSET(BULK) function to import and export data. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

SQL Server 2012 provides features to allow administrators to ensure that data is accessed efficiently, this includes the use of indexes, table and index partitions, and full-text search. Indexes in SQL Server 2012 database allow data to be accessed quickly using keys that are stored in a B-tree structure. Indexes need to be created and managed to ensure for the best database performance. SQL Server 2008 provides table and index partitioning to allow data to be stored across multiple filegroups within a database. This makes tables and indexes that contain large amounts of data more manageable. Partitions in the database may need to be split to allow for more data to be stored, or data from one partition may need to be moved to another partition. SQL Server's full-text search component can be implemented to ensure that specific data is returned based on search words and phrases. This course demonstrations how to create and manage indexes, table and index partitions, and how to configure and use the full-text search component in SQL Server 2012. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

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 series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

To keep SQL Server 2012 databases running as efficiently as possible, there are a variety of performance tuning and monitoring tools. The SQL Server Profiler enables you to use trace files and logs to analyze a database's performance. You can also use the Windows System Monitor to monitor SQL Server 2012 using counters, which monitor specific aspects of the server for performance issues. SQL Server 2012 includes the Activity Monitor, which provides an overview of the system's performance in real-time. SQL Server 2012 provides a the Resource Governor, which allocates specific resources to specific sessions, and a data collector, which collects specific data and stores it in a management data warehouse. Extended Events can be used to monitor performance information based on events that occur in the instance using sessions. In SQL Server 2012, concurrency issues may arise that require you to intervene by detecting the locking issue and possibly terminating a process that could be blocking a session from performing its task. Concurrency issues can arise when multiple users are trying to access the same data in a database. This course demonstrates how to use SQL Server Profiler, System Monitor, Activity Monitor, Extended Events, and the data collector to monitor and tune the performance of the database. It also addresses how to detect and resolve locks. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

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 that SQL Server 20012 environments are available to users at all times by providing a high-availability and complete disaster-recovery solution. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

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 one of the requirements for the MCSA: SQL Server 2012, MCSE: Data Platform, and MCSE: Business Intelligence certification paths.

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 data before it is extracted. 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 one of the requirements for the MCSA: SQL Server 2012, MCSE: Data Platform, and MCSE: Business Intelligence certification paths.

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 of transformations to transform the data and how to implement them on the data that is extracted for the source. 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 one of the requirements for the MCSA: SQL Server 2012, MCSE: Data Platform, and MCSE: Business Intelligence certification paths.

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 Mining Query, Term Extraction, Term Lookup, and Percentage Sampling transformations. 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 one of the requirements for the MCSA: SQL Server 2012, MCSE: Data Platform, and MCSE: Business Intelligence certification paths.

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 the Microsoft SQL Server 2012 exam 70-463:Implementing a Data Warehouse with Microsoft SQL Server 2012. This exam is one of the requirements for the MCSA: SQL Server 2012, MCSE: Data Platform, and MCSE: Business Intelligence certification paths.

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 packages.

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 Server 2012 exam 70-463:Implementing a Data Warehouse with Microsoft SQL Server 2012. This exam is one of the requirements for the MCSA: SQL Server 2012, MCSE: Data Platform, and MCSE: Business Intelligence certification paths.

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 in the enterprise demonstrates the steps to configure the product.

One of the most valuable assets an enterprise can possess is data - information acquired and stored in the process of carrying out everyday business activities. This includes data regarding customers and potential customers, employee-related information, data gathered concerning competitors, and information pertaining to products. In order to take full advantage of its information assets, an enterprise must be able to store and utilize data wisely. The SAP BusinessObjects suite of applications provides the enterprise with a comprehensive set of reporting and analysis tools that enables timely and accurate presentation of data, including that obtained from SAP and non-SAP information stores.

Business data comes from a variety of sources and is stored in various formats. The volume and variety of business data presents immense potential for understanding and responding to customer requirements and business process optimization. In order to realize this potential, SAP provides the Crystal Reports reporting tool. Crystal Reports has supplanted the BusinessExplorer report designer as SAP's standard enterprise reporting tool. Crystal Reports provides the interface to allow business users to extract and present formatted, layout-centric reports from business data. Crystal Reports provides a very user-friendly interface to various data sources, including data sources outside of the SAP realm. This course provides an introduction to the Crystal Reports reporting tool, including an initiation to the user-friendly interface, the various formatting and layout options, as well as the various methods of data access made available to all levels of users through Crystal Reports.

Data may be an enterprise's most valuable proprietary asset. Each enterprise possesses unique data that, when used strategically, provides a competitive advantage. Data can reveal significant information about customer behavior and preferences, and provide insight into business processes that may ultimately influence what a company sells, how products are made, and how they are sold. Getting the most out of this data will determine the ultimate value it provides to the enterprise. SAP BusinessObjects Web Intelligence is one of the industry's most flexible, user-friendly and powerful reporting solutions. It provides ad hoc query, analysis, and reporting tools in a package that is geared toward the business user. You do not have to know structured query language (SQL) to take advantage of the power offered by Web Intelligence. You can easily create and publish high-quality reports that contain drill downs, and allow readers to track changes and share business information across the enterprise. This course provides an introduction to BusinessObjects Web Intelligence, highlighting some of its key features and benefits. You will also be able to practice using Web Intelligence tools to perform common tasks.

The typical enterprise generates hundreds of management reports on a weekly basis. As companies grow and continue to add new channels, benchmarking and weekly reporting are key to helping top management keep a finger on the pulse of the business. With all those reports to wade through, business executives need a reporting format that provides the information they need at a glance. The corporate dashboard report does just that. It contains a series of dials in a corporate cockpit that reflect the key performance metrics from each department. Dashboarding involves the presentation of key business data in a very concise visual manner. SAP's BusinessObjects offers dynamic, customizable data visualization tools that allow you to create insightful and powerful dashboards from various data sources. These tools are intuitive and appropriate for users of all skill levels. This course provides an introduction to dashboarding. You will learn how to create dashboards using SAP BusinessObjects InfoView, Xcelsius, and Dashboard Builder.

SAP BusinessObjects provides various tools for enterprise reporting purposes. InfoView is a web-based application that provides an interface for users to perform common activities, such as viewing or modifying reports, without having to install any additional software on their systems. InfoView can work with Xcelsius, Crystal, and Web Intelligence documents. It allows you to publish reports to common formats, such as PDF or MS Word, as well as alter a report's underlying data. This course provides an introduction to the essential features and functions of SAP BusinessObjects InfoView and provides a look at some of the common activities performed using InfoView.

Businesses generate a large amount of data in the everyday operation. This data is extremely valuable and may be used by employees at every level of an organization. Before it can be utilized optimally, it must be formatted in such a way that an enterprise can capitalize on the vast amounts of data in its possession. SAP Business Intelligence (BI) is an enterprise solution that provides businesses with a comprehensive suite of tools to collect and prepare the enterprise's data for reporting and analysis purposes. With proper use of BI, an enterprise may become more organized electronically, spot trends in business, and generally have a competitive edge simply because of its ability to securely and accurately report on and analyze a myriad of data.