This session will provide a foundational introduction to SQL, tailored specifically for new data engineers working within the Microsoft ecosystem of data platform tools. We will begin with the very basics of the ANSI standard, ensuring that participants gain a solid understanding of SQL as a language. We will explore the essential concepts of SQL, including data retrieval, modification, and manipulation, all while becoming familiar with the standard syntax and commands that form the basis of SQL across various platforms.

As we progress, we will delve into the specifics of T-SQL and Spark SQL, exploring how these dialects have evolved within the Microsoft SQL family of products and Apache Spark environments. Attendees will gain insights into the unique features and capabilities of each variant, learning how to effectively leverage T-SQL for powerful data management and analysis within SQL Server, as well as how to harness the scalability and performance of Spark SQL for big data processing in Spark implementations. By the end of this session, participants will have the skills and knowledge to confidently structure and query data with the language.