SQL — Querying and Managing Data
Who it is for: analysts, developers and business users who want answers from their own data instead of waiting for a report.
Covers the classic SQL tutorial path — SELECT, WHERE, ORDER BY, INSERT, UPDATE, DELETE, functions, joins, GROUP BY, HAVING, subqueries — plus modern features (CTEs, window functions) using PostgreSQL syntax that also works in MySQL/MariaDB and SQL Server with minor changes.
Community and help: every enrolled student gets the course Forum tab — ask the BOSS Pacific team or other students, share fixes and lab results. Read the BP Academy blog for updates and worked examples.
Includes: the full course as a licensed PDF workbook, available after purchase.
Hands-on labs: rent a ready environment from BOSS Pacific — PostgreSQL sandbox. Every lab resets every 24 hours and is removed at the end of your rental. Or build your own with the gear listed in the course.
| Responsible | Administrator |
|---|---|
| Last Update | 11/08/2026 |
| Completion Time | 3 hours 30 minutes |
| Members | 0 |
-
-
INSERT, UPDATE, DELETE and transactionsNew
-
Free Preview New
-
Design, indexes and performanceNew
-
-
Gear and labs for this course4Lessons · 1 hr 48 min
-
Free Preview New
-
JoinsNew
-
Free Preview New
-
Grouping, aggregates, CTEs and window functionsNew
-
-
Final quiz1Lessons · 15 min
-
Final quiz — SQLNew 10 xp
-
-
Course workbook (PDF)1Lessons · 6 min
-
Download the full course workbookNew
-
-
Certification1Lessons · 18 min
-
Certification exam — earn your BP Academy certificateNew
-