Find the perfect coding resourcesLearn how skillcraft.ai helps developers find the perfect coding learning resourcesLearn more→
Lane Wagner
Instructor
Lane is a back-end engineer and the lead instructor of Boot.dev. He has taught over one million students worldwide, on Boot.dev, FreeCodeCamp, YouTube and the Backend Banter podcast. Lane worked as a backend engineer writing Go, Python and TypeScript, then moved into engineering management and a couple of years later left to build Boot.dev full-time.
Completion
Certificate included
Format
Interactive coding
Freemium
Design and create database tables with constraints
Master CRUD operations and complex queries
Use joins to combine data from multiple tables
Apply normalization for data consistency
Optimize query performance with indexes
Learn all the basics of Structured Query Language in this comprehensive SQL course. You will build out real database tables and practice querying them in flexible ways right in your browser. Not only will you understand how to use SQL, but you will also learn when you should use it and in what situations. We will cover architectural design patterns and how to use SQL in a production environment.
Learn about the basics of SQL and how it came to be
Create new tables and learn how to structure data efficiently
Learn how to keep data accurate and up to date
Create, read, update and delete information from a SQL database
Practice additional clauses and features that SQL offers for more flexible querying
Learn how to order and limit the data returned in large query sets
Learn how to run powerful calculations on entire datasets
Practice the advanced technique of nesting queries inside one another
Learn how to normalize a database in order to keep its data consistent and accurate
Practice joining multiple tables together in order to power real world usecases
Learn how to keep databases running fast and efficient in production
Share Your Experience
Sign in to leave a review and help others
No reviews yet. Be the first to review!