How to best attain knowledge or skill.

learn more… | top users | synonyms

1
vote
0answers
19 views

Certification Test 70-461 [on hold]

I am a student at University of Houston-Downtown and looking to take the Database Administrator certification test sometime in October. I am hoping that someone has been recently been certified or ...
3
votes
3answers
221 views

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 ...
2
votes
1answer
61 views

How do you generate large OLTP and reporting workloads? [closed]

My current skillset lies towards plain vanilla data warehousing, with < 20k users, our setups are rather simple.. I am looking for ways to enhance my technical skills, however, as much theory as I ...
0
votes
2answers
512 views

Is there a free/web-based game that requires knowledge of SQL to win? [closed]

Looking for an alternative way of teaching SQL, and wondering if there is a free/web-based game that requires knowledge of SQL to win. If possible, the game should not only be fun, but also track how ...
0
votes
1answer
225 views

Where can I get best resources to learn sql? [duplicate]

I am very new to the databases just have basic knowledge about it. I want to learn sql language and dont know where to start. Please help me to start with it. And what is the difference between ...
4
votes
2answers
335 views

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 ...
83
votes
15answers
30k views

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 ...
4
votes
4answers
387 views

Where can I find good literature for beginners?

I am trying to find some database tutorials,books and similar, since I have started this course in college, and received some material, but it is really hard to manage through all the info on the net. ...
10
votes
3answers
2k views

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.
16
votes
5answers
2k views

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 ...
9
votes
2answers
566 views

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?
7
votes
5answers
336 views

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 ...
16
votes
8answers
8k views

Must-read Books for DBA [closed]

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 ...
5
votes
0answers
231 views

books for aspiring DBA [duplicate]

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 ...
76
votes
7answers
13k views

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 ...