Microsoft SQL Server Training Courses

Microsoft SQL Server Training Courses

Local, instructor-led live Microsoft SQL Server (also known as MS SQL Server, or simply SQL Server) training courses demonstrate through hands-on practice the fundamentals of Microsoft SQL Server. Microsoft SQL Server training is available as "onsite live training" or "remote live training". Onsite live training can be carried out locally on customer premises in Europe or in NobleProg corporate training centers in Europe. Remote live training is carried out by way of an interactive, remote desktop. NobleProg -- Your Local Training Provider

Testimonials

★★★★★
★★★★★

Microsoft SQL Server Subcategories

Microsoft SQL Server Course Outlines

CodeNameDurationOverview
advsqlptAdvanced SQL, Stored Procedures and Triggers for Microsoft SQL Server14 hoursThe aim of this course is to provide a clear understanding of the advanced use of (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL. For more in depth coverage of the topics this course can be run as a three day course.
sqlsqlsvrSQL in SQL Server14 hoursThis SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:

- how to write SQL queries
- what relational databases are and how we can use them
- what are relations and how to create them
- the structure of data
- differences between T-SQL and other dialects
- practical skills for writing queries

This SQL course deals with Microsoft T-SQL dialect. If you are interested in generic SQL, please see SQL Fundamentals course.
transsqladvTransact SQL Advanced7 hoursDelegates will gain an understanding of some of the more advanced features of Transact SQL as well as being able to do each of the following:

- Use queries to return complex result sets
- Manage database objects to aid query performance
- Tune queries to perform more efficiently

This course is for anyone who currently uses Transact SQL to extract data from a Microsoft SQL Server database and wishes to expand their knowledge particularly in the areas of data analysis and improving query speed.
SQL100T-SQL Fundamentals with SQL Server Training Course16 hoursThis SQL training course is for people who want to acquire basic skills to deal with SQL Server Databases. Course will help the members to learn:

- How to work with SQL Server and SQL Server Management Studio.
- Meaning of Databases, SQL and RDBMS etc.
- How to create tables, use DDL, DML and DAL.
- Which are the various RDBMS Packages in the market and how they compare with each other.
- An Introduction to NoSQL and how they are organizations are changing into hybrid databases.
mssql2016MS SQL Server 201614 hoursAs a core of the Microsoft data platform, SQL Server is a leading operational database management system.
sqlmssqlserverLearning SQL with Microsoft SQL Server21 hoursMicrosoft SQL Server is a relational database management system (RDBMS) for storing and retrieving data.

In this instructor-led, live training (onsite or remote), participants will learn the essentials of the SQL language needed to query a Microsoft SQL Server database.

By the end of this training, participants will be able to:

- Install and configure Microsoft SQL Server
- Query a Microsoft SQL Server database using Microsoft's Transact-SQL (T-SQL) language
- Understand the essentials of database design
- Optimize a database through normalization
- Use aggregate functions to generate results similar to those of "pivot-tables"
- Access Microsoft SQL Server through Excel

Audience

- Data analysts
- Business Intelligence professionals
- Business managers
- Excel experts who wish to expand their analysis skill set

Format of the Course

- Interactive lecture and discussion
- Lots of exercises and practice
- Hands-on implementation in a live-lab environment

Course Customization Options

- This training is based on the latest version of Microsoft SQL Server
- To request a customized training for this course, please contact us to arrange.
poshadminAdministration with Powershell35 hoursThis intensive training provides the fundamental knowledge and skills to use Windows PowerShell for automating administration of Windows based computers. The skills taught in this course are applicable to all Microsoft products that use Windows PowerShell for daily administration.

Training focuses mainly on using Windows PowerShell as an interactive command line interface however it also includes some coverage of scripting and programming topics.
68403Introduction to SQL Server 2012 Integration Services (SSIS)28 hours
ssasBusiness Intelligence with SSAS14 hoursSSAS (SQL Server Analysis Services), is a Microsoft SQL Server transactional processing (OLAP) and data mining tool for analyzing data across multiple databases, tables or files. The semantic data models provided by SSAS are used by client applications such as Power BI, Excel, Reporting Services, and other data visualization tools.

In this instructor-led, live training (onsite or remote), participants will learn how to use SSAS to analyze large volumes of data in databases and data warehouses.

By the end of this training, participants will be able to:

- Install and configure SSAS
- Understand the relationship between SSAS, SSIS, and SSRS
- Apply multidimensional data modeling to extract business insights from data
- Design OLAP (Online Analytical Processing) cubes
- Query and manipulate multidimensional data using the MDX (Multidimensional Expressions) query language
- Deploy real-world BI solutions using SSAS

Audience

- BI (Business Intelligence) professionals
- Data Analysts
- Database and data warehousing professionals

Format of the Course

- Interactive lecture and discussion
- Lots of exercises and practice
- Hands-on implementation in a live-lab environment

Course Customization Options

- This training is based on the latest version of Microsoft SQL Server and SSAS.
- To request a customized training for this course, please contact us to arrange.

Upcoming Microsoft SQL Server Courses

CourseCourse DateCourse Price [Remote / Classroom]
Transact SQL Advanced - BrnoFri, 2018-10-12 09:301500EUR / 1900EUR
Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server - VästeråsMon, 2018-10-15 09:303000EUR / 3600EUR
Administration with Powershell - Riga, Old TownMon, 2018-10-15 09:307500EUR / 8700EUR
Introduction to SQL Server 2012 Integration Services (SSIS) - Helsinki, PohjoisesplanadiTue, 2018-10-16 09:306000EUR / 7000EUR
T-SQL Fundamentals with SQL Server Training Course - Prague, Prague CastleTue, 2018-10-16 09:304500EUR / 5100EUR
Weekend Microsoft SQL Server courses, Evening Microsoft SQL Server training, Microsoft SQL Server boot camp, Microsoft SQL Server instructor-led, Weekend Microsoft SQL Server training, Evening Microsoft SQL Server courses, Microsoft SQL Server coaching, Microsoft SQL Server instructor, Microsoft SQL Server trainer, Microsoft SQL Server training courses, Microsoft SQL Server classes, Microsoft SQL Server on-site, Microsoft SQL Server private courses, Microsoft SQL Server one on one training

Course Discounts

Course Venue Course Date Course Price [Remote / Classroom]
Business Plan building with Business Motivation Model Helsinki, Pohjoisesplanadi Thu, 2018-09-27 09:30 2700EUR / 3300EUR
Git for Users Luxembourg, Place de la Gare Fri, 2018-09-28 09:30 1350EUR / 1750EUR
OCEB Certified Expert in BPM - Technical Intermediate Exam Preparation Nicosia, Jacovides Tower Mon, 2018-10-01 09:30 3150EUR / 3750EUR
jBPM for Process Designers Helsinki, Pohjoisesplanadi Mon, 2018-10-01 09:30 6300EUR / 7300EUR
Managing Business Rules with PHP Business Rules Nicosia, Jacovides Tower Mon, 2018-10-01 09:30 3150EUR / 3750EUR
Haskell Fundamentals Luxembourg, Place de la Gare Tue, 2018-10-02 09:30 2700EUR / 3300EUR
Apache Solr - Full-Text Search Server Luxembourg, Place de la Gare Tue, 2018-10-02 09:30 2700EUR / 3300EUR
Statistical Thinking for Decision Makers Helsinki, Pohjoisesplanadi Tue, 2018-10-02 09:30 1575EUR / 1975EUR
Apache Tomcat Administration Helsinki, Pohjoisesplanadi Tue, 2018-10-02 09:30 4050EUR / 4850EUR
OCEB2 OMG Certified Expert in BPM - Fundamental Exam Preparation Helsinki, Pohjoisesplanadi Tue, 2018-10-02 09:30 6300EUR / 7300EUR
Statistical Thinking for Decision Makers Nicosia, Jacovides Tower Thu, 2018-10-04 09:30 1575EUR / 1975EUR
Business Rule Approach with SBVR Luxembourg, Place de la Gare Thu, 2018-10-04 09:30 2700EUR / 3300EUR
Business Rule Approach with SBVR Tampere Mon, 2018-10-08 09:30 2700EUR / 3300EUR
jBPM for Developers Brno Mon, 2018-10-08 09:30 7875EUR / 9075EUR
Apache Tomcat Administration Brno Tue, 2018-10-09 09:30 4050EUR / 4850EUR
MongoDB for Developers Brno Tue, 2018-10-09 09:30 2700EUR / 3300EUR
OCEB2 OMG Certified Expert in BPM - Business Intermediate Exam Preparation Brno Tue, 2018-10-09 09:30 4725EUR / 5525EUR
Business Rule Management (BRMS) with Drools Luxembourg, Place de la Gare Wed, 2018-10-10 09:30 1575EUR / 1975EUR
jBPM for Developers Vaduz, Oberland Mon, 2018-10-15 09:30 7875EUR / 9075EUR
Haskell Fundamentals Tampere Mon, 2018-10-15 09:30 2700EUR / 3300EUR
MediaWiki for Developers Tampere Mon, 2018-10-15 09:30 4050EUR / 4850EUR
OCEB Certified Expert in BPM - Business Advanced Exam Preparation Luxembourg, Place de la Gare Mon, 2018-10-15 09:30 1575EUR / 1975EUR
MoDAF/NAF Introduction Tampere Mon, 2018-10-15 09:30 1575EUR / 1975EUR
Business Process Modelling in BPMN 2.0 Vantaa Mon, 2018-10-15 09:30 4725EUR / 5525EUR
Agile Software Testing Luxembourg, Place de la Gare Tue, 2018-10-16 09:30 2700EUR / 3300EUR
Advanced Haskell Luxembourg, Place de la Gare Tue, 2018-10-16 09:30 2700EUR / 3300EUR
Apache Spark Helsinki, Pohjoisesplanadi Tue, 2018-10-16 09:30 2700EUR / 3300EUR
OCEB Certified Expert in BPM - Technical Advanced Exam Preparation Brno Tue, 2018-10-16 09:30 1575EUR / 1975EUR
IoT ( Internet of Things) for Entrepreneurs, Managers and Investors Ostrava Wed, 2018-10-17 09:30 4725EUR / 5525EUR
Apache Solr - Full-Text Search Server Helsinki, Pohjoisesplanadi Thu, 2018-10-18 09:30 2700EUR / 3300EUR
MoDAF/NAF Introduction Prague, Prague Castle Fri, 2018-10-19 09:30 1575EUR / 1975EUR
OCEB Certified Expert in BPM - Business Advanced Exam Preparation Ostrava Tue, 2018-10-23 09:30 1575EUR / 1975EUR
Docker for Developers and System Administrators Prague, Prague Castle Wed, 2018-10-24 09:30 2700EUR / 3300EUR
Business Process Modelling in BPMN 2.0 Prague, Prague Castle Wed, 2018-10-24 09:30 4725EUR / 5525EUR
Drupal and Solr Ostrava Wed, 2018-10-24 09:30 2700EUR / 3300EUR
Neural Network in R Vantaa Mon, 2018-10-29 09:30 3150EUR / 3750EUR
OCEB Certified Expert in BPM - Technical Intermediate Exam Preparation Luxembourg, Place de la Gare Tue, 2018-11-06 09:30 3150EUR / 3750EUR
Node.js for JavaScript Developers Tampere Tue, 2018-11-13 09:30 4050EUR / 4850EUR
Cloud Computing Overview Luxembourg, Place de la Gare Wed, 2018-11-14 09:30 1350EUR / 1750EUR
Business Rule Management (BRMS) with Drools Ostrava Wed, 2018-11-14 09:30 1575EUR / 1975EUR
jBPM for Developers Ostrava Mon, 2018-11-19 09:30 7875EUR / 9075EUR
Managing Business Rules with PHP Business Rules Vaduz, Oberland Mon, 2018-11-19 09:30 3150EUR / 3750EUR
Business Plan building with Business Motivation Model Prague, Prague Castle Tue, 2018-11-20 09:30 2700EUR / 3300EUR
Introduction to R Tampere Tue, 2018-11-20 09:30 4725EUR / 5525EUR
Business Process Modelling in BPMN 2.0 Luxembourg, Place de la Gare Wed, 2018-11-21 09:30 4725EUR / 5525EUR
Statistical Thinking for Decision Makers Helsinki, Pohjoisesplanadi Wed, 2018-11-21 09:30 1575EUR / 1975EUR
Git for Users Luxembourg, Place de la Gare Fri, 2018-11-23 09:30 1350EUR / 1750EUR
Ubuntu Server Overview Prague, Prague Castle Fri, 2018-11-23 09:30 1350EUR / 1750EUR
OCEB2 OMG Certified Expert in BPM - Business Intermediate Exam Preparation Vantaa Mon, 2018-11-26 09:30 4725EUR / 5525EUR
Node.js for JavaScript Developers Helsinki, Pohjoisesplanadi Tue, 2018-11-27 09:30 4050EUR / 4850EUR
Neural Network in R Luxembourg, Place de la Gare Wed, 2018-11-28 09:30 3150EUR / 3750EUR
Administering and Optimizing HipHop Virtual Machine (HHVM) Luxembourg, Place de la Gare Wed, 2018-11-28 09:30 2700EUR / 3300EUR
Business Process Modelling in BPMN 2.0 Ostrava Wed, 2018-11-28 09:30 4725EUR / 5525EUR
Apache Solr - Full-Text Search Server Luxembourg, Place de la Gare Thu, 2018-11-29 09:30 2700EUR / 3300EUR
One Day Workshop for PEAP Authentication of Windows 7 Supplicant using a Cisco Switch as Authenticator and Windows 2008 R2 Server Prague, Prague Castle Thu, 2018-11-29 09:30 1350EUR / 1750EUR
Statistical Thinking for Decision Makers Prague, Prague Castle Thu, 2018-11-29 09:30 1575EUR / 1975EUR
OCEB Certified Expert in BPM - Business Advanced Exam Preparation Prague, Prague Castle Mon, 2018-12-03 09:30 1575EUR / 1975EUR
Managing Business Rules with PHP Business Rules Prague, Prague Castle Mon, 2018-12-03 09:30 3150EUR / 3750EUR
Business Process Modelling in BPMN 2.0 Tampere Mon, 2018-12-03 09:30 4725EUR / 5525EUR
IoT ( Internet of Things) for Entrepreneurs, Managers and Investors Vantaa Wed, 2018-12-05 09:30 4725EUR / 5525EUR
Docker for Developers and System Administrators Brno Tue, 2018-12-11 09:30 2700EUR / 3300EUR
Neural Network in R Brno Tue, 2018-12-11 09:30 3150EUR / 3750EUR
OCEB2 OMG Certified Expert in BPM - Business Intermediate Exam Preparation Luxembourg, Place de la Gare Wed, 2018-12-12 09:30 4725EUR / 5525EUR
Advanced Lua Luxembourg, Place de la Gare Thu, 2018-12-13 09:30 2700EUR / 3300EUR
Business Rule Approach with SBVR Vantaa Thu, 2018-12-13 09:30 2700EUR / 3300EUR
OCEB Certified Expert in BPM - Business Advanced Exam Preparation Luxembourg, Place de la Gare Fri, 2018-12-14 09:30 1575EUR / 1975EUR
jBPM for Process Designers Luxembourg, Place de la Gare Mon, 2018-12-17 09:30 6300EUR / 7300EUR
MongoDB for Developers Tampere Mon, 2018-12-17 09:30 2700EUR / 3300EUR
Programming with Big Data in R Luxembourg, Place de la Gare Mon, 2018-12-17 09:30 4725EUR / 5525EUR
Introduction to R Luxembourg, Place de la Gare Mon, 2018-12-17 09:30 4725EUR / 5525EUR
IoT ( Internet of Things) for Entrepreneurs, Managers and Investors Prague, Prague Castle Tue, 2018-12-18 09:30 4725EUR / 5525EUR
Neural Network in R Vantaa Thu, 2018-12-20 09:30 3150EUR / 3750EUR
Hadoop for Data Analysts Ostrava Thu, 2018-12-27 09:30 2700EUR / 3300EUR
OCEB Certified Expert in BPM - Technical Intermediate Exam Preparation Luxembourg, Place de la Gare Thu, 2018-12-27 09:30 3150EUR / 3750EUR
Advanced Lua Vaduz, Oberland Mon, 2019-02-04 09:30 2700EUR / 3300EUR

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in your region!

As a Business Development Manager you will:

  • expand business in the region
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

contact us right away!