Whether delivered online or in-person, our instructor-led live Microsoft SQL Server (also known as MS SQL Server, or simply SQL Server) training programs emphasize practical, hands-on experience to master the core capabilities of Microsoft SQL Server.
These Microsoft SQL Server courses are available as either "online live training" or "onsite live training." The online live option (also referred to as "remote live training") is conducted through an interactive remote desktop connection. Alternatively, onsite live training can be hosted directly at your customer premises in Nantes or within NobleProg’s corporate training facilities in Nantes.
NobleProg -- Your Local Training Provider
Nantes, Zenith
NobleProg Nantes, 4 rue Edith Piaf, Saint-Herblain, france, 44821
In the Parc d'Ar Mor zone, near the Zénith.
Car : from the ring road, Porte de Chézine Exit> Boulevard du Zenith > Esplanade Georges Brassens (restaurants) > Rue Edith Piaf on the right. From the N444 road (Nantes > Lorient), Exit #1 > boulevard Marcel Paul > Rue Edith Piaf at the right.
Parking Zénith P1 (free). Once parked, you can recognize the building: it's one of the tree bulding with zinc frontage.
Bicycle: free indoor parking
Public transport :
Tramway R1, Schoelcher station + 10 mn by foot through commercial center Atlantis
Tramway R1, François Mitterrand stop + bus 50, stop at Saulzaie station or bus 71, stop at the Zénith station
Tramway R3, Marcel Paul station + bus 50, Saulzaie station
Chronobus C6, Hermeland station+ bus 71, Zénith station
Bus : lignes 50 (Saulzaie station) or 71 (Zénith station)
This instructor-led live training in Nantes (online or onsite) is targeted at intermediate-level database administrators who wish to acquire 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 live, instructor-led program in Nantes focuses on essential SQL Server administrative competencies. Learners will gain proficiency in installing and configuring environments, overseeing database management, and tracking performance. It is perfectly suited for IT professionals seeking practical experience in automation and troubleshooting.
This instructor-led, live training in Nantes (online or onsite) is designed for intermediate to advanced 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 program on Nantes specializes in the creation of advanced SSIS data flows and transformations. Learners will gain proficiency in implementing Slowly Changing Dimensions, managing complex data sources, and deploying robust packages to streamline data warehousing and migration initiatives.
This instructor-led live training in Nantes (online or onsite) targets intermediate-level software developers and automation engineers seeking 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 Nantes (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 SQL training for Nantes focuses on stored procedures, triggers, and error management within Microsoft SQL Server. It assists developers in constructing complex, production-ready database architectures that utilize efficient transaction control and procedural logic to meet enterprise demands.
This advanced Transact SQL course in Nantes empowers participants to manage complex result sets and optimize database performance. It encompasses analytical functions, index administration, query optimization, and fundamental data warehousing methods for Microsoft SQL Server.
Develop proficiency in T-SQL through this practical course in Nantes. Participants will learn to navigate SQL Server Management Studio, construct tables using DDL and DML, and formulate sophisticated queries utilizing joins and subqueries. This program is perfectly suited for beginners looking to establish a solid foundation in database skills and gain hands-on experience with contemporary relational systems.
In Nantes, this training equips administrators with the skills to manage SQL Server with precision. Participants will master database creation, SQL syntax for data manipulation, and essential security protocols. The curriculum also delves into advanced features such as replication, automation, and BI to facilitate the development of sophisticated, real-world solutions.
This instructor-led Nantes course is tailored for individuals with existing SQL Server experience. It emphasizes set-based querying, query optimization, index management, and execution plan analysis. Participants will gain mastery over table expressions, ranking functions, and the handling of partitioned tables.
Gain a deep understanding of advanced SQL syntax and techniques within Microsoft SQL Server. By mastering analytical functions, table joins, subqueries, and aggregation strategies, participants will learn to migrate data analysis tasks from MS Excel to the database layer. This approach boosts efficiency and supports the creation of robust IT systems powered by Microsoft SQL Server.
This practical MSSQL course in Nantes focuses on optimizing SQL query performance for Microsoft SQL Server. It addresses core concepts including relational architectures, data extraction, filtering, and aggregation techniques. Learners will gain command over complex joins, subqueries, and DML procedures to effectively manage business intelligence datasets.
This instructor-led course on Nantes focuses on the fundamentals of SQL with Microsoft SQL Server, enabling participants to proficiently handle querying, database design, and normalization. Through practical, hands-on activities, learners develop essential T-SQL skills to optimize data management and establish seamless connections with Excel.
This practical training on Nantes delves into SQL Server Analysis Services for advanced BI and data modeling. Learners will master the design of OLAP cubes, the use of MDX queries, and the deployment of robust solutions, acquiring the essential skills to facilitate 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
Online Microsoft SQL Server training in Nantes, MS SQL Server training courses in Nantes, Weekend MS SQL Server courses in Nantes, Evening Microsoft SQL Server training in Nantes, Microsoft SQL Server instructor-led in Nantes, MS SQL Server instructor in Nantes, Microsoft SQL Server boot camp in Nantes, SQL Server private courses in Nantes, MS SQL Server one on one training in Nantes, SQL Server classes in Nantes, SQL Server instructor-led in Nantes, Evening MS SQL Server courses in Nantes, MS SQL Server trainer in Nantes, Online SQL Server training in Nantes, MS SQL Server coaching in Nantes, Microsoft SQL Server on-site in Nantes, Weekend Microsoft SQL Server training in Nantes
