Get in Touch
 Duration 21 hours

Course Outline

Getting Started with SQL Server Management Studio (SSMS)

  • Survey of SQL Server editions and constituent elements
  • SSMS interface components and functionality
  • Advantages of utilizing SSMS for database oversight

Installation and Setup

  • Hardware and software requirements for SQL Server and SSMS
  • Deployment of SQL Server and SSMS
  • Initial configuration after installation
  • Establishing connections to SQL Server instances

Database Structure and Storage Mechanisms

  • Comprehending SQL Server databases and instance architecture
  • Internal structure of SQL Server databases
  • Management of filegroups and data files

Database Creation and Lifecycle Management

  • Initiating new databases through SSMS
  • Adjusting database property settings
  • Processes for attaching and detaching database files

Security Governance

  • Foundations of SQL Server security models
  • Administration of logins and user accounts
  • Assignment of roles and granular permissions
  • Deployment of security best practices

Backup and Recovery Strategies

  • Criticality of backup and restore operations
  • Backup modalities: full, differential, and transaction log
  • Executing backups via the SSMS interface
  • Recovering database states from backup files

Maintenance Planning

  • Necessity of consistent database upkeep
  • Designing and scheduling automated maintenance plans
  • Oversight and troubleshooting of maintenance workflows

Performance Monitoring and Optimization

  • Tracking SQL Server performance metrics
  • Detecting and addressing performance bottlenecks
  • Index maintenance and optimization techniques
  • Leveraging SQL Server Profiler and extended events

Task Automation via SQL Server Agent

  • Fundamentals of the SQL Server Agent service
  • Development and management of automated jobs
  • Scheduling routines and alert configurations
  • Monitoring the status of Agent jobs

High Availability and Disaster Recovery

  • Survey of high availability architectures
  • Setup of database mirroring
  • Configuration of Log Shipping
  • Exploration of AlwaysOn availability groups

SQL Server Upgrades and Migration

  • Strategic planning for version upgrades
  • In-place versus side-by-side upgrade methodologies
  • Transfer of databases to new server instances
  • Post-migration verification and tasks

Conclusion and Path Forward

Requirements

  • Fundamental understanding of database concepts
  • Proficiency with SQL syntax and query structures

Target Audience

  • Database Administrators (DBAs)
  • Software Developers
  • IT Professionals

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

SQL Server Management Studio (SSMS) Administration

2026-11-23 09:30
21 hours
Berlin
5208 EUR (Online)
5808 EUR (Classroom)

SQL Server Management Studio (SSMS) Administration

2026-12-07 09:30
21 hours
Potsdam
5208 EUR (Online)
5808 EUR (Classroom)

SQL Server Management Studio (SSMS) Administration

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

SQL Server Management Studio (SSMS) Administration

2027-01-04 09:30
21 hours
Munich
5208 EUR (Online)
5808 EUR (Classroom)

SQL Server Management Studio (SSMS) Administration

2027-01-18 09:30
21 hours
Köln
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...

Learning SQL with Microsoft SQL Server

 21 Hours
This instructor-led program in Germany focuses on the fundamentals of SQL within Microsoft SQL Server, enabling participants to excel in data querying, database architecture, and normalization. Through practical, hands-on activities, learners will develop essential T-SQL skills to refine data management and establish seamless integrations with Excel.
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...

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