Welcome Guest ( Log In | Register )



 
Reply to this topicStart new topic
> Need Info On Database Programming Courses, Oracle Database Programming
sher
post Mar 27 2007, 08:44 AM
Post #1


Newbie [ Level 1 ]
Group Icon

Group: Members
Posts: 2
Joined: 27-March 07
Member No.: 21,112



I know Database Programming on MS-ACCESS, now i am planning to go for some other Database Programming courses, People told me to go for Oracle or VisualAge.

Can anyone told me to start with which one and how long is the course period and which one is easy and is it similar to ms access or somthig different.
Go to the top of the page
 
+Quote Post
faulty.lee
post Mar 27 2007, 11:17 AM
Post #2


Premium Member
Group Icon

Group: [HOSTED]
Posts: 479
Joined: 5-November 06
Member No.: 17,016



QUOTE(sher @ Mar 27 2007, 04:44 PM) *
I know Database Programming on MS-ACCESS, now i am planning to go for some other Database Programming courses, People told me to go for Oracle or VisualAge.

Can anyone told me to start with which one and how long is the course period and which one is easy and is it similar to ms access or somthig different.

Actually which database programming is not important. Since most of them are SQL92 or higher compliant, basic operation like SELECT, UPDATE, INSERT, DELETE is the same. Even the extra condition are mostly the same like WHERE, INNER JOIN, ORDER BY, GROUP BY and so on.

What's more important is your target application and platform. If you're fresh grads, then maybe you should look at what kind of job you're going into, or the demand of your current job. If you're doing this for hobby, and more likely to use it for web application, then I'll recommend MySQL or ProstgreSQL. Since they're the most widely use SQL databases. For personal use, you can save your total cost of ownership.

Other than that, you might want to look at
http://en.wikipedia.org/wiki/Comparison_of...agement_systems

for a list of comparison. You can see which one suite your need better.
Go to the top of the page
 
+Quote Post
ethergeek
post Mar 27 2007, 10:47 PM
Post #3


Premium Member
Group Icon

Group: [HOSTED]
Posts: 393
Joined: 9-March 07
From: Tucson, AZ
Member No.: 20,794



Be careful here...SQL is not all there is to Database programming...there's the native procedure support, like T-SQL in SQL Server and PL/SQL in Oracle.

As for MySQL and PostgreSQL being the most widely used...I'd disagree there. With around 45% of the market share, Oracle is still in the lead on that one.

From a TCO perspective, if you're just learning, Oracle has the "personal edition" and SQL Server has the "SQL Server Express" products, both available free, though you cannot redistribute Oracle's personal edition.

From an employability perspective, being an expert Oracle DBA will pay HUGE dividends in the future, especially if you get yourself certified. Expert DBA's for Oracle are in huge demand right now, because so many large enterprise shops (read: lots of disposable cash) are on Oracle and need people to keep their database running efficiently.

Now, all those facts aside...I personally prefer MySQL for most small projects, but it doesn't scale when you have terabytes of data to work with. I'd go with either Oracle or SQL Server on that one, but I lean towards Oracle since SQL Server requires Windows.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Best Database(3)
  2. Database(6)
  3. Some Useful Database Links.(7)
  4. MySQL Output Database Question(18)
  5. Runuo Programming(4)
  6. VBA And Oracle(8)
  7. Creating A Game In Rpg Maker 2000/2003(18)
  8. Programming In Glut (lesson 1)(3)
  9. Accessing Ms Access Database From A Centralized Location?(5)
  10. Introduction To Programming(1)
  11. Programming In Glut (lesson 4)(7)
  12. Space Needed For Database(10)
  13. Database Access On Remote Server W/jsp(0)
  14. Mysql Database Entry By Excel Sheets(2)
  15. Need Help With A PHP - MySQL Registration Script(13)
  1. [tutorial] Basics Of C Programming - Part 1(11)
  2. Mysql Database Management(1)
  3. How To Save A Image In Pdf File And Download It?(10)
  4. Oracle 10g Install Issues(27)
  5. Mirror My MySQL Database To Another Mysql Server(4)
  6. How To: Connect, Read, Write, Close A Database(3)
  7. Help A Beginner Start On With Game Programming(8)
  8. Starting Programming(15)
  9. C# Tutorial : Lesson 3 - Programming Constructs(1)
  10. Does Anyone Code Using Turing(2)
  11. A Few Thoughts On Freelance Programming(9)
  12. Integrate Access Database Onto Intranet Site(5)
  13. Database(1)
  14. Connecting To A Remote Database(9)
  15. Permission Problem With Mysql Database Creation(8)


 



- Lo-Fi Version Time is now: 8th September 2008 - 02:30 AM