Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [learning]

How to best attain knowledge or skill.

The act, process, or experience of gaining knowledge or skill.

33 questions
104
votes
9 answers

Where are some useful SQL puzzles to teach SQL in a workplace?

I'm looking for beginner and intermediate level SQL puzzles, that I can point trainees at for practice. I'm aware of http://sqlzoo.net/ which is a great resource - is there anything else out there that you could suggest?
testerab
  • 477
  • 3
  • 8
  • 13
92
votes
15 answers

Why is Database Administration so hard?

I know a lot of Database Administrators and they are all over 28-29 years old. Is all database administration like that? I mean, is this about getting experience more than at least 7-8 years? Or is being a database administrator so hard?
Soner Gönül
  • 1,045
  • 2
  • 12
  • 21
33
votes
5 answers

How far should you go with normalization?

I have a decent amount of data in a database. I have well formed tables and good relationships between them with some redundancy in my data. But how far should I go with normalization? Are there performance drawbacks to too much normalization?
Fergus
  • 433
  • 5
  • 7
18
votes
8 answers

Must-read Books for DBA

This question is almost mandatory in any SE site for basic reference. Please post only books with permanently value for DBAs in general. The post should be a must read book, the classical ones, the foundation books, not books for specific products…
Maniero
  • 2,478
  • 6
  • 26
  • 29
12
votes
2 answers

What are some good resources for learning about document oriented databases?

I'm interested in learning about NoSQL databases and I decided to start with document oriented databases. What are some good resources to learn the concepts and good design of this type of database?
indyK1ng
  • 1,081
  • 1
  • 12
  • 11
12
votes
2 answers

Is it ever ok to not test a feature?

Is there any point at which you become so familiar with your language/database/system that there is no need to test a new feature/configuration/query/etc. by contained/simulated testing before implementing it in your system (especially concerning a…
ZX9
  • 253
  • 1
  • 9
11
votes
3 answers

SQL Profiler tutorials for newbie

The MSDN documentation tough to understand. Are there any online tutorials available to learn SQL Profiler? If possible, videos or simple blog posts would be preferred.
Webber
  • 625
  • 1
  • 6
  • 8
8
votes
2 answers

Do agile software development approaches apply to SQL?

I would like to learn if agile software development methods/principles/patterns are valid to SQL programming as well. If yes, where would be a good place to start learning about that? Are there any articles or books targeting agile development in…
Κύριε ἐλέησον
  • 165
  • 1
  • 5
8
votes
2 answers

What are the practical reasons behind learning relational algebra?

Learning how to formulate query-like expressions in relational algebra is a traditional part of many, perhaps most, "Introduction to Databases" courses. This is usually justified by the assertion that relational algebra is the mathematical…
Gordon Royle
  • 183
  • 1
  • 5
7
votes
5 answers

What learning resources are there for part-time DBAs?

Luckily, this isn't a current issue for me, as in my current workplace we're pretty well supplied with DBA knowledge in the team. However, in small development teams, it's not uncommon in my experience for one of the team to be nominated as the…
testerab
  • 477
  • 3
  • 8
  • 13
5
votes
2 answers

Teradata learning resources

I'm moving from SQL Server to Teradata, therefore could someone recommend any good (preferably online) resources about Teradata? I'm not looking for information about basics, but rather about new features and concepts that are in Teradata.
Tomek Tarczynski
  • 153
  • 3
5
votes
0 answers

books for aspiring DBA

Possible Duplicate: Must-read Books for DBA What books do you recommend for the aspiring DBA? Update: I'm particularly looking for sql-server and PostgreSQL books (though books geared towards other DB's might be helpful to keep in one place).
Ramy
  • 191
  • 5
5
votes
1 answer

Compound Primary Key - Index both fields?

I have a many-to-many join table between users and roles. CREATE TABLE AppUserRole ( UserId INT NOT NULL, RoleId INT NOT NULL, CONSTRAINT PK_AppUserRole PRIMARY KEY (UserId, RoleId), CONSTRAINT FK_AppUserRole_User FOREIGN KEY…
Richard
  • 153
  • 5
4
votes
2 answers

How long to learn PostgreSQL?

I want to learn PostgreSQL and How to make the learning process efficient, but really don't know how long it would take even after googling my question. I used MySQL before and knew relational database. However, I would like to use PostgreSQL the…
ChesterL
  • 141
  • 1
  • 4
4
votes
2 answers

Getting to know SQL via the "short questions/simple answers style of learning"

Looking for a incremental SQL course that would likely be similar to the this Ruby Koan course; which is in fact inspired by the book, "The Little Lisper", which uses a short questions/simple answers style of learning. Basically the format is short…
blunders
  • 334
  • 3
  • 13
1
2 3