Microsoft

aaaaaaaa

Module 1: Introduction to SQL Server 2014 Database Administration Module 2: Installing and Configuring SQL Server 2014 Module 3: Working with Databases and Storage Module 4: Planning and Implementing a Backup Strategy Module 5: Restoring SQL Server 2014 Databases Module 6: Importing and Exporting Data Module 7: Monitoring SQL Server 2014 Module 8: Tracing SQL Server Activity Module 9: Managing SQL Server Security Module 10: Auditing Data Access and Encrypting Data Module 11: Performing Ongoing Database Maintenance Module 12: Automating SQL Server 2014 Management Module 13: Monitoring SQL Server 2014 by Using Alerts and Notifications

Module 1: Planning a BI Solution Module 2: Planning SQL Server Business Intelligence Infrastructure Module 3: Designing a Data Warehouse Module 4: Designing an ETL Solution Module 5: Designing Analytical Data Models Module 6: Planning a BI Delivery Solution Module 7: Designing a Reporting Services Solution Module 8: Designing a Microsoft Excel-Based Reporting Solution Module 9: Planning a SharePoint Server BI Solution Module 10: Monitoring and Optimizing a BI Solution Module 11: Operating a BI Solution

Module 1: Introduction to Enterprise Data Architecture Module 2: Multi-Server Configuration Management Module 3: Consolidating Database Workloads with SQL Server 2014 Module 4: Introduction to Cloud Data Solutions Module 5: Introduction to Microsoft Azure Module 6: Microsoft Azure SQL Database Module 7: SQL Server in Microsoft Azure Virtual Machines Module 8: Introduction to High Availability in SQL Server 2014 Module 9: Clustering with Windows Server and SQL Server 2014 Module 10: AlwaysOn Availability Groups Module 11: Planning High Availability and Disaster Recovery Module 12: Replicating Data

Module 1: Introduction to Database Development Module 2: Designing and Implementing Tables Module 3: Ensuring Data Integrity through Constraints Module 4: Introduction to Indexing Module 5: Advanced Indexing Module 6: Columnstore Indexes Module 7: Designing and Implementing Views Module 8: Designing and Implementing Stored Procedures Module 9: Designing and Implementing User-Defined Functions Module 10: Responding to Data Manipulation via Triggers Module 11: Using In-Memory Tables Module 12: Implementing Managed Code in SQL Server Module 13: Storing and Querying XML Data in SQL Server Module 14: Working with SQL Server Spatial Data

Module 1: Introduction to Data Warehousing Module 2: Planning Data Warehouse Infrastructure Module 3: Designing and Implementing a Data Warehouse Module 4: Creating an ETL Solution with SSIS Module 5: Implementing Control Flow in an SSIS Package Module 6: Debugging and Troubleshooting SSIS Packages Module 7: Implementing a Data Extraction Solution Module 8: Loading Data into a Data Warehouse Module 9: Enforcing Data Quality Module 10: Master Data Services Module 11: Extending SQL Server Integration Services Module 12: Deploying and Configuring SSIS Packages Module 13: Consuming Data in a Data Warehouse

Module 1: Introduction to Business Intelligence and Data Modeling Module 2: Creating Multidimensional Databases Module 3: Working with Cubes and Dimensions Module 4: Working with Measures and Measure Groups Module 5: Introduction to MDX Module 6: Enhancing a Cube Module 7: Implementing an Analysis Services Tabular Data Model Module 8: Introduction to DAX Module 9: Implementing Reports with SQL Server Reporting Services Module 10: Enhancing Reports with SQL Server Reporting Services Module 11: Managing Report Execution and Delivery Module 12: Delivering BI with SharePoint PerformancePoint Services Module 13: Performing Predictive Analysis with Data Mining

Module 1: Introduction to Microsoft SQL Server 2014 Module 2: Introduction to T-SQL Querying Module 3: Writing SELECT Queries Module 4: Querying Multiple Tables Module 5: Sorting and Filtering Data Module 6: Working with SQL Server 2014 Data Types Module 7: Using DML to Modify Data Module 8: Using Built-In Functions Module 9: Grouping and Aggregating Data Module 10: Using Subqueries Module 11: Using Table Expressions Module 12: Using Set Operators Module 13: Using Window Ranking, Offset, and Aggregate Functions Module 14: Pivoting and Grouping Sets Module 15: Executing Stored Procedures Module 16: Programming with T-SQL Module 17: Implementing Error Handling Module 18: Implementing Transactions Module 19: Improving Query Performance Module 20: Querying SQL Server Metadata