Menu
Log in

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

  • Thursday, April 06, 2023
  • 8:00 AM - 12:00 PM
  • 4401 West Gate Blvd Suite 400 Austin, TX 78745
  • 22

Registration

  • 10% Discount from regular price.
  • Non-member regular price.
  • Registration for Board of Directors and Chapter Officers.
  • Please get registration code from your Committee Chair.
  • Please get registration code from your Committee Chair.

Registration is closed

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.

      6.4.1
      • Home
      • John May's Introduction to SQL for Enterprise Databases Workshop - Austin
      Powered by Wild Apricot Membership Software