2b:null 2c:["$","title",null,{"children":"Course: Introduction to SQL | Fotis Zapantis | Observable"}] 31:T943,slide_style = html``32:[{"id":"acb44970c19bdd95d7a49f9a40cae77075a472b7c6b6b4ef25206c7474751b3299804a1daa9f9966cde10f5962199eb05dc8c649932dd890999794e8c39bbba5","href":"https://static.observableusercontent.com/files/acb44970c19bdd95d7a49f9a40cae77075a472b7c6b6b4ef25206c7474751b3299804a1daa9f9966cde10f5962199eb05dc8c649932dd890999794e8c39bbba5","name":"paul.jpg","type":"image/jpeg","lastModified":1686154070678.578,"size":76635}] 2f:{"id":"73fa262b43dc9880","slug":null,"title":"Course: Introduction to SQL","thumbnail":"0be3f6bf6a0540f19503a3f4c8750bb986d241b183c94c1e95590ad99afd95d7","access_level":"public","create_time":"$D2023-06-07T16:07:50.678Z","update_time":"$D2023-06-07T16:07:50.678Z","view_time":null,"first_public_time":"$D2023-06-07T16:07:50.678Z","has_unpublished_edits":null,"fork":{"id":"a30a84d0c5fcba3d","slug":"intro-to-sql-course","title":"Course: Introduction to SQL","owner":{"id":"f35c755083683fe5","login":"observablehq","name":"Observable"}},"stars":0,"starred":false,"owner":{"type":"team","id":"1a8df8d954834dc2","login":"fotisz","name":"Fotis Zapantis","avatar_url":"https://avatars-next.observableusercontent.com/901e545cdb3cac06c4e839534bbc428dfeaf42076ff667a94c51a36ffa05a710","tier":"starter_2024"},"version":238,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"acd5a464e612f2ce","login":"fotisz","name":"Fotis Zapantis","avatar_url":"https://avatars-next.observableusercontent.com/15771ec342f0d7ed8668e8ab4d7b9e0ec698cf2903a9002e4ac0c9b5f5178a99","tier":null}],"members":[{"type":"individual","id":"acd5a464e612f2ce","login":"fotisz","name":"Fotis Zapantis","avatar_url":"https://avatars-next.observableusercontent.com/15771ec342f0d7ed8668e8ab4d7b9e0ec698cf2903a9002e4ac0c9b5f5178a99","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Course: Introduction to SQL","cells":[{"id":6,"value":"\n

\n

\n

Course: Introduction to SQL

\nInstructor
\nPaul Buffa
\nHead of Product Education at Observable

\n\n

\nDates and times
\n May 30th, 31st, June 6th, June 7th
\n at 9:00 AM PT / 12:00 PM ET
\n

\n\n

\n \n

\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":7,"value":"# Course: Introduction to SQL","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":8,"value":"## Description \nWhether you're a data analyst, a data scientist or a developer, it's extremely helpful to know some SQL so you can effectively pull data from a database. For many, learning SQL can be difficult because it is very different from common programming languages like JavaScript, Python, or R. Not to worry – our very own [Paul Buffa](https://observablehq.com/@pstuffa?tab=profile) will make SQL easy to learn and perhaps even _fun._\n\nIn this course, you’ll learn the SQL basics for pulling and wrangling data, including: the main SQL clauses (SELECT, FROM, WHERE, GROUP BY, etc.), aggregation functions, joins, window functions and how to impress your friends and colleagues with lightning fast queries. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":9,"value":"## Who is this course for? \n\nThis course is for anyone who wants to learn the basics of working with SQL. It is geared toward those who work with data and may have some familiarity with SQL, but have not written many queries. To note, we'll also get into more advanced topics that can be helpful for even the experienced SQL user. \n\n____","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":10,"value":"## Sessions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":11,"value":"details(\n md`\n### Get Data from a Database\n** May 30th **\n- What are relational databases?\n- Working with SQL in Observable, DuckDB\n- The SQL clauses\n- SELECT, SELECT DISTINCT and GROUP BY`\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"details(\n md`### Joins and Filters\n** May 31st **\n- What is a JOIN?\n- To LEFT JOIN or not to LEFT JOIN\n- ANSI-style JOIN\n- AND, OR, BETWEEN\n- WHERE vs HAVING\n- WITH statements, nested SELECT`\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"details(\n md`### Common SQL Functions\n** June 6th **\n- Aggregation functions, such as count, count distinct, sum, average\n- Case expressions, Coalesce\n- In, Like, Wildcard, Exists `\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"details(\n md`### Advanced Queries\n** June 7th **\n- Window functions\n- Query optimization\n- SQL dialects`\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"___\n## Course Format\n- 4x 1-hour live events (will be recorded)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":16,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"register","database":"$undefined"},{"id":17,"value":"___\n## Prerequisites\n\nWe'll be doing our lessons in Observable notebooks, so you'll want to have an Observable account ([sign-up](https://observablehq.com/login?screen=signup)), know a little bit about Observable by reading [A Taste of Observable](https://observablehq.com/@observablehq/a-taste-of-observable?collection=@observablehq/getting-started), and if you want to get a head start, you can complete our [quick guides](https://observablehq.com/guide/first-steps) to become more familiar with working with data in Observable.\n_____","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":228,"value":"\n## Connect with other course participants in Slack\nConnect with course participants in the Observable Community Slack. \n\nSign-up [here](https://bit.ly/3f6D2I6) and join the **introduction-to-sql** channel.\n_____","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":18,"value":"## About the Instructor\nPaul Buffa is the Head of Product Education at Observable, with a background in data analysis and teaching. He's spent years building custom data visualization tools and stories on topics such as machine learning, cyber security, education, and health. Prior to Observable, Paul worked at McKinsey and National Geographic to build Covid tracking tools with custom D3 visualizations. Paul is passionate about iterative and ethical design and loves to learn novel ways to visualize data.\n\nConnect: [Observable](https://observablehq.com/@pstuffa) | [LinkedIn](https://www.linkedin.com/in/paul-buffa/) | [Twitter](https://twitter.com/pbbuffa) \n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":19,"value":"banner(\"Interested in learning more about collaborating with data?\", \"Sign up for free\", \"https://observablehq.com/product?utm_medium=social&utm_campaign=sql_course&utm_source=observablehq.com\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"____","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":38,"value":"import {buttonCTA} from \"@observablehq/buttons\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"import {banner} from \"@observablehq/brand-assets-updated-color-2023\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"import {details} from \"@observablehq/callout-boxes\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":41,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W32","stdlib":"1","titling":"auto"}} 30:"$2f:body"