ODS442

Oracle Database 19c: SQL Workshop

Q: What level of SQL knowledge do I need before taking this Oracle Database 19c SQL Workshop?

This is an intermediate-level course , so you should have basic familiarity with databases and fundamental SQL concepts. Ideally, you should understand what databases are, have some exposure to basic SELECT statements, and be comfortable working with computers. An undergraduate-level qualification is recommended. If you're completely new to SQL, we suggest starting with an introductory SQL course first to build foundational knowledge.

Q: How long is the Oracle Database 19c SQL Workshop and what teaching methods are used?

The workshop runs for 5 days and uses a comprehensive blend of teaching methodologies to ensure effective learning. You'll experience instructor-led lectures, presentation slides, hands-on labs, group discussions, and Q&A sessions . This multi-faceted approach ensures you not only understand the theoretical concepts but also gain practical experience through lab exercises that simulate real-world database scenarios.

Q: Who should attend this Oracle SQL training course?

This course is designed for entry-level professionals, engineers, and mid-level managers who need to work with Oracle databases. It's ideal for database developers, application developers, data analysts, business intelligence professionals, system administrators, and anyone responsible for querying, managing, or analyzing data in Oracle Database 19c environments. Whether you're transitioning into a database role or looking to formalize your SQL skills, this workshop provides the comprehensive training you need.

Q: What practical skills will I gain from this Oracle Database 19c SQL Workshop?

You'll develop comprehensive SQL skills including: writing efficient SELECT statements with filtering and sorting ; performing complex multi-table queries using joins, subqueries, and set operators ; manipulating data with INSERT, UPDATE, DELETE, and MERGE statements ; creating and managing database objects like tables, views, indexes, and sequences ; implementing transaction control and data integrity constraints ; controlling user access through privileges and roles ; working with time zone data types ; and applying advanced techniques including analytic and hierarchical queries for performance optimization.

Q: Does this course include hands-on practice with Oracle Database 19c?

Yes! The course includes extensive hands-on labs as a core teaching methodology. You'll gain practical experience working directly with Oracle Database 19c, applying the concepts you learn in real-world scenarios. These lab exercises cover everything from basic data retrieval to advanced query optimization, ensuring you can confidently apply your skills in actual database environments after completing the workshop.

Q: Will I receive a certification upon completing this Oracle SQL Workshop?

This particular workshop does not include a certification exam . However, it provides comprehensive training that prepares you with the essential SQL skills needed for working with Oracle Database 19c. The knowledge and practical experience you gain will be valuable for your professional development and can serve as preparation if you choose to pursue Oracle certification independently in the future.

Q: What advanced SQL topics are covered in this workshop?

Beyond fundamental SQL, the workshop covers sophisticated techniques essential for professional database work. You'll learn analytic functions for complex calculations , hierarchical queries for working with tree-structured data , performance optimization strategies for efficient query execution, advanced subquery techniques , set operators for combining result sets , and MERGE statements for complex data synchronization . You'll also explore the data dictionary , implement security best practices , and master transaction management for maintaining data consistency in multi-user environments.

Q: Where is the training conducted?

Our online trainings are conducted usually using Zoom or Google Meet. Our physical trainings are normally held in Common Ground, Bangsar South .

Q: Can international participants join this course?

Please check the Available in section to see which countries the course is available in. If your country is not listed, please contact us.

Q: What is the difference between public, corporate, and training provider pricing?

Public pricing : applies for individuals signing up from different companies. Corporate pricing : applies if a company wants to have an intake for its employees only. Training provider pricing : applies only for other training providers looking to hire our trainers and use our content. Our content has a licensing fee.

Master Oracle Database 19c SQL development under expert guidance. Enroll in our comprehensive workshop designed to build your expertise from fundamental queries to advanced database management. Gain practical skills in data retrieval, multi-table operations, transaction control, and schema object creation while learning industry best practices for query optimization and security implementation.

Available in:
Malaysia

Upcoming intakes:
Jan 26, 2026

Online Jan 26-30, 2026 9:00 AM - 5:00 PM Mohammad Mehdi Lotfinejad

Created: November 12th 2025, 1:14 PM MYT Last Modified: January 20th 2026, 6:02 AM MYT

updated

intermediate

We price match

Public Pricing

MYR 8750

Corporate Pricing

Pax:

Training Fees: MYR 6500/day

Total Fees: MYR 32500 ++

Training Provider Pricing

Pax:

Training Fees: MYR 2800/day

Material Fees: MYR 600

Total Fees: MYR 14600 ++

Features

5 days

40 modules

1 intake

Full life-time access

English

Technical: 25 pax

Target Audience

students

engineers

managers

Methodologies

lecture

slides

labs

group discussion

q&A

Subsidies

What you'll learn

Manipulate data using INSERT, UPDATE, DELETE, and MERGE statements effectively
Create and manage database objects including tables, views, indexes, and sequences
Work with time zone data types and perform date-time conversions accurately
Implement transaction control and maintain data integrity with constraints
Control user access through privileges, roles, and security best practices
Write efficient SELECT statements with filtering, sorting, and functions
Apply advanced SQL techniques including analytic and hierarchical queries
Perform complex multi-table queries using joins, subqueries, and set operators

TTT Certificate

Mohammad Mehdi Lotfinejad is a distinguished Chief Data Officer and certified HRDF trainer with over 15 years of experience in computer science instruction and professional data science training. Currently serving as Chief Data and Knowledge Officer at Magna.ai, a Florida-based lawtech company, he leads the development of sophisticated graph databases, data warehouses, and API solutions that power AI-driven legal case analysis systems. His expertise spans the entire data ecosystem, from architecture design to workflow automation and team leadership. With a robust background encompassing more than a decade of hands-on experience in data engineering and data science, Mohammad has successfully implemented enterprise-scale data processing pipelines across multiple industries and geographies. His professional journey includes senior roles at Axiata Digital Advertising (ADA) in Malaysia, where he designed and deployed data pipelines using AWS Redshift, Snowflake, Apache Spark, and Apache Airflow, and at The Center of Applied Data Science, where he led teams delivering training solutions to major corporations including CIMB, PETRONAS, SHELL, and TNB. Mohammad's technical proficiency is comprehensive and current, encompassing cloud platforms (AWS, Google Cloud), data warehousing solutions (Redshift, Snowflake), big data technologies (Apache Spark, Hadoop, Hive), workflow orchestration (Apache Airflow), and multiple database systems (MySQL, PostgreSQL, MongoDB). He holds a Harvard Business School certification in Business Analytics and multiple AWS certifications, including specialized credentials in Big Data, Data Warehousing, and Practical Data Science with Amazon SageMaker. As an educator, Mohammad brings exceptional depth to his training delivery. His academic career includes faculty positions at Payame Noor University and Islamic Azad University, where he served in leadership roles including Chancellor and Department Head. He has authored three technical books and published numerous peer-reviewed papers in international journals. His teaching repertoire covers data engineering, data science, machine learning, software development, and computer architecture, delivered through engaging, hands-on methodologies that bridge theoretical concepts with practical industry applications. Mohammad's unique combination of executive leadership, technical expertise, and proven training capabilities makes him an invaluable resource for organizations seeking to develop their data science and engineering capabilities. His ability to translate complex technical concepts into actionable learning outcomes, coupled with his extensive real-world implementation experience, ensures that training participants gain immediately applicable skills that drive business value.

8 Students

96 Courses

18 Years

( 3 ratings )

100%

( 3 reviews )

Instructor Reviews

Mohammad Mehdi Lotfinejad

Chief Data Officer & Data Science Trainer

"Mehdi and I worked on several projects with company such as Petronas , Shell and CIMB Regional ETC. I must say Mehdi's training was highly appreciated by our clients as he was able to exhibit in full display his vast knowledge as a Data professional. I would highly recommend him to anyone looking for a top tier training expert."

"Not only knowledgeable but also having hands dirty on what he knows Friendly and building networks quickly."

"I had the pleasure of working with Mehdi together on some high-level initiatives such as the Petronas data scientist program and Shell's project to become a data-driven organization. During these projects, Mehdi received numerous accolades for his ability to share his knowledge and mentor up-and-coming data scientists. Based on our shared experiences, I have no hesitation in recommending Mehdi for any project or position he may be considered for."

FAQ

Frequently Asked Questions About This Course

What level of SQL knowledge do I need before taking this Oracle Database 19c SQL Workshop?

How long is the Oracle Database 19c SQL Workshop and what teaching methods are used?

Who should attend this Oracle SQL training course?

What practical skills will I gain from this Oracle Database 19c SQL Workshop?

Does this course include hands-on practice with Oracle Database 19c?

Will I receive a certification upon completing this Oracle SQL Workshop?

What advanced SQL topics are covered in this workshop?

Where is the training conducted?

Can international participants join this course?

What is the difference between public, corporate, and training provider pricing?

Do I have to pay right away?

I just enrolled in an intake. Does that mean I can attend the course on that date?

What happens if quorum for an intake is not reached?

Why should you attend?

What you'll learn

Manipulate data using INSERT, UPDATE, DELETE, and MERGE statements effectively
Create and manage database objects including tables, views, indexes, and sequences
Work with time zone data types and perform date-time conversions accurately
Implement transaction control and maintain data integrity with constraints
Control user access through privileges, roles, and security best practices
Write efficient SELECT statements with filtering, sorting, and functions
Apply advanced SQL techniques including analytic and hierarchical queries
Perform complex multi-table queries using joins, subqueries, and set operators

End of Day 5