Basic Database Knowledge?

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Hi,

I have managed to get an interview for an apprenticeship Within a Information department that deal with design, developing and maintaining IT systems, providing data and essential tools for day to day running.

My query is, how extensive is Basic Database Knowledge, as im a complete novice (hence why i chose an apprentice scheme) what should i be prepping on? The Job description does state that its to do with MS access and SQL server and data sources in oracle development.


Any info is much appreciated!!


Chris!

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

You could read/learn a little about Access, also google a bit about relational database - it is on Wiki but I am sure there are easier to follow definitions to be found. Also search for SQL - don't think you should know any as it is quite steep learning if you're new to it, but you should definitely know what it is. If you want to impress them read up on database normalization - 1st, 2nd and 3rd form. I'd describe these as basic stuff you'd need to know, they might think different;)
good luck!

 

Thanks Nyx! Mucho appreciated!

Ive been told I will be doing a task to demonstrate my data system knowledge, as this is my first ever interview for an IT position so it is quite daunting.

 

As its your first interview just relax and no matter what happens use it as experenice for your next interview, unless you get the job then you wont have anotehr interview for awhile

 

SQL Introduction

Have a look at that link. It's a tutorial on SQL primarily but does cover a bit about what a database is and what it does. You should be able to work your way through that over the weekend and I think it should give you all the basics.
I reckon they're going to be looking for some basic SQL knowledge as well as a general idea about what a database is and what it can do. Since it's an apprenticeship I doubt they're looking for too much knowledge.

 

Thank youfor the link, i've been through most of it but my concern is how that will relate to the task they will present. I think next i will go through access (office for dummies )

Thanks again!


Chris!

 

Firstly make your basic database concepts very clear. Because that forms the basic foundation for many database languages. Try to grasp more knowledge from various website like sqlservercentral.com/forum. Also study the concept of different database connection in various languages. Always keep yourself with up to date knowledge.

 

SQL is a standard language and forms 80% of most vendors proprietary SQL. Syntax for Stored Procedures tend to differ the most between databases.

I would not think that connection pooling, and database connection handling in various languages really fits 'Basic Database Knowledge' for IT support/admin.

 

well i had the interview and wasn't successful. I was told that i'd get a call by end of week for feedback.

The role mainly consisted in using access, just going to take it as experience and progress and thanks to all your replies.



chris

 

Experience is valuable. Getting verbal feedback (where you can ask for clarification) is invaluable. You haven't succeeded this time but you'll be better armed for the next one.

 

There's also this site for help wth learning SQL & Access.

HTH
NB