SQL: Exploring Data
You know how to select data from a table, but how do you do more than pull rows and columns of data? How can you get summary measures from the database? How can you find text that matches what you’re looking for? What if you need to manipulate the data? This workshop is the second in the SQL series focused on working with existing databases. This workshop uses PostgreSQL, but the concepts are generally applicable to other SQL databases.