New Blog for Database Tech Support

As I was taking a database class last semester, I came across loads of problems that I had a hard time figuring out.  I created this blog in order to address various details of beginning database design and development.  Some of the issues covered will include table structure, foreign key - primary key relationships, constraints, joins, merges, and a myriad of other topics that are often frustrating while attempting to learn the intricacies of databases.  I will spend most of my time focusing on Oracle 10g/11g XE and MySQL 5.x, but I'm also taking an advanced database class where we will be getting into SQL Server.

It is important to note that this will not be a comprehensive guide (we will not cover installation of software or creation of users/schemas); instead, I will assume that you have a basic understanding of how databases operate.  This blog will simply be a complementary aid to common road blocks often encountered.

If you come across anything that is unclear or incorrect, please do not hesitate to contact me; I do not by any means consider myself a professional, and I believe we can all learn from one another.  Also, if you've come across any problems during your own database adventures that aren't covered here, please feel free to send me a message either requesting help or (if you've already figured it out) with a detailed solution so we can all benefit from your experience.  I will be sure to credit you for your work if you do send me additional information.

I hope you find this guide helpful!

Jonathan Lundberg

Posted in: