Get in Touch

Seoul - Gran Seoul

Jongno-gu, Tower 1, Gran Seoul, 33 Jong-ro, Spaces Gran Seoul, 7F, Seoul, korea, 01359

Gran Seoul is located on the 7th floor of 24-storey Gran Seoul Tower. The location is just a stone's throw away from Gwanghwamun, the largest gate of Gyeongbukgung Palace which is one of the most popular tourist attractions and national landmark in the heart of Seoul. Spaces Gran Seoul can be conveniently accessed by public transportation with Kwanghwamoon subway station located just 500 meters away and only a few minutes’ walk to Jonggak subway station. Also located nearby and within 15 minutes ride is Seoul Station where five lines of bullet train, subway, and airport train are started. The Gran Seoul Tower is a grade-A commercial building combining office space, world class hotel, department store, major companies, finance enterprises, government offices and banks. Surrounded by historical and cultural facilities symbolizing Seoul’s pride, Gran Seoul is an ideal workspace for all businesses from start-ups to large international companies looking for established business location in the heart of Seoul's CBD.

Seoul Center 1

Jung-gu, 26, Eulji-ro 5-gil, 27/F, . West Center, Center1 Building, Seoul, korea, 04539

Center 1 is conveniently located at the core of Seoul's central business district (CBD). Center 1 is one of the most advanced green building in Korea. Offers smartly landscaped park for rest and for a showcase of media technology as a front yard. It also features top class amenities such as prestigious retail shops and wide range of sophisticated restaurants (Italian, Japanese, Thai, Chinese, Korean, Indian, and Mexican) and breezy cafes. Business, dining, and shopping are under one roof at Center 1. Many financial institutions, investment banks, and insurance companies are located in close proximity, including the headquarter for the Bank of Korea. Seoul's political, public administration, media, cultural and economic venues are all within walking distance of Center 1. Also hotels, department stores and other amenities are within walking distance.

Subcategories (2)

SSAS

SSAS
SSIS

SSIS

Explore Our Courses

SQL Server Management Studio (SSMS) Administration

 21 Hours

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

Microsoft SQL Server Database Administration

 40 Hours

SQL Server is Microsoft’s enterprise-grade relational database management system, engineered to efficiently store, manage, and retrieve data.

This instructor-led live training, available both online and onsite, is tailored for intermediate IT professionals looking to administer, configure, and maintain SQL Server environments.

Upon completing this training, participants will be equipped to:

  • Install and configure SQL Server environments.
  • Manage databases, users, and permissions.
  • Monitor performance and resolve issues.
  • Automate tasks using jobs and maintenance plans.

Format of the Course

  • Interactive lectures and discussions.
  • Extensive exercises and practical activities.
  • Hands-on implementation in a live-lab environment.

Course Customization Options

  • To request customized training for this course, please contact us to arrange.
Read more...

Microsoft SQL Server for Database Administrators: Intermediate to Advanced

 28 Hours

This instructor-led, live training in Seoul (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 2022 Integration Services (SSIS) – Data Flows and Advanced Transformations

 14 Hours

SQL Server Integration Services (SSIS) serves as a vital component within Microsoft SQL Server, offering a comprehensive platform for data integration and workflow applications. It is extensively utilized for data migration, warehousing, and transformation tasks.

This instructor-led live training, available both online and onsite, is designed for intermediate-level data professionals and developers aiming to master the design of advanced SSIS data flows, transformations, and the management of Slowly Changing Dimensions (SCD) in data warehousing contexts.

Upon completion of this training, participants will be equipped to:

  • Design and implement robust data flows using SSIS.
  • Effectively work with diverse data sources, destinations, and transformation tools.
  • Implement Slowly Changing Dimensions (SCD) to manage historical data changes.
  • Deploy, execute, and troubleshoot SSIS packages with confidence.

Course Format

  • Interactive lectures and discussions.
  • Extensive exercises and practical application.
  • Hands-on implementation within a live-lab environment.

Course Customization Options

  • To arrange a customized training session for this course, please contact us.
Read more...

Visual Studio for PLC Communication and Database Integration

 21 Hours

This instructor-led, live training session (online or onsite) targets intermediate software developers and automation engineers seeking to build applications that communicate with PLCs and interact with SQL databases using Visual Studio.

Upon completing this training, participants will be capable of:

  • Creating .NET applications in Visual Studio for industrial automation purposes.
  • Communicating with PLCs utilizing industrial protocols such as OPC UA.
  • Implementing database interactions with SQL Server to store and retrieve PLC data.
  • Optimizing application performance for real-time industrial settings.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

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

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

 14 Hours

Mastering advanced Transact-SQL for Microsoft SQL Server unlocks the potential of enterprise database automation. This course explores essential development constructs such as procedural programming, structured error handling, transaction management, cursor operations, stored procedures, and database triggers. It empowers seasoned developers to design sophisticated backend data operations, minimize application-layer overhead, and deliver production-ready solutions for critical database applications within enterprise environments.

Read more...

Transact SQL Advanced

 7 Hours

Participants will gain insight into several advanced features of Transact SQL and will be able to perform the following tasks:

  • Utilize queries to generate complex result sets
  • Manage database objects to enhance query performance
  • Optimize queries for improved efficiency

This course is designed for anyone currently using Transact SQL to extract data from a Microsoft SQL Server database who wishes to expand their knowledge, particularly in data analysis and improving query speed.

Read more...

T-SQL Fundamentals with SQL Server Training Course

 14 Hours

This SQL training course is designed for individuals seeking to acquire foundational skills for managing SQL Server Databases. The curriculum empowers participants to master the following key areas:

  • Effective utilization of SQL Server and SQL Server Management Studio.
  • Understanding core concepts such as Databases, SQL, and RDBMS.
  • Creating tables and applying Data Definition Language (DDL), Data Manipulation Language (DML), and Data Access Language (DAL).
  • Identifying various RDBMS packages available in the market and understanding their comparative advantages.
  • Gaining an introduction to NoSQL and exploring how organizations are transitioning toward hybrid database architectures.
Read more...

Administering in Microsoft SQL Server

 21 Hours

This course is tailored for system administrators, developers, and database developers.

Training Objectives:

  • Develop and reinforce skills in creating and managing databases
  • Gain proficiency in SQL syntax for retrieving and modifying data
  • Implement security protocols within the database
  • Utilize advanced features such as replication, automation, and business intelligence (BI)
  • Leverage Microsoft SQL Server capabilities to build complex reports and developer solutions
Read more...

Microsoft SQL Server (MSSQL)

 14 Hours

This program is designed for participants who are already familiar with SQL within the Microsoft SQL Server 2008/2012 environment. The curriculum emphasizes set-based querying and query optimization, along with techniques for working with indexes and analyzing execution plans.

Additionally, the training includes topics on table expressions, ranking functions, and strategies for managing partitioned tables.

Read more...

SQL language in MSSQL

 14 Hours

Mastering the creation of efficient SQL queries for Microsoft SQL Server forms the cornerstone of every enterprise data pipeline. This course explores fundamental techniques, beginning with relational database models and advancing through data retrieval, filtering, sorting, and aggregation using grouping functions and subqueries. Participants are guided through multi-table joins, set operators, DML operations, and transaction control, enabling them to reliably extract and manipulate business intelligence datasets.

Read more...

Learning SQL with Microsoft SQL Server

 21 Hours

Microsoft SQL Server serves as a robust relational database management system (RDBMS) designed for efficient data storage and retrieval.

This instructor-led live training, available both onsite and remotely, equips participants with the fundamental SQL skills required to effectively query a Microsoft SQL Server database.

Upon completion of this training, participants will be capable of:

  • Installing and configuring Microsoft SQL Server
  • Executing database queries using Microsoft's Transact-SQL (T-SQL) language
  • Grasping the core principles of database design
  • Optimizing database structures through normalization
  • Leveraging aggregate functions to create results akin to Excel pivot tables
  • Connecting to Microsoft SQL Server directly from Excel

Target Audience

  • Data analysts
  • Business Intelligence specialists
  • Business managers
  • Excel professionals looking to broaden their analytical capabilities

Course Format

  • Engaging lectures and discussions
  • Extensive exercises and practical drills
  • Real-world implementation within a live laboratory environment

Customization Options

  • The training curriculum is based on the most recent version of Microsoft SQL Server
  • To arrange a customized training session, please reach out to us.
Read more...

Business Intelligence with SSAS

 14 Hours

SSAS (SQL Server Analysis Services) is a Microsoft SQL Server tool designed for online analytical processing (OLAP) and data mining, enabling the analysis of data across multiple databases, tables, or files. The semantic data models provided by SSAS are utilized by client applications such as Power BI, Excel, Reporting Services, and various other data visualization tools.

Through this instructor-led live training (available onsite or remotely), participants will learn how to leverage SSAS to analyze large volumes of data stored in databases and data warehouses.

Upon completion of this training, participants will be able to:

  • Install and configure SSAS
  • Understand the relationships between SSAS, SSIS, and SSRS
  • Apply multidimensional data modeling to extract business insights
  • Design OLAP (Online Analytical Processing) cubes
  • Query and manipulate multidimensional data using the MDX (Multidimensional Expressions) query language
  • Deploy real-world BI solutions using SSAS

Audience

  • BI (Business Intelligence) professionals
  • Data Analysts
  • Database and data warehousing professionals

Format of the Course

  • Interactive lecture and discussion
  • Extensive exercises and practice
  • Hands-on implementation in a live-lab environment

Course Customization Options

  • This training is based on the latest version of Microsoft SQL Server and SSAS.
  • To request a customized training for this course, please contact us to arrange.
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

Upcoming Courses

SQL language in MSSQL

2026-07-30 10:00
14 hours
Seoul Center 1
₩ 5000000 (Online)
₩ 10000000 (Classroom)

Learning SQL with Microsoft SQL Server

2026-08-13 10:00
21 hours
Seoul - Gran Seoul
₩ 7500000 (Online)
₩ 15000000 (Classroom)

Transact SQL Advanced

2026-08-27 10:00
7 hours
Seoul Center 1
₩ 2500000 (Online)
₩ 5000000 (Classroom)

Learning SQL with Microsoft SQL Server

2026-09-10 10:00
21 hours
Seoul - Gran Seoul
₩ 7500000 (Online)
₩ 15000000 (Classroom)

Other regions in South Korea

Other Countries

These courses are also available in other countries
Online Microsoft SQL Server training in Seoul, MS SQL Server training courses in Seoul, Weekend SQL Server courses in Seoul, Evening MS SQL Server training in Seoul, MS SQL Server instructor-led in Seoul, MS SQL Server on-site in Seoul, MS SQL Server instructor-led in Seoul, Microsoft SQL Server coaching in Seoul, MS SQL Server one on one training in Seoul, Evening MS SQL Server courses in Seoul, Microsoft SQL Server trainer in Seoul, Online Microsoft SQL Server training in Seoul, Weekend SQL Server training in Seoul, Microsoft SQL Server private courses in Seoul, SQL Server boot camp in Seoul, Microsoft SQL Server classes in Seoul, SQL Server instructor in Seoul