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.

updated
beginner
ANSI SQL Part II

Public Pricing

MYR 500

Features

5 hours
5 modules
27 intakes
Full life-time access
English

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

Learn how to create and use stored procedures
Understand the different types stored procedures
Learn how to use stored procedures to automate tasks
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
Short Break
15 mins
Short Break
15 mins

Instructor

Loading...
Tarun Sukhani Founder & CTO Teaching

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

21 Students
245 Courses
English, Malay, Spanish
25 Years

Instructor

Loading...
Mohammad Mehdi Lotfinejad Certified Data Science Trainer and Data Engineer Teaching

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

8 Students
75 Courses
18 Years

Minimum Qualification

basic IT

Target Audience

engineers
mid level managers
senior managers

Methodologies

lecture
slides
case studies
labs

Prerequisites

Instructor Reviews

Tarun Sukhani Founder & CTO
review avatar
Michael Wong Shen Kai
3 years ago
3 years ago

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.

review avatar
Anak Agung
3 years ago
3 years ago

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.

review avatar
Pei Cher Chai
3 years ago
3 years ago

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

review avatar
LJ Ong
3 years ago
3 years ago

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

AS
Aamer S
3 years ago
3 years ago

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.

JK
Jovyn Kim
3 years ago
3 years ago

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.

review avatar
Srikanth K
3 years ago
3 years ago

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.

review avatar
Zulfikri Y
3 years ago
3 years ago

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.

review avatar
Marti Sigi
5 years ago
5 years ago

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!

PK
Pravena K
3 years ago
3 years ago

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

Mohammad Mehdi Lotfinejad Certified Data Science Trainer and Data Engineer
review avatar
Michael Ogheneme
1 year ago
1 year ago

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.

review avatar
Amin Jula
1 year ago
1 year ago

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

review avatar
Kennedy Okonkwo
1 year ago
1 year ago

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

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

Learn how to create and use stored procedures
Understand the different types stored procedures
Learn how to use stored procedures to automate tasks
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
Short Break
15 mins
Short Break
15 mins

Instructor Reviews

Tarun Sukhani Founder & CTO
review avatar
Michael Wong Shen Kai
3 years ago
3 years ago

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.

review avatar
Anak Agung
3 years ago
3 years ago

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.

review avatar
Pei Cher Chai
3 years ago
3 years ago

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

review avatar
LJ Ong
3 years ago
3 years ago

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

AS
Aamer S
3 years ago
3 years ago

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.

JK
Jovyn Kim
3 years ago
3 years ago

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.

review avatar
Srikanth K
3 years ago
3 years ago

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.

review avatar
Zulfikri Y
3 years ago
3 years ago

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.

review avatar
Marti Sigi
5 years ago
5 years ago

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!

PK
Pravena K
3 years ago
3 years ago

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

Mohammad Mehdi Lotfinejad Certified Data Science Trainer and Data Engineer
review avatar
Michael Ogheneme
1 year ago
1 year ago

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.

review avatar
Amin Jula
1 year ago
1 year ago

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

review avatar
Kennedy Okonkwo
1 year ago
1 year ago

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

Features

5 hours
5 modules
27 intakes
Full life-time access
English

Subsidies

HRDC Claimable logo

Instructors

Loading...
Tarun Sukhani Founder & CTO Teaching

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

21 Students
245 Courses
English, Malay, Spanish
25 Years
Loading...
Mohammad Mehdi Lotfinejad Certified Data Science Trainer and Data Engineer Teaching

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

8 Students
75 Courses
18 Years

Minimum Qualification

basic IT

Target Audience

engineers
mid level managers
senior managers

Methodologies

lecture
slides
case studies
labs

Prerequisites

FAQs

Close menu