Available in both online and onsite formats, these instructor-led live courses provide practical, hands-on guidance on mastering the fundamentals of Microsoft SQL Server (commonly referred to as MS SQL Server or simply SQL Server).
You can choose between online live training, often called remote live training, which utilizes an interactive remote desktop connection, or onsite live training conducted directly at your customer premises in Gaia or at NobleProg's dedicated corporate training centers in Gaia.
NobleProg -- Your Local Training Provider
Holiday Inn Porto - Gaia
220, Rua Diogo Macedo, 220, Vila Nova de Gaia 4400-107 , Gaia, Portugal
From Porto by Metro
If you're coming from Porto city centre:
Take the Metro Line D (yellow line) toward Vila d’Este.
Get off at João de Deus.
From João de Deus, walk about 13 minutes to: Rua Diogo Macedo 220, 4400-107 Vila Nova de Gaia.
From Vila Nova de Gaia train station
If by “local train station” you mean Vila Nova de Gaia-Devesas:
The address is approximately 12 minutes walking from Vila Nova de Gaia station according to the accommodation's location information.
You can therefore walk directly rather than taking the metro.
This instructor-led, live training in Gaia (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.
This instructor-led, live training in Gaia focuses on essential SQL Server administration capabilities. Participants will acquire the skills to install and configure environments, manage database assets, and oversee performance. It is ideal for IT professionals seeking practical experience in automation and troubleshooting.
This instructor-led, live training in Gaia (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.
This instructor-led training in Gaia emphasizes the creation of advanced SSIS data flows and transformations. Learners will gain proficiency in managing Slowly Changing Dimensions, processing complex data sources, and deploying high-performance packages to support efficient data warehousing and migration workflows.
This instructor-led, live training in Gaia (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.
This instructor-led live training in Gaia (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.
This advanced course in Gaia focuses on stored procedures, triggers, and error management for Microsoft SQL Server. It equips developers to create intricate, production-grade database solutions, utilizing efficient transaction control and procedural logic suitable for enterprise environments.
This advanced Transact SQL course in Gaia empowers participants to manage complex result sets and optimize database performance. It covers analytical functions, index management, query tuning, and fundamental data warehouse techniques for Microsoft SQL Server.
Develop a strong command of T-SQL fundamentals in this practical course held in Gaia. You will learn to navigate SQL Server Management Studio, construct tables using DDL and DML, and formulate advanced queries employing joins and subqueries. This programme is ideally suited for beginners aiming to acquire core database competencies and gain hands-on experience with contemporary relational systems.
In Gaia, this programme empowers administrators to manage SQL Server with confidence. Participants will gain proficiency in database creation, SQL syntax for data manipulation, and essential security protocols. Furthermore, the curriculum explores advanced features such as replication, automation, and BI, enabling the construction of complex, real-world solutions.
This instructor-led course in Gaia is tailored for participants already familiar with SQL Server. It concentrates on set-based querying, query tuning, index management, and execution plan analysis. Learners will develop expertise in table expressions, ranking functions, and the optimization of partitioned tables.
This programme is tailored to offer a comprehensive mastery of the advanced SQL syntax and methodologies available within Microsoft SQL Server. By acquiring proficiency in analytical functions, table joins, subqueries, and aggregation strategies, learners will gain the capability to shift data analysis workflows from MS Excel directly into the database layer. This transition not only enhances operational efficiency but also facilitates the construction of robust IT systems built upon Microsoft SQL Server.
This practical SQL workshop in Gaia focuses on efficient query construction for Microsoft SQL Server. It examines relational models, data retrieval, filtering, and aggregation. Learners gain proficiency in multi-table joins, subqueries, and DML operations, enabling them to manipulate business intelligence datasets with precision and reliability.
This instructor-led training in Gaia covers the essentials of SQL with Microsoft SQL Server, helping participants master querying, database design, and normalization. Through hands-on exercises, learners will gain practical skills in T-SQL to optimize data and connect seamlessly with Excel.
This practical training in Gaia delves into SQL Server Analysis Services for advanced BI and data modeling. Participants will acquire the skills to design OLAP cubes, utilize MDX queries, and deploy robust solutions, gaining the practical expertise necessary to drive data-driven decision-making for contemporary business operations.
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)
Online MS SQL Server training in Gaia, MS SQL Server training courses in Gaia, Weekend MS SQL Server courses in Gaia, Evening MS SQL Server training in Gaia, Microsoft SQL Server instructor-led in Gaia, Weekend MS SQL Server training in Gaia, Microsoft SQL Server coaching in Gaia, Microsoft SQL Server private courses in Gaia, MS SQL Server trainer in Gaia, SQL Server instructor in Gaia, Evening MS SQL Server courses in Gaia, MS SQL Server boot camp in Gaia, Microsoft SQL Server classes in Gaia, MS SQL Server on-site in Gaia, MS SQL Server one on one training in Gaia, Online Microsoft SQL Server training in Gaia, MS SQL Server instructor-led in Gaia
