SQL and Databases Master Class
Stop writing slow queries and designing broken database schemas. Get the complete system that takes you from SQL beginner to database expert—mastering PostgreSQL, query optimization, database design, transactions, and advanced SQL. Everything you need to build production-ready databases that scale and perform.
- courses
- 5
- of video
- 21.3 h
- lectures
- 385
$199.98$420.25one payment
Lifetime access. 15-day money-back guarantee.
Want a mentor as well? The Academy gives you every course on Amigoscode plus code reviews, daily live calls and interview prep, for $129/month. Compare →
What's inside
5 courses, in the order we'd teach them
21.3 h of video across 385 lectures. Open any course to see its curriculum.
Every course
5 courses · 21.3 h
Linux Fundamentals6 h · 112 lectures
Learn the fundamentals of Linux and how to use the command line
- 1Intro1 lecture · 1 min
- 2Getting started3 lectures · 3 min
- 3Mac installation7 lectures · 25 min
- 4Windows installation5 lectures · 24 min
- 5Virtual machines5 lectures · 19 min
- 6GitHub codespaces6 lectures · 22 min
- 7The terminal16 lectures · 43 min
- 8The shell8 lectures · 31 min
- 9Linux commands10 lectures · 50 min
- 10Linux file system7 lectures · 22 min
- 11Working with files9 lectures · 30 min
- 12Working with directories5 lectures · 14 min
- 13Users and groups12 lectures · 29 min
- 14File permissions13 lectures · 45 min
- 15Outro5 lectures · 2 min
Up and Running with SQL and DatabasesFree1.9 h · 38 lectures
Learn SQL and databases from the ground up.
- 1Intro2 lectures · 1 min
- 2Getting started with databases7 lectures · 16 min
- 3Postgresql installation4 lectures · 12 min
- 4Psql9 lectures · 29 min
- 5Exploring postgresql server3 lectures · 15 min
- 6Databases4 lectures · 15 min
- 7Working with tables6 lectures · 25 min
- 8Next steps3 lectures · 1 min
SQL and Databases Fundamentals3.4 h · 67 lectures
Master SQL and database fundamentals to enhance your data querying and management skills.
- 1Intro2 lectures · 1 min
- 2Important stuff7 lectures · 27 min
- 3Insert and query data7 lectures · 26 min
- 4Filtering data12 lectures · 45 min
- 5Grouping and aggregate functions9 lectures · 24 min
- 6Mathematical operators and functions3 lectures · 10 min
- 7Modifying data5 lectures · 18 min
- 8Relationships4 lectures · 17 min
- 9Joins12 lectures · 33 min
- 10Order of SQL4 lectures · 3 min
- 11Next steps2 lectures · 1 min
Advanced Databases8.3 h · 136 lectures
Advanced database management with SQL, integrity, and practical applications
- 1Intro3 lectures · 1 min
- 2Schemas6 lectures · 19 min
- 3Advanced data types11 lectures · 51 min
- 4Working with dates5 lectures · 15 min
- 5Constraints9 lectures · 42 min
- 6Foreign keys3 lectures · 19 min
- 7Manage tables2 lectures · 1 min
- 8Indexes12 lectures · 1 h 0 min
- 9Analyse queries7 lectures · 15 min
- 10Conditional expressions5 lectures · 13 min
- 11Dealing with conflicts5 lectures · 13 min
- 12Sub queries8 lectures · 18 min
- 13Common table expressions5 lectures · 15 min
- 14Window functions7 lectures · 31 min
- 15Views and materialized views5 lectures · 17 min
- 16Transactions8 lectures · 23 min
- 17Functions stored procedures and triggers7 lectures · 33 min
- 18Roles groups and privileges5 lectures · 23 min
- 19Backup and restore5 lectures · 27 min
- 20Full text search7 lectures · 17 min
- 21Row level security8 lectures · 47 min
- 22Next steps3 lectures · 1 min
Database Design & Implementation1.7 h · 32 lectures
Skills in database design and SQL for efficient, robust backend development
- 1Intro3 lectures · 4 min
- 2Database design17 lectures · 1 h 17 min
- 3Database normalization5 lectures · 12 min
- 4Exercise 12 lectures · 8 min
- 5Exercise 23 lectures · 2 min
- 6Next steps2 lectures · 1 min
Choose how you learn
Learn on your own, or with people who check your work
The bundle is these courses, yours to keep. The Academy is the same courses and every other one, plus the people who get you hired.
SQL and Databases Master Class
The courses, on your own
$199.98$420.25one payment
- 5 courses, 21.3 h of video, 385 lectures
- 6 months of any JetBrains product ($141.34 value)
- Lifetime access to every course in the bundle
15-day money-back guarantee
The Academy
The courses, plus the people
$129/monthcancel anytime
Everything in the bundle, plus
- Every course on Amigoscode 50+ in the Zero to Hired Roadmap
- Daily live calls and 1:1 instructor time
- Code reviews and pair programming on what you build
- Interview prep mock interviews, System Design Lab, CV and LinkedIn review
- Land an interview in 90 days or we coach you 1:1 free until you do.
7-day money-back guarantee · Secure checkout on Skool
The bundle costs the same as under 2 months of the Academy, and the Academy includes every course in it.
“Nelson was teaching 90% of my job. I was already implementing everything I learnt from it.”
“I was a totally different person. More confident as a developer, more prepared for my job.”
GabrielaSoftware Engineer at Mercado Livre“I studied biomedicine and psychology. I found Nelson's Java tutorials while looking for a course for my brother. I was hooked and now here I am, a software engineer at IKEA.”
NajmaSoftware Engineer at IKEAAbout this bundle
What order should I take the courses in?
Top to bottom. The list is in the order we'd teach it. If you already know a topic, skip that course and carry on.
How long will it take?
There are about 21 hours of video. At 5 hours a week that's about 4 weeks of watching, plus the time you spend building along.
Are new courses included?
Yes. Any course we add to this bundle later is yours too, at no extra cost.
Do I keep access?
Yes. You pay once and keep every course in the bundle for life, including updates.
What if it isn't for me?
Email us within 15 days of buying and we'll refund you in full.
Should I get the bundle or join the Academy?
Get the bundle if you want these courses and you learn well on your own. Join the Academy if you want to get hired or move up: you get every course on Amigoscode, plus daily live calls, code reviews and interview prep, for $129/month. Under 2 months of the Academy costs the same as the bundle ($199.98).