SQL beginners
You’re new to databases and want a structured way to stop guessing and start understanding. You want to build a foundation that makes future learning (and job requirements) feel approachable.
SQL - The Complete Developer's Guide (MySQL, PostgreSQL)
From data definition to manipulation (CRUD, relations, JOIN): Learn SQL for MySQL, Postgresql & more from the ground up!
Course Overview
About This Course
You’ve probably bumped into SQL in job posts, tutorials, or at work—and it can feel like everyone assumes you already “just know” how to query a database. Maybe you can copy a query, but writing your own (or understanding why it works) still feels shaky.
This course gives you a clear, detailed path to real confidence with SQL, without requiring any prior database or programming experience. You can follow the full step-by-step route or take the quick summary path when you need the essentials fast—and you’ll see everything demonstrated in both MySQL and PostgreSQL.
By the end, you’ll be able to set up your database environment, create solid table structures, and work with data of different shapes and complexity. You’ll confidently write your own queries—from straightforward lookups to more involved requests—and you’ll know how to structure and optimize databases so they stay maintainable as they grow.
What You'll Learn
You’ll practice the same SQL ideas in both MySQL and PostgreSQL, so you can move between database systems without feeling like you’re starting over.
Write SQL confidently
Use core SQL syntax to write commands from scratch instead of relying on copy/paste. You’ll understand what SQL is doing and how to express what you want the database to return.
Install database setups
Install MySQL and PostgreSQL and connect through different clients. You’ll be able to get a working environment running so you can execute queries and manage databases locally.
Perform CRUD operations
Create, read, update, and delete data using SQL in a controlled way. You’ll insert records into tables and safely change or remove data when requirements evolve.
Query and filter data
Retrieve exactly the rows you need with simple and complex queries. You’ll filter results and shape outputs so they match real questions you need to answer from your data.
Design normalized tables
Split data across multiple tables to avoid duplication and keep your database clean. You’ll create and structure tables with appropriate data types for the kind of data you store.
Join and aggregate results
Merge data from multiple tables into combined result sets and summarize it with grouping and aggregation. You’ll also use built-in functions for numbers, text, and dates to produce useful outputs.
Ready to get started?
Prerequisites
No prior SQL or database knowledge is required.
No programming experience is required.
Who Is This Course For?
Web developers
You build applications and need to incorporate a relational database without feeling blocked by query writing. You want to be able to work comfortably with SQL in MySQL or PostgreSQL depending on the project.
Data analysts
You work with data (or want to) and keep running into SQL as a must-have skill. You want to pull, combine, and summarize data yourself instead of waiting on someone else to write queries.
Curriculum Overview
Start NowPreview the structure and pacing of this course before you begin.
And 5 more sections in the full course.
Ready to Get Started?
Choose the option that works best for you.
Single Course
SQL - The Complete Developer's Guide (MySQL, PostgreSQL)
One Payment. Lifetime Access.
$69one-time
- One-time payment
- All future updates for this course
- Downloadable resources & code
- Certificate of completion
- Hands-on exercises & projects
- Self-paced learning
- English captions on all videos
- Lifetime access
Most Popular
All-Access Membership
Everything we teach. One subscription.
$25/mo
$4,335+ worth of courses
- Full access to all courses
- All future courses included
- Downloadable resources & code
- Certificates of completion
- Hands-on exercises & projects
- Self-paced learning
- English captions on all videos
- Cancel anytime