Get in Touch

Course Outline

Introduction

Installing and Configuring Microsoft SQL Server

Exploring Microsoft SQL Server Capabilities

Introduction to Transact-SQL Principles

Retrieving Data with SELECT

Filtering Records using WHERE

Arranging Output with ORDER BY

Querying Multiple Tables through Joins

Categorizing Data with GROUP BY

Applying Aggregate Functions for Data Calculations

Refining Groups with HAVING

Setting Up a New Database

Comprehending the Database Model

Improving Database Efficiency via Normalization

Advanced Query Techniques with Procedures

Developing Functions and Sub-routines

Controlling Execution Flow with Conditions

Linking to Microsoft SQL Server via Excel

Diagnosing Issues

Recap and Final Thoughts

Requirements

  • No prior experience with SQL or databases is necessary.
 21 Hours

Number of participants


Price per participant

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-10-16 09:30
21 hours
Milan
3150 EUR (Online)
3750 EUR (Classroom)

Learning SQL with Microsoft SQL Server

2026-10-30 09:30
21 hours
Naples
3150 EUR (Online)
3750 EUR (Classroom)

Learning SQL with Microsoft SQL Server

2026-11-13 09:30
21 hours
Turin
3150 EUR (Online)
3750 EUR (Classroom)

Learning SQL with Microsoft SQL Server

2026-11-27 09:30
21 hours
Genoa
3150 EUR (Online)
3750 EUR (Classroom)

Learning SQL with Microsoft SQL Server

2026-12-11 09:30
21 hours
Bologna
3150 EUR (Online)
3750 EUR (Classroom)

Related Courses

Administering in Microsoft SQL Server

 21 Hours
In Italy, this training equips administrators with the skills to manage SQL Server with confidence. Participants will master database creation, apply SQL syntax for data retrieval, and implement security best practices. Additionally, you will explore advanced features such as replication, automation, and BI to construct complex, real-world solutions.
Read more...

Microsoft SQL Server (MSSQL)

 14 Hours
This instructor-led course in Italy is intended for professionals already familiar with SQL Server. It concentrates on set-based querying, query optimization, index management, and execution plan analysis. Learners will gain proficiency in table expressions, ranking functions, and the management of partitioned tables.
Read more...

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

 14 Hours
This advanced SQL course in Italy focuses on stored procedures, triggers, and error handling for Microsoft SQL Server. It empowers developers to construct complex, production-grade database solutions utilizing efficient transaction control and procedural logic tailored for enterprise environments.
Read more...

MS SQL Server: SQL Advanced level for Data Analysts

14 Hours

Designed to offer a deep dive into advanced SQL syntax and methodologies within Microsoft SQL Server, this course empowers learners to leverage analytical functions, complex table joins, subqueries, and aggregation techniques. By transitioning data analysis workflows from MS Excel directly to the database layer, participants will enhance operational efficiency while contributing to the construction of robust IT architectures powered by Microsoft SQL Server.

Read more...

T-SQL Fundamentals with SQL Server Training Course

 14 Hours
Develop a strong command of T-SQL fundamentals through this practical course in Italy. Participants will learn to navigate SQL Server Management Studio, define table structures using DDL and DML, and craft advanced queries utilizing joins and subqueries. This course is particularly suited for beginners aiming to acquire core database competencies and hands-on experience with modern relational systems.
Read more...

SQL language in MSSQL

 14 Hours
This practical SQL training in Italy focuses on crafting efficient queries for Microsoft SQL Server. It encompasses relational models, data retrieval, filtering, and aggregation techniques. Learners will develop proficiency in multi-table joins, subqueries, and DML operations to confidently manage business intelligence datasets.
Read more...

Microsoft SQL Server Database Administration

 40 Hours
This live, instructor-led training in Italy focuses on essential SQL Server administration capabilities. Learners will master the installation and configuration of environments, database management, and performance monitoring. It is particularly well-suited for IT professionals aiming to gain practical experience in automation and troubleshooting.
Read more...

Microsoft SQL Server for Database Administrators: Intermediate to Advanced

 28 Hours

This instructor-led, live training in Italy (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.A
Read more...

SQL Server Management Studio (SSMS) Administration

 21 Hours

This instructor-led, live training in Italy (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.
Read more...

Business Intelligence with SSAS

 14 Hours
This practical training in Italy delves into SQL Server Analysis Services for advanced BI and data modeling. Participants will master the design of OLAP cubes, utilize MDX queries, and deploy robust solutions, acquiring the practical skills needed to drive data-driven decision-making in modern business operations.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in Italy (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.
Read more...

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

 14 Hours
This instructor-led training in Italy specializes in the design of advanced SSIS data flows and transformations. Participants will gain mastery over Slowly Changing Dimensions, manage complex data sources, and deploy robust packages to facilitate efficient data warehousing and migration strategies.
Read more...

Transact SQL Advanced

 7 Hours
This advanced Transact SQL course at Italy empowers participants with the skills to manage complex result sets and optimize database performance. It explores 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 instructor-led, live training in Italy (online or onsite) is aimed at intermediate-level 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.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server