MCSE SQL SERVER 2012 BUSINESS INTELLIGENCE (LIVE LABS INCLUDED)

Greater Brighton Metropolitan College

Course

Online

Price on request

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

Enabling Business Intelligence and Reporting Engineers to go beyond the basic mechanics of SQL Server 2012, students will learn how to design, build and deploy Business Intelligence applications in an enterprise-class environment.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • MCSE
  • Business Intelligence
  • MCSE training
  • SQL
  • Server

Course programme

  • Getting Started with SQL Server 2012
  • Working with T-SQL
  • Writing SELECT Queries
  • Working with SQL Data Types
  • Sorting and Filtering Data
  • Querying Data from Multiple Tables
  • Modifying Data
  • Working with SQL Server Built-in Functions
  • Programming in T-SQL
  • Implementing Stored Procedures
  • Working with Subqueries and Table Expressions
  • Working with Set Operators, Conditional Operators, and Window Functions
  • Working with PIVOT, UNPIVOT, and Grouping Sets
  • Managing Error Handling and Transactions
  • Querying SQL Server System
  • Optimizing Query Performance
  • Identifying the SQL Server Platform
  • Deploying SQL Server
  • Configuring SQL Server
  • Managing Databases in SQL Server 2012
  • Managing SQL Server Security
  • Implementing Advanced Security Settings
  • Applying Encryption and Compression
  • Working with Indexes and Log Files
  • Working with Backup and Restore
  • Implementing High Availability
  • Optimizing Server Performance
  • Troubleshooting Issues and Recovering Databases
  • Performing Advanced Database Management Tasks
  • Introduction to Data Warehouse
  • Creating Dimensions and Changing Granularity of Dimensions
  • Creating Fact Tables and ColumnStore Indexes
  • Implementing Data Warehouse in SQL Server 2012
  • Working with Integration Services
  • Managing Control Flow
  • Working with Dynamic Variables
  • Implementing Data Flow
  • Managing Data Flow
  • Managing SSIS Package Execution
  • Debugging and Troubleshooting
  • Deploying Packages
  • Securing Packages and Databases
  • Working with MDS and Windows
  • Introduction To Business Intelligence and Data Modeling Part1
  • Introduction To Business Intelligence and Data Modeling Part2
  • The Microsoft Business intelligence Platform Part1
  • The Microsoft Business intelligence Platform Part2
  • The Microsoft Business intelligence Platform Part3
  • The Microsoft Business intelligence Platform Part4
  • Implementing Reports the SQL Server Reporting Services Part1
  • Implementing Reports the SQL Server Reporting Services Part3
  • Implementing Reports the SQL Server Reporting Services Part2
  • Implementing Reports the SQL Server Reporting Services Part4
  • Implementing Reports the SQL Server Reporting Services Part5
  • Implementing Reports the SQL Server Reporting Services Part6
  • Implementing Reports the SQL Server Reporting Services Part7
  • Implementing Reports the SQL Server Reporting Services Part8
  • Supporting Self Service Reporting Part1
  • Supporting Self Service Reporting Part2
  • Managing Report Execution And Delivery
  • Managing Report Execution
  • Subscriptions And Data Alerts
  • Creating Multidimensional Databases
  • Creating Data Sources And Data Source Views
  • Creating And Browsing a Cube
  • Working with Cubes And Dimensions
  • Sorting And Grouping Attributes
  • Introduction to MDX
  • Adding Calculations To A Cube
  • Customizing Cube Functionality Part1
  • Customizing Cube Functionality Part2
  • Customizing Cube Functionality Part3
  • Implementing A Tabular Data Model Part1
  • Implementing A Tabular Data Model Part2
  • Introduction to DAX
  • Demonstration Making A Tabular Model Part1
  • Demonstration Making A Tabular Model Part2
  • Using DAX
  • Implementing An Analysis Services Tabular Data Model Part1
  • Implementing An Analysis Services Tabular Data Model Part2
  • Deploying A Tabular Data Model
  • SQL Analysis Services Part1
  • SQL Analysis Services Part2
  • Performing Predictive Analysis With Data Mining
  • Using the Data Mining Wizard
  • Predictive Analytics Part1
  • Predictive Analytics Part2
  • Introduction
  • The Business Intelligence Solution
  • Overview Of Business Intelligence
  • BI And Power Pivot Demo
  • ETL Intro
  • Designing Data Warehouses
  • Design For Speed
  • BI Semantic Model
  • Basic Database Objects Demo
  • Stored Procedures And Triggers Demo
  • Database Clusters Demo
  • SQL Server Management
  • Table Triggers
  • DB Config Options
  • DB Backup
  • DB Files And Restore
  • Using SQL Server Data Tools Demo
  • Building An IS Integration Services Package Demo
  • Loading Data From Remote Sources Demo
  • Processing Data From Web Service Demo
  • Report Building Intro Setup Demo
  • Using Report Builder Demo
  • Reporting From Multiple Tables Demo
  • Report Function And Matrix Demo
  • Interactive Reports Demo
  • Sorting Report Data Demo
  • Drill Through Reports
  • Data Visualization
  • Creating Store Procedure From Scratch
  • Memory Optimize Table
  • Building Our First Integration Project
  • Data Transformation
  • Introduction To Big Data
  • Transformation Using Store Procedure
  • Transformation Using SSIS
  • Building Fact Table Using Store Procedure
  • Building Fact Table Using SSIS
  • Backup Enhancements
  • Index Enhancements
  • Online DB Enhancements
  • Back Up To The Cloud
  • Partition Data
  • BI Review
  • Share Point Overview
  • Share Point Demo
  • Exam Prep
  • Before You Take The Exam
  • Conclusion

    • Additional information

    How to work with large datasets across multiple platforms as is common in most modern BI applications and reports. Building Online Analytical Processing (OLAP) cubes and supporting structures such as pivot tables, PowerPivot solutions and Multidimensional Expressions (MDX) to deliver information quickly and efficiently to analysts. Choosing between the Unified Dimensional Model (UDM) and Business Intelligence Semantic models according to specific business data and reporting needs. Developing complex SQL queries to mine multiple datasets and building reports using Crescent

    See related categories

    MCSE SQL SERVER 2012 BUSINESS INTELLIGENCE (LIVE LABS INCLUDED)

    Price on request

    The best SQL Server courses

    See all

    See all