ANSI SQL Part I
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.
Public Pricing
Features
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 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
Uzair Aslam is a distinguished Data Scientist with an impressive track record, demonstrating a profound ability to derive insightful information from vast datasets. Starting his career in Islamabad as a Product Marketing Lead for Huaxin Technomen International, Uzair successfully merged analytical skills with strategic marketing, securing significant military contracts. His journey into data science began as a Machine Learning Intern at Maxis Telecom in Kuala Lumpur, where he excelled in model development for extracting customer points of interest and designing effective Named Entity Recognition (NER) models. Elevating his career to Senior Data Scientist roles, Uzair showcased his exceptional skillset at Maybank by pioneering a machine learning-based fraud detection model that notably enhanced efficiency and reduced false positives. His innovative approach, combining computer vision with natural language processing, streamlined document analysis and anomaly detection processes. Uzair's leadership in developing a sophisticated news web-scraping app and the C-insight Risk Reporting Dashboard further underscores his capacity to leverage technology in addressing complex business challenges. With extensive experience training corporate clients on cutting-edge data science topics and holding multiple certifications, Uzair exemplifies a blend of technical mastery and practical application in real-world scenarios.
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.'
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
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 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.
Public Pricing
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.'
Uzair Aslam is a distinguished Data Scientist with an impressive track record, demonstrating a profound ability to derive insightful information from vast datasets. Starting his career in Islamabad as a Product Marketing Lead for Huaxin Technomen International, Uzair successfully merged analytical skills with strategic marketing, securing significant military contracts. His journey into data science began as a Machine Learning Intern at Maxis Telecom in Kuala Lumpur, where he excelled in model development for extracting customer points of interest and designing effective Named Entity Recognition (NER) models. Elevating his career to Senior Data Scientist roles, Uzair showcased his exceptional skillset at Maybank by pioneering a machine learning-based fraud detection model that notably enhanced efficiency and reduced false positives. His innovative approach, combining computer vision with natural language processing, streamlined document analysis and anomaly detection processes. Uzair's leadership in developing a sophisticated news web-scraping app and the C-insight Risk Reporting Dashboard further underscores his capacity to leverage technology in addressing complex business challenges. With extensive experience training corporate clients on cutting-edge data science topics and holding multiple certifications, Uzair exemplifies a blend of technical mastery and practical application in real-world scenarios.
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.'
FAQs
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
Top companies choose Academy for Business
201601037204 (1208145-P)
