Key Points

1. SQL basics
2. SQL procs, functions, events
3. SQL in applications
4. SQL event streams
5. NoSQL databases using SQL
6. common data tools - Squirrel, BIRT, Grails, more
7. data source mappings
8. data transformations - FMR
9. data visualizations tools - BIRT, PowerBI, R
10. data editing tools - Grails, SQL clients
11. data roles - goalie, janitor, whisperer, therapist
12. data modeling
13. process modeling - JEPLD - Jim's Event Processing Language with Decisions

References

Key Concepts

session: SQL and Data Management Concepts 

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 

Jim Mason 

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

Advanced SQL Presentation that has some new updates I created I have yet to add as slides that might be fairly relevant:

1>  SQL Stream support for streaming events - sample code

2> Lambda functions ( Serverless ) - for anyone creating simple services in the cloud

3> Some Groovy data analytics examples - for data scripting, services, data quality etc

4> Logical diagram on how Cloud data services work as a model ( similar for GCP, Azure, AWS and IBM Cloud )

This is the old version I've attached but the 3 items above are quick to add to make the new presentation.

Potential Value Opportunities

Potential Challenges

Candidate Solutions

Step-by-step guide for Example

sample code block

Recommended Next Steps

Related articles