Develop your Microsoft SQL Server skills and prepare for SQL Database Certification with
training from New Horizons South Florida.
SQL Server Courses Scheduled Soon
What SQL Server Topics and Technologies
Will I Learn at New Horizons South Florida?
- 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 South Florida 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 South Florida, 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 South Florida you will learn how to implement multidimensional databases and create tabular semantic data models for analysis using SQL Server Analysis Services (SSAS).