Get in Touch

Ly Thai To

Level 5, 41A Ly Thai To Street, Hanoi, Vietnam

The business centre is conveniently located in Sentinel Place on the corner of Ly Thai To and Tran Nguyen Han Streets. It is located within five minutes walk to the Opera House, the Metropole and the Hilton Hanoi Opera and in close proximity to The Ministry of Finance, The Hanoi People's Committee, The State Bank of Vietnam and numerous other commercial properties and foreign banks. Ly Thai To Street is a prominent street which is well known in Hanoi and provides easy of access for any visitors. Key office developments in the vicinity include BIDV Tower, 63 Ly Thai To and the Opera Business Centre and there is high-end shopping malls in the immediate locality.

InterContinental Hanoi Westlake

Leve1 & 2, Number 1A, Nghi Tam, Ha Noi, Vietnam

Located at strategic positions on Floors 1 & 2, No. 1A Nghi Tam Street, in the central Ho Tay Ward, Hanoi, InterContinental Hanoi Westlake Hotel stands as one of the city's premier commercial buildings. This iconic structure sits on a major thoroughfare, offering excellent accessibility and convenient connections to the vibrant cultural and entertainment centers of Hanoi. From this prime location, both residents and tourists can easily access famous landmarks such as the picturesque West Lake and the bustling Hoan Kiem Lake area. With its strategic positioning, the hotel is just a 5- to 10-minute drive from Ga Doi Anh (formerly Ga Chung Cun - Yên Hòa) on Line 2 of the Hanoi Metro. More than just providing luxurious work and living spaces, InterContinental Hanoi Westlake functions as a prestigious commercial center, seamlessly integrating all business and leisure needs within a modern and comfortable environment.

JW Marriott Hanoi

Number 8, Do Duc Duc Street,, Ha Noi, Viet Nam

Located at a prime position on Floor 8, Number 8 Do Duc Duc Street, in the heart of Hoan Kiem Ward, Hanoi, the JW Marriott Hanoi stands as a premier commercial building. This iconic structure sits strategically on a key thoroughfare, offering exceptional accessibility and convenient connections to Hanoi's vibrant cultural and entertainment centers. From this central location, guests can easily access the beautiful Hoan Kiem Lake and the historic Old Quarter with its myriad attractions. The hotel's strategic positioning makes it highly suitable for both business and leisure, providing convenient access to the city's core. More than just elegant accommodation, the JW Marriott Hanoi functions as a prestigious commercial hub, seamlessly integrating sophisticated workspaces, dining, and leisure amenities within a modern and comfortable environment. It is an ideal base for discerning travelers seeking convenience, style, and access to Hanoi's dynamic energy.

Pullman Ha Noi

Level 1 & 2 , Number 40, Cat Linh, Ha Noi, Vietnam

Located at a prime position on Floors 1 & 2, Number 40 Cat Linh Street, Hanoi, Vietnam, the Pullman Hanoi stands as a modern commercial hub. This strategic location places it within the rapidly developing Cat Linh area, offering excellent access to the bustling Central Space and proximity to upcoming infrastructure like the Cat Linh-Hai Ba Trung Metro station (Line 2). From this modern address, guests and professionals find it convenient to connect to the heart of Hanoi. The hotel is well-positioned to reach key landmarks such as Hoan Kiem Lake and West Lake, as well as the historic Old Quarter, all within a relatively short distance. More than just a modern hotel, the Pullman Hanoi functions as a dynamic commercial center, integrating contemporary business facilities and leisure amenities within a stylish and comfortable environment, catering to the needs of today's discerning traveler.

Sofitel Legend Metropole Hanoi

Level 1 & 2 , Number 15, Ngo Quyen, Ha Noi, Vietnam

Located at a prestigious position on Floors 1 & 2, Number 15 Ngo Quyen Street, in Hanoi, Vietnam, the Sofitel Legend Metropole Hanoi stands as an iconic historic landmark and premier commercial building. This magnificent French colonial structure sits on a significant thoroughfare within the vibrant Old Quarter, offering exceptional accessibility and convenient connections to the heart of Hanoi. From this distinguished location, guests and professionals can easily access the beautiful Hoan Kiem Lake and the bustling Old Quarter with its rich history and cultural attractions. The hotel's prestigious positioning makes it an ideal base for both business endeavors and leisure exploration. More than just luxury accommodations, the Sofitel Legend Metropole Hanoi functions as a prestigious commercial and cultural hub, seamlessly integrating timeless charm, sophisticated amenities, and refined services within its historic walls, catering to the discerning traveler and connoisseur.

Toong IPH

3rd Floor, Indochina Plaza, 241 Xuan Thuy street, Cau Giay district, Ha Noi, Vietnam

Located on the 3rd floor of Indochina Plaza, Hanoi, Toong coworking space is one of the key tenants in the whole service complex. We help complete and elevate an ecosystem of living - working - socializing - trading - and relaxing hubs for local entrepreneurs and knowledge workers.

UPGen Keangnam

Level 43, Keangnam Hanoi Landmark Tower, Pham Hung Street, Nam Tu Liem District, Ha Noi, Viet Nam

Inside the tallest building in Hanoi and second tallest in Vietnam, the 72-floor skyscraper Keangnam Hanoi Landmark Tower (Landmark72) is home to one of UPGen’s most impressive spaces. This Grade-A building boasts an incredible view of the city unlike anywhere else in Hanoi. UPGen Keangnam is conveniently located just five minutes’ walk from the metro line.

Explore Our Courses

Oracle: Programming with PL/SQL II

 21 Hours

This instructor-led, live training in Hanoi (online or onsite) is aimed at advanced-level developers and database administrators who wish to use PL/SQL to develop high-performing, secure, and scalable database solutions while leveraging advanced programming techniques and integrations.

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

  • Work with complex data types, collections, and bulk operations for efficient data management.
  • Develop object types, table functions, and custom aggregates to enhance database functionality.
  • Apply performance tuning techniques, use native compilation, and safeguard against SQL injection.
  • Implement application contexts, VPD, and secure program units for robust database solutions.
Read more...

Oracle: Programming with PL/SQL I

 28 Hours

This instructor-led, live training in Hanoi (online or onsite) is aimed at beginner-level developers and database administrators who wish to learn PL/SQL to automate database tasks, implement business logic, and develop robust database applications.

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

  • Develop efficient PL/SQL programs to automate database operations and integrate SQL commands effectively.
  • Create reusable program units, including procedures, functions, packages, and triggers, for modular and scalable applications.
  • Implement advanced data structures like associative arrays and manage query results using cursors.
  • Handle errors robustly and secure code with encryption, obfuscation, and conditional compilation techniques.
  • Apply PL/SQL in real-world scenarios, leveraging built-in packages for file handling, email automation, and other advanced functionalities. 
Read more...

Oracle Database 19c PL and Advanced SQL

28 Hours

This instructor-led, live training in Hanoi (online or onsite) is aimed at intermediate-level database administrators who wish to have an in-depth understanding of Oracle Database 19c PL/SQL programming and advanced SQL techniques.

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

  • Understand the fundamentals and advanced features of PL/SQL.
  • Develop advanced SQL queries to retrieve and manipulate data efficiently.
  • Implement PL/SQL programming constructs to manage data and database operations.
  • Optimize SQL queries for better performance.
  • Use advanced PL/SQL features like collections, bulk processing, and error handling.
  • Learn to debug and manage PL/SQL programs effectively.
Read more...

Oracle Database: Program with PL/SQL

 21 Hours

PL/SQL (Procedural Language/SQL) is Oracle’s extension to SQL that enables developers to write procedural logic directly inside the database.

This instructor-led, live training (online or onsite) is aimed at intermediate-level developers and technical professionals who wish to write robust PL/SQL programs, manage exceptions, and create reusable procedures, functions, and packages in Oracle Database.

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

  • Create PL/SQL blocks, procedures, and functions to encapsulate business logic.
  • Use control structures, cursors, and exception handling effectively.
  • Define and manage packages, triggers, and stored logic securely.
  • Debug and test PL/SQL code using standard Oracle tools.

Format of the Course

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

Course Customization Options

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

PL/SQL in Oracle 19c

 21 Hours

This instructor-led, live training in Hanoi (online or onsite) is aimed at intermediate-level developers and administrators who wish to have a solid PL/SQL programming foundation to develop efficient and robust database applications using Oracle 19c.

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

  • Gain a comprehensive understanding of what PL/SQL is and its advantages over standard SQL.
  • Learn how to declare and use variables and different data types within PL/SQL blocks.
  • Apply control structures like IF-THEN-ELSE, CASE statements, and loops to create robust PL/SQL programs.
  • Understand and implement explicit and implicit cursors for data retrieval.
  • Handle exceptions effectively using predefined and user-defined exceptions.
  • Develop and manage triggers to automate and enforce business rules.
  • Create and use PL/SQL packages to encapsulate and modularize code for reuse and maintainability.
Read more...

ORACLE PL/SQL Fundamentals

 21 Hours

This 3 day course gives an introduction to ORACLE PL/SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/SQL commands.

The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements.

Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.

Read more...

Last Updated:

Testimonials (3)

he explained very well, and gave guidance on the exercises.

Stoyan - OPEN COURSE

Course - Oracle Database 19c PL and Advanced SQL

I liked the hands-on experience and the opportunity to work on actual coding activities

Kristine - Isuzu Philippines Corporation

Course - ORACLE PL/SQL Fundamentals

The PL/SQL session basics. I used PL/SQL but never got the basics of it and this course helped me a lot understand PL/SQL queries.

Stefan-Andrei

Course - PL/SQL in Oracle 19c

Provisional Upcoming Courses (Require 5+ participants)

ORACLE PL/SQL Fundamentals

2026-05-22 09:30
21 hours
Pullman Ha Noi
304,860,354 VND (Online)
304,860,354 VND (Classroom)

Oracle: Programming with PL/SQL I

2026-06-05 09:30
28 hours
Sofitel Legend Metropole Hanoi
406,480,472 VND (Online)
406,480,472 VND (Classroom)

PL/SQL in Oracle 19c

2026-06-19 09:30
21 hours
Toong IPH
304,860,354 VND (Online)
304,860,354 VND (Classroom)

PL/SQL in Oracle 19c

2026-07-03 09:30
21 hours
UPGen Keangnam
304,860,354 VND (Online)
304,860,354 VND (Classroom)

Oracle: Programming with PL/SQL II

2026-07-17 09:30
21 hours
Ly Thai To
304,860,354 VND (Online)
304,871,304 VND (Classroom)

Other regions in Vietnam

Other Countries

These courses are also available in other countries

Consulting

Oracle PL/SQL Consulting
Online Oracle PL/SQL training in Hanoi, Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) training courses in Hanoi, Weekend Oracle PL/SQL courses in Hanoi, Evening Oracle PL/SQL training in Hanoi, Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) instructor-led in Hanoi, Oracle PL/SQL boot camp in Hanoi, Oracle PL/SQL trainer in Hanoi, Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) on-site in Hanoi, Online Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) training in Hanoi, Oracle PL/SQL instructor-led in Hanoi, Evening Oracle PL/SQL courses in Hanoi, Oracle PL/SQL classes in Hanoi, Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) private courses in Hanoi, Weekend Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) training in Hanoi, Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) one on one training in Hanoi, Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) coaching in Hanoi, Oracle PL/SQL instructor in Hanoi