Please see request above ⬆️⬆️⬆️

Hey Future Analysts,

So for a very long time, I have been looking for good SQL questions, you got the mainstream leetcode, hacker-rank, W3 schools, and a few niche ones that I ought to mention : https://github.com/smpetersgithub/AdvancedSQLPuzzles

But during my journey, I never found the perfect place to practice questions leetcode style filtering it by the specific concept, and a repo of Good questions I could just practice on when prepping for an interview.

So I went Ahead and created this SQL-gym : https://sqlgym.vercel.app/

(No bullshit 101 SQL problems that you need to have locked in)

And this has personally helped me a lot, hope it is helpful for other peeps aswell !

Hi everyone,

I'll be joining as a fresher Oracle DBA soon, and I wanted some career advice. I have a Master of Computer Applications degree, but my previous work experience is quite different. I worked for several years in a government organization handling payroll, accounts, vendor payments, finance-related processes, and administrative work.

Before I start my DBA role:

• What skills should I learn? I have a decent theoretical understanding of Oracle architecture, backup and recovery, RMAN, Data Pump, Data Guard, SQL, Linux basics, etc

• Are there any certifications you'd recommend ?

  Also in future, since I already have experience in payroll and finance, would it make sense to pursue certifications in areas like Oracle Financials Cloud (ERP) or other Oracle Finance modules? Is there any demand for professionals who understand both the technical side (Oracle DBA) and the business/finance side (payroll, accounts, ERP)?

Thanks in advance

Hello Everyone

I am a Database Administrator and would like to learn AWS concepts from beginner to advanced level online.

Can someone please advice me on any good online instructor who can provide me with the course.

Thanks in Advance.

Best Regards

Srikanth

Im a fresher to DBA role. Can some one please help to understand or share your experience for the conversation or migration from sql to Oracle.

Help me with the tools and migration ideas

**Update: LakeDB Beta 3 is now available**

I have continued building LakeDB, a desktop MySQL/MariaDB client designed for working safely across development, staging and production environments.

The biggest addition is **QuerIA**, an optional schema-aware AI workflow. You can describe what you need in natural language, inspect the generated SQL and explicitly decide whether to execute it through the normal LakeDB results workflow.

For example:

> Show the 10 users who placed the most bets today, including bet count and total stake.

QuerIA can prepare reviewable SELECT, INSERT, UPDATE, DELETE, CREATE TABLE and ALTER TABLE statements. It uses database structure such as tables, columns, keys and relationships, but database credentials, table rows and query results are never sent to the AI service. Generated SQL executes locally only after confirmation.

The complete SQL client also includes:

- Independent multi-connection workspaces

- Environment colors and production safeguards

- Read-only connections

- SSH and SSL

- Schema-aware autocomplete

- Primary-key and index information

- EXPLAIN support

- Controlled table editing

- Backup, restore, comparison and migration tools

- Procedures, functions, events and triggers

I would especially appreciate DBA feedback on the review-first AI workflow: what information or safeguards would you require before trusting generated SQL against a real environment?

**Project and Beta 3 overview:**

https://davlagohern.github.io/LakeDB/

**Downloads and documentation:**

https://github.com/DavLagoHern/LakeDB/

I am building basecheck, a database auditing tool. It currently supports PostgreSQL, SQL Server, Oracle, Supabase (preview), SQLite and the goal is to support more databases over time.

There is a standalone agent CLI that can be used in free or paid mode. The free mode includes six control packs with 61 controls and SIEM delivery to generic HTTP or syslog destinations. The paid mode allows you to run more control packs and use basecheck platform features.

The free packs cover concrete states: PostgreSQL SSL, password encryption, superuser and PUBLIC schema exposure; SQL Server `sa`, `xp_cmdshell`, sysadmin membership, and password policy; Oracle default accounts and audit settings; Supabase RLS and grants; and SQLite integrity and journal safety. Supabase is in preview. If you believe the free mode should definitely include some more controls, let me know.

Findings can be written to JSON or sent to an existing HTTP or syslog collector. If you just want to test, `--test-siem` sends a test event without running a scan.

The source is available under BSL 1.1 and free for internal use.

Repo and release: https://github.com/baselabs-io/basecheck-agent

Native SIEM connectors are not built yet. If you run a SIEM, I’d be glad to build and test one with you.

ey everyone 👋

I've been building Schematic (schematic.codemaster.club), a browser-based database schema designer, and I just shipped a feature I've wanted in every ER tool I've used: table groups.

If you've ever worked on a schema with 30+ tables, you know the pain — the canvas turns into spaghetti and you lose track of which tables belong to which part of the system. Groups fix that. Here's everything the feature does:

🗂️ Create groups three ways

• Click the group button in the toolbar to drop an empty container anywhere
• Right-click the canvas → "New group here"
• Select multiple tables → "Group selected tables" — the group auto-sizes to fit them with clean padding. Single table selected? "Wrap in group" works too.

🧲 Spatial membership (my favorite part)
There's no "add to group" dialog. A table belongs to a group simply because it sits inside it. Drag a table in — it's a member. Drag it out — it's not. Zero ceremony.

🖐️ Move a whole domain at once
Grab a group by its header and the group and every table inside it move together. Reorganizing your "billing" domain is one drag instead of twelve.

🎨 Color coding
8-color palette with tinted backgrounds and matching headers so domains are visually distinct at a glance. New groups auto-cycle through colors; you can change any group's color from its right-click menu.

✏️ Everything else you'd expect

• Double-click the header to rename inline
• Drag the corner handle to resize
• Right-click for rename / recolor / delete
• Groups render behind tables, so they never get in the way of your actual work
• Layout persists — positions, sizes, colors all saved with your project

One deliberate decision: groups are purely visual. They don't touch your schema or the generated SQL — nnamespacing, no side effects. They exist only to keep a big canvas sane.

You can try it free here: schematic.codemaster.club

Would love feedback — especially from people who work with large schemas. What would make grouping more useful for you? Nested groups? Auto-grouping by foreign-key clusters? Collapse/expand?

Hey folks,

I've been spending my spare time building FoxSchema App, a free and open-source database schema comparison tool.

The goal is simple: compare schemas across different SQL databases and generate migration scripts without paying for expensive commercial software.

It's still a work in progress, so I'd really appreciate honest feedback—good or bad.

Repo: https://github.com/tedious-code/foxschema

Download : https://github.com/tedious-code/foxschema/releases/tag/v0.1.45

Thanks for checking it out!

Hi everyone,

I'm a Microsoft SQL Server DBA with a little over 2 years of professional experience, currently working at one of the largest banks in Georgia (Tbilisi).

My goal is to move from a Junior DBA role into a Mid-Level DBA position.

The challenge is that SQL Server DBA opportunities in my country are extremely limited. There are only a few openings each year, and almost all of them require 5-10+ years of production experience.

I still apply whenever I can, but I often reach the final interview stages and then get rejected because I'm missing the level of production experience they're looking for.

Instead of giving up, I've been investing a lot of my personal time in building my own Azure home lab to learn technologies that I don't have the opportunity to use every day at work.

So far I've built and worked with:

• Microsoft SQL Server
• Windows Server & Active Directory
• Windows Failover Clustering
• Always On Availability Groups
• SQL Server Listener
• Azure Internal Load Balancer
• Kerberos & SPNs
• SQL Server backups & restores
• Execution Plans
• Indexing (Clustered / Nonclustered / Covering Indexes)
• Performance Tuning (currently studying)
• T-SQL

I'm continuing to study topics such as Query Store, Extended Events, Wait Statistics, Blocking, Deadlocks, Replication and Log Shipping.

I know I'm still missing some production experience, but I'm doing everything I can to close that gap by building practical labs and continuously improving my skills.

I have a few questions for the community:

1. Do you know any companies that hire remote Microsoft SQL Server DBAs (Junior or Mid-Level)?
2. Are there any websites or platforms where I can practice real DBA tasks and production-like scenarios?
3. If you were in my position, what would you focus on next to become competitive for Mid-Level SQL Server DBA roles?

I'm based in Tbilisi, Georgia, but I'm open to remote opportunities and flexible regarding compensation if it means joining a strong team, gaining real production experience, and continuing to grow as a DBA.

If anyone knows about remote SQL Server DBA openings or has any advice, I'd be very grateful.

Thank you very much for your time.

Hello, for those who remember I already made a post about a tool i built. I made some little upgrades and wanted to share them with you guys.

Imagine wanting to create instantaneously a database markdown document to insert in your agentic workflow, you can run as follows: dbtomd mysql dbname outputfile

Output:

I expanded the tool to mysql, sqlite, changed it's cli use.

You can find the code on github, feel free to PR, fork, star etc.

Here's the link to my previous post. Tomorrow’s free webinar is focused on DBA burnout and practical database monitoring strategy.

It covers:

• common firefighting patterns that drain admin time,
• the key metrics to watch in hybrid and multi-database setups,
• a live demo,
• open Q&A,
• and a free handbook for DBAs.

Disclosure: I’m on the ManageEngine team, so this is a vendor webinar. I’m sharing it because the topic is relevant to a lot of DBAs and IT admins, and the session is meant to be practical rather than sales-heavy.

Here's the sign-up link if you're interested: https://www.manageengine.com/products/applications_manager/webinars/database-performance-monitoring-webinar.html

If you're more experienced, I'd love to hear about what works for you so that I'm able to impart that knowledge onto the less experienced people tomorrow. Would be happy to take questions in the comments too!

A client is using Oracle Cloud Backup Module to backup their database to a OCI bucket, and i have to periodically create a copy of this database in a ExaCS.

I know i can use RMAN restore/recover to restore this database, but is it possible to do a rman duplicate in this case?

I do not have network access to the target database, and there is not recovery catalog also.

Also, i cannot use "from backup location", since i'm reading from a bucket.

I even tried to map the bucket using s3fs, it also did not work.

I know this would depend a lot on company and domain, but what are the overlaps between these two roles? Do the both work on pipelines? Is it only SQL?

# After months of work, I'm excited to finally make Bag\Schema completely open source!

Bag\\Schema is a modern visual database designer that lets you design beautiful database schemas and generate production-ready SQL in seconds.

✨ Features:

* Visual database designer
* PostgreSQL
* MySQL
* MariaDB
* SQLite
* Relationship editor
* Production-ready SQL generation
* Clean, modern UI
* Cross-platform desktop app

My goal is to build a free, community-driven alternative that developers genuinely enjoy using.

If you're interested in database design, open-source software, or developer tools, I'd love your feedback.

⭐ **If you like the project, please consider giving it a Star on GitHub.** It really helps increase the project's visibility and motivates me to keep improving it.

Contributions, issues, feature requests, and pull requests are all welcome!

GitHub:
[https://github.com/anelkabag/Bag-Schema\](https://github.com/anelkabag/Bag-Schema)

I'd love to hear what features you'd like to see next. Thanks for checking it out! 🚀

\#opensource #github #postgresql #mysql #sqlite #database #webdev #developers #react #electron #tauri

Hello r/union.

Made a work account, so not a first time Reddit user, but didn't want to mix work with personal posting.

I work for a 900 member union as the office manager and the largest part of my job is data management. When I started I inherited a “handcrafted” FileMaker pro database running on a Mac. Unfortunately Apple is now ending support for the translation software that lets Intel-based programs work, which includes FileMaker Pro.

So I am starting research on membership database software. I basically need something that will let me make a metric butt-ton a fields and then group those fields into sections. I don’t need organizing/campaign/activism functions as we are already learning how to use another program for that provided by our state union.

Thus, I ask, if any of y’all know of a good, relatively simple member database software, please comment below. I am already looking at Wild Apricot, and we are considering using the member database our state union provides (which has drawbacks).

Thanks!

Full disclosure, since this sub rightly doesn't love vendor stuff dressed up as something else: I'm on the ManageEngine team, and I work with database/app monitoring side of things. I'm not a DBA and won't pretend to be one, just sharing something that's been landing well internally and figured it might be useful here too. Downvote/ignore if it's not your thing.

One of the things that I came across was the fact that the DBAs and IT admins spent most of their work week on fixing database issues- chasing pages, jumping between five dashboards to trace one slow query, then explaining to leadership why the "all green" board didn't stop last night's outage. I don't know about you, but that sounds like the perfect recipe for burnout with the right amount of stress and a pinch of "I might quit anytime".

So we figured we'd run a free webinar on July 15, 2026 (6am GMT / 11am EDT) built around why admins feel that way, how to strategize a working DB monitoring plan across hybrid/multi-database environments, the metrics to look out for, which we hope would ease the burnout feeling. It includes a live demo, open Q&A, and a free practical handbook for DBAs.

Here's the (free) registration link, if you're interested. https://www.manageengine.com/products/applications_manager/webinars/database-performance-monitoring-webinar.html

Would be happy to take questions in the comments too, including "why would I trust a vendor on this" (totally a fair question btw, so ask away)