1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Basic Database Knowledge?

Discussion in 'Employment & Jobs' started by chris1, Jan 26, 2012.

  1. chris1

    chris1 Bit Poster

    13
    0
    2
    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 :oops: (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!
     
  2. Nyx

    Nyx Byte Poster

    131
    7
    15
    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!
     
  3. chris1

    chris1 Bit Poster

    13
    0
    2
    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.
     
  4. Rob1234

    Rob1234 Megabyte Poster

    782
    24
    69
    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 :D
     
    Certifications: A few.
  5. soundian

    soundian Gigabyte Poster

    1,460
    71
    107
    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.
     
    Last edited: Jan 27, 2012
    Certifications: A+, N+,MCDST,MCTS(680), MCP(270, 271, 272), ITILv3F, CCENT
    WIP: Knuckling down at my new job
  6. chris1

    chris1 Bit Poster

    13
    0
    2

    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 :oops:)

    Thanks again!


    Chris!
     
  7. frankcastle

    frankcastle Bit Poster

    21
    0
    36
    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.
     
    Certifications: MCSE
    WIP: CCNA
  8. dmarsh

    dmarsh Terabyte Poster

    3,782
    302
    184
    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.
     
    Last edited: Jan 31, 2012
    Certifications: CITP, BSc, HND, SCJP, SCJD, SCWCD, SCBCD, SCEA, N+, Sec+, Proj+, Server+, Linux+, MCTS, MCPD, MCSA, MCITP, CCDH
  9. chris1

    chris1 Bit Poster

    13
    0
    2
    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
     
  10. soundian

    soundian Gigabyte Poster

    1,460
    71
    107
    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.
     
    Certifications: A+, N+,MCDST,MCTS(680), MCP(270, 271, 272), ITILv3F, CCENT
    WIP: Knuckling down at my new job
  11. Notes_Bloke

    Notes_Bloke Terabyte Poster

    3,230
    54
    146
    There's also this site for help wth learning SQL & Access.

    HTH
    NB:D
     
    Certifications: 70-210, 70-215, A+,N+, Security+
    WIP: MCSA

Share This Page

Loading...