Available either online or onsite, our instructor-led live Microsoft SQL Server (also referred to as MS SQL Server, or simply SQL Server) courses focus on practical, hands-on mastery of the platform's core fundamentals.
You can choose between "online live training" and "onsite live training." Online live sessions (often called "remote live training") are conducted interactively via a remote desktop. Onsite live training can be delivered locally at your premises in Prague or within NobleProg's corporate training facilities in Prague.
From Prague Main Train Station (Praha hlavní nádraží)
Take tram 9 from Hlavní nádraží toward Sídliště Řepy.
Get off at Újezd.
Walk about 10 minutes toward Malostranské náměstí / Prokopská.
Continue along Prokopská to 296/8.
Alternative: Take the metro C from Hlavní nádraží → Muzeum, change to metro A → Malostranská, then walk across Malá Strana. This involves more walking.
From Prague Bus Station — Florenc
Take metro B from Florenc toward Zličín.
Get off at Můstek.
Change to metro A toward Nemocnice Motol.
Get off at Malostranská.
Walk approximately 10–15 minutes to Prokopská 296/8.
This instructor-led, live training in Prague (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 Prague focuses on essential SQL Server administration competencies. Learners will gain the skills to install and configure environments, manage databases, and oversee performance. It is perfectly suited for IT professionals seeking practical experience in automation and troubleshooting.
This instructor-led, live training in Prague (online or onsite) is designed for intermediate to advanced database administrators seeking to deepen their knowledge of SQL Server. The curriculum emphasizes 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 the performance of queries and databases.
Implement high availability and disaster recovery strategies.
Diagnose and resolve complex issues in production environments.
This instructor-led training on Prague concentrates on crafting advanced SSIS data flows and transformations. Participants will gain mastery over Slowly Changing Dimensions, navigate complex data sources, and deploy resilient packages to streamline data warehousing and migration operations.
This instructor-led, live training in Prague (online or onsite) targets intermediate software developers and automation engineers who wish 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 Prague (online or onsite) is designed for beginner-level data professionals who wish to learn how to design, implement, and manage SSIS packages for data integration and transformation tasks.
Upon completing 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 course in Prague explores stored procedures, triggers, and error handling within Microsoft SQL Server. It enables developers to create intricate, production-level database solutions featuring efficient transaction management and procedural logic tailored for enterprise environments.
This advanced Transact SQL course in Prague provides participants with the capabilities to manage complex result sets and enhance database performance. Key topics include analytical functions, index management, query optimization, and foundational data warehouse methodologies for Microsoft SQL Server.
Develop a strong command of T-SQL fundamentals through this practical course in Prague. You will learn to navigate SQL Server Management Studio, construct tables using DDL and DML, and engineer complex queries utilizing joins and subqueries. This course is perfect for beginners aiming to build core database competencies and gain hands-on experience with contemporary relational systems.
In Prague, this training equips administrators with the skills to manage SQL Server effectively. Participants will master database creation, SQL syntax for data retrieval, and security protocols. Additionally, you will explore advanced features like replication, automation, and BI to build complex, real-world solutions.
This instructor-led course in Prague is tailored for individuals already familiar with SQL Server. It concentrates on set-based querying, query tuning, index management, and the interpretation of execution plans. Learners will gain proficiency in using table expressions, applying ranking functions, and working with partitioned tables.
This course offers a comprehensive exploration of advanced SQL syntax and capabilities within Microsoft SQL Server. By delving into analytical functions, table joins, subqueries, and aggregation strategies, participants will learn to transition data analysis workflows from MS Excel directly into the database layer. This shift not only enhances operational efficiency but also lays the foundation for building robust IT systems powered by Microsoft SQL Server.
This practical SQL course in Prague focuses on writing high-performance queries for Microsoft SQL Server. It encompasses relational models, data extraction, filtering, and aggregation techniques. Learners will gain proficiency in multi-table joins, subqueries, and DML operations to effectively manage business intelligence data.
This instructor-led training in Prague focuses on the fundamentals of SQL using Microsoft SQL Server, enabling participants to master data querying, database design, and normalization. Through practical exercises, learners develop hands-on T-SQL skills to optimize data management and integrate seamlessly with Excel.
This hands-on training in Prague delves into SQL Server Analysis Services for advanced BI and data modeling. Learners will acquire the skills to design OLAP cubes, utilize MDX queries, and deploy robust solutions, thereby gaining practical capabilities to facilitate data-driven decision-making within modern 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 SQL Server training in Prague, SQL Server training courses in Prague, Weekend SQL Server courses in Prague, Evening Microsoft SQL Server training in Prague, Microsoft SQL Server instructor-led in Prague, MS SQL Server coaching in Prague, Microsoft SQL Server trainer in Prague, SQL Server private courses in Prague, MS SQL Server one on one training in Prague, SQL Server boot camp in Prague, MS SQL Server instructor in Prague, Online SQL Server training in Prague, MS SQL Server on-site in Prague, MS SQL Server classes in Prague, Evening Microsoft SQL Server courses in Prague, SQL Server instructor-led in Prague, Weekend Microsoft SQL Server training in Prague
