+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20
MIS Systems Thread, CMIS Experience in Technical; I have a really good, crib sheet i wrote on SQL i can send you if you like, it's just ...
  1. #16

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    I have a really good, crib sheet i wrote on SQL i can send you if you like, it's just a scan of some hand written notes i made yonks ago, but it is pretty good and covers the basics, including the various joins and select filters you can use.
    EDIT: It's generic for SQL, not for SIMS or anything. I do have some scripts i use for SIMS if you want them for various tasks, like looking at who is running SIMS, which updates have been applied, not sure if many use joins though.

    I'd post it here but i'm embarassed of my handwriting, i should type it up i suppose.

    A bit of confidence with SQL will surely hold you in good stead for any future DB role, but certainly with CMIS. The SIMS layout is all over the place and a nightmare to understand.
    Last edited by vikpaw; 24th May 2011 at 03:24 PM. Reason: addition

  2. Thanks to vikpaw from:

    CAM (24th May 2011)

  3. #17
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Reigate Area, Surrey
    Posts
    4,428
    Thank Post
    884
    Thanked 416 Times in 316 Posts
    Blog Entries
    61
    Rep Power
    328
    Was tempted to post some sample SQL scripts on here that I knocked together with the Green Abbey database, but not sure if I might attract Phil's wrath if I do...

  4. #18

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,454
    Thank Post
    1,543
    Thanked 1,070 Times in 935 Posts
    Rep Power
    305
    The Serco Squirrels are an interesting breed, think of them as a cross between the red and the grey and then you will be fine I'm sure @michael2k6 will agree with me the Hybrid-Serco-Squirrel is an interesting character

  5. #19

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    Quote Originally Posted by CAM View Post
    Was tempted to post some sample SQL scripts on here that I knocked together with the Green Abbey database, but not sure if I might attract Phil's wrath if I do...
    Best not to give too much dangerous stuff out unless it's asked for, to stop people messing.

  6. #20

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    636
    Thank Post
    101
    Thanked 135 Times in 105 Posts
    Rep Power
    68
    Serco Squirrell what now? John what are you on? Cross breeding squirells? What now?



SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. experience of switchshop.co.uk
    By networkingNut in forum Recommended Suppliers
    Replies: 5
    Last Post: 5th February 2010, 09:32 PM
  2. work experience
    By shafia2009 in forum Educational IT Jobs
    Replies: 3
    Last Post: 13th February 2009, 12:41 PM
  3. Work experience
    By shafia2009 in forum General Chat
    Replies: 2
    Last Post: 5th February 2009, 03:02 PM
  4. Anyone have experience of this?
    By pinemarten in forum Network and Classroom Management
    Replies: 2
    Last Post: 12th September 2007, 01:31 PM
  5. Getting Experience
    By russdev in forum Educational IT Jobs
    Replies: 2
    Last Post: 21st August 2007, 10:41 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •