Quick Links

• Call us 888-825-6684
• Find Training & Certification
• Microsoft Technical Training
• Microsoft SATV Vouchers
• Microsoft Windows Server 2012
• Free Microsoft Software Downloads

Microsoft SQL Server
Training and Certification

Microsoft SQL Server 2012 training at New Horizons Southern California covers all aspects of Microsoft's premier database system for all sizes of business.

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.

Microsoft SQL Server 2012 Training

New Horizons Southern California has all the Microsoft SQL Server courses and SQL training you need to prepare you for certification or to solidify your SQL Server expertise. Microsoft SQL Server certifications are offered for SQL Server 2008 (until July 2013) and SQL Server 2012.

Microsoft SQL Server 2012 Technical Training

What You Will Learn

• 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

SQL Server 2012 Certifications Overview

Earning your Microsoft SQL Server certifications is a great way to establish your credibility and skillset with employers.

Microsoft SQL Server certifications allow you to focus on one or more area of specialization:

• Database Administrator - day-to-day server administration and maintenance
• Database Developer - extract and manipulate your data, optimize performance
• Business Intelligence - analyze and mine information from your data

Microsoft SQL Server 2012 Certifications

See the individual tabs for complete details of each certification

• Entry-Level Certification - MCSA: SQL Server 2012
• Database Administration/Development - MCSE: Data Platform
• Business Intelligence - MCSE: Business Intelligence

Upgrade your SQL Server 2008 to SQL Server 2012 certifications

Upgrade paths from SQL Server 2008 to SQL Server 2012 certifications have also been provided by Microsoft. See details on each certification tab.

Build a Foundation - Earn MCSA SQL Server 2012

Start your certfication path with the Microsoft Certified Solutions Associate (MCSA) for SQL Server 2012.

Who's it for?

The MCSA: SQL Server 2012 certification is an entry-level SQL Server 2012 certification. Demonstrate to potential hiring managers your essential skills and breakthrough insights in developing and maintaining the next wave of mission critical environments by achieving the MCSA: SQL Server 2012 certification.

This certification is your first step to mastering Microsoft SQL Server 2012.

Step 1 - Prepare with SQL Server 2012 Training

Rest assured that official Microsoft SQL Server training from New Horizons Southern California is the most efficient way to get up to speed and master all aspects of SQL Server 2012.

Step 2 - Take and Pass your Microsoft Exams

The MCSA SQL Server 2012 requires 3 exams if you hold no prior SQL Server certifications. If you are upgrading your certification, you can take two exams.

If you hold no prior certifications...

Upgrade Path if you hold prior certifications...

If you have a MCTS certification on Microsoft SQL Server 2008, you may upgrade to MCSA: SQL Server 2012 by passing two exams:

MCSE Data Platform

Take the next step in your SQL Server 2012 career with courses and training to help you prepare for your MCSE: Data Platform certification.

Demonstrate your broad skill sets in building and administrating enterprise-scale data solutions both on-premise or in cloud environments by earning an MCSE: Data Platform certification.

Who's It For?

The MCSE: Data Platform certification validates your ability to administer high-availability solutions on the SQL Server 2012 platform. A prerequisite for the MCSE Data Platform certification is MCSA SQL Server 2012.

Step 1 - Earn your MCSA SQL Server 2012 and Train for MCSE

Microsoft Official Curriculum (MOC) taught by Microsoft Certified Trainers (MCT) at New Horizons Southern California is the perfect combination to help you prepare for your exams.

Step 2 - Take and Pass your Microsoft SQL Server Exams

In addition to the MCSA SQL Server prerequisite (3 Exams), the MCSE Data Platform candidate must pass two additional exams. If you hold a prior SQL Server Certification, please see the upgrade path below.

If you hold no prior certifications...

Upgrade Path if you hold prior certification...

MCSE Business Intelligence Certification

Future-proof your BI expertise by earning the MCSE: Business Intelligence certification, your gateway to the skills and techniques needed to design, build, and deploy solutions that deliver more data to more people across the organization. Depending on your experience level, less or more coursework may be required.

Who's It For?

The MCSE: Business Intelligence certification validates your ability to work in the Business Intelligence Developer role to create analysis and reporting solutions on the SQL Server 2012 platform.

Step 1 - Earn your MCSA SQL Server 2012 and Train for MCSE

Start with your MCSA SQL Server 2012 Certification, then train with New Horizons Southern California to prepare for your MCSE Business Intelligence Certification

If you hold no prior certifications...

Upgrade Path if you hold prior certification...

About Microsoft SQL Server 2012

Microsoft SQL Server 2012 is the most recent version of Microsoft's premier database system for businesses and enterprises.

SQL Server 2012 is a Cloud-ready information platform that will help organizations unlock breakthrough insights across the organization as well quickly build solutions and extend data from server to Private or Public Cloud, backed by advanced capabilities for mission critical confidence.

Mission Critical Confidence

Do you see yourself introducing new Mission Critical applications or planning migrations in 3 months to a year?

Many organizations are 24x7 operations and have a global presence and can't afford downtime. How is your current database supporting your needs? Is the performance of your current database where you need it to be?

Enable mission critical performance and availability at low Total Cost of Ownership (TCO).

• New integrated high availability and disaster recovery solution
• Advanced performance speeds
• Built-in encryption capabilities help protect confidential information without changes to the application

Breakthrough Insight

Unlock new insights with pervasive data discovery across the organization.

• Empower business users to create visually rich dashboards or reports across heterogeneous data sources
• Managed self-service BI - Easily balance employee's need for rich information and collaboration with IT's need to manage the safety and confidentiality of information

Cloud on Your Terms

How are you viewing Business Insights for your organization? Are you planning any major projects within the next three months to a year?

Quickly create business solutions on your terms across servers to Private or Public Clouds

• Easily move applications across on-premises and Cloud with unlimited virtualization and license mobility
• Extend data across on-premises and the Cloud

SQL Server 2008 Training and Certification

Microsoft SQL Server 2008 training at New Horizons Harrisburg covers all aspects of Microsoft's premier database system for all sizes of business.

Whether your focus is SQL Server 2008 administration, programming or business intelligence and reporting, New Horizons has the training that is right for you and that will fit your busy schedule.

SQL Server 2008 Administration Training

SQL Server 2008 Business Intelligence Training

Two Levels of Microsoft SQL Server 2008 Certification

MCTS: Microsoft Certified Technology Specialist

Ideal as an entry-level or foundation certification.

MCITP: Microsoft Certified IT Professional

Premier certification to demonstrate knowledge and expertise.

Microsoft SQL Server 2008 Certifications

Please note - several of the exams to obtain the below certifications expire 7/31/13. For MCITP SQL Server certifications, follow the links below and scroll to the "Other Certifications" section of the Microsoft SQL Server certification page.

Database Administration

• MCTS: SQL Server 2008, Implementation & Maintenance
• MCITP: Database Administrator 2008

Database Developer

• MCTS: SQL Server 2008, Database Development
• MCITP: Database Developer 2008

Business Intelligence

• MCTS: SQL Server 2008, Business Intelligence Development & Maintenance
• MCITP: Business Intelligence Developer 2008