Home

Welcome to Elfinwood Ecology

Data Science, Ecology, and Conservation based in Washington’s Methow Valley

Latest from the Blog

Lesson 009: Advanced filtering using SQL WHERE

Introduction In the previous 2 posts I covered SQL select statements, and we looked at the Lesson_007 and Lesson_008 files in the learning-data-science GitHub repository. Lesson 007 covered the basics of SQL selects statements, and Lesson 008 covered LIMIT and OFFSET, column aliases, data type casting, creating columns on-the-fly, mathematical operations. In this post, LessonContinue reading “Lesson 009: Advanced filtering using SQL WHERE”

Lesson 008: SQL SELECT Part 2

Introduction In the previous post I covered part 1 of SQL select statements. We looked at the Lesson_007 files in the learning-data-science GitHub repository to learn the basics of SQL select statements. In this post, the second of 2 posts focused on SQL select statements, I cover LIMIT, OFFSET, mathematical operations, creating columns on theContinue reading “Lesson 008: SQL SELECT Part 2”

Lesson 007: SQL Select Part 1

Introduction In the previous post I covered SQL Statements. We looked at the Lesson_006 files in the learning-data-science GitHub repository to learn about SQL statements, run several SQL statements strung together in a SQL script, and wrote a basic select statement. In this post, Lesson 007, we’ll learn about SQL select statements in more detail,Continue reading “Lesson 007: SQL Select Part 1”

Get new content delivered directly to your inbox.

Copyright © 2020, Aaron Wells