Skills › Backend Engineering

Database Integration

Connect, query, and optimise relational and NoSQL databases in application code.

0%
Confidence · no data yet
Sign in to track

After this skill you can…

  • Use an ORM (Prisma, SQLAlchemy, Drizzle)
  • Write optimised queries with indexes
  • Handle migrations and schema evolution safely

Prerequisites

Watch (10 videos)

How to Install Oracle Database 11g on Windows 10 By Manish Sharma
Manish Sharma · beginner hands-on
→ Install Oracle Database on Windows→ Configure database settings
How do I resolve Amazon RDS instance full storage issues when storage auto-scaling is turned on?
Amazon Web Services · beginner hands-on
→ Resolve storage issues in Amazon RDS→ Configure auto-scaling for databases
Basic PHP Programming Tutorial 28: MySQL Database Part 2: Reading From Database
sentdex · beginner hands-on
→ Read data from a MySQL database using PHP→ Integrate a database into a PHP application
Ultimate Way To Save Archive Redo Logs into Fast Recovery Area
Manish Sharma · beginner hands-on
→ Configure Oracle database for archive logs→ Store logs in the Fast Recovery Area
Flutter & Firebase App Tutorial #18 - Firestore Streams
Net Ninja · beginner hands-on
→ Integrate a NoSQL database with a mobile app→ Handle realtime data updates using Firestore streams
How do I troubleshoot a slowly running SELECT query in my Amazon Aurora MySQL DB cluster?
Amazon Web Services · beginner hands-on
→ Troubleshoot slow queries in MySQL→ Optimize database performance for better query execution
THE BEST WAY to Setup ORACLE DATABASE on VS CODE in 2024
Manish Sharma · beginner hands-on
→ Connect Oracle to VS Code→ Use Oracle SQL Developer Extension
CloudSQL: Configure database flags
Google Cloud Tech · intermediate hands-on
→ Configure CloudSQL database flags→ Customize instance behavior
Infinite Scroll Pagination Tutorial with Firestore (part 2)
Net Ninja · beginner hands-on
→ Implement infinite scroll pagination with Firestore→ Use Firebase for frontend development
Set Up an MongoDB Replica Set in Less Than an Hour Using Bitnami Packages
The New Stack · intermediate hands-on
→ Set up a MongoDB replica set→ Monitor database performance with Datadog

Read (10 articles)

📄
How to add type annotations to SQLAlchemy models
Dev.to · Carlos V. · 2022-03-21
📄
Hibernate - N+1 Problem
Dev.to · Yiğit Erkal · 2022-04-15
📄
Scaling Laravel with Serverless Redis
Dev.to · Bobby · 2022-05-09
📄
Building User + Auth Service for Forum-Based Web using Redis (Part 2)
Dev.to · Bervianto Leo Pratama · 2022-07-17
📄
Creating a GraphQL Server from just Mongoose Models
Dev.to · Danish Siraj · 2022-10-03
📄
Storage Layer 📦
Dev.to · Јане Џумеркоски · 2022-10-20
📄
Superfast search with RediSearch
Dev.to · Vikas Solegaonkar · 2022-10-20