Database Tutorials
Our database tutorials provide well-structured learning paths for both SQL and NoSQL databases. Covering essential concepts, query languages, database design, and optimization techniques, our tutorials are suitable for both beginners and intermediate developers. With free labs and practical examples, you'll gain hands-on experience in database operations across different database systems.
Other Skill Trees
LinuxDevOpsCybersecurityAWSCybersecurity EngineerDevSecOpsNetworkingCompTIAKali LinuxWiresharkNmapHydraRed Hat Enterprise LinuxRHCSA TrainingRHCE in Enterprise Linux TrainingLFCS TrainingShellDevOps EngineerGitDockerKubernetesCKA TrainingCKAD TrainingCKS TrainingAnsibleRHCE in Ansible TrainingJenkinsCloudflareMySQLPostgreSQLRedisMongoDBSQLiteData ScienceBig DataPythonGolangRustJavaCC++Web Development
Find Every Available Product Variant
Return every in-stock MongoDB variant that matches a customer request and derive its displayed minimum from the matching set.
MongoDB
Repair the Product Search Query
Trace an unsafe shop search and repair its SQLite query with a bound value while preserving legitimate names and listing rules.
SQLiteCybersecurity
Protect Workshop Registration Rules
Keep a working MySQL registration desk consistent without confusing same-name people or losing existing bookings.
MySQL
End Database Access When the Report Is Finished
Finish a real database report, revoke its exact lease, observe natural expiry on a separate short lease, and recover with a new temporary login.
PostgreSQLShellCybersecurity
Find and Fix Unsafe Database Queries
Trace a short Python lookup, read a real local Semgrep finding, and bind SQLite parameters while preserving legitimate quoted names.
SQLiteCybersecurityPython
Close Each Venue’s Local Sales Day
Build time-zone-independent PostgreSQL closing queries and real ticket reports using each venue’s local calendar-day boundaries.
PostgreSQL
Switch the Application to Restricted Access
The support dashboard has a prepared restricted account, but still connects through Redis's broad default account. You will switch its configuration and retire that old connection path while preserving the monitor.
Redis
Keep Each Order Total Correct
Avoid duplicated sales totals by aggregating items, payments and refunds separately before joining orders.
SQLite
Protect Exhibitor Reads and Writes
Protect a shared PostgreSQL register with real account ownership, safe writes and continued organizer access.
PostgreSQL
Apply Versioned Catalog Updates
Reject contradictory supplier editions and apply newer SQLite stock values without losing local shelf notes or accepting stale updates.
SQLite
Finish Queued Tickets Safely
Recover real RabbitMQ ticket work after interruptions without losing registrations or duplicating business results.
SQLitePython
Inspect a Supplier Delivery
Stage a supplier CSV in SQLite, validate its real values, and preserve stock while producing a reusable delivery review.
SQLite
Give the Settlement Report Only the Data It Needs
Give a real settlement report a dynamically issued PostgreSQL login that can read its reporting view while private tables and writes remain unavailable.
PostgreSQLShellCybersecurity
Deliver a Sales Reconciliation
Turn accurate per-order SQLite balances into real CSV handover files without hiding unpaid orders or offsetting differences.
SQLite
Keep Every Order Across Pages
Add complete timestamp-and-ID cursors to MySQL order queries for correct ascending and descending pagination.
MySQL
Understand the Dashboard's Cache Access
A support dashboard uses Redis to cache a ticket and its processed result. You will keep that workflow working while creating an account limited to its own data.
Redis
Open a Restored Shop Beside the Original
Restore complete orders into an independent writable shop and preserve the original shop.
PostgreSQL
Save the Orders at a Known Recovery Point
Save a real PostgreSQL custom-format backup and distinguish its recovery point from later shop orders.
PostgreSQLLinux
- Prev
- 1
- 2
- 3
- 4
- 5
- 6
- ...
- 136
- Next