sql courses
Our Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012 is one of the many sql courses available at IT Nuggets Online. This SQL course prepares students to use the Microsoft SQL Server 2012 BI tools and is focused on the Microsoft 70-467 exam
About the Exam for Microsoft 70-467
The exam key focused areas
- Plan business intelligence (BI) infrastructure (15–20%)
- Design BI infrastructure (15–20%)
- Design a reporting solution (20–25%)
- Design BI data models (30–35%)
- Design an ETL solution (10–15%)
1: Intro
- Intro to Business Intelligence Solution
- Overview Of Business Intelligence
- BI And Power Pivot Demo
- ETL Intro
- Designing Data Warehouses
- Design For Speed
- BI Semantic Model
2: DB Essentials
- Basic Database Objects Demo
- Stored Procedures And Triggers Demo
- Database Clusters Demo
- SQL Server Management
- Table Triggers
- DB Config Options , Backup, Files And Restore
3: Business Intelligence Development
- Database Schema
- Create Table & Tablespace – Part 1- 2
- Create View & Index & Sequence
4: Business Intelligence Results
- Report Building Intro Setup Demo
- Using Report Builder Demo
- Processing Data From Web Service Demo
- Reporting From Multiple Tables Demo
- Report Function And Matrix Demo
- Interactive Reports Demo
- Sorting Report Data Demo
5: Advanced Reporting & Development
- Drill Through Reports
- Data Visualization
- Creating Store Procedure From Scratch
- Memory Optimize Table
6: SQL Server Integration Services
- Building Our First Integration Project
- Data Transformation
- Intro To Big Data
- Transformation Using Store Procedure & SSIS
- Building Fact Table Using Store Procedure & SSIS
7: Functions
- Functions
- More, Group & Custom Functions
Backup Enhancements Index Enhancements Online DB Enhancements BackUp To The Cloud Partition Data
- BI Review
- SharePoint Overview & Demo
- Exam Prep
- Before You Take The Exam
- Conclusion
9: Regular Expressions and SQL Loader
- Regular Expressions
- SQL Loader
10: Monitor SQL Server Instances
- Create and Manage Operators & SQL Agent Alerts
- Configure Policy Based Management & Lab
- Identify Available Space on Data Volumes
- Identify the Cause of- Manage Performance Degradation & Lab Part 1-2
11: Implement Log Shipping
- Configure and Monitor Log Shipping & Lab Part 1- 2
12: Implement Failover Cluster Instances
- Windows Server Failover Cluster
- Manage Shared Disks
- Configure Cluster Shared Volumes & WSFC Lab
13: Implement Always On Availability Groups
- Database Mirroring
- Create an Availability Group
- Manage Failover
- Configure Read Only Routing
- Create Distributed Availability Groups
- Configuring Always On Availability Group Lab Part 1- 2
- Conclusion
