Microsoft SQL Server Training from New Horizons Spokane

Microsoft SQL Server Courses

{{value[0].Version}}

MS Exchange Server Develop your Microsoft SQL Server skills and prepare for SQL Database Certification with training from New Horizons Spokane.

SQL Server Courses Scheduled Soon


Course Starts Location Price
20764 Administering a SQL Database Infrastructure 8/10/2020 Spokane, WA
20764 Administering a SQL Database Infrastructure 8/24/2020 Spokane, WA
20762 Developing SQL Databases 8/10/2020 Spokane, WA
20762 Developing SQL Databases 10/12/2020 Spokane, WA
20778 Analyzing Data with Power BI 7/20/2020 Spokane, WA
20778 Analyzing Data with Power BI 8/10/2020 Spokane, WA

How Can I Become Certified in Microsoft SQL Server?

Get Microsoft Certified!

Earning a Microsoft SQL Server certification is a great way to advance your career and generate new opportunites. SQL Server remains the foundation of most enterprise data-centric applications on the Microsoft platform. Whether you you are developing for an Azure cloud-based application or are the database administrator for an on-premises installation, you can build and prove your skills with a Microsoft SQL Server certification.

Role-based Certification Opportunity
Level:
Associate
Job Role:
Database Administrator

Microsoft Certified Associate badge

The Azure Database Administrator implements and manages the operational aspects of cloud-native and hybrid data platform solutions built on Microsoft Azure data services and Microsoft SQL Server. The Azure Database Administrator uses a variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes.

 Prerequisites
  • No prerequisites for this certification

Step 1 Take These Courses

Step 2 Take This Exam

  • Exam DP-300: Administering Relational Databases on Microsoft Azure (beta)

Step 3 Earn This Certification

  • Microsoft Certified: Azure Database Administrator Associate
Traditional MCSA/MCSE Certification Options

The certifications below will continue to be available through January 31, 2021.

This certification demonstrates your skills with database installation, maintenance, configuration, and provisioning tasks.

 Prerequisites
  • No prerequisites for this certification

Step 2 Take These Exams

  • Exam 70-764: Administering a SQL Database Infrastructure
  • Exam 70-765: Provisioning SQL Databases

Step 3 Earn This Certification

  • MCSA: SQL 2016 Database Administration

This certification demonstrates your skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments.

 Prerequisites
  • No prerequisites for this certification

Step 2 Take These Exams

  • Exam 70-461: Querying Microsoft SQL Server 2012/2014
  • Exam 70-462: Administering Microsoft SQL Server 2012/2014 Databases
  • Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

Step 3 Earn This Certification

  • MCSA: SQL Server 2012/2014

This certification demonstrates your skills as a database professional, for both on-premises and cloud-based databases.

 Prerequisites
  • No prerequisites for this certification

Step 2 Take These Exams

  • Exam 70-761: Querying Data with Transact-SQL
  • Exam 70-762: Developing SQL Databases

Step 3 Earn This Certification

  • MCSA: SQL 2016 Database Development

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

 Prerequisites
  • No prerequisites for this certification

Step 2 Take These Exams

  • Exam 70-767: Implementing a Data Warehouse using SQL
  • Exam 70-768: Developing SQL Data Models

Step 3 Earn These Certifications

  • MCSA: SQL 2016 BI Development

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.

 Prerequisites
  • To earn the MCSE: Data Management and Analytics certification, first complete a relevant MCSA certification (see above)

Step 2 Pass ONE of the following additional elective exams

  • 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-762: Developing SQL Databases
  • 70-767: Implementing a Data Warehouse using SQL
  • 70-768: Developing SQL Data Models
  • 70-777: Implementing Microsoft Azure Cosmos DB Solutions

Step 3 Earn These Certifications

  • MCSE: Data Management and Analytics

What SQL Server Topics and Technologies
Will I Learn at New Horizons Spokane?

  • Database Administration
    Learn how to create and configure databases, set up database access and security, backup and restore databases and other essential administration skills.
  • Structured Query Language / TSQL
    SQL is an acronym for "structured query language", and is the universal language used to retrieve and modify data in your database. In Microsoft SQL Server, TSQL extends structured query language with transactional capabilities to enhance database programming capabilities.
  • Database Performance and Optimization
    New Horizons Spokane provides courses that will teach you to optimize your database performance by building and maintaining indexing of your database tables, and using tools to analyze and perfect queries used by your applications.
  • Database Development
    Learn to use the many tools provided by Microsoft to design and implement your database schema, including entity relationships, foreign keys, constraints and indexing.
  • Data Warehousing
    Advanced database professionals will learn to use Microsoft SQL Server to set up and utilize data warehouses, which are central repositories of data pulled together from one or more sources for the purpose of creating analytical reports to support business decisions.
  • Business Intelligence
    With training from New Horizons Spokane, you can develop your understanding and mastery of the analysis strategies collectively known as "Business Intelligence", which make use of data warehouses: reporting, online analytical processing, analytics, data mining, process mining, complex event processing, business performance management, benchmarking, text mining, predictive analytics, and prescriptive analytics.
  • SQL Data ModelsPart of Business analysis involves the creation of data models: at New Horizons Spokane you will learn how to implement multidimensional databases and create tabular semantic data models for analysis using SQL Server Analysis Services (SSAS).