Location visible to members
Big data is sexy 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.
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.
• 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
• A burning desire to learn SQL
About the Instructor:
Vicki is a data scientist at CapTech Consulting. She's been wrestling with data for over nine years in every format known to humanity. Currently, she does a lot of work with Hadoop, Python, and SQL. When not making CSV files cry, Vicki blogs, runs, and reads. She also enjoys a fine jar of Nutella occasionally.
All attendees are expected to abide by the Girl Develop It Code of Conduct.
Questions about the class or want to Teaching Assist? Contact [masked]
See our Assistance page for information on scholarships, laptops for loan, and other services. We'd like to help you benefit from our classes!
NOTE: Refunds are offered only if the class is rescheduled/cancelled or in extreme circumstances.