Please Help! Database Programming

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Hi

I am looking into Database Programming, My knowledge is not brilliant and I am looking to start pretty much from the beginning. Can someone please help me with where to start including what books to buy and the best way to start learning.

Many thanks

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Hi and welcome to CF!

Where are you starting from? Databases are not simple, so guessing where you are is difficult. There are many ways to address these - and it depends on your maths background as well as other things. How are you on boolean algebra? Or relational algebra?

Harry.

 

Hello and welcome to the forums! You may wish to post a proper introduction in the New Members section found here - http://www.certforums.co.uk/forums/forum21.html

Qs

 

A formal appreciation of Databases and Relational Algebra is nice but not strictly necessary to learn about databases.

Most people learn by playing with an example database, get hold of MS SqlExpress, ProgresSQL, MySQL or even MS Access. Play with the product by getting an introductory book and a sample database. Learn basic SQL(DDL/DML) statements.

You could look at taking a course

http://www3.open.ac.uk/courses/bin/P12.dll?S01
http://www3.open.ac.uk/courses/bin/p12.dll?C01M359
http://www3.open.ac.uk/courses/bin/p12.dll?C01M876

To actually program properly in the database tier you will need to learn something like PL/SQL or TransactSQL. You can also embed Java or .Net code in some databases.

To program more generally you will need to learn a general high level lanaguage, these can also be used to connect to databases and perfrom SQL(DDL/DML) or sometimes interact with the database directly at a lower level.

Best of luck !