ANSI SQL Part II
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.
- Available in:
- Malaysia

Features
Subsidies

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
Short Break
15 minsShort Break
15 minsRecap and Q&A
15 minsShort Break
15 minsShort Break
15 minsRatings and Reviews
Instructor
Tarun Sukhani is a distinguished professional trainer and consultant with over 25 years of comprehensive industry experience spanning multinational corporations across the US, Europe, Asia, South America, and the Middle East. His extensive background encompasses senior executive roles including CIO/CTO, director, and board member positions at renowned organizations such as Dell, AMD, and Experian, as well as regional conglomerates like Indra in Asia Pacific. This diverse corporate experience provides him with unique insights into enterprise-level challenges and solutions across multiple business functions including HR, Finance, Operations, Sales, Risk Management, Engineering, and Accounting. As a highly sought-after trainer, Tarun specializes in an impressive array of cutting-edge technologies and methodologies. His expertise spans Agile/Scrum/SAFe frameworks, enterprise architecture (TOGAF/COBIT/ITIL), cybersecurity (CISSP/CEH/CISO), project management (PRINCE2/PMP), Big Data technologies (Hadoop/Spark), Data Science with Python and R, DevOps practices, Machine Learning/AI, cloud computing, blockchain technologies, and modern development frameworks. This comprehensive skill set enables him to deliver training across the entire technology spectrum, from foundational concepts to advanced implementations. His training delivery extends throughout the Asia Pacific region, including Malaysia, Indonesia, Philippines, Thailand, and Singapore, where he has successfully conducted workshops and training programs for both large enterprises and SMEs. Tarun's client portfolio includes industry leaders such as Dell, AMD, Western Digital, Singtel, CIMB, Digi, Tenaga Nasional, and Sime Darby, demonstrating his ability to work with diverse organizational cultures and technical requirements. Academically, Tarun holds exceptional credentials including an MSc in Information Systems and MBA in Finance and Operations Management from Loyola University Chicago, where he graduated summa cum laude with Beta Gamma Sigma and Alpha Sigma Nu honors. His educational foundation is further strengthened by Bachelor's degrees in Biology, Math, Computer Science, and Business Administration, plus advanced programs from MIT and Stanford in AI, Blockchain, and Entrepreneurship. His extensive certifications as an Agile/Scrum trainer, Java/.NET developer, Machine Learning specialist, and InfoSec expert validate his technical proficiency and commitment to continuous learning, making him an ideal trainer for organizations seeking comprehensive technology education and transformation guidance.'
Instructor
Mohammad Mehdi Lotfinejad is an accomplished Chief Data Officer and certified HRDF trainer with over 15 years of experience in computer science instruction and professional data science/engineering training. He combines extensive academic credentials with deep industry expertise, holding a PhD in Computer Science from Universiti Malaya and Harvard Business School certification in Business Analytics. His comprehensive technical background spans Apache Spark, MySQL, PostgreSQL, MongoDB, Snowflake, Redshift, Apache Airflow, API development, microservices, and Amazon Web Services. Currently serving as Chief Data and Knowledge Officer at Magna.ai, a Florida-based lawtech company, Lotfinejad leads the development of AI-driven legal case analysis systems, architecting graph databases, data warehouses, and workflow engines while ensuring compliance with legal standards. His concurrent role as Senior Data Engineer at AXIATA Digital Advertising (ADA) in Malaysia demonstrates his ability to manage complex, multi-regional data operations across Southeast Asian markets, designing automated pipelines using AWS RedShift, Snowflake, and Google BigQuery. His training expertise was honed during his tenure as Lead Senior Data Scientist Professional Trainer at The Center of Applied Data Science, where he designed and delivered comprehensive training programs for major corporations including CIMB, PETRONAS, SHELL, and TNB. He successfully led teams of data scientists and engineers in developing cutting-edge curriculum and migrating legacy systems to modern data management solutions. His academic foundation includes faculty positions at multiple universities where he taught computer architecture, programming languages, software engineering, and data structures while publishing numerous high-impact research papers and books. Lotfinejad's unique combination of technical leadership, educational expertise, and industry experience makes him exceptionally qualified to deliver sophisticated software training programs. His proven track record of leading cross-functional teams, developing enterprise-level solutions, and translating complex technical concepts into accessible learning materials positions him as an ideal trainer for organizations seeking to advance their technical capabilities in data science, engineering, and modern software development practices.'
Minimum Qualification
Target Audience
Methodologies
Prerequisites
Instructor Reviews
He was indeed very skilled, knowledgeable and passionate in the data science realm. I was impressed with his business know-how (how the world economy works and how all things can be explain with data, with/without bias) and technical skills in converting data into insights. I will not hesitate to recommend Tarun for any data science related training as I would like to attend more classes myself to learn from the best of the best.
I attended one of Tarun's Data Science course in Jakarta (CDSS). He was a professional trainer & very knowledgeable in Data Science. In his course, Tarun gave many practical examples & valuable information regarding how to conduct Data Science & it's related components (e.g. Software & Deployment Architecture). In addition to those lessons, he also gave very useful insights on building a career as a Data Scientist.
Attended "Blockchain Training: An Overview for Business Professionals" conducted by Dr. Tarun. The reference materials are very comprehensive and an excellent means of conveying information. I was very impressed with how this technology works and adapted into business
He shared his professional insights on data science with a sense of humor that cleared up so many of my questions about the content and real-world applications. Information, tools, and resources given are very useful
His knowledge of multiple subjects exceeds far greater than that of any IT or non-IT person I have met or interacted with in a long time. The breadth and depth of the subject matter he has acquired is exemplary.
Training with Tarun has been awesome. He’s super knowledgable, funny, empathetic and a great educator in general. As someone who didn’t come from a computer science background, his teachings didn’t make me feel stupid or impossible to eventually arrive at being a competent developer. I could understand him as he communicates well & has helped me see the big picture of the computer science field beyond the scope of syntaxes. If you similarly did not come from a CS background and hope to transition into the world of programming but struggle to learn on your own, understand all the foreign & abstract concepts and connect the dots, I think the right person to guide you on your journey would make a big difference. Having someone who’s deep in the field with many years of experience narrow and communicate the relevant areas to focus would also close a big gap from having to struggle and figure out a lot of things on your own. Being able to maintain your interest during your learning journey is important too, thus finding that someone is important. All in all, I would wholeheartedly recommend Tarun and the backend course I took.
Tarun is a results-driven & inspirational technology leader with a clear vision, direction, and broad-based technology expertise. He is passionate, intuitive, engaged, pragmatic, systematic, agile. His experiences span from small start-ups to complex, global companies, from being technical lead to technical strategist to being the leader of larger group of architecture and engineering teams. Much of his experiences are in the area of Java, Scala, Machine Learning, Neural Networks, Cloud Computing, Data Science and what not. I am truly amazed to experience his breadth & depth of technological expertise and pleasure to be part of his team.
Tarun is very passionate on the domains and gave numerous insights to support critical business decisions and develop data products to transform daily encounters and processes. He was a professional trainer & very knowledgeable in Data Science. His material is presented through a sequence of brief lectures, interactive demonstrations, great hands-on exercises, and discussions.
We’ve been collaborated many times in doing courses for the accountants. He spoke to quiet number of event in our company with various topic regards to accountants need. The collaboration was very smooth and his session definitely made a huge impact on our success. Mr Tarun is a great Professional!
Mr. Tarun is a driven, hardworking, and knowledgeable entrepreneur in his field." A broad-minded trainer who embraces change and inspires people to do better every day. Mr. Tarun sets a good example by being enthusiastic and dedicated, and he inspires and motivates others. I am delighted to be working for such personnel
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.
FAQs
- 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.
Courses you may like
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
Short Break
15 minsShort Break
15 minsRecap and Q&A
15 minsShort Break
15 minsShort Break
15 minsInstructor Reviews
He was indeed very skilled, knowledgeable and passionate in the data science realm. I was impressed with his business know-how (how the world economy works and how all things can be explain with data, with/without bias) and technical skills in converting data into insights. I will not hesitate to recommend Tarun for any data science related training as I would like to attend more classes myself to learn from the best of the best.
I attended one of Tarun's Data Science course in Jakarta (CDSS). He was a professional trainer & very knowledgeable in Data Science. In his course, Tarun gave many practical examples & valuable information regarding how to conduct Data Science & it's related components (e.g. Software & Deployment Architecture). In addition to those lessons, he also gave very useful insights on building a career as a Data Scientist.
Attended "Blockchain Training: An Overview for Business Professionals" conducted by Dr. Tarun. The reference materials are very comprehensive and an excellent means of conveying information. I was very impressed with how this technology works and adapted into business
He shared his professional insights on data science with a sense of humor that cleared up so many of my questions about the content and real-world applications. Information, tools, and resources given are very useful
His knowledge of multiple subjects exceeds far greater than that of any IT or non-IT person I have met or interacted with in a long time. The breadth and depth of the subject matter he has acquired is exemplary.
Training with Tarun has been awesome. He’s super knowledgable, funny, empathetic and a great educator in general. As someone who didn’t come from a computer science background, his teachings didn’t make me feel stupid or impossible to eventually arrive at being a competent developer. I could understand him as he communicates well & has helped me see the big picture of the computer science field beyond the scope of syntaxes. If you similarly did not come from a CS background and hope to transition into the world of programming but struggle to learn on your own, understand all the foreign & abstract concepts and connect the dots, I think the right person to guide you on your journey would make a big difference. Having someone who’s deep in the field with many years of experience narrow and communicate the relevant areas to focus would also close a big gap from having to struggle and figure out a lot of things on your own. Being able to maintain your interest during your learning journey is important too, thus finding that someone is important. All in all, I would wholeheartedly recommend Tarun and the backend course I took.
Tarun is a results-driven & inspirational technology leader with a clear vision, direction, and broad-based technology expertise. He is passionate, intuitive, engaged, pragmatic, systematic, agile. His experiences span from small start-ups to complex, global companies, from being technical lead to technical strategist to being the leader of larger group of architecture and engineering teams. Much of his experiences are in the area of Java, Scala, Machine Learning, Neural Networks, Cloud Computing, Data Science and what not. I am truly amazed to experience his breadth & depth of technological expertise and pleasure to be part of his team.
Tarun is very passionate on the domains and gave numerous insights to support critical business decisions and develop data products to transform daily encounters and processes. He was a professional trainer & very knowledgeable in Data Science. His material is presented through a sequence of brief lectures, interactive demonstrations, great hands-on exercises, and discussions.
We’ve been collaborated many times in doing courses for the accountants. He spoke to quiet number of event in our company with various topic regards to accountants need. The collaboration was very smooth and his session definitely made a huge impact on our success. Mr Tarun is a great Professional!
Mr. Tarun is a driven, hardworking, and knowledgeable entrepreneur in his field." A broad-minded trainer who embraces change and inspires people to do better every day. Mr. Tarun sets a good example by being enthusiastic and dedicated, and he inspires and motivates others. I am delighted to be working for such personnel
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.
Features
Subsidies

Ratings and Reviews
Instructors
Tarun Sukhani is a distinguished professional trainer and consultant with over 25 years of comprehensive industry experience spanning multinational corporations across the US, Europe, Asia, South America, and the Middle East. His extensive background encompasses senior executive roles including CIO/CTO, director, and board member positions at renowned organizations such as Dell, AMD, and Experian, as well as regional conglomerates like Indra in Asia Pacific. This diverse corporate experience provides him with unique insights into enterprise-level challenges and solutions across multiple business functions including HR, Finance, Operations, Sales, Risk Management, Engineering, and Accounting. As a highly sought-after trainer, Tarun specializes in an impressive array of cutting-edge technologies and methodologies. His expertise spans Agile/Scrum/SAFe frameworks, enterprise architecture (TOGAF/COBIT/ITIL), cybersecurity (CISSP/CEH/CISO), project management (PRINCE2/PMP), Big Data technologies (Hadoop/Spark), Data Science with Python and R, DevOps practices, Machine Learning/AI, cloud computing, blockchain technologies, and modern development frameworks. This comprehensive skill set enables him to deliver training across the entire technology spectrum, from foundational concepts to advanced implementations. His training delivery extends throughout the Asia Pacific region, including Malaysia, Indonesia, Philippines, Thailand, and Singapore, where he has successfully conducted workshops and training programs for both large enterprises and SMEs. Tarun's client portfolio includes industry leaders such as Dell, AMD, Western Digital, Singtel, CIMB, Digi, Tenaga Nasional, and Sime Darby, demonstrating his ability to work with diverse organizational cultures and technical requirements. Academically, Tarun holds exceptional credentials including an MSc in Information Systems and MBA in Finance and Operations Management from Loyola University Chicago, where he graduated summa cum laude with Beta Gamma Sigma and Alpha Sigma Nu honors. His educational foundation is further strengthened by Bachelor's degrees in Biology, Math, Computer Science, and Business Administration, plus advanced programs from MIT and Stanford in AI, Blockchain, and Entrepreneurship. His extensive certifications as an Agile/Scrum trainer, Java/.NET developer, Machine Learning specialist, and InfoSec expert validate his technical proficiency and commitment to continuous learning, making him an ideal trainer for organizations seeking comprehensive technology education and transformation guidance.'
Mohammad Mehdi Lotfinejad is an accomplished Chief Data Officer and certified HRDF trainer with over 15 years of experience in computer science instruction and professional data science/engineering training. He combines extensive academic credentials with deep industry expertise, holding a PhD in Computer Science from Universiti Malaya and Harvard Business School certification in Business Analytics. His comprehensive technical background spans Apache Spark, MySQL, PostgreSQL, MongoDB, Snowflake, Redshift, Apache Airflow, API development, microservices, and Amazon Web Services. Currently serving as Chief Data and Knowledge Officer at Magna.ai, a Florida-based lawtech company, Lotfinejad leads the development of AI-driven legal case analysis systems, architecting graph databases, data warehouses, and workflow engines while ensuring compliance with legal standards. His concurrent role as Senior Data Engineer at AXIATA Digital Advertising (ADA) in Malaysia demonstrates his ability to manage complex, multi-regional data operations across Southeast Asian markets, designing automated pipelines using AWS RedShift, Snowflake, and Google BigQuery. His training expertise was honed during his tenure as Lead Senior Data Scientist Professional Trainer at The Center of Applied Data Science, where he designed and delivered comprehensive training programs for major corporations including CIMB, PETRONAS, SHELL, and TNB. He successfully led teams of data scientists and engineers in developing cutting-edge curriculum and migrating legacy systems to modern data management solutions. His academic foundation includes faculty positions at multiple universities where he taught computer architecture, programming languages, software engineering, and data structures while publishing numerous high-impact research papers and books. Lotfinejad's unique combination of technical leadership, educational expertise, and industry experience makes him exceptionally qualified to deliver sophisticated software training programs. His proven track record of leading cross-functional teams, developing enterprise-level solutions, and translating complex technical concepts into accessible learning materials positions him as an ideal trainer for organizations seeking to advance their technical capabilities in data science, engineering, and modern software development practices.'
Minimum Qualification
Target Audience
Methodologies
Prerequisites
FAQs
- 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.
Courses you may like
Our Offers

Become a Trainer
Teach what you love. Abundent Academy gives you the tools you need to run your own trainings! We provide you with the platform, the students, the materials, and the support you need to succeed!
- Higher trainer payouts
- Ready-made course materials
- Student management system
- AI digital marketing assistant

Academy for Business
Get unlimited access to all of Abundent Academy's carefully curated courses for your team, all organized according to job category and role! Perfect for companies looking to upskill their workforce and stay ahead in the tech industry.
- Carefully curated courses
- Role-based learning paths
- Team progress tracking
- Gap Identification and Analysis