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.
What SQL Server Topics and Technologies
Will I Learn at New Horizons?
- 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 ModelsPart 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.