ANSI SQL Part I: Master Database Fundamentals & Query Techniques
Elevate your database management capabilities with our focused ANSI-SQL course. Learn to navigate through the complexities of SQL syntax, manipulate data proficiently, and seamlessly combine table data using joins. Gain practical skills in creating views to optimize your querying process for a robust SQL skill set.
- Available in:
- Malaysia
- Upcoming intakes:
- Feb 13, 2026
- Feb 13, 2026
- Feb 13, 2026
- Feb 13, 2026
- Feb 23, 2026
- Feb 23, 2026
- Feb 23, 2026
- Feb 24, 2026
- Feb 24, 2026
- Feb 24, 2026
- Feb 25, 2026
- Feb 25, 2026
- Feb 25, 2026
- Feb 26, 2026
- Feb 26, 2026
- Feb 26, 2026
- Feb 27, 2026
- Feb 27, 2026
- Feb 27, 2026
- Mar 9, 2026
- Mar 10, 2026
- Mar 11, 2026
- Mar 12, 2026
- Mar 13, 2026
Training Provider Pricing
Pax:
Features
Target Audience
Methodologies
Subsidies

What you'll learn
- Understand how to utilize different types of joins to merge table data
- Simplify complex queries using views for better database performance
- Acquire the knowledge to create and manage various types of views
- Master commands for effective data manipulation such as create, update, and delete
- Grasp the fundamental concepts and components of ANSI-SQL
- Develop proficiency in crafting subqueries for advanced data retrieval
- Learn to write basic SQL queries using correct syntax and clauses
Why should you attend?
Dive into the world of structured query language with this comprehensive ANSI-SQL course designed to equip you with a solid foundation in database management. Begin by understanding the basics of ANSI-SQL, including its core components and various data types that form the backbone of SQL databases. As you progress, learn to master the essential syntax that underpins every SQL command, enabling you to write effective queries with ease. The course further delves into data manipulation techniques, teaching you how to adeptly create, update, and delete data within your databases using specific commands. Additionally, gain expertise in combining data from multiple tables through various types of joins and enrich your skill set by learning how to craft subqueries for more complex data retrieval. Finally, discover the power of views in SQL and understand how they can be used to streamline and simplify intricate queries, making your database management tasks more efficient.
Course Syllabus
Short Break
15 minsRecap and Q&A
15 minsRatings and Reviews
Instructor
Instructor
Instructor
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
- 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.
We will keep you updated on the status of the intake after you enroll.
Courses you may like
Why should you attend?
Dive into the world of structured query language with this comprehensive ANSI-SQL course designed to equip you with a solid foundation in database management. Begin by understanding the basics of ANSI-SQL, including its core components and various data types that form the backbone of SQL databases. As you progress, learn to master the essential syntax that underpins every SQL command, enabling you to write effective queries with ease. The course further delves into data manipulation techniques, teaching you how to adeptly create, update, and delete data within your databases using specific commands. Additionally, gain expertise in combining data from multiple tables through various types of joins and enrich your skill set by learning how to craft subqueries for more complex data retrieval. Finally, discover the power of views in SQL and understand how they can be used to streamline and simplify intricate queries, making your database management tasks more efficient.
What you'll learn
- Understand how to utilize different types of joins to merge table data
- Simplify complex queries using views for better database performance
- Acquire the knowledge to create and manage various types of views
- Master commands for effective data manipulation such as create, update, and delete
- Grasp the fundamental concepts and components of ANSI-SQL
- Develop proficiency in crafting subqueries for advanced data retrieval
- Learn to write basic SQL queries using correct syntax and clauses
Course Syllabus
Short Break
15 minsRecap and Q&A
15 minsInstructor 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."
Training Provider Pricing
Pax:
Features
Target Audience
Methodologies
Subsidies

Ratings and Reviews
Instructors
Courses you may like
FAQ
Frequently Asked Questions About This Course
- 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.
We will keep you updated on the status of the intake after you enroll.
Our Offers
Academy for Trainers Academy for Trainers
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 Corporates Academy for Corporates
Get unlimited access to all of Abundent Academy's carefully curated courses for your team, all organized according to learning paths and roles! 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
Academy for Partners Academy for Partners
White-label IT training delivery for training providers. We become your behind-the-scenes delivery arm so you can say yes to more clients without hiring more trainers.
- Expand your training catalog
- 40+ expert trainers ready
- White-label delivery
- You keep client relationships