> Nearby Locations
Southern California
888-825-6684
 
 
My Account  |  View Cart
Microsoft SQL Server Training
  • SQL Server 2014 Training

    Learn the latest SQL Server 2014
  • SQL Server 2012 Training

    Get started today with SQL Server
  • SQL Server Certifications

    Overview of SQL Certifications
  • MCSA SQL Server 2012

    Build your foundation
  • MCSE Data Platform

    Specialize in SQL Administration
  • MCSE Business Intelligence

    Reporting and Data Warehousing
  • About Microsoft SQL Server

    Complete Enterprise Database solution
  • SQL Server 2008

    Training and Certification

Microsoft SQL Server 2014 Training

SQL Server 2014 includes tools to deploy and manage databases offering new technologies for online transaction processing, data warehousing and analytics. SQL Server 2014 also provides solutions for cloud backup and disaster recovery.

New Horizons Southern California offers Microsoft SQL Server 2014 training, so you are up to speed on the latest technology allowing for improved performance and quicker data insights.

Please note the following information from Microsoft, "The MCSA: SQL Server 2012 credential and associated exams (461/462/463) will remain in market without any alterations. No MCSA: SQL Server 2014 credential will be offered. In April 2014, the MCSE: Data Platform (464/465) and MCSE: Business Intelligence (466/467) exams will be appropriately updated with SQL Server 2014 topics. The exam numbers will remain the same." (Microsoft website, 7/11/2014)

Microsoft SQL Server 2014 Technical Training

10977 Updating Your SQL Server Skills to Microsoft® SQL Server® 2014 Schedule Outline
20461 Querying Microsoft SQL Server® Schedule Outline
20462 Administering Microsoft® SQL Server 2014 Databases Schedule Outline
20463 Implementing a Data Warehouse with Microsoft SQL Server 2014 Schedule Outline
20464 Developing Microsoft SQL Server 2014 Databases Schedule Outline
20466 Implementing Data Models and Reports with Microsoft SQL Server 2014 Schedule Outline
40074 Microsoft® SQL Server® 2014 for Oracle DBAs Schedule Outline
55073 Master Data Services, Data Quality Services
with SQL 2012-2014 and Excel
Schedule Outline

What You Will Learn

  • What’s New in SQL Server Database Development
  • Enhancements to SQL Server Management Studio
  • Write basic Transact-SQL queries
  • New and Enhanced Transact-SQL Functions
  • Storing and Querying Documents
  • In-Memory Database Capabilities
  • Scripting SQL Server 2014
  • Implementing Security in Microsoft SQL Server 2014
  • High Availability and Data Recovery Enhancements
  • New and Enhanced Features in SQL Server Integration Services
  • Data Quality Services
  • Master Data Services
  • SQL Server 2014 Reporting Services
  • Cloud Data Solutions

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

10774 Querying Microsoft SQL Server 2012 Schedule Outline
10775 Administering Microsoft SQL Server 2012 Databases Schedule Outline
10776 Developing Microsoft SQL Server 2012 Databases Schedule Outline
10777 Implementing a Data Warehouse
with Microsoft SQL Server 2012
Schedule Outline
10778 Implementing Data Models and Reports
with Microsoft SQL Server 2012
Schedule Outline
20465 Designing Database Solutions
for Microsoft SQL Server 2012
Schedule Outline
20467 Designing Business Intelligence Solutions
with Microsoft SQL Server 2012
Schedule Outline

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...

Exam 461 Querying Microsoft SQL Server 2012
Course: 10774 Querying Microsoft SQL Server 2012
Exam 462 Administering Microsoft SQL Server 2012 Databases
Course: 10775 Administering Microsoft SQL Server 2012 Databases
Exam 463 Implementing a Data Warehouse with Microsoft SQL Server 2012
Course: 10777 Implementing a Data Warehouse with Microsoft SQL Server 2012

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:

Exam 457 Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1
Exam 458 Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2
Courses: 10774 Querying Microsoft SQL Server 2012
10775 Administering Microsoft SQL Server 2012 Databases
10777 Implementing a Data Warehouse with Microsoft SQL Server 2012

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...

Exam 464 Developing Microsoft SQL Server 2012 Databases
Course: 10776 Developing Microsoft SQL Server 2012 Databases
Exam 465 Designing Database Solutions for Microsoft SQL Server 2012
Course: 20465 Designing Database Solutions for Microsoft SQL Server 2012

Upgrade Path if you hold prior certification...

Exam 457 Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1
Exam 458 Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2
Courses: 10774 Querying Microsoft SQL Server 2012
10775 Administering Microsoft SQL Server 2012 Databases
10777 Implementing a Data Warehouse with Microsoft SQL Server 2012
Exam 459 Transition your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform
Course: 10776 Developing Microsoft SQL Server 2012 Databases

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...

Exam 466 Implementing Data Models and Reports
with Microsoft SQL Server 2012
Course: 10778 Implementing Data Models and Reports
with Microsoft SQL Server 2012
Exam 467 Designing Business Intelligence Solutions
with Microsoft SQL Server 2012
Course: 20467 Designing Business Intelligence Solutions
with Microsoft SQL Server 2012

Upgrade Path if you hold prior certification...

Exam 457 Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1
Exam 458 Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2
Courses: 10774 Querying Microsoft SQL Server 2012
10775 Administering Microsoft SQL Server 2012 Databases
10777 Implementing a Data Warehouse with Microsoft SQL Server 2012
Exam 460 Transition your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence
Course: 10778 Implementing Data Models and Reports with Microsoft SQL Server 2012

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

Mission CriticalDo 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

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

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 Southern California 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

6231 Maintaining a Microsoft SQL Server 2008 Database Schedule Outline
6232 Implementing a Microsoft SQL Server 2008 Database Schedule Outline

SQL Server 2008 Business Intelligence Training

2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL Schedule Outline
6234 Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services Schedule Outline
6235 Implementing and Maintaining Microsoft SQL Server 2008 Integration Services Schedule Outline
6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services Schedule Outline

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

Database Developer

Business Intelligence