New 'Learn SQL' Course Launched on Boot.dev
I’m happy to announce that today we launched our new Learn SQL course! It was a ton of fun to write, but I also had a blast building the back-end infrastructure that allows students to write and execute SQL in the browser. If you’ve been wanting to gain a solid foundation of SQL skills, this course is for you!
What’s in the course?
You’ll learn all the fundamentals of SQL in this 11-chapter course. The instructions will all in an image + text format, but the cool part is that on each assignment you’ll be writing and running real SQLite queries in your browser! No need to set up a local database environment and install a client. The 11 chapters are:
- What is SQL?
- Tables
- Constraints
- CRUD operations (how databases play a role in web apps)
- Basic Queries
- Structuring Data
- Aggregations
- Subqueries
- Normalization
- Joins
- Performance
This course really rounds out our entire back-end path - all the major pieces are there! Of course, we’ll still be adding to and updating the content regularly, but this SQL course was a big “missing piece”.
What does it cost?
At the time of release, the first 3 chapters of the course are free. After that, you can become a member to unlock full access for $34/mo!
Related Articles
The More Mentors, The Better (When Learning to Code)
Sep 13, 2022 by Lane Wagner - Boot.dev co-founder and backend engineer
Vim or VS Code? Tabs or spaces? Rails or Django? The world of programming is fraught with decisions to be made. Sometimes experienced developers are able to share their beliefs in a somewhat objective way. That said, we’re all human, and opinions can come across as gospel when we’re not careful.
Boot.dev Hackathon September 1st, 2022
Sep 03, 2022 by Lane Wagner - Boot.dev co-founder and backend engineer
Mark your calendar, because we’re hosting another hackathon in the Boot.dev Discord server! The kickoff meeting will be on Thursday, September 1st at 4PM MST, you can RSVP for that event here in our Discord server. Everyone is welcome to participate, in fact, it’s free and we’ll have prizes for all the winners!
What Would a Recession Mean For Developers?
May 26, 2022 by Lane Wagner - Boot.dev co-founder and backend engineer
With markets in a slump, many of us are concerned a recession could be right around the corner. The NASDAQ is already down 27% so far in 2022. Heck, maybe we’re already in the middle of a recession.
We Just Launched Community Insights
Apr 27, 2022 by Lane Wagner - Boot.dev co-founder and backend engineer
tl;dr At Boot.dev we’ve launched “community insights”! Insights make it possible for our students to drop comments at the bottom of any step in our coding courses. We’ve quickly found that we have amazing students, and it’s much better for everyone if we give them tools to help each other more directly.