| |
|
EVENT DETAILS |
SQL is a language used to query, modify & update data in databases, tasks commonly associated with data analysts & data scientists across multiple disciplines, including finance, marketing, business operations, product, & data science.
This workshop is part two of a part two series, with it being an intermediate workshop. This bootcamp will provide a intermediate-level introduction to SQL, & is for those who already have a beginner foundation of SQL knowledge.
Required Materials: Laptop
Agenda
Introduction
Set up Mode access & UI
Topics covered include:
What is a database & tables
How to query a table, including:
Inner Join/Left Join review
Nested subqueries
Union/Union all
Case when with & without aggregations
Instructor Bios
Ryan Baker has always had a passion for exploring new ways to use technology to improve lives, communities, & businesses. His drive to understand what makes people tick & how to tap into those needs has led him to careers developing technology in the music industry & most recently in software. After earning his Master's in Information Management & Systems from the UC Berkeley School of Information in 2014, he joined TubeMogul, a fast-growing ad tech company in Emeryville, CA, where he became Director of Marketing Technology. He now works at Adobe, building information systems & data products that support Enterprise Marketing & Sales. When not on the computer, Ryan is likely pursuing culinary delights, doing the Times Crossword, seeing live music, or exploring the natural wonders of California.
Christine Petrozzo has worked in the media industry for ten years, with 7 of those years working on analytics teams. A graduate of UC Berkeley's School of Information master's program, she currently is a business intelligence manager at CBS Interactive in San Francisco, using SQL on regular basis to support strategy & operations across the company. When she's not working, you can find her pursuing her interests like traveling, learning Spanish, hiking, playing with her new Brussels Griffon puppy, & mentoring women & men who want to learn more about data & its role within business.
Partner Bio
CBS Interactive is the premier online content network for information & entertainment. Our brands dive deep into the things that people care about across entertainment, sports, news, technology, games & media. With over 1 billion users visiting our properties every quarter, we are a global top 10 web property & the largest premium content network.
|
|
|
|
|
|
