SQL in 30 – SELECT Basics

On-demand Learning

Join us for our new learning SQL series. This is a progressive course that will help you learn SQL basics as a foundation for learning.

This first foundational session introduces the SELECT statement, the most frequently used SQL command for retrieving data from databases and the most typical starting point for the SQL learning journey.

Participants will learn how to:

  • select specific columns
  • sort results with ORDER BY
  • limit rows using TOP
  • filter data with WHERE clauses, and
  • aggregate data using GROUP BY and HAVING.

The session focuses on SQL formatting, the logical execution order of query clauses, and some best practices for crafting  efficient, readable, performant and maintainable SELECT queries using the AdventureWorks2025 database.

Instructor

Hristo Hristov is a seasoned data professional with experience spanning the intersection of data engineering and smart manufacturing solutions. Since 2017, he specializes in implementing advanced analytics solutions for bridging the IT/OT gap.

A technical writer with over fifty published articles on data and AI technologies, Python development, and cloud solutions. Passionate about transforming complex data into business value through innovative applications of Azure Data Platform, Python, IoT solutions, databases, and other cloud technologies.

Currently applying Industry 4.0 best practices, focusing on IoT connectivity, and implementing data and AI systems in manufacturing. Hristo holds a degree in Data Science and several Microsoft certifications covering SQL, Power BI, and related technologies.

Name(Required)

3 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *