On your reference I will help you here to get the information about SQL Training and Certification conducted by New Horizons so that you can have idea.
The New Horizons offer Microsoft SQL Server training will help you to focus on SQL Server administration, programming or business intelligence and reporting so that you can easily know more about.
Here is the program structure
Querying Microsoft SQL Server®

Administering Microsoft® SQL Server® Databases

Implementing a Data Warehouse with Microsoft® SQL Server®

Developing Microsoft® SQL Server® Databases

Designing a Data Solution with Microsoft SQL Server

Implementing Data Models and Reports with Microsoft® SQL Server®

Designing Self-Service Business Intelligence and Big Data Solutions

Querying Microsoft SQL Server 2012

Administering Microsoft SQL Server 2012 Databases

Developing Microsoft SQL Server 2012 Databases

Implementing a Data Warehouse with Microsoft SQL Server 2012

Implementing Data Models and Reports with Microsoft SQL Server 2012

Here are the skills you will gain from the certification

Optimize and tune queries
Create and alter stored procedures
Create and alter indexes
Maintain database integrity
Optimize indexing strategies
Create and alter tables
Maintain indexes
Create and modify constraints
Create and alter views
Create and alter user-defined functions (UDFs)
Control execution plans
Work with XML data
Implement full-text search
Troubleshoot security
Write automation scripts
Troubleshoot performance issues
Implement reporting solutions by using SQL Server Reporting Services
Implementing multidimensional databases by using SQL Server Analysis Services
Creating tabular semantic data models for analysis by using SQL Server Analysis Services
Create visualizations of data by using Power View
Create data mining solutions by using SQL Server Analysis Services

Address:-
New Horizons
100 4 Falls Corporate Center, Suite 408
West Conshohocken, PA 19428-4132

Phone:-
888-236-3625