Online Workshop 2 - Database Management Systems for Geotechnical Engineers
Workshop Schedule: Oct 28, Oct 29, Nov 4 and Nov 5, 2020 - 11 AM to 4 PM EST/EDT
20 PDH Credits
The role of databases in data analytics cannot be overstated; databases facilitate efficient, secure and accurate information storage and retrieval across multiple users and platforms. As such, proficiency in database design and knowledge of SQL programming are essential skills for the modern engineer. Databases are crucial in enabling organizations to shift from simply handling unstructured information to processing data and producing insights. As such, you will learn how to program in SQL and design your own relational databases which can then serve as the backbone of interactive visualizations and analyses.This course is designed to help you develop these skills.
In this twenty hour workshop, you will learn how to design simple relational databases and populate the databases with data. Next, you will learn the basics of the most popular query language, SQL to interact with both Sqlite and Postgres databases. Finally, you will use the databases you create to connect to powerful reporting platforms such as PowerBI, Tableau and Metabase with civil engineering and geotechnical applications.
By taking this course, you gain life-time access to the course’s Discourse server where you can post questions and browse for answers and advice from industry experts.
WORKSHOP 2 - AGENDA
Oct 28, 2020 (5 hours):
● Database environment setup
● Introduction to relational databases
Oct 29, 2020 (5 hours):
● SQL programming: select statements, joins, aggregate functions
● Database design, typical civil engineering requirements, typical geotechnical attributes
Nov 4, 2020 (5 hours)
● SQL programming (continued)
● Importing and exporting data
Nov 5, 2020 (5 hours):
● Databases as a backend for PowerBI, Tableau and Metabase, applications in geotechnical engineering
● Extra: database operations with Python
Workshop Instructor: Nick Machairas, PhD,
Nick Machairas, PhD, is a geotechnical engineering and applied analytics consultant with more than seven years of experience building custom business and engineering AI solutions, thus minimizing risk and construction costs. He holds a PH.d from New York University in Civil Engineering. He is also a lecturer at Columbia University and New York University, where he teaches graduate courses on modern database systems and machine learning. He can be reached at firstname.lastname@example.org.