Looking for a place to build your own solid SQL foundation? This learning path will teach you basic SQL statements like WHERE, GROUP BY, ORDER BY, and HAVING. You’ll also learn how to JOIN tables and add, modify, or remove data from a database.
37 free interactive coding challenges
This learning path is designed for complete SQL beginners with no previous knowledge of SQL or databases. It benefits data analysts working with relational databases or anyone interested in learning standard SQL. Scroll down for details.
Welcome to SQL Foundations! This learning path will give you a practical overview of SQL. You’ll find out how to write an SQL query and how to use common functions to work with a database. Our hands-on approach has you writing code all by yourself very early in the first course. We'll start simple (promise!) and learn the bare basics. Then we’ll slowly progress to more advanced features, like combining data from multiple tables with JOIN or building complex SQL queries using aggregations or subqueries (i.e. queries inside queries). By the end of this track, you’ll feel comfortable inserting, updating, and deleting data from a database. You’ll also be able to create a basic SQL report from scratch and work with multiple tables in one query.
What's in it for me?
Who should take this learning path?
Start here if you're new to SQL Server. Learn the basics of T-SQL for SQL Server, retrieve data from an SQL Server database and build simple reports.
Learn how to use common T-SQL functions to process various types of data with ease. Soon, you’ll be able to modify textual data, perform calculations, round numbers up or down, change date and time formats, and even adjust time zone info!
Discover SQL Server data manipulation language (DML) processes. Learn how to insert, update, and delete data from a database.
5.00 / 5