John May's Introduction to SQL for Enterprise Databases Workshop - Austin

Introduction to SQL for Enterprise Databases

April 6, 2023

8:00 AM - 12:00 PM

HDR | 4401 West Gate Blvd, Suite 400 | Austin, TX 78745

Park in the private Parking Garage in the back of the building

This tutorial is designed for people who are new to SQL and would like to use it to answer questions with data. SQL is the cornerstone of data analysis—it's used for accessing, cleaning, and analyzing data stored in databases. It can be used to quickly answer questions and analyze data. This class will focus on SQL operations within an ESRI geodatabase environment consisting of feature classes, related tables, and attachment tables and include SQL code examples that could be reused in your environment. The following topics will be covered:

1.       Important Enterprise Database Design Considerations

2.       SQL Do’s and Don’ts for Enterprise Databases

3.       SQL Operations

SELECT - WHERE - LIKE - IN - BETWEEN -

AND - OR - IS NULL - ORDER BY

4.       SQL Data Manipulation

COUNT - SUM - AVG - GROUP BY - CASE - 

DISTINCT - INNER JOINS - OUTER JOINS - LEFT JOINS -

 LEFT JOINS - UNION - SELF JOINS

Requires: General knowledge of GIS.

Class materials and a workbook will be provided for each student.

Schedule:

8:00 AM - 8:30 AM - Breakfast/Snacks provided 

8:30 AM - 12:00 PM - Intro to SQL

Mappy Hour Lunch afterwards at 

Hyde Park Bar & Grill 

4521 West Gate Blvd Ste B | Austin, TX 78745

Registration price:

Regular Ticket - $100

URISA Members Discount - $90

Instructor:

John May

John has been using ESRI products and doing GIS since 1989. During that time he has used GIS for many diverse applications from site selection and analysis for banks and retail businesses to land and endangered species management for the USFS and DOE. During the last decade the range of his projects included work for the Department of Homeland Security, the Tarrant Regional Water District, several major Oil and Gas companies, and the Florida Department of Transportation. Johns' specialties are using native RDMS capabilities in concert with SQL Server Reporting Services to extend the value and utility of web enabled GIS platforms.

Cancellation Policy

Full refunds are available up to 14 days before the event. Please refer to our Cancellation Policy for details.