Intro to SQL

Big data is hot right now. SQL is like the hipster of data. It was cool before people were into data. Most large companies, and many small ones, store all the valuable information about their companies in databases, and SQL is the language to get at that data and find out what you want about your customers, your products, and your entire business. SQL is a declarative language, which means it reads a lot like English, and is easy to get started with.

This class will teach you how to query databases, create them, and edit them, to get the information you need without waiting for developers or business analysts. SQL power to the people.

You'll learn:

First Half (Morning): How to Read a Database

• What's a Database? What's SQL?

• Select statement

• Grouping by statements

• Clauses and joins

Second Half (Afternoon): How to Write to a Database

• Creating, deleting, and updating a table

• Super-awesome bonus round: subqueries

This class is the second in a series of classes focusing on data, and goes hand-in-hand with Sondra Willhite's Intro to Database Design class. You don't need to have taken the class, but a familiarity with database concepts and terminology helps. No prior programming skills necessary, since SQL is all fun and declaratory like that.

PREREQUISITES AND TECHNICAL REQUIREMENTS

Preferred but not necessary to have taken Sondra Willhite's Intro to Database Design course.

Please come to class with a laptop with Internet connection capability

Also, please download DB Browser for SQLite prior to class. DB Browser for SQLite is an open source visual tool that works with database files within your computer. The tool is great for SQL practice as there is no need to access a server.

Download links:
http://sqlitebrowser.org/
https://github.com/sqlitebrowser/sqlitebrowser

If you have difficulties installing it, please contact Emily or come to class early and she can help you.

ABOUT THE TEACHER

Emily Supil is a Senior Business Intelligence Analyst and Developer at IBM, where she works on strategic analytics projects for Worldwide Software Sales. Emily learned to code on the job and uses SQL every day. Her previous role was a Technical Seller for IBM's Business Analytics portfolio. Outside of work, Emily enjoys volunteering for STEM initiatives with Girls Who Code, TechGirlz, and ChickTech.

IMPORTANT INFORMATION

Girl Develop It welcomes all genders and identities to our classroom. By entering this group, all community members agree to abide by our Code of Conduct ( http://www.girldevelopit.com/codeofconduct).

See our Assistance page for information on scholarships, laptops for loan, and other services. We'd like to help you benefit from our classes! (http://bit.ly/gdiphillyhelp)

Questions about the class or want to Teaching Assist? Contact jend@girldevelopit.com.

REFUNDS AND WAITLIST

Refunds are offered only if the class is rescheduled/cancelled or in extreme circumstances. If you are no longer able to attend, please post your interest in selling your ticket in the comments. If you find a buyer, send a Meetup message to Jen with the name of the buyer. Do not change your RSVP in the Meetup event.

Unfortunately, GDI cannot offer a waitlist. If the class is full, please keep an eye on the comments to see if another student is interested in selling their ticket to you.

CLASS FREQUENCY

We aim to offer this class four times per year. Timing varies based on teacher and venue availability. Keep an eye on our Meetup page for future class announcements.