GO

SQL Server Training & Certification from New Horizons

SQL Server delivers breakthrough mission-critical capabilities with native in-memory performance and operational analytics. Comprehensive security features help protect your data at rest and in motion.

Organizations gain deeper insights into their data with capabilities that go beyond business intelligence to perform advanced analytics directly within their database and present rich visualizations for business intelligence on any mobile device or workstation.

Business Benefits of Microsoft Certification

SQL also lets you gain the benefits of hyper-scale cloud, dynamically stretching your warm and cold transactional data to Microsoft Azure in a secured way so your information is always on hand for queries, no matter the size. In addition, SQL Server delivers a complete database platform for hybrid cloud, enabling you to easily build, deploy and manage solutions that span on-premises and cloud.

Structured query language forms the basis of many custom-built and third-party applications, making it a critical component of IT expertise. Microsoft SQL Server training from New Horizons covers all aspects of Microsoft's premier database system for all business sizes. Whether your focus is SQL Server administration, programming, or business intelligence and reporting, New Horizons has the training that is right for you and will fit your busy schedule.

Microsoft SQL Server Certification*

No matter the SQL Server version you prefer, New Horizons has the SQL server administration training, database training, and BI training you need to improve SQL database performance and complete all necessary Microsoft certifications.

Microsoft SQL Server 2016 Certification

Earning an MCSA: SQL 2016 Database Development certification validates your skills in building and implementing databases across organizations, and will qualify you for a position as a database developer.

Courses and Exams for the MCSA: SQL 2016 Database Development:

Course:  20761 Querying Data with Transact SQL
Exam: 70-761 Querying Data with Transact-SQL
 
Course: 20762 Developing SQL Databases
Exam: 70-762 Developing SQL Databases

Individuals who currently hold an MCSA: SQL Server 2012/2014 certification can upgrade by taking and passing Exam 70-762.  

Earning an MCSA: SQL 2016 Database Administration certification validates your skills with database installation, maintenance, configuration, and provisioning tasks, and will qualify you for a position as a database administrator or infrastructure specialist.

Courses and Exams for the MCSA: SQL 2016 Database Administration:

Course: 20764 Administering a SQL Database Infrastructure
Exam: 70-764 Administering a SQL Database Infrastructure
 
Course: 20765 Provisioning SQL Databases
Exam: 70-765 Provisioning SQL Databases

Individuals who currently hold an MCSA: SQL Server 2012/2014 certification can upgrade by taking and passing Exam 70-765.

Earning an MCSA: SQL 2016 Business Intelligence Development certification validates your extract, transform, and load (ETL) and data warehouse skills, along with those for implementing BI solutions using multidimensional and tabular data models and online analytical processing (OLAP) cubes. This certification will qualify you for a position as a BI developer.

Course:  20767 Implementing a SQL Data Warehouse
Exam: 70-767 Implementing a SQL Data Warehouse
 
Course: 20768 Developing SQL Data Models
Exam: 70-768 Developing SQL Data Models

Individuals who currently hold an MCSA: SQL Server 2012/2014 certification can upgrade by taking and passing Exam 70-768.

Microsoft Certified Solutions Expert (MCSE): Database Management & Analytics

Demonstrate your broad skill sets in SQL administration, building enterprise-scale data solutions, and leveraging business intelligence data—both on-premises and in cloud environments. Earning an MCSE: Data Management and Analytics certification qualifies you for such positions as database analyst, database designer, and business intelligence analyst.


NOTE: To earn the MCSE: Database Management & Analytics certification, you must first earn a: MCSA: SQL Server 2012/2014, or MSCA: SQL Server 2016 Database Administration, or MSCA: SQL Server 2016 Database Development, or MSCA: SQL Server 2016 BI Development and then, pass a single additional exam from a list of electives associated with the corresponding certification.

Once you hold an appropriate corresponding MCSA, pass any one of the following elective exams to earn an MCSE: Database Management & Analytics:

Preparation Course: Currently unavailable
Elective Exam: 70-473: Designing and Implementing Cloud Data Platform Solutions
 
Preparation Course: Currently unavailable
Elective Exam: 70-475: Designing and Implementing Big Data Analytics Solutions
 
Preparation Course: 20464 Developing Microsoft SQL Server Databases
Elective Exam: 70-464: Developing Microsoft SQL Server Databases
 
Preparation Course: 20465 Designing Database Solutions for Microsoft SQL Server
Elective Exam: 70-465: Designing Database Solutions for Microsoft SQL Server
 
Preparation Course: 20466 Implementing Data Models and Reports with Microsoft SQL Server
Elective Exam: 70-466: Implementing Data Models and Reports with Microsoft SQL Server
 
Preparation Course: 20467 Designing Business Intelligence Solutions with Microsoft SQL Server
Elective Exam: 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server

Note that Microsoft will change the required elective exams every calendar year.

Microsoft SQL Server 2012 Certification

Microsoft SQL Server 2008 Certification


*Important MCSE & MCSD Certification Changes from Microsoft

On September 26, 2016, five new Microsoft Certified Solutions Expert (MCSE) and Developer (MCSD) specialties were released. To earn each of the new certifications—MCSE: Cloud Platform and Infrastructure, MCSE: Mobility, MCSE: Data Management and Analysis, MCSE: Productivity, or MCSD: App Builder—you must first earn a qualifying Microsoft Certified Solutions Associate (MCSA) certification and, then, pass a single additional exam from a list of electives associated with the corresponding certification. Click here for a complete summary of the MCSE and MCSD changes from Microsoft, including answers to some of the most frequently asked questions.

Taking Your Next Microsoft Certification Exam Just Got A Whole Lot Easier! Learn more about Online Proctoring.

Questions About SQL?

SQL Server 2016 Course Details

  • 10985 Introduction to SQL Databases
    Are you moving into a database role or taking on a database management project? This three-day course is the ideal SQL starting point.
  • 10986 Upgrading Your Skills to SQL Server 2016
    If you’re an experienced SQL 2014 professional looking to prepare for the 2016 Upgrade exam, this instructor-led course is for you.
  • 10987 Performance Tuning and Optimizing SQL Databases
    This four-day Microsoft SQL training is designed to help IT pros maximize the performance of live database environments through hands-on query writing and testing.
  • 10988 Managing SQL Business Intelligence Operations
    Ready to tap the BI benefits of SQL? This course helps database professionals implement and manage self-service business intelligence solutions
  • 10989 Analyzing Data with Power BI
    SQL’s Power BI solution offers a foundation for solid data analytics and business intelligence. This course provides the key skills needed to maximize Power BI efficacy.
  • 20761 Querying Data with Transact SQL
    If you’re an SQL power user, database admin or developer, this SQL training gives you the in-depth knowledge of Transact-SQL language you need to write SELECT queries, query multiple tables, or sort and filter data.
  • 10990 Analyzing Data with SQL Server Reporting Services
    Great BI only returns great value with clear and concise reports. This SQL database training course gives IT pros the skills they need to create and implement both workstation and mobile reporting.
  • 20762-1 Developing SQL Databases
    This four-day course provides the foundational skills needed to create and manage an SQL 2016 database and is ideal for IT pros looking to increase their specific SQL knowledge.
  • 20764 Administering a SQL Database Infrastructure
    For IT pros tasked with managing user authentication and access, course 20764 provides the critical knowledge needed to assign database roles, backup databases and configure security for the SQL server agent.
  • 20765 Provisioning SQL Databases
    The primary audience for this SQL training is IT professionals in charge of regular database admin and maintenance, or tasked with delivering content from SQL databases. Upon completion, you’ll have the skills needed to provision, upgrade or configure an SQL server.
  • 20767 Implementing a SQL Data Warehouse
    If you’ve taken on the role of business intelligence development, this SQL server training is for you. This five-day course will equip you with all the skills needed to implement logical and physical warehouse design, implement data flow in SSIS and implement a Master Data Services model.
  • 20768 Developing SQL Data Models
    This three-day, instructor-led course is ideal for database pros in a BI developer role and provides the training needed to create multidimensional databases, use MDX syntax and implement a tabular database.

SQL Server 2014/2012 Course Details