Introduction to SQL for Enterprise Databases
April 7, 2023
8:00 AM - 12:00 PM
11330 Clay Rd, Houston, TX 77041
Conference Room 1008
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.
8:00 AM - 8:30 AM - Breakfast/Snacks provided
8:30 AM - 12:00 PM - Intro to SQL
Regular Ticket - $100
URISA Members Discount - $90
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.
Full refunds are available up to 14 days before the event. Please refer to our Cancellation Policy for details.