Notice : You are now accessing LOOP SIT SERVER. This is not meant for public access. For the actual LOOP Website please visit www.LOOP.sg instead


Certification at Your Fingertips - Microsoft 70 -467: Designing Business Intelligence Solutions with SQL Server 2012


Certification at Your Fingertips - Microsoft 70 -467: Designing Business Intelligence Solutions with SQL Server 2012, Singapore SKillsFuture elarning online course

Course Description

Practice Lab
This course comes with a Remote Practice Environment, a virtual remote environment; where you are able to practically apply the skills you have learned on the respective server, systems and networks. With this platform, get one step ahead in your preparation for your certification exams!

Whether it’s Cisco, Microsoft or VMware, our Practice Lab unifies access to all of these vendors through a web browser interface. Pre-configured hardware layouts with accompanying lab guides for fast, convenient access to gain hands on experience. With step-by-step instructions covering thousands of practical tasks across Cisco, Microsoft, VMware and CompTIA exam titles, the Practice Lab makes studying for an exam or learning new technologies an engaging experience.

What this course prepares you for:

With Business intelligence (BI) architects in mind, this course will prepare such individuals for the Microsoft 70 -467: Designing Business Intelligence Solutions with SQL Server 2012 exam. Business Architects are responsible for the overall design of a BI infrastructure and how it relates to other data systems in use. This course will cover topics such as Intro To Business Intelligence, Database Essentials, Business Intelligence Development, Business Intelligence Results plus much more.

Ace your certification examination with this preparation course!

- Learn of the examination outline before sitting for your certification
- Know and understand the topics that may be covered in your examinations
- Understand both practical and theory aspects of the examination
- Apply the practical skills through the Remote Practice Environment

This course is SkillsFuture Credit Eligible.


Course Objectives

1. Database Essentials
2. Business Intelligence Results
3. SQL Server Integration Services (SSIS)
4. SQL Server 2014 New Features


Related Courses

  • Certification at Your Fingertips - Microsoft 70 -463: Implementing a Data Warehouse with SQL Server 2012

    Certification at Your Fingertips - Microsoft 70 -463: Implementing a Data Warehouse with SQL Server 2012

    SGD $589.00

    Course Description

    Practice Lab  This course comes with a Remote Practice Environment, a virtual remote environment; where you are able to practically apply the skills you have learned on the respective server, systems and networks. With this platform, get one step ahead in your preparation for your certification exams! Whether it’s Cisco, Microsoft or VMware, our Practice Lab unifies access to all of these vendors through a web browser interface. Pre-configured hardware layouts with accompanying lab guides for fast, convenient access to gain hands on experience. With step-by-step instructions covering thousands of practical tasks across Cisco, Microsoft, VMware and CompTIA exam titles, the Practice Lab makes studying for an exam or learning new technologies an engaging experience. What this course prepares you for: This course is preparation for the Microsoft 70-463 Implementing a Data Warehouse with SQL Server 2012 exam. The course covers topics that are featured on the exam, such as how to implement a data warehouse platform to support a BI solution, how to create a data warehouse with Microsoft SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. Ace your certification examination with this preparation course! - Learn of the examination outline before sitting for your certification  - Know and understand the topics that may be covered in your examinations - Understand both practical and theory aspects of the examination - Apply the practical skills through the Remote Practice Environment

    Read more...

  • Certification at Your Fingertips - Microsoft 70-410: Installing and Configuring Windows Server 2012

    Certification at Your Fingertips - Microsoft 70-410: Installing and Configuring Windows Server 2012

    SGD $589.00

    Course Description

    Practice Lab  This course comes with a Remote Practice Environment, a virtual remote environment; where you are able to practically apply the skills you have learned on the respective server, systems and networks. With this platform, get one step ahead in your preparation for your certification exams! Whether it’s Cisco, Microsoft or VMware, our Practice Lab unifies access to all of these vendors through a web browser interface. Pre-configured hardware layouts with accompanying lab guides for fast, convenient access to gain hands on experience. With step-by-step instructions covering thousands of practical tasks across Cisco, Microsoft, VMware and CompTIA exam titles, the Practice Lab makes studying for an exam or learning new technologies an engaging experience. What this course prepares you for: With this preparation course for Microsoft 70-410: Installing and Configuring Windows Server 2012, candidates will be able to revise and sharpen their skills and knowledge needed to pass the examination. This exam is part one of a series of three exams that test the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. Passing this exam validates a candidate’s ability to implement and configure Windows Server 2012 core services, such as Active Directory and the networking services. Passing this exam along with the other two exams confirms that a candidate has the skills and knowledge necessary for implementing, managing, maintaining, and provisioning services and infrastructure in a Windows Server 2012 environment. A few of the topics that will be covered in this course includes: install and configure servers, configure server roles and features, Configure Hyper-V, Deploy and configure core network services, install and administer Active Directory and Create and manage Group Policy. Ace your certification examination with this preparation course! - Learn of the examination outline before sitting for your certification  - Know and understand the topics that may be covered in your examinations - Understand both practical and theory aspects of the examination - Apply the practical skills through the Remote Practice Environment This course is SkillsFuture Credit Eligible

    Read more...

  • Microsoft Software Development Fundamentals MTA (98-361)

    Microsoft Software Development Fundamentals MTA (98-361)

    SGD $45.00

    Course Description

    Microsoft's Software Development Fundamentals MTA Exam 98-361 is designed for candidates who are seeking to prove core software development skills. Microsoft Technology Associate (MTA) is an introductory Microsoft certification for individuals considering a career in technology. MTA certification addresses a wide spectrum of fundamental technical concepts, assesses and validates your core technical knowledge, and enhances your technical credibility. The Software Development Fundamentals exam tests your broad, foundational knowledge of the various technologies and options when developing software solutions using today's tools. In this course, Mark Long helps you to understand the core technologies and functionalities that can be used to create excellent software solutions. Understanding the core technologies, their functionalities, and how they fit into the big picture of software development is key to getting started in a software development career. Mark brings over 25 years of real world experience along as he helps you learn what you need to know to prepare for the 98-361 MTA exam.Be fully prepared for your certifications exams!- Learn of the examination outline before sitting for your certification - Know and understand the topics that may be covered in your examinations- Learn and understand the chapters for each tailored certification - Go through past questions to have a feel of the examinationsThis course is SkillsFuture Credit Eligible.

    Read more...


Content

Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012

+
Simulated Practice Environment
Content
  • Module 1: Intro To Business Intelligence
    • 1.1 The Business Intelligence Solution
    • 1.2 Overview Of Business Intelligence
    • 1.3 BI And Power Pivot Demo
    • 1.4 ETL Intro
    • 1.5 Designing Data Warehouses
    • 1.6 Design For Speed
    • 1.7 BI Semantic Model
  • Module 2: Database Essentials
    • 2.1 Basic Database Objects Demo
    • 2.2 Stored Procedures And Triggers Demo
    • 2.3 Database Clusters Demo
    • 2.4 SQL Server Management
    • 2.5 Table Triggers
    • 2.6 DB Configuring Options
    • 2.7 DB Backup
    • 2.8 DB Files And Restore
  • Module 3: Business Intelligence Development
    • 3.1 Using SQL Server Data Tools Demo
    • 3.2 Building An IS Integration Services Package Demo
    • 3.3 Loading Data From Remote Sources Demo
    • 3.4 Processing Data From Web Service Demo
  • Module 4: Business Intelligence Results
    • 4.1 Report Building Intro Setup Demo
    • 4.2 Using Report Builder Demo
    • 4.3 Reporting From Multiple Tables Demo
    • 4.4 Report Function And Matrix Demo
    • 4.5 Interactive Reports Demo
    • 4.6 Sorting Report Data Demo
  • Module 5: Advanced Reporting And Development
    • 5.1 Drill Through Reports
    • 5.2 Data Visualization
    • 5.3 Creating Store Procedure From Scratch
    • 5.4 Memory Optimize Table
  • Module 6: SQL Server Integration Services (SSIS)
    • 6.1 Building Our First Integration Project
    • 6.2 Data Transformation
    • 6.3 Introduction To Big Data
    • 6.4 Transformation Using Store Procedure
    • 6.5 Transformation Using SSIS
    • 6.6 Building Fact Table Using Store Procedure
    • 6.7 Building Fact Table Using SSIS
  • Module 7: SQL Server 2014 New Features
    • 7.1 Backup Enhancements
    • 7.2 Index Enhancements
    • 7.3 Online DB Enhancements 
    • 7.4 Back Up To The Cloud
    • 7.5 Partition Data
  • Module 8: Course Review And Exam Prep
    • 8.1 BI Review
    • 8.2 SharePoint Overview
    • 8.3 SharePoint Demo
    • 8.4 Exam Preparation 
    • 8.5 Before You Take The Exam

SkillsFuture Credit Eligible

SGD $589.00
(Price excludes GST)
GET ACCESS NOW
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.