UIIPA – Our 33rd Year!

UIIPA – Our 33rd Year!

Utah IBM i Professionals Association

January Meeting: SQL Tips and Techniques on the IBM i

UPDATE: We want to thank David Larsen for a great presentation. If you were not able to make it to the meeting you can access his reference material here: 1) 33-Page slide deck  2) Document with all reference links

 

sqlSpeaker: David Larsen, Software Engineer at Lagoon Corporation

Topic: SQL Tips and Techniques on the IBM i

Date: Wednesday, January 14th, 2015

Time: 11:00 a.m. – 12:00 noon

Location: Murray City Offices (City Council Chambers), 5025 South State Street, Murray, Utah.

Our user group presentation this month will be by David Larsen. He will be introducing the basics of SQL and its implementation on the IBM i. For some of you, SQL is a very familiar tool you use every day. But for others it is a mystery of what it actually is and why you would want to use it. David will give us an overview of SQL with examples of SQL generation with System Navigator, some embedded SQL examples and many tips on how to get started using SQL. So come and learn how to use this very powerful tool.

New Picture (2)

David Larson is currently a software engineer at Lagoon Corporation. Previously he was the Director of Information Systems at Murray City for 16 years and also served as IT Director and Manager with other companies. He is also a founding member of the user group and has worked on the IBM i for many years.

 

sql-join

766 Responses to January Meeting: SQL Tips and Techniques on the IBM i

  1. Its like you read my mind! You appear to know so much about this, like you wrote the book in it or something. I think that you can do with some pics to drive the message home a little bit, but other than that, this is excellent blog. A fantastic read. I will definitely be back.

    Permalink
  2. vocational and activity oriented) and depth (honors, accelerated, advanced vs.
    Next, if you happen to be searching online for any graphic, try to find something can be simply extracted from experience (if there
    is indeed a credentials). Ponbadu along with the small and large nobilities had indulged within this fun, who prefered a beautiful
    color and exquisite decorative style.

    Permalink
  3. I am curious to know just what website system you are working with? I am experiencing a few minor safety challenges with the most recent site regarding omega xl for sale so I’d like to find one thing a lot more risk-free. Do you have any strategies?

    Permalink
  4. I have acquired some new items from your website about pc’s. Another thing I have always believed is that computer systems have become a product that each residence must have for some reasons. They offer convenient ways in which to organize the home, pay bills, go shopping, study, focus on music and in many cases watch television shows. An innovative solution to complete all of these tasks has been a notebook computer. These pc’s are portable ones, small, robust and portable.

    Permalink
  5. Hi I am so happy I found your weblog, I really
    found you by accident, while I was browsing on Google for something else, Anyhow I am here now and would just like to say thank
    you for a remarkable post and a all round entertaining blog (I also love the theme/design), I don’t have time to look over it all at the moment but I
    have bookmarked it and also added in your RSS feeds, so when I have time I will be back to read more, Please do keep up the awesome jo.

    Permalink
  6. It was wonderful reading this article and I believe you’re entirely correct. Inform me in case you’re considering aptoide for pc, this is my main expertise. I’m hoping to see you soon, bye for now!

    Permalink
  7. This is very fascinating, You are an overly professional
    blogger. I have joined your feed and sit up for searching for extra of your excellent post.

    Additionally, I have shared your website in my social
    networks

    Permalink
  8. You made some nice points there. I did a search on the subject matter and found most persons will approve with your blog.

    Permalink
  9. I do trust all the ideas you’ve introduced for your post. They are very convincing and can definitely work. Still, the posts are too short for newbies. Could you please lengthen them a little from subsequent time? Thanks for the post.

    Permalink
  10. A familyy in Puerto Rico is promoting off all of their possessions in order to come across security outside of the hurricane ravsged island.
    Resources are scarce, the family is obtaining issues finding water, food, and other basic necessities.

    The famly is attempting to raise $4000 to be able to afford housing while the island gets
    back to typical operation with water, power, andd communications.

    Puerto Rico has suffered major consiquences due to the fact both hurricane Maria and
    Hurricane Irma ravaged the island. The family has lost every littgle
    thing in the recent storms. They lost their household, their furnishings, their boat and all of their worldly possession much less a few
    products that survived the storms.
    They would be most grateful if you would take a look at their auctions and their fund raising
    web site if you cann donate.

    Permalink
  11. vіctimѕ from Ꮪan Juan ɑuctiߋning their ersonal possessions to leave from Puerto Rіⅽo

    Permalink
  12. Wⲟw that was strange. I јust wrote an incredibly long comment but after I clicked submit my comment didn’t appear.

    Grrrr… well I’m not wгiting all that over again. Anyway, just wanted to say great blog!

    Permalink
  13. Hi, Neat post. There is a problem with your website in web explorer, might check this¡K IE nonetheless is the marketplace chief and a huge component to other folks will omit your wonderful writing because of this problem.

    Permalink
  14. I do accept as true with all of the ideas you’ve presented in your post. They are very convincing and will certainly work. Still, the posts are too quick for novices. Could you please prolong them a little from next time? Thank you for the post.

    Permalink
  15. One thing is that while you are searching for a education loan you may find that you will want a co-signer. There are many conditions where this is correct because you may find that you do not have a past credit ranking so the mortgage lender will require you have someone cosign the loan for you. Great post.

    Permalink
  16. Será que existe uma maneira de emagrecer rosto? http://personagelaser.sunblog.ir/Post/1/sunblog.ir/Register?p=1

    Permalink

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>