Microsoft SQL Server 2012 - Implementing a Data Warehouse: Design and Deployment
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 ...
Microsoft SQL Server 2012 - Implementing a Data Warehouse: DQS and MDS Solutions
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 ...
Microsoft SQL Server 2012 - Implementing a Data Warehouse: Enhancing Packages
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 ...
Microsoft SQL Server 2012 - Implementing a Data Warehouse: ETL Solutions
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, ...
Microsoft SQL Server 2012 - Implementing a Data Warehouse: Installing SSIS
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 ...
Microsoft SQL Server 2012 - Implementing a Data Warehouse: Troubleshooting
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 ...
Microsoft SQL Server 2012: Backing Up and Restoring Databases
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 ...
Microsoft SQL Server 2012: Configuring High Availability
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, ...
Microsoft SQL Server 2012: Creating Database Objects
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, ...
Microsoft SQL Server 2012: Creating Functions and Triggers
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 ...