NEMUG
The New England Midrange Users Group

Home

Newsletter

Pictures

Schedule

About

Directions

Application

Contact an Officer

 Download Annual    Invoice

Home Page
 

   

 

Next Meeting - Wednesday, September 9, 2020, Presentation by Jim Mason - SQL and Data Management Concepts

 

The New England Mid-Range Users Group is organized as a resource for users of IBM System i, i Series and AS/400 systems. If you were looking for the New England M User's Group (MUMPS) goto www.nemug.org

 

Date:  Wednesday September 9, 2020
Time:

Sign In 5:30 p.m.; Speaker 6:00 - 7:15 p.m., 

Place:  Virtual Meeting, To be held on-line via GoTo Meeting
Topic:

 

 SQL and Data Management Concepts

 

Speaker:

Jim Mason - Sky Web Team

Dinner:

Bring Your Own Dinner

Cost:  No Charge! 

Please let us know if you plan to attend this Webinar no later than Tuesday, September 8, 2020


     

 

SQL and Data Management Concepts

Topic:

SQL and good Data Management are key to every organization's success.
Everyone knows having the right data with the right quality is always important.
This session covers a lot of ground at a high level, quickly on SQL and data management concepts:

1.        Databases and data sources ( SQL, NoSQL etc )

2.        Application access to Data ( Java, RPG, more )

3.        SQL basics

4.        SQL functions

5.        SQL sub queries and pipelines

6.        SQL filter, map, reduce queries

7.        SQL Stored procedures 

8.        External Stored procedures 

9.        Java example of SQL event streams for real-time, automation

10.      Simple example of a Java Lambda expression 

11.      Simple example of an AWS Serverless function

12.      A few simple examples of Java data analytics services 

13.      Logical diagram of a Cloud data analytics solution from data source, transformation, map-reduce and visualization

14.      Some options for frameworks and tools to use for data management 

 

Speaker Bio:

Jim helps clients turn technologies ( data, services, blockchain, analytics ) into improved operations results, infrastructure, trust, compliance, performance, lower costs, lower risks.
Jim’s background includes:
• Blockchain Practice leader at Sky Web Team
• DMX Foundry Director led cloud analytics, Hyperledger blockchain
• Work on the Hyperledger Fabric Documentation Team
• MOBI Core team for Vehicle Identity standards
• Data services, data warehouse architect
• Director of Infrastructure & Architecture at Fidelity
• Over 100 presentations at COMMON and articles

 

NEMUG Officers:
 

President  

Dawn Dawson,
The Moore Company

(401) 315-6351

ddawson@themooreco.com

Vice President  

Chip DiFolco,

Callico

(774) 227-7373

cdifolco@callico.com

Secretary  

Rick Marcotte

iTech Solutions  

(508) 243-3508

 

rmarcotte@itechsol.com

Treasurer  

Eileen Newell,
FGX International
  

(401) 719-2337  

enewell@fgxi.com

Webmaster  

Rick Marcotte

iTech Solutions

(508) 243-3508

rmarcotte@itechsol.com

NE Conference Liaison  

Chip DiFolco,

Callico

(774) 227-7373

cdifolco@callico.com




President's Message:

NEMUG would like to thank two great speakers, Dan and Aaron Magid, from Eradani who took time on July 29th to speak to us about the fundamentals of Java Script Programming for RPG Developers.  Eradani (www.eradani.com) is a new company in the IBM world located in Berkeley, CA.

 Please join us again on September 9th for another NEMUG Virtual Meeting.  This month we have a great speaker, Jim Mason, Senior Architect at Sky Web Team, joining us to talk to NEMUG about "everything" SQL.  Join us at 5:30 pm for networking - the Speaker will start at 6pm.


Dawn Dawson

NEMUG President

     
 

E-mail Notification
If you are not on our e-mail list, go to the web site at www.nemug.com and click on the "Subscribe" button to be added to the list.

 

Welcome to the following New and Renewing Member Companies

(as of 9/1/2020)

FGX International

Callico Distributors

J.H. Lynch & Sons

The Moore Company

CCBS

iTech Solutions

Franklin Sports

Natco

 


If your company has not renewed their NEMUG Membership as of August 2019, go to the website to download the annual invoice for membership (on left side of the home page). Bring a check (payable to NEMUG) and the form with you to get the member prices at the meeting.
 

Thank you for your support of NEMUG!

 

 
 

 

The next meeting
Wednesday, September 9, 2020 -

Register for next meeting:  Click to register

 

Manage your subscription to NEMUG emails

 

Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Subscribe
For Email Marketing you can trust

Maxava.com

iFoundation.com

The Maxava iFoundation, established by Maxava, to support non-profit IBM i user groups, has awarded a grant to NEMUG.  We are proud to be recognized by the Foundation, and to have been selected for this award.  We look forward to a lasting relationship with them.

Click on either of the links to learn more about Maxava, and the Maxava iFoundation.

 

Click to see a 1968 midrange computer!

------------------------------------------
 
 

   

 
11-08

 

Copyright 2011-2012 New England Midrange Users Group

Site created and maintained by Rick Marcotte  -- Last updated September 02, 2020 -- Best Viewed at 800x600

Top of Form