+ 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,787
    Thank Post
    716
    Thanked 1,441 Times in 1,194 Posts
    Rep Power
    360
    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 02: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
    Burgh Heath, Surrey
    Posts
    4,301
    Thank Post
    870
    Thanked 406 Times in 307 Posts
    Blog Entries
    60
    Rep Power
    289
    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,407
    Thank Post
    1,520
    Thanked 1,057 Times in 926 Posts
    Rep Power
    303
    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,787
    Thank Post
    716
    Thanked 1,441 Times in 1,194 Posts
    Rep Power
    360
    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
    632
    Thank Post
    98
    Thanked 134 Times in 104 Posts
    Rep Power
    67
    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, 08:32 PM
  2. work experience
    By shafia2009 in forum Educational IT Jobs
    Replies: 3
    Last Post: 13th February 2009, 11:41 AM
  3. Work experience
    By shafia2009 in forum General Chat
    Replies: 2
    Last Post: 5th February 2009, 02:02 PM
  4. Anyone have experience of this?
    By pinemarten in forum Network and Classroom Management
    Replies: 2
    Last Post: 12th September 2007, 12:31 PM
  5. Getting Experience
    By russdev in forum Educational IT Jobs
    Replies: 2
    Last Post: 21st August 2007, 09: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
  •