SQL Foundations
By External Provider
About this course
Learn the fundamentals of SQL with Microsoft SQL Server in this introductory course. You'll learn to write basic and intermediate queries to extract and analyze data while understanding relational database concepts. Through hands-on exercises with SQL Server Management Studio, you'll practice filtering data with WHERE clauses, sorting results with ORDER BY, and transforming data with built-in functions. This course also introduces you to database schemas, tables, and views, providing a foundation for understanding data structure. Additionally, you'll explore how generative AI tools can assist with SQL query development, reflecting modern workplace practices. By completing this course, you'll build confidence writing T-SQL queries and be prepared for more advanced data manipulation techniques.
What you will learn
- Write SQL queries using SELECT, WHERE, ORDER BY, and built-in SQL functions to retrieve and analyze data
- Understand relational database concepts including schemas, tables, views, and structured data organization
- Use Microsoft SQL Server Management Studio to create, filter, sort, and transform data efficiently
- Apply generative AI tools to support SQL query writing, debugging, and data analysis workflows