Get in Touch
 Duration 21 hours

Course Outline

Introduction

Installation and Configuration of Microsoft SQL Server

Key Features of Microsoft SQL Server

Foundational Concepts of Transact-SQL

Retrieving Data using SELECT Statements

Filtering Records with the WHERE Clause

Ordering Output with ORDER BY

Combining Multiple Tables through Joins

Aggregating Data using GROUP BY

Performing Calculations with Aggregate Functions

Filtering Grouped Data with HAVING

Database Creation Process

Comprehending the Database Model

Database Optimization via Normalization

Advancing Queries with Stored Procedures

Developing Functions and Sub-routines

Controlling Program Flow with Conditional Logic

Integrating Microsoft SQL Server with Excel

Troubleshooting Strategies

Summary and Wrap-up

Requirements

  • No prior experience with SQL or databases is necessary.

Number of participants


Price per participant (excl. VAT)

Open Training Courses require 5+ participants.

Testimonials (4)

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

Upcoming Courses

Learning SQL with Microsoft SQL Server

2026-12-17 09:30
21 hours
Stuttgart
5208 EUR (Online)
5808 EUR (Classroom)

Learning SQL with Microsoft SQL Server

2026-12-31 09:30
21 hours
Bremen
5208 EUR (Online)
5808 EUR (Classroom)

Learning SQL with Microsoft SQL Server

2027-01-14 09:30
21 hours
Erfurt
5208 EUR (Online)
5808 EUR (Classroom)

Learning SQL with Microsoft SQL Server

2027-01-28 09:30
21 hours
Bonn
5208 EUR (Online)
5808 EUR (Classroom)

Related Courses

Administering in Microsoft SQL Server

 21 Hours
In Germany, this training enables administrators to manage SQL Server with efficiency and confidence. Participants will master the creation of databases, the application of SQL syntax for data manipulation, and the implementation of essential security protocols. Additionally, the course delves into advanced functionalities, including replication, automation, and BI, equipping learners to construct complex, real-world solutions.
Read more...

Microsoft SQL Server (MSSQL)

 14 Hours
This instructor-led course in Germany is tailored for professionals already experienced with SQL Server. It concentrates on set-based querying, query optimization, index management, and execution plan analysis. Participants will gain proficiency in utilizing table expressions, ranking functions, and partitioned table structures.
Read more...

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

 14 Hours
This advanced SQL course in Germany focuses on stored procedures, triggers, and error handling in Microsoft SQL Server. It enables developers to construct complex, production-grade database solutions featuring efficient transaction management and procedural logic tailored for enterprise contexts.
Read more...

MS SQL Server: SQL Advanced level for Data Analysts

14 Hours

This program is structured to deliver a comprehensive grasp of sophisticated SQL syntax and methodologies within the Microsoft SQL Server environment. By acquiring proficiency in analytical functions, table joins, subqueries, and aggregation methods, learners will gain the ability to migrate data analysis workflows from MS Excel directly into the database layer. This transition not only enhances operational efficiency but also underpins the creation of resilient IT solutions built on Microsoft SQL Server.

Read more...

T-SQL Fundamentals with SQL Server Training Course

 14 Hours
Develop a solid command of T-SQL fundamentals through this practical, hands-on course in Germany. You will gain the ability to leverage SQL Server Management Studio, design tables using DDL and DML, and construct sophisticated queries involving joins and subqueries. This program is ideally suited for beginners looking to establish core database competencies and gain practical experience with modern relational systems.
Read more...

SQL language in MSSQL

 14 Hours
This practical SQL course in Germany focuses on writing optimized queries for Microsoft SQL Server. It encompasses relational models, data retrieval, filtering, and aggregation. Learners will gain proficiency in multi-table joins, subqueries, and DML operations, enabling them to manage business intelligence datasets effectively.
Read more...

Microsoft SQL Server Database Administration

 40 Hours
This instructor-led, live training in Germany covers core SQL Server administration skills. Participants will learn to install and configure environments, manage databases, and monitor performance. Ideal for IT professionals seeking hands-on experience with automation and troubleshooting.
Read more...

Microsoft SQL Server for Database Administrators: Intermediate to Advanced

 28 Hours

This instructor-led, live training in Germany (available online or onsite) is designed for intermediate to advanced-level database administrators aiming to enhance their SQL Server knowledge. The focus is on efficient database management, performance tuning, high availability, and advanced troubleshooting.

By the conclusion of this training, participants will be capable of:

  • Administering and configuring SQL Server instances following best practices.
  • Improving the performance of queries and databases.
  • Implementing high availability and disaster recovery frameworks.
  • Diagnosing and resolving complex issues in production environments.A
Read more...

SQL Server Management Studio (SSMS) Administration

 21 Hours

This instructor-led, live training in Germany (online or onsite) targets intermediate-level database administrators aiming to master the skills necessary for effective management and administration of SQL Server databases using SQL Server Management Studio.

By the conclusion of this program, participants will be capable of:

  • Understanding system prerequisites and carrying out installations.
  • Creating, setting up, and managing databases with SSMS.
  • Overseeing logins, user accounts, roles, and access permissions.
  • Executing various backup types and restoring database integrity.
  • Building, timing, and administering tasks via SQL Server Agent.
  • Adhering to best practices for robust and secure SQL Server operations.
Read more...

Business Intelligence with SSAS

 14 Hours
This hands-on course in Germany dives deep into SQL Server Analysis Services for advanced BI and data modeling. Learners will master the design of OLAP cubes, the utilization of MDX queries, and the deployment of robust solutions, acquiring the practical expertise needed to support data-driven decision-making in modern business contexts.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in Germany (online or onsite) is tailored for beginner-level data professionals aiming to learn how to design, implement, and manage SSIS packages for 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...

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

 14 Hours

This instructor-led training in Germany is dedicated to the design of sophisticated SSIS data flows and transformations. Learners will gain mastery over Slowly Changing Dimensions, manage intricate data sources, and implement robust packages to support efficient data warehousing and migration workflows.

Read more...

Transact SQL Advanced

 7 Hours
This advanced Transact SQL course in Germany provides participants with the skills necessary 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.
Read more...

Visual Studio for PLC Communication and Database Integration

 21 Hours

This live, instructor-led training in Germany (online or onsite) is designed for intermediate-level software developers and automation engineers aiming to develop applications that handle PLC communication and SQL database interaction using Visual Studio.

By the end of the training, participants will have the ability to:

  • Create .NET applications in Visual Studio for industrial automation.
  • Connect with PLCs utilizing industrial protocols like OPC UA.
  • Perform database interactions with SQL Server to store and retrieve PLC data.
  • Optimize application performance for real-time industrial environments.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server