Name: Databases Part II: Querying in the Real World
Start: 2016-10-13T18:30:00-04:00
End: 2016-10-13T20:30:00-04:00
Location: The Graduate Center, CUNY

Databases Part II: Querying in the Real World

The GC Digital Fellows

<P><SPAN>Databases are a ubiquoutous piece of software on our personal computers and on the internet. They enable the storage of data in such a way that we can access it in a reliable and robust way. One of the most important types of databases are "relationational databases" that store data in structured tables and provide users access to the data through SQL, a querying language which allows us to filter, sort, and combine our data. This workshop will build on the basics of SQL covered in Databases (Part 1) on Oct. 4th. We will use a sample MySQL database from a Wordpress website to reveal some of the many secrets to the magic of the internet. We will begin by inspecting the database schema, examining how the "relationships" of a "relational database" are specified and maintained as we add and remove data. Having better understood the layout of an actually existing database, we will proceed to query the data, asking questions like "how many posts has each user created" and "which post had the most comments." The topics covered in this workshop are applicable across different SQL implementations, including MySQL and PostgreSQL. If you are unable to attend Part 1 of this series, please look through this tutorial: https://digitalfellows.commons.gc.cuny.edu/2016/04/08/fun-times-with-sqlite-or-a-beginners-tutorial-to-data-management-and-databases-with-sql/</SPAN></P>

The Graduate Center, CUNY

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Databases Part II: Querying in the Real World

More events from The GC Digital Fellows

Follow organizers to get events picked for you

Databases Part II: Querying in the Real World

More events from The GC Digital Fellows

Follow organizers to get events picked for you

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.