Search Training
X
GO

Available Courses

SQL Server 2016

SQL Server 2014/2012

SQL Server 2008

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: BI Reporting demonstrates knowledge relevant to data analysis, data visualization, modeling, dashboards, and direct connectivity to data sources in Excel and Power BI. It is the first step on your path to becoming a Data Management and Analytics Microsoft Certified Solutions Expert (MCSE).

Courses and Exams for the MCSA: BI Reporting:

Course:  20778 Analyzing Data with Power BI
Exam: 70-778: Analyzing and Visualizing Data with Power BI
 
Course: 20779 Analyzing Data with Excel
Exam: 70-779: Analyzing and Visualizing Data with Microsoft Excel

Microsoft Certified Solutions Associate (MCSA): Microsoft Dynamics 365 for Operations

This certification demonstrates your expertise in Microsoft Dynamics 365 technologies to implement the basic technical and development tasks required to customize Microsoft Dynamics 365 for Operations. This audience typically includes technical consultants, programmers, and IT personnel.

Earning an MCSA: Microsoft Dynamics 365 for Operations provides the foundation for a position as a Dynamics 365 developer, solution architect, or implementer and is the first step on your path to becoming a Business Applications Microsoft Certified Solutions Expert (MCSE).

Course: 20764 Administering a SQL Database Infrastructure
Exam: 70-764 Administering a Microsoft SQL Database Infrastructure
Course: 20765 Provisioning SQL Databases
Exam: 70-765 Provisioning SQL Databases
Course: N/A
Exam: MB6-894 Development, Extensions and Deployment for Microsoft Dynamics 365 for Finance and Operations

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.


Once you obtain an associated Microsoft Certified Solutions Associate (MSCA), pass any ONE of the following elective exams to earn an MCSE: Database Management & Analytics:

  • 70-464: Developing Microsoft SQL Server Databases
  • 70-465: Designing Database Solutions for Microsoft SQL Server
  • 70-466: Implementing Data Models and Reports with Microsoft SQL Server
  • 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server
  • 70-473: Designing and Implementing Cloud Data Platform Solutions
  • 70-475: Designing and Implementing Big Data Analytics Solutions
  • 70-762: Developing SQL Databases
  • 70-767: Implementing a Data Warehouse using SQL
  • 70-768: Developing SQL Data Models
  • 70-773: Analyzing Big Data with Microsoft R
  • 70-774: Perform Cloud Data Science with Azure Machine Learning
  • 70-775: Perform Data Engineering on Microsoft Azure HDInsight

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

Microsoft SQL Server 2012 Certification

Microsoft SQL Server 2008 Certification

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