Get in Touch
 Duration 21 hours

Course Outline

Introduction to SQL Server Management Studio (SSMS)

  • Survey of SQL Server editions and core components
  • Exploring the SSMS interface and key features
  • Advantages of utilizing SSMS for database oversight

Installation and Setup

  • System prerequisites for SQL Server and SSMS
  • Process for installing SQL Server and SSMS
  • Configurations required after installation
  • Establishing connections to SQL Server instances

Database Structure and Storage

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

Database Creation and Administration

  • Building new databases within SSMS
  • Modifying and managing database properties
  • Procedures for attaching and detaching databases

Security Governance

  • Fundamentals of SQL Server security
  • Handling user logins and accounts
  • Distributing roles and defining permissions
  • Applying security best practices

Backup and Restoration

  • The critical role of backup and restore protocols
  • Backup variations: full, differential, and transaction log
  • Executing backups through SSMS
  • Restoring database content from backup files

Database Maintenance Schedules

  • The necessity of consistent database upkeep
  • Designing and scheduling maintenance routines
  • Monitoring and resolving issues in maintenance plans

Performance Monitoring and Optimization

  • Tracking SQL Server performance metrics
  • Detecting and addressing performance bottlenecks
  • Managing and optimizing indexes
  • Leveraging SQL Server Profiler and extended events

Task Automation via SQL Server Agent

  • Overview of SQL Server Agent
  • Creation and management of automated jobs
  • Scheduling jobs and configuring alerts
  • Oversight of SQL Server Agent tasks

High Availability and Disaster Recovery

  • Review of high availability strategies
  • Setting up database mirroring
  • Configuration of Log Shipping
  • Introduction to AlwaysOn availability groups

SQL Server Upgrades and Migration

  • Planning strategies for SQL Server upgrades
  • Comparing in-place and side-by-side upgrade methods
  • Transferring databases to new instances
  • Completing post-migration activities

Course Conclusion and Recommended Next Steps

Requirements

  • Fundamental understanding of database concepts
  • Proficiency in SQL syntax and query execution

Intended Audience

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

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

SQL Server Management Studio (SSMS) Administration

2026-11-17 09:30
21 hours
Riga, Old Town
4500 EUR (Online)
5100 EUR (Classroom)

SQL Server Management Studio (SSMS) Administration

2026-12-01 09:30
21 hours
Riga, Old Town
4500 EUR (Online)
5100 EUR (Classroom)

SQL Server Management Studio (SSMS) Administration

2026-12-15 09:30
21 hours
Riga, Old Town
4500 EUR (Online)
5100 EUR (Classroom)

SQL Server Management Studio (SSMS) Administration

2026-12-29 09:30
21 hours
Riga, Old Town
4500 EUR (Online)
5100 EUR (Classroom)

SQL Server Management Studio (SSMS) Administration

2027-01-12 09:30
21 hours
Riga, Old Town
4500 EUR (Online)
5100 EUR (Classroom)

SQL Server Management Studio (SSMS) Administration

2027-01-26 09:30
21 hours
Riga, Old Town
4500 EUR (Online)
5100 EUR (Classroom)

Related Courses

Administering in Microsoft SQL Server

 21 Hours
In Latvia, this training empowers administrators to manage SQL Server effectively. Learners master database creation, SQL syntax for data retrieval, and security protocols. You will also explore advanced features like replication, automation, and BI to build complex, real-world solutions.
Read more...

Microsoft SQL Server (MSSQL)

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

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

 14 Hours
This advanced SQL training module located in Latvia focuses on stored procedures, triggers, and error management within Microsoft SQL Server. It empowers developers to construct sophisticated, production-ready database architectures featuring optimized transaction control and procedural logic suited for enterprise contexts.
Read more...

MS SQL Server: SQL Advanced level for Data Analysts

14 Hours

This course provides a comprehensive understanding of advanced SQL syntax and techniques within Microsoft SQL Server. By mastering analytical functions, table joins, subqueries, and aggregation techniques, participants will learn to shift data analysis tasks from MS Excel to the database layer. This approach not only boosts efficiency but also supports the development of robust IT systems based on Microsoft SQL Server.

Read more...

T-SQL Fundamentals with SQL Server Training Course

 14 Hours
Master T-SQL fundamentals in this hands-on course located in Latvia. Learn to leverage SQL Server Management Studio, construct tables using DDL and DML, and develop complex queries with joins and subqueries. This course is ideal for beginners seeking core database competencies and practical experience with modern relational systems.
Read more...

SQL language in MSSQL

 14 Hours
This practical SQL training in Latvia focuses on writing efficient queries for Microsoft SQL Server. It examines relational models, data retrieval, filtering, and aggregation. Participants will master multi-table joins, subqueries, and DML operations to confidently manipulate business intelligence datasets.
Read more...

Learning SQL with Microsoft SQL Server

 21 Hours
This instructor-led course on Latvia focuses on the fundamentals of SQL with Microsoft SQL Server, guiding participants to master querying, database design, and normalization. Through practical exercises, students will develop hands-on T-SQL skills to optimize data workflows and establish seamless connections with Excel.
Read more...

Microsoft SQL Server Database Administration

 40 Hours
This live, instructor-led program in Latvia focuses on essential SQL Server administration competencies. Learners will acquire the skills to install and configure environments, govern databases, and track performance. It is particularly suited for IT professionals aiming to gain practical proficiency in automation and troubleshooting.
Read more...

Microsoft SQL Server for Database Administrators: Intermediate to Advanced

 28 Hours

This instructor-led live training, conducted in Latvia (either online or onsite), is tailored for intermediate to advanced database administrators aiming to expand their SQL Server expertise. The focus is on achieving efficient database management, fine-tuning performance, ensuring high availability, and mastering advanced troubleshooting techniques.

By the conclusion of this training, participants will be able to:

  • Administer and configure SQL Server instances following best practices.
  • Optimize the performance of both queries and databases.
  • Establish high availability and disaster recovery protocols.
  • Diagnose and address complex issues in production settings.A
Read more...

Business Intelligence with SSAS

 14 Hours
This hands-on training in Latvia delves into SQL Server Analysis Services for advanced BI and data modeling. Participants will learn to design OLAP cubes, utilize MDX queries, and deploy robust solutions, acquiring practical skills to facilitate data-driven decision-making for modern business operations.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This live, instructor-led course in Latvia (delivered online or onsite) is designed for beginner-level data professionals aiming to learn how to design, implement, and manage SSIS packages for data integration and transformation tasks.

By the conclusion of this training, participants will be able to:

  • Comprehend the architecture and components of SSIS.
  • Design and implement ETL processes using SSIS.
  • Utilize SSIS tools to develop, deploy, and manage data integration solutions.
  • Troubleshoot and optimize SSIS packages to ensure high performance and reliability.
Read more...

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

 14 Hours

This instructor-led program in Latvia is dedicated to the design of advanced SSIS data flows and transformations. Participants will gain mastery over Slowly Changing Dimensions, learn to manage complex data sources, and deploy robust packages to streamline data warehousing and migration workflows.

Read more...

Transact SQL Advanced

 7 Hours
This advanced Transact SQL course in Latvia equips participants with the skills necessary to manage complex result sets and optimize database performance. It covers analytical functions, index management, query tuning, and basic 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 Latvia (online or onsite) targets intermediate software developers and automation engineers aiming to build applications that communicate with PLCs and interact with SQL databases using Visual Studio.

By the conclusion of this program, participants will be equipped to:

  • Develop .NET applications in Visual Studio for industrial automation purposes.
  • Communicate with PLCs utilizing industrial protocols such as OPC UA.
  • Execute database interactions with SQL Server for the storage and retrieval of PLC data.
  • Optimize application performance for real-time industrial operations.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server