Probably due to a lack of activity. I can't remember the last time I even saw an Oracle post. It doesn't make a lot of sense to create a dedicated forum for a topic that will only have a few posts per year. If it ever picks up, I'm sure the powers that be will create a forum for it, just like everything else.
Probably due to a lack of activity. I can't remember the last time I even saw an Oracle post. It doesn't make a lot of sense to create a dedicated forum for a topic that will only have a few posts per year. If it ever picks up, I'm sure the powers that be will create a forum for it, just like everything else.
A lot of OCA/SCSAs might pick up in the coming months (when the ORACLE-SUN deal goes through).
I would certainly be willing to participate. But maybe it might be better to have a general SQL forum in the same way there is no VMWare forum and no Hyper-V forum? I don't know...
I would certainly be willing to participate. But maybe it might be better to have a general SQL forum in the same way there is no VMWare forum and no Hyper-V forum? I don't know...
I like that idea. MySQL is becoming a bigger and bigger part of my job.
I would like to start studying SQL I have no idea about would like to know where to start.
I pretty much taught myself t-sql in about a week. If you have a vm, throw sql express on there and start learning. Once you understand basic syntax and commands, its pretty intuitive from there.
Here is an example of a basic query:
SELECT cases.case_number, cases.style, sum(acct_transaction.amount) as Amount
FROM acct_banktran INNER JOIN
acct_bank ON acct_banktran.bankaccount_sk = acct_bank.BankAccount_sk RIGHT OUTER JOIN
acct_transaction ON acct_banktran.banktran_sk = acct_transaction.banktran_sk RIGHT OUTER JOIN
cases ON acct_transaction.case_sk = cases.case_sk
WHERE (acct_transaction.trans_type = 't') AND (acct_bank.Description LIKE 'AZ%') AND (acct_transaction.eff_date > '2009-06-15')
AND (acct_bank.Description = 'WFB Trust 2009' OR acct_bank.Description = 'WFB Trust 2008')
GROUP BY cases.case_number, cases.style, acct_transaction.trans_type, cases.case_sk
ORDER BY cases.style, cases.case_number
Those are for MS SQL Server so many people who want to post on Oracle would not even bother. But it might just be a question of renaming it something like
SQL Database Exams - Oracle (9i, 10g, 11g) MS SQL Server (2000, 2005, 2008.) MySQL
We'd like to keep the MS exams in the Microsoft certs section, but do prefer a separate forum per cert vendor/cert (and if popular per exam even), rather than forums for technologies. The Virtualization forum is an obvious exception so it's not set in stone either but in this case we can add a MySQL certs forum to the Others category and see later next year if it's worth keeping. Or give Sun their own category with Java and MySQL and then rename it to Oracle later on. I'll give it some more thought and discuss it with JD tomorrow. Thanks for the suggestions!
ronzilla
Member Posts: 47 ■■□□□□□□□□
Comments
A lot of OCA/SCSAs might pick up in the coming months (when the ORACLE-SUN deal goes through).
Agreed 10x.
I like that idea. MySQL is becoming a bigger and bigger part of my job.
Agreed. It would be cool to have a sql area.
Current Studying : GPEN |GCNF|CISSP??
Current Reading : CISSP| CounterHack|Gray Hat Hacking
Completed 2019 : GCIH
Free Reading : History Books
I pretty much taught myself t-sql in about a week. If you have a vm, throw sql express on there and start learning. Once you understand basic syntax and commands, its pretty intuitive from there.
Here is an example of a basic query:
I did this years ago. Try looking here:
W3Schools Online Web Tutorials
Go look under the SQL tutorials and go from there. Pick up a a "...in 24 hours book".
Also grab a copy of oracle/sqlexpress/mysql and start going.
SQL Server 2000 and 2005 exams - TechExams.net IT Certification Forums
SQL Database Exams - Oracle (9i, 10g, 11g) MS SQL Server (2000, 2005, 2008.) MySQL