Certification Learning Path

MCSE: Business Intelligence

The globally recognized standard for IT professionals. (The courses listed below will give you a good start in preparing for this certification. More courses are coming soon.) https://www.microsoft.com/learning/en-us/mcse-sql-business-intelligence.aspx


70-461: Querying Microsoft SQL Server
Course TitleRuntimeVideosTrailer
SQL Server 2014, Part 1 of 9: A Tour of SQL Server 2h 52m 9
SQL Server 2014, Part 2 of 9: Installing 1h 43m 4
SQL Server 2014, Part 3 of 9: Working with Management Studio 1h 47m 4
SQL Server 2014, Part 4 of 9: Designing and Creating a Database 2h 25m 6
SQL Server 2014, Part 5 of 9: Security Basics 1h 39m 5
SQL Server 2014, Part 6 of 9: Permissions and Data Protection 1h 50m 5
SQL Server 2014, Part 7 of 9: Introduction to T-SQL 2h 6m 7
SQL Server 2014, Part 8 of 9: T-SQL Select, Where, and Clauses 1h 38m 5
SQL Server 2014, Part 9 of 9: T-SQL Working with Data 1h 18m 4
SQL 2014 Developer, Part 01 of 13: Views 1h 18m 5
SQL 2014 Developer, Part 02 of 13: Stored Procedures 1h 46m 6
SQL 2014 Developer, Part 03 of 13: Functions 1h 4m 4
SQL 2014 Developer, Part 04 of 13: Transactions 1h 37m 4
SQL 2014 Developer, Part 05 of 13: Common Language Runtime 1h 26m 5
SQL 2014 Developer, Part 06 of 13: Advanced SQL CLR 1h 2m 4
SQL 2014 Developer, Part 07 of 13: Design and Deployment 1h 50m 7
SQL 2014 Developer, Part 08 of 13: Advanced T-SQL Queries 3h 4m 11
SQL 2014 Developer, Part 09 of 13: Advanced Data Types 2h 37m 11
SQL 2014 Developer, Part 10 of 13: Partitions 1h 22m 4
SQL 2014 Developer, Part 11 of 13: Complex Querying 1h 15m 4
SQL 2014 Developer, Part 12 of 13: Coding Techniques 1h 19m 3
SQL 2014 Developer, Part 13 of 13: Working with XML 1h 13m 4

70-462: Administering Microsoft SQL Server 2012/2014 Databases

70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

70-466: Implementing Data Models and Reports with Microsoft SQL Server

70-467: Designing Business Intelligence Solutions with Microsoft SQL Server
Course TitleRuntimeVideosTrailer
SSIS 2014, Part 01 of 11: Concepts and Data Tools 1h 40m 5
SSIS 2014, Part 02 of 11: Control Flows and Tasks 1h 44m 6
SSIS 2014, Part 03 of 11: Data Flows and Tasks 1h 26m 5
SSIS 2014, Part 04 of 11: Containers and Transaction Support 1h 41m 6
SSIS 2014, Part 05 of 11: Join Transformations 1h 27m 4
SSIS 2014, Part 06 of 11: Variables and Expressions 1h 55m 5
SSIS 2014, Part 07 of 11: Scripting Components 1h 43m 6
SSIS 2014, Part 08 of 11: Handling Errors and Events 2h 5m 8
SSIS 2014, Part 09 of 11: Configuring and Deploying Packages 1h 30m 7
SSIS 2014, Part 10 of 11: Managing Packages 1h 24m 6
SSIS 2014, Part 11 of 11: Security 0h 56m 5
SSRS 2014, Part 01 of 10: Introduction and Report Builder 2h 18m 10
SSRS 2014, Part 02 of 10: Creating Reports 1h 5m 4
SSRS 2014, Part 03 of 10: Tablix Report Type 1h 48m 7
SSRS 2014, Part 04 of 10: Expressions and Functions 1h 18m 5
SSRS 2014, Part 05 of 10: Layout, Parameters, and Visualizing 2h 46m 16
SSRS 2014, Part 06 of 10: Accessing and Subscribing to Reports 2h 22m 7
SSRS 2014, Part 07 of 10: Programming Report Access 2h 19m 8
SSRS 2014, Part 08 of 10: Web Service Programming 2h 44m 8
SSRS 2014, Part 09 of 10: Managing Reporting Services 1h 3m 4
SSRS 2014, Part 10 of 10: Reporting Services Security 1h 6m 4