ANSI SQL Part II: Advanced Database Programming & Security Course

Elevate your database expertise with our specialized ANSI SQL course. Master stored procedures, triggers, indexes, and security protocols to optimize and secure your databases. Gain hands-on experience in implementing advanced SQL features for peak performance.

Face-to-Face Jul 27, 2026 9:00 AM - 1:00 PM Mohammad Mehdi Lotfinejad
updated
beginner
ANSI SQL Part II

Public Pricing

MYR 500

Training Provider Pricing

Pax:

Training Fees: MYR 2400/day
Material Fees: MYR 400
Total Fees: MYR 1750 ++

Features

4 hours
4 modules
39 intakes
Full life-time access
English
Technical: 25 pax

Target Audience

engineers
managers
executives

Methodologies

lecture
slides
labs
case studies

Subsidies

HRDC Claimable logo

What you'll learn

  • Explore advanced ANSI-SQL features for performance optimization
  • Design and implement efficient indexes to speed up queries
  • Automate database operations using triggers
  • Differentiate between various types of stored procedures and triggers
  • Create and utilize stored procedures for routine tasks
  • Control access to data through proper use of permissions
  • Understand and apply different security measures for database protection

Why should you attend?

Dive into the advanced functionalities of ANSI SQL with our in-depth course designed to enhance your database management skills. Learn how to streamline your workflow and ensure data integrity through the use of stored procedures, which allow for the encapsulation of complex operations into simple callable units. Explore the dynamic world of triggers and understand how they can automate tasks by responding to specific changes within your database. Enhance query efficiency by mastering indexes, gaining knowledge on their creation, types, and usage for optimized query performance. Elevate your understanding of database security measures and learn to implement robust security protocols to protect sensitive information effectively. The course culminates with a focus on advanced topics, providing insights into the sophisticated features of ANSI SQL that are crucial for optimizing performance and maintaining cutting-edge database systems.

Course Syllabus

Module 1
Creating and using stored procedures
Types of stored procedures and their applications
Creating and implementing triggers
Types of triggers and automation use cases
Module 2
Short Break
15 mins
Module 3
Module 4
Recap and Q&A
15 mins

Instructor

Loading...
Mohammad Mehdi Lotfinejad Chief Data Officer & Data Science Trainer
Trainer Profile
Trainer Profile
TTT Certificate
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
104 Courses
18 Years

Instructor

Loading...
Mohammed Al-obaydee AI & Data Science Expert
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Dr. Mohammed Al-Obaydee is a distinguished academic and industry professional with extensive expertise in artificial intelligence, machine learning, deep learning, and data science. As an Adjunct Associate Professor at Taylor's University Malaysia and a certified Train the Trainer professional, he brings a unique blend of academic rigor and practical industry experience to his teaching and consulting engagements. With a Ph.D. in Information Science from Universiti Kebangsaan Malaysia (UKM) and over two decades of experience spanning academia and industry, Dr. Al-Obaydee has established himself as a leading authority in advanced computing technologies. His research excellence is evidenced by multiple best paper awards, including recognition at IEEE ACSAT2014 and ITNG 2023 conferences, along with an impressive publication record featuring over 149 citations and an h-index of 6. His research focuses on medical image analysis, computer vision, machine learning applications, and deep learning techniques. As a founder of INNOEYETIVE and AIC4ALL, Dr. Al-Obaydee demonstrates entrepreneurial acumen in leveraging AI and immersive technologies for digital transformation. His industry experience includes successful training and consultation projects with major corporations such as HSBC Bank, OCBC Bank, DELL Malaysia, Amway Malaysia, and EtiQa, where he has delivered specialized programs in data science, analytics, and applied AI engineering. His ability to bridge the gap between theoretical concepts and practical applications makes him an exceptional trainer for professionals seeking to upskill in emerging technologies. Dr. Al-Obaydee's teaching portfolio encompasses a comprehensive range of subjects including Machine Learning, Deep Learning, Data Analytics, Data Engineering, Parallel Computing, and Advanced Data Structures. He has supervised numerous master's students and research projects at both Taylor's University and the International Islamic University Malaysia (IIUM), focusing on cutting-edge topics such as deep reinforcement learning, medical image classification, fraud detection, and natural language processing. His international speaking engagements and extensive training experience across multiple organizations demonstrate his exceptional communication skills and ability to make complex technical concepts accessible to diverse audiences.
113 Courses
English
21 Years

Prerequisites

Instructor Reviews

ML

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

Why should you attend?

Dive into the advanced functionalities of ANSI SQL with our in-depth course designed to enhance your database management skills. Learn how to streamline your workflow and ensure data integrity through the use of stored procedures, which allow for the encapsulation of complex operations into simple callable units. Explore the dynamic world of triggers and understand how they can automate tasks by responding to specific changes within your database. Enhance query efficiency by mastering indexes, gaining knowledge on their creation, types, and usage for optimized query performance. Elevate your understanding of database security measures and learn to implement robust security protocols to protect sensitive information effectively. The course culminates with a focus on advanced topics, providing insights into the sophisticated features of ANSI SQL that are crucial for optimizing performance and maintaining cutting-edge database systems.


What you'll learn

  • Explore advanced ANSI-SQL features for performance optimization
  • Design and implement efficient indexes to speed up queries
  • Automate database operations using triggers
  • Differentiate between various types of stored procedures and triggers
  • Create and utilize stored procedures for routine tasks
  • Control access to data through proper use of permissions
  • Understand and apply different security measures for database protection

Course Syllabus

Module 1
Creating and using stored procedures
Types of stored procedures and their applications
Creating and implementing triggers
Types of triggers and automation use cases
Module 2
Short Break
15 mins
Module 3
Module 4
Recap and Q&A
15 mins

Instructor Reviews

ML

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."

Public Pricing

MYR 500

Training Provider Pricing

Pax:

Training Fees: MYR 2400/day
Material Fees: MYR 400
Total Fees: MYR 1750 ++

Features

4 hours
4 modules
39 intakes
Full life-time access
English
Technical: 25 pax

Target Audience

engineers
managers
executives

Methodologies

lecture
slides
labs
case studies

Subsidies

HRDC Claimable logo

Instructors

Loading...
Mohammad Mehdi Lotfinejad Chief Data Officer & Data Science Trainer
Trainer Profile
Trainer Profile
TTT Certificate
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
104 Courses
18 Years
Loading...
Mohammed Al-obaydee AI & Data Science Expert
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Dr. Mohammed Al-Obaydee is a distinguished academic and industry professional with extensive expertise in artificial intelligence, machine learning, deep learning, and data science. As an Adjunct Associate Professor at Taylor's University Malaysia and a certified Train the Trainer professional, he brings a unique blend of academic rigor and practical industry experience to his teaching and consulting engagements. With a Ph.D. in Information Science from Universiti Kebangsaan Malaysia (UKM) and over two decades of experience spanning academia and industry, Dr. Al-Obaydee has established himself as a leading authority in advanced computing technologies. His research excellence is evidenced by multiple best paper awards, including recognition at IEEE ACSAT2014 and ITNG 2023 conferences, along with an impressive publication record featuring over 149 citations and an h-index of 6. His research focuses on medical image analysis, computer vision, machine learning applications, and deep learning techniques. As a founder of INNOEYETIVE and AIC4ALL, Dr. Al-Obaydee demonstrates entrepreneurial acumen in leveraging AI and immersive technologies for digital transformation. His industry experience includes successful training and consultation projects with major corporations such as HSBC Bank, OCBC Bank, DELL Malaysia, Amway Malaysia, and EtiQa, where he has delivered specialized programs in data science, analytics, and applied AI engineering. His ability to bridge the gap between theoretical concepts and practical applications makes him an exceptional trainer for professionals seeking to upskill in emerging technologies. Dr. Al-Obaydee's teaching portfolio encompasses a comprehensive range of subjects including Machine Learning, Deep Learning, Data Analytics, Data Engineering, Parallel Computing, and Advanced Data Structures. He has supervised numerous master's students and research projects at both Taylor's University and the International Islamic University Malaysia (IIUM), focusing on cutting-edge topics such as deep reinforcement learning, medical image classification, fraud detection, and natural language processing. His international speaking engagements and extensive training experience across multiple organizations demonstrate his exceptional communication skills and ability to make complex technical concepts accessible to diverse audiences.
113 Courses
English
21 Years

Prerequisites

FAQ

Frequently Asked Questions About This Course

Close menu