You can find all of the content and slides for Danny Ma's live training SQL and PostgresSQL for Data Analytics held on the O'Reilly platform on the 5th of October 2021!
- 🦊 Katacoda Scenarios
- 📚 Presentation Slides
- 🔥 PostgreSQL Super Quick Cheatsheet
- 🙏 Next Steps
- 😎 About the Author
The accompanying SQL Simplified Katacoda course created by Danny Ma to support this live training is also available on the O'Reilly platform!
- Scenario 1: Basic Data Analysis Techniques
- Scenario 2: Aggregate Functions for Data Analysis
- Scenario 3: Understanding Case When Statements
- Scenario 4: Operating Window Functions
- Scenario 5: Using Table Joins
You can also see the presentation slides for the live training here!
You can also click on the banner below to view Danny's PostgreSQL Super Quick Cheatsheet he's created for this live training.
This cheatsheet is supposed to be used as a super quick reference - it is full of code examples which you can easily copy and paste into your SQL queries!
Thank you for checking out this ! If you enjoyed this live training or you've found this repo on Danny's GitHub - please feel free to share this with your friends and leave a star! ⭐
Here are some ways you can support the author and the Data With Danny team below 🙏
If you're interested in learning valuable data science skills with Danny directly - you can checkout the Data With Danny website for more details!
Join our private student community with over 1,000 data professionals, join a local study group, get help from our team of 12+ data mentors and learn more about our personalized mentorship initiatives!
The 1st part of the Data With Danny program is Serious SQL - if you've enjoyed this live training and the SQL Simplified Katacoda course at O'Reilly, you won't want to miss this course!
Our first live SQL training cohort begins in November 2021 - you can gain all access to course content, recorded videos, our private Discord and more for a one off payment of only $49 - find out more here!
Want to test your SQL skills and tackle 8 realistic SQL case studies and get access to a collection of free SQL learning resources?
Join the Data With Danny 8 Week SQL Challenge for free today!
Solve all 8 realistic SQL case studies designed to simulate real work scenarios and interview questions across multiple analytics domains including customer analytics, digital, banking, retail and subscriptions!
Danny is the Chief Data Mentor at Data With Danny and the Founder & CEO of Sydney Data Science, a boutique data consultancy based out of Sydney, Australia 🇦🇺
After spending the last 10 years working in almost every single role in the data ecosystem, Danny is now focused on solving difficult problems at scale re-imagining data education and recruitment, and mentoring the next generation of data professionals.
He provides specialist data consultancy services:
- Digital customer analytics and experimentation
- Data and machine learning strategy
- Data engineering and systems design
- Team building for analytics and data science functions
- Technical training for practitioners and management
Danny is a regular speaker at global data conferences, meetups and podcasts where he shares the importance of mentorship for all data professionals. He is also a technical author and instructor for O'Reilly.
Danny believes that he is living proof that dispels the myth that you need higher level education to be successful in the data science space, and he wants to share his experiences with others so they can do the same.
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent