|
| I
would
recommend
th
|
|
 |
|
 |
I would recommend that you start with _A Visual Introduction to SQL_ by Chappel et. al. This is the best intriductoon to SQL I have ever encountered. The only problem is that in my opinion the first edition is better-written and more understandable, but it does not cover subqueries and outer joins. The 2nd edition does cover those topics but the added material is not as good as the work of the original authors.Creating and managing the example tables for that text in Oracle should also give you experience with DDL and DBA tasks.I would then proceed to Celko's _SQL for Smarties_, which contains a lot of interesting SQL puzzles. Solving these puzzles helps develop more complex SQL skills. Celko doesn't always agree with Kyte on SQL best practices, but the contrast between the two is a good thing.Unfortunately, the best approach is to have some real problems to solve along the way - that is how most of the people who contribute to these forums learned. In my case I was suddenly faced with being responsible for an Oracle database as the manager, DBA, and developer. I worked interactively through the books under discussion here with the added pressure of needing to find solutions so that my family could continue eating ;-) The combination of research and application is difficult for a student to duplicate.sPh
|
 |
|
 |
|
|
|
|
|
|
(VISITOR) AUTHOR'S NAME
Ece
MESSAGE TIMESTAMP
17 december 2014, 05:45:02
AUTHOR'S IP LOGGED
62.210.78.179
|
|
|
|
