Intro to SQL

О курсе

Discover how to build efficient, data-driven applications using SQL, the essential database language. In this interactive Scrimba course, you'll write SQL queries against the database of a retro car store, solving practical coding challenges and improving your muscle memory as you go. In Section One, you’ll discover the core building blocks of SQL by writing real queries against real data. You’ll cover everything from SELECT statements and filtering with WHERE, to sorting, grouping, and basic data manipulation with INSERT, UPDATE, and DELETE. Section Two goes beyond single-table queries. You’ll learn how to work with relational data, including creating and modifying tables, populating them with data, and using different types of joins to combine data across tables. Finally, Section Three introduces more advanced logic, showing you how to use ANY, ALL, and EXISTS for powerful subqueries, and how to apply CASE expressions in SELECT, WHERE, and UPDATE clauses to create dynamic, flexible queries. By the end, you’ll have built a solid foundation in SQL and developed the skills to work effectively with real-world databases.

Навыки, которые вы освоите

Учитесь у экспертов

Gregor Thomson

Преподаватель курса