Would like to learn SQL. Which vendor should I go for and what certification should I get?

15 pts.
Tags:
SQL
SQL certifications
SQL Server
SQL Server certifications
Hi All,
I would like to learn SQL but was wondering shich SQL package should I go for? I am looking for emplyment in the finance industry as an analyst and thus looking for the right SQL package to learn and get the right certification. Could somone please advise me accordingly.
cheers!
Jeevan


Software/Hardware used:
Windows 7

Answer Wiki

Thanks. We'll let you know when a new response is added.

According to ur background, I think, Oracle for Financial Services delivers a powerful combination of technology and comprehensive, preintegrated business applications, including key functionality built specifically for banking and capital markets organizations.
U may go for the certification of Oracle Certified Financial Applications Consultant Rel 11 which is a part of Oracle E-Business Suite. For more details, please <a href=”http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=15″>Link Here</a> and select for E-Business Suite title.
OR one more is here, u can also go for SAS which stands for “Statistical Analysis System” and it has many business solutions that enable large-scale software solutions for areas such as IT management, human resource management, <b>Financial Management</b>, business intelligence, customer relationship management and many more. It is fully SQL support. Please visit for more <a href=”http://support.sas.com/documentation/cdl/en/basess/58133/HTML/default/a001310736.htm”>Information</a>

@Good Luck

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    First what is your goal? Is it to become a DBA, or a database developer, or a business analyst? If you already work for a company ask your IT people what database platform they use. That would be a good start. It'll either be Microsoft SQL Server, Oracle, or DB2. Don't worry about getting a certification right away. The certifications are designed to show that you have been using the platform for a couple of years. Having a certification with no experience will not do you any good what so ever. No one will hire someone with a certification with no experience, and if they do you won't keep that job for very long.
    66,010 pointsBadges:
    report
  • Jeevan2310
    Thanks for both the replies. @Rechil: I will look through both the sites you have given and if there are more questions, then I will get back to you. @Mrdenny: I am presently looking for a job as an analyst and it seems most companies are looking for someone with a knowledge of SQL whether it be Microsoft SQL, Oracle or MySQL. I am at the moment trying to learn one of the SQL packages (preferably one thats cheap to purchase) on my own and thought that a certification with one of the vendor products would enhance my chances. I do not have any experience, yes, but I have got to start somewhere to get it right? @both: I have looked at MySQL and since its open sourced, thought that would be good. Comments welcome on this!
    15 pointsBadges:
    report
  • Mortimer1
    So there is the ANSI SQL Standard which most of the major Database software vendors will support. This is not optimal in that it's a lowest common denominator approach. This will be useful if you want to be a data modeler, but if you wish to be a DBA then you will need to target the specific SQL implementation for a particular Database. A number of years back there was a movement to support Java in stored procedures for some databases, but that does not cover all databases. Unfortunately in order to be proficient in a particular database you will need to choose the one you want to support and then learn it. And especially in the case for databases a specific implementation will affect the different attributes of a database, so while getting a certification is useful almost all companies will require you have some amount of practicial real world experience with a database, unless you already work for said company and are transferring departments.
    675 pointsBadges:
    report
  • Denny Cherry
    To work as a data analyst (or really any sort of analyst) you basically just need to learn how to select data from the database. You don't care about index tuning, etc as you won't have access to do any of that anyway. You can start with the ANSI standard SQL, but there will be gaps as done of the vendors have implemented the entire standard, and all of the vendors have put their own spin on the languages. For example MySQL uses the keyword LIMIT, where SQL Server and Oracle (I think) use TOP to select just a specific number of rows. Both Microsoft and Oracle have free versions of the databases that you can download called the Express editions. These are fully functional versions of the databases. They are just limited in how much data you can put into the database, but for your needs these should work just fine. If you need more power, on the SQL Server side you can get the SQL Server Developer Edition for $50 US from Fry's or online directly from Microsoft. This is basically the Enterprise Edition of SQL Server, but it isn't licensed for production use. Any of the products will get you started, just be forewarned that there are differences between them. I wrote a Back to Basics series a while back, and one of the topics was the select statement. It is from a SQL Server point of view, but it'll probably get you started.
    66,010 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following