SQL Training in Aveiro

SQL serves as a standardized language designed to query, manipulate, and manage data within relational database systems.

This instructor-led, live training (available online or onsite) is tailored for users ranging from beginner to advanced levels who aim to construct efficient SQL queries and work confidently with relational databases.

Upon completion of this training, participants will acquire the skills to:

• Construct SQL queries to retrieve, filter, and sort data.
• Manipulate data through insert, update, and delete operations.
• Create joins, subqueries, and aggregated reports.
• Apply advanced SQL techniques for real-world data analysis.

Format of the Course

• Instructor-led lectures combined with guided discussions.
• Hands-on query building and practical exercises.
• Live-lab demonstrations using real datasets.

Course Customization Options

• If you require a tailored SQL program for your organization, please contact us to arrange.

AI for SQL refers to the application of artificial intelligence and large language models (LLMs) to automate, optimize, and improve how SQL queries are generated, executed, and interpreted within enterprise data environments.

This instructor-led, live training (available online or onsite) targets intermediate-level data engineers and technical leads who wish to integrate AI capabilities into SQL workflows to enable natural language querying, intelligent optimization, and automated data analysis.

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

• Integrate LLMs such as GPT, DeepSeek, LLaMA, Qwen, and Mistral into SQL environments.
• Build natural-language-to-SQL pipelines for conversational data access.
• Implement AI-driven query optimization and error detection.
• Design secure, auditable AI-SQL workflows for enterprise use.

Format of the Course

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

Course Customization Options

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

SQL serves as a robust tool for managing and analyzing structured data within relational databases.

This instructor-led training, available both online and onsite, is designed for intermediate users looking to enhance their SQL capabilities for handling complex queries, data manipulation, and performance optimization.

Upon completion of this training, participants will gain the ability to:

• Compose intricate SQL queries by utilizing advanced joins and subqueries.
• Manage data effectively through INSERT, UPDATE, and DELETE operations.
• Apply window functions to conduct advanced analytics.
• Enhance query performance through optimization techniques.

Course Structure

• Engaging lectures and interactive discussions.
• Extensive practical exercises and drills.
• Practical application within a live laboratory environment.

Customization Opportunities

• For tailored training solutions, please reach out to us to discuss your specific needs.

SQL serves as the standard language for accessing and manipulating databases.

This instructor-led live training, available online or on-site, is designed for beginners who want to grasp the fundamentals of SQL for data querying and reporting.

Upon completing this training, participants will be able to:

• Comprehend the structure of relational databases.
• Compose basic SQL statements to retrieve, filter, and sort data.
• Utilize aggregate functions to summarize data.
• Execute basic joins between multiple tables.

Course Format

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

Course Customization Options

• To arrange customized training for this course, please contact us.

This instructor-led, live training in Aveiro (online or onsite) is designed for beginner to intermediate-level data analysts, database professionals, and software developers who wish to learn SQL for effective database management.

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

• Grasp and utilize core SQL commands and queries.
• Construct and manipulate tables and databases.
• Employ SQL to sort, filter, and summarize data.
• Execute more complex operations, including joins, subqueries, and set operations.
• Apply intermediate techniques such as indexes, views, stored procedures, and triggers.

This instructor-led live training in Aveiro (online or onsite) is designed for intermediate-level database administrators, SQL developers, and data analysts who wish to enhance their SQL skills by mastering the use of Analytic Functions.

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

• Understand the concept and importance of Analytic Functions.
• Apply various Analytic Functions to solve complex analytical problems.
• Combine Analytic Functions with other SQL features for comprehensive data analysis.
• Optimize queries for better performance using Analytic Functions.

This instructor-led, live training in Aveiro (online or onsite) is designed for data scientists and developers who wish to utilise and integrate SQL, Python, and Tableau to perform complex data analysis, processing, and visualisation.

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

• Configure the required environment to perform data analysis using SQL, Python, and Tableau.
• Grasp the core concepts of software integration, including data, servers, clients, APIs, and endpoints.
• Review the fundamental principles of Python and SQL.
• Apply data pre-processing techniques within Python.
• Establish connections between Python and SQL for effective data analysis.
• Produce insightful data visualisations and charts using Tableau.

This SQL training course is designed for individuals seeking to acquire the essential skills required to extract and analyse data using Microsoft Access. Participants will learn:

• how to write SQL queries
• the concept of relational databases and their practical application
• the nature of relations and how to establish them
• the fundamental structure of data
• the distinctions between SQL dialects (Oracle, T-SQL, ANSI)
• practical techniques for composing queries

This SQL course specifically addresses the SQL dialect used in Microsoft Access.

This SQL training course is designed for individuals seeking to acquire the essential skills required to extract, analyse, and report data from any database. Participants will master:

• writing SQL queries
• the concept of relational databases and their practical applications
• the nature of relations and methods for creating them
• data structure fundamentals
• distinctions between T-SQL and other SQL dialects
• hands-on techniques for constructing queries

This course focuses on the Microsoft T-SQL dialect. For those interested in generic SQL, we recommend our SQL Fundamentals course.

• How to build a query?
• What is a relational database?
• What is the structure and SQL commands?

This instructor-led, live training in Aveiro (online or onsite) is aimed at intermediate-level database administrators, developers, and analysts who wish to master advanced SQL functionalities for complex data operations and database management.

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

• Execute advanced querying techniques using unions, subqueries, and complex joins.
• Add, update, and delete data, tables, views, and indexes with precision.
• Ensure data integrity through transactions and manipulate database structures.
• Create and manage databases efficiently for robust data storage and retrieval.

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.

Participants will acquire a solid understanding of the fundamental principles of Structured Query Language, along with the ability to perform the following tasks:

• Formulate queries to extract and filter data from a SQL Server database
• Generate summarized results
• Transform, derive, and format data to meet specific output requirements
• Modify data and manage database components and definitions

This course is designed for anyone who requires access to information within a Microsoft SQL Server database. It is suitable for system developers as well as professionals from other departments who need to utilize SQL to extract and analyze data.

Designed for individuals with prior SQL experience, this course delves into universal SQL database principles alongside MySQL-specific syntax, functions, and capabilities.

In this instructor-led, live training in Aveiro, participants will explore three distinct methodologies for accessing, analysing, and visualising data. The session begins with an introduction to RDMS databases, focusing on accessing and querying an Oracle database using SQL. Next, we examine strategies for programmatically accessing an RDMS database via Python. Finally, we cover how to visualise and present data graphically using TIBCO Spotfire.

Format of the Course
Interactive lecture and discussion.
Extensive exercises and practice.
Hands-on implementation in a live-lab environment.

Course Format

• Interactive lectures accompanied by group discussions.
• Extensive practical exercises and hands-on practice.
• Live laboratory sessions for direct implementation.

This course aims to provide a comprehensive understanding of SQL usage across various databases (such as Oracle, SQL Server, and MS Access). Gaining insight into analytic functions and techniques for joining different tables within a database will enable participants to shift data analysis operations to the database layer, rather than relying on MS Excel. This knowledge is also valuable for developing any IT system that utilizes relational databases.

This SQL training programme is designed for individuals seeking to acquire the essential skills to extract, analyse, and report on data from any database. Participants will learn:

• how to write SQL queries
• what relational databases are and how to utilise them
• the concept of relations and how to establish them
• the structure of data
• differences between SQL dialects (Oracle, T-SQL, ANSI)
• practical skills for writing queries

This SQL course focuses on generic ANSI SQL, making it applicable to any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL, and other relational databases.

This live, instructor-led training in Aveiro (online or onsite) is aimed at beginners, programmers, and database administrators who wish to learn or improve their SQL development skills and knowledge.

By the end of this training, participants will be able to install, create, manage, manipulate, and monitor databases using SQL and database management systems.

Key Questions Addressed by the Course

• How to construct a query?
• What capabilities does SQL offer?
• What defines a relational database?
• What is the structure and the set of SQL commands?