Microsoft SQL Server Training from New Horizons

Microsoft SQL Server Microsoft SQL Server
Notice

No data available.

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

Gain deeper insights into your data. Take advantage of advanced analytics and present rich visualizations on any mobile device or workstation. Microsoft SQL Server delivers mission-critical capabilities with native in-memory performance and operational analytics.

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 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, 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 Models

Part of Business analysis involves the creation of data models. At New Horizons you will learn how to implement multidimensional databases and create tabular semantic data models for analysis using SQL Server Analysis Services (SSAS).

Microsoft SQL Server delivers a complete database platform for both Azure cloud and on-premises applications, enabling you to easily build, deploy and manage solutions in either environment, or that spans both.
Login