Get in Touch

Lisbon Airport Business Center

NobleProg Lisboa, Avenue of the Portuguese Communities, Lisbon, portugal, 1700-007

Our venue is located on the heart of Lisbon, well connected by public transportation and well served with parking locations on the surrounding area. Our rooms are equipped with high technology accessories, which will enable you to learn well during your training course.

Eurostars Cascais Hotel

35-35A, Travessa da Republica, 35 -35A Cascais 2750-475 Portugal, Cascais, Portugal, 2750-475 Portugal

Eurostars Cascais 4* is able to host all kinds of meetings and events. It has 4 different multifunctional rooms with natural light and access to the garden area of the swimming pool. The rooms have the latest technology, including: soundproof doors with peepholes, customisable signage for businesses and a slide projecto

Hotel Real Oeiras

nº5, R. Álvaro Rodrigues de Azevedo nº 5, 2770-197 Paço de Arcos, Paço de Arcos, Portugal, 2770-197 Paço de Arcos

With a privileged location near the business hubs of Oeiras, such as Lagoas Park, Tagus Park, and Quinta da Fonte, the Hotel Real Oeiras is a 4-star hotel that offers all the conditions to organize all types of meetings and social events. Whether it’s a business meeting, a congress, a business event, a social event, a dinner or a private lunch, a marriage, a baptism, an anniversary party or even if it’s an amusing child anniversary, the 8 multipurpose rooms are the ideal option. With every room having natural light and direct access to the outdoor swimming pool and to the surrounding green areas, this hotel is the perfect choice to make your event memorable.

Mercure Lisboa Almada

9, Rua Abel Salazar, 9, PRAGAL 2805-313 ALMADA, Almada, Portugal, 2805-313 Almada

"A perfect getaway about 30 minutes from Lisbon". Disconnect from the world and discover the Mercure Lisboa Almada Hotel. This 4-star hotel set in a green zone overlooks the Tagus River and the mythical Cristo Rei. A short drive away, relax on beautiful Costa da Caparica beaches. There is a modern restaurant with a wide variety of natural fruit juices and mocktails, plus 4 fully equipped meeting rooms.
NobleProg Training Place, City Vila Galé Sintra Resort Hotel, Conference & SPA

Vila Galé Sintra Resort Hotel, Conference & SPA

nº30, Rua Fonte da Granja, nº 30 2710-652 Sintra, Sintra, Portugal, 2710-652 Sintra

Located in broad Várzea de Sintra, surrounded by green areas and with a breathtaking view of the Pena Palace, the Vila Galé Sintra Resort Hotel, Conference & Spa hotel has the ideal space for your business meetings. Having you and your company in mind, it offers rooms for meetings, congresses or team building actions, but also adaptable to other event types. We have the right solutions to provide memorable moments.

Subcategories (2)

SSAS

SSAS
SSIS

SSIS

Explore Our Courses

SQL Server Management Studio (SSMS) Administration

 21 Hours

This instructor-led, live training in Lisbon (online or onsite) is aimed at intermediate-level database administrators who wish to learn the necessary skills and knowledge to effectively manage and administer SQL Server databases using SQL Server Management Studio.

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

  • Understand system requirements and perform installations.
  • Create, configure, and manage databases using SSMS.
  • Manage logins, users, roles, and permissions.
  • Perform various types of backups and restore databases.
  • Create, schedule, and manage jobs using SQL Server Agent.
  • Implement best practices for efficient and secure SQL Server administration.
Read more...

Microsoft SQL Server Database Administration

 40 Hours

SQL Server is Microsoft’s enterprise-grade relational database management system, engineered for the efficient storage, management, and retrieval of data.

This instructor-led live training (available online or onsite) is tailored for IT professionals at an intermediate level who aim to administer, configure, and maintain SQL Server environments.

Upon completion of this training, participants will be able to:

  • Install and configure SQL Server environments.
  • Manage databases, users, and permissions.
  • Monitor performance and troubleshoot issues.
  • Automate tasks using jobs and maintenance plans.

Course Format

  • Interactive lectures and discussions.
  • Ample exercises and practical practice.
  • Hands-on implementation within a live-lab environment.

Customization Options

  • To request a customized training version of this course, please contact us to arrange.
Read more...

Microsoft SQL Server for Database Administrators: Intermediate to Advanced

 28 Hours

This instructor-led, live training in Lisbon (online or onsite) is aimed at intermediate-level to advanced-level database administrators who wish to deepen their knowledge of SQL Server for efficient database management, performance tuning, high availability, and advanced troubleshooting.

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

  • Administer and configure SQL Server instances using best practices.
  • Optimize performance of queries and databases.
  • Implement high availability and disaster recovery strategies.
  • Diagnose and resolve complex issues in production environments.
Read more...

SQL Server 2022 Integration Services (SSIS) – Data Flows and Advanced Transformations

 14 Hours

SQL Server Integration Services (SSIS) is a core component of Microsoft SQL Server, providing a robust platform for data integration and workflow applications. It is widely utilized for data migration, data warehousing, and transformation tasks.

This instructor-led live training, available either online or onsite, is designed for intermediate-level data professionals and developers aiming to master the design of advanced SSIS data flows and transformations, as well as the management of Slowly Changing Dimensions (SCD) within data warehousing contexts.

Upon completion of this training, participants will be equipped to:

  • Design and implement resilient data flows using SSIS.
  • Interact with diverse data sources, destinations, and transformation components.
  • Apply Slowly Changing Dimensions (SCD) to manage historical data changes effectively.
  • Deploy, execute, and troubleshoot SSIS packages with efficiency.

Course Format

  • Interactive lectures and discussions.
  • Extensive exercises and practical practice.
  • Hands-on implementation within a live-lab environment.

Course Customization Options

  • To request a customized training session for this course, please contact us to arrange.
Read more...

Visual Studio for PLC Communication and Database Integration

 21 Hours

This instructor-led, live training in Lisbon (available online or in-person) is designed for intermediate software developers and automation engineers who aim to build applications that communicate with PLCs and interact with SQL databases using Visual Studio.

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

  • Develop .NET applications in Visual Studio for industrial automation.
  • Communicate with PLCs using industrial protocols such as OPC UA.
  • Implement database interactions with SQL Server for storing and retrieving PLC data.
  • Optimize application performance for real-time industrial environments.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led live training in Lisbon (online or onsite) is aimed at beginner-level data professionals who wish to learn how to design, implement, and manage SSIS packages to perform data integration and transformation tasks.

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

  • Understand the architecture and components of SSIS.
  • Design and implement ETL processes using SSIS.
  • Use SSIS tools to develop, deploy, and manage data integration solutions.
  • Troubleshoot and optimize SSIS packages for performance and reliability.
Read more...

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

 14 Hours

Mastering advanced Transact-SQL within Microsoft SQL Server unleashes the full potential of enterprise database automation. This course explores essential development constructs, including procedural programming, structured error handling, transaction management, cursor operations, stored procedures, and database triggers. It empowers seasoned developers to design complex backend data processes, minimize application-layer overhead, and deliver robust, production-ready solutions for critical enterprise database applications.

Read more...

Transact SQL Advanced

 7 Hours

Participants will develop a solid understanding of several advanced Transact SQL capabilities, alongside gaining the ability to perform the following tasks:

  • Employ queries to retrieve complex result sets
  • Manage database objects to enhance query performance
  • Optimize queries for greater efficiency

This course is designed for individuals who currently utilise Transact SQL to extract data from a Microsoft SQL Server database and wish to broaden their expertise, particularly regarding data analysis and improving query speed.

Read more...

T-SQL Fundamentals with SQL Server Training Course

 14 Hours

This SQL training course is designed for individuals seeking to acquire foundational skills for managing SQL Server databases. Participants will learn:

  • How to interact with SQL Server and SQL Server Management Studio.
  • The concepts behind databases, SQL, and RDBMS.
  • Techniques for creating tables and utilizing DDL, DML, and DCL.
  • Various RDBMS products available in the market and their comparative advantages.
  • An introduction to NoSQL and how organizations are transitioning to hybrid database architectures.
Read more...

Administering in Microsoft SQL Server

 21 Hours

This course is tailored for system administrators, developers, and database professionals.

Training Objectives:

  • Gain and reinforce the skills necessary to create and manage databases
  • Understand SQL syntax and apply it to retrieve and modify data
  • Implement security protocols within the database environment
  • Utilize advanced features such as replication, automation, and Business Intelligence (BI)
  • Leverage Microsoft SQL Server capabilities to develop complex reports and solutions for developers
Read more...

Microsoft SQL Server (MSSQL)

 14 Hours

Designed for delegates who already possess familiarity with SQL within the Microsoft SQL Server 2008/2012 environment, this course concentrates on set-based querying and query tuning. Key areas of study include working with indexes and analyzing execution plans.

Additionally, the training covers table expressions, ranking functions, and techniques for handling partitioned tables.

Read more...

SQL language in MSSQL

 14 Hours

Developing efficient SQL queries for Microsoft SQL Server forms the bedrock of every enterprise data pipeline. This course explores core techniques, beginning with relational database models, and advancing through data retrieval, filtering, sorting, and aggregation using grouping functions and subqueries. It guides participants through multi-table joins, set operators, DML operations, and transaction control to reliably extract and manipulate business intelligence datasets.

Read more...

Learning SQL with Microsoft SQL Server

 21 Hours

Microsoft SQL Server serves as a robust relational database management system (RDBMS) designed for efficient data storage and retrieval.

Through this instructor-led live training, available either onsite or remotely, attendees will acquire the fundamental SQL skills necessary to effectively query Microsoft SQL Server databases.

Upon completion of this course, participants will be equipped to:

  • Install and configure Microsoft SQL Server
  • Execute queries on a Microsoft SQL Server database using the Transact-SQL (T-SQL) language
  • Grasp the core principles of database design
  • Enhance database performance through normalization
  • Utilize aggregate functions to generate results comparable to those produced by pivot tables
  • Connect to Microsoft SQL Server directly from Excel

Target Audience

  • Data analysts
  • Business Intelligence specialists
  • Business managers
  • Excel specialists looking to broaden their analytical capabilities

Course Structure

  • Interactive lectures and group discussions
  • Extensive practical exercises and hands-on practice
  • Live implementation within a lab environment

Customization Options

  • This training utilizes the most recent version of Microsoft SQL Server
  • For inquiries regarding customized training arrangements, please contact us directly.
Read more...

Business Intelligence with SSAS

 14 Hours

SSAS (SQL Server Analysis Services) is a Microsoft SQL Server tool designed for Online Analytical Processing (OLAP) and data mining, enabling the analysis of data across multiple databases, tables, or files. The semantic data models provided by SSAS serve as a foundation for client applications such as Power BI, Excel, Reporting Services, and various data visualization tools.

In this instructor-led live training (available onsite or remotely), participants will learn how to utilize SSAS to analyze large volumes of data stored 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.
Read more...

Last Updated:

Testimonials (5)

data was personalised to our organisations

Vincent Long - ASSMANG PTY LTD

Course - T-SQL Fundamentals with SQL Server Training Course

personalised to our understanding and data

Vincent Long - ASSMANG PTY LTD

Course - Business Intelligence with SSAS

The instructor brought his A game again as he superbly took my staff through the customized training with expert timing, knowledge, support, and rapport with my staff.

James - Shawnee Mission School District

Course - Administering in Microsoft SQL Server

The lecture about cte

Glyssa Mae - Metropolitan Bank and Trust Company

Course - Transact SQL Advanced

Lot of content and exactly the requested one.

Pascal - Diehl

Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Provisional Upcoming Courses (Contact Us For More Information)

SQL Server 2022 Integration Services (SSIS) – Data Flows and Advanced Transformations

2026-07-22 09:30
14 hours
Lisbon Airport Business Center

Introduction to SQL Server 2022 Integration Services (SSIS)

2026-08-05 09:30
28 hours
Lisbon Airport Business Center

Business Intelligence with SSAS

2026-08-19 09:30
14 hours
Lisbon Airport Business Center

Business Intelligence with SSAS

2026-09-02 09:30
14 hours
Lisbon Airport Business Center

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-09-16 09:30
14 hours
Lisbon Airport Business Center

Other regions in Portugal

Other Countries

These courses are also available in other countries
Online SQL Server training in Lisbon, SQL Server training courses in Lisbon, Weekend SQL Server courses in Lisbon, Evening SQL Server training in Lisbon, Microsoft SQL Server instructor-led in Lisbon, Microsoft SQL Server classes in Lisbon, MS SQL Server instructor-led in Lisbon, Weekend MS SQL Server training in Lisbon, Online Microsoft SQL Server training in Lisbon, Microsoft SQL Server private courses in Lisbon, Microsoft SQL Server instructor in Lisbon, Microsoft SQL Server on-site in Lisbon, Evening MS SQL Server courses in Lisbon, SQL Server trainer in Lisbon, Microsoft SQL Server coaching in Lisbon, MS SQL Server one on one training in Lisbon, MS SQL Server boot camp in Lisbon