MCSE: Business Intelligence

Skillsoft

The Course

Gain the skills to build and deploy SQL Server business intelligence (BI) solutions with this course. You'll get the training you need to pass the exams for the MCSE: Business Intelligence certification. The certification exam is not included in this course.

At a Glance

Qualification

Certification Training

Provider

Skillsoft

Study Mode

Self-Paced

Delivery Mode

Online Learning

Course Duration

7 Months

Location

Online

Intake

Enrol anytime

Key Topics

70-461: Querying Microsoft SQL Server 2012
  • Creating database objects
  • Querying basics & modifying data
  • Manipulate data using operators & functions
  • Creating functions & triggers
  • Creating programming objects & optimizing queries
  • Managing XML data
70-462: Administering Microsoft SQL Server 2012 Databases
  • Installation & upgrade
  • Instance configuration & database creation
  • Managing databases & automating tasks
  • Security management
  • Managing database data
  • Managing indexes, full-text search & partitions
  • Backing up & restoring databases
  • Database monitoring & performance tuning
  • Configuring high availability
70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012
  • Design & deployment
  • Create basic packages
  • ETL solutions
  • Enhancing packages
  • Custom components
  • Installing SSIS
  • Troubleshooting
  • DQS & MDS solutions
70-466 Implementing Data Models and Reports with Microsoft SQL Server
  • Design & install analysis services & tools
  • Designing multidimensional models & data sources
  • Implement & configure cubes
  • Design & implement dimensions
  • Implement partitions & custom logic
  • MDX Queries, process models & deploy databases
  • Manage, maintain & troubleshoot SSAS
  • Create & manage tabular data models
  • Design reports & create data sources & datasets
  • Report formatting & interactivity
  • Manage reporting services
  • Process report & create subscriptions & schedules
70-467 Designing Business Intelligence Solutions with Microsoft SQL Server
  • BI infrastructure design
  • Extract, transform & load
  • Data models
  • Reporting services
  • SharePoint integration
  • MDX Queries & performance
  • Availability & recovery

Career Outcomes

  • BI & Reporting Engineer
  • Database Administrator

Pre-Requisites

  • Successful completion of MCSA:SQL Server 2012 (exams 70-461, 70-462, 70-463)

Our Partner for this Course

 
Skillsoft

Skillsoft provides high-quality online learning solutions to global enterprises, SMEs, governments and educational institutions. Skillsoft's courses, books and videos have been developed by industry leading learning experts to ensure that they maximize business skills, performance, and talent development.

Enquire Online

Speak to one of our Education Consultants