top of page

Workshop: Databases Management - Agenda

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


Databases Workshop Img 1_Site.JPG

Databases Workshop Img 2_Site.JPG

Databases Workshop Img 3_Site.JPG

Databases Workshop Img 4_Site.JPG


 

NickMachairas2.JPG

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 nick@machairas.com.



 

Trusted by


Trusted by partners

 








Comments


SELECTED POSTS:

Check back soon
Once posts are published, you’ll see them here.
bottom of page