How to best attain knowledge or skill.
-1
votes
1answer
63 views
What must I already know to get profound knowledge in Oracle [closed]
I've been working with relational database systems for about 4 years, 2 years in Oracle particularly. I've been able to do pretty much everything I've needed so far but I know that the knowledge I ...
5
votes
2answers
3k views
Learning to Optimize SQL Queries and Understand Execution Plans - Resources?
I find myself writing more and more SQL queries at work (mostly Oracle 11g, but some SQL Server 2005-2008) and have started creating some pretty complex views for the rest of the analyst team.
They ...
0
votes
1answer
149 views
Tips for using DML Statements [closed]
I've recently began learning T-SQL and have found that there are some rules to using single table queries. For instance:
GROUP BY
If aggregate and non-aggregate expressions are used together in a ...
4
votes
2answers
121 views
Virtual Oracle server for education?
I am currently a College Student and am taking an introduction to Oracle 10G. I cannot seem to make it to class all of the time and am curious to ask if there is any Virtual Oracle Server or something ...
4
votes
2answers
215 views
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 ...
1
vote
1answer
2k views
Good video tutorials/series for learning Oracle? [closed]
I am a better learner with visual content. Therefore I actively seek video tutorials when I start learning a subject. For oracle below links are my finds. I would like some additions to these.
...
0
votes
1answer
125 views
Crystal Reports Training for Self-Taught User? [closed]
Not sure if this is the best place to ask.
I'm the IT guy at my company. I have a user who has handled all the Crystal Reporting in the company for years. She learned how to do most of what she can ...
2
votes
3answers
181 views
How to validate and upgrade my knowledge of SQL Server with MCSA
My story is that I am working now almost 10 years as an administrator, I deal with SQL Server and other IT stuff, most of my knowledge is self taught by reading books, dealings with problems and ...
3
votes
4answers
166 views
Which SQL standard is most broadly and completely supported?
I want to concentrate on one of the SQL language specs for learning and reference purposes. Which version of the SQL standard is most broadly supported across DBMS'es so that I can focus my time and ...
3
votes
1answer
208 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 ...
41
votes
9answers
8k 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 ...
2
votes
4answers
297 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. ...
23
votes
2answers
769 views
Where can I find database tuning exercises for learning?
As a developer, often DBAs take responsibility for resolving performance issues at the database level so we don't get that much experience diagnosing, tuning, refactoring queries etc.
I'm looking ...
9
votes
3answers
1k 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.
13
votes
5answers
1k 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
380 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
265 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 ...
10
votes
8answers
2k 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
208 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 ...
