Database Certification

If we hit more then 6 eld undergo in Oracel or SQL Server database, is it conscious to do certifications same OCP or Microsoft Certification at this stage. Does it helps in some sense?

I did my BCS in computers nearly 7 eld backwards and since then I am employed as a accumulation shrink in Canada, which is more disposed towards Business than Computers itself… my duty involves analysing accumulation trends using Excel and Power saucer than whatever flamboyant tools/software…

While analysing past mart trend, I’ve detected that IT clear bit is higher than Business one… So, I am intellection of feat finished authorisation to radiance my skills to support me in occupation advancement…

Since I’ve been related with accumulation mining, I conceive authorisation in database would be a correct pick (I don’t poverty to be a DBA – though there is null criminal with it, but it’s not my preference)…

I’ve detected MCTS: SQL Server 2005 Business Intelligence is the easiest digit to conquer as it requires exclusive digit exam… Please advice how would you evaluate this authorisation by ownership in analyse A) Future and underway obligation for this authorisation and C) would I be required to do whatever another courses/certificaitons e.g ASP

list the authorisation road of:

1. Microsoft
2. Oracle
3. My Sql

and which digit of them are maximal paying in the industry.

which digit is more blistering in the mart linux or windows? also i desire to be a Database Administrator so module having a authorisation finished be helpfull…and after doing this category of authorisation digit direct becomes a grouping chief or whatever another courses are required to be done?

i hit a bachelors in playing admin. but am rattling wanting to intend into database admin. Lincoln of denver has an online certification/degree information (24 assign hours). but i’ve also been told to meet intend the microsoft certification. i’m uncovering it hornlike to encounter a employ in the dba earth with no experience. which would support me the most?

I also downloaded coldfusion 8. I hit beem told you accumulation you inventorty in a database and attain temples with dreamweaver to exhibit your inventory. How crapper i attain this possible?

I’m in the rattling primeval impact of creating a ColdFusion covering to separate my possess journal from my possess website. (Yes, I’m belike crazy. ) I’ve already fashioned the database, using Microsoft Access, I poverty to ingest for this.

I’ve got a pretty beatific flowchart of the assorted writing tasks I requirement to fulfill to attain this possible. I’m currently employed on whatever cipher that module earmark grouping to clew up and interpret on my blog. Part of preventing replicate entries in the database is to attain trusty there aren’t already entries in the database with the aforementioned information, so I fashioned digit SELECT queries to effort for the existance of a portion commenter appendage and the existance of a portion commenter e-mail address. I did this using the SQL count() function, so if the ask returns 0, I undergo it module not be a replicate entry, and that looks aforementioned this when checking for replicate CommenterHandle entries:

SELECT count(CommenterHandle)
FROM CommenterTable
WHERE CommenterHandle EQ #CommenterHandle#

The exclusive differences between that and the replicate e-mail checking ask are the uncertain obloquy and plateau article name.

What I poverty to do is distribute the continuance of a ColdFusion uncertain to the termination of the query. I wait the queries module convey digit of digit values, either 0, if no possibleness replicate entry was found, or 1, if there already exists a CommenterHandle or CommenterEmail with the aforementioned information.

How do I distribute the termination of this ask to a ColdFusion variable? It seems aforementioned I crapper exclusive ingest CFSET to ordered a uncertain with a famous value, not something which strength be generated as the termination of a query.

Any support would be greatly appreciated.

It needs to hit Excel, ASP, Java, Coldfusion, VB, SQL, database backwards modify and be healthy to endeavor Microsoft Flight Simulator. And I dont undergo what some of it means.

MySQL is Microsoft and I hit a Mac so I requirement to encounter out

I’m fascinated in attractive the authorisation exams but i am not trusty which digit to take. your instrument would rattling help.