Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Introduction to SQL

via Pluralsight

Overview

Learn SQL from scratch and master practical database querying, including using Generative AI tools. Whether you need SQL for data analysis, software development, or better business insights, we'll cover all the fundamentals of real-world SQL skills.

In this engaging, fast-paced course, you'll learn the fundamentals of SQL and gain practical skills for querying databases, including leveraging the latest Generative AI tools for SQL. We'll begin with a quick crash course on relational database fundamentals to ensure you have a solid foundation. From there, we'll dive into the essential concepts and syntax of SQL, building upon them to explore more advanced topics. You'll discover how to create and manipulate tables, retrieve and filter data using SELECT statements, and perform more complex queries with joins, subqueries, and aggregations. Throughout the course, we'll focus on helping you change your thought process to make writing queries more intuitive and efficient. We'll explore common questions people have when learning SQL, cover real-world best practices, and even dig into how you can now use Generative AI to supercharge your SQL skills. By the end of this course, you'll have a solid understanding of SQL and the practical skills to effectively manipulate and analyze data in various domains.

Syllabus

  • Introduction 10mins
  • Database Fundamentals 30mins
  • Writing SQL Queries 31mins
  • Ordering, Grouping, and Aggregate Functions 19mins
  • How to JOIN Tables 15mins
  • Subqueries and Sets 10mins
  • Adding, Updating, and Deleting Data 6mins
  • Additional Topics 13mins

Taught by

Simon Allardice

Reviews

4.9 rating at Pluralsight based on 96 ratings

Start your review of Introduction to SQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.