> Nearby Locations
Connecticut
860-768-3777
 
 
My Account  |  View Cart

Microsoft SQL Server 2012 Training Connecticut

The next wave of SQL Server will help extend organizations beyond the database with a cloud-ready information platform. Maintaining maximum uptime, data availability and a level of compliance are not just expected skills from IT professionals, but are critical to any healthy business.

Microsoft SQL Server 2012 training at New Horizons Connecticut covers all aspects of Microsoft's premier database system for all business sizes. Whether your focus is SQL Server 2012 administration, programming or business intelligence and reporting, New Horizons has the training that is right for you and that will fit your busy schedule.

New Horizons Connecticut uses Microsoft Official Curriculum to provide you with the best possible training. If your goal is certification, you may also want to view our SQL Server 2012 certification page.

SQL Server 2012 Database Administrator Key Courses

In the first tier of SQL Server 2012 training at New Horizons Connecticut, the student will be prepared for the MCSA: SQL Server 2012 Certification:
  • Installing, configuring and maintaining SQL Server 2012
  • Managing SQL Server 2012 security
  • Replication, disaster recovery and performance tuning
  • Working with views, stored procedures, triggers and functions
  • Transactions and locks
Learn more about the exams for the MCSA: SQL Server 2012 Certification

Key Courses
Outline 10774 Querying Microsoft SQL Server 2012
Outline 10775 Administering Microsoft SQL Server 2012 Databases
Outline 10777 Implementing a Data Warehouse with Microsoft SQL Server 2012

SQL Server 2012 Database Developer Key Courses

In the second tier of SQL Server 2012 training at New Horizons Connecticut, the student will be prepared for the MCSE: Data Platform SQL Server 2012 Certification:
    • Create and alter indexes, stored procedures, tables, user-defined functions (UDFs), & views 
    • Control execution plans 
    • Create and modify constraints 
    • Implement full-text search 
    • Maintain database indexes & integrity 
    • Optimize and tune queries & indexing strategies 
    • Troubleshoot performance issues & security 
    • Write automation scripts 
    • Work with XML data 
Learn more about the exams for the MCSE: Data Platform SQL Server 2012 Certification

Key Courses
Outline 10776 Developing Microsoft SQL Server 2012 Databases

SQL Server 2012 Business Intelligence Key Courses

In the third tier of SQL Server 2012 training at New Horizons Connecticut, the student will be prepared for the MCSE: Business Intelligence SQL Server 2012 Certification:
    • Implement reporting solutions by using SQL Server Reporting Services
    • Utilize multidimensional databases by using SQL Server Analysis Services
    • Create tabular semantic data models for analysis by using SQL Server Analysis Services
    • Produce visualizations of data by using Power View
    • Generate data mining solutions by using SQL Server Analysis Services
Learn more about the exams for the MCSE: Business Intelligence SQL Server 2012 Certification

Key Courses
Outline 10778 Implementing Data Models and Reports with Microsoft SQL Server 2012

For more information about SQL Server 2012 training with New Horizons, fill out the form to the right
and a representative will contact you shortly.

Fill out my SQL Server 2012 form.