[AccessD] Skills Assessment - PL/SQL

And don't Oracle distribute mySQL these days?  Although as Jim said, they are very similar.

For what it is worth Bill, in the interview I would focus on selling yourself on the concepts and your understanding of those concepts rather than the nitty gritty details.  If you can write and understand any SQL (or even code for that matter) and understand databases and normalisation then you have some good skills that are worth having.  Don't let the minor details cloud what you have to offer these people.

Deeply understanding the core concepts of data and how to manipulate it is where the value lies - So if you get stuck, I would really emphasis that point and focus on those skills.  It is not knowing every little quirk of the software language that is important - it is understanding what is possible, what can / should be done vs what shouldn't be done.  Frankly with Google, anyone can find out the answer, but understanding the issue is more important and valuable.

Anyway.  Good luck - let us know how you go.
Cheers
Darryl

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Wednesday, 16 July 2014 12:18 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Skills Assessment - PL/SQL

It is just the Oracle database language.... Both MS SQL and Oracle procedural languages are very similar. I use to just copy and paste from one to the other and then make the few appropriate changes.

Jim 

----- Original Message -----
From: "Bill Benson" <bensonforums at gmail.com>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Tuesday, 15 July, 2014 7:50:18 AM
Subject: [AccessD] Skills Assessment - PL/SQL

Does anyone know of a commercially available skills assessment test for PL/SQL? I have a job interview in two days and that is what I have been informed I will be taking as a part of the candidate selection process. I don't even know if I am good at it or not. I could certainly use a primer in getting better at it. Please be so kind as to recommend a source for refreshing me memory. I have SQL Server on my machine and SSMS, but I have not put on Oracle, and I am not sure in the short amount of time between now and the interview I would want the headache of downloading Oracle and SQL Developer.

 

It is kind of odd that they put on the job requirements that they were looking for someone with skills in SSRS and SSIS, as well as ETL, but then they give a skills assessment in an Oracle based product.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com