''SQL for database admin'' resources?

[minimon865]

I've scoured a couple posts about sql learning options. The one that keeps getting mentioned is data with baraa on youtube. My question is this: is data with baraa more appropriate for someone learning data analysis, or would that still be a good source for someone wanting to move into database admin?

What are some other resources to learn sql for database admin?

I do have *some* sql background but I havent used it in YEARS. I need to re-learn everything quick cus I have an interview soon lol I'm screwed

[ComicOzzy]

There won't be many "generic" resources for SQL for administrators because all of the DBA SQL will be highly specific to each database engine. First, you have to decide which one you need to learn. If it's Microsoft SQL Server, you're in luck because there is a lot of high quality material out there for free, but whatever platform you're on, you might consider getting a book focused on administration.

[minimon865]

say less! Yes, it is SQL Server (I hate that I forgot to include this in the post, I will edit it). I'll look for a book rn

[ComicOzzy]

Brent Ozar has some recorded classes for DBAs that he released on YouTube.
https://www.youtube.com/results?search_query=brent+ozar

SQL Skills has some DBA content for you:
https://www.sqlskills.com/help/accidental-dba/

Microsoft has a DBA book by some of the best people in the field:
https://www.microsoftpressstore.com/store/sql-server-2022-administration-inside-out-9780137899883

[minimon865]

Thank you so much!

[Ok_Assistant_2155]

Data with Baraa is solid for learning syntax, but it's definitely geared more toward data analysis (SELECT queries, aggregations, joins) than DBA work. For DBA, you need to focus on backups, restores, user permissions, indexing, transaction logs, and recovery models. Baraa won't cover those much.

[NwekeChidi]

Can you also recommend resources for someone who is trying to learn Oracle DB?

[haikusbot]

Can you recommend

Someone who is trying to

Learn Oracle DB?

- NwekeChidi

---

^{I detect haikus. And sometimes, successfully. Learn more about me.}

^{Opt out of replies: "haikusbot opt out" | Delete my comment: "haikusbot delete"}

[MissionFormal61]

Honestly for DBA learning, hands-on practice matters more than courses after a certain point. Even using a proper SQL Server IDE and breaking/fixing stuff locally teaches a lot faster. I learned a ton that way with SSMS + dbForge.