Session #1: Tuesday, April 17 @ 6:00pm – 8:30pm
Session #2: Thursday, April 19 @ 6:00pm – 8:30pm
Session #3: Tuesday, April 24 @ 6:00pm – 8:30pm
Session #4: Thursday, April 26 @ 6:00pm – 8:30pm
Ever think there must be a better way than a hefty Excel document to keep track of client records, inventory, or contact information? Want to get your hands dirty in the data that gets served up to a website by Django, Rails, or Drupal? Join us for a friendly introduction to the wonders of relational databases and SQL!
Some topics we’ll cover include:
• What is a relational database? What is SQL?
• What can you store in a database?
• Data in, data out: INSERT, UPDATE, and DELETE
• Basic Queries; SELECT, FROM, WHERE, ORDER BY, and LIMIT
• Data in, data out: CREATE, ALTER, DROP
• Intermediate Queries: GROUP BY, aggregate functions, and JOIN
Dinner will be provided!
JOIN US ON SLACK: Girl Develop It Ann Arbor Slack (https://gdiaa-slack.herokuapp.com/)
WHAT TO BRING: Please bring your laptop and charger. Power strips & Wi-Fi will be provided.
-Your laptop. Note: A netbook or tablet will NOT work as a substitute.
-A modern browser, either Chrome or Firefox (with the Firebug extension installed).
-A text editor. We recommend Sublime Text 3 (it’s free for unlimited trial and available for both Mac and PC.)
We will be using PostgreSQL 9.5 for this class. Please download and install PostgreSQL prior to class: Mac OSX 10.7+ (https://therufs.github.io/intro_to_sql/gdirdu/2016/08/20/mac-install/)
Windows 7, 8, 10 (https://therufs.github.io/intro_to_sql/gdirdu/2016/08/20/windows-install/)
Instructions for other installation options are available on the PostgreSQL wiki: https://wiki.postgresql.org/wiki/Detailed_installation_guides
QUESTIONS? We’re here to help! If you have additional questions or would like to talk further before signing up for a class, please contact us at [masked] or reach out to us on Slack (https://gdiaa-slack.herokuapp.com/).
SCHOLARSHIPS: We are offering scholarships on a limited basis for students with financial need. Please complete our scholarship application (http://www.gdiannarbor.com/scholarships.html) if you are interested. Scholarship recipients will be notified via email at least 1 week before class.
ABOUT THE INSTRUCTOR: Megan Boczar
Megan Boczar has been a software developer since way back in April. She graduated with a degree from the University of Michigan in anthropology with minors in museum studies and Polish language, literature, and culture. Since graduation, her passion for data took her around the outskirts of development for several years, before she finally jumped into a Grand Circus Detroit bootcamp. When she’s not coding, Megan enjoys playing board games and spending time with her baby nephew, Walker. Megan, her husband Sean, and cat Sammy love all manner of nerdy things.
HOSTED BY: Thomson Reuters
At Thomson Reuters, (https://www.thomsonreuters.com/en.html) we believe what we do matters. We are passionate about our work, inspired by the impact it has on our business and our customers. As a team, we believe in winning as one – collaborating to reach shared goals, and developing through challenging and meaningful experiences. With over 50,000 employees in more than 100 countries, we work flexibly across boundaries and realize innovations that help shape industries around the world.
SPONSORED BY: DocNetwork
DocNetwork is the leading electronic health record system for camps, child care and schools. A collaborative effort between doctors, nurses and directors, DocNetwork helps organizations improve efficiency and maximize safety, managing health forms, allergies, medications and illness and injury tracking.
All attendees are expected to abide by the Girl Develop It Code of Conduct (http://www.girldevelopit.com/codeofconduct).