DB Development

SQL

1. sql-plsql.blogspot.com
First website where I have started with learning was sql-plsql.blogspot.com
It simply has basic stuff about SQL and PL/SQL written in a short way. I did not go through all the pages of the SQL part. I would definitely suggest people to check it out as a complete beginners guide to see what is there in SQL and PL/SQL and shortly what is what.
I am sure that there are even better websites for this purpose, but this is the one I have started with.
Please write in comment if you have some better website, for this starting out purpose.

2. CBT Nuggets SQL Fundamentals video series
You can find it HERE. It is really really good thing for a beginner and I would suggest you to check it out. It will not only go with you through the SQL, but it will also help and guide you through using tools as SQL*PLUS , SQL Developer and a little bit of Enterprise Manager. Here are also given many nice links to other websites worth checking and the Oracle documentation is explained a bit, just enough to help you start with it. The down side is that there are too little examples and too little SQL functions actually being mentioned.

3. “Oracle SQL By Example – 4th Edition” by Rischert, Alice
Next thing I took where I wanted to go a bit more into detail was “Oracle SQL By Example – 4th Edition” by Rischert, Alice. This is a great book for learning SQL, that goes into detail with many SQL functions and is giving you examples to practice. I was really really satisfied with this book!

4. Oracle documentation
in case there is still something you do not know (for sure) you will most probably find it here:

List of all SQL functions – http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions001.htm

SQL Language Reference – http://docs.oracle.com/cd/E11882_01/server.112/e26088/toc.htm

PL/SQL

1. sql-plsql.blogspot.com
Once again I have started with this website just to see the basics of PL/SQL and figure out what is what. There is actually enough written for some basic tasks, but it is missing more material and more explanation and more examples. But for beginning and for a quick reference it is not bad at all.

2. “Oracle PL/SQL language – pocket reference” by Steve Feuerstein
This is a really great book for beginning as it has only 180 pages, so you can really fast go through it and see which things need to be more explained and which are understood only by going through that short version. It is for sure a great book to have also for later, because once you do understand those parts that were not so clear at beginning, you can use this book just to remind yourself of the most important basics.

3. “http://www.amazon.com/gp/product/0596514468/ref=oh_details_o01_s00_i00” by Steve Feurstein
I have ordered this book (have not read it yet) and will use it to read through all the parts that were unclear to me after reading the “Oracle PL/SQL language – pocket reference” book

4. “Oracle PL/SQL Best Practices” by Steve Feuerstein
This is another book I have ordered from the same author (did not read it yet). It has a set of best practices-recommendations for developing successful applications.

5. “Oracle PL/SQL Recipes: A Problem-Solution Approach
This is the last book I have ordered about PL/SQL (have not read it yet). I wanted to have another book with examples of how to use PL/SQL in a real applications with examples, from another author (all previous books were from the same author) so that I can see the topic from another perspective.

Database Design

1. “Effective Oracle by Design” by Thomas Kyte
This book explains how to best make your database and write your code so that you do not have a problem with the DB later. It is somewhere in between a guide for a DB developer and DB administrator. (still did not read it)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: