- Home
- Database
- Networking
- Programming
- Online Courses
- Mobile Application
- Web App Developments
- Cryptocurrency Wallets and Mining Coins
- Q# Programming
- BlockChain Application Development
- Java Servlet Programming
- Java Training with Spring
- Developing Images with Docker
- C++ Training
- Python RPA Programming
- Excel VBA Training
- Ruby on Rails Training
- C# Training Course
- Testing
- Automation Test Engineer
- Penetration Testing
- Cucumber BDD
- Selenium Web Test Training Java
- Selenium Test Automation with PHP
- Selenium Test Automation with C# .NET and NUnit
- Android Appium Test Automation
- Online Performance Testing
- Python Automation Testing with Selenium and BDD
- Automation Test Architect
- Automation Test Analyst
- SpecFlow Automation Testing
- Contact
- About Us
MCSE SQL Server 2012: Business Intelligence
Course code
MCSE-12BI
COURSE OVERVIEW
MCSE: Business Intelligence training validates the skills that you needed to design, build and deploy solutions that deliver more data to more people across the organisation.
Exams covered in this Course are:
- Exam 70-461 – Querying Microsoft SQL Server 2012
- Exam 70-462 – Administering Microsoft SQL Server 2012 Databases
- Exam 70-463 – Implementing a Data Warehouse with Microsoft SQL Server 2012
- Exam 70-466 – Implementing Data Models and Reports with Microsoft SQL Server 2012
- Exam 70-467 – Designing Business Intelligence Solutions with Microsoft SQL Server 2012
What is included
- You will get trained to create and control cost-effective, safe and agile server infrastructure.
- The Desktop Infrastructure that is updated and included in this course educates you the ways to implement flexible, sustainable, reliable and free of friction access to any type of company and corporate resources and services among different platforms and devices.
- Licensed software for practice at home
- VAT
Course Start Dates
| Start Date | Time | Days | Duration | Location |
|---|---|---|---|---|
| 24/05/2021 | 10.00 - 17.00 | 10 Days | 2 Weeks | Brentford |
| 28/06/2021 | 10.00 - 17.00 | 10 Days | 2 Weeks | Brentford |
| 26/07/2021 | 10.00 - 17.00 | 10 Days | 2 Weeks | Brentford |
| 30/08/2021 | 10.00 - 17.00 | 10 Days | 2 Weeks | Brentford |
| 27/09/2021 | 10.00 - 17.00 | 10 Days | 2 Weeks | Brentford |
| 01/11/2021 | 10.00 - 17.00 | 10 Days | 2 Weeks | Brentford |
| 06/12/2021 | 10.00 - 17.00 | 10 Days | 2 Weeks | Brentford |
You can choose your dates while you enroll this course
Target Audience
Course Mode
Course Duration
Course Outcome
At the end of the course students can apply for the following job roles
Course Content
MCSE 2012: Business Intelligence Training
- Introduction to Microsoft SQL Server 2012
- Getting Started with SQL Azure
- Introduction to T-SQL Querying
- Writing SELECT Queries
- Querying Multiple Tables
- Sorting and Filtering Data
- Working with SQL Server 2012 Data Types
- Using Built-In Functions
- Grouping and Aggregating Data
- Using Subqueries
- Using Table Expressions
- Using Set Operators
- Using Window Ranking, Offset and Aggregate Functions
- Pivoting and Grouping Sets
- Querying SQL Server Metadata
- Executing Stored Procedures
- Programming with T-SQL
- Implementing Error Handling
- Implementing Transactions
- Improving Query Performance
- Introduction to SQL Server 2012 and its Toolset
- Preparing Systems for SQL Server 2012
- Installing and Configuring SQL Server 2012
- Working with Databases
- Understanding SQL Server 2012 Recovery Models
- Backup of SQL Server 2012 Databases
- Restoring SQL Server 2012 Databases
- Importing and Exporting Data
- Authenticating and Authorizing Users
- Assigning Server and Database Roles
- Authorizing Users to Access Resources
- Auditing SQL Server Environments
- Automating SQL Server 2012 Management
- Configuring Security for SQL Server Agent
- Monitoring SQL Server 2012 with Alerts and Notifications
- Performing Ongoing Database Maintenance
- Tracing Access to SQL Server 2012
- Monitoring SQL Server 2012
- Managing Multiple Servers
- Troubleshooting Common SQL Server 2012 Administrative Issues
- Introduction to Data Warehousing
- Data Warehouse Hardware
- Designing and Implementing a Data Warehouse
- Creating an ETL Solution with SSIS
- Implementing Control Flow in an SSIS Package
- Debugging and Troubleshooting SSIS Packages
- Implementing an Incremental ETL Process
- Incorporating Data from the Cloud into a Data Warehouse
- Enforcing Data Quality
- Using Master Data Services
- Extending SQL Server Integration Services
- Deploying and Configuring SSIS Packages
- Consuming Data in a Data Warehouse
- Developing Microsoft SQL Server 2012 Databases
- Designing Database Solutions for SQL Server 2012
- Introduction to Business Intelligence and Data Modeling
- Implementing Reports with SQL Server Reporting Services
- Supporting Self Service Reporting
- Managing Report Execution and Delivery
- Creating Multidimensional DatabasesThe fundamental purpose of using SQL Server Analysis Services
- Working with Dimensions
- Working with Measures and Measure Groups
- Introduction to MDX
- Customizing Cube Functionality
- Implementing a Tabular Data Model with Microsoft PowerPivot
- Introduction to DAX
- Implementing an Analysis Services Tabular Data Model
- Creating Data Visualizations with Power View
- Performing Predictive Analysis with Data Mining
- Planning a BI Solution
- Planning SQL Server Business Intelligence Infrastructure
- Designing a Data Warehouse
- Designing an ETL Solution
- Designing Analytical Data Models
- Planning a BI Delivery Solution
- Designing a Reporting Services Solution
- Designing a Microsoft Excel-Based Reporting Solution
- Planning a SharePoint Server BI Solution
- Monitoring and Optimizing a BI Solution
- Operating a BI Solution
Mohammed hasan – :
Great trainer, worth it. Thus course Help me to get my dream job.