SQL Workshop

In this 2-hour workshop, we will learn about relational databases using one of the most in-demand versions of SQL PostgreSQL (open-source). The workshop will focus on how to read and write SQL queries.

In this workshop, we will work through a large dataset running several queries to select and analyze different parts of the dataset. We will start off by learning about tables, then we will move onto running simply queries using (Select, From, Where, Group By, Having, and Order By). In the second half of the workshop, we will focus on aggregation functions (min, max, avg, sum) before wrapping up learning about clauses of join and merge.

Agenda:

4:50 pm - 5:00 pm Arrival and socializing
5:00 pm - 5:10 pm Opening
5:10 pm - 6:50 pm Dane Miller, "SQL Workshop"
6:50 pm - 7:00 pm Q&A

About Dane Miller:

Over the past five years, Dane has been working as a science educator in Palo Alto. Where he teaches science, builds hands-on science programs, and mentors students. His passion is science! Prior to being a science educator Dane worked in the field of paleontology for 10 years. He worked on several paleontology projects focused on data collections and curatorial work with the Denver Museum of Nature and Science and the Smithsonian National Museum of Natural History. In 2010, he was part of a major paleontological discovery in the state of Colorado’s history. Working with a team from the Denver Museum of Nature and Science, we unearthed a treasure trove of fossils 30,000+ vertebrate fossils from mammoths, mastodons, camels, deer, bison, bear, and many other animals. The discovery of this ice age ecosystem drew news coverage from the New York Times, NOVA, and National Geographic. The fossil conifer cones from this discovery led to his graduate research at the University of Wyoming, Laramie.

In graduate school he started finding the power of scientific programming using SAS and R. Two years ago, he was inspired to pursue data science by a keynote address by Dr. Debbie Berebichez. Since then Dane has become proficient in Python, R, and SQL. He actively reaches out in the data science community to collaborating with a wide range of interests in paleontology, healthcare industry, wine, and here with Magnimind Academy.

This past December, Dane was hired as a Data Scientist with Les Schwab Tires Center in Bend, Oregon. In this position, he worked extensively with Snowflake SQL databases, managing automated systems in the Dataiku platform and modeling with Python. Dane works on the Business Intelligence team to support business decisions throughout the company.

https://us02web.zoom.us/j/97761884210 Webinar ID: 977-6188-4210